diff --git a/event/oasis2017/idol/name.rb b/event/oasis2017/idol/name.rb index 820bef0..fbe4f42 100755 --- a/event/oasis2017/idol/name.rb +++ b/event/oasis2017/idol/name.rb @@ -33,6 +33,10 @@ printf("Set-Cookie: id=%s; expires=%s\n\n", id, expire) db = SQLite3::Database.new("../db/users.sq3") +############# +############# +############# + db.execute("PRAGMA foreign_keys=on") db.execute("CREATE TABLE IF NOT EXISTS " + "users(id text primary key, name text, creation text)")