3 ALTER TABLE slice_attribute ADD nodegroup_id integer REFERENCES nodegroups;
5 CREATE INDEX slice_attribute_nodegroup_id_idx ON slice_attribute (nodegroup_id);
7 ---------- view changes
9 DROP VIEW view_slice_attributes;
11 CREATE OR REPLACE VIEW view_slice_attributes AS
13 slice_attribute.slice_attribute_id,
14 slice_attribute.slice_id,
15 slice_attribute.node_id,
16 slice_attribute.nodegroup_id,
17 slice_attribute_types.attribute_type_id,
18 slice_attribute_types.name,
19 slice_attribute_types.description,
20 slice_attribute_types.min_role_id,
23 INNER JOIN slice_attribute_types USING (attribute_type_id);
26 ---------- bump subversion
28 UPDATE plc_db_version SET subversion = 6;
29 SELECT subversion from plc_db_version;