## 11 UML Class(es) found
create table Inquiry
(
   inquiry_id               int(10) unsigned      not null auto_increment,
   login_id                 int(10)           default null,
   `date`                   datetime          not null,
   find                     int(1)            default 1,
   name                     varchar(255)      not null,
   `lock`                   tinyint(1)        default 0,
   expiry                   int(10) unsigned      not null,
   definition               text              default null,
   rights                   varchar(255)      default null,
   primary key              (inquiry_id)
) engine = InnoDB;


create table Languages
(
   lang_id                  int(10) unsigned      not null auto_increment,
   name                     varchar(255)      not null,
   shortcut                 varchar(10)       not null,
   primary key              (lang_id),
    unique                  (name)
) engine = InnoDB;


create table Menu
(
   menu_id                  int(10) unsigned      not null auto_increment,
   tree_id                  varchar(255) collate ascii_general_ci      not null,
   rootmenu                 varchar(255)      default null,
   name                     varchar(255)      not null,
   link                     varchar(255)      default null,
   javascript               varchar(255)      default null,
   rights                   varchar(255)      default null,
   find                     int(1)            default 1,
   primary key              (menu_id),
    unique                  (tree_id)
) engine = InnoDB;


create table NCategories
(
   category_id              int(10) unsigned      not null auto_increment,
   tree_id                  varchar(255) collate ascii_general_ci      not null,
   name                     varchar(255)      not null,
   primary key              (category_id),
    unique                  (name),
    unique                  (tree_id)
) engine = InnoDB;


create table Dictionary
(
   lang_id                  int(10) unsigned      not null,
   const                    varchar(255)      not null,
   string                   varchar(255)      not null,
   index                    (lang_id),
   foreign key              (lang_id) references Languages (lang_id),
    index                   (const),
    unique                  (const,lang_Id)
) engine = InnoDB;


create table Events
(
   event_id                 int(10) unsigned      not null auto_increment,
   lang_id                  int(10) unsigned      not null,
   login_id                 int(10)           default null,
   date                     datetime          not null,
   find                     int(1)            default 1,
   name                     varchar(255)      not null,
   `from`                   datetime          not null,
   `to`                     datetime          not null,
   formating                enum('xhtml','nl2br','self')      default 'nl2br',
   `text`                   text              default null,
   primary key              (event_id),
   index                    (lang_id),
   foreign key              (lang_id) references Languages (lang_id)
) engine = InnoDB;


create table Forums
(
   forum_id                 int(10) unsigned      not null auto_increment,
   lang_id                  int(10) unsigned      not null,
   name                     varchar(255)      not null,
   description              text              default null,
   primary key              (forum_id),
   index                    (lang_id),
   foreign key              (lang_id) references Languages (lang_id)
) engine = InnoDB;


create table Inquires_data
(
   inquiry_id               int(10) unsigned      not null,
   `date`                   datetime          not null,
   user_agent               varchar(255)      not null,
   data                     text              default null,
   index                    (inquiry_id),
   foreign key              (inquiry_id) references Inquiry (inquiry_id)
) engine = InnoDB;


create table News
(
   new_id                   int(10) unsigned      not null auto_increment,
   category_id              int(10) unsigned      not null,
   lang_id                  int(10) unsigned      not null,
   login_id                 int(10)           default null,
   date                     datetime          not null,
   find                     int(1)            default 1,
   name                     varchar(255)      not null,
   formating                enum('xhtml','nl2br','self')      default 'nl2br',
   text                     text              default null,
   primary key              (new_id),
   index                    (category_id),
   index                    (lang_id),
   foreign key              (category_id) references NCategories (category_id),
   foreign key              (lang_id) references Languages (lang_id)
) engine = InnoDB;


create table Texts
(
   text_id                  int(10) unsigned      not null auto_increment,
   lang_id                  int(10) unsigned      not null,
   login_id                 int(10)           default null,
   date                     datetime          not null,
   find                     int(1)            default 1,
   name                     varchar(255)      not null,
   formating                enum('xhtml','nl2br','self')      default 'nl2br',
   text                     text              default null,
   primary key              (text_id),
   index                    (lang_id),
   foreign key              (lang_id) references Languages (lang_id)
) engine = InnoDB;


create table Forums_data
(
   forum_id                 int(10) unsigned      not null,
   tree_id                  varchar(512) collate ascii_general_ci      not null,
   login_id                 int(10)           not null,
   a_name                   varchar(255)      default null,
   `date`                   datetime          not null,
   name                     varchar(255)      not null,
   `text`                   text              not null,
   index                    (forum_id),
   foreign key              (forum_id) references Forums (forum_id),
    index                   (tree_id),
    unique                  (forum_id,tree_id)
) engine = InnoDB;