diff options
author | wei <> | 2006-12-20 03:15:04 +0000 |
---|---|---|
committer | wei <> | 2006-12-20 03:15:04 +0000 |
commit | 2c221ea67d0512961beea8fbcb30b23865c16bb0 (patch) | |
tree | aba7901f8e286d0b4101fc9022247897881bd5c1 /tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql | |
parent | 2570226fbac3e26b1e94896b50d1db4bc1aa3308 (diff) |
Add quickstart docs for Active Record and SqlMap
Diffstat (limited to 'tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql')
-rw-r--r-- | tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql | 15 |
1 files changed, 1 insertions, 14 deletions
diff --git a/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql index cb800835..b0f7e424 100644 --- a/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql +++ b/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql @@ -1,18 +1,5 @@ -use IBatisNet;
-
-drop table if exists 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;
+TRUNCATE `LineItems`;
INSERT INTO LineItems VALUES (1, 10, 'ESM-34', 1, 45.43, null);
INSERT INTO LineItems VALUES (2, 10, 'QSM-98', 8, 8.40, null);
|