Allow users to create an account, confirm it and logout

2 files changed, 6 insertions, 5 deletions

diff --git a/db/rerun_dbic_loader.pl b/db/rerun_dbic_loader.pl
index fa93165de..ed2fd6375 100755
--- a/db/rerun_dbic_loader.pl
+++ b/db/rerun_dbic_loader.pl
@@ -16,7 +16,7 @@ my @tables_to_ignore = (
     'abuse',         'admin_log',       'alert',        'alert_sent',
     'alert_type',    'comment',         'contacts',     'contacts_history',
     'debugdate',     'flickr_imported', 'partial_user', 'problem',
-    'questionnaire', 'secret',          'textmystreet', 
+    'questionnaire', 'secret',          'textmystreet',
 );
 my $exclude = '^(?:' . join( '|', @tables_to_ignore ) . ')$';
 
diff --git a/db/schema_0001.sql b/db/schema_0001.sql
index 1c2bf4ffc..918fdcbc5 100644
--- a/db/schema_0001.sql
+++ b/db/schema_0001.sql
@@ -11,10 +11,11 @@ CREATE TABLE sessions (
 
 -- users table
 create table users (
-    id          serial not null primary key,
-    email       text not null unique,
-    name        text,
-    password    text,
+    id              serial  not null primary key,
+    email           text    not null unique,
+    name            text,
+    password        text,
+    is_confirmed    bool    not null default false
 );
 
 -- add PK to contacts table