summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql')
-rw-r--r--tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql14
1 files changed, 1 insertions, 13 deletions
diff --git a/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql
index c254ae4d..5a1cdb2a 100644
--- a/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql
+++ b/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql
@@ -1,16 +1,4 @@
-use IBatisNet;
-
-drop table if exists 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;
+TRUNCATE `Documents`;
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');