To check out this repository please hg clone the following URL, or open the URL using EasyMercurial or your preferred Mercurial client.
root / vendor / plugins / classic_pagination / test / fixtures / schema.sql @ 442:753f1380d6bc
History | View | Annotate | Download (948 Bytes)
| 1 |
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 |
); |