img/favicon-touch.svg


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<svg
   xmlns:dc="http://purl.org/dc/elements/1.1/"
   xmlns:cc="http://creativecommons.org/ns#"
   xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
   xmlns:svg="http://www.w3.org/2000/svg"
   xmlns="http://www.w3.org/2000/svg"
   id="svg4551"
   viewBox="0 0 128 128"
   x="0px"
   y="0px"
   enable-background="new 0 0 595.275 311.111"
   width="128"
   height="128"
   xml:space="preserve"
   version="1.1"><metadata
     id="metadata4557"><rdf:RDF><cc:Work
         rdf:about=""><dc:format>image/svg+xml</dc:format><dc:type
           rdf:resource="http://purl.org/dc/dcmitype/StillImage" /><dc:title /></cc:Work></rdf:RDF></metadata><defs
     id="defs4555" /><rect
     style="fill:#0082c9;stroke-width:4"
     id="rect4547"
     x="0"
     y="-7.6293945e-06"
     width="128"
     height="128"
     ry="20"
     rx="20" /><path
     style="fill:#ffffff;stroke-width:3.68571424"
     d="m 15.085709,12.661086 c -2.041886,0 -3.685714,1.643827 -3.685714,3.685695 v 7.371441 c 0,2.041881 1.643828,3.68572 3.685714,3.68572 h 95.828571 c 2.04189,0 3.68571,-1.643839 3.68571,-3.68572 v -7.371441 c 0,-2.041868 -1.64382,-3.685695 -3.68571,-3.685695 z m 0,29.485696 c -2.041886,0 -3.685714,1.643841 -3.685714,3.68572 v 7.371441 c 0,2.04188 1.643828,3.685719 3.685714,3.685719 h 66.342856 c 2.041884,0 3.685715,-1.643839 3.685715,-3.685719 v -7.371441 c 0,-2.041879 -1.643831,-3.68572 -3.685715,-3.68572 z m 0,29.48572 c -2.041886,0 -3.685714,1.64384 -3.685714,3.68572 v 7.371441 c 0,2.041879 1.643828,3.68572 3.685714,3.68572 h 88.457141 c 2.04189,0 3.68572,-1.643841 3.68572,-3.68572 v -7.371441 c 0,-2.04188 -1.64383,-3.68572 -3.68572,-3.68572 z m 0,29.485728 c -2.041886,0 -3.685714,1.64384 -3.685714,3.68571 v 7.37145 c 0,2.04188 1.643828,3.68571 3.685714,3.68571 H 59.31428 c 2.041888,0 3.685717,-1.64383 3.685717,-3.68571 v -7.37145 c 0,-2.04187 -1.643829,-3.68571 -3.685717,-3.68571 z"
     id="path4725" /></svg>
