1 insert into admin_h2
VALUES (2,6,'Newsletter',30);
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);
8 -- Table structure for table `newsletter`
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,
18 ) TYPE=MyISAM
COMMENT='liste des NL envoyes';
21 -- Table structure for table `newsletter_art`
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`
)
36 -- Table structure for table `newsletter_cat`
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 '',
48 -- Table structure for table `newsletter_ins`
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`
),
57 ) TYPE=MyISAM
COMMENT='liste des abonnés à la newsletter';