0337d704 |
1 | alter table auth_user_quick add column banana_last timestamp not null; |
2 | |
3 | -- |
4 | -- Table structure for table `abos` |
5 | -- |
6 | |
7 | CREATE TABLE banana_abos ( |
8 | fid tinyint(3) unsigned NOT NULL default '0', |
9 | uid smallint(5) unsigned NOT NULL default '0', |
10 | PRIMARY KEY (fid,uid) |
11 | ) TYPE=MyISAM COMMENT='abonnements aux forums'; |
12 | |
13 | -- |
14 | -- Table structure for table `list` |
15 | -- |
16 | |
17 | CREATE TABLE banana_list ( |
18 | fid tinyint(3) unsigned NOT NULL auto_increment, |
19 | nom varchar(40) NOT NULL default '', |
20 | PRIMARY KEY (fid) |
21 | ) TYPE=MyISAM COMMENT='liste des fora'; |
22 | |
23 | -- |
24 | -- Table structure for table `profils` |
25 | -- |
26 | |
27 | CREATE TABLE banana_profils ( |
28 | uid smallint(5) unsigned NOT NULL default '0', |
29 | nom varchar(50) NOT NULL default '', |
30 | mail varchar(70) NOT NULL default '', |
31 | sig tinytext NOT NULL, |
32 | flags set('threads','automaj') NOT NULL default '', |
33 | PRIMARY KEY (uid) |
34 | ) TYPE=MyISAM; |
35 | |
36 | -- |
37 | -- Table structure for table `respofaqs` |
38 | -- |
39 | |
40 | CREATE TABLE banana_respofaqs ( |
41 | fid tinyint(3) unsigned NOT NULL default '0', |
42 | uid smallint(5) unsigned NOT NULL default '0', |
43 | PRIMARY KEY (fid,uid) |
44 | ) TYPE=MyISAM COMMENT='responsables des FAQs'; |
45 | |