3 -- this is the script to migrate from 4.2 to 5.0
6 ----------------------------------------
7 -- rename nodenetwork into interface
8 ----------------------------------------
10 ALTER TABLE nodenetworks RENAME TO interfaces;
11 ALTER TABLE interfaces RENAME COLUMN nodenetwork_id TO interface_id;
13 ALTER INDEX nodenetworks_node_id_idx RENAME TO interfaces_node_id_idx;
15 -- xxx need manual merge -> turn into tag_type
16 --ALTER TABLE nodenetwork_setting_types RENAME TO interface_setting_types;
17 --ALTER TABLE interface_setting_types RENAME COLUMN nodenetwork_setting_type_id TO interface_setting_type_id;
19 ALTER TABLE nodenetwork_setting RENAME TO interface_setting;
22 ALTER TABLE nodenetworks_ordered RENAME TO interfaces_ordered;
23 ALTER TABLE interfaces_ordered RENAME COLUMN nodenetwork_id TO interface_id;
25 ALTER TABLE node_nodenetworks RENAME TO node_interfaces;
26 ALTER TABLE node_interfaces RENAME COLUMN nodenetwork_ids TO interface_ids;
28 ALTER TABLE nodenetwork_settings RENAME TO interface_settings;
29 ALTER TABLE interface_settings RENAME COLUMN nodenetwork_id TO interface_id;
30 ALTER TABLE interface_settings RENAME COLUMN nodenetwork_setting_ids TO interface_setting_ids;
32 ALTER TABLE view_nodenetwork_settings RENAME TO view_interface_settings;
33 ALTER TABLE view_interface_settings RENAME COLUMN nodenetwork_setting_id TO interface_setting_id;
34 ALTER TABLE view_interface_settings RENAME COLUMN nodenetwork_id TO interface_id;
35 -- xxx need manual merge -> turn into tag_type
36 --ALTER TABLE view_interface_settings RENAME COLUMN nodenetwork_setting_type_id TO interface_setting_type_id;
38 ALTER TABLE view_nodenetworks RENAME TO view_interfaces;
39 ALTER TABLE view_interfaces RENAME COLUMN nodenetwork_id TO interface_id;
40 ALTER TABLE view_interfaces RENAME COLUMN nodenetwork_setting_ids TO interface_setting_ids;
42 ALTER TABLE view_nodes RENAME COLUMN nodenetwork_ids TO interface_ids;
44 ----------------------------------------
46 ----------------------------------------
47 CREATE TABLE tag_types ...
48 CREATE TABLE node_tag ...
50 ---------- related views
51 CREATE OR REPLACE VIEW node_tags AS ...
52 CREATE OR REPLACE VIEW view_node_tags AS ...
54 ----------------------------------------
57 -- a more usable migration script would need to capture more data
58 ----------------------------------------
59 DROP TABLE IF EXISTS nodegroups CASCADE;
62 CREATE TABLE nodegroups ...
63 CREATE OR REPLACE VIEW nodegroup_node AS ...
64 CREATE OR REPLACE VIEW nodegroup_nodes AS ...
65 CREATE OR REPLACE VIEW node_nodegroups AS ...
66 CREATE OR REPLACE VIEW view_nodegroups AS
68 ----------------------------------------
70 ----------------------------------------
72 CREATE OR REPLACE VIEW view_nodes AS ...
74 ----------------------------------------
76 ----------------------------------------
77 --CREATE TABLE link_types ...
78 CREATE TABLE ilink ...
80 CREATE OR REPLACE VIEW ilinks AS ...
81 CREATE OR REPLACE VIEW ilink_src_node AS ...
82 CREATE OR REPLACE VIEW ilink_nodes AS ...
84 ----------------------------------------
86 ----------------------------------------
87 UPDATE plc_db_version SET version=5, subversion=0;