aboutsummaryrefslogtreecommitdiffhomepage
path: root/install/postgres.sql
diff options
context:
space:
mode:
authorNicolas LÅ“uillet <nicolas@loeuillet.org>2015-01-21 14:45:39 +0100
committerNicolas LÅ“uillet <nicolas@loeuillet.org>2015-01-21 14:45:39 +0100
commit19875ef0dad9999f91e6f8d780756e402b5e6722 (patch)
tree169b887df1bf71f7ceb0be54447b11be8765e431 /install/postgres.sql
parent00fcfd299b7a1aa5177c97d2b13c0d9d587678e5 (diff)
downloadwallabag-19875ef0dad9999f91e6f8d780756e402b5e6722.tar.gz
wallabag-19875ef0dad9999f91e6f8d780756e402b5e6722.tar.zst
wallabag-19875ef0dad9999f91e6f8d780756e402b5e6722.zip
add install script after composer install
Diffstat (limited to 'install/postgres.sql')
-rw-r--r--install/postgres.sql41
1 files changed, 0 insertions, 41 deletions
diff --git a/install/postgres.sql b/install/postgres.sql
deleted file mode 100644
index 1d73dfcb..00000000
--- a/install/postgres.sql
+++ /dev/null
@@ -1,41 +0,0 @@
1CREATE TABLE IF NOT EXISTS config (
2 id bigserial primary key,
3 name varchar(255) NOT NULL,
4 value varchar(255) NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS entries (
8 id bigserial primary key,
9 title varchar(255) NOT NULL,
10 url varchar(255) NOT NULL,
11 is_read boolean DEFAULT false,
12 is_fav boolean DEFAULT false,
13 content TEXT,
14 user_id integer NOT NULL
15);
16
17CREATE TABLE IF NOT EXISTS users (
18 id bigserial primary key,
19 username varchar(255) NOT NULL,
20 password varchar(255) NOT NULL,
21 name varchar(255) NOT NULL,
22 email varchar(255) NOT NULL
23);
24
25CREATE TABLE IF NOT EXISTS users_config (
26 id bigserial primary key,
27 user_id integer NOT NULL,
28 name varchar(255) NOT NULL,
29 value varchar(255) NOT NULL
30);
31
32CREATE TABLE IF NOT EXISTS tags (
33 id bigserial primary key,
34 value varchar(255) NOT NULL
35);
36
37CREATE TABLE IF NOT EXISTS tags_entries (
38 id bigserial primary key,
39 entry_id integer NOT NULL,
40 tag_id integer NOT NULL
41)