CREATE TABLE `roles` (
  `id_role` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `is_admin` TINYINT(1) UNSIGNED NOT NULL,
  `is_deleted` TINYINT(1) UNSIGNED NOT NULL,
  PRIMARY KEY (`id_role`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;

CREATE TABLE `users` (
  `id_user` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_role` INTEGER(10) UNSIGNED NOT NULL,
  `login` VARCHAR(100) NOT NULL,
  `password` VARCHAR(100) NOT NULL,
  `email` VARCHAR(100),
  `name` VARCHAR(50) NOT NULL,
  `name2` VARCHAR(100) NOT NULL,
  `is_deleted` TINYINT(1) UNSIGNED NOT NULL,
  PRIMARY KEY (`id_user`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;

INSERT INTO roles(id_role, name, is_admin, is_deleted) values(1, 'Administrator', 1, 0);
INSERT INTO roles(id_role, name, is_admin, is_deleted) values(2, 'User', 0, 0);
INSERT INTO users (id_user, id_role, login, password, email, name, name2, is_deleted) VALUES(1, 1, 'admin', 'passw0rd_a', 'oksztul@gmail.com', 'Rafał', 'Oksztulski', 0);

CREATE TABLE `main_page` (
  `id` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `description` TEXT NOT NULL,
  `meta_keywords` TEXT NOT NULL,
  `meta_description` TEXT NOT NULL,
  `is_deleted` TINYINT(1) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;

INSERT INTO main_page(id,description,meta_keywords,meta_description,is_deleted) VALUES(1,'Tutaj zamiesc informacje o firmie...','Antyki','Antyki',0);

CREATE TABLE `media` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`picture_url` VARCHAR( 200 ) NOT NULL ,
`width` VARCHAR( 20 ) NOT NULL ,
`height` VARCHAR( 20 ) NOT NULL ,
`is_active` TINYINT( 1 ) UNSIGNED NOT NULL
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;

CREATE TABLE `contact` (
  `id` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `description` TEXT NOT NULL,
  `meta_keywords` TEXT NOT NULL,
  `meta_description` TEXT NOT NULL,
  `is_deleted` TINYINT(1) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;

INSERT INTO contact(id,description,meta_keywords,meta_description,is_deleted) VALUES(1,'Tutaj zamiesc informacje o kontakcie...','Antyki','Antyki',0);

ALTER TABLE `main_page` ADD COLUMN `title` TEXT NOT NULL AFTER `id`;

CREATE TABLE `offer` (
  `id` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `description` TEXT NOT NULL,
  `title` TEXT NOT NULL,
  `meta_keywords` TEXT NOT NULL,
  `meta_description` TEXT NOT NULL,
  `is_deleted` TINYINT(1) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;

CREATE TABLE `pictures` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`offer_id` INT(10) UNSIGNED NOT NULL,
`position` INT(10) NOT NULL,
`picture_url` VARCHAR(200) NOT NULL,
`is_active` TINYINT(1) NOT NULL,
`thumbnail_url` VARCHAR(200) NOT NULL,
PRIMARY KEY(`id`)
) ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_polish_ci;