...
The following SQL needs to be run to upgrade the database (from version 2.4.2 to version 2.5.0). Please make a backup of the original database before proceding with these modifications.
Code Block | |||||||
---|---|---|---|---|---|---|---|
| |||||||
create table tmp_up_fragment_restrictions as select fragment_id, node_id, decode(restriction_type,1,'priority',2,'depth',6,'immutable',8,'immutable') restriction_name, restriction_value, restriction_tree_path from up_fragment_restrictions; alter table tmp_up_fragment_restrictions modify restriction_name varchar2(128); create table bak_up_fragment_restrictions as select * from up_fragment_restrictions; drop table up_fragment_restrictions cascade constraints; alter table tmp_up_fragment_restrictions rename to up_fragment_restrictions; alter table up_fragment_restrictions add primary key (FRAGMENT_ID, NODE_ID, RESTRICTION_NAME, RESTRICTION_TREE_PATH); create table tmp_up_layout_restrictions as select layout_id, user_id, node_id, decode(restriction_type,1,'priority',2,'depth',6,'immutable',8,'immutable') restriction_name, restriction_value, restriction_tree_path from up_layout_restrictions; alter table tmp_up_layout_restrictions modify restriction_name varchar2(128); create table bak_up_layout_restrictions as select * from up_layout_restrictions; drop table up_layout_restrictions cascade constraints; alter table tmp_up_layout_restrictions rename to up_layout_restrictions; alter table up_layout_restrictions add primary key (LAYOUT_ID, USER_ID, NODE_ID, RESTRICTION_NAME, RESTRICTION_TREE_PATH); DROP TABLE UP_RESTRICTIONS; DROP TABLE UPC_KEYWORD; UPDATE UP_VERSIONS SET MINOR=5, MICRO=0 WHERE FNAME='UP_FRAMEWORK'; INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT) VALUES (3, 'fragmentTemplate', 2, 1, 45, '08-APR-2005'); INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT) VALUES (4, 'ent-lo', 2, 1, 51, '08-APR-2005'); INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT) VALUES (5, 'news-lo', 2, 1, 52, '08-APR-2005'); INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT) VALUES (8, 'guest-lo', 3, 1, 54, '20-APR-2005'); INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES ('ent-lo', '(MD5)FwlZ/YNTQ/hbNPEIUl8yTGfYwwnp65/g', NULL, 'Entertainment', 'Fragment', NULL); INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES ('fragmentTemplate', '(MD5)TcJ+RAxMebVLfq2+xF1YY4Mv5dRGo7Rg', NULL, 'Fragment', 'Template', NULL); INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES ('news-lo', '(MD5)d3ST813VSpkgg4g7mlVsK2T2pue7b9J6', NULL, 'News', 'Fragment', NULL); INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES ('guest-lo', '(MD5)NZpveCmtCTXi6qaq0Rx7O5HcQDEW3MTE', NULL, NULL, NULL, NULL); UPDATE UP_CHANNEL SET CHAN_CLASS='org.jasig.portal.layout.alm.channels.CContentSubscriber' WHERE CHAN_CLASS='org.jasig.portal.layout.channels.CContentSubscriber'; INSERT INTO UP_CHANNEL ( CHAN_ID, CHAN_TITLE, CHAN_NAME, CHAN_DESC, CHAN_PUBL_ID, CHAN_PUBL_DT, CHAN_APVL_ID, CHAN_APVL_DT, CHAN_TYPE_ID, CHAN_CLASS, CHAN_TIMEOUT, CHAN_EDITABLE, CHAN_HAS_HELP, CHAN_FNAME, CHAN_SECURE) VALUES ( 91, 'User Preferences', 'User Preferences', 'DLM User Preferences channel', 0, SYSDATE, 0, SYSDATE, 1, 'org.jasig.portal.channels.DLMUserPreferences.CUserPreferences', 10000, 'N', 'N', 'portal/userpreferences/dlm', 'N'); INSERT INTO UP_CHANNEL ( CHAN_ID, CHAN_TITLE, CHAN_NAME, CHAN_DESC, CHAN_PUBL_ID, CHAN_PUBL_DT, CHAN_APVL_ID, CHAN_APVL_DT, CHAN_TYPE_ID, CHAN_CLASS, CHAN_TIMEOUT, CHAN_EDITABLE, CHAN_HAS_HELP, CHAN_HAS_ABOUT, CHAN_FNAME, CHAN_SECURE) VALUES ( 82, 'Password Management', 'Password Management', 'Allows management of passwords', 0, SYSDATE, 0, SYSDATE, 1, 'org.jasig.portal.channels.cusermanager.CUserManager', 100000, 'N', 'Y', 'N', 'passwordmgr', 'N'); INSERT INTO UP_CHANNEL ( CHAN_ID, CHAN_TITLE, CHAN_NAME, CHAN_DESC, CHAN_PUBL_ID, CHAN_PUBL_DT, CHAN_APVL_ID, CHAN_APVL_DT, CHAN_TYPE_ID, CHAN_CLASS, CHAN_TIMEOUT, CHAN_EDITABLE, CHAN_HAS_HELP, CHAN_HAS_ABOUT, CHAN_FNAME, CHAN_SECURE ) VALUES ( 50, 'DLM Administrator''s Guide', 'DLM Administrator''s Guide', 'A channel that presents an administrator''s guide for Distributed Layout Management.', 2, '20-APR-2005', 2, '20-APR-2005', -1, 'org.jasig.portal.layout.dlm.channels.guide.DlmIntroChannel', 5000, 'N', 'N', 'N', 'dlm.admin.guide', 'N' ); INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID) VALUES (1, 3, 'Fragment Layout', 1); INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID) VALUES (1, 4, 'Entertainment', 1); INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID) VALUES (1, 5, 'News', 1); INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID) VALUES (1, 8, 'Guests', 1); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 27, 0, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (3, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 27, 46, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 46, 0, 48, NULL, NULL, 'Real Entertainment', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 47, 0, 50, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 48, 47, 49, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 49, 51, 0, NULL, 14, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 50, 0, 0, NULL, 1, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 51, 0, 0, NULL, 9, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (4, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 27, 46, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 46, 0, 48, NULL, NULL, 'Useful News', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 47, 0, 51, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 48, 47, 49, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 49, 50, 0, NULL, 12, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 50, 0, 0, NULL, 11, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 51, 52, 0, NULL, 13, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 52, 0, 0, NULL, 6, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (5, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 27, 46, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 46, 0, 49, NULL, NULL, 'Welcome', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 49, 0, 52, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 52, 0, 0, NULL, 50, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE) VALUES (8, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N'); INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL) VALUES (4, 1, 46, 'cp:editAllowed', 'false'); INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL) VALUES (5, 1, 46, 'cp:moveAllowed', 'false'); INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL) VALUES (4, 1, 49, 'cp:deleteAllowed', 'false'); INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL) VALUES (4, 1, 49, 'cp:moveAllowed', 'false'); INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL) VALUES (4, 1, 49, 'maxNum', '100'); INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL) VALUES (4, 1, 49, 'minNum', '1'); UPDATE UP_CHAN_TYPE SET TYPE_NAME='XML SSL' WHERE TYPE_ID=1; INSERT INTO UP_CHAN_TYPE (TYPE_ID, TYPE_NAME, TYPE, TYPE_DESCR, TYPE_DEF_URI) VALUES ( 8, 'XML XSLT', 'org.jasig.portal.channels.CGenericXSLT', 'Transforms an XML document into a fragment of markup language using a single XSLT.', '/org/jasig/portal/channels/CGenericXSLT/CGenericJustXSLT.cpd'); INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID) VALUES (3, 1, 'HTML browser profile', 'A sample profile for common web browsers', 1, 4, 3); INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID) VALUES (4, 1, 'HTML browser profile', 'A system profile for common web browsers', 1, 4, 3); INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID) VALUES (5, 1, 'HTML browser profile', 'A system profile for common web browsers', 1, 4, 3); INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID) VALUES (8, 1, 'HTML browser profile', 'A sample profile for common web browsers', 1, 4, 3); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (3, 1, 4, 1, 'activeTab', '1'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (3, 1, 3, 2, 'skin', 'imm'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (4, 1, 4, 1, 'activeTab', '1'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (4, 1, 3, 2, 'skin', 'imm'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (5, 1, 4, 1, 'activeTab', '1'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (5, 1, 3, 2, 'skin', 'imm'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (8, 1, 4, 1, 'activeTab', '1'); INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL) VALUES (8, 1, 3, 2, 'skin', 'imm'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (4, 1, 4, 1, 48, 'width', 2, '40%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (4, 1, 4, 1, 47, 'width', 2, '60%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (5, 1, 4, 1, 48, 'width', 2, '30%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (5, 1, 4, 1, 47, 'width', 2, '70%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (1, 1, 4, 1, 5, 'width', 2, '30%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (1, 1, 4, 1, 7, 'width', 2, '70%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (1, 1, 4, 1, 12, 'width', 2, '70%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (1, 1, 4, 1, 10, 'width', 2, '30%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (1, 1, 4, 1, 15, 'width', 2, '70%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (1, 1, 4, 1, 17, 'width', 2, '30%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (4, 1, 4, 1, 48, 'width', 2, '40%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (4, 1, 4, 1, 47, 'width', 2, '60%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (5, 1, 4, 1, 48, 'width', 2, '30%'); INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES (5, 1, 4, 1, 47, 'width', 2, '70%'); INSERT INTO UP_SS_STRUCT (SS_ID, SS_NAME, SS_URI, SS_DESCRIPTION_URI, SS_DESCRIPTION_TEXT) VALUES ( 4, 'DLM Tabs and columns', '/org/jasig/portal/layout/DLM-tab-column/tab-column.xsl', '/org/jasig/portal/layout/DLM-tab-column/tab-column.sdf', 'Presents the DLM layout in terms of tabs and columns.'); INSERT INTO UP_SS_THEME ( SS_ID, SS_NAME, SS_URI, SS_DESCRIPTION_URI, SS_DESCRIPTION_TEXT, STRUCT_SS_ID, SAMPLE_ICON_URI, SAMPLE_URI, MIME_TYPE, DEVICE_TYPE, SERIALIZER_NAME, UP_MODULE_CLASS) VALUES ( 3, 'DLM Nested tables', '/org/jasig/portal/layout/DLM-tab-column/nested-tables/nested-tables.xsl', '/org/jasig/portal/layout/DLM-tab-column/nested-tables/nested-tables.sdf', 'Renders DLM tabs and columns as nested tables', 4, 'media/org/jasig/portal/layout/DLM-tab-column/nested-tables/sample_icon.gif', 'media/org/jasig/portal/layout/DLM-tab-column/nested-tables/sample_full.gif', 'text/html', 'workstation', 'HTML', 'org.jasig.portal.channels.DLMUserPreferences.TabColumnPrefsState'); INSERT INTO UP_SS_THEME_PARM (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE) VALUES (3, 'skin', 'java', 'Design skin name', 1); INSERT INTO UP_SS_THEME_PARM (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE) VALUES (3, 'minimized', 'false', 'Flag determining if the channel is minimized or not', 3); INSERT INTO UP_SS_STRUCT_PAR (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE) VALUES (4, 'activeTab', '1', 'The number of the DLM tab that is initially active', 1); INSERT INTO UP_SS_STRUCT_PAR (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE) VALUES (4, 'width', '100%', 'Width of a DLM column', 2); INSERT INTO UP_SS_MAP (THEME_SS_ID, STRUCT_SS_ID, MIME_TYPE) VALUES (3, 4, 'text/html'); INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE) VALUES ('UP_FRAMEWORK', 3, 'local.0', 'SUBSCRIBE', 'CHAN_ID.91', 'GRANT'); INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE) VALUES ('UP_FRAMEWORK', 3, 'local.1', 'SUBSCRIBE', 'CHAN_ID.82', 'GRANT'); INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE) VALUES ('UP_FRAMEWORK', 3, 'local.2', 'SUBSCRIBE', 'CHAN_ID.82', 'GRANT'); INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE) VALUES ('UP_FRAMEWORK', 3, 'local.3', 'SUBSCRIBE', 'CHAN_ID.82', 'GRANT'); INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE) VALUES ('org.jasig.portal.channels.cusermanager.CUserManager', 3, 'local.14', 'acctmgr', 'Account Manager', 'GRANT'); INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE) VALUES ('UP_FRAMEWORK', 3, 'local.0', 'SUBSCRIBE', 'CHAN_ID.50', 'GRANT'); INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP) VALUES (0, 'local', 'fragmentTemplate', 'F'); INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP) VALUES (4, 'local', 'ent-lo', 'F'); INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP) VALUES (4, 'local', 'news-lo', 'F'); INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP) VALUES (51, 'local', '82', 'F'); INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP) VALUES (0, 'local', 'guest-lo', 'F'); INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP) VALUES (52, 'local', '50', 'F'); COMMIT; |
...
Code Block |
---|
alter table tmp_up_layout_restrictions rename to up_layout_restrictions; |
with
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
create table tmp_up_fragment_restrictions as select fragment_id, node_id, case when restriction_type=1 then 'priority' when restriction_type=2 then 'depth' when restriction_type=6 then 'immutable' else 'immutable' end as restriction_name, restriction_value, restriction_tree_path from up_fragment_restrictions; alter table tmp_up_fragment_restrictions alter column restriction_name type varchar(128); create table bak_up_fragment_restrictions as select * from up_fragment_restrictions; drop table up_fragment_restrictions cascade; alter table tmp_up_fragment_restrictions rename to up_fragment_restrictions; alter table up_fragment_restrictions add primary key (FRAGMENT_ID, NODE_ID, RESTRICTION_NAME, RESTRICTION_TREE_PATH); create table tmp_up_layout_restrictions as select layout_id, user_id, node_id, case when restriction_type=1 then 'priority' when restriction_type=2 then 'depth' when restriction_type=6 then 'immutable' else 'immutable' end as restriction_name, restriction_value, restriction_tree_path from up_layout_restrictions; alter table tmp_up_layout_restrictions alter column restriction_name type varchar(128); create table bak_up_layout_restrictions as select * from up_layout_restrictions; drop table up_layout_restrictions cascade; |
...