Struktur der Tabelle zen_admin_activity_log'

[disa3000]

Hallo Leute,

ich habe mir gerade die o.g. Tabelle zerschossen. Hat jemand die Struktur dazu?

Besten Dank

[disa3000]

Antwort gefunden...

Hab´s doch noch gefunden:

So stellt man diese Tabelle wieder her:


CREATE TABLE admin_activity_log (
log_id int(15) NOT NULL auto_increment,
access_date datetime NOT NULL default '0001-01-01 00:00:00',
admin_id int(11) NOT NULL default '0',
page_accessed varchar(80) NOT NULL default '',
page_parameters varchar(150) default NULL,
ip_address varchar(15) NOT NULL default '',
PRIMARY KEY (log_id),
KEY idx_page_accessed_zen (page_accessed),
KEY idx_access_date_zen (access_date),
KEY idx_ip_zen (ip_address)
) TYPE=MyISAM;

[klartexter]

Hat jemand die Struktur dazu?

-- 
-- Tabellenstruktur für Tabelle `zen_admin_activity_log`
-- 

CREATE TABLE `zen_admin_activity_log` (
  `log_id` int(15) NOT NULL auto_increment,
  `access_date` datetime NOT NULL default '0001-01-01 00:00:00',
  `admin_id` int(11) NOT NULL default '0',
  `page_accessed` varchar(80) collate latin1_general_ci NOT NULL default '',
  `page_parameters` varchar(150) collate latin1_general_ci default NULL,
  `ip_address` varchar(15) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`log_id`),
  KEY `idx_page_accessed_zen` (`page_accessed`),
  KEY `idx_access_date_zen` (`access_date`),
  KEY `idx_ip_zen` (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

[disa3000]

Danke!