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/05/15 22:20:25 UTC
svn commit: r170260 - in
/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL:
./ DataBase.sql account-init.sql category-init.sql documents-init.sql
enumeration-init.sql line-item-init.sql more-account-records.sql
order-init.sql other-init.sql user-init.sql
Author: roberto
Date: Sun May 15 13:20:24 2005
New Revision: 170260
URL: http://svn.apache.org/viewcvs?rev=170260&view=rev
Log:
+Adding C# DataMapper NUnit PostgreSQL scripts (first cut!)
Added:
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/DataBase.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/account-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/category-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/documents-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/enumeration-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/line-item-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/more-account-records.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/order-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/other-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/user-init.sql
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/DataBase.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/DataBase.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/DataBase.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/DataBase.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,194 @@
+DROP database "IBatisNet";
+DROP database "NHibernate";
+
+-- User: "IBatisNet"
+
+DROP USER "IBatisNet";
+
+CREATE USER "IBatisNet" PASSWORD 'test'
+ CREATEDB CREATEUSER
+ VALID UNTIL 'infinity';
+
+-- User: "NHibernate"
+
+DROP USER "NHibernate";
+
+CREATE USER "NHibernate" PASSWORD 'test'
+ CREATEDB CREATEUSER
+ VALID UNTIL 'infinity';
+
+
+-- Database: "IBatisNet"
+
+CREATE DATABASE "IBatisNet"
+WITH ENCODING='UNICODE'
+ OWNER="IBatisNet";
+
+-- Database: "NHibernate"
+
+CREATE DATABASE "NHibernate"
+ WITH ENCODING='UNICODE'
+ OWNER="NHibernate";
+
+
+
+
+\connect "IBatisNet" "IBatisNet" using test;
+
+-- DROP TABLE "Accounts";
+
+-- DROP TABLE "Categories";
+
+-- DROP TABLE "Enumerations";
+
+-- DROP TABLE "LineItems";
+
+-- DROP TABLE "Orders";
+
+-- DROP TABLE "Others";
+
+-- DROP TABLE "Documents";
+
+
+
+-- Sequence: "S_Categories"
+
+DROP SEQUENCE "S_Categories";
+
+CREATE SEQUENCE "S_Categories"
+ INCREMENT 1
+ MINVALUE 1
+ MAXVALUE 9223372036854775807
+ START 1
+ CACHE 20;
+ALTER TABLE "S_Categories" OWNER TO "IBatisNet";
+
+
+/*==============================================================*/
+/* Table : Accounts */
+/*==============================================================*/
+CREATE TABLE "Accounts"
+(
+ "Account_Id" int4 NOT NULL,
+ "Account_FirstName" varchar(32) NOT NULL,
+ "Account_LastName" varchar(32) NOT NULL,
+ "Account_Email" varchar(128),
+ "Account_Banner_Option" varchar(255),
+ "Account_Cart_Option" int4,
+ CONSTRAINT "PK_Accounts" PRIMARY KEY ("Account_Id")
+) WITHOUT OIDS;
+ALTER TABLE "Accounts" OWNER TO "IBatisNet";
+
+/*==============================================================*/
+/* Table : Categories */
+/*==============================================================*/
+CREATE TABLE "Categories"
+(
+ "Category_Id" int4 NOT NULL,
+ "Category_Name" varchar(32),
+ "Category_Guid" varchar(36),
+ CONSTRAINT "PK_Categories" PRIMARY KEY ("Category_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Categories" OWNER TO "IBatisNet";
+
+/*==============================================================*/
+/* Table : Enumerations */
+/*==============================================================*/
+CREATE TABLE "Enumerations"
+(
+ "Enum_Id" int4 NOT NULL,
+ "Enum_Day" int4 NOT NULL,
+ "Enum_Color" int4 NOT NULL,
+ "Enum_Month" int4,
+ CONSTRAINT "PK_Enumerations" PRIMARY KEY ("Enum_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Enumerations" OWNER TO "IBatisNet";
+
+/*==============================================================*/
+/* Table : LineItems */
+/*==============================================================*/
+CREATE TABLE "LineItems"
+(
+ "LineItem_Id" int4 NOT NULL,
+ "Order_Id" int4 NOT NULL,
+ "LineItem_Code" varchar(32) NOT NULL,
+ "LineItem_Quantity" int4 NOT NULL,
+ "LineItem_Price" numeric(18,2),
+ "LineItem_Picture" bytea,
+ CONSTRAINT "PK_LineItems" PRIMARY KEY ("LineItem_Id", "Order_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "LineItems" OWNER TO "IBatisNet";
+
+/*==============================================================*/
+/* Table : Orders */
+/*==============================================================*/
+CREATE TABLE "Orders"
+(
+ "Order_Id" int4 NOT NULL,
+ "Account_Id" int4 NOT NULL,
+ "Order_Date" date,
+ "Order_CardType" varchar(32),
+ "Order_CardNumber" varchar(32),
+ "Order_CardExpiry" varchar(32),
+ "Order_Street" varchar(32),
+ "Order_City" varchar(32),
+ "Order_Province" varchar(32),
+ "Order_PostalCode" varchar(32),
+ "Order_FavouriteLineItem" int4,
+ CONSTRAINT "PK_Orders" PRIMARY KEY ("Order_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Orders" OWNER TO "IBatisNet";
+
+/*==============================================================*/
+/* Table : Others */
+/*==============================================================*/
+CREATE TABLE "Others"
+(
+ "Other_Int" int4,
+ "Other_Long" int8,
+ "Other_Bit" bool NOT NULL DEFAULT false,
+ "Other_String" varchar(32) NOT NULL
+)
+WITHOUT OIDS;
+ALTER TABLE "Others" OWNER TO "IBatisNet";
+
+/*==============================================================*/
+/* Table : Documents */
+/*==============================================================*/
+CREATE TABLE "Documents"
+(
+ "Document_Id" int4 NOT NULL,
+ "Document_Title" varchar(32),
+ "Document_Type" varchar(32),
+ "Document_PageNumber" int4,
+ "Document_City" varchar(32),
+ CONSTRAINT "PK_Documents" PRIMARY KEY ("Document_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Documents" OWNER TO "IBatisNet";
+
+
+
+
+\connect "NHibernate" "NHibernate" using test;
+
+-- DROP TABLE "Users";
+
+/*==============================================================*/
+/* Table : Users */
+/*==============================================================*/
+CREATE TABLE "Users"
+(
+ "LogonId" varchar(20) NOT NULL DEFAULT '0'::character varying,
+ "Name" varchar(40),
+ "Password" varchar(20),
+ "EmailAddress" varchar(40),
+ "LastLogon" date,
+ CONSTRAINT "PK_Users" PRIMARY KEY ("LogonId")
+)
+WITHOUT OIDS;
+ALTER TABLE "Users" OWNER TO "NHibernate";
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/account-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/account-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/account-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/account-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,21 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP TABLE "Accounts";
+
+CREATE TABLE "Accounts"
+(
+ "Account_Id" int4 NOT NULL,
+ "Account_FirstName" varchar(32) NOT NULL,
+ "Account_LastName" varchar(32) NOT NULL,
+ "Account_Email" varchar(128),
+ "Account_Banner_Option" varchar(255),
+ "Account_Cart_Option" int4,
+ CONSTRAINT "PK_Accounts" PRIMARY KEY ("Account_Id")
+) WITHOUT OIDS;
+ALTER TABLE "Accounts" OWNER TO "IBatisNet";
+
+INSERT INTO "Accounts" VALUES(1,'Joe', 'Dalton', 'Joe.Dalton@somewhere.com', 'Oui', 200);
+INSERT INTO "Accounts" VALUES(2,'Averel', 'Dalton', 'Averel.Dalton@somewhere.com', 'Oui', 200);
+INSERT INTO "Accounts" VALUES(3,'William', 'Dalton', null, 'Non', 100);
+INSERT INTO "Accounts" VALUES(4,'Jack', 'Dalton', 'Jack.Dalton@somewhere.com', 'Non', 100);
+INSERT INTO "Accounts" VALUES(5,'Gilles', 'Bayon', null, 'Oui', 100);
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/category-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/category-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/category-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/category-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,23 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP SEQUENCE "S_Categories";
+
+CREATE SEQUENCE "S_Categories"
+ INCREMENT 1
+ MINVALUE 1
+ MAXVALUE 9223372036854775807
+ START 1
+ CACHE 20;
+ALTER TABLE "S_Categories" OWNER TO "IBatisNet";
+
+DROP TABLE "Categories";
+
+CREATE TABLE "Categories"
+(
+ "Category_Id" int4 NOT NULL,
+ "Category_Name" varchar(32),
+ "Category_Guid" varchar(36),
+ CONSTRAINT "PK_Categories" PRIMARY KEY ("Category_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Categories" OWNER TO "IBatisNet";
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/documents-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/documents-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/documents-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/documents-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,22 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP TABLE "Documents";
+
+CREATE TABLE "Documents"
+(
+ "Document_Id" int4 NOT NULL,
+ "Document_Title" varchar(32),
+ "Document_Type" varchar(32),
+ "Document_PageNumber" int4,
+ "Document_City" varchar(32),
+ CONSTRAINT "PK_Documents" PRIMARY KEY ("Document_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Documents" OWNER TO "IBatisNet";
+
+INSERT INTO Documents VALUES (1, 'The World of Null-A', 'Book', 55, null);
+INSERT INTO Documents VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon');
+INSERT INTO Documents VALUES (3, 'Lord of the Rings', 'Book', 3587, null);
+INSERT INTO Documents VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris');
+INSERT INTO Documents VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris');
+INSERT INTO Documents VALUES (6, 'Foundation', 'Monograph', 557, null);
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/enumeration-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/enumeration-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/enumeration-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/enumeration-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,19 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP TABLE "Enumerations";
+
+CREATE TABLE "Enumerations"
+(
+ "Enum_Id" int4 NOT NULL,
+ "Enum_Day" int4 NOT NULL,
+ "Enum_Color" int4 NOT NULL,
+ "Enum_Month" int4,
+ CONSTRAINT "PK_Enumerations" PRIMARY KEY ("Enum_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Enumerations" OWNER TO "IBatisNet";
+
+INSERT INTO Enumerations VALUES(1, 1, 1, 128);
+INSERT INTO Enumerations VALUES(2, 2, 2, 2048);
+INSERT INTO Enumerations VALUES(3, 3, 4, 256);
+INSERT INTO Enumerations VALUES(4, 4, 8, null);
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/line-item-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/line-item-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/line-item-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/line-item-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,38 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP TABLE "LineItems";
+
+CREATE TABLE "LineItems"
+(
+ "LineItem_Id" int4 NOT NULL,
+ "Order_Id" int4 NOT NULL,
+ "LineItem_Code" varchar(32) NOT NULL,
+ "LineItem_Quantity" int4 NOT NULL,
+ "LineItem_Price" numeric(18,2),
+ "LineItem_Picture" bytea,
+ CONSTRAINT "PK_LineItems" PRIMARY KEY ("LineItem_Id", "Order_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "LineItems" OWNER TO "IBatisNet";
+
+INSERT INTO LineItems VALUES (1, 10, 'ESM-34', 1, 45.43, null);
+INSERT INTO LineItems VALUES (2, 10, 'QSM-98', 8, 8.40, null);
+INSERT INTO LineItems VALUES (1, 9, 'DSM-78', 2, 45.40, null);
+INSERT INTO LineItems VALUES (2, 9, 'TSM-12', 2, 32.12, null);
+INSERT INTO LineItems VALUES (1, 8, 'DSM-16', 4, 41.30, null);
+INSERT INTO LineItems VALUES (2, 8, 'GSM-65', 1, 2.20, null);
+INSERT INTO LineItems VALUES (1, 7, 'WSM-27', 7, 52.10, null);
+INSERT INTO LineItems VALUES (2, 7, 'ESM-23', 2, 123.34, null);
+INSERT INTO LineItems VALUES (1, 6, 'QSM-39', 9, 12.12, null);
+INSERT INTO LineItems VALUES (2, 6, 'ASM-45', 6, 78.77, null);
+INSERT INTO LineItems VALUES (1, 5, 'ESM-48', 3, 43.87, null);
+INSERT INTO LineItems VALUES (2, 5, 'WSM-98', 7, 5.40, null);
+INSERT INTO LineItems VALUES (1, 4, 'RSM-57', 2, 78.90, null);
+INSERT INTO LineItems VALUES (2, 4, 'XSM-78', 9, 2.34, null);
+INSERT INTO LineItems VALUES (1, 3, 'DSM-59', 3, 5.70, null);
+INSERT INTO LineItems VALUES (2, 3, 'DSM-53', 3, 98.78, null);
+INSERT INTO LineItems VALUES (1, 2, 'DSM-37', 4, 7.80, null);
+INSERT INTO LineItems VALUES (2, 2, 'FSM-12', 2, 55.78, null);
+INSERT INTO LineItems VALUES (1, 1, 'ESM-48', 8, 87.60, null);
+INSERT INTO LineItems VALUES (2, 1, 'ESM-23', 1, 55.40, null);
+
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/more-account-records.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/more-account-records.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/more-account-records.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/more-account-records.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,7 @@
+
+INSERT INTO Accounts VALUES(6,'Jane', 'Calamity', 'Jane.Calamity@somewhere.com');
+INSERT INTO Accounts VALUES(7,'Lucky', 'Luke', 'Lucky.Luke@somewhere.com');
+INSERT INTO Accounts VALUES(8,'Ming', 'Li Foo', null);
+INSERT INTO Accounts VALUES(9,'O''Hara', 'Steve', 'Jack.OHara@somewhere.com');
+INSERT INTO Accounts VALUES(10,'Robert', 'O''Timmins', null);
+
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/order-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/order-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/order-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/order-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,33 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP TABLE "Orders";
+
+CREATE TABLE "Orders"
+(
+ "Order_Id" int4 NOT NULL,
+ "Account_Id" int4 NOT NULL,
+ "Order_Date" date,
+ "Order_CardType" varchar(32),
+ "Order_CardNumber" varchar(32),
+ "Order_CardExpiry" varchar(32),
+ "Order_Street" varchar(32),
+ "Order_City" varchar(32),
+ "Order_Province" varchar(32),
+ "Order_PostalCode" varchar(32),
+ "Order_FavouriteLineItem" int4,
+ CONSTRAINT "PK_Orders" PRIMARY KEY ("Order_Id")
+)
+WITHOUT OIDS;
+ALTER TABLE "Orders" OWNER TO "IBatisNet";
+
+INSERT INTO Orders VALUES (1, 1, '2003-02-15 8:15:00', 'VISA', '999999999999', '05/03', '11 This Street', 'Victoria', 'BC', 'C4B 4F4',2);
+INSERT INTO Orders VALUES (2, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '06/03', '222 That Street', 'Edmonton', 'AB', 'X4K 5Y4',1);
+INSERT INTO Orders VALUES (3, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '07/03', '333 Other Street', 'Regina', 'SK', 'Z4U 6Y4',2);
+INSERT INTO Orders VALUES (4, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '08/03', '444 His Street', 'Toronto', 'ON', 'K4U 3S4',1);
+INSERT INTO Orders VALUES (5, 5, '2003-02-15 8:15:00', 'VISA', '555555555555', '09/03', '555 Her Street', 'Calgary', 'AB', 'J4J 7S4',2);
+INSERT INTO Orders VALUES (6, 5, '2003-02-15 8:15:00', 'VISA', '999999999999', '10/03', '6 Their Street', 'Victoria', 'BC', 'T4H 9G4',1);
+INSERT INTO Orders VALUES (7, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '11/03', '77 Lucky Street', 'Edmonton', 'AB', 'R4A 0Z4',2);
+INSERT INTO Orders VALUES (8, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '12/03', '888 Our Street', 'Regina', 'SK', 'S4S 7G4',1);
+INSERT INTO Orders VALUES (9, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '01/04', '999 Your Street', 'Toronto', 'ON', 'G4D 9F4',2);
+INSERT INTO Orders VALUES (10, 1, '2003-02-15 8:15:00', 'VISA', '555555555555', '02/04', '99 Some Street', 'Calgary', 'AB', 'W4G 7A4',1);
+
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/other-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/other-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/other-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/other-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,16 @@
+\connect "IBatisNet" "IBatisNet";
+
+DROP TABLE "Others";
+
+CREATE TABLE "Others"
+(
+ "Other_Int" int4,
+ "Other_Long" int8,
+ "Other_Bit" bool NOT NULL DEFAULT false,
+ "Other_String" varchar(32) NOT NULL
+)
+WITHOUT OIDS;
+ALTER TABLE "Others" OWNER TO "IBatisNet";
+
+INSERT INTO Others VALUES(1, 8888888, false, 'Oui');
+INSERT INTO Others VALUES(2, 9999999999, true, 'Non');
Added: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/user-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/user-init.sql?rev=170260&view=auto
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/user-init.sql (added)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/PostgreSQL/user-init.sql Sun May 15 13:20:24 2005
@@ -0,0 +1,15 @@
+\connect "NHibernate" "NHibernate";
+
+DROP TABLE "Users";
+
+CREATE TABLE "Users"
+(
+ "LogonId" varchar(20) NOT NULL DEFAULT '0'::character varying,
+ "Name" varchar(40),
+ "Password" varchar(20),
+ "EmailAddress" varchar(40),
+ "LastLogon" date,
+ CONSTRAINT "PK_Users" PRIMARY KEY ("LogonId")
+)
+WITHOUT OIDS;
+ALTER TABLE "Users" OWNER TO "NHibernate";