Index: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql =================================================================== diff -u -r7748 -r7762 --- branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (.../install_schema.sql) (revision 7748) +++ branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (.../install_schema.sql) (revision 7762) @@ -422,3 +422,12 @@ PRIMARY KEY (PopupId), KEY TemplateName (TemplateName) ); + +CREATE TABLE SpiderUserAgents ( + `AgentId` int(10) unsigned NOT NULL auto_increment, + `Name` varchar(255) NOT NULL default '', + `Version` varchar(100) NOT NULL default '', + `UserAgent` varchar(255) NOT NULL default '', + PRIMARY KEY (`AgentId`), + KEY `UserAgent` (`UserAgent`(100)) +);