index
:
vndb
fran
master
Source code of VNDB.org
Yorhel
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
util
/
sql
/
schema.sql
Age
Commit message (
Expand
)
Author
Files
Lines
2015-01-28
sql: Merge staff changes into /util/sql/ and rename staff.sql
2.24
Yorhel
1
-0
/
+58
2014-12-02
Completely drop l_vnn column from VN info
Yorhel
1
-1
/
+0
2014-10-15
Use scrypt for new password hashes
Yorhel
1
-1
/
+7
2014-10-15
SQL: Merge users.(passwd|salt) in one column + document values
Yorhel
1
-1
/
+9
2014-10-13
SQL: Use enum to represent platforms
Yorhel
1
-2
/
+2
2014-10-11
SQL: Convert login_throttle.timeout to a timestamptz
Yorhel
1
-1
/
+1
2014-08-29
Throttle failed login attempts (10/day)
Yorhel
1
-0
/
+6
2013-01-05
Screenshot uploader: Load stuff synchronously + removed processing flag
Yorhel
1
-1
/
+0
2012-06-05
schema.sql: Fix order of some columns + remove useless DEFAULT NULL
Yorhel
1
-4
/
+4
2012-06-04
schema.sql: Fix creation of anime table
Yorhel
1
-2
/
+2
2012-01-07
SQL: Added two indices
Yorhel
1
-0
/
+2
2011-08-23
Added email confirmation to registration process
Yorhel
1
-1
/
+2
2011-04-30
Replaced user ranks with a permission system
Yorhel
1
-1
/
+1
2011-04-29
affiliates: +data column, hide hidden links, better browser, Multi fixes
Yorhel
1
-1
/
+2
2011-04-09
affiliates: Added very basic support for sponsored "buy now" links
Yorhel
1
-0
/
+15
2011-03-19
chardb: Synchronized DB changes with util/sql/* and dbgraph.pl
Yorhel
1
-2
/
+95
2011-02-13
chardb: Added notes file and started implementing the traits
Yorhel
1
-1
/
+1
2011-02-04
Added category field to tags (content/ero/technical)
Yorhel
1
-1
/
+2
2011-01-03
SQL: Added tags_vn.ignore column and updated queries to respect this
Yorhel
1
-0
/
+1
2011-01-02
Bugfix: allow a VN to be available for more than 7 platforms
Yorhel
1
-1
/
+1
2010-12-23
Converted the notify_announce and notify_dbedit preferences
Yorhel
1
-3
/
+1
2010-12-23
Converted the show_list pref. to users_prefs and inverted the value
Yorhel
1
-1
/
+0
2010-12-23
Converted the show_nsfw preference to use the users_prefs table
Yorhel
1
-1
/
+0
2010-12-23
Added users_prefs table and removed users.(skin|customcss)
Yorhel
1
-2
/
+9
2010-12-21
Added notes field to the user VN list
Yorhel
1
-0
/
+1
2010-12-19
SQL: Synchronised the current index definitions with schema.sql
Yorhel
1
-0
/
+5
2010-12-19
RFC-01: Code/DB cleanup and renamed some stuff for consistency
Yorhel
1
-2
/
+1
2010-12-18
RFC-01: Implemented (most) of the SQL part
Yorhel
1
-0
/
+12
2010-12-10
Keep track of last modification date for tag<->vn links
Yorhel
1
-0
/
+1
2010-11-28
VN Filter Selector: Added "original language" filter
Yorhel
1
-1
/
+2
2010-11-14
SQL: Added ON DELETE clause to all foreign keys referencing users (id)
Yorhel
1
-12
/
+12
2010-11-10
Started on adding an "official" flag to vn<->vn relations
Yorhel
1
-0
/
+1
2010-11-06
Synchronised sql/schema.sql with the actual DB
Yorhel
1
-1
/
+2
2010-02-05
Notifications: Added 'announce' notification
Yorhel
1
-1
/
+2
2010-02-05
Notifications: Added 'dbedit' notification
Yorhel
1
-1
/
+2
2010-02-02
SQL: Converted language columns to an ENUM type
Yorhel
1
-3
/
+3
2010-02-01
Cache the title and userid of the notifications
Yorhel
1
-1
/
+4
2010-01-26
SQL: Replaced sessions.expiration with sessions.added
Yorhel
1
-1
/
+1
2010-01-26
Keep track of when a session has last been used
Yorhel
1
-0
/
+1
2010-01-26
Made a start on the notification system
Yorhel
1
-3
/
+15
2010-01-24
Versioned the deleting and locking of database entries
Yorhel
1
-1
/
+3
2010-01-09
SQL: Split dump.sql into several files and merged update_2.10.sql
Yorhel
1
-0
/
+388