<commit_before><?xml version="1.0"?>
<!-- $Revision$ -->

<tables>
  <table>
    <name>UP_USER</name>
    <columns>
      <column> <name>USER_ID</name>          <type>INTEGER</type>                     </column>
      <column> <name>USER_NAME</name>        <type>VARCHAR</type>   <param>35</param> </column>
      <column> <name>USER_DFLT_USR_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>USER_DFLT_LAY_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>CURR_LAY_ID</name>      <type>INTEGER</type>                     </column>
      <column> <name>NEXT_STRUCT_ID</name> <type>INTEGER</type>                   </column>
      <column> <name>LST_CHAN_UPDT_DT</name> <type>TIMESTAMP</type>                   </column>
    </columns>
  </table>

  <table>
    <name>UP_PERSON_DIR</name>
    <columns>
      <column> <name>USER_ID</name>         <type>INTEGER</type>	                   </column>
      <column> <name>ENCRPTD_PSWD</name>	  <type>VARCHAR</type>	 <param>64</param> </column>
      <column> <name>LST_PSWD_CGH_DT</name> <type>TIMESTAMP</type>                   </column>
                        <column> <name>FIRST_NAME</name>			<type>VARCHAR</type>   <param>15</param> </column>
                        <column> <name>LAST_NAME</name>       <type>VARCHAR</type>   <param>15</param> </column>
                        <column> <name>EMAIL</name>           <type>VARCHAR</type>   <param>60</param> </column>
    </columns>
    <primary-key>USER_ID</primary-key>
  </table>

  <table>
    <name>UP_PERMISSIONS</name>
    <columns>
      <column>
        <name>OWNER</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>PRINCIPAL</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>ACTIVITY</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>TARGET</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>PERMISSION_TYPE</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>EFFECTIVE</name>
        <type>TIMESTAMP</type>
      </column>
      <column>
        <name>EXPIRES</name>
        <type>TIMESTAMP</type>
      </column>
    </columns>
  </table>

  <table>
    <name>UP_USER_PARAM</name>
    <columns>
      <column> <name>USER_ID</name>          <type>INTEGER</type>                    </column>
      <column> <name>USER_PARAM_NAME</name>  <type>VARCHAR</type> <param>35</param>  </column>
      <column> <name>USER_PARAM_VALUE</name> <type>VARCHAR</type> <param>255</param> </column>
    </columns>
    <not-null>USER_ID</not-null>
  </table>

  <table>
    <name>UP_USER_LAYOUT</name>
    <columns>
      <column> <name>LAYOUT_ID</name>      <type>INTEGER</type>                   </column>
      <column> <name>USER_ID</name>        <type>INTEGER</type>                   </column>
      <column> <name>LAYOUT_TITLE</name>   <type>VARCHAR</type> <param>15</param> </column>
      <column> <name>INIT_STRUCT_ID</name> <type>INTEGER</type>                   </column>
    </columns>
    <primary-key>LAYOUT_ID</primary-key>
    <primary-key>USER_ID</primary-key>
  </table>

  <table>
    <name>UP_LAYOUT_STRUCT</name>
    <columns>
      <column> <name>USER_ID</name>        <type>INTEGER</type>                   </column>
      <column> <name>LAYOUT_ID</name>      <type>INTEGER</type>                   </column>
      <column> <name>STRUCT_ID</name>      <type>INTEGER</type>                   </column>
      <column> <name>NEXT_STRUCT_ID</name> <type>INTEGER</type>                   </column>
      <column> <name>CHLD_STRUCT_ID</name> <type>INTEGER</type>                   </column>
      <column> <name>EXTERNAL_ID</name>    <type>INTEGER</type>                   </column>
      <column> <name>CHAN_ID</name>        <type>INTEGER</type>                   </column>
      <column> <name>NAME</name>           <type>VARCHAR</type> <param>35</param> </column>
      <column> <name>TYPE</name>           <type>VARCHAR</type> <param>35</param> </column>
      <column> <name>HIDDEN</name>         <type>VARCHAR</type> <param>1</param>  </column>
      <column> <name>IMMUTABLE</name>      <type>VARCHAR</type> <param>1</param>  </column>
      <column> <name>UNREMOVABLE</name>      <type>VARCHAR</type> <param>1</param>  </column>
    </columns>
    <primary-key>LAYOUT_ID</primary-key>
    <primary-key>USER_ID</primary-key>
    <primary-key>STRUCT_ID</primary-key>
  </table>

  <table>
    <name>UP_STRUCT_PARAM</name>
    <columns>
      <column> <name>USER_ID</name>         <type>INTEGER</type>                     </column>
      <column> <name>LAYOUT_ID</name>       <type>INTEGER</type>                     </column>
      <column> <name>STRUCT_ID</name>       <type>INTEGER</type>                     </column>
      <column> <name>STRUCT_PARM_NM</name>  <type>VARCHAR</type> <param>35</param>   </column>
      <column> <name>STRUCT_PARM_VAL</name> <type>VARCHAR</type> <param>1950</param> </column>
    </columns>
    <not-null>LAYOUT_ID</not-null>
    <not-null>USER_ID</not-null>
    <not-null>STRUCT_ID</not-null>
    <not-null>STRUCT_PARM_NM</not-null>
    <not-null>STRUCT_PARM_VAL</not-null>
  </table>

  <table>
    <name>UP_CHANNEL</name>
    <columns>
      <column> <name>CHAN_ID</name>          <type>INTEGER</type>                      </column>
      <column> <name>CHAN_TITLE</name>       <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>CHAN_DESC</name>        <type>VARCHAR</type>   <param>255</param> </column>
      <column> <name>CHAN_CLASS</name>       <type>VARCHAR</type>   <param>100</param> </column>
      <column> <name>CHAN_PUBL_ID</name>     <type>INTEGER</type>                      </column>
      <column> <name>CHAN_PUBL_DT</name>     <type>TIMESTAMP</type>                    </column>
      <column> <name>CHAN_APVL_ID</name>     <type>INTEGER</type>                      </column>
      <column> <name>CHAN_APVL_DT</name>     <type>TIMESTAMP</type>                    </column>
      <column> <name>CHAN_TIMEOUT</name>     <type>INTEGER</type>                      </column>
      <column> <name>CHAN_MINIMIZABLE</name> <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_EDITABLE</name>    <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_HAS_HELP</name>    <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_HAS_ABOUT</name>   <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_UNREMOVABLE</name> <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_DETACHABLE</name>  <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_NAME</name>        <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>CHAN_FNAME</name>       <type>VARCHAR</type>   <param>255</param> </column>
    </columns>
    <primary-key>CHAN_ID</primary-key>
  </table>

  <table>
    <name>UP_CHAN_PARAM</name>
    <columns>
      <column> <name>CHAN_ID</name>        <type>INTEGER</type>                    </column>
      <column> <name>CHAN_PARM_NM</name>   <type>VARCHAR</type> <param>35</param>  </column>
      <column> <name>CHAN_PARM_DESC</name> <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>CHAN_PARM_VAL</name>  <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>CHAN_PARM_OVRD</name> <type>VARCHAR</type> <param>1</param>   </column>
    </columns>
    <not-null>CHAN_ID</not-null>
    <not-null>CHAN_PARM_NM</not-null>
  </table>

  <table>
    <name>UP_CATEGORY</name>
    <columns>
      <column> <name>CAT_ID</name>          <type>INTEGER</type>                      </column>
      <column> <name>CAT_TITLE</name>       <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>CAT_DESC</name>        <type>VARCHAR</type>   <param>255</param> </column>
      <column> <name>PARENT_CAT_ID</name>   <type>INTEGER</type>                      </column>
      <column> <name>NEXT_CAT_ID</name>     <type>INTEGER</type>                      </column>
      <column> <name>PRIOR_CAT_ID</name>    <type>INTEGER</type>                      </column>
      <column> <name>FST_CHLD_CAT_ID</name> <type>INTEGER</type>                      </column>
    </columns>
    <primary-key>CAT_ID</primary-key>
  </table>

  <table>
    <name>UP_CAT_CHAN</name>
    <columns>
      <column> <name>CHAN_ID</name> <type>INTEGER</type> </column>
      <column> <name>CAT_ID</name>  <type>INTEGER</type> </column>
    </columns>
    <primary-key>CAT_ID</primary-key>
    <primary-key>CHAN_ID</primary-key>
  </table>

  <table>
    <name>UP_ROLE</name>
    <columns>
      <column> <name>ROLE_ID</name>          <type>INTEGER</type>                      </column>
      <column> <name>ROLE_TITLE</name>       <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>ROLE_DESC</name>        <type>VARCHAR</type>   <param>255</param> </column>
      <column> <name>ROLE_DFLT_USR_ID</name> <type>INTEGER</type>                      </column>
      <column> <name>ROLE_DFLT_LAY_ID</name> <type>INTEGER</type>                      </column>
      <column> <name>ROLE_OWNER_ID</name>    <type>INTEGER</type>                      </column>
      <column> <name>ROLE_CREATE_ID</name>   <type>TIMESTAMP</type>                    </column>
    </columns>
    <primary-key>ROLE_ID</primary-key>
  </table>

  <table>
    <name>UP_USER_ROLE</name>
    <columns>
      <column> <name>USER_ID</name>       <type>INTEGER</type>                  </column>
      <column> <name>ROLE_ID</name>       <type>INTEGER</type>                  </column>
      <column> <name>PRIM_ROLE_IND</name> <type>VARCHAR</type> <param>1</param> </column>
    </columns>
    <not-null>USER_ID</not-null>
    <not-null>ROLE_ID</not-null>
  </table>

  <table>
    <name>UP_ROLE_CHAN</name>
    <columns>
      <column> <name>ROLE_ID</name>      <type>INTEGER</type>                    </column>
      <column> <name>CHAN_ID</name>      <type>INTEGER</type>                    </column>
      <column> <name>RELEASE_DT</name>   <type>TIMESTAMP</type>                  </column>
      <column> <name>APPROVAL_FLG</name> <type>VARCHAR</type>   <param>1</param> </column>
    </columns>
    <not-null>ROLE_ID</not-null>
    <not-null>CHAN_ID</not-null>
  </table>

  <table>
    <name>UP_KEYWORD</name>
    <columns>
      <column> <name>CHAN_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>ROLE_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>USER_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>KEYWORD</name> <type>VARCHAR</type>  <param>512</param> </column>
    </columns>
    <primary-key>CHAN_ID</primary-key>
    <primary-key>ROLE_ID</primary-key>
    <primary-key>USER_ID</primary-key>
  </table>

  <table>
    <name>UP_CHAN_TYPES</name>
    <columns>
      <column> <name>TYPE_ID</name>      <type>INTEGER</type>                        </column>
      <column> <name>TYPE</name>         <type>VARCHAR</type>     <param>50</param>  </column>
      <column> <name>TYPE_NAME</name>    <type>VARCHAR</type>     <param>70</param>  </column>
      <column> <name>TYPE_DESCR</name>   <type>LONGVARCHAR</type>                    </column>
      <column> <name>TYPE_DEF_URI</name> <type>VARCHAR</type>     <param>255</param> </column>
    </columns>
    <primary-key>TYPE_ID</primary-key>
  </table>

  <table>
    <name>UPC_BOOKMARKS</name>
    <columns>
      <column> <name>PORTAL_USER_ID</name> <type>INTEGER</type>     </column>
      <column> <name>BOOKMARK_XML</name>   <type>LONGVARCHAR</type> </column>
    </columns>
    <primary-key>PORTAL_USER_ID</primary-key>
  </table>

  <table>
    <name>UP_SEQUENCE</name>
    <columns>
      <column> <name>SEQUENCE_NAME</name>  <type>VARCHAR</type> <param>35</param> </column>
      <column> <name>SEQUENCE_VALUE</name> <type>INTEGER</type>                   </column>
    </columns>
    <primary-key>SEQUENCE_NAME</primary-key>
  </table>

  <table>
    <name>UP_USER_UA_MAP</name>
    <columns>
      <column> <name>USER_ID</name>    <type>INTEGER</type>                    </column>
      <column> <name>USER_AGENT</name> <type>VARCHAR</type> <param>100</param> </column>
      <column> <name>PROFILE_ID</name> <type>INTEGER</type>                    </column>
    </columns>
  </table>

  <table>
    <name>UP_USER_PROFILES</name>
    <columns>
      <column> <name>USER_ID</name>           <type>INTEGER</type>                    </column>
      <column> <name>PROFILE_ID</name>        <type>INTEGER</type>                    </column>
      <column> <name>PROFILE_NAME</name>      <type>VARCHAR</type> <param>50</param>  </column>
      <column> <name>DESCRIPTION</name>       <type>VARCHAR</type> <param>100</param> </column>
      <column> <name>LAYOUT_ID</name>         <type>INTEGER</type>                    </column>
      <column> <name>STRUCTURE_SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>THEME_SS_ID</name>     <type>INTEGER</type>   </column>
    </columns>
    <primary-key>USER_ID</primary-key>
    <primary-key>PROFILE_ID</primary-key>
  </table>

  <table>
    <name>UP_USER_SS_PARMS</name>
    <columns>
      <column> <name>USER_ID</name>              <type>INTEGER</type>                       </column>
      <column> <name>PROFILE_ID</name>           <type>INTEGER</type>                       </column>
      <column> <name>SS_ID</name>      <type>INTEGER</type>   </column>
      <column> <name>SS_TYPE</name> <type>INTEGER</type> </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
    </columns>
  </table>

  <table>
    <name>UP_USER_SS_ATTS</name>
    <columns>
      <column> <name>USER_ID</name>              <type>INTEGER</type>                       </column>
      <column> <name>PROFILE_ID</name>           <type>INTEGER</type>                       </column>
      <column> <name>SS_ID</name>      <type>INTEGER</type>   </column>
      <column> <name>SS_TYPE</name> <type>INTEGER</type> </column>
      <column> <name>STRUCT_ID</name>      <type>INTEGER</type>                               </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_TYPE</name>             <type>INTEGER</type>    </column>
      <column> <name>PARAM_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
    </columns>
  </table>


  <table>
    <name>UP_THEME_SS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>SS_NAME</name>             <type>VARCHAR</type>     <param>30</param>  </column>
      <column> <name>SS_URI</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_URI</name>  <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_TEXT</name> <type>LONGVARCHAR</type>                    </column>
      <column> <name>STRUCT_SS_ID</name>		<type>INTEGER</type> </column>
      <column> <name>SAMPLE_ICON_URI</name>      <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>SAMPLE_URI</name>      <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>MIME_TYPE</name>      <type>VARCHAR</type> <param>30</param> </column>
      <column> <name>DEVICE_TYPE</name>      <type>VARCHAR</type> <param>30</param> </column>
      <column> <name>SERIALIZER_NAME</name>      <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>UP_MODULE_CLASS</name>      <type>VARCHAR</type> <param>255</param> </column>
    </columns>
    <primary-key>SS_ID</primary-key>
  </table>

  <table>
    <name>UP_STRUCT_SS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>SS_NAME</name>             <type>VARCHAR</type>     <param>30</param>  </column>
      <column> <name>SS_URI</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_URI</name>  <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_TEXT</name> <type>LONGVARCHAR</type>                    </column>
    </columns>
    <primary-key>SS_ID</primary-key>
  </table>

  <table>
    <name>UP_STRUCT_PARAMS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_DEFAULT_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>PARAM_DESCRIPT</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>TYPE</name> <type>INTEGER</type> </column>
    </columns>
    <primary-key>SS_ID</primary-key>
    <primary-key>PARAM_NAME</primary-key>
    <primary-key>TYPE</primary-key>
  </table>

  <table>
    <name>UP_THEME_PARAMS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_DEFAULT_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>PARAM_DESCRIPT</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>TYPE</name> <type>INTEGER</type> </column>
    </columns>
    <primary-key>SS_ID</primary-key>
    <primary-key>PARAM_NAME</primary-key>
    <primary-key>TYPE</primary-key>
  </table>

  <table>
    <name>UP_SS_MAP</name>
    <columns>
      <column> <name>THEME_SS_ID</name>    <type>INTEGER</type>                   </column>
      <column> <name>STRUCT_SS_ID</name>   <type>INTEGER</type>                   </column>
      <column> <name>MIME_TYPE</name>      <type>VARCHAR</type> <param>30</param> </column>
    </columns>
  </table>

  <table>
    <name>UP_MIME_TYPES</name>
    <columns>
      <column> <name>MIME_TYPE</name>             <type>VARCHAR</type>     <param>30</param> </column>
      <column> <name>MIME_TYPE_DESCRIPTION</name> <type>LONGVARCHAR</type>                   </column>
    </columns>
    <primary-key>MIME_TYPE</primary-key>
  </table>

