#--数据表td_guestbookCREATE 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留言
mysql 中导入这段sql没反映啊
`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留言
mysql 中导入这段sql没反映啊
`id` BIGINT(10) DEFAULT '0 ' NOT NULL AUTO_INCREMENT, ===>`id` BIGINT(10) 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, ===>`id` INT(2) 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`)
);