0337d704 |
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 | |