summaryrefslogtreecommitdiff
path: root/util/dump.sql
AgeCommit message (Expand)AuthorFilesLines
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel1-789/+0
2010-01-01SQL: Revision insertion abstraction for release entriesYorhel1-1/+1
2009-12-28SQL: Fixed bug in producer_relgraph_notify()Yorhel1-5/+2
2009-12-05SQL: Removed changes.causedbyYorhel1-3/+1
2009-12-05SQL: Call update_vncache() in a triggerYorhel1-1/+16
2009-12-05SQL: Don't allow argument of update_vncache() to be 0Yorhel1-18/+11
2009-12-05SQL: Removed the use of CONSTRAINT TRIGGERsYorhel1-30/+34
2009-11-29SQL: Replace index on tags_vn_inherit (tag) with an index on (tag,vid)Yorhel1-2/+2
2009-11-29Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debugYorhel1-60/+0
2009-11-29SQL: Rewrote tag_vn_calc() to use a WITH RECURSIVE .. SELECT queryYorhel1-32/+27
2009-11-27Changed VN score on tags pages to display plain averagesYorhel1-12/+8
2009-11-15SQL: Improved performance of update_vnpopularity()Yorhel1-1/+1
2009-11-14SQL: Allow NULL for vn.c_popularityYorhel1-2/+2
2009-11-14SQL: Cached bayesian VN rating and vote countsYorhel1-11/+3
2009-11-14Added bayesian rating and vote count to the VN listYorhel1-0/+10
2009-11-14Added wikipedia links for producersYorhel1-1/+2
2009-11-14SQL/L10N: Allow NULL for releases_rev.minage and make the values translatableYorhel1-1/+1
2009-11-02SQL: Fixed another bug with the tags_vn_bayesian.spoiler calculationYorhel1-1/+1
2009-10-24Removed update_rev() function and monthly revcache cronYorhel1-25/+0
2009-10-24Added Spawned <> Originated from producer relationYorhel1-1/+1
2009-10-21SQL: Send relgraph notify when needed for producer entriesYorhel1-0/+30
2009-10-21Added relation graphs for producersYorhel1-1/+3
2009-10-21SQL: Renamed vn_graphs to relgraphs and synced dbgraph.plYorhel1-11/+7
2009-10-21SQL: Synced update_2.8.sql into dump.sqlYorhel1-5/+18
2009-10-18SQL: Fixed calculation of tags_vn_bayesian.spoilerYorhel1-1/+1
2009-10-17SQL: Converted releases_rev.type to an ENUM data typeYorhel1-4/+5
2009-10-12SQL: Converted changes.type to an ENUMYorhel1-4/+5
2009-10-10Display number of unread posts in user menuYorhel1-0/+1
2009-10-09Added producer role (developer/publisher) to DB and release editorYorhel1-0/+3
2009-10-09SQL: Converted releases_media.medium to an ENUM typeYorhel1-2/+3
2009-10-08Synchronised and updated dump.sql and dbgraph.plYorhel1-17/+14
2009-09-18Fixed bug with excluding AVG(vote) < 0 VNs from tag pagesYorhel1-2/+3
2009-08-12Added global user votes ignore listYorhel1-2/+7
2009-08-12Synchronised a NOT NULL constraint in dump.sql with the actual DBYorhel1-1/+1
2009-08-09Converted changes.added to timestamptzYorhel1-3/+3
2009-08-08Converted tags.added to timestamptzYorhel1-1/+1
2009-08-08Converted users.registered to timestamptzYorhel1-1/+1
2009-08-08Converted votes.date to timestamptz and use NOW() as defaultYorhel1-1/+1
2009-08-08Converted threads_posts.date and edited to timestamptzYorhel1-2/+2
2009-08-08Converted wlists.added and rlists.added to timestamptzYorhel1-2/+2
2009-08-08Convert old category relations to tags and remove vn_categoriesYorhel1-9/+0
2009-08-06Use timestamptz data type instead of timestampYorhel1-2/+2
2009-08-05Multi::IRC: Reimplemented notifications using PgSQL LISTEN/NOTIFYYorhel1-0/+19
2009-07-31Use bytea data type to store session tokensYorhel1-1/+1
2009-07-30Fixed syntax error in update_2.6.sql and removed leading spaces in dump.sqlYorhel1-2/+2
2009-07-30Merge branch 'auth' of git://3decibels.net/vndb into betaYorhel1-1/+11
2009-07-29Changed sessions.expiration column to timestamp3dB1-2/+2
2009-07-28Multiple bugfixes to authorization system & sql tweaks3dB1-1/+11
2009-07-23Implemented relgraph notify from PgSQL triggerYorhel1-0/+36
2009-07-19Removed DEFERRED property on most foreign key constraintsYorhel1-43/+41