Skip to content

Instantly share code, notes, and snippets.

@lockefox

lockefox/ship_package_volume.sql

Created August 11, 2015 21:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lockefox/1c70b7de00567b131598 to your computer and use it in GitHub Desktop.
Save lockefox/1c70b7de00567b131598 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ship_package_volume.sql
UPDATE invTypes SET volume=500 WHERE groupID in (29,1022,31);
UPDATE invTypes SET volume=1000 WHERE groupID in (448,12,649,952,340);
UPDATE invTypes SET volume=2500 WHERE groupID in (324,830,893,25,831,237,834);
UPDATE invTypes SET volume=3750 WHERE groupID in (543,463);
UPDATE invTypes SET volume=5000 WHERE groupID in (420,541,963);
UPDATE invTypes SET volume=10000 WHERE groupID in (906,358,833,894,832,26);
UPDATE invTypes SET volume=15000 WHERE groupID in (1201,419,540);
UPDATE invTypes SET volume=50000 WHERE groupID in (27,898,381,941,900);
UPDATE invTypes SET volume=20000 WHERE groupID in (1202,380,28);
UPDATE invTypes SET volume=1000000 WHERE groupID in (883,547,485,513,902,659);
UPDATE invTypes SET volume=10000000 WHERE groupID = 30;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment