naboard_schema.php

php写的论坛,代码精简到极点 请相看说明文件。是从英文翻译过来的：）

<?
//////////////////////////////////article table
$table="
CREATE TABLE $t[board] ( 
no int(11) DEFAULT '0' NOT NULL auto_increment primary key, 
id varchar(20),
name varchar(50) NOT NULL,
memo text NOT NULL,
home varchar(50),
mail varchar(50),
title varchar(50) NOT NULL,
date int(11),
hit int(11) DEFAULT '0',
pass varchar(250),
ip varchar(20),
cat int(11),
abs int(11) DEFAULT '0' NOT NULL,
step int(11) DEFAULT '0' NOT NULL,
level int(11) DEFAULT '0' NOT NULL,
secret tinyint(1) DEFAULT '0',
html tinyint(1) DEFAULT '0',
remail tinyint(1) DEFAULT '0',
attach_name varchar(50),
attach_size varchar(50),
attach_dir varchar(50),
attach_hit int(11) DEFAULT '0',
attach2_name varchar(50),
attach2_size varchar(50),
attach2_dir varchar(50),
attach2_hit int(11) DEFAULT '0',
link varchar(250),
link_hit int(11) DEFAULT '0',
link2 varchar(250),
link2_hit int(11) DEFAULT '0',
image varchar(50),
vote int(11) DEFAULT '0',
KEY pos(abs,step,level)
)";
@mysql_query($table,$connect);

//////////////////////////////////comment table
$table="
CREATE TABLE $t[com] ( 
comno int(11) DEFAULT '0' NOT NULL auto_increment primary key,
id varchar(20),
no int(11),
name varchar(20),
memo text,
pass varchar(250),
ip varchar(20),
date int(11)
)"; 
@mysql_query($table,$connect);

//////////////////////////////////category table
$table="
CREATE TABLE $t[cat] ( 
no int(11) DEFAULT '0' NOT NULL auto_increment primary key, 
name varchar(100)
)"; 
@mysql_query($table,$connect);

//////////////////////////////////To put category
$input="insert into $t[cat] (no,name) values (1,'主讨论区')";
@mysql_query($input,$connect);
$input="insert into $t[cat] (no,name) values (2,'问题解答')";
@mysql_query($input,$connect);

//////////////////////////////////Establishment table
$table="
CREATE TABLE $t[config] ( 
no int(11) DEFAULT '0' NOT NULL auto_increment primary key, 
title varchar(200),
skinname varchar(50) DEFAULT 'navyism',
background_image varchar(200),
background_color varchar(20),
title_length int(4) DEFAULT '40',
name_length int(4) DEFAULT '10', 
page int(2) DEFAULT '15',
pagenum int(2) DEFAULT '10', 
table_width int(4) DEFAULT '80',
width_kind tinyint(1) DEFAULT '0',
best int(11) DEFAULT '0',
show_list tinyint(1) DEFAULT '1', 
default_text text,

cat tinyint(1) DEFAULT '0',
cat_on tinyint(1) DEFAULT '0',

use_ban_tag tinyint(1) DEFAULT '1',
use_ban_word tinyint(1) DEFAULT '1',
use_ban_ip tinyint(1) DEFAULT '0',
use_ban_server tinyint(1) DEFAULT '0',
show_ip tinyint(1) DEFAULT '0',

attach tinyint(1) DEFAULT '0',
attach_title varchar(20) DEFAULT '附件',
can_attach varchar(255) DEFAULT 'zip,arj,tgz,tar.gz,txt,gif,jpg',
cant_attach varchar(255) DEFAULT 'htm,html,php,php3,php4,asp,aspx,cgi,jsp',
attach2 tinyint(1) DEFAULT '0',
attach_title2 varchar(20) DEFAULT '图像',
can_attach2 varchar(255) DEFAULT 'zip,arj,tgz,tar.gz,txt,gif,jpg',
cant_attach2 varchar(255) DEFAULT 'htm,html,php,php3,php4,asp,aspx,cgi,jsp',
image_size int(3) DEFAULT '300',
link tinyint(1) DEFAULT '0',
link2 tinyint(1) DEFAULT '0',

top_url varchar(50),
top text,
bottom_url varchar(50),
bottom text,

auth_list tinyint(1) DEFAULT '10',
auth_read tinyint(2) DEFAULT '10',
auth_write tinyint(2) DEFAULT '10',
auth_reply tinyint(2) DEFAULT '10',
auth_comment tinyint(2) DEFAULT '10',
auth text
)"; 
@mysql_query($table,$connect);

//////////////////////////////////To put establishment
$input="insert into $t[config] (no,auth) values (1,'$HTTP_COOKIE_VARS[$member_cookie]')";
@mysql_query($input,$connect);
?>