 #
 
 CREATE TABLE {$db_prefix}spiders (
-  id_spider smallint(5) unsigned NOT NULL auto_increment,
-  spider_name varchar(255) NOT NULL default '',
-  user_agent varchar(255) NOT NULL default '',
-  ip_info varchar(255) NOT NULL default '',
+  id_spider SMALLINT(5) UNSIGNED AUTO_INCREMENT,
+  spider_name VARCHAR(255) NOT NULL DEFAULT '',
+  user_agent VARCHAR(255) NOT NULL DEFAULT '',
+  ip_info VARCHAR(255) NOT NULL DEFAULT '',
   PRIMARY KEY id_spider(id_spider)
 ) ENGINE={$engine};
 

#

CREATE TABLE {$db_prefix}admin_info_files (
  id_file tinyint(4) unsigned NOT NULL auto_increment,
  filename varchar(255) NOT NULL default '',
  path varchar(255) NOT NULL default '',
  parameters varchar(255) NOT NULL default '',
  data text NOT NULL,
  filetype varchar(255) NOT NULL default '',
  PRIMARY KEY (id_file),
  KEY filename (filename(30))
) ENGINE={$engine};

#

#

CREATE TABLE {$db_prefix}calendar (
  id_event SMALLINT(5) UNSIGNED AUTO_INCREMENT,
  start_date date NOT NULL DEFAULT '0001-01-01',
  end_date date NOT NULL DEFAULT '0001-01-01',
  id_board SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  id_topic MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
  title VARCHAR(255) NOT NULL DEFAULT '',
  id_member MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (id_event),
  INDEX idx_start_date (start_date),
  INDEX idx_end_date (end_date),
  INDEX idx_topic (id_topic, id_member)
) ENGINE={$engine};

#
