Fix initialization SQL

diff --git a/tables.sql b/tables.sql
index d3554bc..9335981 100644 (file)
--- a/tables.sql
+++ b/tables.sql
@@ -20,19 +20,23 @@ CREATE TABLE WebUser(
 CREATE SEQUENCE WebUserSeq START 1;
 
 INSERT INTO WebUser
-       (id, name, bal) VALUES
-       (0, 'adam', 0);
+       (id, name, rname, bal, joined) VALUES
+       (0, 'adam', 'Adam Chlipala', 0, CURRENT_TIMESTAMP);
 
 CREATE TABLE WebGroup(
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL);
 
-CREATE SEQUENCE WebGroupSeq START 4;
+CREATE SEQUENCE WebGroupSeq START 2;
 
 INSERT INTO WebGroup
        (id, name) VALUES
        (0, 'root');
 
+INSERT INTO WebGroup
+       (id, name) VALUES
+       (1, 'paying');
+
 CREATE TABLE Membership(
        grp INTEGER NOT NULL,
        usr INTEGER NOT NULL,
@@ -44,6 +48,10 @@ INSERT INTO Membership
        (grp, usr) VALUES
        (0, 0);
 
+INSERT INTO Membership
+       (grp, usr) VALUES
+       (1, 0);
+
 CREATE TABLE Transaction(
        id INTEGER PRIMARY KEY,
        descr TEXT NOT NULL,