From 19875ef0dad9999f91e6f8d780756e402b5e6722 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= Date: Wed, 21 Jan 2015 14:45:39 +0100 Subject: add install script after composer install --- install/postgres.sql | 41 ----------------------------------------- 1 file changed, 41 deletions(-) delete mode 100644 install/postgres.sql (limited to 'install/postgres.sql') 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 @@ -CREATE TABLE IF NOT EXISTS config ( - id bigserial primary key, - name varchar(255) NOT NULL, - value varchar(255) NOT NULL -); - -CREATE TABLE IF NOT EXISTS entries ( - id bigserial primary key, - title varchar(255) NOT NULL, - url varchar(255) NOT NULL, - is_read boolean DEFAULT false, - is_fav boolean DEFAULT false, - content TEXT, - user_id integer NOT NULL -); - -CREATE TABLE IF NOT EXISTS users ( - id bigserial primary key, - username varchar(255) NOT NULL, - password varchar(255) NOT NULL, - name varchar(255) NOT NULL, - email varchar(255) NOT NULL -); - -CREATE TABLE IF NOT EXISTS users_config ( - id bigserial primary key, - user_id integer NOT NULL, - name varchar(255) NOT NULL, - value varchar(255) NOT NULL -); - -CREATE TABLE IF NOT EXISTS tags ( - id bigserial primary key, - value varchar(255) NOT NULL -); - -CREATE TABLE IF NOT EXISTS tags_entries ( - id bigserial primary key, - entry_id integer NOT NULL, - tag_id integer NOT NULL -) -- cgit v1.2.3