From 6318df0e5c5f8198f7003cd2e6fe8a269ecce341 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Thu, 17 Nov 2005 19:04:18 +0100
Subject: more multiuser schema fixes

---
 schema/ttrss_schema_pgsql.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 8bd8221de..407b3647c 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -13,11 +13,13 @@ create table ttrss_users (id serial primary key,
 	access_level integer not null default 0);
 
 insert into ttrss_users (login,pwd_hash,access_level) values ('admin', 'password', 10);
+insert into ttrss_users (login,pwd_hash,access_level) values ('user-1', 'password1', 0);
+insert into ttrss_users (login,pwd_hash,access_level) values ('user-2', 'password2', 0);
 
 create table ttrss_feeds (id serial not null primary key,
 	owner_uid integer not null references ttrss_users(id) on delete cascade,
-	title varchar(200) not null unique, 
-	feed_url varchar(250) unique not null, 
+	title varchar(200) not null, 
+	feed_url varchar(250) not null, 
 	icon_url varchar(250) not null default '',
 	update_interval integer not null default 0,
 	purge_interval integer not null default 0,
-- 
cgit v1.2.3-54-g00ecf

