hint TEXT NOT NULL
);
INSERT INTO depository.base_object_type (label, hint) VALUES ('Subscription Pattern and Caption', 'scap');
-INSERT INTO depository.base_object_type (base_type, system) VALUES (CURRVAL(depository.base_object_type_id_seq), 'Evergreen-2.1');
-INSERT INTO depository.base_object_type (base_type, system) VALUES (CURRVAL(depository.base_object_type_id_seq), 'Evergreen-2.2');
-INSERT INTO depository.base_object_type (base_type, system) VALUES (CURRVAL(depository.base_object_type_id_seq), 'Evergreen-2.3');
-INSERT INTO depository.base_object_type (base_type, system) VALUES (CURRVAL(depository.base_object_type_id_seq), 'Evergreen-2.4');
-
CREATE TABLE depository.versioned_object_type (
id SERIAL PRIMARY KEY,
base_type INT NOT NULL REFERENCES depository.base_object_type (id),
system TEXT NOT NULL REFERENCES depository.source_system (name)
);
+INSERT INTO depository.versioned_object_type (base_type, system) VALUES (CURRVAL('depository.base_object_type_id_seq'), 'Evergreen-2.1');
+INSERT INTO depository.versioned_object_type (base_type, system) VALUES (CURRVAL('depository.base_object_type_id_seq'), 'Evergreen-2.2');
+INSERT INTO depository.versioned_object_type (base_type, system) VALUES (CURRVAL('depository.base_object_type_id_seq'), 'Evergreen-2.3');
+INSERT INTO depository.versioned_object_type (base_type, system) VALUES (CURRVAL('depository.base_object_type_id_seq'), 'Evergreen-2.4');
+
CREATE TABLE depository.versioned_object_type_property_ignore (
id SERIAL PRIMARY KEY,
);
CREATE INDEX grp_tree_parent_idx ON permission.grp_tree (parent);
-NSERT INTO permission.grp_tree (name, perm_interval, usergroup, application_perm) VALUES
+INSERT INTO permission.grp_tree (name, perm_interval, usergroup, application_perm) VALUES
('Users', '3 years', TRUE, 'group_application.user');
CREATE TABLE permission.grp_perm_map (
CONSTRAINT perm_grp_once UNIQUE (grp,perm)
);
-INSERT INTO permission.grp_perm_map (grp,perm,depth) SELECT CURRVAL(permission.grp_tree_id_seq), pl.id, 0 FROM permission.perm_list pl WHERE id > 0;
+INSERT INTO permission.grp_perm_map (grp,perm,depth) SELECT CURRVAL('permission.grp_tree_id_seq'), pl.id, 0 FROM permission.perm_list pl WHERE id > 0;
CREATE TABLE permission.usr_perm_map (
id SERIAL PRIMARY KEY,