From 93fd4692f6eb753cae16358131c8049d84cfbb41 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= Date: Thu, 22 Jan 2015 08:30:07 +0100 Subject: symfony is there --- bin/postgres.sql | 41 ----------------------------------------- 1 file changed, 41 deletions(-) delete mode 100644 bin/postgres.sql (limited to 'bin/postgres.sql') diff --git a/bin/postgres.sql b/bin/postgres.sql deleted file mode 100644 index 1d73dfcb..00000000 --- a/bin/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