 #
 
 CREATE TABLE {$db_prefix}user_alerts_prefs (
-  id_member mediumint(8) unsigned NOT NULL default '0',
-  alert_pref varchar(32) NOT NULL default '',
-  alert_value tinyint(3) NOT NULL default '0',
+  id_member MEDIUMINT(8) UNSIGNED DEFAULT '0',
+  alert_pref VARCHAR(32) DEFAULT '',
+  alert_value TINYINT(3) NOT NULL DEFAULT '0',
   PRIMARY KEY (id_member, alert_pref)
 ) ENGINE={$engine};
 

VALUES ('xx', 'Standard', '0'),
	('thumbup', 'Thumb Up', '1'),
	('thumbdown', 'Thumb Down', '2'),
	('exclamation', 'Exclamation point', '3'),
	('question', 'Question mark', '4'),
	('lamp', 'Lamp', '5'),
	('smiley', 'Smiley', '6'),

#

CREATE TABLE {$db_prefix}log_spider_stats (
  id_spider SMALLINT(5) UNSIGNED DEFAULT '0',
  page_hits SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  last_seen INT(10) UNSIGNED NOT NULL DEFAULT '0',
  stat_date DATE DEFAULT '0001-01-01',
  PRIMARY KEY (stat_date, id_spider)
) ENGINE={$engine};

