index
:
vndb
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
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
2009-07-19
Notify Multi::Image via PostgreSQL for new screenshots
Yorhel
1
-0
/
+12
2009-07-19
Converted and renamed screenshots.status (int) to processed (bool)
Yorhel
1
-1
/
+1
2009-07-18
Notify Multi::Image for new cover images via LISTEN/NOTIFY
Yorhel
1
-0
/
+13
2009-07-18
Use PostgreSQL's LISTEN/NOTIFY to notify Multi::Anime for new anime
Yorhel
1
-0
/
+15
2009-07-18
Automatically insert rows into anime table for new vn_anime.aid items
Yorhel
1
-0
/
+12
2009-07-18
Modified definition of the anime table
Yorhel
1
-7
/
+7
2009-07-14
Removed old and unused table/column definitions from dump.sql
Yorhel
1
-11
/
+0
2009-07-08
Keep track of users who requested tags
Yorhel
1
-1
/
+3
2009-07-04
Implemented support for multilingual releases
Yorhel
1
-4
/
+12
2009-05-23
Animation fields for releases
Yorhel
1
-1
/
+3
2009-05-23
Added freeware and doujin information to releases
Yorhel
1
-1
/
+3
[next]