bibi

<?





$bdd = mysql_connect("localhost","root","");



$req = mysql_query('CREATE DATABASE testons') or die ("Erreur");



if($req)

{

	echo "Création de la base ..... OK\r\n";

	/*mysql_select_db("testons",$bdd) or die("erreur de connexion à la base");*/

	$fd = fopen("projet.sql","r");

	$buffer = "";

	  while (!feof ($fd)) {

   			$buffer .= fgets($fd, 4096);

   			}



   			$requete = explode(";",$buffer);

			mysql_select_db("testons",$bdd) or die("erreur de connexion a la base");

   			for($i=0;$i<count($requete)-1;$i++)

   			{

   				$req = mysql_query($requete[$i]) or die(mysql_error());

   			}

}

DROP TABLE IF EXISTS `level`; CREATE TABLE `level` ( `NumLevel` tinyint(3) unsigned NOT NULL , `NomLevel` varchar(20) NOT NULL default '', PRIMARY KEY (`NumLevel`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `NumUser` tinyint(3) unsigned NOT NULL auto_increment, `NomUser` varchar(20) NOT NULL default '', `PassUser` varchar(150) NOT NULL default '', `MailUser` varchar(50) NOT NULL, `LevelUser` tinyint(3) NOT NULL default '1', `DateinsUser` varchar(20) NOT NULL default '', PRIMARY KEY (`NumUser`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `commfic`; CREATE TABLE `commfic` ( `NumComFic` int(10) unsigned NOT NULL default '0', `DateComFic` varchar(20) NOT NULL default '', `NomPosteur` varchar(11) NOT NULL default '0', `Texte` text NOT NULL default '', `NumFichier` int(10) unsigned NOT NULL, `NoteComFic` tinyint(2), PRIMARY KEY (`NumComFic`) ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `fichier`; CREATE TABLE `fichier` ( `NumFichier` tinyint(3) unsigned NOT NULL auto_increment, `NomFichier` varchar(20) NOT NULL default '', `DescrFichier` varchar(200), `GroupeFichier` tinyint(3) NOT NULL default '', `NumUserFichier` tinyint(3) NOT NULL default '', `NumtypeFichier` tinyint(3) NOT NULL, `DateFichier` varchar(20) NOT NULL default '', `NumetatFichier` tinyint(3) NOT NULL, PRIMARY KEY (`NumFichier`) ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `typefichier`; CREATE TABLE `typefichier` ( `Numtype` tinyint(3) unsigned NOT NULL auto_increment, `Nomtype` varchar(20) NOT NULL default '', PRIMARY KEY (`Numtype`) ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `typeetat`; CREATE TABLE `typeetat` ( `NumEtat` tinyint(3) unsigned NOT NULL auto_increment, `NomEtat` varchar(20) NOT NULL default '', PRIMARY KEY (`NumEtat`) ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `messageprive`; CREATE TABLE `messageprive` ( `NumMessagePrive` tinyint(3) unsigned NOT NULL auto_increment, `SujetMessagePrive` varchar(40) NOT NULL default '', `ExpMessagePrive` varchar(20) NOT NULL default '', `DestMessagePrive` varchar(20) NOT NULL default '', `CorpsMessagePrive` text NOT NULL default '', `DateMessagePrive` varchar(20) NOT NULL default '', PRIMARY KEY (`NumMessagePrive`) ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `groupe`; CREATE TABLE `groupe` ( `NumGroupe` tinyint(3) unsigned NOT NULL auto_increment, `NomGroupe` varchar(20) NOT NULL default '', `DescrGroupe` varchar(200), `OwnerGroupe` varchar(20) NOT NULL default '', `DateGroupe` varchar(20) NOT NULL default '', PRIMARY KEY (`NumGroupe`) ) TYPE=MyISAM AUTO_INCREMENT=1; DROP TABLE IF EXISTS `groupuser`; CREATE TABLE `groupuser` ( `NumUser` tinyint(3) unsigned NOT NULL, `NumGroupe` tinyint(3) unsigned NOT NULL, PRIMARY KEY(`NumUser`,`NumGroupe`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `typeext`; CREATE TABLE `typeext`( `NumExt` tinyint(3) unsigned NOT NULL auto_increment, `NumTypeExt` tinyint(3) NOT NULL, `NomExt` varchar(5) NOT NULL, PRIMARY KEY(`NumExt`) ) TYPE=MyISAM AUTO_INCREMENT=1; # -------------------------------------------------------- # # Structure de la table `message` # # Création: Lundi 02 Février 2004 à 18:28 # Dernière modification: Lundi 02 Février 2004 à 18:37 # DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `NumMsg` int(10) unsigned NOT NULL auto_increment, `Date` varchar(20) NOT NULL default '', `NumUser` int(11) NOT NULL default '0', `Texte` text NOT NULL default '', `Image` varchar(250), `Titre` varchar(40), PRIMARY KEY (`NumMsg`) ) TYPE=MyISAM AUTO_INCREMENT=1; # -------------------------------------------------------- # # Structure de la table `commentaire` # # Création: Lundi 02 Février 2004 à 18:28 # Dernière modification: Lundi 02 Février 2004 à 18:37 # DROP TABLE IF EXISTS `commentaire`; CREATE TABLE `commentaire` ( `NumCom` int(10) unsigned NOT NULL default '0', `Date` varchar(20) NOT NULL default '', `NomPosteur` varchar(11) NOT NULL default '0', `Texte` text NOT NULL default '', `NumMsg` int(10) unsigned NOT NULL, PRIMARY KEY (`NumCom`) ) TYPE=MyISAM; # -------------------------------------------------------- INSERT INTO `typeetat` VALUES (1, 'En attente'); INSERT INTO `typeetat` VALUES (2, 'Validé'); INSERT INTO `typeetat` VALUES (3, 'Refusé'); INSERT INTO `level` VALUES (1, 'Utilisateur'); INSERT INTO `level` VALUES (6, 'Posteur'); INSERT INTO `level` VALUES (15, 'Administrateur'); INSERT INTO `level` VALUES (90, 'Dieu'); INSERT INTO `typefichier` VALUES (1, 'Image'); INSERT INTO `typefichier` VALUES (2, 'Texte'); INSERT INTO `typefichier` VALUES (3, 'Vidéo'); INSERT INTO `typefichier` VALUES (4, 'Application'); INSERT INTO `typefichier` VALUES (5, 'Archive'); INSERT INTO `typefichier` VALUES (6, 'Autre'); INSERT INTO `typeext` VALUES (1, 1, 'jpg'); INSERT INTO `typeext` VALUES (2, 1, 'jpeg'); INSERT INTO `typeext` VALUES (3, 1, 'png'); INSERT INTO `typeext` VALUES (4, 1, 'gif'); INSERT INTO `typeext` VALUES (5, 1, 'bmp'); INSERT INTO `typeext` VALUES (6, 1, 'tiff'); INSERT INTO `typeext` VALUES (7, 2, 'txt'); INSERT INTO `typeext` VALUES (8, 2, 'sql'); INSERT INTO `typeext` VALUES (9, 2, 'php'); INSERT INTO `typeext` VALUES (10, 2, 'html'); INSERT INTO `typeext` VALUES (11, 3, 'mpg'); INSERT INTO `typeext` VALUES (12, 3, 'mpeg'); INSERT INTO `typeext` VALUES (13, 3, 'avi'); INSERT INTO `typeext` VALUES (14, 3, 'asf'); INSERT INTO `typeext` VALUES (15, 3, 'wmv'); INSERT INTO `typeext` VALUES (16, 3, 'mov'); INSERT INTO `typeext` VALUES (17, 4, 'exe'); INSERT INTO `typeext` VALUES (18, 5, 'zip'); INSERT INTO `typeext` VALUES (19, 5, 'rar'); INSERT INTO `typeext` VALUES (20, 2, 'php3'); INSERT INTO `typeext` VALUES (21, 2, 'php4'); INSERT INTO `typeext` VALUES (22, 2, 'asp'); INSERT INTO `typeext` VALUES (23, 2, 'cgi'); INSERT INTO `typeext` VALUES (24, 5, 'ace'); INSERT INTO `typeext` VALUES (25, 2, 'php3'); INSERT INTO `typeext` VALUES (26, 2, 'php4'); INSERT INTO `typeext` VALUES (27, 2, 'php5'); INSERT INTO `typeext` VALUES (28, 2, 'cgi'); INSERT INTO `typeext` VALUES (29, 2, 'asp');