# HG changeset patch # User OOTANI Hiroyuki # Date 1506662837 -32400 # Node ID 5f275c36c66051a7edbc47244dbc5290403a7f08 # Parent ac27a57656278c78119b16ac1f268c679d349325 # add diff -r ac27a5765627 -r 5f275c36c660 event/oasis2017/idol/name.rb --- a/event/oasis2017/idol/name.rb Fri Sep 29 14:22:31 2017 +0900 +++ b/event/oasis2017/idol/name.rb Fri Sep 29 14:27:17 2017 +0900 @@ -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)")