install/schemas/upgrade/1.1.2-1.1.3-postgresql.sql
author Dan
Mon, 16 Feb 2009 16:17:25 -0500
changeset 832 7152ca0a0ce9
parent 624 e9c04ed3290f
permissions -rw-r--r--
Major redesign of rendering pipeline that separates pages saved with MCE from pages saved with the plaintext editor (full description in long commit message) - Pages are now stored with an extra metadata field called page_format which is "wikitext" or "xhtml" - New $flags parameter + RENDER_* constants added that control RenderMan::render() behavior - Several other changes: * Added a sprite API for Javascript and made editor use sprites when possible * Removed a number of config options from the default install schema, replaced with second parameter to getConfig() calls * MessageBox in editor mostly replaced with miniPrompt * A few bugfixes related to password changes (registration didn't even work) * Rewrote the bitfield compression algorithm used to serialize allowed MIME types * Fixed some typos in language files and strings * Fixed a Text_Wiki bug in Heading parser
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