index
:
vndb
fran
master
Source code of VNDB.org
Yorhel
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
util
/
dump.sql
Age
Commit message (
Expand
)
Author
Files
Lines
2010-01-09
SQL: Split dump.sql into several files and merged update_2.10.sql
Yorhel
1
-789
/
+0
2010-01-01
SQL: Revision insertion abstraction for release entries
Yorhel
1
-1
/
+1
2009-12-28
SQL: Fixed bug in producer_relgraph_notify()
Yorhel
1
-5
/
+2
2009-12-05
SQL: Removed changes.causedby
Yorhel
1
-3
/
+1
2009-12-05
SQL: Call update_vncache() in a trigger
Yorhel
1
-1
/
+16
2009-12-05
SQL: Don't allow argument of update_vncache() to be 0
Yorhel
1
-18
/
+11
2009-12-05
SQL: Removed the use of CONSTRAINT TRIGGERs
Yorhel
1
-30
/
+34
2009-11-29
SQL: Replace index on tags_vn_inherit (tag) with an index on (tag,vid)
Yorhel
1
-2
/
+2
2009-11-29
Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debug
Yorhel
1
-60
/
+0
2009-11-29
SQL: Rewrote tag_vn_calc() to use a WITH RECURSIVE .. SELECT query
Yorhel
1
-32
/
+27
2009-11-27
Changed VN score on tags pages to display plain averages
Yorhel
1
-12
/
+8
2009-11-15
SQL: Improved performance of update_vnpopularity()
Yorhel
1
-1
/
+1
2009-11-14
SQL: Allow NULL for vn.c_popularity
Yorhel
1
-2
/
+2
2009-11-14
SQL: Cached bayesian VN rating and vote counts
Yorhel
1
-11
/
+3
2009-11-14
Added bayesian rating and vote count to the VN list
Yorhel
1
-0
/
+10
2009-11-14
Added wikipedia links for producers
Yorhel
1
-1
/
+2
2009-11-14
SQL/L10N: Allow NULL for releases_rev.minage and make the values translatable
Yorhel
1
-1
/
+1
2009-11-02
SQL: Fixed another bug with the tags_vn_bayesian.spoiler calculation
Yorhel
1
-1
/
+1
2009-10-24
Removed update_rev() function and monthly revcache cron
Yorhel
1
-25
/
+0
2009-10-24
Added Spawned <> Originated from producer relation
Yorhel
1
-1
/
+1
2009-10-21
SQL: Send relgraph notify when needed for producer entries
Yorhel
1
-0
/
+30
2009-10-21
Added relation graphs for producers
Yorhel
1
-1
/
+3
2009-10-21
SQL: Renamed vn_graphs to relgraphs and synced dbgraph.pl
Yorhel
1
-11
/
+7
2009-10-21
SQL: Synced update_2.8.sql into dump.sql
Yorhel
1
-5
/
+18
2009-10-18
SQL: Fixed calculation of tags_vn_bayesian.spoiler
Yorhel
1
-1
/
+1
2009-10-17
SQL: Converted releases_rev.type to an ENUM data type
Yorhel
1
-4
/
+5
2009-10-12
SQL: Converted changes.type to an ENUM
Yorhel
1
-4
/
+5
2009-10-10
Display number of unread posts in user menu
Yorhel
1
-0
/
+1
2009-10-09
Added producer role (developer/publisher) to DB and release editor
Yorhel
1
-0
/
+3
2009-10-09
SQL: Converted releases_media.medium to an ENUM type
Yorhel
1
-2
/
+3
2009-10-08
Synchronised and updated dump.sql and dbgraph.pl
Yorhel
1
-17
/
+14
2009-09-18
Fixed bug with excluding AVG(vote) < 0 VNs from tag pages
Yorhel
1
-2
/
+3
2009-08-12
Added global user votes ignore list
Yorhel
1
-2
/
+7
2009-08-12
Synchronised a NOT NULL constraint in dump.sql with the actual DB
Yorhel
1
-1
/
+1
2009-08-09
Converted changes.added to timestamptz
Yorhel
1
-3
/
+3
2009-08-08
Converted tags.added to timestamptz
Yorhel
1
-1
/
+1
2009-08-08
Converted users.registered to timestamptz
Yorhel
1
-1
/
+1
2009-08-08
Converted votes.date to timestamptz and use NOW() as default
Yorhel
1
-1
/
+1
2009-08-08
Converted threads_posts.date and edited to timestamptz
Yorhel
1
-2
/
+2
2009-08-08
Converted wlists.added and rlists.added to timestamptz
Yorhel
1
-2
/
+2
2009-08-08
Convert old category relations to tags and remove vn_categories
Yorhel
1
-9
/
+0
2009-08-06
Use timestamptz data type instead of timestamp
Yorhel
1
-2
/
+2
2009-08-05
Multi::IRC: Reimplemented notifications using PgSQL LISTEN/NOTIFY
Yorhel
1
-0
/
+19
2009-07-31
Use bytea data type to store session tokens
Yorhel
1
-1
/
+1
2009-07-30
Fixed syntax error in update_2.6.sql and removed leading spaces in dump.sql
Yorhel
1
-2
/
+2
2009-07-30
Merge branch 'auth' of git://3decibels.net/vndb into beta
Yorhel
1
-1
/
+11
2009-07-29
Changed sessions.expiration column to timestamp
3dB
1
-2
/
+2
2009-07-28
Multiple bugfixes to authorization system & sql tweaks
3dB
1
-1
/
+11
2009-07-23
Implemented relgraph notify from PgSQL trigger
Yorhel
1
-0
/
+36
2009-07-19
Removed DEFERRED property on most foreign key constraints
Yorhel
1
-43
/
+41
[next]