diff options
Diffstat (limited to 'db')
| -rwxr-xr-x | db/rerun_dbic_loader.pl | 2 | ||||
| -rw-r--r-- | db/schema_0001.sql | 9 |
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 |