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.h2 / src / test / resources / org / gvsig / fmap / dal / store / h2 / performChanges.sql @ 44678
History | View | Annotate | Download (2.1 KB)
1 | 44678 | 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 | IF NOT EXISTS "constraint_test_Geometry_geom" |
||
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 |