Changeset 61 for install/scripts/mysql.sql

Timestamp:

02/21/06 23:31:25 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2003-05-01 11:37:38 by benjamin]
Suppression de Sympa du CVS. Sympa et Mailman sont maintenant dans 2
paquets distincts et séparés d'AlternC : alternc-mailman alternc-sympa

Original author: benjamin
Date: 2003-05-01 11:37:40

File:

• install/scripts/mysql.sql (modified) (6 diffs)

install/scripts/mysql.sql

@@ -1 +1 @@
 #
-# $Id: mysql.sql,v 1.4 2003/04/04 05:35:06 root Exp $
+# $Id: mysql.sql,v 1.5 2003/05/01 11:37:39 benjamin Exp $
 # ----------------------------------------------------------------------
 # AlternC - Web Hosting System
@@ -176 +176 @@
 
 #
-# 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 `quotas`
 #
@@ -281 +266 @@
 # Contenu de la table `mime`
 #
-# TODO : Mettre les types mimes dans le .po + déplacer cela dans un fichier plat si possible (performance ?)
+# TODO : Mettre les types mimes dans le .po + 
+# déplacer cela dans un fichier plat si possible (performance ?)
 
 INSERT INTO mime VALUES (0, 'html', '', 'html', 'Document HTML');
@@ -452 +438 @@
 
 #
-# 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;
-
-#
 # Structure de la table `forbidden_domains`
 #
@@ -498 +451 @@
 #
 
+# Registries : 
 INSERT INTO forbidden_domains VALUES ('afilias.net');
 INSERT INTO forbidden_domains VALUES ('afnic.fr');
-INSERT INTO forbidden_domains VALUES ('aol.com');
-INSERT INTO forbidden_domains VALUES ('caramail.com');
 INSERT INTO forbidden_domains VALUES ('dns.be');
-INSERT INTO forbidden_domains VALUES ('hotmail.com');
 INSERT INTO forbidden_domains VALUES ('internic.net');
-INSERT INTO forbidden_domains VALUES ('microsoft.com');
 INSERT INTO forbidden_domains VALUES ('netsol.com');
 INSERT INTO forbidden_domains VALUES ('nic.biz');
 INSERT INTO forbidden_domains VALUES ('nic.cx');
 INSERT INTO forbidden_domains VALUES ('nic.fr');
+INSERT INTO forbidden_domains VALUES ('verisign.com');
+INSERT INTO forbidden_domains VALUES ('octopuce.com');
+INSERT INTO forbidden_domains VALUES ('pir.org');
+# big isp :
+INSERT INTO forbidden_domains VALUES ('aol.com');
+INSERT INTO forbidden_domains VALUES ('hotmail.com');
+INSERT INTO forbidden_domains VALUES ('microsoft.com');
 INSERT INTO forbidden_domains VALUES ('sympatico.ca');
 INSERT INTO forbidden_domains VALUES ('tiscali.fr');
-INSERT INTO forbidden_domains VALUES ('verisign.com');
 INSERT INTO forbidden_domains VALUES ('voila.fr');
 INSERT INTO forbidden_domains VALUES ('wanadoo.fr');
 INSERT INTO forbidden_domains VALUES ('yahoo.com');
 INSERT INTO forbidden_domains VALUES ('yahoo.fr');
-INSERT INTO forbidden_domains VALUES ('octopuce.com');
-INSERT INTO forbidden_domains VALUES ('pir.org');
 
 #
@@ -563 +517 @@
 ) TYPE=MyISAM COMMENT='Statistiques apaches brutes';
 
+
 #
 # Structure de la table `defquotas`