Changeset 264

Timestamp:

02/21/06 23:56:32 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2004-05-24 14:55:38 by anonymous]

• suppression de la table mime

• ajout du drop table mime dans l'upgrade

Original author: anonymous
Date: 2004-05-24 14:55:38

Location:

install/scripts

Files:

• mysql.sql (modified) (2 diffs)
• upgrades/0.9.1.sh (modified) (4 diffs)

install/scripts/mysql.sql

@@ -1 +1 @@
 #
-# $Id: mysql.sql,v 1.16 2004/05/10 23:53:25 anonymous Exp $
+# $Id: mysql.sql,v 1.17 2004/05/24 14:55:38 anonymous Exp $
 # ----------------------------------------------------------------------
 # AlternC - Web Hosting System
@@ -270 +270 @@
   value bigint(20) unsigned default '0'         # Valeur du quota
 ) TYPE=MyISAM;
-
-#
-# Structure de la table `mime`
-#
-# Liste des types mimes : 
-
-CREATE TABLE IF NOT EXISTS mime (
-  tid int(10) unsigned NOT NULL default '0',
-  ext varchar(8) NOT NULL default '',
-  mime varchar(128) NOT NULL default '',
-  icon varchar(32) NOT NULL default '',
-  descr varchar(128) NOT NULL default '',
-  PRIMARY KEY  (tid),
-  KEY ext (ext)
-) TYPE=MyISAM COMMENT='Types Mimes + Icones';
-
-#
-# Contenu de la table `mime`
-#
-# TODO : Mettre les types mimes dans le .po + 
-# déplacer cela dans un fichier plat si possible (performance ?)
-
-INSERT IGNORE INTO mime VALUES (0, 'html', '', 'html', 'Document HTML');
-INSERT IGNORE INTO mime VALUES (1, 'htm', '', 'htm', 'Document HTML');
-INSERT IGNORE INTO mime VALUES (2, 'php', '', 'php', 'Source php');
-INSERT IGNORE INTO mime VALUES (3, 'php3', '', 'php3', 'Source php3');
-INSERT IGNORE INTO mime VALUES (4, 'php4', '', 'php4', 'Source php4');
-INSERT IGNORE INTO mime VALUES (5, 'phtml', '', 'phtml', 'Source php');
-INSERT IGNORE INTO mime VALUES (6, 'txt', '', 'txt', 'Document texte');
-INSERT IGNORE INTO mime VALUES (7, 'sh', '', 'sh', 'Shell Script');
-INSERT IGNORE INTO mime VALUES (8, 'wml', '', 'wml', 'Document WAP');
-INSERT IGNORE INTO mime VALUES (9, 'tex', '', 'tex', 'Document Latex');
-INSERT IGNORE INTO mime VALUES (10, 'ini', '', 'ini', 'Paramètres de configuration');
-INSERT IGNORE INTO mime VALUES (11, 'inf', '', 'inf', 'Paramètres d\'installation');
-INSERT IGNORE INTO mime VALUES (12, 'log', '', 'log', 'Document Log');
-INSERT IGNORE INTO mime VALUES (13, 'bat', '', 'bat', 'Script de Commandes');
-INSERT IGNORE INTO mime VALUES (14, 'cmd', '', 'cmd', 'Script de Commandes');
-INSERT IGNORE INTO mime VALUES (15, 'cfm', '', 'cfm', 'Document Coldfusion');
-INSERT IGNORE INTO mime VALUES (16, 'css', '', 'css', 'Feuille de Style');
-INSERT IGNORE INTO mime VALUES (17, 'csv', '', 'csv', 'Document Séparateur ;');
-INSERT IGNORE INTO mime VALUES (18, 'dat', '', 'dat', 'Fichier de données');
-INSERT IGNORE INTO mime VALUES (19, 'ht', '', 'ht', 'Executable HTML');
-INSERT IGNORE INTO mime VALUES (20, 'hta', '', 'hta', 'Executable HTML');
-INSERT IGNORE INTO mime VALUES (21, 'nfo', '', 'nfo', 'Document d\'information');
-INSERT IGNORE INTO mime VALUES (22, 'shtml', '', 'shtml', 'Document HTML');
-INSERT IGNORE INTO mime VALUES (23, 'vcf', '', 'vcf', 'Carte de visite');
-INSERT IGNORE INTO mime VALUES (24, 'xml', '', 'xml', 'Document XML');
-INSERT IGNORE INTO mime VALUES (25, 'xsl', '', 'xsl', 'Feuille de style XSL');
-INSERT IGNORE INTO mime VALUES (26, 'c', '', 'c', 'Source c');
-INSERT IGNORE INTO mime VALUES (27, 'cpp', '', 'cpp', 'Source c++');
-INSERT IGNORE INTO mime VALUES (28, 'h', '', 'h', 'Fichier en-tete');
-INSERT IGNORE INTO mime VALUES (29, 'hpp', '', 'hpp', 'Fichier en-tete');
-INSERT IGNORE INTO mime VALUES (30, 'pas', '', 'pas', 'Source Pascal');
-INSERT IGNORE INTO mime VALUES (31, 'c++', '', 'c++', 'Source c++');
-INSERT IGNORE INTO mime VALUES (32, 'vbs', '', 'vbs', 'Projet Visual Basic');
-INSERT IGNORE INTO mime VALUES (33, 'reg', '', 'reg', 'Fichier de registre');
-INSERT IGNORE INTO mime VALUES (34, 'asp', '', 'asp', 'Document ASP');
-INSERT IGNORE INTO mime VALUES (35, 'asa', '', 'asa', 'Document ASP');
-INSERT IGNORE INTO mime VALUES (36, 'js', '', 'js', 'Source Javascript');
-INSERT IGNORE INTO mime VALUES (37, 'jsp', '', 'jsp', 'Java Server PAge');
-INSERT IGNORE INTO mime VALUES (38, 'java', '', 'java', 'Source Java');
-INSERT IGNORE INTO mime VALUES (39, 'class', '', 'class', 'Classe Java');
-INSERT IGNORE INTO mime VALUES (40, 'lex', '', 'lex', 'Document Lex');
-INSERT IGNORE INTO mime VALUES (41, 'lib', '', 'lib', 'Librairie compilée');
-INSERT IGNORE INTO mime VALUES (42, 'obj', '', 'obj', 'Librairie Compilée');
-INSERT IGNORE INTO mime VALUES (43, 'o', '', 'o', 'Librairie');
-INSERT IGNORE INTO mime VALUES (44, 'a', '', 'a', 'Librairie statique');
-INSERT IGNORE INTO mime VALUES (45, 's', '', 's', 'Source Assembleur');
-INSERT IGNORE INTO mime VALUES (46, 'bas', '', 'bas', 'Source Basic');
-INSERT IGNORE INTO mime VALUES (47, 'asm', '', 'asm', 'Source Assembleur');
-INSERT IGNORE INTO mime VALUES (48, 'cer', '', 'cer', 'cer');
-INSERT IGNORE INTO mime VALUES (49, 'crt', '', 'crt', 'crt');
-INSERT IGNORE INTO mime VALUES (50, 'p7b', '', 'p7b', 'p7b');
-INSERT IGNORE INTO mime VALUES (51, 'der', '', 'der', 'der');
-INSERT IGNORE INTO mime VALUES (52, 'p7c', '', 'p7c', 'p7c');
-INSERT IGNORE INTO mime VALUES (53, 'p7m', '', 'p7m', 'p7m');
-INSERT IGNORE INTO mime VALUES (54, 'p7r', '', 'p7r', 'p7r');
-INSERT IGNORE INTO mime VALUES (55, 'p7s', '', 'p7s', 'p7s');
-INSERT IGNORE INTO mime VALUES (56, 'pgp', '', 'pgp', 'pgp');
-INSERT IGNORE INTO mime VALUES (57, 'pfx', '', 'pfx', 'pfx');
-INSERT IGNORE INTO mime VALUES (58, 'doc', '', 'doc', 'doc');
-INSERT IGNORE INTO mime VALUES (59, 'xls', '', 'xls', 'xls');
-INSERT IGNORE INTO mime VALUES (60, 'pps', '', 'pps', 'pps');
-INSERT IGNORE INTO mime VALUES (61, 'ppt', '', 'ppt', 'ppt');
-INSERT IGNORE INTO mime VALUES (62, 'hlp', '', 'hlp', 'hlp');
-INSERT IGNORE INTO mime VALUES (63, 'chm', '', 'chm', 'chm');
-INSERT IGNORE INTO mime VALUES (64, 'pdf', '', 'pdf', 'pdf');
-INSERT IGNORE INTO mime VALUES (65, 'ps', '', 'ps', 'ps');
-INSERT IGNORE INTO mime VALUES (66, 'cgi', '', 'cgi', 'cgi');
-INSERT IGNORE INTO mime VALUES (67, 'dot', '', 'dot', 'dot');
-INSERT IGNORE INTO mime VALUES (68, 'xla', '', 'xla', 'xla');
-INSERT IGNORE INTO mime VALUES (69, 'eps', '', 'eps', 'eps');
-INSERT IGNORE INTO mime VALUES (70, 'latex', '', 'latex', 'latex');
-INSERT IGNORE INTO mime VALUES (71, 'mdb', '', 'mdb', 'mdb');
-INSERT IGNORE INTO mime VALUES (72, 'ldb', '', 'ldb', 'ldb');
-INSERT IGNORE INTO mime VALUES (73, 'mde', '', 'mde', 'mde');
-INSERT IGNORE INTO mime VALUES (74, 'rtf', '', 'rtf', 'rtf');
-INSERT IGNORE INTO mime VALUES (75, '123', '', '123', '123');
-INSERT IGNORE INTO mime VALUES (76, 'sch', '', 'sch', 'sch');
-INSERT IGNORE INTO mime VALUES (77, 'wri', '', 'wri', 'wri');
-INSERT IGNORE INTO mime VALUES (78, 'swf', '', 'swf', 'Document Flash');
-INSERT IGNORE INTO mime VALUES (79, 'tif', '', 'tif', 'tif');
-INSERT IGNORE INTO mime VALUES (80, 'tiff', '', 'tiff', 'tiff');
-INSERT IGNORE INTO mime VALUES (81, 'jpe', '', 'jpe', 'jpe');
-INSERT IGNORE INTO mime VALUES (82, 'jpg', '', 'jpg', 'jpg');
-INSERT IGNORE INTO mime VALUES (83, 'jpeg', '', 'jpeg', 'jpeg');
-INSERT IGNORE INTO mime VALUES (84, 'bmp', '', 'bmp', 'bmp');
-INSERT IGNORE INTO mime VALUES (85, 'wmf', '', 'wmf', 'wmf');
-INSERT IGNORE INTO mime VALUES (86, 'psp', '', 'psp', 'psp');
-INSERT IGNORE INTO mime VALUES (87, 'psd', '', 'psd', 'psd');
-INSERT IGNORE INTO mime VALUES (88, 'gif', '', 'gif', 'gif');
-INSERT IGNORE INTO mime VALUES (89, 'dib', '', 'dib', 'dib');
-INSERT IGNORE INTO mime VALUES (90, 'emf', '', 'emf', 'emf');
-INSERT IGNORE INTO mime VALUES (91, 'fpx', '', 'fpx', 'fpx');
-INSERT IGNORE INTO mime VALUES (92, 'ico', '', 'ico', 'ico');
-INSERT IGNORE INTO mime VALUES (93, 'iff', '', 'iff', 'iff');
-INSERT IGNORE INTO mime VALUES (94, 'jbf', '', 'jbf', 'jbf');
-INSERT IGNORE INTO mime VALUES (95, 'jfif', '', 'jfif', 'jfif');
-INSERT IGNORE INTO mime VALUES (96, 'jif', '', 'jif', 'jif');
-INSERT IGNORE INTO mime VALUES (97, 'pcx', '', 'pcx', 'pcx');
-INSERT IGNORE INTO mime VALUES (98, 'pic', '', 'pic', 'pic');
-INSERT IGNORE INTO mime VALUES (99, 'pict', '', 'pict', 'pict');
-INSERT IGNORE INTO mime VALUES (100, 'pix', '', 'pix', 'pix');
-INSERT IGNORE INTO mime VALUES (101, 'png', '', 'png', 'png');
-INSERT IGNORE INTO mime VALUES (102, 'tga', '', 'tga', 'tga');
-INSERT IGNORE INTO mime VALUES (103, 'xbm', '', 'xbm', 'xbm');
-INSERT IGNORE INTO mime VALUES (104, 'wav', '', 'wav', 'wav');
-INSERT IGNORE INTO mime VALUES (105, 'mp2', '', 'mp2', 'mp2');
-INSERT IGNORE INTO mime VALUES (106, 'mp3', '', 'mp3', 'mp3');
-INSERT IGNORE INTO mime VALUES (107, 'wma', '', 'wma', 'wma');
-INSERT IGNORE INTO mime VALUES (108, 'mid', '', 'mid', 'mid');
-INSERT IGNORE INTO mime VALUES (109, 'aif', '', 'aif', 'aif');
-INSERT IGNORE INTO mime VALUES (110, 'aiff', '', 'aiff', 'aiff');
-INSERT IGNORE INTO mime VALUES (111, 'au', '', 'au', 'au');
-INSERT IGNORE INTO mime VALUES (112, 'cda', '', 'cda', 'cda');
-INSERT IGNORE INTO mime VALUES (113, 'm3u', '', 'm3u', 'm3u');
-INSERT IGNORE INTO mime VALUES (114, 'pls', '', 'pls', 'pls');
-INSERT IGNORE INTO mime VALUES (115, 'it', '', 'it', 'it');
-INSERT IGNORE INTO mime VALUES (116, 'midi', '', 'midi', 'midi');
-INSERT IGNORE INTO mime VALUES (117, 'mus', '', 'mus', 'mus');
-INSERT IGNORE INTO mime VALUES (118, 'ra', '', 'ra', 'ra');
-INSERT IGNORE INTO mime VALUES (119, 'ram', '', 'ram', 'ram');
-INSERT IGNORE INTO mime VALUES (120, 'rmi', '', 'rmi', 'rmi');
-INSERT IGNORE INTO mime VALUES (121, 's3m', '', 's3m', 's3m');
-INSERT IGNORE INTO mime VALUES (122, 'snd', '', 'snd', 'snd');
-INSERT IGNORE INTO mime VALUES (123, 'xm', '', 'xm', 'xm');
-INSERT IGNORE INTO mime VALUES (124, 'mpg', '', 'mpg', 'mpg');
-INSERT IGNORE INTO mime VALUES (125, 'avi', '', 'avi', 'avi');
-INSERT IGNORE INTO mime VALUES (126, 'asf', '', 'asf', 'asf');
-INSERT IGNORE INTO mime VALUES (127, 'asx', '', 'asx', 'asx');
-INSERT IGNORE INTO mime VALUES (128, 'mpeg', '', 'mpeg', 'mpeg');
-INSERT IGNORE INTO mime VALUES (129, 'mpe', '', 'mpe', 'mpe');
-INSERT IGNORE INTO mime VALUES (130, 'fla', '', 'fla', 'fla');
-INSERT IGNORE INTO mime VALUES (131, 'zip', '', 'zip', 'zip');
-INSERT IGNORE INTO mime VALUES (132, 'arc', '', 'arc', 'arc');
-INSERT IGNORE INTO mime VALUES (133, 'arj', '', 'arj', 'arj');
-INSERT IGNORE INTO mime VALUES (134, 'rar', '', 'rar', 'rar');
-INSERT IGNORE INTO mime VALUES (135, 'tar', '', 'tar', 'tar');
-INSERT IGNORE INTO mime VALUES (136, 'tgz', '', 'tgz', 'tgz');
-INSERT IGNORE INTO mime VALUES (137, 'gz', '', 'gz', 'gz');
-INSERT IGNORE INTO mime VALUES (138, 'cab', '', 'cab', 'cab');
-INSERT IGNORE INTO mime VALUES (139, 'lzh', '', 'lzh', 'lzh');
-INSERT IGNORE INTO mime VALUES (140, 'ace', '', 'ace', 'ace');
-INSERT IGNORE INTO mime VALUES (141, 'uu', '', 'uu', 'uu');
-INSERT IGNORE INTO mime VALUES (142, 'uue', '', 'uue', 'uue');
-INSERT IGNORE INTO mime VALUES (143, 'hqx', '', 'hqx', 'hqx');
-INSERT IGNORE INTO mime VALUES (144, 'sit', '', 'sit', 'sit');
-INSERT IGNORE INTO mime VALUES (145, 'z', '', 'z', 'z');
-INSERT IGNORE INTO mime VALUES (146, 'bz', '', 'bz', 'bz');
-INSERT IGNORE INTO mime VALUES (147, 'bz2', '', 'bz2', 'bz2');
-INSERT IGNORE INTO mime VALUES (148, 'zoo', '', 'zoo', 'zoo');
-INSERT IGNORE INTO mime VALUES (149, 'scr', '', 'scr', 'scr');
-INSERT IGNORE INTO mime VALUES (150, 'dll', '', 'dll', 'dll');
-INSERT IGNORE INTO mime VALUES (151, 'exe', '', 'exe', 'exe');
-INSERT IGNORE INTO mime VALUES (152, 'com', '', 'com', 'com');
-INSERT IGNORE INTO mime VALUES (153, 'vbx', '', 'vbx', 'vbx');
-INSERT IGNORE INTO mime VALUES (154, 'vxd', '', 'vxd', 'vxd');
-INSERT IGNORE INTO mime VALUES (155, 'ocx', '', 'ocx', 'ocx');
-INSERT IGNORE INTO mime VALUES (156, 'bin', '', 'bin', 'bin');
-INSERT IGNORE INTO mime VALUES (157, 'cpl', '', 'cpl', 'cpl');
-INSERT IGNORE INTO mime VALUES (158, 'drv', '', 'drv', 'drv');
-INSERT IGNORE INTO mime VALUES (159, 'out', '', 'out', 'out');
-INSERT IGNORE INTO mime VALUES (160, 'msi', '', 'msi', 'msi');
-INSERT IGNORE INTO mime VALUES (161, 'pif', '', 'pif', 'pif');
-INSERT IGNORE INTO mime VALUES (162, 'lnk', '', 'lnk', 'lnk');
-INSERT IGNORE INTO mime VALUES (163, 'sys', '', 'sys', 'Fichier Système');
-INSERT IGNORE INTO mime VALUES (164, 'fon', '', 'fon', 'fon');
-INSERT IGNORE INTO mime VALUES (165, 'ttf', '', 'ttf', 'ttf');
-# --------------------------------------------------------
 
 #

