summaryrefslogtreecommitdiff
path: root/util/sql
AgeCommit message (Expand)AuthorFilesLines
2018-09-29Add default spoiler level to tags and use it in spoiler calculationYorhel2-11/+16
2018-09-29Add default spoiler level to traits and use it on character editYorhel1-1/+2
2018-06-03Add development DB dump, remove old devdb, convert README to markdownYorhel4-383/+24
2018-05-25Add uncensored flag to release entriesYorhel1-2/+4
2018-02-08Store d+ pages in the DB as versioned entries + use markdownYorhel5-6/+76
2018-02-04SQL: Load permissions after creating sequencesYorhel1-4/+4
2018-02-04Add "development database" for quick setup & testing purposesYorhel1-0/+314
2017-12-29SQL: Don't inherit trait/tag childs if parent is mentioned directlyYorhel1-2/+7
2017-12-29Experimenting with PostgreSQL 10: "UNENCRYPTED" keyword has been removedYorhel1-1/+1
2017-11-26Add language: Bulgarian and Platforms: Nintendo Switch & Wii UYorhel1-2/+2
2017-11-25perms.sql: Revoke all permissions before re-assigningYorhel1-0/+2
2017-08-14Remove useless NOT NULL in schema.sqlYorhel1-1/+1
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