Mercurial > hgrepos > hgweb.cgi > skipweb

changeset 3444:1cba3ac996ea

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add UNIQUEÀ©Ìó
author OOTANI Hiroyuki <c115036@g.koeki-u.ac.jp>
date Fri, 28 Jul 2017 12:36:03 +0900
parents f30c435a13b2
children 0574b524a200
files event/oasis2017/ikusei/daizu.rb event/oasis2017/ikusei/kayaku4.rb event/oasis2017/ikusei/me.rb event/oasis2017/ikusei/neko.rb event/oasis2017/ikusei/tamago.rb
diffstat 5 files changed, 6 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/event/oasis2017/ikusei/daizu.rb	Fri Jul 28 12:29:37 2017 +0900
+++ b/event/oasis2017/ikusei/daizu.rb	Fri Jul 28 12:36:03 2017 +0900
@@ -40,7 +40,7 @@
 db.execute("CREATE TABLE IF NOT EXISTS " +
            "users(id text primary key, name text, creation text)")
 db.execute("CREATE TABLE IF NOT EXISTS " +
-           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id))")
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id),UNIQUE(id, keyword))")
 
 
 if form_seikai > "" && id > ''# ã‚‚ã—正解ã—ãŸã‚‰
--- a/event/oasis2017/ikusei/kayaku4.rb	Fri Jul 28 12:29:37 2017 +0900
+++ b/event/oasis2017/ikusei/kayaku4.rb	Fri Jul 28 12:36:03 2017 +0900
@@ -42,7 +42,7 @@
 db.execute("CREATE TABLE IF NOT EXISTS " +
            "users(id text primary key, name text, creation text)")
 db.execute("CREATE TABLE IF NOT EXISTS " +
-           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id))")
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id),UNIQUE(id, keyword))")
 
 
 if form_seikai > "" && id > ''# ã‚‚ã—正解ã—ãŸã‚‰
--- a/event/oasis2017/ikusei/me.rb	Fri Jul 28 12:29:37 2017 +0900
+++ b/event/oasis2017/ikusei/me.rb	Fri Jul 28 12:36:03 2017 +0900
@@ -41,7 +41,7 @@
 db.execute("CREATE TABLE IF NOT EXISTS " +
            "users(id text primary key, name text, creation text)")
 db.execute("CREATE TABLE IF NOT EXISTS " +
-           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id))")
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id),UNIQUE(id, keyword))")
 
 
 if form_seikai > "" && id > ''# ã‚‚ã—正解ã—ãŸã‚‰
--- a/event/oasis2017/ikusei/neko.rb	Fri Jul 28 12:29:37 2017 +0900
+++ b/event/oasis2017/ikusei/neko.rb	Fri Jul 28 12:36:03 2017 +0900
@@ -1,4 +1,4 @@
-#!/usr/bin/env ruby
+!/usr/bin/env ruby
 # -*- coding: utf-8 -*- 
 Encoding.default_internal = "UTF-8"
 Encoding.default_external = "UTF-8"
@@ -40,7 +40,7 @@
 db.execute("CREATE TABLE IF NOT EXISTS " +
            "users(id text primary key, name text, creation text)")
 db.execute("CREATE TABLE IF NOT EXISTS " +
-           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id))")
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id),UNIQUE(id, keyword))")
 
 
 if form_seikai > "" && id > ''# ã‚‚ã—正解ã—ãŸã‚‰
--- a/event/oasis2017/ikusei/tamago.rb	Fri Jul 28 12:29:37 2017 +0900
+++ b/event/oasis2017/ikusei/tamago.rb	Fri Jul 28 12:36:03 2017 +0900
@@ -40,7 +40,7 @@
 db.execute("CREATE TABLE IF NOT EXISTS " +
            "users(id text primary key, name text, creation text)")
 db.execute("CREATE TABLE IF NOT EXISTS " +
-           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id))")
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id),UNIQUE(id, keyword))")
 
 
 if form_seikai > "" && id > ''# ã‚‚ã—正解ã—ãŸã‚‰

yatex.org