4 CREATE TABLE IF NOT EXISTS `plugin_mailman` (
5 listname varchar( 100 ) NOT NULL ,
6 address varchar( 255 ) NOT NULL ,
7 hide enum( 'Y', 'N' ) NOT NULL default 'N',
8 nomail enum( 'Y', 'N' ) NOT NULL default 'N',
9 ack enum( 'Y', 'N' ) NOT NULL default 'Y',
10 not_metoo enum( 'Y', 'N' ) NOT NULL default 'Y',
11 digest enum( 'Y', 'N' ) NOT NULL default 'N',
12 plain enum( 'Y', 'N' ) NOT NULL default 'N',
13 PASSWORD varchar( 255 ) NOT NULL default '!',
14 lang varchar( 255 ) NOT NULL default 'en',
15 name varchar( 255 ) default NULL ,
16 one_last_digest enum( 'Y', 'N' ) NOT NULL default 'N',
17 user_options bigint( 20 ) NOT NULL default 0,
18 delivery_status INT( 10 ) NOT NULL default 0,
19 topics_userinterest varchar( 255 ) default NULL ,
20 delivery_status_timestamp datetime default '0000-00-00 00:00:00',
21 bi_cookie varchar( 255 ) default NULL ,
22 bi_score double NOT NULL default '0',
23 bi_noticesleft double NOT NULL default '0',
24 bi_lastnotice date NOT NULL default '0000-00-00',
25 bi_date date NOT NULL default '0000-00-00'
27 INSERT INTO service(group_id, label, description, short_name, link, is_active, is_used, scope, rank) VALUES ( 100 , 'Mailman' , 'Manage mailing lists' , 'mailman', '/plugins/mailman/index.php?group_id=$group_id', 1 , 0 , 'system', 230 );