create table if not exists category id int 11 not null auto_increment

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
create table if not exists `category` (
`id` int(11) not null auto_increment,
`name` varchar(255) not null,
primary key (`id`),
key `id` (`id`)
) engine = myisam default charset = utf8 auto_increment = 1;
create table if not exists `sub_category` (
`id` int(11) not null auto_increment,
`name` varchar(255) not null,
primary key (`id`),
key `id` (`id`)
) engine = myisam default charset = utf8 auto_increment = 1;
create table if not exists `conecting` (
`id` int(11) not null auto_increment,
`cat_id` int(11) not null,
`sub_id` int(11) not null,
primary key (`id`),
key `id` (`id`)
) engine = myisam default charset = utf8 auto_increment = 1;