Location: PHPKode > projects > Twisty Forum > twisty-forum/installation/install.php
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Installation des tables de Twisty Forum</title>
<link rel="StyleSheet" type="text/css" href="index.css" />
</head>
<body>
<?php
include('coords.inc.php');
include ('haut.inc');
mysql_query("CREATE TABLE IF NOT EXISTS fmess (
id smallint( 6 ) NOT NULL AUTO_INCREMENT,
ind smallint( 6 ) NOT NULL default '0',
f tinyint( 4 ) NOT NULL default '0',
texte text NOT NULL ,
auteur varchar( 15 ) NOT NULL default '',
temps varchar( 14 ) default NULL ,
temps2 varchar( 30 ) NOT NULL default '',
watch char( 3 ) NOT NULL default 'non',
vu text NOT NULL ,
PRIMARY KEY ( `id` ) ,
FULLTEXT KEY `texte` ( `texte` ) 
) TYPE = MYISAM;");


mysql_query("CREATE TABLE IF NOT EXISTS ftitre (
id smallint( 6 ) NOT NULL AUTO_INCREMENT,
f tinyint( 4 ) NOT NULL default '0',
ftitre varchar( 255 ) NOT NULL default '',
titre varchar( 150 ) NOT NULL default '',
temps varchar( 14 ) default NULL ,
temps2 varchar( 30 ) NOT NULL default '',
auteur varchar( 15 ) NOT NULL default '',
premier varchar( 15 ) NOT NULL default '',
reponse tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) 
) TYPE = MYISAM;");

mysql_query("CREATE TABLE IF NOT EXISTS fusers (
id smallint( 6 ) NOT NULL AUTO_INCREMENT,
nom varchar( 15 ) NOT NULL default '',
pass varchar( 10 ) NOT NULL default '',
mail varchar( 150 ) NOT NULL default '',
logo varchar( 200 ) NOT NULL default '',
site varchar( 200 ) NOT NULL default '',
pub char( 3 ) NOT NULL default '',
temps varchar( 14 ) NOT NULL default '',
PRIMARY KEY ( `id` ) 
) TYPE = MYISAM;");

?>

<div style="text-align:center;clear:left"><h3><Les tables ont été installées!</h3>
<p>Twisty Forum est prêt à fonctionner. <img src="<?php echo $racinegif;?>sm10.gif" alt="" /></p>
</div>


<p style="margin-top:50px;color:white;clear:left">
<a class="liensite" href="http://javatwist.imingo.net">© Javatwist 2002</a> - JavaTwisting people
</p>


</body>
</html>
Return current item: Twisty Forum