summaryrefslogtreecommitdiff
path: root/util/sql
AgeCommit message (Expand)AuthorFilesLines
2010-11-14SQL: Removed CREATE LANGUAGE plpgsqlYorhel1-3/+0
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-12/+12
2010-11-14SQL: Added WHEN clause to all TRIGGERs for which it was usefulYorhel2-152/+144
2010-11-14Improved performance of update_vnpopularity() on PostgreSQL 9.0Yorhel1-1/+3
2010-11-10Multi::RG: Use dotted line to indicate unofficial status in VN relationsYorhel1-1/+1
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel2-2/+3
2010-11-06Synchronised sql/schema.sql with the actual DBYorhel1-1/+2
2010-03-13Improved VN searchYorhel2-0/+49
2010-02-05Merge branch 'master' into betaYorhel1-2/+2
2010-02-05Notifications: Added 'announce' notificationYorhel3-2/+24
2010-02-05Notifications: Added 'dbedit' notificationYorhel3-4/+44
2010-02-04Notifications: Added notify for deletion of entries in (wish)listYorhel2-3/+38
2010-02-02SQL: Converted language columns to an ENUM typeYorhel3-5/+6
2010-02-02SQL: Improved query in edit_commit()Yorhel1-6/+4
2010-02-01Added notification for database deletions to users who contributedYorhel2-0/+36
2010-02-01SQL: Renamed the hidlock_update trigger namesYorhel1-3/+3
2010-02-01Cache the title and userid of the notificationsYorhel2-3/+6
2010-01-29SQL: Another try at fixing the tag spoiler calculationYorhel1-2/+2
2010-01-26SQL: Replaced sessions.expiration with sessions.addedYorhel1-1/+1
2010-01-26Keep track of when a session has last been usedYorhel1-0/+1
2010-01-26Made a start on the notification systemYorhel3-5/+64
2010-01-24Versioned the deleting and locking of database entriesYorhel3-11/+39
2010-01-23SQL: Don't DROP the temporary edit_* tablesYorhel1-39/+52
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel3-0/+1005