install/scripts/upgrades/0.9.1.sh

@@ -15 +15 @@
 override_f=${override_d}.conf
 
+. /etc/alternc/local.sh
+if [ -z "$MYSQL_HOST" ]
+then
+    MYSQL_HOST="localhost"
+fi
+
 # imprime le nom d'usager associé au domaine
 get_account_by_domain() {
@@ -26 +32 @@
                 # implantons localement ce que nous avons besoin, puisque admintools
                 # n'est pas là
-                . /etc/alternc/local.sh
-                mysql -u$MYSQL_USER -p$MYSQL_PASS -D$MYSQL_DATABASE -B -N -e \
+                mysql -h$MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASS -D$MYSQL_DATABASE -B -N -e \
                 'SELECT a.login FROM membres a, sub_domaines b WHERE a.uid = b.compte AND \
                 CONCAT(IF(sub="", "", CONCAT(sub, ".")), domaine) = "'$1'" LIMIT 1;'
@@ -62 +67 @@
 }
 
-echo -n adding open_base_dir protection for:
+echo -n "adding open_base_dir protection for: "
 # boucle sur tous les domaines hébergés
 for i in `find /var/alternc/dns -type l`
@@ -101 +106 @@
 
 echo .
+echo "Done."
+
+echo -n "Dropping unused mime table"
+mysql -h$MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASS -D$MYSQL_DATABASE -B -N -e 'DROP TABLE mime;'
+echo "Done."
+
+