/[drupal]/contributions/modules/troll/troll.install
ViewVC logotype

Diff of /contributions/modules/troll/troll.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.2.2.1, Tue Apr 8 16:32:54 2008 UTC revision 1.2.2.1.2.1, Sun Mar 1 03:24:10 2009 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: troll.install,v 1.4 2008/04/02 16:26:44 jaydub Exp $  // $Id: troll.install,v 1.2.2.1 2008/04/08 16:32:54 jaydub Exp $
3    
4  /**  /**
5   * Implementation of hook_install().   * Implementation of hook_install().
# Line 17  function troll_install() { Line 17  function troll_install() {
17    
18        db_query("CREATE TABLE {troll_ip_ban} (        db_query("CREATE TABLE {troll_ip_ban} (
19            iid int(11) NOT NULL auto_increment,            iid int(11) NOT NULL auto_increment,
20            ip_address varchar(30) NOT NULL default '',            ip_address varchar(39) NOT NULL default '',
21            domain_name varchar(255) NOT NULL default '',            domain_name varchar(255) NOT NULL default '',
22            expires int(11) unsigned NOT NULL default '0',            expires int(11) unsigned NOT NULL default '0',
23            created int(11) unsigned NOT NULL default '0',            created int(11) unsigned NOT NULL default '0',
# Line 30  function troll_install() { Line 30  function troll_install() {
30        db_query("CREATE TABLE {troll_ip_track} (        db_query("CREATE TABLE {troll_ip_track} (
31            uid int(11) NOT NULL default '0',            uid int(11) NOT NULL default '0',
32            accessed int(11) unsigned NOT NULL default '0',            accessed int(11) unsigned NOT NULL default '0',
33            ip_address varchar(20) NOT NULL default '',            ip_address varchar(39) NOT NULL default '',
34            created int(11) NOT NULL default '0',            created int(11) NOT NULL default '0',
35            KEY uid (uid)            KEY uid (uid)
36          ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */"          ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */"
# Line 56  function troll_install() { Line 56  function troll_install() {
56    
57        db_query("CREATE TABLE {troll_ip_ban} (        db_query("CREATE TABLE {troll_ip_ban} (
58            iid serial,            iid serial,
59            ip_address varchar(30) NOT NULL default '',            ip_address varchar(39) NOT NULL default '',
60            domain_name varchar(255) NOT NULL default '',            domain_name varchar(255) NOT NULL default '',
61            expires integer NOT NULL default '0',            expires integer NOT NULL default '0',
62            created integer NOT NULL default '0',            created integer NOT NULL default '0',
# Line 69  function troll_install() { Line 69  function troll_install() {
69        db_query("CREATE TABLE {troll_ip_track} (        db_query("CREATE TABLE {troll_ip_track} (
70            uid integer NOT NULL default '0',            uid integer NOT NULL default '0',
71            accessed integer NOT NULL default '0',            accessed integer NOT NULL default '0',
72            ip_address varchar(20) NOT NULL default '',            ip_address varchar(39) NOT NULL default '',
73            created integer NOT NULL default '0',            created integer NOT NULL default '0',
74            PRIMARY KEY (uid)            PRIMARY KEY (uid)
75          )"          )"
# Line 141  function troll_update_2() { Line 141  function troll_update_2() {
141  }  }
142    
143  /**  /**
144     * Support IPv6 address lengths.
145     *
146     * @return array
147     */
148    function troll_update_5000() {
149      $ret = array();
150      $ret[] = update_sql("ALTER TABLE {troll_ip_ban} CHANGE ip_address ip_address VARCHAR(39) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
151      $ret[] = update_sql("ALTER TABLE {troll_ip_track} CHANGE ip_address ip_address VARCHAR(39) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
152      return $ret;
153    }
154    
155    /**
156   * Implmentation of hook_uninstall().   * Implmentation of hook_uninstall().
157   */   */
158  function troll_uninstall() {  function troll_uninstall() {
Legend:
Removed from v.1.2.2.1  
changed lines
  Added in v.1.2.2.1.2.1
  ViewVC Help
Powered by ViewVC 1.1.2