diff options
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index 9f2ef285f..0be5db11f 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -20,13 +20,15 @@ CREATE TABLE access ( -- CREATE TABLE accesslog ( + aid tinyint(10) NOT NULL auto_increment, title varchar(255) default NULL, path varchar(255) default NULL, url varchar(255) default NULL, hostname varchar(128) default NULL, uid int(10) unsigned default '0', timestamp int(11) unsigned NOT NULL default '0', - KEY accesslog_timestamp (timestamp) + KEY accesslog_timestamp (timestamp), + PRIMARY KEY (aid) ) TYPE=MyISAM; -- |