WJfvdveS

1CREATE  TABLE IF NOT EXISTS `city` (
2  `id` INT NOT NULL AUTO_INCREMENT ,
3  `cityname` VARCHAR(255) NOT NULL ,
4  `cityalias` VARCHAR(45) NULL ,
5  PRIMARY KEY (`id`) )
6ENGINE = MyISAM DEFAULT CHARSET=UTF8;
7
8CREATE  TABLE IF NOT EXISTS `street` (
9  `id` INT NOT NULL AUTO_INCREMENT ,
10  `cityid` INT NOT NULL ,
11  `streetname` VARCHAR(255) NOT NULL ,
12  `streetalias` VARCHAR(45) NULL ,
13  PRIMARY KEY (`id`) )
14ENGINE = MyISAM DEFAULT CHARSET=UTF8;
15
16CREATE  TABLE IF NOT EXISTS `build` (
17  `id` INT NOT NULL AUTO_INCREMENT ,
18  `streetid` INT NOT NULL ,
19  `buildnum` VARCHAR(10) NOT NULL ,
20  PRIMARY KEY (`id`) )
21ENGINE = MyISAM DEFAULT CHARSET=UTF8;
22
23CREATE  TABLE IF NOT EXISTS `apt` (
24  `id` INT NOT NULL AUTO_INCREMENT ,
25  `buildid` INT NOT NULL ,
26  `entrance` VARCHAR(15) NULL ,
27  `floor` VARCHAR(15) NULL ,
28  `apt` VARCHAR(5) NULL ,
29  PRIMARY KEY (`id`) )
30ENGINE = MyISAM DEFAULT CHARSET=UTF8;
31
32CREATE  TABLE IF NOT EXISTS `address` (
33`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
34`login` VARCHAR( 45 ) NOT NULL ,
35`aptid` INT NOT NULL
36) ENGINE = MYISAM  DEFAULT CHARSET=UTF8;