RESETTER DB

resetterdb.sql

SELECT * FROm tr_salesorderdetail;
SELECT * FROM tr_salesorderdetailmenu;


SELECT * FROM tr_productionprocesshead;
SELECT * FROM tr_productionprocessdetail;
SELECT * FROM tr_productionprocessformula;

SELECT * FROM tr_stockrequisitionhead;
SELECT * FROM tr_stockrequisitiondetail;
SELECT * FROM tr_picking;

SELECT * FROM tr_finishing;
SELECT * FROM tr_packing;

SELECT * FROM tr_goodstransferhead;
SELECT * FROM tr_goodstransferdetail;

SELECT * FROM tr_logistic;


SELECT * FROM tr_stockcard;

SELECT * FROM tr_logistic;


UPDATE tr_goodstransferhead SET receivedBy = NULL, receivedDate = NULL;












-- TRUNCATE tr_salesorderdetail;
-- TRUNCATE tr_salesorderdetailmenu;


TRUNCATE tr_productionprocesshead;
TRUNCATE tr_productionprocessdetail;
TRUNCATE tr_productionprocessformula;

TRUNCATE tr_stockrequisitionhead;
TRUNCATE tr_stockrequisitiondetail;

TRUNCATE tr_finishing;
TRUNCATE tr_packing;

TRUNCATE tr_goodstransferhead;
TRUNCATE tr_goodstransferdetail;

TRUNCATE tr_stockcard;

TRUNCATE tr_logistic;

-- RESET SCHEDULE
UPDATE tr_productionprocesshead SET productionScheduleDate = NULL, productionScheduleBy = NULL, productionPic = NULL;
TRUNCATE tr_finishing;
TRUNCATE tr_stockrequisitionhead;
TRUNCATE tr_stockrequisitiondetail;
TRUNCATE tr_productionprocessformula;