1 ---------- view changes
3 DROP VIEW view_slice_attributes;
5 CREATE OR REPLACE VIEW view_slice_attributes AS
7 slice_attribute.slice_attribute_id,
8 slice_attribute.slice_id,
9 slice_attribute.node_id,
10 slice_attribute_types.attribute_type_id,
11 slice_attribute_types.name,
12 slice_attribute_types.description,
13 slice_attribute_types.min_role_id,
16 INNER JOIN slice_attribute_types USING (attribute_type_id);
19 DROP INDEX slice_attribute_nodegroup_id_idx;
20 ALTER TABLE slice_attribute DROP COLUMN nodegroup_id;
22 ---------- revert subversion
24 UPDATE plc_db_version SET subversion = 5;
25 SELECT subversion from plc_db_version;