Tasks/schema.sql

11 lines
209 B
MySQL
Raw Permalink Normal View History

2015-11-13 17:04:42 +08:00
CREATE TABLE task (
id integer primary key autoincrement,
title varchar(100),
content text,
is_deleted char(1) default 'N',
created_date timestamp,
last_modified_at timestamp,
finish_date timestamp
);