root/trunk/demo/db/schema.sqlite
| Revision 14, 246 bytes (checked in by jk, 3 years ago) |
|---|
| Line | |
|---|---|
| 1 | drop table contents; |
| 2 | create table contents ( |
| 3 | id INTEGER PRIMARY KEY, |
| 4 | title varchar(100), |
| 5 | description text |
| 6 | ); |
| 7 | |
| 8 | drop table comments; |
| 9 | create table comments ( |
| 10 | id INTEGER PRIMARY KEY, |
| 11 | author varchar(100), |
| 12 | content text, |
| 13 | content_id int |
| 14 | ); |
Note: See TracBrowser for help on using the browser.
