[Sommaire] [Imprimer]

   1  #
   2  # Table structure for table `cm_lists`
   3  #
   4  
   5  DROP TABLE IF EXISTS cm_lists;
   6  CREATE TABLE cm_lists (
   7    lst_id int(11) NOT NULL default '0',
   8    lst_name varchar(255) NOT NULL default '',
   9    lst_comment text NOT NULL,
  10    lst_moderation varchar(10) NOT NULL default '',
  11    lst_moderator_email varchar(255) NOT NULL default '',
  12    lst_subscribe_subject varchar(255) NOT NULL default '',
  13    lst_subscribe_text text NOT NULL,
  14    lst_subject varchar(255) NOT NULL default '',
  15    lst_unsubscribe_subject varchar(255) NOT NULL default '',
  16    lst_unsubscribe_text text NOT NULL,
  17    lst_subject_tag tinyint(1) NOT NULL default '1',
  18    lst_html_header text NOT NULL,
  19    lst_html_footer text NOT NULL,
  20    lst_text_header text NOT NULL,
  21    lst_text_footer text NOT NULL,
  22    PRIMARY KEY  (lst_id)
  23  ) TYPE=MyISAM;
  24  
  25  #
  26  # Table structure for table `cm_lists_subscribers`
  27  #
  28  
  29  DROP TABLE IF EXISTS cm_lists_subscribers;
  30  CREATE TABLE cm_lists_subscribers (
  31    lst_id int(11) NOT NULL default '0',
  32    sub_id bigint(20) NOT NULL default '0',
  33    lsr_mode tinyint(1) NOT NULL default '0',
  34    lsr_id varchar(32) NOT NULL default '',
  35    PRIMARY KEY  (lst_id,sub_id),
  36    KEY lst_id (lst_id)
  37  ) TYPE=MyISAM;
  38  
  39  #
  40  # Table structure for table `cm_pending`
  41  #
  42  
  43  DROP TABLE IF EXISTS cm_pending;
  44  CREATE TABLE cm_pending (
  45    lst_id int(11) NOT NULL default '0',
  46    sub_id bigint(20) NOT NULL default '0',
  47    pnd_action varchar(15) NOT NULL default '',
  48    pnd_mode tinyint(1) NOT NULL default '0',
  49    pnd_action_date int(11) NOT NULL default '0',
  50    pnd_action_id varchar(32) NOT NULL default '',
  51    PRIMARY KEY  (lst_id,sub_id)
  52  ) TYPE=MyISAM;
  53  
  54  #
  55  # Table structure for table `cm_posts`
  56  #
  57  
  58  DROP TABLE IF EXISTS cm_posts;
  59  CREATE TABLE cm_posts (
  60    pst_id bigint(20) NOT NULL default '0',
  61    lst_id int(11) NOT NULL default '0',
  62    pst_date_create int(11) NOT NULL default '0',
  63    pst_date_update int(11) NOT NULL default '0',
  64    pst_date_sent int(11) NOT NULL default '0',
  65    pst_subject varchar(255) NOT NULL default '',
  66    pst_html text NOT NULL,
  67    pst_text text NOT NULL,
  68    PRIMARY KEY  (pst_id)
  69  ) TYPE=MyISAM;
  70  
  71  #
  72  # Table structure for table `cm_posts_done`
  73  #
  74  
  75  DROP TABLE IF EXISTS cm_posts_done;
  76  CREATE TABLE cm_posts_done (
  77    pst_id bigint(20) NOT NULL default '0',
  78    sub_id bigint(20) NOT NULL default '0',
  79    PRIMARY KEY  (pst_id,sub_id)
  80  ) TYPE=MyISAM;
  81  
  82  #
  83  # Table structure for table `cm_posts_links`
  84  #
  85  
  86  DROP TABLE IF EXISTS cm_posts_links;
  87  CREATE TABLE cm_posts_links (
  88    lnk_id bigint(20) NOT NULL default '0',
  89    pst_id bigint(20) NOT NULL default '0',
  90    lnk_name varchar(255) NOT NULL default '',
  91    lnk_url text NOT NULL,
  92    PRIMARY KEY  (lnk_id)
  93  ) TYPE=MyISAM;
  94  
  95  #
  96  # Table structure for table `cm_posts_queued`
  97  #
  98  
  99  DROP TABLE IF EXISTS cm_posts_queued;
 100  CREATE TABLE cm_posts_queued (
 101    pst_id bigint(20) NOT NULL default '0',
 102    sub_id bigint(20) NOT NULL default '0',
 103    psq_date int(11) NOT NULL default '0',
 104    PRIMARY KEY  (pst_id,sub_id)
 105  ) TYPE=MyISAM;
 106  
 107  #
 108  # Table structure for table `cm_settings`
 109  #
 110  
 111  DROP TABLE IF EXISTS cm_settings;
 112  CREATE TABLE cm_settings (
 113    set_name varchar(15) NOT NULL default '',
 114    set_value varchar(255) NOT NULL default '',
 115    PRIMARY KEY  (set_name)
 116  ) TYPE=MyISAM COMMENT='Application settings';
 117  
 118  #
 119  # Dumping data for table `cm_settings`
 120  #
 121  
 122  INSERT INTO cm_settings VALUES ('CM_MAIL_FROM', 'No Reply <noreply@example.com>');
 123  INSERT INTO cm_settings VALUES ('CM_BASE_URL', 'http://www.example.com/cm/');
 124  INSERT INTO cm_settings VALUES ('CM_LISTS_SIZE', '20');
 125  INSERT INTO cm_settings VALUES ('CM_MAIL_ADMIN', 'postmaster@example.com');
 126  INSERT INTO cm_settings VALUES ('CM_UPLOAD_DIR', '/tmp/');
 127  INSERT INTO cm_settings VALUES ('CM_SEND_NUMBER', '100');
 128  
 129  #
 130  # Table structure for table `cm_subscribers`
 131  #
 132  
 133  DROP TABLE IF EXISTS cm_subscribers;
 134  CREATE TABLE cm_subscribers (
 135    sub_id bigint(20) NOT NULL default '0',
 136    sub_email varchar(255) NOT NULL default '',
 137    sub_first_name varchar(50) NOT NULL default '',
 138    sub_middle_name varchar(50) NOT NULL default '',
 139    sub_last_name varchar(50) NOT NULL default '',
 140    sub_title varchar(10) NOT NULL default '',
 141    sub_profile varchar(32) NOT NULL default '',
 142    PRIMARY KEY  (sub_id),
 143    KEY sub_profile (sub_profile),
 144    KEY sub_email (sub_email)
 145  ) TYPE=MyISAM;
 146