F728hRwE

1-- ---
2-- Globals
3-- ---
4
5-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
6-- SET FOREIGN_KEY_CHECKS=0;
7
8-- ---
9-- Table 'products'
10-- Tabela zawierajaca promocje
11-- ---
12
13DROP TABLE IF EXISTS `products`;
14		
15CREATE TABLE `products` (
16  `id` INT(12) NOT NULL AUTO_INCREMENT COMMENT 'ID promocji',
17  `name` VARCHAR(256) NOT NULL COMMENT 'Nazwa promocji',
18  `img_url` VARCHAR(256) NOT NULL COMMENT 'Url obrazka promocji',
19  `price` DECIMAL(9, 2) NOT NULL,
20  `shop_id` INT(12) NOT NULL COMMENT 'ID sklepu',
21  `category_id` INT(12) NOT NULL COMMENT 'ID kategorii',
22  `starts_on` VARCHAR(128) NOT NULL COMMENT 'Data startu promocji, format YYYY.MM.DD',
23  `ends_on` VARCHAR(128) NOT NULL DEFAULT 'NOT NULL' COMMENT 'Data końca promocji, format YYYY.MM.DD',
24  `created_on` VARCHAR(128) NOT NULL COMMENT 'Data stworzenia promocji, format YYYY.MM.DD',
25  `to_show` ENUM('Y', 'N') NOT NULL DEFAULT 'Y' COMMENT 'Czy promocja jest do wyświetlenia użytkownikom, Y - tak, N -',
26  `created_by` INT(12) NOT NULL COMMENT 'Stworzone przez',
27  PRIMARY KEY (`id`)
28) COMMENT 'Tabela zawierajaca promocje';
29
30-- ---
31-- Table 'categories'
32-- Tabela z kategoriami
33-- ---
34
35DROP TABLE IF EXISTS `categories`;
36		
37CREATE TABLE `categories` (
38  `id` INT(12) NOT NULL AUTO_INCREMENT COMMENT 'ID kategorii',
39  `name` VARCHAR(256) NOT NULL COMMENT 'Nazwa kategorii',
40  PRIMARY KEY (`id`)
41) COMMENT 'Tabela z kategoriami';
42
43-- ---
44-- Table 'shops'
45-- Tabela sklepow
46-- ---
47
48DROP TABLE IF EXISTS `shops`;
49		
50CREATE TABLE `shops` (
51  `id` INT(12) NOT NULL AUTO_INCREMENT COMMENT 'ID sklepu',
52  `name` VARCHAR(256) NOT NULL COMMENT 'Nazwa sklepu',
53  `img_url` VARCHAR(256) NOT NULL COMMENT 'Url obrazka sklepu',
54  PRIMARY KEY (`id`)
55) COMMENT 'Tabela sklepow';
56
57-- ---
58-- Table 'users'
59-- Tabela adminow
60-- ---
61
62DROP TABLE IF EXISTS `users`;
63		
64CREATE TABLE `users` (
65  `id` INT(12) NOT NULL AUTO_INCREMENT,
66  `name` VARCHAR(128) NOT NULL COMMENT 'Login',
67  `password` VARCHAR(128) NOT NULL COMMENT 'Haslo',
68  `img_url` VARCHAR(258) NOT NULL COMMENT 'Url obrazka profilowego',
69  PRIMARY KEY (`id`)
70) COMMENT 'Tabela adminow';
71
72-- ---
73-- Foreign Keys 
74-- ---
75
76ALTER TABLE `products` ADD FOREIGN KEY (shop_id) REFERENCES `shops` (`id`);
77ALTER TABLE `products` ADD FOREIGN KEY (category_id) REFERENCES `categories` (`id`);
78ALTER TABLE `products` ADD FOREIGN KEY (created_by) REFERENCES `users` (`id`);
79
80-- ---
81-- Table Properties
82-- ---
83
84-- ALTER TABLE `products` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
85-- ALTER TABLE `categories` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
86-- ALTER TABLE `shops` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
87-- ALTER TABLE `users` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
88
89-- ---
90-- Test Data
91-- ---
92
93-- INSERT INTO `products` (`id`,`name`,`img_url`,`price`,`shop_id`,`category_id`,`starts_on`,`ends_on`,`created_on`,`to_show`,`created_by`) VALUES
94-- ('','','','','','','','','','','');
95-- INSERT INTO `categories` (`id`,`name`) VALUES
96-- ('','');
97-- INSERT INTO `shops` (`id`,`name`,`img_url`) VALUES
98-- ('','','');
99-- INSERT INTO `users` (`id`,`name`,`password`,`img_url`) VALUES
100-- ('','','','');