Просмотр архива DCMS Special 6 beta

CREATE TABLE `admin_log` (
  `id` int(10) unsigned NOT NULL
auto_increment,
  `id_user` int(10) unsigned NOT NULL,
  `time` int(10)
unsigned NOT NULL,
  `mod` int(11) NOT NULL,
  `act` int(11) NOT NULL,
 
`opis` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `mod` (`mod`),
  KEY
`act` (`act`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE
`admin_log_act` (
  `id` int(11) NOT NULL auto_increment,
  `id_mod`
int(11) NOT NULL,
  `name` varchar(64) default NULL,
  PRIMARY KEY 
(`id`),
  KEY `act` (`name`),
  KEY `id_mod` (`id_mod`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;

CREATE TABLE `admin_log_mod` (
  `id` int(11) NOT
NULL auto_increment,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY  (`id`),

 KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;