modules/carto/carto.mysql

/**
 * carto_filter_nodes: nodes that contain carto filters
 */
drop table carto_filter_nodes;
create table carto_filter_nodes(
    nid integer NOT NULL
,   numblocks integer NOT NULL default '0'

,   PRIMARY KEY(nid)
);


/**
 * carto_filter_blocks: each block is identified by the node id and
 * the carto filter block id. 
 */
drop table carto_filter_blocks;
create table carto_filter_blocks(
    cfid varchar(254) unique not null
,   crc int
,   time int      
,   content blob

,   PRIMARY KEY(cfid)
);

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

,   PRIMARY KEY( nid )
);

drop table carto_wms_layer;
create table carto_wms_layer(
    nid integer not null
,   lid integer not null                COMMENT 'layer sequence number'
,   name varchar(255)
,   title varchar(255)
,   abstract longtext
,   minx double
,   miny double
,   maxx double
,   maxy double
,   queryable tinyint(1) default '0'
,   opaque tinyint(1) default '0'
,   cascaded tinyint(1) default '0'

,   PRIMARY KEY( nid, lid )
);

drop table carto_wms_layer_properties;
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 longtext

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

/* ------------------------------------
create table carto_templates(
    name varchar(32)
,   description varchar(256)
,   content varchar(5000)
,   PRIMARY KEY( name )
);

create table carto_nodes(
    nid integer not null
,   tplname varchar(32)
,   service varchar
,   layers varchar
,   qlayers varchar
,   extent varchar
,   maxextent varchar
,   srs varchar
,   PRIMARY KEY( nid )
);
*/
1	/**
2	* carto_filter_nodes: nodes that contain carto filters
3	*/
4	drop table carto_filter_nodes;
5	create table carto_filter_nodes(
6	nid integer NOT NULL
7	, numblocks integer NOT NULL default '0'
8
9	, PRIMARY KEY(nid)
10	);
11
12
13	/**
14	* carto_filter_blocks: each block is identified by the node id and
15	* the carto filter block id.
16	*/
17	drop table carto_filter_blocks;
18	create table carto_filter_blocks(
19	cfid varchar(254) unique not null
20	, crc int
21	, time int
22	, content blob
23
24	, PRIMARY KEY(cfid)
25	);
26
27	drop table carto_wms_node;
28	create table carto_wms_node(
29	nid integer not null
30	, name varchar(32)
31	, service varchar(255)
32	, capabilities longtext COMMENT 'capabilities text'
33	, bbox varchar(255)
34	, layers varchar(255)
35	, abstract longtext
36	, keywords varchar(255)
37	, title varchar(255)
38	, captime int(11) NOT NULL default '0' COMMENT ''
39
40	, PRIMARY KEY( nid )
41	);
42
43	drop table carto_wms_layer;
44	create table carto_wms_layer(
45	nid integer not null
46	, lid integer not null COMMENT 'layer sequence number'
47	, name varchar(255)
48	, title varchar(255)
49	, abstract longtext
50	, minx double
51	, miny double
52	, maxx double
53	, maxy double
54	, queryable tinyint(1) default '0'
55	, opaque tinyint(1) default '0'
56	, cascaded tinyint(1) default '0'
57
58	, PRIMARY KEY( nid, lid )
59	);
60
61	drop table carto_wms_layer_properties;
62	create table carto_wms_layer_properties(
63	nid integer not null
64	, lid integer not null
65	, property varchar(255) not null
66	, name varchar(255) not null
67	, value longtext
68
69	, PRIMARY KEY( nid, lid, property, name )
70	);
71
72	/* ------------------------------------
73	create table carto_templates(
74	name varchar(32)
75	, description varchar(256)
76	, content varchar(5000)
77	, PRIMARY KEY( name )
78	);
79
80	create table carto_nodes(
81	nid integer not null
82	, tplname varchar(32)
83	, service varchar
84	, layers varchar
85	, qlayers varchar
86	, extent varchar
87	, maxextent varchar
88	, srs varchar
89	, PRIMARY KEY( nid )
90	);
91	*/