install/schemas/upgrade/1.1.2-1.1.3-postgresql.sql
author Dan
Sat, 01 Mar 2008 23:02:05 -0500
changeset 471 7906fb190fc1
parent 468 194a19711346
child 624 e9c04ed3290f
permissions -rw-r--r--
Implemented all security features on theme disabling and ACLs; added clean_key mode to login API to clean unused encryption keys
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 SERIAL,
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
);
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 DROP group_policy, ADD COLUMN group_policy varchar(9) NOT NULL DEFAULT 'allow_all', ADD CHECK ( group_policy IN ('allow_all', 'whitelist', 'blacklist') );
194a19711346 Fixed the fact that cron just didn't work at all (brain fart that day or something)
Dan
parents: 436
diff changeset
    15