[Sommaire] [Imprimer]

   1  # phpMyAdmin MySQL-Dump
   2  # version 2.2.5
   3  # http://phpwizard.net/phpMyAdmin/
   4  # http://phpmyadmin.sourceforge.net/ (download page)
   5  #
   6  # Host: localhost
   7  # Generation Time: Jan 07, 2003 at 12:02 PM
   8  # Server version: 3.23.49
   9  # PHP Version: 4.1.2
  10  # Database : `clevermail`
  11  # --------------------------------------------------------
  12  
  13  #
  14  # Table structure for table `cm_lists`
  15  #
  16  
  17  DROP TABLE IF EXISTS cm_lists;
  18  CREATE TABLE cm_lists (
  19    lst_id int(11) NOT NULL default '0',
  20    lst_name varchar(255) NOT NULL default '',
  21    lst_comment text NOT NULL,
  22    lst_moderation varchar(10) NOT NULL default '',
  23    lst_subscribe_subject varchar(255) NOT NULL default '',
  24    lst_subscribe_text text NOT NULL,
  25    lst_subject varchar(255) NOT NULL default '',
  26    lst_unsubscribe_subject varchar(255) NOT NULL default '',
  27    lst_unsubscribe_text text NOT NULL,
  28    lst_subject_tag tinyint(1) NOT NULL default '1',
  29    lst_html_header text NOT NULL,
  30    lst_html_footer text NOT NULL,
  31    lst_text_header text NOT NULL,
  32    lst_text_footer text NOT NULL,
  33    PRIMARY KEY  (lst_id)
  34  ) TYPE=MyISAM;
  35  
  36  #
  37  # Dumping data for table `cm_lists`
  38  #
  39  
  40  INSERT INTO cm_lists VALUES (1, 'Clever Link', 'Newsletter périodique de veille technologique de Clever Age', 'email', 'Confirmation d\'inscription', 'Bonjour,\r\n\r\nune demande d\'inscription à notre lettre Clever Link au format #FORMAT# a été demandée pour l\'adresse suivante :\r\n  #ADDRESS#\r\n\r\nPour confirmer cette inscription, veuillez d\'ici moins de 48h cliquer sur le lien ci-dessous, ou en recopier l\'adresse dans votre navigateur :\r\n  #URL#\r\n\r\nSi vous n\'avez pas fait cette demande, veuillez simplement ignorer ce message.\r\n\r\nCordialement,\r\n\r\nClever Age\r\n\r\n--\r\nDésinscription : #UNSUBSCRIBE#', '', 'Confirmation de désinscription', 'Bonjour,\r\n\r\nune demande de désinscription de notre lettre Clever Link a été demandée pour l\'adresse suivante :\r\n\r\n#ADDRESS#\r\n\r\nPour confirmer cette désinscription, veuillez d\'ici moins de 48h cliquer sur le lien ci-dessous, ou en recopier l\'adresse dans votre navigateur :\r\n\r\n#URL#\r\n\r\nSi vous n\'avez pas fait cette demande, veuillez simplement ignorer ce message.\r\n\r\nCordialement,\r\n\r\nClever Age', 1, '', '', '', '');
  41  INSERT INTO cm_lists VALUES (2, 'Clever Link de test', 'Version de test de Clever Link pour tester avant envoi réel', 'closed', 'Confirmation d\'inscription', 'Bonjour,\r\n\r\nune demande d\'inscription à notre lettre Clever Link au format #FORMAT# a été demandée pour l\'adresse suivante :\r\n\r\n#ADDRESS#\r\n\r\nPour confirmer cette inscription, veuillez d\'ici moins de 48h cliquer sur le lien ci-dessous, ou en recopier l\'adresse dans votre navigateur :\r\n\r\n#URL#\r\n\r\nSi vous n\'avez pas fait cette demande, veuillez simplement ignorer ce message.\r\n\r\nCordialement,\r\n\r\nClever Age\r\n\r\n--\r\nDésinscription : #UNSUBSCRIBE#', 'Test d\'envoi ...', 'Confirmation de désinscription', 'Bonjour,\r\n\r\nune demande de désinscription de notre lettre Clever Link a été demandée pour l\'adresse suivante :\r\n\r\n#ADDRESS#\r\n\r\nPour confirmer cette désinscription, veuillez d\'ici moins de 48h cliquer sur le lien ci-dessous, ou en recopier l\'adresse dans votre navigateur :\r\n\r\n#URL#\r\n\r\nSi vous n\'avez pas fait cette demande, veuillez simplement ignorer ce message.\r\n\r\nCordialement,\r\n\r\nClever Age', 1, '', '', '', '');
  42  # --------------------------------------------------------
  43  
  44  #
  45  # Table structure for table `cm_lists_seq`
  46  #
  47  
  48  DROP TABLE IF EXISTS cm_lists_seq;
  49  CREATE TABLE cm_lists_seq (
  50    id int(10) unsigned NOT NULL auto_increment,
  51    PRIMARY KEY  (id)
  52  ) TYPE=MyISAM;
  53  
  54  #
  55  # Dumping data for table `cm_lists_seq`
  56  #
  57  
  58  INSERT INTO cm_lists_seq VALUES (4);
  59  # --------------------------------------------------------
  60  
  61  #
  62  # Table structure for table `cm_lists_subscribers`
  63  #
  64  
  65  DROP TABLE IF EXISTS cm_lists_subscribers;
  66  CREATE TABLE cm_lists_subscribers (
  67    lst_id int(11) NOT NULL default '0',
  68    sub_id bigint(20) NOT NULL default '0',
  69    lsr_mode tinyint(1) NOT NULL default '0',
  70    lsr_id varchar(32) NOT NULL default '',
  71    PRIMARY KEY  (lst_id,sub_id)
  72  ) TYPE=MyISAM;
  73  
  74  #
  75  # Dumping data for table `cm_lists_subscribers`
  76  #
  77  
  78  INSERT INTO cm_lists_subscribers VALUES (1, 12, 1, '7bb1e0e990ede5317177552e7353ee06');
  79  INSERT INTO cm_lists_subscribers VALUES (1, 3, 1, '5e8fa5fb3ac31cd8235420c57ec811c3');
  80  INSERT INTO cm_lists_subscribers VALUES (1, 4, 1, '02e4ff94bb121ba44209f2e31511d466');
  81  INSERT INTO cm_lists_subscribers VALUES (1, 5, 1, '3610ef61a0c2f8843a620e40dae404ca');
  82  INSERT INTO cm_lists_subscribers VALUES (1, 6, 1, '9be76c04fcf7b5c82eaa30bb21514cd2');
  83  INSERT INTO cm_lists_subscribers VALUES (1, 13, 1, '16935f40ab222647a650a3849dad0b41');
  84  INSERT INTO cm_lists_subscribers VALUES (1, 7, 1, 'f4b730de3741102915ecce5cdaa08a59');
  85  INSERT INTO cm_lists_subscribers VALUES (1, 9, 1, '3a1e44b04a8abf7c4b6be565b313fc82');
  86  INSERT INTO cm_lists_subscribers VALUES (1, 10, 1, '92131ea2705c0eb956179e72b432b7ee');
  87  # --------------------------------------------------------
  88  
  89  #
  90  # Table structure for table `cm_pending`
  91  #
  92  
  93  DROP TABLE IF EXISTS cm_pending;
  94  CREATE TABLE cm_pending (
  95    lst_id int(11) NOT NULL default '0',
  96    sub_id bigint(20) NOT NULL default '0',
  97    pnd_action varchar(15) NOT NULL default '',
  98    pnd_mode tinyint(1) NOT NULL default '0',
  99    pnd_action_date int(11) NOT NULL default '0',
 100    pnd_action_id varchar(32) NOT NULL default '',
 101    PRIMARY KEY  (lst_id,sub_id)
 102  ) TYPE=MyISAM;
 103  
 104  #
 105  # Dumping data for table `cm_pending`
 106  #
 107  
 108  INSERT INTO cm_pending VALUES (1, 8, 'subscribe', 1, 1041633712, '424e63b387786187210fd3f8f1d3c67b');
 109  INSERT INTO cm_pending VALUES (2, 21, 'subscribe', 1, 1041879259, 'e816a13ffb7eda2255d307fc67a72157');
 110  INSERT INTO cm_pending VALUES (2, 22, 'subscribe', 1, 1041879259, '5c22dfc4840c682b3202677158819f47');
 111  INSERT INTO cm_pending VALUES (2, 23, 'subscribe', 0, 1041879835, '19410670366866e3f26750737ce21342');
 112  INSERT INTO cm_pending VALUES (2, 24, 'subscribe', 0, 1041879835, '85d181606cb9dec9e17958785859db94');
 113  # --------------------------------------------------------
 114  
 115  #
 116  # Table structure for table `cm_posts`
 117  #
 118  
 119  DROP TABLE IF EXISTS cm_posts;
 120  CREATE TABLE cm_posts (
 121    pst_id bigint(20) NOT NULL default '0',
 122    lst_id int(11) NOT NULL default '0',
 123    pst_date timestamp(14) NOT NULL,
 124    pst_subject varchar(255) NOT NULL default '',
 125    pst_html text NOT NULL,
 126    pst_text text NOT NULL,
 127    PRIMARY KEY  (pst_id)
 128  ) TYPE=MyISAM;
 129  
 130  #
 131  # Dumping data for table `cm_posts`
 132  #
 133  
 134  # --------------------------------------------------------
 135  
 136  #
 137  # Table structure for table `cm_posts_done`
 138  #
 139  
 140  DROP TABLE IF EXISTS cm_posts_done;
 141  CREATE TABLE cm_posts_done (
 142    pst_id bigint(20) NOT NULL default '0',
 143    sub_id bigint(20) NOT NULL default '0',
 144    PRIMARY KEY  (pst_id,sub_id)
 145  ) TYPE=MyISAM;
 146  
 147  #
 148  # Dumping data for table `cm_posts_done`
 149  #
 150  
 151  # --------------------------------------------------------
 152  
 153  #
 154  # Table structure for table `cm_posts_links`
 155  #
 156  
 157  DROP TABLE IF EXISTS cm_posts_links;
 158  CREATE TABLE cm_posts_links (
 159    lnk_id bigint(20) NOT NULL default '0',
 160    pst_id bigint(20) NOT NULL default '0',
 161    lnk_name varchar(255) NOT NULL default '',
 162    lnk_url text NOT NULL,
 163    PRIMARY KEY  (lnk_id)
 164  ) TYPE=MyISAM;
 165  
 166  #
 167  # Dumping data for table `cm_posts_links`
 168  #
 169  
 170  # --------------------------------------------------------
 171  
 172  #
 173  # Table structure for table `cm_posts_queued`
 174  #
 175  
 176  DROP TABLE IF EXISTS cm_posts_queued;
 177  CREATE TABLE cm_posts_queued (
 178    pst_id bigint(20) NOT NULL default '0',
 179    sub_id bigint(20) NOT NULL default '0',
 180    PRIMARY KEY  (pst_id,sub_id)
 181  ) TYPE=MyISAM;
 182  
 183  #
 184  # Dumping data for table `cm_posts_queued`
 185  #
 186  
 187  # --------------------------------------------------------
 188  
 189  #
 190  # Table structure for table `cm_settings`
 191  #
 192  
 193  DROP TABLE IF EXISTS cm_settings;
 194  CREATE TABLE cm_settings (
 195    set_name varchar(15) NOT NULL default '',
 196    set_value varchar(255) NOT NULL default '',
 197    PRIMARY KEY  (set_name)
 198  ) TYPE=MyISAM COMMENT='Application settings';
 199  
 200  #
 201  # Dumping data for table `cm_settings`
 202  #
 203  
 204  INSERT INTO cm_settings VALUES ('CM_MAIL_FROM', 'Clever Age <noreply@clever-age.com>');
 205  INSERT INTO cm_settings VALUES ('CM_BASE_URL', 'http://www.clever-age.com/cm/');
 206  INSERT INTO cm_settings VALUES ('CM_LISTS_SIZE', '10');
 207  INSERT INTO cm_settings VALUES ('CM_MAIL_ADMIN', 'nhoizey@clever-age.com');
 208  INSERT INTO cm_settings VALUES ('CM_UPLOAD_DIR', '/tmp/');
 209  # --------------------------------------------------------
 210  
 211  #
 212  # Table structure for table `cm_subscribers`
 213  #
 214  
 215  DROP TABLE IF EXISTS cm_subscribers;
 216  CREATE TABLE cm_subscribers (
 217    sub_id bigint(20) NOT NULL default '0',
 218    sub_email varchar(255) NOT NULL default '',
 219    sub_first_name varchar(50) NOT NULL default '',
 220    sub_middle_name varchar(50) NOT NULL default '',
 221    sub_last_name varchar(50) NOT NULL default '',
 222    sub_title varchar(10) NOT NULL default '',
 223    sub_profile varchar(32) NOT NULL default '',
 224    PRIMARY KEY  (sub_id),
 225    KEY sub_profile (sub_profile)
 226  ) TYPE=MyISAM;
 227  
 228  #
 229  # Dumping data for table `cm_subscribers`
 230  #
 231  
 232  INSERT INTO cm_subscribers VALUES (3, 'jed@clever-age.com', '', '', '', '', '');
 233  INSERT INTO cm_subscribers VALUES (4, 'avialet@e-care.fr', '', '', '', '', '');
 234  INSERT INTO cm_subscribers VALUES (5, 'mbelge@clever-age.com', '', '', '', '', '');
 235  INSERT INTO cm_subscribers VALUES (6, 'mbelge@noos.fr', '', '', '', '', '');
 236  INSERT INTO cm_subscribers VALUES (7, 'bgoupil@clever-age.com', '', '', '', '', '');
 237  INSERT INTO cm_subscribers VALUES (8, 'yafournier@wanadoo.fr', '', '', '', '', '');
 238  INSERT INTO cm_subscribers VALUES (9, 'philu@ll88ll.com', '', '', '', '', '');
 239  INSERT INTO cm_subscribers VALUES (10, 'cgluch@sopragroup.com', '', '', '', '', '');
 240  INSERT INTO cm_subscribers VALUES (12, 'mlafourcade@sopragroup.com', '', '', '', '', '');
 241  INSERT INTO cm_subscribers VALUES (13, 'jean-yves_thibert@sandp.com', '', '', '', '', '');
 242  # --------------------------------------------------------
 243  
 244  #
 245  # Table structure for table `cm_subscribers_seq`
 246  #
 247  
 248  DROP TABLE IF EXISTS cm_subscribers_seq;
 249  CREATE TABLE cm_subscribers_seq (
 250    id int(10) unsigned NOT NULL auto_increment,
 251    PRIMARY KEY  (id)
 252  ) TYPE=MyISAM;
 253  
 254  #
 255  # Dumping data for table `cm_subscribers_seq`
 256  #
 257  
 258  INSERT INTO cm_subscribers_seq VALUES (28);
 259