mybbs.sql

来自「JSP源码-5。」· SQL 代码 · 共 20 行

CREATE TABLE mybbs (
        idx			int				NOT NULL,
        name		varchar(16)		NOT NULL,
        email		varchar(64)		DEFAULT '',
		password	varchar(16)		DEFAULT '',

		moment		datetime,
		html		int				DEFAULT 0,
		title		varchar(96)		NOT NULL,
		content		text			NOT NULL,
		count		int				DEFAULT 0,
		filename		varchar(255)	DEFAULT '',
		filesize		int				DEFAULT 0,

		ref				int				NOT NULL,
		step			int				DEFAULT 0,
		re_level		int				DEFAULT 0,

        PRIMARY KEY(idx)
);