Added initial user management functions

1 files changed, 8 insertions, 4 deletions

diff --git a/blavote.go b/blavote.go
index f493b1b..4d621b9 100644
--- a/blavote.go
+++ b/blavote.go
@@ -1,5 +1,6 @@
 package main
 
+// import "blavote"
 import "fmt"
 import "github.com/mxk/go-sqlite/sqlite3"
 import "github.com/jessevdk/go-flags"
@@ -55,6 +56,9 @@ func main() {
         addPoll(db, opts.Args.Title, opts.Args.Rest)
     }
 
+    createUser(db, "l_bratch", true)
+    getUserForId(db, 1)
+
 }
 
 func connectDb(name string) (*sqlite3.Conn, error) {
@@ -83,10 +87,10 @@ func initTables(db *sqlite3.Conn) {
    db.Exec("create table info(id int, key text, value text)")
    db.Exec("insert into info (key, value) values('version', '0.01')")
 
-   db.Exec("create table users(id int, name text, admin boolean)")
-   db.Exec("create table polls(id int, text text, user_id int)")
-   db.Exec("create table options(id int, text text, poll_id int)")
-   db.Exec("create table votes(id int, user_id int, poll_id int, option_id int)")
+   db.Exec("create table users(id integer primary key autoincrement, name text, admin boolean)")
+   db.Exec("create table polls(id integer primary key autoincrement, text text, user_id int)")
+   db.Exec("create table options(id integer primary key autoincrement, text text, poll_id int)")
+   db.Exec("create table votes(id integer primary key autoincrement, user_id int, poll_id int, option_id int)")
 
 
 }