</tables>

<commit_msg>Added another table for Skins<commit_after><?xml version="1.0"?>
<!-- $Revision$ -->

<tables>
  <table>
    <name>UP_USER</name>
    <columns>
      <column> <name>USER_ID</name>          <type>INTEGER</type>                     </column>
      <column> <name>USER_NAME</name>        <type>VARCHAR</type>   <param>35</param> </column>
      <column> <name>USER_DFLT_USR_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>USER_DFLT_LAY_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>CURR_LAY_ID</name>      <type>INTEGER</type>                     </column>
      <column> <name>NEXT_STRUCT_ID</name> <type>INTEGER</type>                   </column>
      <column> <name>LST_CHAN_UPDT_DT</name> <type>TIMESTAMP</type>                   </column>
    </columns>
  </table>

  <table>
    <name>UP_PERSON_DIR</name>
    <columns>
      <column> <name>USER_ID</name>         <type>INTEGER</type>	                   </column>
      <column> <name>ENCRPTD_PSWD</name>	<type>VARCHAR</type>	 <param>64</param> </column>
      <column> <name>LST_PSWD_CGH_DT</name> <type>TIMESTAMP</type>                   </column>
      <column> <name>FIRST_NAME</name>		<type>VARCHAR</type>   <param>15</param> </column>
      <column> <name>LAST_NAME</name>       <type>VARCHAR</type>   <param>15</param> </column>
      <column> <name>EMAIL</name>           <type>VARCHAR</type>   <param>60</param> </column>
    </columns>
    <primary-key>USER_ID</primary-key>
  </table>

  <table>
    <name>UP_PERMISSIONS</name>
    <columns>
      <column>
        <name>OWNER</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>PRINCIPAL</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>ACTIVITY</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>TARGET</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>PERMISSION_TYPE</name>
        <type>VARCHAR</type>
        <param>255</param>
      </column>
      <column>
        <name>EFFECTIVE</name>
        <type>TIMESTAMP</type>
      </column>
      <column>
        <name>EXPIRES</name>
        <type>TIMESTAMP</type>
      </column>
    </columns>
  </table>

  <table>
    <name>UP_USER_PARAM</name>
    <columns>
      <column> <name>USER_ID</name>          <type>INTEGER</type>                    </column>
      <column> <name>USER_PARAM_NAME</name>  <type>VARCHAR</type> <param>35</param>  </column>
      <column> <name>USER_PARAM_VALUE</name> <type>VARCHAR</type> <param>255</param> </column>
    </columns>
    <not-null>USER_ID</not-null>
  </table>

  <table>
    <name>UP_USER_LAYOUT</name>
    <columns>
      <column> <name>LAYOUT_ID</name>      <type>INTEGER</type>                   </column>
      <column> <name>USER_ID</name>        <type>INTEGER</type>                   </column>
      <column> <name>LAYOUT_TITLE</name>   <type>VARCHAR</type> <param>15</param> </column>
      <column> <name>INIT_STRUCT_ID</name> <type>INTEGER</type>                   </column>
    </columns>
    <primary-key>LAYOUT_ID</primary-key>
    <primary-key>USER_ID</primary-key>
  </table>

  <table>
    <name>UP_LAYOUT_STRUCT</name>
    <columns>
      <column> <name>USER_ID</name>        <type>INTEGER</type>                   </column>
      <column> <name>LAYOUT_ID</name>      <type>INTEGER</type>                   </column>
      <column> <name>STRUCT_ID</name>      <type>INTEGER</type>                   </column>
      <column> <name>NEXT_STRUCT_ID</name> <type>INTEGER</type>                   </column>
      <column> <name>CHLD_STRUCT_ID</name> <type>INTEGER</type>                   </column>
      <column> <name>EXTERNAL_ID</name>    <type>INTEGER</type>                   </column>
      <column> <name>CHAN_ID</name>        <type>INTEGER</type>                   </column>
      <column> <name>NAME</name>           <type>VARCHAR</type> <param>35</param> </column>
      <column> <name>TYPE</name>           <type>VARCHAR</type> <param>35</param> </column>
      <column> <name>HIDDEN</name>         <type>VARCHAR</type> <param>1</param>  </column>
      <column> <name>IMMUTABLE</name>      <type>VARCHAR</type> <param>1</param>  </column>
      <column> <name>UNREMOVABLE</name>      <type>VARCHAR</type> <param>1</param>  </column>
    </columns>
    <primary-key>LAYOUT_ID</primary-key>
    <primary-key>USER_ID</primary-key>
    <primary-key>STRUCT_ID</primary-key>
  </table>

  <table>
    <name>UP_STRUCT_PARAM</name>
    <columns>
      <column> <name>USER_ID</name>         <type>INTEGER</type>                     </column>
      <column> <name>LAYOUT_ID</name>       <type>INTEGER</type>                     </column>
      <column> <name>STRUCT_ID</name>       <type>INTEGER</type>                     </column>
      <column> <name>STRUCT_PARM_NM</name>  <type>VARCHAR</type> <param>35</param>   </column>
      <column> <name>STRUCT_PARM_VAL</name> <type>VARCHAR</type> <param>1950</param> </column>
    </columns>
    <not-null>LAYOUT_ID</not-null>
    <not-null>USER_ID</not-null>
    <not-null>STRUCT_ID</not-null>
    <not-null>STRUCT_PARM_NM</not-null>
    <not-null>STRUCT_PARM_VAL</not-null>
  </table>

  <table>
    <name>UP_CHANNEL</name>
    <columns>
      <column> <name>CHAN_ID</name>          <type>INTEGER</type>                      </column>
      <column> <name>CHAN_TITLE</name>       <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>CHAN_DESC</name>        <type>VARCHAR</type>   <param>255</param> </column>
      <column> <name>CHAN_CLASS</name>       <type>VARCHAR</type>   <param>100</param> </column>
      <column> <name>CHAN_PUBL_ID</name>     <type>INTEGER</type>                      </column>
      <column> <name>CHAN_PUBL_DT</name>     <type>TIMESTAMP</type>                    </column>
      <column> <name>CHAN_APVL_ID</name>     <type>INTEGER</type>                      </column>
      <column> <name>CHAN_APVL_DT</name>     <type>TIMESTAMP</type>                    </column>
      <column> <name>CHAN_TIMEOUT</name>     <type>INTEGER</type>                      </column>
      <column> <name>CHAN_MINIMIZABLE</name> <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_EDITABLE</name>    <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_HAS_HELP</name>    <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_HAS_ABOUT</name>   <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_UNREMOVABLE</name> <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_DETACHABLE</name>  <type>VARCHAR</type>   <param>1</param>   </column>
      <column> <name>CHAN_NAME</name>        <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>CHAN_FNAME</name>       <type>VARCHAR</type>   <param>255</param> </column>
    </columns>
    <primary-key>CHAN_ID</primary-key>
  </table>

  <table>
    <name>UP_CHAN_PARAM</name>
    <columns>
      <column> <name>CHAN_ID</name>        <type>INTEGER</type>                    </column>
      <column> <name>CHAN_PARM_NM</name>   <type>VARCHAR</type> <param>35</param>  </column>
      <column> <name>CHAN_PARM_DESC</name> <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>CHAN_PARM_VAL</name>  <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>CHAN_PARM_OVRD</name> <type>VARCHAR</type> <param>1</param>   </column>
    </columns>
    <not-null>CHAN_ID</not-null>
    <not-null>CHAN_PARM_NM</not-null>
  </table>

  <table>
    <name>UP_CATEGORY</name>
    <columns>
      <column> <name>CAT_ID</name>          <type>INTEGER</type>                      </column>
      <column> <name>CAT_TITLE</name>       <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>CAT_DESC</name>        <type>VARCHAR</type>   <param>255</param> </column>
      <column> <name>PARENT_CAT_ID</name>   <type>INTEGER</type>                      </column>
      <column> <name>NEXT_CAT_ID</name>     <type>INTEGER</type>                      </column>
      <column> <name>PRIOR_CAT_ID</name>    <type>INTEGER</type>                      </column>
      <column> <name>FST_CHLD_CAT_ID</name> <type>INTEGER</type>                      </column>
    </columns>
    <primary-key>CAT_ID</primary-key>
  </table>

  <table>
    <name>UP_CAT_CHAN</name>
    <columns>
      <column> <name>CHAN_ID</name> <type>INTEGER</type> </column>
      <column> <name>CAT_ID</name>  <type>INTEGER</type> </column>
    </columns>
    <primary-key>CAT_ID</primary-key>
    <primary-key>CHAN_ID</primary-key>
  </table>

  <table>
    <name>UP_ROLE</name>
    <columns>
      <column> <name>ROLE_ID</name>          <type>INTEGER</type>                      </column>
      <column> <name>ROLE_TITLE</name>       <type>VARCHAR</type>   <param>35</param>  </column>
      <column> <name>ROLE_DESC</name>        <type>VARCHAR</type>   <param>255</param> </column>
      <column> <name>ROLE_DFLT_USR_ID</name> <type>INTEGER</type>                      </column>
      <column> <name>ROLE_DFLT_LAY_ID</name> <type>INTEGER</type>                      </column>
      <column> <name>ROLE_OWNER_ID</name>    <type>INTEGER</type>                      </column>
      <column> <name>ROLE_CREATE_ID</name>   <type>TIMESTAMP</type>                    </column>
    </columns>
    <primary-key>ROLE_ID</primary-key>
  </table>

  <table>
    <name>UP_USER_ROLE</name>
    <columns>
      <column> <name>USER_ID</name>       <type>INTEGER</type>                  </column>
      <column> <name>ROLE_ID</name>       <type>INTEGER</type>                  </column>
      <column> <name>PRIM_ROLE_IND</name> <type>VARCHAR</type> <param>1</param> </column>
    </columns>
    <not-null>USER_ID</not-null>
    <not-null>ROLE_ID</not-null>
  </table>

  <table>
    <name>UP_ROLE_CHAN</name>
    <columns>
      <column> <name>ROLE_ID</name>      <type>INTEGER</type>                    </column>
      <column> <name>CHAN_ID</name>      <type>INTEGER</type>                    </column>
      <column> <name>RELEASE_DT</name>   <type>TIMESTAMP</type>                  </column>
      <column> <name>APPROVAL_FLG</name> <type>VARCHAR</type>   <param>1</param> </column>
    </columns>
    <not-null>ROLE_ID</not-null>
    <not-null>CHAN_ID</not-null>
  </table>

  <table>
    <name>UP_KEYWORD</name>
    <columns>
      <column> <name>CHAN_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>ROLE_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>USER_ID</name> <type>INTEGER</type>                     </column>
      <column> <name>KEYWORD</name> <type>VARCHAR</type>  <param>512</param> </column>
    </columns>
    <primary-key>CHAN_ID</primary-key>
    <primary-key>ROLE_ID</primary-key>
    <primary-key>USER_ID</primary-key>
  </table>

  <table>
    <name>UP_CHAN_TYPES</name>
    <columns>
      <column> <name>TYPE_ID</name>      <type>INTEGER</type>                        </column>
      <column> <name>TYPE</name>         <type>VARCHAR</type>     <param>50</param>  </column>
      <column> <name>TYPE_NAME</name>    <type>VARCHAR</type>     <param>70</param>  </column>
      <column> <name>TYPE_DESCR</name>   <type>LONGVARCHAR</type>                    </column>
      <column> <name>TYPE_DEF_URI</name> <type>VARCHAR</type>     <param>255</param> </column>
    </columns>
    <primary-key>TYPE_ID</primary-key>
  </table>

  <table>
    <name>UPC_BOOKMARKS</name>
    <columns>
      <column> <name>PORTAL_USER_ID</name> <type>INTEGER</type>     </column>
      <column> <name>BOOKMARK_XML</name>   <type>LONGVARCHAR</type> </column>
    </columns>
    <primary-key>PORTAL_USER_ID</primary-key>
  </table>

  <table>
    <name>UP_SEQUENCE</name>
    <columns>
      <column> <name>SEQUENCE_NAME</name>  <type>VARCHAR</type> <param>35</param> </column>
      <column> <name>SEQUENCE_VALUE</name> <type>INTEGER</type>                   </column>
    </columns>
    <primary-key>SEQUENCE_NAME</primary-key>
  </table>

  <table>
    <name>UP_USER_UA_MAP</name>
    <columns>
      <column> <name>USER_ID</name>    <type>INTEGER</type>                    </column>
      <column> <name>USER_AGENT</name> <type>VARCHAR</type> <param>100</param> </column>
      <column> <name>PROFILE_ID</name> <type>INTEGER</type>                    </column>
    </columns>
  </table>

  <table>
    <name>UP_USER_PROFILES</name>
    <columns>
      <column> <name>USER_ID</name>           <type>INTEGER</type>                    </column>
      <column> <name>PROFILE_ID</name>        <type>INTEGER</type>                    </column>
      <column> <name>PROFILE_NAME</name>      <type>VARCHAR</type> <param>50</param>  </column>
      <column> <name>DESCRIPTION</name>       <type>VARCHAR</type> <param>100</param> </column>
      <column> <name>LAYOUT_ID</name>         <type>INTEGER</type>                    </column>
      <column> <name>STRUCTURE_SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>THEME_SS_ID</name>     <type>INTEGER</type>   </column>
    </columns>
    <primary-key>USER_ID</primary-key>
    <primary-key>PROFILE_ID</primary-key>
  </table>

  <table>
    <name>UP_USER_SS_PARMS</name>
    <columns>
      <column> <name>USER_ID</name>              <type>INTEGER</type>                       </column>
      <column> <name>PROFILE_ID</name>           <type>INTEGER</type>                       </column>
      <column> <name>SS_ID</name>      <type>INTEGER</type>   </column>
      <column> <name>SS_TYPE</name> <type>INTEGER</type> </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
    </columns>
  </table>

  <table>
    <name>UP_USER_SS_ATTS</name>
    <columns>
      <column> <name>USER_ID</name>              <type>INTEGER</type>                       </column>
      <column> <name>PROFILE_ID</name>           <type>INTEGER</type>                       </column>
      <column> <name>SS_ID</name>      <type>INTEGER</type>   </column>
      <column> <name>SS_TYPE</name> <type>INTEGER</type> </column>
      <column> <name>STRUCT_ID</name>      <type>INTEGER</type>                               </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_TYPE</name>             <type>INTEGER</type>    </column>
      <column> <name>PARAM_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
    </columns>
  </table>


  <table>
    <name>UP_THEME_SS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>SS_NAME</name>             <type>VARCHAR</type>     <param>30</param>  </column>
      <column> <name>SS_URI</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_URI</name>  <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_TEXT</name> <type>LONGVARCHAR</type>                    </column>
      <column> <name>STRUCT_SS_ID</name>		<type>INTEGER</type> </column>
      <column> <name>SAMPLE_ICON_URI</name>      <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>SAMPLE_URI</name>      <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>MIME_TYPE</name>      <type>VARCHAR</type> <param>30</param> </column>
      <column> <name>DEVICE_TYPE</name>      <type>VARCHAR</type> <param>30</param> </column>
      <column> <name>SERIALIZER_NAME</name>      <type>VARCHAR</type> <param>255</param> </column>
      <column> <name>UP_MODULE_CLASS</name>      <type>VARCHAR</type> <param>255</param> </column>
    </columns>
    <primary-key>SS_ID</primary-key>
  </table>

  <table>
    <name>UP_STRUCT_SS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>SS_NAME</name>             <type>VARCHAR</type>     <param>30</param>  </column>
      <column> <name>SS_URI</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_URI</name>  <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>SS_DESCRIPTION_TEXT</name> <type>LONGVARCHAR</type>                    </column>
    </columns>
    <primary-key>SS_ID</primary-key>
  </table>

  <table>
    <name>UP_STRUCT_PARAMS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_DEFAULT_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>PARAM_DESCRIPT</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>TYPE</name> <type>INTEGER</type> </column>
    </columns>
    <primary-key>SS_ID</primary-key>
    <primary-key>PARAM_NAME</primary-key>
    <primary-key>TYPE</primary-key>
  </table>

  <table>
    <name>UP_THEME_PARAMS</name>
    <columns>
      <column> <name>SS_ID</name> <type>INTEGER</type> </column>
      <column> <name>PARAM_NAME</name>             <type>VARCHAR</type>     <param>100</param>  </column>
      <column> <name>PARAM_DEFAULT_VAL</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>PARAM_DESCRIPT</name>              <type>VARCHAR</type>     <param>255</param> </column>
      <column> <name>TYPE</name> <type>INTEGER</type> </column>
    </columns>
    <primary-key>SS_ID</primary-key>
    <primary-key>PARAM_NAME</primary-key>
    <primary-key>TYPE</primary-key>
  </table>

  <table>
    <name>UP_SS_MAP</name>
    <columns>
      <column> <name>THEME_SS_ID</name>    <type>INTEGER</type>                   </column>
      <column> <name>STRUCT_SS_ID</name>   <type>INTEGER</type>                   </column>
      <column> <name>MIME_TYPE</name>      <type>VARCHAR</type> <param>30</param> </column>
    </columns>
  </table>

  <table>
    <name>UP_MIME_TYPES</name>
    <columns>
      <column> <name>MIME_TYPE</name>             <type>VARCHAR</type>     <param>30</param> </column>
      <column> <name>MIME_TYPE_DESCRIPTION</name> <type>LONGVARCHAR</type>                   </column>
    </columns>
    <primary-key>MIME_TYPE</primary-key>
  </table>

  <table>
    <name>UP_SKINS</name>
    <columns>
      <column> <name>SKIN_ID</name>                 <type>INTEGER</type>                     </column>
      <column> <name>SKIN_NAME</name>               <type>VARCHAR</type>   <param>20</param> </column>
      <column> <name>SKIN_DESCRIPTION</name>        <type>VARCHAR</type>   <param>100</param> </column>
	  <column> <name>THUMBNAIL_FILE_LOCATION</name> <type>VARCHAR</type>   <param>100</param> </column>
	  <column> <name>FOLDER_NAME</name>             <type>VARCHAR</type>   <param>30</param> </column>
    </columns>
	<not-null>SKIN_ID</not-null>
	<not-null>FOLDER_NAME</not-null>
  </table>

</tables>


{'fraction_non_alphanumeric': 0.18454766957478583, 'fraction_numerical': 0.009326940711048233, 'mean_word_length': 2.3591481122942883, 'pattern_counts': {'":': 0, '<': 2743, '<?xml version=': 2, '>': 2743, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '620915', 'n_tokens_mistral': 13855, 'n_tokens_neox': 13525, 'n_words': 1815}