modules/carto/carto.pgsql

-- $Id$

--
--
--

create table carto_filter_nodes(
 nid integer NOT NULL default '0'
, numblocks integer NOT NULL default '0'
, PRIMARY KEY(nid)
);

--
--
--

create table carto_filter_blocks(
 cfid varchar(254) unique not null default ''
, crc integer
, time integer
, content text
, PRIMARY KEY(cfid)
);

--
--
--

create table carto_wms_node(
    nid integer not null
,   name varchar(32)
,   service varchar(255)
,   capabilities text
,   bbox varchar(255)
,   layers varchar(255)
,   abstract text
,   keywords varchar(255)
,   title varchar(255)
,   captime integer NOT NULL default '0'

,   PRIMARY KEY( nid )
);

--
--
--

create table carto_wms_layer(
    nid integer not null
,   lid integer not null
,   name varchar(255)
,   title varchar(255)
,   abstract text
,   minx double precision
,   miny double precision
,   maxx double precision
,   maxy double precision
,   queryable smallint default '0'
,   opaque smallint default '0'
,   cascaded smallint default '0'

,   PRIMARY KEY( nid, lid )
);

--
--
--

create table carto_wms_layer_properties(
    nid integer not null
,   lid integer not null
,   property varchar(255) not null
,   name varchar(255) not null
,   value text

,   PRIMARY KEY( nid, lid, property, name )
);

1	-- $Id$
2
3	--
4	--
5	--
6
7	create table carto_filter_nodes(
8	nid integer NOT NULL default '0'
9	, numblocks integer NOT NULL default '0'
10	, PRIMARY KEY(nid)
11	);
12
13	--
14	--
15	--
16
17	create table carto_filter_blocks(
18	cfid varchar(254) unique not null default ''
19	, crc integer
20	, time integer
21	, content text
22	, PRIMARY KEY(cfid)
23	);
24
25	--
26	--
27	--
28
29	create table carto_wms_node(
30	nid integer not null
31	, name varchar(32)
32	, service varchar(255)
33	, capabilities text
34	, bbox varchar(255)
35	, layers varchar(255)
36	, abstract text
37	, keywords varchar(255)
38	, title varchar(255)
39	, captime integer NOT NULL default '0'
40
41	, PRIMARY KEY( nid )
42	);
43
44	--
45	--
46	--
47
48	create table carto_wms_layer(
49	nid integer not null
50	, lid integer not null
51	, name varchar(255)
52	, title varchar(255)
53	, abstract text
54	, minx double precision
55	, miny double precision
56	, maxx double precision
57	, maxy double precision
58	, queryable smallint default '0'
59	, opaque smallint default '0'
60	, cascaded smallint default '0'
61
62	, PRIMARY KEY( nid, lid )
63	);
64
65	--
66	--
67	--
68
69	create table carto_wms_layer_properties(
70	nid integer not null
71	, lid integer not null
72	, property varchar(255) not null
73	, name varchar(255) not null
74	, value text
75
76	, PRIMARY KEY( nid, lid, property, name )
77	);
78