sqldump.sql

来自「新闻发布系统」· SQL 代码 · 共 16 行

# News table
CREATE TABLE fubonews(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
subject VARCHAR(50) NOT NULL DEFAULT 'No topic.',
news TEXT NOT NULL,
datetime VARCHAR(20) NOT NULL DEFAULT '00/00/00 at 00:00 am'
);

# A test entry :P
INSERT INTO fubonews VALUES(
0,
"Test topic.",
"Test news.  Feel free to delete this entry.",
"00/00/00 at 00:00 am"
);