-
Notifications
You must be signed in to change notification settings - Fork 24
/
Copy pathvalue_list_base.sql
27 lines (22 loc) · 1.47 KB
/
value_list_base.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
/*
qWat - QGIS Water Module
SQL file :: leak_cause table
*/
/* CREATE */
CREATE TABLE qwat_vl.value_list_base ( id integer not null, CONSTRAINT "value_list_base_pk" PRIMARY KEY (id));
COMMENT ON TABLE qwat_vl.value_list_base IS 'Master tables for value lists. It will be inherited by value list tables. This table shall not be filled. Be warned that value list table shal have its own unique index on id since PG does not propagate indexes. Therefore unicity of id cannot be garanteed over all value lists.';
/* COLUMNS */
ALTER TABLE qwat_vl.value_list_base ADD COLUMN vl_active boolean default true;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN short_fr varchar(10) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN short_en varchar(10) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN short_ro varchar(10) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN short_de varchar(10) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN value_fr varchar(50) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN value_en varchar(50) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN value_ro varchar(50) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN value_de varchar(50) ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN description_fr text ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN description_en text ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN description_ro text ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN description_de text ;
ALTER TABLE qwat_vl.value_list_base ADD COLUMN sia405code text;