install/schemas/upgrade/1.1.2-1.1.3-postgresql.sql
author Dan
Fri, 17 Jul 2009 20:48:53 -0400
changeset 1068 4bcefa85649c
parent 624 e9c04ed3290f
permissions -rw-r--r--
Editor: completely moved wiki edit notice to AJAX fetch, so it's not shipped with the page anymore.
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