XqPsQRh4

1DROP DATABASE IF EXISTS `rain-av31`;
2CREATE DATABASE `rain-av31`;
3USE DATABASE `rain-av31`;
4 
5CREATE TABLE `Tooted` (
6    ID INT NOT NULL AUTO_INCREMENT,
7    Tootekood varchar(16) NOT NULL DEFAULT "PEC",
8    Tootenimetus varchar(64) NOT NULL DEFAULT "ASD",
9    Kogus INT NOT NULL DEFAULT -1,
10    Kaal INT NOT NULL DEFAULT -1,
11    Hind decimal(7,2) NOT NULL DEFAULT -1,
12    Kuupäev DATE NOT NULL DEFAULT "2005-05-05",
13    PRIMARY KEY (ID)
14);
15 
16CREATE TABLE `Tootjad` (
17    ID INT NOT NULL AUTO_INCREMENT,
18    Tootjanimi varchar(32) NOT NULL DEFAULT "ASD",
19    Aadress varchar(64) NOT NULL DEFAULT "ASD",
20    Telefon INT NOT NULL DEFAULT 51234567
21    PRIMARY KEY (ID)