You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by ro...@apache.org on 2005/03/07 04:15:53 UTC
svn commit: r156379 -
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql
Author: roberto
Date: Sun Mar 6 19:15:51 2005
New Revision: 156379
URL: http://svn.apache.org/viewcvs?view=rev&rev=156379
Log:
~ Updated DataMapper Test MySql/DataBase.sql for new Documents table
Modified:
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql?view=diff&r1=156378&r2=156379
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql Sun Mar 6 19:15:51 2005
@@ -35,6 +35,8 @@
drop table if exists OTHERS;
+drop table if exists DOCUMENTS;
+
/*==============================================================*/
/* Table : ACCOUNTS */
/*==============================================================*/
@@ -110,6 +112,19 @@
(
OTHER_INT int,
OTHER_LONG bigint
+) TYPE=INNODB;
+
+/*==============================================================*/
+/* Table : DOCUMENTS */
+/*==============================================================*/
+create table DOCUMENTS
+(
+ DOCUMENT_ID int not null,
+ DOCUMENT_TITLE varchar(32),
+ DOCUMENT_TYPE varchar(32),
+ DOCUMENT_PAGENUMBER int,
+ DOCUMENT_CITY varchar(32),
+ primary key (DOCUMENT_ID)
) TYPE=INNODB;