Mercurial > gemma
view schema/tap_tests_data.sql @ 177:4e2451d561b1
Make schema for templates more realistic
A print template should be stored with name and timestamp and
the template itself will be any data to be interpreted as
a template file by a templating engine.
Delete relations in user_templates with their parents using CASCADE,
because user_templates is only an m:n-table.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 17 Jul 2018 16:50:16 +0200 |
parents | 25dba84d5703 |
children | 4df4e4bf480e |
line wrap: on
line source
SET search_path TO public, gemma, gemma_waterway, gemma_fairway; INSERT INTO countries VALUES ('AT'), ('RO'); INSERT INTO responsibility_areas VALUES ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)); INSERT INTO user_profiles (username, country, email_adress) VALUES ('waterway_user', 'AT', 'xxx'), ('waterway_user2', 'RO', 'xxy'), ('waterway_admin', 'AT', 'yyy'), ('sys_admin', 'AT', 'zzz'); INSERT INTO limiting_factors VALUES ('depth'), ('width'); INSERT INTO gauges ( location, function_code, objname, geom, zero_point, source_organization) VALUES (('AT', 'XXX', '00001', '00000', 1)::isrs, 'xxx', 'testgauge', ST_geomfromtext('POINT(0 0)', 4326), 0, 'testorganization'); INSERT INTO bottlenecks ( bottleneck_id, fk_g_fid, stretch, area, rb, lb, responsible_country, revisiting_time, limiting, source_organization, staging_done) VALUES ('testbottleneck1', ('AT', 'XXX', '00001', '00000', 1)::isrs, isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, ('AT', 'XXX', '00001', '00000', 2)::isrs), ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326), 'AT', 'AT', 'AT', 1, 'depth', 'testorganization', false), ('testbottleneck2', ('AT', 'XXX', '00001', '00000', 1)::isrs, isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, ('AT', 'XXX', '00001', '00000', 2)::isrs), ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326), 'AT', 'AT', 'AT', 1, 'depth', 'testorganization', true); INSERT INTO templates (template_name, template_data) VALUES ('AT', '\x'), ('RO', '\x'); INSERT INTO user_templates VALUES ('waterway_user', 'AT'), ('waterway_user2', 'RO');