summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
AgeCommit message (Expand)AuthorFilesLines
2020-04-04SQL reorg: Move util/sql/ to sql/ as a top-level dirYorhel1-983/+0
2020-04-02Increase max release title length to 300Yorhel1-2/+2
2020-03-26imgflag: Keep track of users.c_imgvotes + limit number of votes + adjust samp...Yorhel1-1/+2
2020-03-23ExtLinks: A few more shop links for releasesYorhel1-2/+10
2020-03-16imgflag: Initial schema + UI for image flaggingYorhel1-3/+18
2020-03-12SQL: Keep track of dimensions for all images in the DBYorhel1-2/+2
2020-03-12SQL: Use global "images" table for metadata of all images in the DBYorhel1-13/+17
2020-02-23dbdump: Add vn.c_popularity, c_rating and c_votecount to the dumpsYorhel1-3/+3
2020-02-21SQL: Allow tags_vn.uid to be NULL for deleted usersYorhel1-3/+2
2020-02-09Tagmod: Add "notes" field to tag voting thingYorhel1-0/+1
2020-02-06Cache Markdown-to-HTML in the database for doc pagesYorhel1-2/+4
2020-01-04ulist: Add ability to save views as defaultYorhel1-1/+4
2019-12-30Merge branch 'ulist'Yorhel1-32/+37
2019-12-30ulist: Remove remnants of old votes/vnlists/wlists tablesYorhel1-28/+0
2019-12-24ulist: Export new lists in dbdump.pl, unexport old listsYorhel1-16/+16
2019-12-22ulist: Update "My lists" VN filters to use new ulists featureYorhel1-1/+1
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 statsYorhel1-1/+3
2019-12-16ulist: Integrate update script into SQL + update notify_listdel()Yorhel1-0/+31
2019-12-01v2rw: Convert thread display + poll votingYorhel1-2/+2
2019-11-08Wikidata: Add support for doujinshi.org 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 settingsYorhel1-1/+10
2019-10-07SQL: Adjust tag_vn_inherit and trait_chars calculationsYorhel1-3/+1
2019-10-03Require email confirmation when changing email addressYorhel1-1/+2
2019-10-03SQL: Add session types + use sessions for password reset tokensYorhel1-4/+4
2019-10-03SQL: Change sessions.lastused into sessions.expiresYorhel1-4/+4
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 tableYorhel1-21/+28
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-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 ErogeTrailers.com links to releasesYorhel1-2/+4
2019-09-01Add EGS links to releasesYorhel1-2/+4
2019-08-26Display shop+price info on VN pages + delete old affiliate codeYorhel1-14/+0
2019-08-25Add PlayAsia shop crawlerYorhel1-0/+15
2019-08-25Add DLsite price & shop info crawlerYorhel1-0/+9
2019-08-24Add DenpaSoft price info crawlerYorhel1-0/+9
2019-08-24Add MangaGamer price info crawlerYorhel1-0/+9
2019-08-24Add J-List price info crawlerYorhel1-0/+9
2019-08-22Add JAST USA links to releasesYorhel1-2/+4
2019-08-21Add Itch.io links to releasesYorhel1-2/+4