svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / test / resources / org / gvsig / sqlite / dal / performChanges.sql @ 47579
History | View | Annotate | Download (1.9 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" |
7 |
) |
8 |
VALUES (
|
9 |
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? |
10 |
); |
11 |
|
12 |
-- Delete SQL
|
13 |
DELETE FROM "test" WHERE ( ("ID") = (?) ); |
14 |
|
15 |
-- Update SQL
|
16 |
UPDATE "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" = ? |
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" BIGINT DEFAULT NULL NULL; |
40 |
ALTER TABLE "test" ADD COLUMN "Timestamp" DATETIME DEFAULT NULL NULL; |
41 |
ALTER TABLE "test" ADD COLUMN "Date" DATE DEFAULT NULL NULL; |
42 |
ALTER TABLE "test" ADD COLUMN "Time" TIME 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" DOUBLE PRECISION DEFAULT NULL NULL; |
47 |
ALTER TABLE "test" ADD COLUMN "Bool4" BOOLEAN DEFAULT NULL NULL; |
48 |
ALTER TABLE "test" ADD COLUMN "Float" FLOAT 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" BLOB DEFAULT NULL NULL; |
52 |
--ALTER TABLE "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 |
|