<?php
//date_default_timezone_set("Asia/Shanghai");
/*
function create_siteinfo
DONE:網(wǎng)站信息表
Author:www.5dkx.com
DATE:2010-3-30
表結(jié)構(gòu):
title 網(wǎng)站名
keyword 網(wǎng)站關(guān)鍵詞
description 網(wǎng)站描述
*/
function create_siteinfo()
{
global $conn;
$sql = "create table siteinfo (
title varchar(100) not null,
keyword varchar(200) not null,
description varchar(200) not null
)";
$dropsql = "drop table if exists siteinfo";
mysql_query($dropsql,$conn)or die("刪除表siteinfo失敗!");
mysql_query($sql,$conn)or die("創(chuàng)建表siteinfo失敗!");
}
/*
function:create_article()
DONE:mysql創(chuàng)建文章表sql語(yǔ)句
Author:www.5dkx.com
表結(jié)構(gòu):
id 文章ID
cid 歸屬類(lèi)別ID
abstract 文章摘要
title 文章標(biāo)題
posttime 發(fā)布時(shí)間
aurhor 作者
comefrom 文章來(lái)源
comeurl 來(lái)源URL
content 正文內(nèi)容
keyword 關(guān)鍵詞
rank 文章等級(jí)
views 瀏覽次數(shù)
*/
function create_article()
{
global $conn,$table_article;
$sql ="create table $table_article(
id int(11) auto_increment not null,
cid int(5) not null,
abstract varchar(300) not null,
title varchar(50) not null,
posttime datetime not null,
author varchar(30) not null,
comefrom varchar(50) not null,
comeurl varchar(50) not null,
content TEXT not null,
keyword varchar(20) not null,
rank int(2) not null,
views int(5) not null,
PRIMARY KEY(id)
)";
$dropsql = "drop table if exists $table_article";
mysql_query($dropsql,$conn)or die("刪除數(shù)據(jù)庫(kù)失敗!");
mysql_query($sql,$conn)or die("創(chuàng)建數(shù)據(jù)庫(kù)失敗!");
}
/*
function:create_member()
DONE:mysql創(chuàng)建會(huì)員表sql語(yǔ)句
Author:www.5dkx.com
uid 會(huì)員ID
u_name 會(huì)員名稱
u_passwd 密碼
rank 會(huì)員等級(jí)
*/
function create_member()
{
global $conn,$table_member;
$sql = "create table $table_member(
uid int(5) auto_increment not null,
u_name varchar(20) not null UNIQUE,
u_passwd varchar(100) not null,
rank int(2) not null,
PRIMARY KEY(uid)
)";
$dropsql = "drop table if exists $table_member";
mysql_query($dropsql,$conn)or die("刪除數(shù)據(jù)庫(kù)失敗!");
mysql_query($sql,$conn)or die("創(chuàng)建數(shù)據(jù)庫(kù)失敗!");
}
/*
function:create_class
DONE:sql創(chuàng)建分類(lèi)sql語(yǔ)句
Author:www.5dkx.com
表結(jié)構(gòu):
cid 類(lèi)類(lèi)別ID
cname 類(lèi)名
*/
function create_class()
{
global $conn,$table_class;
$sql = "create table $table_class(
cid int(5) auto_increment not null,
cname varchar(50) not null UNIQUE,
PRIMARY KEY(cid)
)";
$dropsql = "drop table if exists $table_class";
mysql_query($dropsql,$conn)or die("刪除".$table_class."失敗!");
mysql_query($sql,$conn)or die("創(chuàng)建表".$table_class."失敗");
}
/*
function:create_guest
DONE:sql創(chuàng)建留言板sql語(yǔ)句
Author:www.5dkx.com
表結(jié)構(gòu):
gid 留言ID
g_name 留言用戶名
g_site 用戶個(gè)人主頁(yè)
g_mail 用戶郵箱
g_cid 留言位置(哪篇文章或者是留言板)
*/
function create_guest()
{
global $conn,$table_guest;
$sql = "create table $table_guest(
gid int(11) auto_increment not null,
g_name varchar(50) not null,
g_site varchar(50) not null,
g_mail varchar(50) not null,
g_cid int(5) not null,
PRIMARY KEY(gid)
)";
$dropsql = "drop table if exists $table_guest";
mysql_query($dropsql,$conn)or die("刪除表".$table_guest."失敗");
mysql_query($sql,$conn)or die("創(chuàng)建表".$table_guest."失敗");
}
function create_sql()
{
global $table_article,$table_member,$table_class,$table_guest,$conn;
echo "創(chuàng)建siteinfo表\r……";
create_siteinfo();
echo "完成<br>";
echo "創(chuàng)建".$table_article."表\r……";
create_article();
echo "完成<br>";
echo "創(chuàng)建".$table_member."表\r……";
create_member();
echo "完成<br>";
echo "創(chuàng)建".$table_class."表\r……";
create_class();
echo "完成<br>";
echo "創(chuàng)建".$table_guest."表\r……";
create_guest();
echo "完成<br>";
mysql_close($conn);
}
?>