[Sangokushi-svn] [SVN_Comitted] [454] テーブル " t_login" のCREATEを追加

OpenSangokushi commit ML sango****@lists*****
2010年 11月 3日 (水) 15:28:48 JST


Revision: 454
          http://sourceforge.jp/projects/sangokushi/svn/view?view=rev&revision=454
Author:   hryksbt
Date:     2010-11-03 15:28:48 +0900 (Wed, 03 Nov 2010)

Log Message:
-----------
テーブル"t_login"のCREATEを追加

Modified Paths:
--------------
    trunk/Documents/tableSQL.txt

Modified: trunk/Documents/tableSQL.txt
===================================================================
--- trunk/Documents/tableSQL.txt	2010-11-03 06:04:12 UTC (rev 453)
+++ trunk/Documents/tableSQL.txt	2010-11-03 06:28:48 UTC (rev 454)
@@ -129,6 +129,14 @@
 ENGINE = InnoDB
 DEFAULT CHARACTER SET = utf8;
 
+CREATE  TABLE IF NOT EXISTS `o_sangokushi`.`t_login` (
+  `userID` VARCHAR(10) NOT NULL ,
+  `sessionID`  VARCHAR(40) NOT NULL ,
+  `lastLoginDate` DATETIME NULL ,
+  `lastUpdateDate` DATETIME NULL )
+ENGINE = InnoDB
+DEFAULT CHARACTER SET = utf8;
+
 SET SQL_MODE=@OLD_SQL_MODE;
 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;




Sangokushi-svn メーリングリストの案内