ddl.sql

来自「JSP留言薄.请指教」· SQL 代码 · 共 26 行

#--数据表td_guestbook

CREATE TABLE `td_guestbook` (
`id` BIGINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT, 
`name` VARCHAR(30) NOT NULL, 
`qq` VARCHAR(30) DEFAULT 'no' NOT NULL, 
`email` VARCHAR(100) DEFAULT 'no' NOT NULL, 
`homepage` VARCHAR(100) DEFAULT 'no' NOT NULL, 
`headima` TINYINT(1) DEFAULT '0' NOT NULL, 
`time` BIGINT(19) DEFAULT '0' NOT NULL, 
`content` TEXT NOT NULL,
PRIMARY KEY  (`id`)
);

#--数据表td_guestbook_admin
CREATE TABLE `td_guestbook_admin` (
`id` INT(2) DEFAULT '0' NOT NULL AUTO_INCREMENT, 
`user` VARCHAR(50) NOT NULL, 
`psw` VARCHAR(40) NOT NULL, 
`title` VARCHAR(100) NOT NULL, 
`pageshownumber` INT(4) DEFAULT '15' NOT NULL,
PRIMARY KEY  (`id`)
);


insert into td_guestbook_admin values(1,'admin','565491d704013245','天地网络--JSP留言薄',15);