PHP SQL::setup_table方法代码示例

 /**
  * create tables for files
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['active'] = "ENUM('Y','R','N') DEFAULT 'Y' NOT NULL";
     $fields['active_set'] = "ENUM('Y','R','N') DEFAULT 'Y' NOT NULL";
     $fields['alternate_href'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['anchor'] = "VARCHAR(64) DEFAULT 'section:1' NOT NULL";
     $fields['anchor_id'] = "MEDIUMINT UNSIGNED NOT NULL";
     $fields['anchor_type'] = "VARCHAR(64) DEFAULT 'section' NOT NULL";
     $fields['assign_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['assign_date'] = "DATETIME";
     $fields['assign_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['assign_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['behaviors'] = "TEXT NOT NULL";
     $fields['create_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['create_date'] = "DATETIME";
     $fields['create_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['create_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['description'] = "TEXT NOT NULL";
     $fields['edit_action'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $fields['edit_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['edit_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['file_href'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['file_name'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['file_size'] = "INT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['hits'] = "INT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['icon_url'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['keywords'] = "TEXT NOT NULL";
     $fields['overlay'] = "TEXT NOT NULL";
     $fields['overlay_id'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['rank'] = "INT UNSIGNED DEFAULT 10000 NOT NULL";
     $fields['source'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['thumbnail_url'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['title'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX active'] = "(active)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX file_size'] = "(file_size)";
     $indexes['INDEX hits'] = "(hits)";
     $indexes['INDEX overlay_id'] = "(overlay_id)";
     $indexes['INDEX rank'] = "(rank)";
     $indexes['INDEX title'] = "(title(25))";
     $indexes['FULLTEXT INDEX'] = "full_text(title, source, keywords)";
     return SQL::setup_table('files', $fields, $indexes);
 }

 /**
  * create tables for comments
  *
  * @see control/setup.php
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['anchor'] = "VARCHAR(64) DEFAULT 'section:1' NOT NULL";
     $fields['anchor_type'] = "VARCHAR(64) DEFAULT 'section' NOT NULL";
     $fields['anchor_id'] = "MEDIUMINT UNSIGNED NOT NULL";
     $fields['previous_id'] = "MEDIUMINT UNSIGNED DEFAULT 0 ";
     $fields['type'] = "VARCHAR(64) DEFAULT 'default' NOT NULL";
     $fields['description'] = "TEXT NOT NULL";
     $fields['create_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['create_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['create_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['create_date'] = "DATETIME";
     $fields['edit_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['edit_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_action'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX anchor_id'] = "(anchor_id)";
     $indexes['INDEX anchor_type'] = "(anchor_type)";
     $indexes['INDEX create_date'] = "(create_date)";
     $indexes['INDEX create_id'] = "(create_id)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX edit_id'] = "(edit_id)";
     $indexes['INDEX previous_id'] = "(previous_id)";
     $indexes['INDEX type'] = "(type)";
     $indexes['FULLTEXT INDEX'] = "full_text(description)";
     $views = array();
     $views[] = "CREATE OR REPLACE VIEW " . SQL::table_name('comments_by_person_per_month') . " AS" . " SELECT" . "  SUBSTRING(edit_date, 1, 7) AS month," . "  edit_id AS 'id'," . "  edit_name AS 'name'," . "  COUNT(id) AS 'contributions'" . " FROM " . SQL::table_name('comments') . " GROUP BY month, edit_name" . " ORDER BY month DESC, contributions DESC";
     $views[] = "CREATE OR REPLACE VIEW " . SQL::table_name('comments_by_anchor_per_month') . " AS" . " SELECT" . "  SUBSTRING(edit_date, 1, 7) AS month," . "  anchor," . "  COUNT(id) AS 'contributions'" . " FROM " . SQL::table_name('comments') . " GROUP BY month, anchor" . " ORDER BY month DESC, contributions DESC";
     return SQL::setup_table('comments', $fields, $indexes, $views);
 }

 /**
  * create table for values
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     // up to 255 chars
     $fields['value'] = "MEDIUMTEXT NOT NULL";
     // up to 16M chars
     $fields['edit_date'] = "DATETIME";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     return SQL::setup_table('values', $fields, $indexes);
 }

 /**
  * create tables for users
  *
  * @see control/setup.php
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['active'] = "ENUM('Y','R','N') DEFAULT 'Y' NOT NULL";
     $fields['aim_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['alternate_number'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['authenticate_date'] = "DATETIME";
     $fields['authenticate_failures'] = "SMALLINT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['avatar_url'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['birth_date'] = "DATETIME";
     $fields['capability'] = "ENUM('A','M','S','?') DEFAULT '?' NOT NULL";
     $fields['click_anchor'] = "VARCHAR(64) DEFAULT '' NOT NULL";
     $fields['click_date'] = "DATETIME";
     $fields['create_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['create_id'] = "MEDIUMINT UNSIGNED DEFAULT 1 NOT NULL";
     $fields['create_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['create_date'] = "DATETIME";
     $fields['description'] = "TEXT NOT NULL";
     $fields['edit_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_id'] = "MEDIUMINT UNSIGNED DEFAULT 1 NOT NULL";
     $fields['edit_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_action'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $fields['editor'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['email'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['full_name'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['from_where'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['handle'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['icq_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['interface'] = "ENUM('I','C') DEFAULT 'I' NOT NULL";
     $fields['introduction'] = "TEXT NOT NULL";
     $fields['irc_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['jabber_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['language'] = "VARCHAR(6) DEFAULT '' NOT NULL";
     $fields['login_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['login_date'] = "DATETIME";
     $fields['msn_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['nick_name'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['options'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['overlay'] = "TEXT NOT NULL";
     $fields['overlay_id'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['password'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['pgp_key'] = "TEXT NOT NULL";
     $fields['phone_number'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['post_date'] = "DATETIME";
     $fields['posts'] = "INT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['signature'] = "TEXT NOT NULL";
     $fields['skype_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['tags'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['twitter_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['vcard_agent'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['vcard_label'] = "TEXT NOT NULL";
     $fields['vcard_organization'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['vcard_title'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['web_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['with_newsletters'] = "ENUM('Y','N') DEFAULT 'N' NOT NULL";
     $fields['without_alerts'] = "ENUM('Y','N') DEFAULT 'N' NOT NULL";
     $fields['without_confirmations'] = "ENUM('Y','N') DEFAULT 'N' NOT NULL";
     $fields['without_messages'] = "ENUM('Y','N') DEFAULT 'N' NOT NULL";
     $fields['yahoo_address'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX birth_date'] = "(birth_date)";
     $indexes['INDEX create_date'] = "(create_date)";
     $indexes['INDEX create_id'] = "(create_id)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX edit_id'] = "(edit_id)";
     $indexes['INDEX email'] = "(email)";
     $indexes['INDEX full_name'] = "(full_name(255))";
     $indexes['INDEX handle'] = "(handle)";
     $indexes['INDEX login_date'] = "(login_date)";
     $indexes['INDEX nick_name'] = "(nick_name)";
     $indexes['INDEX overlay_id'] = "(overlay_id)";
     $indexes['INDEX post_date'] = "(post_date)";
     $indexes['INDEX posts'] = "(posts)";
     $indexes['INDEX with_newsletters'] = "(with_newsletters)";
     $indexes['FULLTEXT INDEX'] = "full_text(nick_name, full_name, introduction, description)";
     return SQL::setup_table('users', $fields, $indexes);
 }

 /**
  * create tables for profiles
  *
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['url'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['total_hits'] = "INT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['total_time'] = "DOUBLE UNSIGNED";
     $fields['minimum_time'] = "FLOAT UNSIGNED";
     $fields['maximum_time'] = "FLOAT UNSIGNED";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX url'] = "(url)";
     $indexes['INDEX hits'] = "(total_hits)";
     return SQL::setup_table('profiles', $fields, $indexes);
 }

 /**
  * create or alter tables for tables
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['nick_name'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['anchor'] = "VARCHAR(64) DEFAULT 'section:1' NOT NULL";
     $fields['title'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['description'] = "TEXT NOT NULL";
     $fields['source'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['query'] = "TEXT NOT NULL";
     $fields['with_zoom'] = "ENUM('Y','T','N') DEFAULT 'N' NOT NULL";
     $fields['edit_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['edit_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX edit_id'] = "(edit_id)";
     $indexes['INDEX nick_name'] = "(nick_name)";
     $indexes['INDEX title'] = "(title(255))";
     $indexes['FULLTEXT INDEX'] = "full_text(title, source, description)";
     $text = SQL::setup_table('tables', $fields, $indexes);
     return $text;
 }

 /**
  * create tables for referrals
  *
  * @see agents/referrals_hook.php
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['url'] = "TEXT NOT NULL";
     $fields['referer'] = "TEXT NOT NULL";
     $fields['domain'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['keywords'] = "VARCHAR(255) DEFAULT ''";
     $fields['hits'] = "INT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['stamp'] = "DATETIME";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX url'] = "(url(255))";
     $indexes['INDEX referer'] = "(referer(255))";
     $indexes['INDEX domain'] = "(domain)";
     $indexes['INDEX keywords'] = "(keywords)";
     $indexes['INDEX hits'] = "(hits)";
     $indexes['INDEX stamp'] = "(stamp)";
     return SQL::setup_table('referrals', $fields, $indexes);
 }

 /**
  * create table for notifications
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['recipient'] = "MEDIUMINT NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $fields['data'] = "TEXT";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX recipient'] = "(recipient)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     return SQL::setup_table('notifications', $fields, $indexes);
 }

 /**
  * create tables for members
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['anchor'] = "VARCHAR(64) NOT NULL";
     $fields['member'] = "VARCHAR(64) NOT NULL";
     $fields['member_type'] = "VARCHAR(64) NOT NULL";
     $fields['member_id'] = "VARCHAR(64) NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX member'] = "(member)";
     $indexes['INDEX member_type'] = "(member_type)";
     $indexes['INDEX member_id'] = "(member_id)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     return SQL::setup_table('members', $fields, $indexes);
 }

 /**
  * create tables for the cache
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     // up to 255 chars
     $fields['text'] = "MEDIUMTEXT NOT NULL";
     // up to 16M chars
     $fields['topic'] = "VARCHAR(64) DEFAULT '' NOT NULL";
     // up to 64 chars
     $fields['edit_date'] = "DATETIME";
     // modification date
     $fields['expiry_date'] = "DATETIME";
     // expiry date
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX topic'] = "(topic)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX expiry_date'] = "(expiry_date)";
     return SQL::setup_table('cache', $fields, $indexes);
 }

 /**
  * create table for visits
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['active'] = "ENUM('Y','R','N') DEFAULT 'Y' NOT NULL";
     // Yes, Restricted or No
     $fields['anchor'] = "VARCHAR(64) NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $fields['user_id'] = "MEDIUMINT UNSIGNED";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX active'] = "(active)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX user_id'] = "(user_id)";
     return SQL::setup_table('visits', $fields, $indexes);
 }

 /**
  * create table for categories
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['active'] = "ENUM('Y','R','N') DEFAULT 'Y' NOT NULL";
     $fields['active_set'] = "ENUM('Y','R','N') DEFAULT 'Y' NOT NULL";
     $fields['anchor'] = "VARCHAR(64)";
     $fields['articles_layout'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['background_color'] = "VARCHAR(64) DEFAULT '' NOT NULL";
     $fields['categories_count'] = "INT UNSIGNED NOT NULL";
     $fields['categories_layout'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['categories_overlay'] = "VARCHAR(64) DEFAULT '' NOT NULL";
     $fields['create_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['create_date'] = "DATETIME";
     $fields['create_id'] = "MEDIUMINT UNSIGNED DEFAULT 1 NOT NULL";
     $fields['create_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['description'] = "TEXT NOT NULL";
     $fields['display'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['edit_action'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $fields['edit_id'] = "MEDIUMINT UNSIGNED DEFAULT 1 NOT NULL";
     $fields['edit_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['expiry_date'] = "DATETIME";
     $fields['extra'] = "TEXT NOT NULL";
     $fields['hits'] = "INT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['icon_url'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['introduction'] = "TEXT NOT NULL";
     $fields['keywords'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['nick_name'] = "VARCHAR(64) DEFAULT '' NOT NULL";
     $fields['options'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['overlay'] = "TEXT NOT NULL";
     $fields['overlay_id'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['owner_id'] = "MEDIUMINT UNSIGNED DEFAULT 0 NOT NULL";
     $fields['path'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['prefix'] = "TEXT NOT NULL";
     $fields['rank'] = "MEDIUMINT UNSIGNED DEFAULT 10000 NOT NULL";
     $fields['sections_layout'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['suffix'] = "TEXT NOT NULL";
     $fields['thumbnail_url'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['title'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['trailer'] = "TEXT NOT NULL";
     $fields['users_layout'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $indexes = array();
     $indexes['PRIMARY KEY id'] = "(id)";
     $indexes['INDEX active'] = "(active)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX create_date'] = "(create_date)";
     $indexes['INDEX create_id'] = "(create_id)";
     $indexes['INDEX display'] = "(display)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     $indexes['INDEX edit_id'] = "(edit_id)";
     $indexes['INDEX expiry_date'] = "(expiry_date)";
     $indexes['INDEX hits'] = "(hits)";
     $indexes['INDEX keywords'] = "(keywords(255))";
     $indexes['INDEX nick_name'] = "(nick_name)";
     $indexes['INDEX path'] = "(path(255))";
     $indexes['INDEX rank'] = "(rank)";
     $indexes['INDEX title'] = "(title(255))";
     $indexes['FULLTEXT INDEX'] = "full_text(title, introduction, description, keywords)";
     return SQL::setup_table('categories', $fields, $indexes);
 }

 /**
  * create table for js_css
  * to count js and css files calls over time
  *
  * @see control/setup.php
  */
 public static function setup()
 {
     $fields = array();
     $fields['id'] = "VARCHAR(32) NOT NULL";
     $fields['path'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['calls'] = "MEDIUMINT UNSIGNED DEFAULT 1 NOT NULL";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     return SQL::setup_table('js_css_calls', $fields, $indexes);
 }

 /**
  * create tables for versions
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     $fields['anchor'] = "VARCHAR(64) NOT NULL";
     $fields['content'] = "MEDIUMTEXT NOT NULL";
     $fields['edit_address'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $fields['edit_date'] = "DATETIME";
     $fields['edit_id'] = "MEDIUMINT DEFAULT 0 NOT NULL";
     $fields['edit_name'] = "VARCHAR(128) DEFAULT '' NOT NULL";
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX anchor'] = "(anchor)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     return SQL::setup_table('versions', $fields, $indexes);
 }

 /**
  * create tables for queued messages
  */
 public static function setup()
 {
     global $context;
     $fields = array();
     $fields['id'] = "MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT";
     // up to 16m items
     $fields['edit_date'] = "DATETIME";
     $fields['headers'] = "TEXT NOT NULL";
     // up to 64k chars
     $fields['message'] = "MEDIUMTEXT NOT NULL";
     // up to 16M chars
     $fields['recipient'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     $fields['subject'] = "VARCHAR(255) DEFAULT '' NOT NULL";
     // up to 255 chars
     $indexes = array();
     $indexes['PRIMARY KEY'] = "(id)";
     $indexes['INDEX edit_date'] = "(edit_date)";
     return SQL::setup_table('messages', $fields, $indexes);
 }