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-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
2009-05-22
Voiced field for releases
Yorhel
1
-1
/
+2
2009-05-22
Added resolution field to release entries
Yorhel
1
-1
/
+2
2009-05-09
Don't consider VNs with AVG(vote) < 0 on tag pages
Yorhel
1
-2
/
+2
2009-03-28
Fixed and re-organized tag<->vn calculation
Yorhel
1
-37
/
+33
2009-03-22
Fixed tiny SQL bug
Yorhel
1
-1
/
+1
2009-03-22
Merge branch 'tagging' into beta
Yorhel
1
-5
/
+174
2009-03-22
Incorporated update_2.3.sql into dump.sql and updated the dbgrapher script
Yorhel
1
-5
/
+174
2009-02-21
Aliases field to producer entries
Yorhel
1
-1
/
+2
2009-02-12
Catalog number field to release entries
Yorhel
1
-1
/
+2
2009-01-25
Random quote feature
Yorhel
1
-0
/
+10
2009-01-10
Limit account creation to one account a day per IP
Yorhel
1
-1
/
+2
2009-01-10
Added VN popularity ranking
Yorhel
1
-1
/
+14
2009-01-04
Added patch flag to releases
Yorhel
1
-2
/
+4
2008-12-23
Fixed syntax error in dump.sql
Yorhel
1
-2
/
+2
2008-12-23
Added skin selector to profile page
Yorhel
1
-0
/
+1
2008-12-11
2 Bugfixes with user registration
Yorhel
1
-1
/
+1
2008-11-29
Caching the global database statistics
Yorhel
1
-6
/
+74
2008-11-11
Removed users.flags and used two boolean columns instead
Yorhel
1
-0
/
+2
2008-11-11
Cached each users change and vote counts in the users table
Yorhel
1
-1
/
+29
2008-10-18
Added original title field to VN entries
yorhel
1
-0
/
+1
2008-08-27
Added release link to screenshots
yorhel
1
-0
/
+2
2008-08-20
Fixed error when creating a new thread, changed type of threads_posts.num to ...
yorhel
1
-1
/
+2
2008-08-20
Another internal database change: changes.causedby accepts NULL values and pr...
yorhel
1
-1
/
+2
[next]