mYCEZhjk

1DROP DATABASE IF EXISTS erlent_av31;
2CREATE DATABASE IF NOT EXISTS erlent_av31;
3USE erlent_av31;
4
5CREATE TABLE `andmed` (
6	`a_ID` INT NOT NULL AUTO_INCREMENT,
7	`eesnimi` varchar(25) NOT NULL DEFAULT 'Tundmatu',
8	`perenimi` varchar(25) NOT NULL DEFAULT 'Tundmatu',
9	`isikukood` varchar(11) NOT NULL DEFAULT '00000000000',
10	`kursus` varchar(50) NOT NULL DEFAULT 'Tundmatu',
11	PRIMARY KEY (`a_ID`)
12);
13
14CREATE TABLE `uhendus` (
15	`andmed_id` INT NOT NULL,
16	`info_id` INT NOT NULL
17);
18
19CREATE TABLE `info` ( #tellimus
20	`i_ID` INT NOT NULL AUTO_INCREMENT,
21	`hinne` int(3) NOT NULL DEFAULT '1',
22	`selgitus` varchar(500) NOT NULL DEFAULT 'Pole selgitust',
23	PRIMARY KEY (`i_ID`)
24);
25
26ALTER TABLE `uhendus` ADD CONSTRAINT `uhendus_fk0` FOREIGN KEY (`andmed_id`) REFERENCES `andmed`(`a_ID`);
27
28ALTER TABLE `uhendus` ADD CONSTRAINT `uhendus_fk1` FOREIGN KEY (`info_id`) REFERENCES `info`(`i_ID`);