summaryrefslogtreecommitdiff
path: root/schema.sql
Commit message (Collapse)AuthorAgeFilesLines
* Add support for explicit journal keeping in the database.Matthias Andreas Benkard2018-05-271-0/+16
|
* Database schema: Add function do_full_text_search and a couple of full-text ↵Matthias Andreas Benkard2011-03-221-0/+48
| | | | search indices.
* Completely rethink the way articles are retrieved from the database based on ↵Matthias Andreas Benkard2011-03-191-48/+26
| | | | the requested characteristics.
* Add a database-backed page caching mechanism.Matthias Andreas Benkard2011-03-151-0/+8
|
* Database schema: Fix column order.Matthias Andreas Benkard2011-03-151-2/+2
|
* Fix the database schema and make it compatible with PostgreSQL 8.4.Matthias Andreas Benkard2011-03-151-13/+8
|
* Optionally use Hashcash for comment verification.Matthias Andreas Benkard2011-03-151-0/+5
|
* 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