ctqj2Tgm

1create table if not exists types (
2    id int(10) not null auto_increment,
3    name varchar(20) not null default "Pessoa Jurídica";
4    primary key(id)
5) engine = innodb;
6
7create table if not exists customers (
8    id int(10) not null auto_increment,
9    type_id int(10) not null,
10    name varchar(255) not null,
11    primary key(id),
12    foreign key(type_id) references types(id)
13) engine = innodb;
14
15create table if not exists categories (
16    id int(10) not null auto_increment,
17    name varchar(255) not null,
18    primary key(id)
19) engine = innodb;
20
21create table if not exists states (
22    id int(10) not null auto_increment,
23    name varchar(25) not null,
24    acronym varchar(2) not null,
25    primary key(id)
26) engine = innodb;
27
28create table if not exists neighborhoods (
29    id int(10) not null auto_increment,
30    name varchar(50) not null,
31    primary key(id)
32) engine = innodb;
33
34create table if not exists addresses (
35    id int(10) not null auto_increment,
36    street varchar(255) not null,
37    number varchar(10) not null default 's/n',
38    phone1 varchar(15) null,
39    phone2 varchar(15) null,
40    cep varchar(8) not null,
41    neighborhood_id int(10) not null,
42    city varchar(100) not null default 'Manaus',
43    state_id int(10) not null,
44    primary key(id),
45    foreign key(neighborhood_id) references neighborhoods(id),
46    foreign key(state_id) references states(id)
47) engine = innodb;