changeset 814:3a62315bc986

pass2 acc name
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Mon, 20 Jul 2015 18:12:31 +0900
parents 985c3be9788b
children b506b3511671
files oasis2015/accountcheck.rb
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb	Mon Jul 20 18:09:17 2015 +0900
+++ b/oasis2015/accountcheck.rb	Mon Jul 20 18:12:31 2015 +0900
@@ -21,11 +21,11 @@
 cle3 = "CREATE TABLE IF NOT EXISTS goods(id, g1, g2, g3, g4, g5, g6)"
 cle4 = "CREATE TABLE IF NOT EXISTS time(cd, now, id)"
 cle5 = "CREATE TABLE IF NOT EXISTS num(cd, id)"
-cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass)"
+cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass, name)"
 
 ins4 = 'insert into time values(?, 61, "n")'
 ins5 = 'insert into num values("aa",0)'
-ins6 = 'insert into pass values(?, ?)'
+ins6 = 'insert into pass values(?, ?, ?)'
 num = "select id from num where cd = ?"
 numup = "update num set id = ? where cd = ?"
 
@@ -71,7 +71,7 @@
   if pass == nil
     pass = id
   end
-  db.execute(ins6, id, pass)
+  db.execute(ins6, id, pass, name)
   db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
   db.execute(toi, id)
   db.execute(item, id)

yatex.org