CREATE TABLE `permission_module` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `module_name` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

CREATE TABLE `permission_group` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `group_name` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

CREATE TABLE `permission_page_group` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `group_id` smallint(5) NOT NULL,
  `page_id` smallint(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

CREATE TABLE `permission_module_group` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `module_id` smallint(5) NOT NULL,
  `group_id` smallint(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

CREATE TABLE `permission_loginname_group` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `loginname` tinytext NOT NULL,
  `group_id` smallint(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8