summaryrefslogtreecommitdiff
path: root/util/dbdump.pl
AgeCommit message (Expand)AuthorFilesLines
2024-03-28!BREAKING! Restructure directory layout for generated & runtime filesYorhel1-5/+6
2024-03-21dbdump: Fix image export scriptYorhel1-3/+3
2024-03-20Add support for account soft-deletion and email opt-out listYorhel1-56/+72
2024-01-08Add some SQL comments to the database dumpsYorhel1-0/+14
2023-09-15SQL/quotes: Add "approved" flag and improve randomisationYorhel1-1/+1
2023-05-03SQL: Rename columns that are SQL keywordsYorhel1-3/+3
2023-03-05dbdump.pl: Warn instead of error on (un)link failure in export-imgYorhel1-8/+7
2023-03-04dbdump.pl: Support dumping from a standby server + cleanup output dirYorhel1-6/+20
2022-10-31dbdump.pl: Improve performance of dumping ulist_vnsYorhel1-9/+40
2022-10-31SQL: Merge ulist_vns_labels into ulist_vns as array + cache private flagYorhel1-13/+10
2022-09-28WIP add language-specific titles to releasesYorhel1-1/+1
2022-08-25Staff editionsYorhel1-1/+3
2022-04-29SQL: Move utility functions to separate util.sqlYorhel1-1/+2
2022-03-29VN length voting: support private votesYorhel1-2/+2
2022-02-08VN: Add support for multiple titles in different languagesYorhel1-0/+1
2021-08-10Fix daily database dumpsYorhel1-2/+3
2021-08-03VNLengthVote: Add vote listing + aggregated stats + make publicYorhel1-1/+4
2021-05-21Tags/Traits: Add main/primary flag to parents listYorhel1-2/+2
2021-03-24Fix database exportYorhel1-1/+1
2021-03-23Traits: Convert to vndbids + add edit historyYorhel1-6/+6
2021-03-11Tags: Convert to vndbids + add edit historiesYorhel1-9/+7
2021-03-01SQL: vndbid data type conversion for most DB entriesYorhel1-2/+2
2021-02-24dbdump.pl: Add export-data command to dump everythingYorhel1-2/+51
2020-12-29DB dumps: also export the quotes tableYorhel1-0/+1
2020-04-05SQL: Add C-based "vndbid" type and use it for image IDsYorhel1-5/+10
2020-03-19dbdump/imgflag: Make sure to include users who voted on imagesYorhel1-1/+2
2020-03-16imgflag: Initial schema + UI for image flaggingYorhel1-3/+2
2020-03-12SQL: Use global "images" table for metadata of all images in the DBYorhel1-4/+7
2020-02-21SQL: Allow tags_vn.uid to be NULL for deleted usersYorhel1-1/+1
2019-12-24ulist: Export new lists in dbdump.pl, unexport old listsYorhel1-23/+30
2019-12-08dbdump.pl: Do an explicit rollback before disconnecting the DBYorhel1-0/+1
2019-12-07dbdump.pl: Ensure consistent exportsYorhel1-1/+2
2019-10-03SQL: Get rid of the users_prefs table, store preferences in users tableYorhel1-7/+6
2019-09-17Rename VNDBSchema to VNDB::Schema and let it figure out the root path itselfYorhel1-4/+4
2019-08-21dbdump.pl: Make sure to include chars_vns relations with rid = NULLYorhel1-1/+1
2019-08-15Minor util/sql/ reorganization + Make devdump more robustYorhel1-1/+1
2019-08-09Replace Wikipedia links with Wikidata IDsYorhel1-0/+4
2019-08-03dbdump.pl: Change export-img to maintain a hardlink dir insteadYorhel1-26/+38
2019-07-25dbdump.pl: Be more silentYorhel1-2/+2
2019-07-22dbdump.pl: Actually include import.sql in the db dumpsYorhel1-1/+1
2019-07-22Move votes/traits/tags exports to dbdump.pl; Get rid of Multi::APIDumpYorhel1-0/+82
2019-07-21Add (fullish) database dumpsYorhel1-0/+251