### bännerite tabel ###

CREATE TABLE `banner` (
`banner_id` INT( 100 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`banner_name` VARCHAR( 200 ) NULL ,
`banner_location` VARCHAR( 200 ) NOT NULL ,
`banner_active` VARCHAR( 200 ) NOT NULL 
) ENGINE = MYISAM ;


### Kasutajate tabel ###


CREATE TABLE `users` (
`user_id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`user_username` VARCHAR( 200 ) NOT NULL ,
`user_firstname` VARCHAR( 100 ) NOT NULL ,
`user_lastname` VARCHAR( 100 ) NOT NULL ,
`user_pass` VARCHAR( 255 ) NOT NULL ,
`user_email` VARCHAR( 200 ) NOT NULL ,
`user_active` INT( 1 ) NOT NULL DEFAULT '1'
) ENGINE = MYISAM ;