SQL
CREATE DATABASE `Lennundus` DEFAULT CHARACTER SET latin4 COLLATE
latin4_estonian_ci;
USE `Lennundus`;
CREATE TABLE IF NOT EXISTS `tlised` (
`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 `tleping` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`lepingu_nr` INT (5) NOT NULL,
`algus` DATETIME (16) NOT NULL,
`lpp` DATETIME(16) NULL,
`tlised_id` INT(11) NOT NULL,
FOREIGN KEY (`tlised_id`) REFERENCES tlised(id),
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `sisselogimine` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`algusaeg` DATETIME(16) NOT NULL,
`lppaeg` DATETIME(16) NULL,
`tlised_id` INT(11) NOT NULL,
FOREIGN KEY (`tlised_id`) REFERENCES tlised(id),
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `kassa` (
`id` INT(4) NOT NULL AUTO_INCREMENT,
...
annaabi.ee 
