From 8629e09d9b60eda1c4f06d88267287083f8f3ea2 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Tue, 20 Dec 2005 07:23:33 +0100
Subject: schema: add email column to ttrss_users

---
 schema/ttrss_schema_pgsql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index dcb996593..5ddcfe1d7 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -27,6 +27,7 @@ create table ttrss_users (id serial not null primary key,
 	pwd_hash varchar(250) not null,
 	last_login timestamp default null,
 	access_level integer not null default 0,
+	email varchar(250) not null default '',
 	theme_id integer references ttrss_themes(id) default null);
 
 insert into ttrss_users (login,pwd_hash,access_level) values ('admin', 'password', 10);
-- 
cgit v1.2.3

