svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / performChanges.sql @ 46102
History | View | Annotate | Download (2.09 KB)
| 1 |
|
|---|---|
| 2 |
-- Insert SQL
|
| 3 |
INSERT INTO "PUBLIC"."test" ( |
| 4 |
"ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", |
| 5 |
"Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", |
| 6 |
"Decimal", "Geometry" |
| 7 |
) |
| 8 |
VALUES (
|
| 9 |
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ST_GeomFromWKB((?), (?)) |
| 10 |
); |
| 11 |
|
| 12 |
-- Delete SQL
|
| 13 |
DELETE FROM "PUBLIC"."test" WHERE ( ("ID") = (?) ); |
| 14 |
|
| 15 |
-- Update SQL
|
| 16 |
UPDATE "PUBLIC"."test" |
| 17 |
SET
|
| 18 |
"Byte" = ?, |
| 19 |
"Bool1" = ?, |
| 20 |
"Long" = ?, |
| 21 |
"Timestamp" = ?, |
| 22 |
"Date" = ?, |
| 23 |
"Time" = ?, |
| 24 |
"Bool2" = ?, |
| 25 |
"String" = ?, |
| 26 |
"Bool3" = ?, |
| 27 |
"Double" = ?, |
| 28 |
"Bool4" = ?, |
| 29 |
"Float" = ?, |
| 30 |
"Bool5" = ?, |
| 31 |
"Decimal" = ?, |
| 32 |
"Geometry" = ST_GeomFromWKB((?), (?)) |
| 33 |
WHERE
|
| 34 |
( ("ID") = (?) ); |
| 35 |
|
| 36 |
-- Update Table SQL
|
| 37 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Byte" TINYINT DEFAULT NULL NULL; |
| 38 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool1" BOOLEAN DEFAULT NULL NULL; |
| 39 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Long" BIGINT DEFAULT NULL NULL; |
| 40 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Timestamp" TIMESTAMP DEFAULT NULL NULL; |
| 41 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Date" DATE DEFAULT NULL NULL; |
| 42 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Time" TIME DEFAULT NULL NULL; |
| 43 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool2" BOOLEAN DEFAULT NULL NULL; |
| 44 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "String" VARCHAR(30) DEFAULT NULL NULL; |
| 45 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool3" BOOLEAN DEFAULT NULL NULL; |
| 46 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Double" DOUBLE DEFAULT NULL NULL; |
| 47 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool4" BOOLEAN DEFAULT NULL NULL; |
| 48 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Float" REAL DEFAULT NULL NULL; |
| 49 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool5" BOOLEAN DEFAULT NULL NULL; |
| 50 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Decimal" DECIMAL(6,3) DEFAULT NULL NULL; |
| 51 |
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Geometry" GEOMETRY(1) DEFAULT NULL NULL; |
| 52 |
ALTER TABLE "PUBLIC"."test" ADD CONSTRAINT |
| 53 |
IF NOT EXISTS "test_GEOM_Geometry" |
| 54 |
CHECK NVL2(
|
| 55 |
"Geometry",
|
| 56 |
ST_GeometryTypeCode("Geometry") = 1 AND |
| 57 |
ST_CoordDim("Geometry") = 2 AND |
| 58 |
ST_SRID("Geometry") = 4326, |
| 59 |
TRUE
|
| 60 |
); |
| 61 |
|
| 62 |
|
| 63 |
|