summaryrefslogtreecommitdiff
path: root/db/laconica_pg.sql
AgeCommit message (Expand)Author
2009-08-11Revert "change file.url to from a varchar(255) to varchar(2047)"Brenda Wallace
2009-08-11change file.url to from a varchar(255) to varchar(2047)Brenda Wallace
2009-08-04Splitting br3nda's merge 97db6e17b3f76e9a6acf87ddbad47ba54e9b1a3bEric Helgeson
2009-07-28Splitting br3nda's merge 97db6e17b3f76e9a6acf87ddbad47ba54e9b1a3bEric Helgeson
2009-07-27pgsql's install had windows newlines. ran db/laconica_pg.sqlEric Helgeson
2009-07-22moved design table earlier - needs to be before "user" becuase of the foreign...Brenda Wallace
2009-07-22more changes to file_id copied from mysql schema change in 05e51228020fecaa89...Brenda Wallace
2009-07-22fixes file_redirection table to match mysql schema change in commit 05e512280...Brenda Wallace
2009-07-22Fixes file_oembed to march mysql schema change that happened in commit 05e512...Brenda Wallace
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
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
2009-07-15removed semicolons from commentsBrenda Wallace
2009-06-25added missing table "design"Brenda Wallace
2009-06-25added missing conversation id to noticesBrenda Wallace
2009-06-25removed semicolons from commentsBrenda Wallace
2009-05-15Added sql files to handle attachments (not yet tested) Hoping someone will im...Robin Millette
2009-05-08PostgreSQL - added dirty dates to Foreign_link - see 3e7b1e69e3e97ac007465376...CiaranG
2009-03-08PostgreSQL - use the specific sequence names required by DB_DataObject, other...CiaranG
2009-03-07PostgreSQL - propogated nonce table fix from MySQL version - see bug #1251 or...CiaranG
2009-03-05PostgreSQL - the ts field in the OAuth nonce table needed to be an integer. (...CiaranG
2009-03-04PostgreSQL - added defaults for 'created' fields, so they work the same as th...CiaranG
2009-03-03PostgreSQL - added new emailnotifyattn field to user table, to match MySQL ve...CiaranG
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 l...Ciaran Gultnieks
2009-01-14PostgreSQL - added the rest of the recently added tables for blocking, notice...CiaranG
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
2008-11-13trac31 pg support, fixing 2tu typo, set ur1.ca as default servicemillette
2008-09-29PostgreSQL: Put a default on confirm_address.address_extra to mimic mysql's b...CiaranG
2008-09-24PostgreSQL: Corrections to the two new table definitionsCiaranG
2008-09-23PostgreSQL: New tables for private messages and invitations (untested)CiaranG
2008-09-14PostgreSQL: support for full text searching (notice and people)CiaranG
2008-09-10PostgreSQL - reply.modified needs a defaultCiaranG
2008-09-09Initial support for PostgreSQLCiaranG