Versions Compared

Old Version 4

changes.mady.by.user Pete Boysen

Saved on

compared with

New Version 5

changes.mady.by.user John Fereira

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
SQL
SQL
titleDatabase upgrade script
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_           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,
		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)
	 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');

	', '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), 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.',
		 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;

 

Restart Tomcat

Modifications for Postgres

...

Code Block
alter table tmp_up_layout_restrictions rename to up_layout_restrictions;

 

with

Code Block
SQL
SQL
titleDatabase upgrade script for Postgres


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;