<?xml version="1.0"?>
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
    <table name="prince_faqgroup" resource="default" engine="innodb" comment="Mageprince FAQ group Table">
        <column xsi:type="int" name="faqgroup_id" unsigned="true" nullable="false" identity="true" comment="Entity ID"/>
        <column xsi:type="varchar" name="groupname" nullable="true" length="255" comment="Group Name"/>
        <column xsi:type="varchar" name="icon" nullable="true" length="255" comment="Group Icon"/>
        <column xsi:type="varchar" name="storeview" nullable="true" length="255" comment="Store View"/>
        <column xsi:type="varchar" name="customer_group" nullable="true" length="255" comment="Customer Group"/>
        <column xsi:type="int" name="sortorder" unsigned="true" nullable="true" identity="false" default="0" comment="Sort Order"/>
        <column xsi:type="smallint" name="status" unsigned="true" nullable="true" identity="false" default="1" comment="Is Enabled"/>
        <column xsi:type="datetime" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="Created at"/>
        <column xsi:type="datetime" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="Update at"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="faqgroup_id"/>
        </constraint>
    </table>
    <table name="prince_faq" resource="default" engine="innodb" comment="Mageprince FAQ Table">
        <column xsi:type="int" name="faq_id" unsigned="true" nullable="false" identity="true" comment="Entity ID"/>
        <column xsi:type="varchar" name="title" nullable="true" length="255" comment="Title"/>
        <column xsi:type="text" name="content" nullable="true" comment="Content"/>
        <column xsi:type="varchar" name="group" nullable="true" length="255" comment="Group"/>
        <column xsi:type="varchar" name="storeview" nullable="true" length="255" comment="Store View"/>
        <column xsi:type="varchar" name="customer_group" nullable="true" length="255" comment="Customer Group"/>
        <column xsi:type="int" name="sortorder" unsigned="true" nullable="true" identity="false" default="0" comment="Sort Order"/>
        <column xsi:type="smallint" name="status" unsigned="true" nullable="true" identity="false" default="1" comment="Is Enabled"/>
        <column xsi:type="datetime" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="Created at"/>
        <column xsi:type="datetime" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="Update at"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="faq_id"/>
        </constraint>
    </table>
</schema>
