root/alternc-sympa/tags/BASE/install/mysql.sql

#
# Structure de la table `ml`
#
# Listes de diffusions des membres : (utilisant sympa)

DROP TABLE IF EXISTS ml;

CREATE TABLE ml (
  id int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0',
  list varchar(128) NOT NULL default '',
  premier tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM;


#
# Structure de la table `subscriber_table`
#
# Table de gestion des abonnés à la ML (Sympa)

DROP TABLE IF EXISTS subscriber_table;
CREATE TABLE subscriber_table (
  list_subscriber varchar(50) NOT NULL default '',
  user_subscriber varchar(100) NOT NULL default '',
  date_subscriber datetime NOT NULL default '0000-00-00 00:00:00',
  update_subscriber datetime default NULL,
  visibility_subscriber varchar(20) default NULL,
  reception_subscriber varchar(20) default NULL,
  bounce_subscriber varchar(30) default NULL,
  comment_subscriber varchar(150) default NULL,
  PRIMARY KEY  (list_subscriber,user_subscriber)
) TYPE=MyISAM;

#
# Structure de la table `user_table`
#
# Table de gestion des abonnés à Sympa

DROP TABLE IF EXISTS user_table;
CREATE TABLE user_table (
  email_user varchar(100) NOT NULL default '',
  gecos_user varchar(150) default NULL,
  password_user varchar(40) default NULL,
  cookie_delay_user int(11) default NULL,
  lang_user varchar(10) default NULL,
  PRIMARY KEY  (email_user)
) TYPE=MyISAM;