...
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;
|
...