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 | 45472 | jjdelcerro | |
|---|---|---|---|
| 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 | 46102 | jjdelcerro | IF NOT EXISTS "test_GEOM_Geometry" |
| 54 | 45472 | jjdelcerro | 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 |