"latin4" - 1 õppematerjal

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,