<SQML/>

<?xml version="1.0" encoding="UTF-8"?>

−

<sqml:create xmlns:sqml="http://www.rapidweb.tools/sql">

−

<sqml:table name="S_PRODUCT" if-not-exists="true" default-encoding="utf8">

<sqml:column name="PS_PRODUCT" datatype="POSITIVE INTEGER" length="30" key="primary" auto-increment="true" index="true"/>[0 lines]

<sqml:column name="S_PRODUCT" datatype="POSITIVE INTEGER" length="30" not-null="true" index="true"/>[0 lines]

<sqml:column name="VS_PRODUCT" datatype="POSITIVE INTEGER" length="30" default="1" index="true"/>[0 lines]

<sqml:column name="LS_PRODUCT" datatype="POSITIVE INTEGER" length="30"/>[0 lines]

<sqml:column name="X_DELETED" datatype="BOOLEAN" default="0" not-null="true"/>[0 lines]

<sqml:column name="X_CREATION" datatype="TIMESTAMP" default="CURRENT_TIMESTAMP"/>[0 lines]

<sqml:column name="X_MODIFIED" datatype="TIMESTAMP" default="CURRENT_TIMESTAMP"/>[0 lines]

<sqml:column name="X_POSITION" datatype="DECIMAL" length="30,1"/>[0 lines]

<sqml:column name="X_LOCALID" datatype="POSITIVE INTEGER" length="30"/>[0 lines]

<sqml:column name="X_OWNER" datatype="POSITIVE INTEGER" length="30" default="0" index="true"/>[0 lines]

<sqml:column name="X_EDITOR" datatype="POSITIVE INTEGER" length="30" default="0" index="true"/>[0 lines]

<sqml:column name="X_ROLE" datatype="POSITIVE INTEGER" length="30" default="0" index="true"/>[0 lines]

<sqml:column name="X_CURRENTUSER" datatype="POSITIVE INTEGER" length="30" index="true"/>[0 lines]

<sqml:column name="X_CURRENTTIMESTAMP" datatype="TIMESTAMP" default="CURRENT_TIMESTAMP" index="true" on-update="CURRENT_TIMESTAMP"/>[0 lines]

<sqml:column name="X_IP" datatype="STRING" length="20"/>[0 lines]

<sqml:column name="X_COUNTRY" datatype="STRING" length="10" index="true"/>[0 lines]

<sqml:column name="X_REGION" datatype="POSITIVE INTEGER" length="30" index="true"/>[0 lines]

<sqml:column name="X_STATUS" datatype="INTEGER" length="5" default="0" index="true"/>[0 lines]

<sqml:column name="X_SURVEY" datatype="INTEGER" length="30" index="true"/>[0 lines]

<sqml:column name="X_MAXPID" datatype="POSITIVE INTEGER" length="30"/>[0 lines]

<sqml:column name="X_MAXVID" datatype="POSITIVE INTEGER" length="30"/>[0 lines]

<sqml:column name="D_NO" datatype="STRING" length="255"/>[0 lines]

<sqml:column name="D_TYPE" datatype="INTEGER" length="1"/>[0 lines]

<sqml:column name="D_FROM" datatype="DATE"/>[0 lines]

<sqml:column name="D_TO" datatype="DATE"/>[0 lines]

<sqml:column name="D_LEVEL" datatype="INTEGER" length="1"/>[0 lines]

<sqml:column name="D_ADMINS" datatype="INTEGER" length="10"/>[0 lines]

<sqml:column name="D_DATA" datatype="INTEGER" length="10"/>[0 lines]

<sqml:column name="D_FREQUENCY" datatype="INTEGER" length="1"/>[0 lines]

<sqml:partitioning type="KEY" count="5"/>[0 lines]

</sqml:table>

[30 lines]

</sqml:create>

[31 lines]