<?
include "config.php";
$criar_tabela = mysql_query("
CREATE TABLE perfil (
id INT( 25 ) NOT NULL AUTO_INCREMENT ,
uid VARCHAR( 75 ) NOT NULL ,
member_id INT( 25 ) NOT NULL,
relacionamento TEXT NOT NULL ,
aniversario TEXT NULL ,
view_mail INT( 1 ) NOT NULL ,
animais TEXT NOT NULL ,
site TEXT NOT NULL ,
cidade TEXT NOT NULL ,
estado TEXT NOT NULL,
pais TEXT NOT NULL,
views INT( 75 ) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;", $db);
$criar_tabelaa = mysql_query("
CREATE TABLE perfil_animais (
id INT( 25 ) NOT NULL AUTO_INCREMENT ,
uid VARCHAR( 75 ) NOT NULL ,
member_id INT( 25 ) NOT NULL,
nome TEXT NOT NULL ,
aniversario TEXT NULL ,
adora TEXT NOT NULL ,
odeia TEXT NOT NULL ,
sexo TEXT NOT NULL ,
cidade TEXT NOT NULL,
estado TEXT NOT NULL,
pais TEXT NOT NULL,
views INT( 75 ) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;", $db);
$criar_tabelaaa = mysql_query("
CREATE TABLE maximo (
quantidade int(7) NOT NULL default '1',
data date NOT NULL default '0000-00-00',
hora time NOT NULL default '00:00:00'
) TYPE=MyISAM;", $db);
$criar_tabelaaaa = mysql_query("
CREATE TABLE usersonline (
id int(7) NOT NULL auto_increment,
ip varchar(255) NOT NULL default '',
TIME int(12) NOT NULL default '0',
local varchar(255) NOT NULL default '',
user_id varchar(50) NOT NULL default '',
) TYPE=MyISAM;", $db);
if ( $criar_tabela == 1 ) {
echo "Tabela de perfis criada com sucesso.<br />";
} else {
echo mysql_error($db);
}
if ( $criar_tabelaa == 1 ) {
echo "Tabela de perfis animais criada com sucesso.<br />";
} else {
echo mysql_error($db);
}
if ( $criar_tabelaaa == 1 ) {
echo "Tabela de maximo criada com sucesso.<br />";
} else {
echo mysql_error($db);
}
if ( $criar_tabelaaaa == 1 ) {
echo "Tabela de online criada com sucesso.<br />";
} else {
echo mysql_error($db);
}
mysql_query("INSERT INTO `maximo` VALUES (1, '2005-06-04', '09:00:00');");
?>O erro que ele retorna é:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 7
E eu não consigo arrumar =S
O que está errado?
