diff options
| author | Nicolas Lœuillet <nicolas.loeuillet@gmail.com> | 2013-12-23 02:28:56 -0800 |
|---|---|---|
| committer | Nicolas Lœuillet <nicolas.loeuillet@gmail.com> | 2013-12-23 02:28:56 -0800 |
| commit | 60fc4f4b1ab37fbfe9021f3fa1395d66a4424ed2 (patch) | |
| tree | 515c4b9c8286ae363f77722c91acb878151dc386 /install/postgres.sql | |
| parent | cbfd5a1019f47fadefd8490dae9f039ae894298d (diff) | |
| parent | da5fc42f615eeb45a702604970f94967507fb432 (diff) | |
| download | wallabag-60fc4f4b1ab37fbfe9021f3fa1395d66a4424ed2.tar.gz wallabag-60fc4f4b1ab37fbfe9021f3fa1395d66a4424ed2.tar.zst wallabag-60fc4f4b1ab37fbfe9021f3fa1395d66a4424ed2.zip | |
Merge pull request #363 from inthepoche/dev1.3.0
poche 1.3.0
Diffstat (limited to 'install/postgres.sql')
| -rw-r--r-- | install/postgres.sql | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/install/postgres.sql b/install/postgres.sql index 9e0e8276..fe8f559c 100644 --- a/install/postgres.sql +++ b/install/postgres.sql | |||
| @@ -27,4 +27,15 @@ CREATE TABLE users_config ( | |||
| 27 | user_id integer NOT NULL, | 27 | user_id integer NOT NULL, |
| 28 | name varchar(255) NOT NULL, | 28 | name varchar(255) NOT NULL, |
| 29 | value varchar(255) NOT NULL | 29 | value varchar(255) NOT NULL |
| 30 | ); \ No newline at end of file | 30 | ); |
| 31 | |||
| 32 | CREATE TABLE tags ( | ||
| 33 | id bigserial primary key, | ||
| 34 | value varchar(255) NOT NULL | ||
| 35 | ); | ||
| 36 | |||
| 37 | CREATE TABLE tags_entries ( | ||
| 38 | id bigserial primary key, | ||
| 39 | entry_id integer NOT NULL, | ||
| 40 | tag_id integer NOT NULL | ||
| 41 | ) \ No newline at end of file | ||