SQL (0)

CREATE DATABASE ` Lennundus ` DEFAULT CHARACTER SET latin4 COLLATE latin4_estonian_ci; USE `Lennundus`; CREATE TABLE IF NOT EXISTS `t��lised` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `Eesnimi`VARCHAR(25) NOT NULL, `Perenimi`VARCHAR(25) NOT NULL, `IK` CHAR (12) UNIQUE NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `t��leping` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `lepingu_nr` INT (5) NOT NULL, `algus` DATETIME (16) NOT NULL, `l�pp` DATETIME(16) NULL, `t��lised_id` INT(11) NOT NULL, FOREIGN KEY (`t��lised_id`) REFERENCES t��lised(id), PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS ` sisselogimine ` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `algusaeg` DATETIME(16) NOT NULL, `l�ppaeg` DATETIME(16) NULL, `t��lised_id` INT(11) NOT NULL, FOREIGN KEY (`t��lised_id`) REFERENCES t��lised(id), PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS ` kassa ` ( `id` INT(4) NOT NULL AUTO_INCREMENT, `kassa_nr` (4) NOT NULL, `sisselogimine_id`INT(11) NOT NULL, FOREIGN KEY (`sisselogimine_id`) REFERENCES sisselogimine(id), PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS ` klient ` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `eesnimi` CHAR(28) NOT NULL, `perenimi` CHAR(28) NOT NULL, `IK` CHAR (12) UNIQUE NOT NULL, `ettev�tte_nimi` VARCHAR(28) NULL, `Aadress`VARCHAR(40) NOT NULL, `Tel_nr` VARCHAR(20) NULL, PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `maksev� imalus ` ( `id` INT(4) NOT NULL AUTO_INCREMENT, `maksev�imaluse_t��p` VARCHAR(30) UNIQUE NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `Tellimus` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `tellimuse_nr` INT(25) NOT NULL, `tellitud_kaup` VARCHAR(30) NULL, PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `soodustused` ( `id` INT(4) NOT NULL AUTO_INCREMENT, `soodustuse_t��p` VAR CHAR(30) UNIQUE NOT NULL, `soodustuse protsent`INT(3) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `kaup` ( `id` INT(4) NOT NULL AUTO_INCREMENT, `kaubanimetus` VARCHAR(40) UNIQUE NOT NULL, `hind` INT(15) NOT NULL, `kogus` INT(16) NULL, `tellimus_id` INT(11) NOT NULL, `soodustused_id` INT(4) NOT NULL, FOREIGN KEY(`tellimus_id`) REFERENCES tellimus(id), FOREIGN KEY(`soodustused_id`) REFERENCES soodustused(id), PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `m��k` ( `id` INT(4) NOT NULL AUTO_INCREMENT, `aeg` DATETIME (16) NULL, `t�ekk_id` INT(11) NOT NULL, `kaup_id` INT(4) NOT NULL, FOREIGN KEY(`kaup_id`) REFERENCES kaup(id), FOREIGN KEY(`t�ekk_id`) REFERENCES t�ekk(id), PRIMARY KEY (`id`) ) CREATE TABLE IF NOT EXISTS `t�ekk` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `t�eki_nr` INT(11) NOT NULL, `kuup�ev` DATETIME(16) NOT NULL, `m��ja` INT(11) NOT NULL, `kassa_id` INT (4) NOT NULL, `klient_id` INT (11) NOT NULL, `maksev�imalus_id` INT(4) NOT NULL, FOREIGN KEY('m��ja') REFERENCES t��lised(id), FOREIGN KEY('kassa_id') REFERENCES kassa(id), FOREIGN KEY('klient_id') REFERENCES klient(id), FOREIGN KEY('maksev�imalus_id') REFERENCES maksev�imalus(id), PRIMARY KEY (`id`) )