install.d/banana/install.sql

   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