Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 3546:0d7d4a94a467
# add
| author | OOTANI Hiroyuki <c115036@g.koeki-u.ac.jp> |
|---|---|
| date | Fri, 29 Sep 2017 14:27:17 +0900 |
| parents | eeb5fcbe8326 |
| children | 22c406eb8eb8 |
| files | event/oasis2017/idol/name.rb |
| diffstat | 1 files changed, 4 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- 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)")
