<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : pages.xml
    Created on : 24 de enero de 2012, 19:57
    Author     : Carlos Garcia Gomez
    Description:
        Structure for the pages table.
-->
<table>
    <column>
        <name>icon</name>
        <type>character varying(50)</type>
    </column>
    <column>
        <name>menu</name>
        <type>character varying(20)</type>
    </column>
    <column>
        <name>name</name>
        <type>character varying(40)</type>
        <null>NO</null>
    </column>
    <column>
        <name>ordernum</name>
        <type>integer</type>
        <null>NO</null>
        <default>100</default>
    </column>
    <column>
        <name>showonmenu</name>
        <type>boolean</type>
        <null>NO</null>
        <default>true</default>
    </column>
    <column>
        <name>submenu</name>
        <type>character varying(20)</type>
    </column>
    <column>
        <name>title</name>
        <type>character varying(50)</type>
        <null>NO</null>
    </column>
    <constraint>
        <name>pages_pkey</name>
        <type>PRIMARY KEY (name)</type>
    </constraint>
</table>
