install.d/newsletter/install.sql

   1 insert into admin_h2 VALUES (2,6,'Newsletter',30);
   2
   3 INSERT INTO admin_a VALUES (6,'Liste','admin/newsletter.php',0);
   4 INSERT INTO admin_a VALUES (6,'Catégories','admin/newsletter_cats.php',10);
   5 INSERT INTO admin_a VALUES (6,'Adresses en panne','admin/newsletter_pattecassee.php',20);
   6
   7 --
   8 -- Table structure for table `newsletter`
   9 --
  10
  11 CREATE TABLE `newsletter` (
  12   `id` int(11) NOT NULL auto_increment,
  13   `date` date NOT NULL default '0000-00-00',
  14   `titre` varchar(255) NOT NULL default '',
  15   `bits` enum('sent','new') NOT NULL default 'new',
  16   `head` mediumtext NOT NULL,
  17   PRIMARY KEY  (`id`)
  18 ) TYPE=MyISAM COMMENT='liste des NL envoyes';
  19
  20 --
  21 -- Table structure for table `newsletter_art`
  22 --
  23
  24 CREATE TABLE `newsletter_art` (
  25   `id` int(10) unsigned NOT NULL default '0',
  26   `aid` smallint(5) unsigned NOT NULL default '0',
  27   `cid` smallint(5) unsigned NOT NULL default '0',
  28   `pos` tinyint(3) unsigned NOT NULL default '0',
  29   `title` mediumtext NOT NULL,
  30   `body` mediumtext NOT NULL,
  31   `append` mediumtext NOT NULL,
  32   PRIMARY KEY  (`id`,`aid`)
  33 ) TYPE=MyISAM;
  34
  35 --
  36 -- Table structure for table `newsletter_cat`
  37 --
  38
  39 CREATE TABLE `newsletter_cat` (
  40   `cid` tinyint(3) unsigned NOT NULL auto_increment,
  41   `pos` tinyint(3) unsigned NOT NULL default '0',
  42   `titre` varchar(128) NOT NULL default '',
  43   PRIMARY KEY  (`cid`),
  44   KEY `pos` (`pos`)
  45 ) TYPE=MyISAM;
  46
  47 --
  48 -- Table structure for table `newsletter_ins`
  49 --
  50
  51 CREATE TABLE `newsletter_ins` (
  52   `user_id` smallint(4) unsigned NOT NULL default '0',
  53   `last` int(11) NOT NULL default '0',
  54   `pref` enum('text','html') NOT NULL default 'html',
  55   PRIMARY KEY  (`user_id`),
  56   KEY `last` (`last`)
  57 ) TYPE=MyISAM COMMENT='liste des abonnés à la newsletter';
  58