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 |
|
---|---|
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 |
|
63 |
|