CREATE TABLE `groups` (
  `id_group` int(11) NOT NULL auto_increment,
  `type_group` tinytext NOT NULL,
  `descr` text,
  PRIMARY KEY  (`id_group`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='таблица определяет группы польз?' AUTO_INCREMENT=25 ;

CREATE TABLE `modules` (
  `mod_id` int(32) NOT NULL auto_increment,
  `mod_pid` tinyint(4) default '0',
  `block_id` int(11) default '0',
  `mod_name` mediumtext,
  `mod_path` varchar(255) default NULL,
  `descr` mediumtext,
  `visib` tinyint(5) NOT NULL default '0',
  `show_sitemap` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`mod_id`),
  FULLTEXT KEY `mod_name` (`mod_name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=4 ;

CREATE TABLE `operations` (
  `op_id` int(11) NOT NULL,
  `op_name` text NOT NULL,
  PRIMARY KEY  (`op_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `permission` (
  `id_group` int(11) default NULL,
  `mod_id` int(11) default NULL,
  `op_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;