/*==============================================================*/
/* DBMS name:      MySQL 4.0                                    */
/* Created on:     2007-12-13 10:12:28                          */
/*==============================================================*/


drop table if exists X27_DEPARTMENT;

drop table if exists X27_MENU;

drop table if exists X27_STAFF;

/*==============================================================*/
/* Table: X27_DEPARTMENT                                        */
/*==============================================================*/
create table X27_DEPARTMENT
(
   ID                             varchar(36)                    not null,
   FULLNAME                       varchar(256)                   not null,
   SHORTNAME                      varchar(256)                   not null,
   REMARK                         varchar(1024),
   primary key (ID)
)
type = InnoDB;

/*==============================================================*/
/* Table: X27_MENU                                              */
/*==============================================================*/
create table X27_MENU
(
   ID                             varchar(36)                    not null,
   PARENTID                       varchar(36)                    not null,
   NAME                           varchar(256)                   not null,
   DESCRIPTION                    varchar(1024),
   HREF                           varchar(1024),
   SORT                           varchar(4)                     not null,
   LEAF                           varchar(4)                     not null default '1',
   primary key (ID)
)
type = InnoDB;

/*==============================================================*/
/* Table: X27_STAFF                                             */
/*==============================================================*/
create table X27_STAFF
(
   ID                             varchar(36)                    not null,
   NAME                           varchar(256),
   DEPARTMENTID                   varchar(36)                    not null,
   EMAIL                          varchar(256),
   MOBILE                         varchar(256),
   primary key (ID)
)
type = InnoDB;