currently, seed_market.sql has multiple versions of market seeding methods in same file, along with a ton of notes and db update command.
these should be cleaned up, separated and named accordingly.
the command at the end of the file is a db update to consolidate missing data from the static dump.
it is in that file for reasons i fail to remember at this time, but it shouldnt be.
there is a "db_updates" file somewhere for items like that.
upon further review, all files in the sql/optional/ directory need review/update/removal.
some are just notes, others are in limbo (not used at this time), while others are just outdated.
currently,
seed_market.sql
has multiple versions of market seeding methods in same file, along with a ton of notes and db update command. these should be cleaned up, separated and named accordingly.the command at the end of the file is a db update to consolidate missing data from the static dump. it is in that file for reasons i fail to remember at this time, but it shouldnt be. there is a "db_updates" file somewhere for items like that.
upon further review, all files in the sql/optional/ directory need review/update/removal. some are just notes, others are in limbo (not used at this time), while others are just outdated.