note.txt

来自「NTsky新闻发布v1.0(提供JavaBean)」· 文本 代码 · 共 34 行

create database notebook;
use notebook
CREATE TABLE admin (
  admin_name char(20) NOT NULL,
  admin_password char(20) NOT NULL,
  PRIMARY KEY(admin_name)
) TYPE=MyISAM;

create table ip(
  id int NOT NULL auto_increment,
  ip text,
  PRIMARY KEY(id)
);

create table guest(id int NOT NULL auto_increment,
			username char(20) NOT NULL,
			sex char(2) NOT NUll,
			email char(20),
			QQ char(9),
			url char(24),
			title text NOT NULL,
			content text NOT NULL,
			time datetime NOT NULL,
			images text,
			primary key(id)
			)
TYPE=MyISAM;

CREATE TABLE reply (
  replyid int(11) NOT NULL,
  content text,
  time datetime
) TYPE=MyISAM;
insert into admin(admin_name,admin_password) values('admin','admin');