To check out this repository please hg clone the following URL, or open the URL using EasyMercurial or your preferred Mercurial client.
root / .svn / pristine / 16 / 16c33740f5a772b206a960577ab56df891c0f33f.svn-base @ 912:5e80956cc792
History | View | Annotate | Download (948 Bytes)
| 1 | 909:cbb26bc654de | Chris | CREATE TABLE 'companies' ( |
|---|---|---|---|
| 2 | 'id' INTEGER PRIMARY KEY NOT NULL, |
||
| 3 | 'name' TEXT DEFAULT NULL, |
||
| 4 | 'rating' INTEGER DEFAULT 1 |
||
| 5 | ); |
||
| 6 | |||
| 7 | CREATE TABLE 'replies' ( |
||
| 8 | 'id' INTEGER PRIMARY KEY NOT NULL, |
||
| 9 | 'content' text, |
||
| 10 | 'created_at' datetime, |
||
| 11 | 'updated_at' datetime, |
||
| 12 | 'topic_id' integer |
||
| 13 | ); |
||
| 14 | |||
| 15 | CREATE TABLE 'topics' ( |
||
| 16 | 'id' INTEGER PRIMARY KEY NOT NULL, |
||
| 17 | 'title' varchar(255), |
||
| 18 | 'subtitle' varchar(255), |
||
| 19 | 'content' text, |
||
| 20 | 'created_at' datetime, |
||
| 21 | 'updated_at' datetime |
||
| 22 | ); |
||
| 23 | |||
| 24 | CREATE TABLE 'developers' ( |
||
| 25 | 'id' INTEGER PRIMARY KEY NOT NULL, |
||
| 26 | 'name' TEXT DEFAULT NULL, |
||
| 27 | 'salary' INTEGER DEFAULT 70000, |
||
| 28 | 'created_at' DATETIME DEFAULT NULL, |
||
| 29 | 'updated_at' DATETIME DEFAULT NULL |
||
| 30 | ); |
||
| 31 | |||
| 32 | CREATE TABLE 'projects' ( |
||
| 33 | 'id' INTEGER PRIMARY KEY NOT NULL, |
||
| 34 | 'name' TEXT DEFAULT NULL |
||
| 35 | ); |
||
| 36 | |||
| 37 | CREATE TABLE 'developers_projects' ( |
||
| 38 | 'developer_id' INTEGER NOT NULL, |
||
| 39 | 'project_id' INTEGER NOT NULL, |
||
| 40 | 'joined_on' DATE DEFAULT NULL, |
||
| 41 | 'access_level' INTEGER DEFAULT 1 |
||
| 42 | ); |