714ed73b51afe7e333d5f83b49b3eae54b7aaeab
1 alter table auth_user_quick
add column banana_last
timestamp not null;
4 -- Table structure for table `abos`
7 CREATE TABLE banana_abos (
8 fid
tinyint(3) unsigned
NOT NULL default '0',
9 uid
smallint(5) unsigned
NOT NULL default '0',
11 ) TYPE=MyISAM
COMMENT='abonnements aux forums';
14 -- Table structure for table `list`
17 CREATE TABLE banana_list (
18 fid
tinyint(3) unsigned
NOT NULL auto_increment
,
19 nom
varchar(40) NOT NULL default '',
21 ) TYPE=MyISAM
COMMENT='liste des fora';
24 -- Table structure for table `profils`
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 '',
37 -- Table structure for table `respofaqs`
40 CREATE TABLE banana_respofaqs (
41 fid
tinyint(3) unsigned
NOT NULL default '0',
42 uid
smallint(5) unsigned
NOT NULL default '0',
44 ) TYPE=MyISAM
COMMENT='responsables des FAQs';