diff options
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/begin.sql | 3 | ||||
| -rw-r--r-- | data/sql/commit.sql | 7 | ||||
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 3 |
3 files changed, 4 insertions, 9 deletions
diff --git a/data/sql/begin.sql b/data/sql/begin.sql index 1775571f..8562c0f8 100644 --- a/data/sql/begin.sql +++ b/data/sql/begin.sql @@ -1 +1,4 @@ +PRAGMA page_size = 4096; +PRAGMA foreign_keys = 1; + BEGIN; diff --git a/data/sql/commit.sql b/data/sql/commit.sql index a580f6e0..9f2356f4 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -9,11 +9,6 @@ CREATE INDEX grid_transformation_idx ON grid_transformation(source_crs_auth_name CREATE INDEX other_transformation_idx ON other_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code); CREATE INDEX concatenated_operation_idx ON concatenated_operation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code); --- Do an explicit foreign_key_check as foreign key checking is a no-op within --- a transaction. Unfortunately we can't ask for this to be an error, so this --- is just for verbose output. In Makefile, we check this separately -PRAGMA foreign_key_check; - -- Final consistency checks CREATE TABLE dummy(foo); CREATE TRIGGER final_checks @@ -190,4 +185,4 @@ INSERT INTO dummy DEFAULT VALUES; DROP TRIGGER final_checks; DROP TABLE dummy; -VACUUM;
\ No newline at end of file +VACUUM; diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index e43dfad4..2969178b 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1,8 +1,5 @@ --- Table structures -PRAGMA page_size = 4096; -PRAGMA foreign_keys = 1; - CREATE TABLE metadata( key TEXT NOT NULL PRIMARY KEY CHECK (length(key) >= 1), value TEXT NOT NULL |