modules/enewsletter/enewsletter.sql

-- MySQL Dump

-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_allowed`
-- 

CREATE TABLE `enewsletter_allowed` (
  `enewsletter_id` int(10) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_bounce_count`
-- 

CREATE TABLE `enewsletter_bounce_count` (
  `email` varchar(100) NOT NULL default '',
  `bounces` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_bounce_record`
-- 

CREATE TABLE `enewsletter_bounce_record` (
  `bid` int(10) NOT NULL auto_increment,
  `message_id` int(10) NOT NULL default '0',
  `newsletter_id` int(10) NOT NULL default '0',
  `date` int(10) NOT NULL default '0',
  `user_id` int(10) NOT NULL default '0',
  `address` varchar(150) NOT NULL default '',
  UNIQUE KEY `bid` (`bid`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_bounce_store`
-- 

CREATE TABLE `enewsletter_bounce_store` (
  `bounce_id` int(10) NOT NULL default '0',
  `header` longtext NOT NULL,
  `headerinfo` longtext NOT NULL,
  `body` longtext NOT NULL,
  `received` int(11) NOT NULL default '0',
  UNIQUE KEY `bounce_id` (`bounce_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_config`
-- 

CREATE TABLE `enewsletter_config` (
  `variable` varchar(25) NOT NULL default '0',
  `value` varchar(250) NOT NULL default '0'
) TYPE=MyISAM;


-- 
-- Dumping data for table `enewsletter_config`
-- 

INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('maximum', '10');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('delay', '2');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('from_address', '');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('reply_address', '');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_addresss', '');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('set_return_path', '1');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('send_maximum', '50');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('send_delay', '2');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_connection', '0');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_host', '');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_port', '110/pop3/notls');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_user', '');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_password', '');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_max_process', '25');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_store_processed', '2');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_limit', '2');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('loggin', '0');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('announce_optional_msg', 'Receive announcement messages from this website by email');
INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('announce_auto_msg', 'Announcement messages from this website will be sent to you by email');

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_newsletters`
-- 

CREATE TABLE `enewsletter_newsletters` (
  `enewsletter_id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(128) NOT NULL default '',
  `description` varchar(128) NOT NULL default '',
  `track` int(2) NOT NULL default '0',
  `template_text` int(10) NOT NULL default '0',
  `template_html` int(10) NOT NULL default '0',
  `start` int(11) NOT NULL default '0',
  `first` int(11) NOT NULL default '0',
  `next` int(11) NOT NULL default '0',
  `last` int(11) NOT NULL default '0',
  `que` int(10) NOT NULL default '0',
  `every` int(3) NOT NULL default '0',
  `frequency` varchar(6) NOT NULL default '0',
  PRIMARY KEY  (`enewsletter_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `enewsletter_newsletters`
-- 
INSERT INTO `enewsletter_newsletters` VALUES (NULL, 'announcements', 'Announcement messages from this website will be sent to you by email', 0, 1, 2, 915148800, 0, 0, 0, 0, 0, 'manual');
  

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_nodes`
-- 

CREATE TABLE `enewsletter_nodes` (
  `nid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`nid`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_selected`
-- 

CREATE TABLE `enewsletter_selected` (
  `enewsletter_id` int(10) unsigned NOT NULL default '0',
  `tid` int(10) NOT NULL default '0',
  `uid` int(10) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_sent`
-- 

CREATE TABLE `enewsletter_sent` (
  `enewsletter_id` int(10) NOT NULL default '0',
  `uid` int(10) NOT NULL default '0',
  `pub_time` int(11) NOT NULL default '0',
  `sent` int(11) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_subscribers`
-- 

CREATE TABLE `enewsletter_subscribers` (
  `uid` int(10) NOT NULL default '0',
  `lid` varchar(8) NOT NULL default '',
  UNIQUE KEY `lid` (`lid`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_subscriptions`
-- 

CREATE TABLE `enewsletter_subscriptions` (
  `uid` int(10) unsigned NOT NULL default '0',
  `enewsletter_id` int(10) NOT NULL default '0',
  `format` varchar(4) NOT NULL default 'text',
  `subscribed` int(11) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `enewsletter_templates`
-- 

CREATE TABLE `enewsletter_templates` (
  `template_id` int(10) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `template` longtext NOT NULL,
  `type` char(2) NOT NULL default '0',
  `format` int(4) NOT NULL default '0',
  PRIMARY KEY  (`template_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `enewsletter_templates`
-- 
INSERT INTO enewsletter_templates (template_id, name, template, type) VALUES (1, 'announcement', '', '0');
INSERT INTO enewsletter_templates (template_id, name, template, type) VALUES (2, 'announcement HTML', '', '1');
INSERT INTO enewsletter_templates VALUES (3, 'default', '<p>Dear $username,<br />\r\nin the latest issue of $publication_title.</p>\r\n<br />\r\n\r\n$nodes\r\n\r\n<hr>\r\n\r\n<p>\r\nUpdate your details:<br />\r\n    $update_link<br />\r\nUnsubscribe:<br />\r\n    $unsubscribe_link<br />\r\n</p>\r\n\r\n<hr>', '0', 1);
INSERT INTO enewsletter_templates VALUES (4, 'default HTML', '<p>Dear $username,<br />\r\nin the latest issue of $publication_title.</p>\r\n<br />\r\n\r\n<div class="content">\r\n$nodes\r\n</div>\r\n\r\n\r\n<div class="controls">\r\n<hr>\r\n\r\n<p>\r\nUpdate your details: <a href="$update_link">Update</a><br />\r\nUnsubscribe: <a href="$unsubscribe_link">Unsubscribe</a>\r\n</p>\r\n\r\n<hr>\r\n</div>', '1', 1);

1	-- MySQL Dump
2
3	--
4
5	-- --------------------------------------------------------
6
7	--
8	-- Table structure for table `enewsletter_allowed`
9	--
10
11	CREATE TABLE `enewsletter_allowed` (
12	`enewsletter_id` int(10) unsigned NOT NULL default '0',
13	`tid` int(10) unsigned NOT NULL default '0'
14	) TYPE=MyISAM;
15
16	-- --------------------------------------------------------
17
18	--
19	-- Table structure for table `enewsletter_bounce_count`
20	--
21
22	CREATE TABLE `enewsletter_bounce_count` (
23	`email` varchar(100) NOT NULL default '',
24	`bounces` tinyint(4) NOT NULL default '0'
25	) TYPE=MyISAM;
26
27	-- --------------------------------------------------------
28
29	--
30	-- Table structure for table `enewsletter_bounce_record`
31	--
32
33	CREATE TABLE `enewsletter_bounce_record` (
34	`bid` int(10) NOT NULL auto_increment,
35	`message_id` int(10) NOT NULL default '0',
36	`newsletter_id` int(10) NOT NULL default '0',
37	`date` int(10) NOT NULL default '0',
38	`user_id` int(10) NOT NULL default '0',
39	`address` varchar(150) NOT NULL default '',
40	UNIQUE KEY `bid` (`bid`)
41	) TYPE=MyISAM;
42
43	-- --------------------------------------------------------
44
45	--
46	-- Table structure for table `enewsletter_bounce_store`
47	--
48
49	CREATE TABLE `enewsletter_bounce_store` (
50	`bounce_id` int(10) NOT NULL default '0',
51	`header` longtext NOT NULL,
52	`headerinfo` longtext NOT NULL,
53	`body` longtext NOT NULL,
54	`received` int(11) NOT NULL default '0',
55	UNIQUE KEY `bounce_id` (`bounce_id`)
56	) TYPE=MyISAM;
57
58	-- --------------------------------------------------------
59
60	--
61	-- Table structure for table `enewsletter_config`
62	--
63
64	CREATE TABLE `enewsletter_config` (
65	`variable` varchar(25) NOT NULL default '0',
66	`value` varchar(250) NOT NULL default '0'
67	) TYPE=MyISAM;
68
69
70	--
71	-- Dumping data for table `enewsletter_config`
72	--
73
74	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('maximum', '10');
75	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('delay', '2');
76	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('from_address', '');
77	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('reply_address', '');
78	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_addresss', '');
79	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('set_return_path', '1');
80	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('send_maximum', '50');
81	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('send_delay', '2');
82	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_connection', '0');
83	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_host', '');
84	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_port', '110/pop3/notls');
85	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_user', '');
86	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_mailbox_password', '');
87	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_max_process', '25');
88	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_store_processed', '2');
89	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('bounce_limit', '2');
90	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('loggin', '0');
91	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('announce_optional_msg', 'Receive announcement messages from this website by email');
92	INSERT INTO `enewsletter_config` (`variable`, `value`) VALUES ('announce_auto_msg', 'Announcement messages from this website will be sent to you by email');
93
94	-- --------------------------------------------------------
95
96	--
97	-- Table structure for table `enewsletter_newsletters`
98	--
99
100	CREATE TABLE `enewsletter_newsletters` (
101	`enewsletter_id` int(10) unsigned NOT NULL auto_increment,
102	`title` varchar(128) NOT NULL default '',
103	`description` varchar(128) NOT NULL default '',
104	`track` int(2) NOT NULL default '0',
105	`template_text` int(10) NOT NULL default '0',
106	`template_html` int(10) NOT NULL default '0',
107	`start` int(11) NOT NULL default '0',
108	`first` int(11) NOT NULL default '0',
109	`next` int(11) NOT NULL default '0',
110	`last` int(11) NOT NULL default '0',
111	`que` int(10) NOT NULL default '0',
112	`every` int(3) NOT NULL default '0',
113	`frequency` varchar(6) NOT NULL default '0',
114	PRIMARY KEY (`enewsletter_id`)
115	) TYPE=MyISAM;
116
117	--
118	-- Dumping data for table `enewsletter_newsletters`
119	--
120	INSERT INTO `enewsletter_newsletters` VALUES (NULL, 'announcements', 'Announcement messages from this website will be sent to you by email', 0, 1, 2, 915148800, 0, 0, 0, 0, 0, 'manual');
121
122
123	-- --------------------------------------------------------
124
125	--
126	-- Table structure for table `enewsletter_nodes`
127	--
128
129	CREATE TABLE `enewsletter_nodes` (
130	`nid` int(10) unsigned NOT NULL default '0',
131	PRIMARY KEY (`nid`)
132	) TYPE=MyISAM;
133
134	-- --------------------------------------------------------
135
136	--
137	-- Table structure for table `enewsletter_selected`
138	--
139
140	CREATE TABLE `enewsletter_selected` (
141	`enewsletter_id` int(10) unsigned NOT NULL default '0',
142	`tid` int(10) NOT NULL default '0',
143	`uid` int(10) NOT NULL default '0'
144	) TYPE=MyISAM;
145
146	-- --------------------------------------------------------
147
148	--
149	-- Table structure for table `enewsletter_sent`
150	--
151
152	CREATE TABLE `enewsletter_sent` (
153	`enewsletter_id` int(10) NOT NULL default '0',
154	`uid` int(10) NOT NULL default '0',
155	`pub_time` int(11) NOT NULL default '0',
156	`sent` int(11) NOT NULL default '0'
157	) TYPE=MyISAM;
158
159	-- --------------------------------------------------------
160
161	--
162	-- Table structure for table `enewsletter_subscribers`
163	--
164
165	CREATE TABLE `enewsletter_subscribers` (
166	`uid` int(10) NOT NULL default '0',
167	`lid` varchar(8) NOT NULL default '',
168	UNIQUE KEY `lid` (`lid`)
169	) TYPE=MyISAM;
170
171	-- --------------------------------------------------------
172
173	--
174	-- Table structure for table `enewsletter_subscriptions`
175	--
176
177	CREATE TABLE `enewsletter_subscriptions` (
178	`uid` int(10) unsigned NOT NULL default '0',
179	`enewsletter_id` int(10) NOT NULL default '0',
180	`format` varchar(4) NOT NULL default 'text',
181	`subscribed` int(11) NOT NULL default '0'
182	) TYPE=MyISAM;
183
184	-- --------------------------------------------------------
185
186	--
187	-- Table structure for table `enewsletter_templates`
188	--
189
190	CREATE TABLE `enewsletter_templates` (
191	`template_id` int(10) NOT NULL auto_increment,
192	`name` varchar(50) NOT NULL default '',
193	`template` longtext NOT NULL,
194	`type` char(2) NOT NULL default '0',
195	`format` int(4) NOT NULL default '0',
196	PRIMARY KEY (`template_id`)
197	) TYPE=MyISAM;
198
199	--
200	-- Dumping data for table `enewsletter_templates`
201	--
202	INSERT INTO enewsletter_templates (template_id, name, template, type) VALUES (1, 'announcement', '', '0');
203	INSERT INTO enewsletter_templates (template_id, name, template, type) VALUES (2, 'announcement HTML', '', '1');
204	INSERT INTO enewsletter_templates VALUES (3, 'default', '<p>Dear $username,<br />\r\nin the latest issue of $publication_title.</p>\r\n<br />\r\n\r\n$nodes\r\n\r\n<hr>\r\n\r\n<p>\r\nUpdate your details:<br />\r\n $update_link<br />\r\nUnsubscribe:<br />\r\n $unsubscribe_link<br />\r\n</p>\r\n\r\n<hr>', '0', 1);
205	INSERT INTO enewsletter_templates VALUES (4, 'default HTML', '<p>Dear $username,<br />\r\nin the latest issue of $publication_title.</p>\r\n<br />\r\n\r\n<div class="content">\r\n$nodes\r\n</div>\r\n\r\n\r\n<div class="controls">\r\n<hr>\r\n\r\n<p>\r\nUpdate your details: <a href="$update_link">Update</a><br />\r\nUnsubscribe: <a href="$unsubscribe_link">Unsubscribe</a>\r\n</p>\r\n\r\n<hr>\r\n</div>', '1', 1);
206