46 lines
2.1 KiB
MySQL
46 lines
2.1 KiB
MySQL
|
use vn;
|
||
|
|
-- Auto-generated SQL script. Actual values for binary/complex data types may differ - what you see is the default string representation of values.
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=1 AND effectived='2014-01-01' AND taxCodeFk=108;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=2 AND effectived='2014-01-01' AND taxCodeFk=108;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=3 AND effectived='2014-01-01' AND taxCodeFk=108;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=5 AND effectived='2014-01-01' AND taxCodeFk=108;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=3 AND effectived='2016-01-01' AND taxCodeFk=109;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=5 AND effectived='2016-01-01' AND taxCodeFk=109;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=1 AND effectived='2019-01-01' AND taxCodeFk=122;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=2 AND effectived='2019-01-01' AND taxCodeFk=122;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=3 AND effectived='2019-01-01' AND taxCodeFk=122;
|
||
|
|
DELETE FROM vn.taxClassCode
|
||
|
|
WHERE taxClassFk=5 AND effectived='2019-01-01' AND taxCodeFk=122;
|
||
|
|
-- Auto-generated SQL script. Actual values for binary/complex data types may differ - what you see is the default string representation of values.
|
||
|
|
DELETE FROM vn.taxCode
|
||
|
|
WHERE id=108;
|
||
|
|
DELETE FROM vn.taxCode
|
||
|
|
WHERE id=109;
|
||
|
|
DELETE FROM vn.taxCode
|
||
|
|
WHERE id=110;
|
||
|
|
DELETE FROM vn.taxCode
|
||
|
|
WHERE id=122;
|
||
|
|
-- Auto-generated SQL script. Actual values for binary/complex data types may differ - what you see is the default string representation of values.
|
||
|
|
DELETE FROM vn.bookingPlanner
|
||
|
|
WHERE countryFk = 30;
|
||
|
|
|
||
|
|
DELETE FROM vn.botanicExport where restriction = 'Importacion Prohibida';
|
||
|
|
|
||
|
|
DELETE FROM vn.itemTaxCountry WHERE countryFk = 30;
|
||
|
|
DELETE FROM vn.botanicExport WHERE countryFk = 30;
|
||
|
|
UPDATE vn.client SET countryFk = 1 WHERE countryFk = 30;
|
||
|
|
UPDATE vn.supplier SET countryFk = 1 WHERE countryFk = 30;
|
||
|
|
UPDATE province SET countryFk = 1 WHERE countryFk = 30;
|
||
|
|
UPDATE autonomy SET countryFk = 1 WHERE countryFk = 30;
|
||
|
|
DELETE FROM vn.taxCode WHERE taxTypeFk = 24;
|
||
|
|
DELETE FROM vn.taxClassCode WHERE taxCodeFk IN (108, 109,110,122);
|
||
|
|
DELETE FROM vn.country WHERE code = 'EX';
|