svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.db / org.gvsig.fmap.dal.db.mdb / src / test / resources / org / gvsig / fmap / dal / store / mdb / performChanges.sql @ 45008
History | View | Annotate | Download (1.76 KB)
| 1 |
|
|---|---|
| 2 |
-- Insert SQL
|
| 3 |
INSERT INTO [test] ( |
| 4 |
[ID], [Byte], [Bool1], [Long], [Timestamp], [Date], [Time], |
| 5 |
[Bool2], [String], [Bool3], [Double], [Bool4], [Float], [Bool5], |
| 6 |
[Decimal], [Geometry], [Decimal19_0]
|
| 7 |
) |
| 8 |
VALUES (
|
| 9 |
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ); |
| 10 |
|
| 11 |
-- Delete SQL
|
| 12 |
DELETE FROM [test] WHERE ( ([ID]) = (?) ); |
| 13 |
|
| 14 |
-- Update SQL
|
| 15 |
UPDATE [test]
|
| 16 |
SET
|
| 17 |
[Byte] = ?,
|
| 18 |
[Bool1] = ?,
|
| 19 |
[Long] = ?,
|
| 20 |
[Timestamp] = ?, |
| 21 |
[Date] = ?, |
| 22 |
[Time] = ?, |
| 23 |
[Bool2] = ?,
|
| 24 |
[String] = ?,
|
| 25 |
[Bool3] = ?,
|
| 26 |
[Double] = ?, |
| 27 |
[Bool4] = ?,
|
| 28 |
[Float] = ?, |
| 29 |
[Bool5] = ?,
|
| 30 |
[Decimal] = ?, |
| 31 |
[Geometry] = ?,
|
| 32 |
[Decimal19_0] = ?
|
| 33 |
WHERE
|
| 34 |
( ([ID]) = (?) );
|
| 35 |
|
| 36 |
-- Update Table SQL
|
| 37 |
ALTER TABLE [test] ADD COLUMN [Byte] TINYINT DEFAULT NULL NULL; |
| 38 |
ALTER TABLE [test] ADD COLUMN [Bool1] BOOLEAN DEFAULT NULL NULL; |
| 39 |
ALTER TABLE [test] ADD COLUMN [Long] DECIMAL(19,0) DEFAULT NULL NULL; |
| 40 |
ALTER TABLE [test] ADD COLUMN [Timestamp] DATETIME DEFAULT NULL NULL; |
| 41 |
ALTER TABLE [test] ADD COLUMN [Date] DATETIME DEFAULT NULL NULL; |
| 42 |
ALTER TABLE [test] ADD COLUMN [Time] DATETIME DEFAULT NULL NULL; |
| 43 |
ALTER TABLE [test] ADD COLUMN [Bool2] BOOLEAN DEFAULT NULL NULL; |
| 44 |
ALTER TABLE [test] ADD COLUMN [String] VARCHAR(30) DEFAULT NULL NULL; |
| 45 |
ALTER TABLE [test] ADD COLUMN [Bool3] BOOLEAN DEFAULT NULL NULL; |
| 46 |
ALTER TABLE [test] ADD COLUMN [Double] FLOAT DEFAULT NULL NULL; |
| 47 |
ALTER TABLE [test] ADD COLUMN [Bool4] BOOLEAN DEFAULT NULL NULL; |
| 48 |
ALTER TABLE [test] ADD COLUMN [Float] REAL DEFAULT NULL NULL; |
| 49 |
ALTER TABLE [test] ADD COLUMN [Bool5] BOOLEAN DEFAULT NULL NULL; |
| 50 |
ALTER TABLE [test] ADD COLUMN [Decimal] DECIMAL(6,3) DEFAULT NULL NULL; |
| 51 |
ALTER TABLE [test] ADD COLUMN [Geometry] CLOB DEFAULT NULL NULL; |
| 52 |
ALTER TABLE [test] ADD COLUMN [Decimal19_0] DECIMAL(19) DEFAULT NULL NULL; |
| 53 |
|
| 54 |
|
| 55 |
|