aboutsummaryrefslogtreecommitdiffhomepage
path: root/install/postgres.sql
diff options
context:
space:
mode:
authorNicolas Frandeboeuf <nicofrand@gmail.com>2013-08-23 22:20:04 +0200
committerNicolas Frandeboeuf <nicofrand@gmail.com>2013-08-23 22:20:04 +0200
commit8413a63f7d9df2695653ab2ef1d77927da6ddc55 (patch)
treef4c28531325c4ae39635c1b9fb856370acf24f0a /install/postgres.sql
parentb64a882696ba6c403c36f9434230fc636741b7d1 (diff)
downloadwallabag-8413a63f7d9df2695653ab2ef1d77927da6ddc55.tar.gz
wallabag-8413a63f7d9df2695653ab2ef1d77927da6ddc55.tar.zst
wallabag-8413a63f7d9df2695653ab2ef1d77927da6ddc55.zip
Clean markup in templates
Diffstat (limited to 'install/postgres.sql')
-rw-r--r--install/postgres.sql30
1 files changed, 0 insertions, 30 deletions
diff --git a/install/postgres.sql b/install/postgres.sql
deleted file mode 100644
index 9e0e8276..00000000
--- a/install/postgres.sql
+++ /dev/null
@@ -1,30 +0,0 @@
1CREATE TABLE config (
2 id bigserial primary key,
3 name varchar(255) NOT NULL,
4 value varchar(255) NOT NULL
5);
6
7CREATE TABLE 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 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 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); \ No newline at end of file