Commit | Line | Data |
---|---|---|
01e84d69 JL |
1 | # |
2 | # Table structure for table `dep` | |
3 | # | |
4 | ||
5 | CREATE TABLE dep ( | |
6 | id int(8) NOT NULL auto_increment, | |
7 | dir int(6) NOT NULL default '0', | |
8 | page int(6) NOT NULL default '0', | |
9 | dep int(6) NOT NULL default '0', | |
10 | type enum('include','image','link') NOT NULL default 'include', | |
11 | PRIMARY KEY (id) | |
12 | ) TYPE=MyISAM; | |
13 | # -------------------------------------------------------- | |
14 | ||
15 | # | |
16 | # Table structure for table `dir` | |
17 | # | |
18 | ||
19 | CREATE TABLE dir ( | |
20 | id int(6) NOT NULL auto_increment, | |
21 | path varchar(255) NOT NULL default '', | |
22 | PRIMARY KEY (id), | |
23 | UNIQUE KEY path (path) | |
24 | ) TYPE=MyISAM; | |
25 | # -------------------------------------------------------- | |
26 | ||
27 | # | |
28 | # Table structure for table `file` | |
29 | # | |
30 | ||
31 | CREATE TABLE file ( | |
32 | id int(6) NOT NULL auto_increment, | |
33 | path varchar(255) NOT NULL default '', | |
34 | type enum('dead','page','include','image') NOT NULL default 'dead', | |
35 | dir int(6) NOT NULL default '0', | |
36 | PRIMARY KEY (id), | |
37 | UNIQUE KEY path (path) | |
38 | ) TYPE=MyISAM; | |
39 |