summaryrefslogtreecommitdiff
path: root/db/laconica_pg.sql
AgeCommit message (Collapse)Author
2009-07-28Splitting br3nda's merge 97db6e17b3f76e9a6acf87ddbad47ba54e9b1a3bEric Helgeson
Add session table to pg.sql
2009-07-27pgsql's install had windows newlines. ran db/laconica_pg.sqlEric Helgeson
Thanks grim26
2009-07-22moved design table earlier - needs to be before "user" becuase of the ↵Brenda Wallace
foreign key
2009-07-22more changes to file_id copied from mysql schema change in ↵Brenda Wallace
05e51228020fecaa894523b5159bc412d48e5b19
2009-07-22fixes file_redirection table to match mysql schema change in commit ↵Brenda Wallace
05e51228020fecaa894523b5159bc412d48e5b19
2009-07-22Fixes file_oembed to march mysql schema change that happened in commit ↵Brenda Wallace
05e51228020fecaa894523b5159bc412d48e5b19
2009-07-22added missing columns in file tableBrenda Wallace
2009-07-22Fixed "User" table - added design_id and viewdesignsBrenda Wallace
2009-07-19Merge commit 'br3nda/0.8.x-pginstaller' into 0.8.xCiaranG
2009-07-17postgres schema - removed not null constraint from nonce.tok, and copied the ↵Brenda Wallace
comment from the mysql schema
2009-07-15moved creation of design table earlier than user_groupBrenda Wallace
2009-07-15added design_id to user_groupBrenda Wallace
2009-07-15added group_block and group_alias tablesBrenda Wallace
2009-07-15added missing conversation id to noticesBrenda Wallace
Conflicts: db/laconica_pg.sql
2009-07-15removed semicolons from commentsBrenda Wallace
(mucks up logic in install.php) and fixed stray commas that stopped it parsing as valid SQL
2009-06-25added missing table "design"Brenda Wallace
2009-06-25added missing conversation id to noticesBrenda Wallace
2009-06-25removed semicolons from commentsBrenda Wallace
(mucks up logic in install.php) and fixed stray commas that stopped it parsing as valid SQL
2009-05-15Added sql files to handle attachments (not yet tested) Hoping someone will ↵Robin Millette
improve the postgres version.
2009-05-08PostgreSQL - added dirty dates to Foreign_link - see ↵CiaranG
3e7b1e69e3e97ac007465376b62084f10bcf97ca
2009-03-08PostgreSQL - use the specific sequence names required by DB_DataObject, ↵CiaranG
otherwise rebuilding can't work
2009-03-07PostgreSQL - propogated nonce table fix from MySQL version - see bug #1251 ↵CiaranG
or 1179ecd13d68e76d74ad94e2d3ca22d9681eeffe
2009-03-05PostgreSQL - the ts field in the OAuth nonce table needed to be an integer. ↵CiaranG
(fix submitted by oxygene)
2009-03-04PostgreSQL - added defaults for 'created' fields, so they work the same as ↵CiaranG
the MySQL version, and made sure all 'modified' fields are not null
2009-03-03PostgreSQL - added new emailnotifyattn field to user table, to match MySQL ↵CiaranG
version
2009-02-05PostgreSQL - database creation script updated to cover 0.7.x featuresCiaranG
2009-01-30PostgreSQL - remaining changes to fix db create script up to laconica 0.6.4 ↵Ciaran Gultnieks
level
2009-01-14PostgreSQL - added the rest of the recently added tables for blocking, ↵CiaranG
notice inboxes, etc. Needs testing
2009-01-14Some more PostgreSQL script updates - some recently added fields were missingCiaranG
2009-01-14Added the inboxed field to the user table for PostgreSQL - resolves bug #892CiaranG
2008-11-15Nudge featurecsarven
darcs-hash:20081116022735-eefa4-366f6deb85942f859ebd532e477b57737bcafbf8.gz
2008-11-13trac31 pg support, fixing 2tu typo, set ur1.ca as default servicemillette
darcs-hash:20081113152718-099f7-42b60d02395f016c54c5f3c301f9dbe987c1283f.gz
2008-09-29PostgreSQL: Put a default on confirm_address.address_extra to mimic mysql's ↵CiaranG
behaviour when a not-null field is not set in a new record darcs-hash:20080929060227-f6e2c-5996ad74cb5c89052417e36634a22b6e219bd92d.gz
2008-09-24PostgreSQL: Corrections to the two new table definitionsCiaranG
darcs-hash:20080924113550-f6e2c-8791d68684424ef028049ee9ed95b3853dd8f770.gz
2008-09-23PostgreSQL: New tables for private messages and invitations (untested)CiaranG
darcs-hash:20080923214601-f6e2c-350de6e8df8bb6e9e5f3dbb1ea43360fc55ee847.gz
2008-09-14PostgreSQL: support for full text searching (notice and people)CiaranG
darcs-hash:20080914201744-f6e2c-71b2a3aec4c0b91557465323d79645e7eab2bfd1.gz
2008-09-10PostgreSQL - reply.modified needs a defaultCiaranG
darcs-hash:20080910073741-f6e2c-fe856e1acbc14f77e8ad6502cf5e16de768e0e5f.gz
2008-09-09Initial support for PostgreSQLCiaranG
darcs-hash:20080909072224-f6e2c-881bd2e7fb032f336fecae9ca5ce527dd821d3dc.gz