www.pudn.com > BBS.rar > bbs.sql


create database bbs; 
 
use bbs; 
 
create table article  
( 
id int primary key auto_increment, 
pid int, 
rootid int, 
title varchar(255), 
cont text, 
pdate datetime, 
isleaf int #1-not leaf 0-leaf 
); 
 
insert into article values (null, 0, 1, '蚂蚁大战大象', '蚂蚁大战大象', now(), 1); 
insert into article values (null, 1, 1, '大象被打趴下了', '大象被打趴下了',now(), 1); 
insert into article values (null, 2, 1, '蚂蚁也不好过','蚂蚁也不好过', now(), 0); 
insert into article values (null, 2, 1, '瞎说', '瞎说', now(), 1); 
insert into article values (null, 4, 1, '没有瞎说', '没有瞎说', now(), 0); 
insert into article values (null, 1, 1, '怎么可能', '怎么可能', now(), 1); 
insert into article values (null, 6, 1, '怎么没有可能', '怎么没有可能', now(), 0); 
insert into article values (null, 6, 1, '可能性是很大的', '可能性是很大的', now(), 0); 
insert into article values (null, 2, 1, '大象进医院了', '大象进医院了', now(), 1); 
insert into article values (null, 9, 1, '护士是蚂蚁', '护士是蚂蚁', now(), 0);