path: root/util/sql
AgeCommit message (Expand)AuthorFilesLines
2019-12-30Minor refactor: Move all trigger functions and declarations to separate fileYorhel4-330/+346
2019-12-30Merge branch 'ulist'Yorhel4-111/+171
2019-12-30ulist: Remove remnants of old votes/vnlists/wlists tablesYorhel3-42/+0
2019-12-27ulists: Update devdump.plYorhel1-13/+13
2019-12-24ulist: Export new lists in, unexport old listsYorhel1-16/+16
2019-12-22ulist: Update "My lists" VN filters to use new ulists featureYorhel1-1/+1
2019-12-22ulist: Use new lists for VN vote stats & listingYorhel1-0/+2
2019-12-20ulist: Remove deprecated hide_list user preferenceYorhel1-1/+1
2019-12-20Keep track of poll vote datesYorhel1-0/+1
2019-12-19ulist: Update user list with vnlist/votes/wishlist statsYorhel4-16/+29
2019-12-17ulist: Synchronize changes between rlists and ulist_vnsYorhel2-32/+28
2019-12-16ulist: Convert vn.c_* vote stat updating to use ulist_vns tableYorhel1-13/+29
2019-12-16ulist: Integrate update script into SQL + update notify_listdel()Yorhel4-7/+82
2019-12-01v2rw: Convert thread display + poll votingYorhel1-2/+2
2019-11-10ulist: Add data model for new lists + Perl/Elm for label managementYorhel1-0/+3
2019-11-08Wikidata: Add support for author linksYorhel1-1/+2
2019-11-02Add character age field + conversionYorhel1-2/+4
2019-11-02Add character cup size field + conversion + filterYorhel1-2/+5
2019-10-10rewards: Add user settingsYorhel2-5/+13
2019-10-07SQL: Improve performance of update_vnpopularity()Yorhel1-15/+12
2019-10-07SQL: Perform incremental updates on traits_chars when characters are editedYorhel1-8/+20
2019-10-07SQL: Perform incremental updates on tags_vn_inherit when tags are modifiedYorhel1-9/+19
2019-10-07SQL: Adjust tag_vn_inherit and trait_chars calculationsYorhel4-53/+44
2019-10-03Disallow changing email address to one already used by another accountYorhel1-2/+2
2019-10-03Require email confirmation when changing email addressYorhel2-7/+26
2019-10-03SQL: Add session types + use sessions for password reset tokensYorhel2-22/+29
2019-10-03SQL: Change sessions.lastused into sessions.expiresYorhel3-13/+10
2019-10-03Fix spoilers preference to be a smallint rather than booleanYorhel1-1/+1
2019-10-03SQL: Get rid of the users_prefs table, store preferences in users tableYorhel5-36/+38
2019-09-27Add Malay languageYorhel1-1/+1
2019-09-24Add language: Scottish GaelicYorhel1-1/+1
2019-09-23Add 4 new languagesYorhel1-1/+1
2019-09-17Rename VNDBSchema to VNDB::Schema and let it figure out the root path itselfYorhel1-1/+1
2019-09-17Don't send db edit notifications for changes made by MultiYorhel1-0/+1
2019-09-14SQL: Replace "shop_*.found" with "deadsince" timestampYorhel1-4/+4
2019-09-03Add Pixiv ID to staff entriesYorhel1-2/+4
2019-09-03Fetch some more IDs from Wikidata + display IGDB & Pixiv linksYorhel1-1/+8
2019-09-02Minor cleanup of l_wp/l_encubed link codeYorhel1-4/+4
2019-09-02Allow multiple Gyutto & DMM links per releaseYorhel1-4/+4
2019-09-01Add links to releasesYorhel1-2/+4
2019-09-01Add EGS links to releasesYorhel1-2/+4
2019-08-30SQL: Remove remnants of old affiliate_links tableYorhel1-2/+0
2019-08-26Display shop+price info on VN pages + delete old affiliate codeYorhel2-16/+0
2019-08-26Display PlayAsia links on release pages + use crawled info to correct shop linksYorhel1-0/+5
2019-08-25Add PlayAsia shop crawlerYorhel3-0/+18
2019-08-25Add DLsite price & shop info crawlerYorhel2-0/+10
2019-08-24Add DenpaSoft price info crawlerYorhel2-0/+10
2019-08-24Add MangaGamer price info crawlerYorhel2-0/+10
2019-08-24Add J-List price info crawlerYorhel2-0/+10
2019-08-22Add JAST USA links to releasesYorhel1-2/+4