紧急求助:数据库表单创建
为什么这样做许多表不能同时创建?我郁闷啊!
<?php
$blog_sqla="create table duoai_type(
id mediumint(8) unsigned not null auto_increment,
name varchar(50) not null,
type varchar(50) not null,
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";
if(mysql_query($blog_sqla)){
echo '分类表单创建成功';
}else{
echo'分类表单创建失败'.mysql_error();
}
$blog_sqlb="create table blog(
id mediumint(8) unsigned not null auto_increment,
name varchar(50) not null,
time varchar(40) not null,
content text not null,
type varchar(50) not null,
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";
if(mysql_query($blog_sqlb)){
echo '日志表单创建成功';
}else{
echo'日志表单创建失败'.mysql_error();
}
$conment_sqlc="create table conment(
id mediumint(8) unsigned not null auto_increment,
nickname varchar(40) not null,
conment text ,
time varchar(40) not null,
rid int(8) unsigned not null,
primary key(id)
) engine=myisam default charset=utf8 auto_increment=1";
if(mysql_query($conment_sqlc)){
exit('conment表单创建成功');
}else{
exit('conment表单创建失败'.mysql_error());}
$createa_sqld="create table chatuser(
id mediumint(8) not null auto_increment,
name varchar(40) not null unique,
password varchar(40) not null,
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";
if(!mysql_query($createa_sqld)){
exit("表单创建失败".mysql_error());
}
$createbe="create table chatinfo(
id mediumint(10) not null auto_increment,
talk text,
time varchar(40) not null,
name varchar(40) not null,
uid varchar(8) not null ,
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";
if(!mysql_query($createbe)){
exit("表单创建失败".mysql_error());}
$createcf="create table chatmsg(
id mediumint(10) not null auto_increment,
sendname varchar(40) not null,
msg text,
time varchar(40) not null,
getname varchar(40) not null,
islook varchar(2) not null default'1',
issenddelete varchar(1) not null default'1',
isgetdelete varchar(1) not null default'1',
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";
if(!mysql_query($createcf)){
exit("表单创建失败".mysql_error());}
$createconmentg="create table album_conment(
id mediumint(8) unsigned not null auto_increment,
nickname varchar(40) not null,
time varchar(20),
conment text not null,
rid varchar(8),
primary key(id)
)engine=myisam auto_increment=1 default charset=utf8";
if(mysql_query($createconmentg)){
echo'表单album_conment创建成功';
}else{
echo'创建失败'.mysql_error();
}
$createtableh="create table album(
id mediumint(8) unsigned not null auto_increment,
name varchar(40) not null,
path text not null,
shuoming text null,
primary key(id)
)engine=myisam auto_increment=1 default charset=utf8";
if(mysql_query($createtableh)){
echo'表单album创建成功';
}else{
echo'创建失败'.mysql_error();
}
$createconmenti="create table upload_conment(
id mediumint(8) unsigned not null auto_increment,
nickname varchar(40) not null,
time varchar(20),
conment text not null,
rid varchar(8),
primary key(id)
)engine=myisam auto_increment=1 default charset=utf8";
if(mysql_query($createconmenti)){
echo'表单upload_conment创建成功';
}else{
echo'创建失败'.mysql_error();
}
$createtablej="create table upload(
id mediumint(8) unsigned not null auto_increment,
name varchar(40) not null,
path text not null,
shuoming text null,
primary key(id)
)engine=myisam auto_increment=1 default charset=utf8";
if(mysql_query($createtablej)){
echo'表单upload创建成功';
}else{
echo'创建失败'.mysql_error();
}
$sqlk="CREATE TABLE liuyan(
id mediumint(8) unsigned not null auto_increment ,
nickname varchar(20) not null default'游客',
liuyan text not null,
liuyantime varchar(40) not null default'0',
qq varchar(10) null default null,
reply text null default null,
reply_time varchar(40) null default null,
primary key(id)
)
engine=myisam default charset=utf8 auto_increment=1";
if(mysql_query($sqlk)){
echo'表单创建成功';
}else{
echo'表单创建失败'.mysql_error();
}
?>