CTnavBQV

1— —-
2— Globals
3— —-
4
5— SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
6— SET FOREIGN_KEY_CHECKS=0;
7
8— —-
9— Table 'Customers'
10— 
11— —-
12
13DROP TABLE IF EXISTS `Customers`;
14
15CREATE TABLE `Customers` (
16`customer_id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
17`customer_name` MEDIUMTEXT NULL DEFAULT NULL COMMENT 'alknfklmsdf',
18`customer_login` MEDIUMTEXT NULL DEFAULT NULL COMMENT 'sadjkafnkjsdn',
19`customer_password` INTEGER NULL DEFAULT NULL COMMENT 'askmd',
20`customer_adress` MEDIUMTEXT NULL DEFAULT NULL,
21PRIMARY KEY (`customer_id`)
22);
23
24— —-
25— Table 'Customer_orders'
26— 
27— —-
28
29DROP TABLE IF EXISTS `Customer_orders`;
30
31CREATE TABLE `Customer_orders` (
32`order_id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
33`customer_id` INTEGER NULL DEFAULT NULL,
34`order_status_code` INTEGER NULL DEFAULT NULL,
35`data_order_placed` DATE NULL DEFAULT NULL,
36`data_order_completed` DATE NULL DEFAULT NULL,
37PRIMARY KEY (`order_id`)
38);
39
40— —-
41— Table 'Order_Items'
42— 
43— —-
44
45DROP TABLE IF EXISTS `Order_Items`;
46
47CREATE TABLE `Order_Items` (
48`order_item_id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
49`order_id` INTEGER NULL DEFAULT NULL,
50`game_id` INTEGER NULL DEFAULT NULL,
51`data_item_delivered` INTEGER NULL DEFAULT NULL,
52`product_type_code` INTEGER NULL DEFAULT NULL,
53PRIMARY KEY (`order_item_id`)
54);
55
56— —-
57— Table 'Games'
58— 
59— —-
60
61DROP TABLE IF EXISTS `Games`;
62
63CREATE TABLE `Games` (
64`game_id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
65`game_name` MEDIUMTEXT NULL DEFAULT NULL,
66`developer` INTEGER NULL DEFAULT NULL,
67`genre` MEDIUMTEXT NULL DEFAULT NULL,
68`description` MEDIUMTEXT NULL DEFAULT NULL,
69`price` INTEGER NULL DEFAULT NULL,
70`platform` MEDIUMTEXT NULL DEFAULT 'pc',
71PRIMARY KEY (`game_id`)
72);
73
74— —-
75— Table 'Developers'
76— 
77— —-
78
79DROP TABLE IF EXISTS `Developers`;
80
81CREATE TABLE `Developers` (
82`developer` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
83`info` MEDIUMTEXT NOT NULL DEFAULT '0',
84PRIMARY KEY (`developer`)
85);
86
87— —-
88— Foreign Keys 
89— —-
90
91ALTER TABLE `Customer_orders` ADD FOREIGN KEY (customer_id) REFERENCES `Customers` (`customer_id`);
92ALTER TABLE `Order_Items` ADD FOREIGN KEY (order_id) REFERENCES `Customer_orders` (`order_id`);
93ALTER TABLE `Order_Items` ADD FOREIGN KEY (game_id) REFERENCES `Games` (`game_id`);
94ALTER TABLE `Games` ADD FOREIGN KEY (developer) REFERENCES `Developers` (`developer`);
95
96— —-
97— Table Properties
98— —-
99
100— ALTER TABLE `Customers` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
101— ALTER TABLE `Customer_orders` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
102— ALTER TABLE `Order_Items` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
103— ALTER TABLE `Games` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
104— ALTER TABLE `Developers` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
105
106— —-
107— Test Data
108— —-
109
110— INSERT INTO `Customers` (`customer_id`,`customer_name`,`customer_login`,`customer_password`,`customer_adress`) VALUES
111— ('','','','','');
112— INSERT INTO `Customer_orders` (`order_id`,`customer_id`,`order_status_code`,`data_order_placed`,`data_order_completed`) VALUES
113— ('','','','','');
114— INSERT INTO `Order_Items` (`order_item_id`,`order_id`,`game_id`,`data_item_delivered`,`product_type_code`) VALUES
115— ('','','','','');
116— INSERT INTO `Games` (`game_id`,`game_name`,`developer`,`genre`,`description`,`price`,`platform`) VALUES
117— ('','','','','','','');
118— INSERT INTO `Developers` (`developer`,`info`) VALUES
119— ('','');