From f6a5e7589396854e10e023c25237b47e512ff047 Mon Sep 17 00:00:00 2001 From: wei <> Date: Fri, 14 Apr 2006 11:23:56 +0000 Subject: Adding SQLMap unit tests. Allow sqlmap to use Prado's caching module to cache records. --- tests/unit/SQLMap/scripts/mysql/DataBase.sql | 214 +++++++++++++++++++++++++++ 1 file changed, 214 insertions(+) create mode 100644 tests/unit/SQLMap/scripts/mysql/DataBase.sql (limited to 'tests/unit/SQLMap/scripts/mysql/DataBase.sql') diff --git a/tests/unit/SQLMap/scripts/mysql/DataBase.sql b/tests/unit/SQLMap/scripts/mysql/DataBase.sql new file mode 100644 index 00000000..b6542cdb --- /dev/null +++ b/tests/unit/SQLMap/scripts/mysql/DataBase.sql @@ -0,0 +1,214 @@ +use mysql; + +drop database IBatisNet; +create database IBatisNet; + +drop database NHibernate; +create database NHibernate; + +grant all privileges on IBatisNet.* to IBatisNet@'%' identified by 'test'; +grant all privileges on IBatisNet.* to IBatisNet@localhost identified by 'test'; +grant all privileges on IBatisNet.* to IBatisNet@localhost.localdomain identified by 'test'; + +grant all privileges on NHibernate.* to NHibernate@'%' identified by 'test'; +grant all privileges on NHibernate.* to NHibernate@localhost identified by 'test'; +grant all privileges on NHibernate.* to NHibernate@localhost.localdomain identified by 'test'; + + +/*==============================================================*/ +/* Nom de la base : MYSQL */ +/* Nom de SGBD : MySQL 3.23 */ +/* Date de cr閍tion : 27/05/2004 20:51:40 */ +/*==============================================================*/ + +use IBatisNet; + +drop table if exists Accounts; + +drop table if exists Categories; + +drop table if exists Enumerations; + +drop table if exists LineItems; + +drop table if exists Orders; + +drop table if exists Others; + +drop table if exists Documents; + +/*==============================================================*/ +/* Table : Accounts */ +/*==============================================================*/ +create table Accounts +( + Account_Id int 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 int, + primary key (Account_Id) +) TYPE=INNODB; + +/*==============================================================*/ +/* Table : Categories */ +/*==============================================================*/ +create table Categories +( + Category_Id int not null AUTO_INCREMENT, + Category_Name varchar(32), + Category_Guid varchar(36), + primary key (Category_Id) +) TYPE=INNODB; + +/*==============================================================*/ +/* Table : Enumerations */ +/*==============================================================*/ +create table Enumerations +( + Enum_Id int not null, + Enum_Day int not null, + Enum_Color int not null, + Enum_Month int, + primary key (Enum_Id) +) TYPE=INNODB; + +/*==============================================================*/ +/* Table : LineItems */ +/*==============================================================*/ +create table LineItems +( + LineItem_Id int not null, + Order_Id int not null, + LineItem_Code varchar(32) not null, + LineItem_Quantity int not null, + LineItem_Price decimal(18,2), + LineItem_Picture blob, + primary key (Order_Id, LineItem_Id) +) TYPE=INNODB; + +/*==============================================================*/ +/* Table : Orders */ +/*==============================================================*/ +create table Orders +( + Order_Id int not null, + Account_Id int null, + Order_Date datetime, + 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 int, + primary key (Order_Id) +) TYPE=INNODB; + +/*==============================================================*/ +/* Table : Others */ +/*==============================================================*/ +create table Others +( + Other_Int int, + Other_Long bigint, + Other_Bit bit not null default 0, + Other_String varchar(32) not null +) TYPE=INNODB; + +CREATE TABLE F ( + ID varchar(50) NOT NULL , + F_Libelle varchar(50) NULL , + primary key (ID) +) TYPE=INNODB; + +CREATE TABLE E ( + ID varchar(50) NOT NULL , + E_Libelle varchar(50) NULL , + primary key (ID) +) TYPE=INNODB; + +CREATE TABLE D ( + ID varchar(50) NOT NULL , + D_Libelle varchar(50) NULL , + primary key (ID) +) TYPE=INNODB; + +CREATE TABLE C ( + ID varchar(50) NOT NULL , + C_Libelle varchar(50) NULL , + primary key (ID) +) TYPE=INNODB; + + +CREATE TABLE B ( + ID varchar(50) NOT NULL , + C_ID varchar(50) NULL , + D_ID varchar(50) NULL , + B_Libelle varchar(50) NULL , + primary key (ID) +) TYPE=INNODB; + +ALTER TABLE B ADD CONSTRAINT FK_B_C FOREIGN KEY FK_B_C (C_ID) + REFERENCES C (ID) + ON DELETE RESTRICT + ON UPDATE RESTRICT, + ADD CONSTRAINT FK_B_D FOREIGN KEY FK_B_D (D_ID) + REFERENCES D (ID) + ON DELETE RESTRICT + ON UPDATE RESTRICT; + +CREATE TABLE A ( + ID varchar(50) NOT NULL , + B_ID varchar(50) NULL , + E_ID varchar(50) NULL , + F_ID varchar(50) NULL , + A_Libelle varchar(50) NULL , + primary key (ID) +) TYPE=INNODB; + +ALTER TABLE A ADD CONSTRAINT FK_A_B FOREIGN KEY FK_A_B (B_ID) + REFERENCES B (ID) + ON DELETE RESTRICT + ON UPDATE RESTRICT, + ADD CONSTRAINT FK_A_E FOREIGN KEY FK_A_E (E_ID) + REFERENCES E (ID) + ON DELETE RESTRICT + ON UPDATE RESTRICT, + ADD CONSTRAINT FK_A_F FOREIGN KEY FK_A_F (F_ID) + REFERENCES F (ID) + ON DELETE RESTRICT; + +/*==============================================================*/ +/* 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; + + + +use NHibernate; + +drop table if exists Users; + +/*==============================================================*/ +/* Table : Users */ +/*==============================================================*/ +create table Users +( + LogonId varchar(20) not null default '0', + Name varchar(40) default null, + Password varchar(20) default null, + EmailAddress varchar(40) default null, + LastLogon datetime default null, + primary key (LogonId) +) TYPE=INNODB; -- cgit v1.2.3