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 | |
parent | cbfd5a1019f47fadefd8490dae9f039ae894298d (diff) | |
parent | da5fc42f615eeb45a702604970f94967507fb432 (diff) | |
download | wallabag-1.3.0.tar.gz wallabag-1.3.0.tar.zst wallabag-1.3.0.zip |
Merge pull request #363 from inthepoche/dev1.3.0
poche 1.3.0
Diffstat (limited to 'install')
-rw-r--r-- | install/mysql.sql | 17 | ||||
-rwxr-xr-x | install/poche.sqlite | bin | 360448 -> 393216 bytes | |||
-rw-r--r-- | install/postgres.sql | 13 |
3 files changed, 28 insertions, 2 deletions
diff --git a/install/mysql.sql b/install/mysql.sql index 9b01e32c..d16381d8 100644 --- a/install/mysql.sql +++ b/install/mysql.sql | |||
@@ -31,4 +31,19 @@ CREATE TABLE IF NOT EXISTS `users_config` ( | |||
31 | `name` varchar(255) NOT NULL, | 31 | `name` varchar(255) NOT NULL, |
32 | `value` varchar(255) NOT NULL, | 32 | `value` varchar(255) NOT NULL, |
33 | PRIMARY KEY (`id`) | 33 | PRIMARY KEY (`id`) |
34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; \ No newline at end of file | 34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
35 | |||
36 | CREATE TABLE IF NOT EXISTS `tags` ( | ||
37 | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
38 | `value` varchar(255) NOT NULL, | ||
39 | PRIMARY KEY (`id`) | ||
40 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
41 | |||
42 | CREATE TABLE IF NOT EXISTS `tags_entries` ( | ||
43 | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
44 | `entry_id` int(11) NOT NULL, | ||
45 | `tag_id` int(11) NOT NULL, | ||
46 | FOREIGN KEY(entry_id) REFERENCES entries(id) ON DELETE CASCADE, | ||
47 | FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE, | ||
48 | PRIMARY KEY (`id`) | ||
49 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
diff --git a/install/poche.sqlite b/install/poche.sqlite index 7abf1f62..b911f272 100755 --- a/install/poche.sqlite +++ b/install/poche.sqlite | |||
Binary files differ | |||
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 | ||