summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/simple_unit/SqlMap/scripts/mysql/account-init.sql')
-rw-r--r--tests/simple_unit/SqlMap/scripts/mysql/account-init.sql15
1 files changed, 1 insertions, 14 deletions
diff --git a/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql
index 51b315f4..afe8dab1 100644
--- a/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql
+++ b/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql
@@ -1,17 +1,4 @@
-use IBatisNet;
-
-drop table if exists 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;
+TRUNCATE `Accounts`;
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);