install/schemas/upgrade/1.1.2-1.1.3-postgresql.sql
author Dan
Sat, 08 Nov 2008 22:36:28 -0500
changeset 726 17e8c93b4729
parent 624 e9c04ed3290f
permissions -rw-r--r--
Upgraded jQuery UI.
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}}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
    14
624
e9c04ed3290f Fixed bad ALTER command in PostgreSQL 1.1.2 -> 1.1.3 upgrade
Dan
parents: 468
diff changeset
    15
ALTER TABLE {{TABLE_PREFIX}}session_keys ALTER COLUMN source_ip TYPE varchar(39),
e9c04ed3290f Fixed bad ALTER command in PostgreSQL 1.1.2 -> 1.1.3 upgrade
Dan
parents: 468
diff changeset
    16
                                         ADD CHECK ( source_ip IS NOT NULL ),
e9c04ed3290f Fixed bad ALTER command in PostgreSQL 1.1.2 -> 1.1.3 upgrade
Dan
parents: 468
diff changeset
    17
                                         ALTER COLUMN source_ip SET DEFAULT '127.0.0.1';
e9c04ed3290f Fixed bad ALTER command in PostgreSQL 1.1.2 -> 1.1.3 upgrade
Dan
parents: 468
diff changeset
    18