summaryrefslogtreecommitdiff
path: root/schema.sql
Commit message (Collapse)AuthorAgeFilesLines
* Add article summary page.Matthias Andreas Benkard2011-03-141-0/+15
|
* Database schema: Add STABLE and IMMUTABLE qualifiers to function definitions ↵Matthias Andreas Benkard2011-03-131-6/+6
| | | | as appropriate.
* Database schema: Stylistic changes.Matthias Andreas Benkard2011-03-131-3/+3
|
* Make the database schema slightly more portable.Matthias Andreas Benkard2011-03-131-20/+25
|
* Reduce the number of roundtrips needed for archive page creation.Matthias Andreas Benkard2011-03-131-0/+22
|
* Reduce the number of database roundtrips necessary for displaying the ↵Matthias Andreas Benkard2011-03-111-3/+38
| | | | journal archive page.
* Add a PL/pgSQL equivalent of FIND-ARTICLE-REVISIONS.Matthias Andreas Benkard2011-03-111-0/+70
|
* Support article categories.Matthias Andreas Benkard2011-03-031-0/+21
|
* Database schema: Add more metadata to users.Matthias Andreas Benkard2011-03-021-4/+6
|
* Database schema: Add more metadata to comments.Matthias Andreas Benkard2011-03-021-10/+13
|
* Database schema: Improve column naming.Matthias Andreas Benkard2011-03-021-5/+5
|
* Database schema: Add missing primary key constraints.Matthias Andreas Benkard2011-03-021-2/+7
|
* Database schema: Add a global_id column to the article_revisions table in ↵Matthias Andreas Benkard2011-03-021-1/+3
| | | | order to simplify data migration.
* Add comment support to article template, add support for multiple page ↵Matthias Andreas Benkard2011-03-021-4/+15
| | | | templates.
* Normalize the database schema.Matthias Andreas Benkard2011-03-011-20/+11
|
* Add remark about the possible use of enum types in PostgreSQL 9.1.Matthias Andreas Benkard2011-03-011-0/+13
|
* Add database schema.Matthias Andreas Benkard2011-03-011-0/+119