<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<database name="sahebkhabar" type="MySQL - 5.5.5-10.0.13-MariaDB">
   <tables>
      <table name="ads" numRows="4" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="7" type="MEDIUMINT"/>
         <column autoUpdated="false" digits="0" id="1" name="image_media_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_ads_media_image" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="flash_media_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_ads_media_flash" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK178B06237393E" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="title" nullable="false" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="customer" nullable="true" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="start_date" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="7" name="end_date" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="8" name="click_count" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="9" name="url" nullable="false" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="12" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="13" name="visible" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="14" name="created" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="15" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="16" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="17" name="last_click" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="18" name="last_view" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="19" name="max_click" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="20" name="max_view" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="21" name="priority" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="22" name="view_count" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="23" name="place_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_ads_place" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="24" name="aspect_ratio" nullable="true" remarks="" size="12" type="FLOAT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK178B06237393E" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="FK_ads_media" unique="false">
            <column ascending="true" name="image_media_id"/>
         </index>
         <index name="FK_ads_media_flash" unique="false">
            <column ascending="true" name="flash_media_id"/>
         </index>
         <index name="FK_ads_place" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
      </table>
      <table name="api_audit_log" numRows="1025" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="api" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="ip" nullable="true" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="ua" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="ref" nullable="true" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="referer" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="url" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="date" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="8" name="visitor" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="9" name="site_id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="10" name="action_code" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="calendar" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="id" nullable="false" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="sh_date" nullable="false" remarks="" size="10" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="sh_year" nullable="false" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="sh_month" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="sh_month_name" nullable="false" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="sh_day" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="sh_day_name" nullable="false" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="gh_year" nullable="false" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="gh_month_name" nullable="false" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="gh_day" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="10" name="gr_date" nullable="true" remarks="" size="10" type="DATE"/>
         <column autoUpdated="false" digits="0" id="11" name="gr_year" nullable="false" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="12" name="gr_month_name" nullable="false" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="13" name="gr_day" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="14" name="event_des" nullable="true" remarks="" size="300" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="holiday" nullable="false" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="entity_audit_log" numRows="7685" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="date" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="2" name="action_code" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="user_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_8yd4jgtdnd2x6waxx0w9hospr" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="entity_class" nullable="false" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="entity_id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="entity_title" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="date_user_id" unique="false">
            <column ascending="true" name="date"/>
            <column ascending="true" name="user_id"/>
         </index>
         <index name="entity_class_entity_id" unique="false">
            <column ascending="true" name="entity_class"/>
            <column ascending="true" name="entity_id"/>
         </index>
         <index name="FK_8yd4jgtdnd2x6waxx0w9hospr" unique="false">
            <column ascending="true" name="user_id"/>
         </index>
      </table>
      <table name="entity_tag" numRows="141" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FKA7A0293E5A42C676" implied="false" onDeleteCascade="false" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="media_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FKA7A0293E652E411E" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="tag_item_id" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="tag_item_type" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="5" name="tag_option_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FKA7A0293E98682B53" implied="false" onDeleteCascade="false" table="tag_option"/>
         </column>
         <column autoUpdated="false" digits="0" id="6" name="person_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FKA7A0293EF8FFE836" implied="false" onDeleteCascade="false" table="person"/>
         </column>
         <column autoUpdated="false" digits="0" id="7" name="tag_item_value" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="9" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="10" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="created" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="12" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="13" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FKA7A0293E5A42C676" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="FKA7A0293E652E411E" unique="false">
            <column ascending="true" name="media_id"/>
         </index>
         <index name="FKA7A0293E98682B53" unique="false">
            <column ascending="true" name="tag_option_id"/>
         </index>
         <index name="FKA7A0293EF8FFE836" unique="false">
            <column ascending="true" name="person_id"/>
         </index>
         <index name="Idx_newsid" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
      </table>
      <table name="ip_country" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="ip_from" nullable="false" remarks="" size="19" type="BIGINT"/>
         <column autoUpdated="false" digits="0" id="1" name="ip_to" nullable="false" remarks="" size="19" type="BIGINT"/>
         <column autoUpdated="false" digits="0" id="2" name="registry" nullable="false" remarks="" size="7" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="assigned" nullable="false" remarks="" size="19" type="BIGINT"/>
         <column autoUpdated="false" digits="0" id="4" name="ctry" nullable="false" remarks="" size="2" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="cntry" nullable="false" remarks="" size="3" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="country" nullable="false" remarks="" size="37" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="id" nullable="false" remarks="" size="10" type="INT"/>
         <primaryKey column="ip_from" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="ip_from"/>
         </index>
      </table>
      <table name="keyword" numRows="3122" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="parent_id" foreignKey="FK_keyword_keyword" implied="false" onDeleteCascade="false" table="keyword"/>
            <child column="preferred_id" foreignKey="fk_keyword_preferred" implied="false" onDeleteCascade="false" table="keyword"/>
            <child column="keyword_id" foreignKey="FK_bdgw368dhxfhor560wbmnt19b" implied="false" onDeleteCascade="false" table="media_keyword"/>
            <child column="keyword_id" foreignKey="fk_news_keyword_keyword_1" implied="false" onDeleteCascade="true" table="news_keyword"/>
         </column>
         <column autoUpdated="false" defaultValue="1" digits="0" id="1" name="site_id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="full_title" nullable="false" remarks="full title in the form: parent &gt; title" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="search_title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="parent_id" nullable="true" remarks="parent keyword (for multi-level keyword support)" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_keyword_keyword" implied="false" onDeleteCascade="false" table="keyword"/>
         </column>
         <column autoUpdated="false" digits="0" id="6" name="preferred_id" nullable="true" remarks="preferred keyword" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_keyword_preferred" implied="false" onDeleteCascade="false" table="keyword"/>
         </column>
         <column autoUpdated="false" digits="0" id="7" name="synonym" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="created" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="9" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="10" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="11" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="12" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="13" name="visible" nullable="false" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_keyword_keyword" unique="false">
            <column ascending="true" name="parent_id"/>
         </index>
         <index name="fk_keyword_preferred" unique="false">
            <column ascending="true" name="preferred_id"/>
         </index>
         <index name="site_id_title_parent_id" unique="true">
            <column ascending="true" name="site_id"/>
            <column ascending="true" name="title"/>
            <column ascending="true" name="parent_id"/>
         </index>
         <index name="UK_2vq94ydrbhq24rhyeui2oe4x8" unique="true">
            <column ascending="true" name="site_id"/>
            <column ascending="true" name="parent_id"/>
            <column ascending="true" name="title"/>
         </index>
      </table>
      <table name="large_entity" numRows="6430" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="body_html_id" foreignKey="fk_news_large_entity" implied="false" onDeleteCascade="true" table="news"/>
            <child column="body_plain_id" foreignKey="fk_news_large_entity_2" implied="false" onDeleteCascade="true" table="news"/>
            <child column="body_html_id" foreignKey="fk_news_history_large_entity_1" implied="false" onDeleteCascade="true" table="news_history"/>
            <child column="body_plain_id" foreignKey="fk_news_history_large_entity_3" implied="false" onDeleteCascade="true" table="news_history"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="text" nullable="true" remarks="" size="16777215" type="MEDIUMTEXT"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="2" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="3" name="type" nullable="false" remarks="to which field is this entity bound" size="3" type="TINYINT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="link" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="url" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="link_group_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_link_link_group" implied="false" onDeleteCascade="false" table="link_group"/>
         </column>
         <column autoUpdated="false" digits="0" id="5" name="priority" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="created" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="8" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="9" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="10" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_link_link_group" unique="false">
            <column ascending="true" name="link_group_id"/>
         </index>
      </table>
      <table name="link_group" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="link_group_id" foreignKey="fk_link_link_group" implied="false" onDeleteCascade="false" table="link"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="priority" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="5" name="created" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="6" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="8" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="media" numRows="4909" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="flash_media_id" foreignKey="FK_ads_media_flash" implied="false" onDeleteCascade="false" table="ads"/>
            <child column="image_media_id" foreignKey="FK_ads_media_image" implied="false" onDeleteCascade="false" table="ads"/>
            <child column="media_id" foreignKey="FKA7A0293E652E411E" implied="false" onDeleteCascade="false" table="entity_tag"/>
            <child column="media_id" foreignKey="FK_fwjt2wyfe2g7qc8v6oc10kq17" implied="false" onDeleteCascade="false" table="media_keyword"/>
            <child column="image2_id" foreignKey="fk_news_media2" implied="false" onDeleteCascade="false" table="news"/>
            <child column="image_id" foreignKey="fk_news_image" implied="false" onDeleteCascade="false" table="news"/>
            <child column="image_id" foreignKey="fk_news_history_image" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="media_id" foreignKey="FK2BF2B378652E411E" implied="false" onDeleteCascade="true" table="news_media"/>
            <child column="icon_id" foreignKey="fk_product_icon" implied="false" onDeleteCascade="false" table="product"/>
            <child column="image_id" foreignKey="fk_product_image" implied="false" onDeleteCascade="false" table="product"/>
            <child column="icon_id" foreignKey="fk_prodcat_icon" implied="false" onDeleteCascade="false" table="product_category"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="type" nullable="false" remarks="0:other, 1:photo ,2:audio ,3:video ,4:flash, 5:document" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="photographer_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_media_person" implied="false" onDeleteCascade="false" table="person"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="title" nullable="true" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="search_title" nullable="true" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="des" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="7" name="repos" nullable="true" remarks="repository version, 0: old, 1 or null is current" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="8" name="entity" nullable="false" remarks="1: news, 2: ads, 3: person" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="9" name="original_filename" nullable="false" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="original_size" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="original_format" nullable="false" remarks="" size="5" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="original_width" nullable="true" remarks="in pixels" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="13" name="original_height" nullable="true" remarks="in pixels" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="14" name="original_bitrate" nullable="true" remarks="kbps" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="15" name="duration" nullable="true" remarks="ms" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="16" name="owner" nullable="true" remarks="interviewer, camera man, author, etc." size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="17" name="personals" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="18" name="places" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="19" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="20" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="21" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="22" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="23" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="24" name="deleted" nullable="true" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_media_person" unique="false">
            <column ascending="true" name="photographer_id"/>
         </index>
         <index name="type" unique="false">
            <column ascending="true" name="type"/>
         </index>
      </table>
      <table name="media_keyword" numRows="19" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="media_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_fwjt2wyfe2g7qc8v6oc10kq17" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="keyword_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_bdgw368dhxfhor560wbmnt19b" implied="false" onDeleteCascade="false" table="keyword"/>
         </column>
         <index name="FK7C48108E46EDDFE" unique="false">
            <column ascending="true" name="keyword_id"/>
         </index>
         <index name="FK7C48108E652E411E" unique="false">
            <column ascending="true" name="media_id"/>
         </index>
         <index name="media_id" unique="true">
            <column ascending="true" name="media_id"/>
            <column ascending="true" name="keyword_id"/>
         </index>
      </table>
      <table name="menu" numRows="30" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="site_id" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="2" name="active" nullable="false" remarks="" size="3" type="TINYINT"/>
         <column autoUpdated="false" digits="0" id="3" name="code" nullable="false" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="code" unique="true">
            <column ascending="true" name="code"/>
            <column ascending="true" name="site_id"/>
         </index>
      </table>
      <table name="messaging_log" numRows="37968" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="1" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="2" name="news_ids" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="publish_strategy" nullable="false" remarks="" size="3" type="TINYINT"/>
         <column autoUpdated="false" digits="0" id="4" name="success" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="5" name="subscription_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_messaging_log_subscription" implied="false" onDeleteCascade="false" table="subscription"/>
         </column>
         <column autoUpdated="false" digits="0" id="6" name="newsletter_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_messaging_log_newsletter" implied="false" onDeleteCascade="false" table="newsletter"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_messaging_log_newsletter" unique="false">
            <column ascending="true" name="newsletter_id"/>
         </index>
         <index name="FK_messaging_log_subscription" unique="false">
            <column ascending="true" name="subscription_id"/>
         </index>
      </table>
      <table name="news" numRows="5597" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="news_id" foreignKey="FKA7A0293E5A42C676" implied="false" onDeleteCascade="false" table="entity_tag"/>
            <child column="news_id" foreignKey="FK_io1bbopmg4bder9jfwk52ubk9" implied="false" onDeleteCascade="false" table="news_comment"/>
            <child column="news_id" foreignKey="fk_news_history_news_id" implied="false" onDeleteCascade="true" table="news_history"/>
            <child column="news_id" foreignKey="fk_news_keyword_news_1" implied="false" onDeleteCascade="true" table="news_keyword"/>
            <child column="news_id" foreignKey="FK_news_log_news" implied="false" onDeleteCascade="true" table="news_log"/>
            <child column="news_id" foreignKey="FK2BF2B3785A42C676" implied="false" onDeleteCascade="true" table="news_media"/>
            <child column="news_id" foreignKey="FK_news_news_news" implied="false" onDeleteCascade="true" table="news_news"/>
            <child column="related_news_id" foreignKey="FK_news_news_news_2" implied="false" onDeleteCascade="true" table="news_news"/>
            <child column="news_id" foreignKey="FK2C201C9B5A42C676" implied="false" onDeleteCascade="true" table="news_place"/>
            <child column="news_id" foreignKey="FK_news_id" implied="false" onDeleteCascade="true" table="news_place_archive"/>
            <child column="news_id" foreignKey="FK_news_subtopic_news" implied="false" onDeleteCascade="true" table="news_subtopic"/>
            <child column="news_id" foreignKey="FK_j8mhh7jtx34ce164ja68wuv5a" implied="false" onDeleteCascade="true" table="news_transition_log"/>
            <child column="subject_id" foreignKey="FK_place_news" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="code" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="doc_num" nullable="true" remarks="" size="20" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="fa" digits="0" id="3" name="language" nullable="true" remarks="" size="2" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="flags" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="5" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_site" implied="false" onDeleteCascade="false" table="site"/>
         </column>
         <column autoUpdated="false" digits="0" id="6" name="type_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_type_id" implied="false" onDeleteCascade="false" table="news_type"/>
         </column>
         <column autoUpdated="false" digits="0" id="7" name="topic_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="8" name="sub_topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_sub_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="9" name="journalist_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_person" implied="false" onDeleteCascade="false" table="person"/>
         </column>
         <column autoUpdated="false" digits="0" id="10" name="headline" nullable="true" remarks="title" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="short_headline" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="search_title" nullable="true" remarks="normalized headline for searching" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="13" name="kicker" nullable="true" remarks="routitr" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="14" name="subhead" nullable="true" remarks="zirtitr" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="lead" nullable="true" remarks="chekideh" size="4000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="16" name="redirect_url" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="17" name="publish_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="18" name="start_date" nullable="true" remarks="Should Set this after publish" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="19" name="end_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="20" name="status" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="21" name="recipient_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_recipient" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="22" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="23" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="24" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="25" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="26" name="locker_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_locker" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="27" name="locked" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="28" name="source_id" nullable="true" remarks="" size="8" type="MEDIUMINT UNSIGNED">
            <parent column="id" foreignKey="fk_news_source" implied="false" onDeleteCascade="false" table="source"/>
         </column>
         <column autoUpdated="false" digits="0" id="29" name="note" nullable="true" remarks="json crawlpartdata" size="400" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="30" name="event_date" nullable="true" remarks="date of news event" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="31" name="has_comment" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="32" name="comment_approval" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="33" name="comment_headline" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="34" name="invisible_top" nullable="false" remarks="Invisible in top places, ex: invisble in top-visited place" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="35" name="body_wcount" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="36" name="body_html_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_large_entity" implied="false" onDeleteCascade="true" table="large_entity"/>
         </column>
         <column autoUpdated="false" digits="0" id="37" name="body_plain_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_large_entity_2" implied="false" onDeleteCascade="true" table="large_entity"/>
         </column>
         <column autoUpdated="false" digits="0" id="38" name="image_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_image" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="39" name="image2_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_media2" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="40" name="region_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_region" implied="false" onDeleteCascade="false" table="region"/>
         </column>
         <column autoUpdated="false" digits="0" id="41" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="42" name="score_ed" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="43" name="score_eic" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="code" unique="true">
            <column ascending="true" name="code"/>
         </index>
         <index name="crd_crr_st_mdd" unique="false">
            <column ascending="true" name="created"/>
            <column ascending="true" name="creator"/>
            <column ascending="true" name="site_id"/>
            <column ascending="true" name="modified"/>
         </index>
         <index name="fk_body_html_id" unique="false">
            <column ascending="true" name="body_html_id"/>
         </index>
         <index name="fk_body_plain_id" unique="false">
            <column ascending="true" name="body_plain_id"/>
         </index>
         <index name="fk_image_id" unique="false">
            <column ascending="true" name="image_id"/>
         </index>
         <index name="fk_locker" unique="false">
            <column ascending="true" name="locker_id"/>
         </index>
         <index name="FK_news_media2" unique="false">
            <column ascending="true" name="image2_id"/>
         </index>
         <index name="fk_news_person" unique="false">
            <column ascending="true" name="journalist_id"/>
         </index>
         <index name="FK_news_region" unique="false">
            <column ascending="true" name="region_id"/>
         </index>
         <index name="fk_news_source" unique="false">
            <column ascending="true" name="source_id"/>
         </index>
         <index name="fk_recipient" unique="false">
            <column ascending="true" name="recipient_id"/>
         </index>
         <index name="fk_site" unique="false">
            <column ascending="true" name="site_id"/>
         </index>
         <index name="fk_source" unique="false">
            <column ascending="true" name="source_id"/>
         </index>
         <index name="fk_sub_topic_id" unique="false">
            <column ascending="true" name="sub_topic_id"/>
         </index>
         <index name="fk_topic_id" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="fk_type" unique="false">
            <column ascending="true" name="type_id"/>
         </index>
         <index name="idx_st_ty_tp_sr_im_st_pd_sd_ed" unique="false">
            <column ascending="true" name="site_id"/>
            <column ascending="true" name="type_id"/>
            <column ascending="true" name="topic_id"/>
            <column ascending="true" name="source_id"/>
            <column ascending="true" name="image_id"/>
            <column ascending="true" name="status"/>
            <column ascending="true" name="publish_date"/>
            <column ascending="true" name="start_date"/>
            <column ascending="true" name="end_date"/>
         </index>
         <index name="publish_date" unique="false">
            <column ascending="true" name="publish_date"/>
         </index>
         <index name="register_date" unique="false">
            <column ascending="true" name="created"/>
         </index>
      </table>
      <table name="news_comment" numRows="30" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="parent_id" foreignKey="FK_news_comment_news_comment" implied="false" onDeleteCascade="false" table="news_comment"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="parent_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_comment_news_comment" implied="false" onDeleteCascade="false" table="news_comment"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_io1bbopmg4bder9jfwk52ubk9" implied="false" onDeleteCascade="false" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="site_id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="creator" nullable="true" remarks="publisher" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="5" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="6" name="session_id" nullable="true" remarks="" size="60" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="user_ip" nullable="false" remarks="" size="60" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="user_email" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="user_name" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="show_email" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="11" name="body" nullable="true" remarks="" size="65535" type="TEXT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="12" name="is_read" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="13" name="published" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="14" name="reply_body" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="modifier" nullable="true" remarks="reply_user_id" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="16" name="modified" nullable="true" remarks="reply_date" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="17" name="edited_body" nullable="true" remarks="" size="65535" type="TEXT"/>
         <column autoUpdated="false" digits="0" id="18" name="edited_username" nullable="true" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="19" name="positive" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="20" name="negative" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="21" name="like_count" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="22" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="23" name="country_code" nullable="true" remarks="" size="2" type="CHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_news_comment_news" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="FK_news_comment_news_comment" unique="false">
            <column ascending="true" name="parent_id"/>
         </index>
      </table>
      <table name="news_history" numRows="578" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_news_id" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="version" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="code" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="doc_num" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="type_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_type_id_2" implied="false" onDeleteCascade="false" table="news_type"/>
         </column>
         <column autoUpdated="false" digits="0" id="6" name="headline" nullable="false" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="short_headline" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="kicker" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="subhead" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="lead" nullable="true" remarks="" size="4000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="body_html" nullable="true" remarks="" size="16777215" type="MEDIUMTEXT"/>
         <column autoUpdated="false" digits="0" id="12" name="body_plain" nullable="true" remarks="" size="16777215" type="MEDIUMTEXT"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="13" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="14" name="publish_date" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="15" name="start_date" nullable="true" remarks="Should Set this after publish" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="16" name="end_date" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="17" name="view_count" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="18" name="comment_count" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="19" name="redirect_url" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="20" name="status" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="21" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="22" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="23" name="source_id" nullable="true" remarks="" size="8" type="MEDIUMINT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_source" implied="false" onDeleteCascade="false" table="source"/>
         </column>
         <column autoUpdated="false" digits="0" id="24" name="note" nullable="true" remarks="json crawlpartdata" size="400" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="25" name="event_date" nullable="true" remarks="date of news event" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="26" name="has_comment" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="27" name="comment_approval" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="28" name="comment_headline" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="29" name="invisible_top" nullable="false" remarks="Invisible in top places, ex: invisble in top-visited place" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="30" name="body_wcount" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="31" name="headline_length" nullable="true" remarks="to prevent realtime counting for each view cutting." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="32" name="deleted" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="33" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="34" name="creator" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="35" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT"/>
         <column autoUpdated="false" digits="0" id="36" name="entity_tag_ids" nullable="true" remarks="" size="80" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="37" name="keyword_ids" nullable="true" remarks="" size="80" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="38" name="media_ids" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="39" name="news_comment_ids" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="40" name="related_news_ids" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="41" name="related_sub_topic_ids" nullable="true" remarks="" size="80" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="42" name="place_ids" nullable="true" remarks="" size="80" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="43" name="score_ed" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="44" name="score_eic" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="45" name="body_html_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_large_entity_1" implied="false" onDeleteCascade="true" table="large_entity"/>
         </column>
         <column autoUpdated="false" digits="0" id="46" name="body_plain_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_large_entity_3" implied="false" onDeleteCascade="true" table="large_entity"/>
         </column>
         <column autoUpdated="false" digits="0" id="47" name="image_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_image" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="48" name="image2_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="49" name="locker_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_7n0m9sdowho7bahiaxnxl7ijx" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="50" name="locked" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="51" name="region_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_history_region" implied="false" onDeleteCascade="false" table="region"/>
         </column>
         <column autoUpdated="false" digits="0" id="52" name="recipient_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_recipient" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="53" name="sub_topic_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_topic_2" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="54" name="journalist_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_person" implied="false" onDeleteCascade="false" table="person"/>
         </column>
         <column autoUpdated="false" digits="0" id="55" name="topic_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_history_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_7n0m9sdowho7bahiaxnxl7ijx" unique="false">
            <column ascending="true" name="locker_id"/>
         </index>
         <index name="fk_news_history_large_entity_1" unique="false">
            <column ascending="true" name="body_html_id"/>
         </index>
         <index name="fk_news_history_large_entity_3" unique="false">
            <column ascending="true" name="body_plain_id"/>
         </index>
         <index name="fk_news_history_person" unique="false">
            <column ascending="true" name="journalist_id"/>
         </index>
         <index name="FK_news_history_region" unique="false">
            <column ascending="true" name="region_id"/>
         </index>
         <index name="fk_news_history_topic" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="fk_news_history_topic_2" unique="false">
            <column ascending="true" name="sub_topic_id"/>
         </index>
         <index name="fk_news_news_id_2" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="fk_news_type_id_2" unique="false">
            <column ascending="true" name="type_id"/>
         </index>
         <index name="FKF9409328379AB268" unique="false">
            <column ascending="true" name="recipient_id"/>
         </index>
         <index name="FKF940932866966A76" unique="false">
            <column ascending="true" name="source_id"/>
         </index>
         <index name="FKF940932867A28047" unique="false">
            <column ascending="true" name="image_id"/>
         </index>
         <index name="UK_kj8fso94hijtvcy89iketh7g" unique="true">
            <column ascending="true" name="version"/>
            <column ascending="true" name="news_id"/>
         </index>
      </table>
      <table name="news_keyword" numRows="4257" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_keyword_news_1" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="keyword_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_news_keyword_keyword_1" implied="false" onDeleteCascade="true" table="keyword"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="4" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_news_keyword_keyword_1" unique="false">
            <column ascending="true" name="keyword_id"/>
         </index>
         <index name="fk_news_keyword_news_1" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
      </table>
      <table name="news_log" numRows="7520" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="1" name="view_count" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="2" name="positive" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="3" name="negative" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="4" name="like_count" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="5" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_log_news" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" defaultValue="0" digits="0" id="6" name="comment_count" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="7" name="pub_comment_count" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="data" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="last_view" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="10" name="last_comment" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="11" name="last_publish_date" nullable="true" remarks="When news is published, unpublished, and then published again this field holds the last publish date." size="19" type="DATETIME"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="12" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="comment_count" unique="false">
            <column ascending="true" name="comment_count"/>
         </index>
         <index name="FK_news_log_news" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="news_id" unique="true">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="UK_j3m21xv080vi5afyx06b2gjb7" unique="true">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="view_count" unique="false">
            <column ascending="true" name="view_count"/>
         </index>
      </table>
      <table name="news_media" numRows="422" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK2BF2B3785A42C676" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="media_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK2BF2B378652E411E" implied="false" onDeleteCascade="true" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="type" nullable="false" remarks="1:Gallery(gozaresh tasviri), 2:Attachment" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="priority" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="5" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="6" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="7" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="8" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="9" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="10" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT"/>
         <column autoUpdated="false" digits="0" id="11" name="internal" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="12" name="title" nullable="true" remarks="" size="255" type="VARCHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK2BF2B3785A42C676" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="FK2BF2B378652E411E" unique="false">
            <column ascending="true" name="media_id"/>
         </index>
         <index name="fk_news_media_media_id" unique="false">
            <column ascending="true" name="media_id"/>
         </index>
         <index name="fk_news_media_news_id" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
      </table>
      <table name="news_news" numRows="1117" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_news_news" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="related_news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_news_news_2" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="priority" nullable="false" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="relation_type" nullable="true" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="5" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="6" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="7" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="8" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="9" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_news_news_news_2" unique="false">
            <column ascending="true" name="related_news_id"/>
         </index>
         <index name="news_id_related_news_id" unique="true">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="related_news_id"/>
            <column ascending="true" name="relation_type"/>
         </index>
         <index name="news_id_related_news_id_relation_type" unique="false">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="related_news_id"/>
            <column ascending="true" name="relation_type"/>
         </index>
         <index name="UK_6d2l311kpvlbfiaggr7ca7gnt" unique="true">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="related_news_id"/>
            <column ascending="true" name="relation_type"/>
         </index>
      </table>
      <table name="news_place" numRows="229" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK2C201C9B5A42C676" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="place_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK2C201C9B9D98A3E" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_place_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="sub_topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_place_subtopic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="5" name="priority" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="6" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="7" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="8" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="9" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="10" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK2C201C9B5A42C676" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="FK2C201C9B9D98A3E" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
         <index name="FK_news_place_subtopic" unique="false">
            <column ascending="true" name="sub_topic_id"/>
         </index>
         <index name="FK_news_place_topic" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="Idx_news_id" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="Idx_place_id" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
         <index name="priority" unique="false">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="place_id"/>
            <column ascending="true" name="priority"/>
            <column ascending="true" name="created"/>
         </index>
         <index name="uk_news_place_subtopic" unique="true">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="place_id"/>
            <column ascending="true" name="sub_topic_id"/>
         </index>
         <index name="uk_place_news_topic" unique="true">
            <column ascending="true" name="place_id"/>
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="sub_topic_id"/>
         </index>
      </table>
      <table name="news_place_archive" numRows="959" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_id" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="place_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FKADABD91E9D98A3E" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_archive_news_place_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="sub_topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_archive_news_place_subtopic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="5" name="priority" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="6" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="7" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="8" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="9" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="10" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_archive_news_place_subtopic" unique="false">
            <column ascending="true" name="sub_topic_id"/>
         </index>
         <index name="FK_archive_news_place_topic" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="FKADABD91E9D98A3E" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
         <index name="Idx_news_id" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="Idx_place_id" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
         <index name="priority" unique="false">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="place_id"/>
            <column ascending="true" name="priority"/>
            <column ascending="true" name="created"/>
         </index>
      </table>
      <table name="news_subtopic" numRows="175" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_subtopic_news" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="topic_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_subtopic_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_news_subtopic_news" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
         <index name="FK_news_subtopic_topic" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="news_id_topic_id" unique="true">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="UK_ih9mu6pkcvsickrshaqtink67" unique="true">
            <column ascending="true" name="news_id"/>
            <column ascending="true" name="topic_id"/>
         </index>
      </table>
      <table name="news_transition_log" numRows="5104" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="news_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_j8mhh7jtx34ce164ja68wuv5a" implied="false" onDeleteCascade="true" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="date" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="3" name="from_user_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_transition_log_user" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="to_user_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_news_transition_log_user_2" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="5" name="from_state" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="to_state" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_news_transition_log_user" unique="false">
            <column ascending="true" name="from_user_id"/>
         </index>
         <index name="FK_news_transition_log_user_2" unique="false">
            <column ascending="true" name="to_user_id"/>
         </index>
         <index name="news_id" unique="false">
            <column ascending="true" name="news_id"/>
         </index>
      </table>
      <table name="news_type" numRows="9" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="type_id" foreignKey="fk_news_type_id" implied="false" onDeleteCascade="false" table="news"/>
            <child column="type_id" foreignKey="fk_news_type_id_2" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="news_type_id" foreignKey="FK_place_news_type" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="code" nullable="true" remarks="" size="20" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="5" name="visible" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="6" name="fixed" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="7" name="priority" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="9" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="10" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="11" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="uq_news_type_code" unique="true">
            <column ascending="true" name="code"/>
         </index>
      </table>
      <table name="newsletter" numRows="25" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="newsletter_id" foreignKey="FK_messaging_log_newsletter" implied="false" onDeleteCascade="false" table="messaging_log"/>
            <child column="newsletter_id" foreignKey="FK_subscription_newsletter" implied="false" onDeleteCascade="false" table="subscription"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="2" name="news_count" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="3" name="place_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_newsletter_place" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="start_date" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="5" name="last_publish" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" defaultValue="1440" digits="0" id="6" name="time_interval" nullable="false" remarks="interval between two alerts (in minute)" size="10" type="INT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="7" name="publish_strategy" nullable="false" remarks="1: automatic, 2: manual" size="3" type="TINYINT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="8" name="medium" nullable="false" remarks="1: email, 2: sms" size="3" type="TINYINT"/>
         <column autoUpdated="false" digits="0" id="9" name="api_key" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="10" name="customizable" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="11" name="creator" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="12" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="13" name="modifier" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="14" name="modified" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="15" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="16" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="17" name="visible" nullable="false" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_newsletter_place" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
         <index name="nl_med_pubs_act_idx" unique="false">
            <column ascending="true" name="medium"/>
            <column ascending="true" name="publish_strategy"/>
            <column ascending="true" name="active"/>
         </index>
      </table>
      <table name="person" numRows="1" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="person_id" foreignKey="FKA7A0293EF8FFE836" implied="false" onDeleteCascade="false" table="entity_tag"/>
            <child column="photographer_id" foreignKey="FK_media_person" implied="false" onDeleteCascade="false" table="media"/>
            <child column="journalist_id" foreignKey="fk_news_person" implied="false" onDeleteCascade="false" table="news"/>
            <child column="journalist_id" foreignKey="fk_news_history_person" implied="false" onDeleteCascade="false" table="news_history"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="code" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="gender" nullable="true" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="first_name" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="last_name" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="prefix_name" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="print_name" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="search_title" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="journalist" nullable="true" remarks="is this person a journalist" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="9" name="photographer" nullable="true" remarks="is this person a photographer" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="10" name="initial" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="job_title" nullable="true" remarks="" size="75" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="b_date" nullable="true" remarks="Maybe contains just year number so its ENGINE is not datetime ." size="10" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="13" name="biography" nullable="true" remarks="" size="4000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="14" name="email" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="website" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="16" name="cell_phone" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="17" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="18" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="19" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="20" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="21" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="22" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="code" unique="true">
            <column ascending="true" name="code"/>
         </index>
      </table>
      <table name="place" numRows="196" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="place_id" foreignKey="FK_ads_place" implied="false" onDeleteCascade="false" table="ads"/>
            <child column="place_id" foreignKey="FK2C201C9B9D98A3E" implied="false" onDeleteCascade="false" table="news_place"/>
            <child column="place_id" foreignKey="FKADABD91E9D98A3E" implied="false" onDeleteCascade="false" table="news_place_archive"/>
            <child column="place_id" foreignKey="FK_newsletter_place" implied="false" onDeleteCascade="false" table="newsletter"/>
            <child column="archive_place_id" foreignKey="FK_place_place" implied="false" onDeleteCascade="false" table="place"/>
            <child column="place_id" foreignKey="fk_place" implied="false" onDeleteCascade="false" table="poll"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="code" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="3" name="auto_fill" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="4" name="is_main" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="5" name="archive_place_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_place_place" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="6" name="topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_place_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="7" name="news_type_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_place_news_type" implied="false" onDeleteCascade="false" table="news_type"/>
         </column>
         <column autoUpdated="false" digits="0" id="8" name="subject_id" nullable="true" remarks="subject/package/portal/parvandeh" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_place_news" implied="false" onDeleteCascade="false" table="news"/>
         </column>
         <column autoUpdated="false" digits="0" id="9" name="title" nullable="false" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="box_title" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="priority" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="12" name="news_count" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="13" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="14" name="visible" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="7" digits="0" id="15" name="news_age" nullable="true" remarks="Maximum new age in day" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="16" name="start_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="17" name="end_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="18" name="filter_topic" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="19" name="filter_source" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="20" name="filter_news_type" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="21" name="html_container_id" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="22" name="theme" nullable="true" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="23" name="tab_group" nullable="true" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="3" digits="0" id="24" name="news_age_unit" nullable="false" remarks="{1: MINUTE, 2: HOUR, 3: DAY}" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="25" name="module_path" nullable="true" remarks="" size="2000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="26" name="link" nullable="true" remarks="box custom link" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="27" name="has_related_news" nullable="true" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="28" name="has_related_image" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="29" name="use_related_image2" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="30" name="related_news_count" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="31" name="relation_type" nullable="true" remarks="comma-separated relation type" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="32" name="box_bg_color" nullable="true" remarks="" size="7" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="33" name="header_bg_color" nullable="true" remarks="" size="7" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="34" name="box_shadow" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="35" name="allow_ips" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="36" name="deny_ips" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="37" name="duplicate_score" nullable="true" remarks="minimum similarity score to find original news of a matched news of this place (using query). 0 means no duplicate removal should be done." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="38" name="query" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="39" name="sort_field" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="40" name="keywords" nullable="true" remarks="cvs list of keyword ids" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="41" name="any_keyword" nullable="true" remarks="true: or between keyword ids, false: and between keyword ids" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="42" name="title_limit" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="43" name="lead_limit" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="44" name="type" nullable="false" remarks="1:User Defined,2:Last News,3: Most Visited,4:Mos Commented, 5: Most mailed,6: Ads" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="45" name="topic_filter" nullable="true" remarks="if true,contents filtered by topic_id which request from query string of the page." size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="46" name="topic_filter_depth" nullable="true" remarks="if topic_filter is true, it should be filtered by topics of this depth" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="47" name="show_in_topic" nullable="true" remarks="comma-separated topic id list" size="255" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="48" name="subject_filter" nullable="true" remarks="if true, joins news box with current subject (if any)" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="49" name="has_image" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="50" name="use_image2" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="51" name="image_size" nullable="true" remarks="1 to 5" size="10" type="INT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="52" name="has_lead" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="53" name="cross_site" nullable="true" remarks="0 or null: site-specific, 1: cross-site." size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="54" name="creator" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="55" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="56" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="57" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="58" name="carousel_items" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="59" name="has_carousel" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="60" name="carousel_autostart" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="61" name="carousel_delay" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="62" name="carousel_item" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="63" name="carousel_paging" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="64" name="carousel_control" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="65" name="has_titr1" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="66" name="has_kicker" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="67" name="has_subhead" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="68" name="has_publish_date" nullable="true" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="69" name="publish_date_format" nullable="true" remarks="" size="20" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="70" name="has_short_headline" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="71" name="has_source" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="72" name="has_journalist" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="73" name="has_player" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="74" name="has_comment" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="75" name="comment_count" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="76" name="has_archive" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="77" name="mosaic_archive" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="78" name="has_feed" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="79" name="has_telegram" nullable="true" remarks="" size="0" type="BIT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_place_news" unique="false">
            <column ascending="true" name="subject_id"/>
         </index>
         <index name="FK_place_news_type" unique="false">
            <column ascending="true" name="news_type_id"/>
         </index>
         <index name="FK_place_place" unique="false">
            <column ascending="true" name="archive_place_id"/>
         </index>
         <index name="FK_place_topic" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
      </table>
      <table name="poll" numRows="2" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="poll_id" foreignKey="FK_poll_option_poll" implied="false" onDeleteCascade="false" table="poll_option"/>
            <child column="poll_id" foreignKey="fk_poll" implied="false" onDeleteCascade="false" table="vote"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="question" nullable="false" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="language" nullable="false" remarks="" size="2" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="4" name="priority" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="5" name="type" nullable="true" remarks="for future use, e.g. multi-select polls" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="visible" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="active" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="start_date" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="9" name="end_date" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="10" name="place_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_place" implied="false" onDeleteCascade="false" table="place"/>
         </column>
         <column autoUpdated="false" digits="0" id="11" name="topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="12" name="site_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="ft_site" implied="false" onDeleteCascade="false" table="site"/>
         </column>
         <column autoUpdated="false" digits="0" id="13" name="creator" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="14" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="15" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="16" name="modified" nullable="true" remarks="" size="19" type="DATETIME"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_place" unique="false">
            <column ascending="true" name="place_id"/>
         </index>
         <index name="fk_topic" unique="false">
            <column ascending="true" name="topic_id"/>
         </index>
         <index name="ft_site" unique="false">
            <column ascending="true" name="site_id"/>
         </index>
      </table>
      <table name="poll_option" numRows="8" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="choice_id" foreignKey="fk_poll_option" implied="false" onDeleteCascade="false" table="vote"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="2" name="title" nullable="false" remarks="" size="300" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="item_order" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="poll_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_poll_option_poll" implied="false" onDeleteCascade="false" table="poll"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_poll_option_poll" unique="false">
            <column ascending="true" name="poll_id"/>
         </index>
      </table>
      <table name="product" numRows="5" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="product_id" foreignKey="fk_prodpricelog_product" implied="false" onDeleteCascade="false" table="product_price_log"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="active" nullable="false" remarks="" size="1" type="BIT"/>
         <column autoUpdated="false" digits="0" id="2" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="3" name="creator" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="modified" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="5" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="priority" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="search_title" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="description" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="price" nullable="false" remarks="" size="12" type="FLOAT"/>
         <column autoUpdated="false" digits="0" id="11" name="price_max" nullable="false" remarks="" size="12" type="FLOAT"/>
         <column autoUpdated="false" digits="0" id="12" name="price_min" nullable="false" remarks="" size="12" type="FLOAT"/>
         <column autoUpdated="false" digits="0" id="13" name="currency" nullable="false" remarks="" size="3" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="14" name="title" nullable="false" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="visible" nullable="false" remarks="" size="1" type="BIT"/>
         <column autoUpdated="false" digits="0" id="16" name="category_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_product_category" implied="false" onDeleteCascade="false" table="product_category"/>
         </column>
         <column autoUpdated="false" digits="0" id="17" name="icon_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_product_icon" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="18" name="image_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_product_image" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_product_category" unique="false">
            <column ascending="true" name="category_id"/>
         </index>
         <index name="fk_product_icon" unique="false">
            <column ascending="true" name="icon_id"/>
         </index>
         <index name="fk_product_image" unique="false">
            <column ascending="true" name="image_id"/>
         </index>
      </table>
      <table name="product_category" numRows="5" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="category_id" foreignKey="fk_product_category" implied="false" onDeleteCascade="false" table="product"/>
            <child column="parent_id" foreignKey="fk_prodcat_parent" implied="false" onDeleteCascade="false" table="product_category"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="active" nullable="false" remarks="" size="1" type="BIT"/>
         <column autoUpdated="false" digits="0" id="2" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="3" name="creator" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="modified" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="5" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="search_title" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="code" nullable="true" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="depth" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="10" name="description" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="full_title" nullable="false" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="13" name="visible" nullable="false" remarks="" size="1" type="BIT"/>
         <column autoUpdated="false" digits="0" id="14" name="icon_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_prodcat_icon" implied="false" onDeleteCascade="false" table="media"/>
         </column>
         <column autoUpdated="false" digits="0" id="15" name="parent_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_prodcat_parent" implied="false" onDeleteCascade="false" table="product_category"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="code" unique="true">
            <column ascending="true" name="code"/>
         </index>
         <index name="fk_prodcat_icon" unique="false">
            <column ascending="true" name="icon_id"/>
         </index>
         <index name="fk_prodcat_parent" unique="false">
            <column ascending="true" name="parent_id"/>
         </index>
      </table>
      <table name="product_price_log" numRows="8" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="2" name="creator" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="price" nullable="false" remarks="" size="12" type="FLOAT"/>
         <column autoUpdated="false" digits="0" id="4" name="price_max" nullable="false" remarks="" size="12" type="FLOAT"/>
         <column autoUpdated="false" digits="0" id="5" name="price_min" nullable="false" remarks="" size="12" type="FLOAT"/>
         <column autoUpdated="false" digits="0" id="6" name="product_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_prodpricelog_product" implied="false" onDeleteCascade="false" table="product"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_prodpricelog_product" unique="false">
            <column ascending="true" name="product_id"/>
         </index>
      </table>
      <table name="region" numRows="2" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="region_id" foreignKey="fk_news_region" implied="false" onDeleteCascade="false" table="news"/>
            <child column="region_id" foreignKey="FK_news_history_region" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="parent_id" foreignKey="FK_region_region" implied="false" onDeleteCascade="false" table="region"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="title" nullable="false" remarks="" size="60" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="search_title" nullable="false" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="full_title" nullable="false" remarks="full title in the form: parent &gt; title" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="code" nullable="true" remarks="" size="10" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="depth" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="parent_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_region_region" implied="false" onDeleteCascade="false" table="region"/>
         </column>
         <column autoUpdated="false" digits="0" id="7" name="longitude" nullable="true" remarks="" size="22" type="DOUBLE"/>
         <column autoUpdated="false" digits="0" id="8" name="latitude" nullable="true" remarks="" size="22" type="DOUBLE"/>
         <column autoUpdated="false" digits="0" id="9" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="10" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="11" name="creator" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="12" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="13" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="14" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="code" unique="true">
            <column ascending="true" name="code"/>
         </index>
         <index name="FK_region_region" unique="false">
            <column ascending="true" name="parent_id"/>
         </index>
         <index name="title_parent_id_site_id" unique="true">
            <column ascending="true" name="title"/>
            <column ascending="true" name="parent_id"/>
            <column ascending="true" name="site_id"/>
         </index>
      </table>
      <table name="role" numRows="6" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="role_id" foreignKey="fk_user_role_role_1" implied="false" onDeleteCascade="false" table="user_role"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="site_ids" nullable="true" remarks="CSV list of site ids" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="permissions_ids" nullable="true" remarks="CSV which starts and ends width comma" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="menu_ids" nullable="true" remarks="CSV which starts and ends width comma" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="place_ids" nullable="true" remarks="CSV which starts and ends width comma" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="8" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="9" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="10" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="11" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="site" numRows="6" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="site_id" foreignKey="fk_news_site" implied="false" onDeleteCascade="false" table="news"/>
            <child column="site_id" foreignKey="ft_site" implied="false" onDeleteCascade="false" table="poll"/>
            <child column="master_site_id" foreignKey="fk_site_master" implied="false" onDeleteCascade="false" table="site"/>
            <child column="site_id" foreignKey="fk_site_domain_site_id" implied="false" onDeleteCascade="false" table="site_domain"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="lang_code" nullable="false" remarks="" size="5" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="slogon" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="url" nullable="true" remarks="e.g. http://sahebkhabar.ir with protocol and no ending slash" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="media_url" nullable="false" remarks="base url address for media" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="flags" nullable="true" remarks="site boolean flags" size="19" type="BIGINT"/>
         <column autoUpdated="false" digits="0" id="7" name="master_site_id" nullable="true" remarks="maste site of this site" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_site_master" implied="false" onDeleteCascade="false" table="site"/>
         </column>
         <column autoUpdated="false" digits="0" id="8" name="page_title" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="home_page_title" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="lang_direction" nullable="false" remarks="" size="3" type="CHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="copyright_clause" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="meta_copyright" nullable="true" remarks="" size="250" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="13" name="info_email" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="14" name="sender_email" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="limit_news_days" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="16" name="limit_start_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="17" name="email_username" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="18" name="email_password" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="19" name="imap_server" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="20" name="meta_keyword" nullable="true" remarks="" size="300" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="21" name="meta_des" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="22" name="meta_frontpage" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="23" name="google_meta_verification" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="24" name="alexa_meta_verification" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="25" name="google_analytic_js" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="26" name="theme_folder" nullable="true" remarks="" size="20" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="27" name="data_folder" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="28" name="db_connection_string" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="29" name="path_seperator" nullable="true" remarks="" size="1" type="CHAR"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="30" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="31" name="has_subscription" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="32" name="topic_top1_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="33" name="topic_top2_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="34" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="35" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="36" name="max_headline_chars" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="37" name="max_lead_chars" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="25000" digits="0" id="38" name="max_body_chars" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="39" name="max_kicker_chars" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="40" name="max_short_headline_chars" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="41" name="mandatory_short_headline" nullable="true" remarks="0 means optional. Greater than zero means at least that number of characters are required." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="42" name="mandatory_headline" nullable="true" remarks="0 means optional. Greater than zero means at least that number of characters are required." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="43" name="mandatory_lead" nullable="true" remarks="0 means optional. Greater than zero means at least that number of characters are required." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="44" name="mandatory_body" nullable="true" remarks="0 means optional. Greater than zero means at least that number of characters are required." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="45" name="mandatory_keyword" nullable="true" remarks="0 means optional. Greater than zero means at least that number of keywords are required." size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="46" name="mandatory_source" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="47" name="mandatory_journalist" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="48" name="mandatory_region" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="49" name="use_news_id_in_url" nullable="true" remarks="Use newsId in makeUrl" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="50" name="use_search_for_keyword_index" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="51" name="render_news_source" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="52" name="backlink_phrase_list" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="53" name="backlink_phrase_url" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="54" name="about_us_news_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="55" name="contact_us_news_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="56" name="links_news_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="57" name="ads_news_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="58" name="password_expire_days" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="59" name="permissions" nullable="true" remarks="comma separated list of permissions enabled on this website" size="200" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="60" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="61" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="62" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_site_master" unique="false">
            <column ascending="true" name="master_site_id"/>
         </index>
      </table>
      <table name="site_domain" numRows="20" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="site_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_site_domain_site_id" implied="false" onDeleteCascade="false" table="site"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="domain_name" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="*" digits="0" id="3" name="protocol" nullable="false" remarks="Could be * for all protocols" size="10" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="port_number" nullable="false" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_site_domain_site_id" unique="false">
            <column ascending="true" name="site_id"/>
         </index>
         <index name="Idx_unique" unique="true">
            <column ascending="true" name="domain_name"/>
            <column ascending="true" name="protocol"/>
            <column ascending="true" name="port_number"/>
         </index>
      </table>
      <table name="source" numRows="198" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="8" type="MEDIUMINT UNSIGNED">
            <child column="source_id" foreignKey="fk_news_source" implied="false" onDeleteCascade="false" table="news"/>
            <child column="source_id" foreignKey="fk_news_history_source" implied="false" onDeleteCascade="false" table="news_history"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="search_title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="code" nullable="false" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="authority" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="flags" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="8" name="visible" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="9" name="priority" nullable="true" remarks="used for ordering" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="10" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="11" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="12" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="13" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="code" unique="true">
            <column ascending="true" name="code"/>
            <column ascending="true" name="site_id"/>
         </index>
         <index name="title" unique="true">
            <column ascending="true" name="title"/>
            <column ascending="true" name="site_id"/>
         </index>
         <index name="UK_3vn98w64b71capgwhf8bpoabk" unique="true">
            <column ascending="true" name="code"/>
            <column ascending="true" name="site_id"/>
         </index>
      </table>
      <table name="subscription" numRows="206" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="subscription_id" foreignKey="FK_messaging_log_subscription" implied="false" onDeleteCascade="false" table="messaging_log"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="name" nullable="false" remarks="" size="40" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="2" name="cell" nullable="true" remarks="" size="40" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="email" nullable="false" remarks="" size="70" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="created" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="5" name="creator" nullable="true" remarks="only appliable when an authenticated user creates one" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="6" name="modified" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="7" name="modifier" nullable="true" remarks="only appliable when an authenticated user modifies one" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="status" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="9" name="active" nullable="true" remarks="reserved. use status to disable a subscription" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="10" name="news_count" nullable="true" remarks="if null, will use newsletter.news_count" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="11" name="newsletter_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_subscription_newsletter" implied="false" onDeleteCascade="false" table="newsletter"/>
         </column>
         <column autoUpdated="false" digits="0" id="12" name="topic_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="13" name="source_id" nullable="true" remarks="" size="8" type="MEDIUMINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="14" name="keyword_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="15" name="site_id" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="16" name="country_code" nullable="true" remarks="" size="2" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="17" name="user_ip" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="subscription_newsletter_idx" unique="false">
            <column ascending="true" name="newsletter_id"/>
         </index>
      </table>
      <table name="subscription_log" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="1" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="2" name="publish_strategy" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="3" name="subscription" nullable="false" remarks="" size="10" type="INT"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="tag_item" numRows="6" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="item_id" foreignKey="FK_fpqxks3masc7x1x3frflik3f" implied="false" onDeleteCascade="false" table="tag_option"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="item_type" nullable="false" remarks="" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="flags" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="5" name="priority" nullable="true" remarks="" size="5" type="SMALLINT"/>
         <column autoUpdated="false" digits="0" id="6" name="in_reports" nullable="true" remarks="show this tagitem in newsroom reports or not" size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="7" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="8" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="9" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="10" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="11" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="Idx_item_type" unique="false">
            <column ascending="true" name="item_type"/>
         </index>
      </table>
      <table name="tag_option" numRows="4" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="tag_option_id" foreignKey="FKA7A0293E98682B53" implied="false" onDeleteCascade="false" table="entity_tag"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="item_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_fpqxks3masc7x1x3frflik3f" implied="false" onDeleteCascade="false" table="tag_item"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="option_order" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="title" nullable="false" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="title2" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="7" name="score" nullable="true" remarks="" size="12" type="FLOAT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="9" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="10" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="11" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="Idx_item_id" unique="false">
            <column ascending="true" name="item_id"/>
         </index>
      </table>
      <table name="topic" numRows="64" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="topic_id" foreignKey="FK178B06237393E" implied="false" onDeleteCascade="false" table="ads"/>
            <child column="sub_topic_id" foreignKey="fk_news_sub_topic" implied="false" onDeleteCascade="false" table="news"/>
            <child column="topic_id" foreignKey="fk_news_topic" implied="false" onDeleteCascade="false" table="news"/>
            <child column="sub_topic_id" foreignKey="fk_news_history_topic_2" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="topic_id" foreignKey="fk_news_history_topic" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="sub_topic_id" foreignKey="FK_news_place_subtopic" implied="false" onDeleteCascade="false" table="news_place"/>
            <child column="topic_id" foreignKey="FK_news_place_topic" implied="false" onDeleteCascade="false" table="news_place"/>
            <child column="sub_topic_id" foreignKey="FK_archive_news_place_subtopic" implied="false" onDeleteCascade="false" table="news_place_archive"/>
            <child column="topic_id" foreignKey="FK_archive_news_place_topic" implied="false" onDeleteCascade="false" table="news_place_archive"/>
            <child column="topic_id" foreignKey="FK_news_subtopic_topic" implied="false" onDeleteCascade="false" table="news_subtopic"/>
            <child column="topic_id" foreignKey="FK_place_topic" implied="false" onDeleteCascade="false" table="place"/>
            <child column="topic_id" foreignKey="fk_topic" implied="false" onDeleteCascade="false" table="poll"/>
            <child column="parent_id" foreignKey="FK_topic_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="parent_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK_topic_topic" implied="false" onDeleteCascade="false" table="topic"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="title" nullable="false" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="full_title" nullable="false" remarks="full title in the form: parent &gt; title" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="search_title" nullable="false" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="priority" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="7" name="depth" nullable="false" remarks="topic: 1, subtopic: 2, sub-subtopic: 3, etc." size="3" type="TINYINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="8" name="url" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="meta_keyword" nullable="true" remarks="" size="300" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="meta_des" nullable="true" remarks="" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="keyword" nullable="true" remarks="keyword meta in html page of this topic" size="500" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="description" nullable="true" remarks="description meta in html page of this topic" size="500" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="13" name="visible" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="14" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="15" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="16" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="17" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="18" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK_topic_topic" unique="false">
            <column ascending="true" name="parent_id"/>
         </index>
         <index name="unq_topic_full_title" unique="true">
            <column ascending="true" name="full_title"/>
            <column ascending="true" name="site_id"/>
         </index>
         <index name="unq_topic_url" unique="true">
            <column ascending="true" name="url"/>
            <column ascending="true" name="site_id"/>
         </index>
      </table>
      <table name="user_config" numRows="3" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="user_config_id" foreignKey="FK36EBCBBE740F4D" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="topic" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="news_type" nullable="true" remarks="" size="5" type="SMALLINT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="grid_size" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="4" name="image" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="news_language" nullable="true" remarks="" size="2" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="theme" nullable="true" remarks="" size="20" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="ui_language" nullable="true" remarks="" size="2" type="VARCHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="user_message" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="false" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="1" name="news_history_id" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="2" name="status" nullable="true" remarks="" size="3" type="TINYINT"/>
         <column autoUpdated="false" digits="0" id="3" name="sender" nullable="false" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="4" name="recipient" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="5" name="sent" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="6" name="received" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="7" name="title" nullable="true" remarks="" size="65535" type="TEXT"/>
         <column autoUpdated="false" digits="0" id="8" name="body" nullable="true" remarks="" size="65535" type="TEXT"/>
         <column autoUpdated="false" digits="0" id="9" name="view_count" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="10" name="last_view" nullable="true" remarks="" size="19" type="DATETIME"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
      </table>
      <table name="user_profile" numRows="9" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <child column="user_id" foreignKey="FK_8yd4jgtdnd2x6waxx0w9hospr" implied="false" onDeleteCascade="false" table="entity_audit_log"/>
            <child column="locker_id" foreignKey="fk_news_locker" implied="false" onDeleteCascade="false" table="news"/>
            <child column="recipient_id" foreignKey="fk_news_recipient" implied="false" onDeleteCascade="false" table="news"/>
            <child column="locker_id" foreignKey="FK_7n0m9sdowho7bahiaxnxl7ijx" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="recipient_id" foreignKey="fk_news_history_recipient" implied="false" onDeleteCascade="false" table="news_history"/>
            <child column="from_user_id" foreignKey="FK_news_transition_log_user" implied="false" onDeleteCascade="false" table="news_transition_log"/>
            <child column="to_user_id" foreignKey="FK_news_transition_log_user_2" implied="false" onDeleteCascade="false" table="news_transition_log"/>
            <child column="user_id" foreignKey="FK143BF46AE3778376" implied="false" onDeleteCascade="false" table="user_role"/>
            <child column="user_id" foreignKey="fk_user-site_user_1" implied="false" onDeleteCascade="false" table="user_site"/>
         </column>
         <column autoUpdated="false" digits="0" id="1" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="2" name="access_level" nullable="true" remarks="0:sysadmin,1:newsadmin" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="3" name="user_config_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK36EBCBBE740F4D" implied="false" onDeleteCascade="false" table="user_config"/>
         </column>
         <column autoUpdated="false" digits="0" id="4" name="topic_ids" nullable="true" remarks="" size="255" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="5" name="region_ids" nullable="true" remarks="comma-separated list of region ids" size="1000" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="6" name="username" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="7" name="password" nullable="true" remarks="" size="60" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="8" name="national_code" nullable="true" remarks="" size="10" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="9" name="salt" nullable="true" remarks="" size="30" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="10" name="first_name" nullable="true" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="11" name="last_name" nullable="true" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="12" name="search_title" nullable="true" remarks="" size="100" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="13" name="country" nullable="true" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="14" name="city" nullable="true" remarks="" size="25" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="15" name="address" nullable="true" remarks="" size="150" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="16" name="cell_number" nullable="true" remarks="" size="15" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="17" name="phone_number" nullable="true" remarks="" size="15" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="18" name="email" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="19" name="website" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="20" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="21" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="22" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="23" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="24" name="active" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="25" name="avatar" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="26" name="password_expired" nullable="false" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="27" name="active_from" nullable="true" remarks="account is non-expired from this datetime" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="28" name="active_to" nullable="true" remarks="account is non-expired to this datetime" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="29" name="last_login_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="30" name="last_password_change" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="31" name="last_login_ip" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="32" name="failed_login_date" nullable="true" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" defaultValue="0" digits="0" id="33" name="failed_login_count" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="34" name="failed_login_ip" nullable="true" remarks="" size="50" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="35" name="status" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="36" name="staus" nullable="true" remarks="" size="10" type="INT"/>
         <column autoUpdated="false" digits="0" id="37" name="config" nullable="true" remarks="" size="1000" type="VARCHAR"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK36EBCBBE740F4D" unique="false">
            <column ascending="true" name="user_config_id"/>
         </index>
         <index name="username" unique="true">
            <column ascending="true" name="username"/>
         </index>
         <index name="username_password" unique="false">
            <column ascending="true" name="username"/>
            <column ascending="true" name="password"/>
         </index>
      </table>
      <table name="user_role" numRows="11" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="user_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="FK143BF46AE3778376" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="role_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_user_role_role_1" implied="false" onDeleteCascade="false" table="role"/>
         </column>
         <column autoUpdated="false" digits="0" id="3" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="1" digits="0" id="4" name="active" nullable="true" remarks="" size="0" type="BIT"/>
         <column autoUpdated="false" digits="0" id="5" name="creator" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" defaultValue="CURRENT_TIMESTAMP" digits="0" id="6" name="created" nullable="false" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="7" name="modified" nullable="true" remarks="" size="19" type="TIMESTAMP"/>
         <column autoUpdated="false" digits="0" id="8" name="modifier" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="FK143BF46AE3778376" unique="false">
            <column ascending="true" name="user_id"/>
         </index>
         <index name="fk_user_role_id" unique="false">
            <column ascending="true" name="role_id"/>
         </index>
         <index name="UK_872xec3woupu3gw59b04pj3sa" unique="true">
            <column ascending="true" name="user_id"/>
            <column ascending="true" name="role_id"/>
         </index>
      </table>
      <table name="user_site" numRows="0" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="user_id" nullable="true" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_user-site_user_1" implied="false" onDeleteCascade="false" table="user_profile"/>
         </column>
         <column autoUpdated="false" digits="0" id="2" name="site_id" nullable="true" remarks="" size="10" type="INT UNSIGNED"/>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_user-site_user_1" unique="false">
            <column ascending="true" name="user_id"/>
         </index>
      </table>
      <table name="vote" numRows="20" remarks="" type="TABLE">
         <column autoUpdated="true" digits="0" id="0" name="id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
         <column autoUpdated="false" digits="0" id="1" name="created" nullable="false" remarks="" size="19" type="DATETIME"/>
         <column autoUpdated="false" digits="0" id="2" name="ip" nullable="true" remarks="" size="40" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="3" name="ua" nullable="true" remarks="" size="200" type="VARCHAR"/>
         <column autoUpdated="false" digits="0" id="4" name="poll_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_poll" implied="false" onDeleteCascade="false" table="poll"/>
         </column>
         <column autoUpdated="false" digits="0" id="5" name="choice_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
            <parent column="id" foreignKey="fk_poll_option" implied="false" onDeleteCascade="false" table="poll_option"/>
         </column>
         <primaryKey column="id" sequenceNumberInPK="1"/>
         <index name="PRIMARY" unique="true">
            <column ascending="true" name="id"/>
         </index>
         <index name="fk_poll" unique="false">
            <column ascending="true" name="poll_id"/>
         </index>
         <index name="fk_poll_option" unique="false">
            <column ascending="true" name="choice_id"/>
         </index>
      </table>
   </tables>
</database>
