path: root/util/sql
AgeCommit message (Expand)AuthorFilesLines
2016-12-01SQL: Fix adding vndb_multi role and grant on rlistsYorhel2-1/+4
2016-11-27SQL: Use separate role for Multi2.26Yorhel2-2/+69
2016-11-27SQL: Use separate role for the website + disallow access to user dataYorhel5-4/+206
2016-08-09Add Croatian languageYorhel1-1/+1
2016-07-31SQL: Improve trait cache update from 206 to 16 secondsYorhel2-4/+6
2016-07-31Add Thai languageYorhel1-1/+1
2016-07-03Generalize substring search relevance + apply to most dropdown searchesYorhel1-0/+15
2016-02-15Add Tagalog languageYorhel1-1/+1
2015-11-11Misc poll improvementsYorhel2-25/+24
2015-11-10Merge branch 'master' into pollmorkt5-817/+717
2015-11-01Removed support for sha256-hashed passwordsYorhel1-3/+0
2015-10-25Staff: Add error msg when removing used alias + fix bug in alias editingYorhel1-2/+2
2015-10-24SQL: Throwing around some indicesYorhel1-2/+8
2015-10-24Improve several discussion board SQL queriesYorhel2-1/+11
2015-10-21SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcsYorhel5-585/+253
2015-10-18discussion board polls.morkt1-0/+24
2015-10-17SQL: Fix all browsing queries to use the new schemaYorhel1-0/+1
2015-10-17SQL: Convert all item-tables to a different schemaYorhel2-235/+453
2015-10-12Notifications: Allow max 500 notifies per user + add SQL index on uidYorhel1-0/+1
2015-10-12SQL: Split constraints/indices/triggers in new file + use idempotent SQLYorhel5-179/+172
2015-10-11SQL: Convert producers_rev.type into enumYorhel2-1/+2
2015-09-07Handler::Discussions: Use ts_headline() to format search resultsYorhel1-1/+7
2015-09-07Implement discussion board search functionYorhel2-0/+10
2015-09-06SQL: Convert threads_board.type to ENUMYorhel2-1/+2
2015-08-08Hide sexual traits by default + Add profile option to change defaultYorhel1-1/+1
2015-07-21Add profile option for the default spoiler settingYorhel1-1/+1
2015-07-21Add profile option for default visible tag categories on VN pagesYorhel1-1/+1
2015-07-21Add profile option to show or summarize tags on VN pages by defaultYorhel1-1/+1
2015-05-13Add staff statistic to main menuYorhel1-0/+3
2015-05-13Change order of staff rolesYorhel1-1/+1
2015-05-11New language: Catalan (/Valencian)Yorhel1-1/+1
2015-05-11Three new platforms: FM Towns, PC Engine, X68000Yorhel1-1/+1
2015-01-29staff: Added 'scenario' credit typeYorhel1-1/+1
2015-01-28sql: Merge staff changes into /util/sql/ and rename staff.sql2.24Yorhel3-69/+64
2015-01-28Merge branch 'staff' into masterYorhel1-1/+1
2015-01-17staff: Fix search to ignore spaces in Japanese namesmorkt1-0/+1
2015-01-12staff: Add notifications for staff edits/deletesYorhel2-2/+12
2015-01-12staff: Remove some remnants of the staff imagesYorhel2-4/+3
2015-01-04staff: Add some link fields and guidelinesmorkt2-4/+7
2015-01-02staff: Fix deleting of staff + use JSON to pass data + minor fixesmorkt1-0/+2
2014-12-28More progress on the staff + cast DBmorkt2-9/+12
2014-12-24Further progress on the staff databasemorkt1-1/+2
2014-12-22Initial implementation of a staff/seiyuu databasemorkt2-2/+111
2014-12-02Completely drop l_vnn column from VN infoYorhel2-3/+2
2014-10-15Use scrypt for new password hashesYorhel1-1/+7
2014-10-15SQL: Merge users.(passwd|salt) in one column + document valuesYorhel1-1/+9
2014-10-13SQL: Use enum to represent platformsYorhel3-4/+6
2014-10-11SQL: Convert login_throttle.timeout to a timestamptzYorhel1-1/+1
2014-09-15Change normalization factor in popularity ranking calculationYorhel1-1/+1
2014-08-29Throttle failed login attempts (10/day)Yorhel1-0/+6