install/schemas/upgrade/1.1.2-1.1.3-mysql.sql
author Dan
Sun, 28 Mar 2010 23:10:46 -0400
changeset 1227 bdac73ed481e
parent 468 194a19711346
permissions -rw-r--r--
Going ahead with the switch to tabs. This is a major coding standards change! If any unusual parser bugs show up, check this changeset. Converted all .php, .js, .tpl, .css, and .json files and did basic testing.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
436
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     1
-- Enano CMS
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     2
-- Upgrade schema: 1.1.2 - 1.1.3
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     3
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     4
-- Storing obscenely huge integers as strings since that's how php processes them.
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     5
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     6
CREATE TABLE {{TABLE_PREFIX}}diffiehellman (
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     7
  key_id int(12) NOT NULL auto_increment,
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     8
  private_key text,
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
     9
  public_key text,
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
    10
  PRIMARY KEY ( key_id )
242353360e37 Added support for Diffie-Hellman key exchange during login. w00t!
Dan
parents:
diff changeset
    11
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
468
194a19711346 Fixed the fact that cron just didn't work at all (brain fart that day or something)
Dan
parents: 436
diff changeset
    12
194a19711346 Fixed the fact that cron just didn't work at all (brain fart that day or something)
Dan
parents: 436
diff changeset
    13
ALTER TABLE {{TABLE_PREFIX}}session_keys MODIFY COLUMN source_ip varchar(39) NOT NULL DEFAULT '127.0.0.1';
194a19711346 Fixed the fact that cron just didn't work at all (brain fart that day or something)
Dan
parents: 436
diff changeset
    14
ALTER TABLE {{TABLE_PREFIX}}themes MODIFY COLUMN group_policy ENUM('allow_all', 'whitelist', 'blacklist') NOT NULL DEFAULT 'allow_all';
194a19711346 Fixed the fact that cron just didn't work at all (brain fart that day or something)
Dan
parents: 436
diff changeset
    15
UPDATE {{TABLE_PREFIX}}themes SET group_policy = 'allow_all';