<database>
    <name>*dbname*</name>
    <create>true</create>
    <overwrite>false</overwrite>
    <charset>utf8</charset>
    <table>
        <name>*dbprefix*news_folders</name>
        <declaration>
            <field>
                <name>id</name>
                <type>integer</type>
                <notnull>true</notnull>
                <autoincrement>true</autoincrement>
                <unsigned>true</unsigned>
                <primary>true</primary>
                <length>8</length>
            </field>
            <field>
                <name>parent_id</name>
                <type>integer</type>
                <length>8</length>
                <notnull>false</notnull>
            </field>
            <field>
                <name>name</name>
                <type>text</type>
                <length>100</length>
                <notnull>true</notnull>
            </field>
            <field>
                <name>user_id</name>
                <type>text</type>
                <default></default>
                <notnull>true</notnull>
                <length>64</length>
            </field>
            <field>
                <name>opened</name>
                <type>boolean</type>
                <default>true</default>
                <notnull>true</notnull>
            </field>
            <field>
                <name>deleted_at</name>
                <type>integer</type>
                <length>8</length>
                <default>0</default>
                <notnull>false</notnull>
                <unsigned>true</unsigned>
            </field>
            <field>
                <name>last_modified</name>
                <type>integer</type>
                <default>0</default>
                <length>8</length>
                <notnull>false</notnull>
                <unsigned>true</unsigned>
            </field>

            <index>
                <name>news_folders_last_modified_index</name>
                <field>
                    <name>last_modified</name>
                </field>
            </index>

            <index>
                <name>news_folders_parent_id_index</name>
                <field>
                    <name>parent_id</name>
                </field>
            </index>

            <index>
                <name>news_folders_user_id_index</name>
                <field>
                    <name>user_id</name>
                </field>
            </index>
        </declaration>
    </table>

    <table>
        <name>*dbprefix*news_feeds</name>
        <declaration>
            <field>
                <name>id</name>
                <type>integer</type>
                <notnull>true</notnull>
                <autoincrement>true</autoincrement>
                <primary>true</primary>
                <length>8</length>
                <unsigned>true</unsigned>
            </field>
            <field>
                <name>user_id</name>
                <type>text</type>
                <default></default>
                <notnull>true</notnull>
                <length>64</length>
            </field>
            <field>
                <name>last_modified</name>
                <type>integer</type>
                <default>0</default>
                <length>8</length>
                <notnull>false</notnull>
                <unsigned>true</unsigned>
            </field>
            <field>
                <name>url_hash</name>
                <type>text</type>
                <length>32</length>
                <notnull>true</notnull>
            </field>
            <field>
                <name>url</name>
                <type>clob</type>
                <notnull>true</notnull>
            </field>
            <field>
                <name>location</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>title</name>
                <type>clob</type>
                <notnull>true</notnull>
            </field>
            <field>
                <name>link</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>favicon_link</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>http_last_modified</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>http_etag</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>added</name>
                <type>integer</type>
                <default>0</default>
                <length>8</length>
                <notnull>false</notnull>
                <unsigned>true</unsigned>
            </field>
            <field>
                <name>articles_per_update</name>
                <type>integer</type>
                <default>0</default>
                <length>8</length>
                <notnull>true</notnull>
            </field>
            <field>
                <name>update_error_count</name>
                <type>integer</type>
                <default>0</default>
                <length>8</length>
                <notnull>true</notnull>
            </field>
            <field>
                <name>last_update_error</name>
                <type>clob</type>
                <default></default>
                <notnull>false</notnull>
            </field>
            <field>
                <name>basic_auth_user</name>
                <type>clob</type>
                <default></default>
                <notnull>false</notnull>
            </field>
            <field>
                <name>basic_auth_password</name>
                <type>clob</type>
                <default></default>
                <notnull>false</notnull>
            </field>
            <field>
                <name>deleted_at</name>
                <type>integer</type>
                <default>0</default>
                <notnull>false</notnull>
                <length>8</length>
                <unsigned>true</unsigned>
            </field>
            <field>
                <name>folder_id</name>
                <type>integer</type>
                <length>8</length>
                <notnull>true</notnull>
            </field>
            <field>
                <name>prevent_update</name>
                <type>boolean</type>
                <default>false</default>
                <notnull>true</notnull>
            </field>
            <field>
                <name>pinned</name>
                <type>boolean</type>
                <default>false</default>
                <notnull>true</notnull>
            </field>
            <field>
                <name>full_text_enabled</name>
                <type>boolean</type>
                <default>false</default>
                <notnull>true</notnull>
            </field>
            <field>
                <name>ordering</name>
                <type>integer</type>
                <default>0</default>
                <notnull>true</notnull>
            </field>
            <field>
                <name>update_mode</name>
                <type>integer</type>
                <default>0</default>
                <notnull>true</notnull>
            </field>

            <index>
                <name>news_feeds_last_modified_index</name>
                <field>
                    <name>last_modified</name>
                </field>
            </index>

            <index>
                <name>news_feeds_user_id_index</name>
                <field>
                    <name>user_id</name>
                </field>
            </index>

            <index>
                <name>news_feeds_folder_id_index</name>
                <field>
                    <name>folder_id</name>
                </field>
            </index>

            <index>
                <name>news_feeds_url_hash_index</name>
                <field>
                    <name>url_hash</name>
                </field>
            </index>
        </declaration>
    </table>

    <table>
        <name>*dbprefix*news_items</name>
        <declaration>
             <field>
                <name>id</name>
                <type>integer</type>
                <length>8</length>
                <notnull>true</notnull>
                <autoincrement>true</autoincrement>
                <primary>true</primary>
                <unsigned>true</unsigned>
            </field>
            <field>
                <name>guid_hash</name>
                <type>text</type>
                <notnull>true</notnull>
                <length>32</length>
            </field>
            <field>
                <name>fingerprint</name>
                <type>text</type>
                <notnull>false</notnull>
                <length>32</length>
            </field>
            <field>
                <name>content_hash</name>
                <type>text</type>
                <notnull>false</notnull>
                <length>32</length>
            </field>
            <field>
                <name>rtl</name>
                <type>boolean</type>
                <notnull>true</notnull>
                <default>false</default>
            </field>
            <field>
                <name>search_index</name>
                <type>clob</type>
            </field>
            <field>
                <name>guid</name>
                <type>clob</type>
                <notnull>true</notnull>
            </field>
            <field>
                <name>url</name>
                <type>clob</type>
            </field>
            <field>
                <name>title</name>
                <type>clob</type>
            </field>
            <field>
                <name>author</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>pub_date</name>
                <type>integer</type>
                <length>8</length>
                <unsigned>true</unsigned>
                <notnull>false</notnull>
            </field>
            <field>
                <name>body</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>enclosure_mime</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>enclosure_link</name>
                <type>clob</type>
                <notnull>false</notnull>
            </field>
            <field>
                <name>feed_id</name>
                <type>integer</type>
                <length>8</length>
                <notnull>true</notnull>
            </field>
            <field>
                <name>status</name>
                <type>integer</type>
                <length>8</length>
                <default>0</default>
                <notnull>true</notnull>
            </field>
            <field>
                <name>last_modified</name>
                <type>integer</type>
                <default>0</default>
                <length>8</length>
                <notnull>false</notnull>
                <unsigned>true</unsigned>
            </field>

            <index>
                <name>news_items_last_modified_index</name>
                <field>
                    <name>last_modified</name>
                </field>
            </index>

            <index>
                <name>news_items_feed_id_index</name>
                <field>
                    <name>feed_id</name>
                </field>
            </index>

            <index>
                <name>news_items_fingerprint_index</name>
                <field>
                    <name>fingerprint</name>
                </field>
            </index>

            <index>
                <name>news_items_item_guid</name>
                <field>
                    <name>guid_hash</name>
                </field>
                <field>
                    <name>feed_id</name>
                </field>
            </index>
        </declaration>
    </table>
</database>