|
- create table Tag
- (
- id integer primary key autoincrement,
- parent_id integer,
- name varchar(127) not null,
- description varchar(127),
- sces blob
- );
-
- create table Scenario
- (
- id integer primary key autoincrement,
- sid varchar(32) not null,
- name varchar(127) not null,
- pic varchar(255),
- map_feature varchar(127),
- method varchar(255),
- standard varchar(255),
- others varchar(255),
- failure varchar(255),
- tags blob,
- date_created integer default (strftime('%s', 'now')) not null
- );
|