create.sql

来自「基于ruby的进阶编程,大家可以对照教材<<Ruby on Rail」· SQL 代码 · 共 15 行

drop table if exists works;

create table works (
	id int unsigned not null auto_increment,
	nickname char(20) not null,
	sex  enum('帅哥','靓妹') not null default '帅哥',
	city char(20) null default '未知',
	email varchar(30)  null,
	qq varchar(15) null,
	ip char(15) null,
	thedatetime datetime null,
	title varchar(100) not null default '无标题',
	content text null,
	primary key (id)
);