<?php
//date_default_timezone_set("Asia/Shanghai");
/*
function create_siteinfo
DONE: Website Information Table
Author:
DATE:2010-3-30
Table structure:
title website name
keyword website keywords
description website description
*/
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("Delete table siteinfo failed!");
mysql_query($sql,$conn)or die("Create table siteinfo failed!");
}
/*
function:create_article()
DONE:mysql create article table sql statement
Author:
Table structure:
id Article ID
cid attribute category ID
abstract article summary
title
posttime Publish time
aurhor
comefrom Article source
comeurl Source URL
content content
keyword keyword
rank article level
views
*/
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("Delete the database failed!");
mysql_query($sql,$conn)or die("Create a database failed!");
}
/*
function:create_member()
DONE:mysql create membership table sql statement
Author:
uid member ID
u_name Member Name
u_passwd password
rank membership level
*/
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("Delete the database failed!");
mysql_query($sql,$conn)or die("Create a database failed!");
}
/*
function:create_class
DONE:sql creates a classified sql statement
Author:
Table structure:
cid class category ID
cname class name
*/
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("delete".$table_class." Failed!");
mysql_query($sql,$conn)or die("Create table".$table_class." Failed");
}
/*
function:create_guest
DONE:sql create message board sql statement
Author:
Table structure:
gid message ID
g_name Message Username
g_site user's personal homepage
g_mail user mailbox
g_cid message location (which article or message board)
*/
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("Delete table".$table_guest." Failed");
mysql_query($sql,$conn)or die("Create table".$table_guest." Failed");
}
function create_sql()
{
global $table_article,$table_member,$table_class,$table_guest,$conn;
echo "Create siteinfo table\r...";
create_siteinfo();
echo "Complete<br>";
echo "Create".$table_article."Table\r...";
create_article();
echo "Complete<br>";
echo "Create".$table_member."Table\r...";
create_member();
echo "Complete<br>";
echo "Create".$table_class."Table\r...";
create_class();
echo "Complete<br>";
echo "Create".$table_guest."Table\r...";
create_guest();
echo "Complete<br>";
mysql_close($conn);
}
?>