summaryrefslogtreecommitdiff
path: root/db/laconica_pg.sql
AgeCommit message (Collapse)Author
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