scanapp_delete_transaction_data.sql 856 B

12345678910111213141516171819
  1. delete from scanapp_useractivity where 1;
  2. delete from scanapp_recycledmaterial where 1;
  3. delete from scanapp_statisticsindex where 1;
  4. delete from scanapp_popupuser where 1;
  5. delete from scanapp_bulkrecycling where 1;
  6. delete from scanapp_ean_code where 1;
  7. delete from scanapp_userbadge where 1;
  8. delete from scanapp_ranking where 1;
  9. delete from scanapp_userstatistics where 1;
  10. delete from scanapp_bom where 1;
  11. delete from scanapp_product where 1;
  12. delete from auth_user where ( username <> "admin" and username <> "test150" );
  13. delete from account_emailaddress where (email <> "test150@test.com" );
  14. delete from authtoken_token where 1;
  15. delete from django_session where 1;
  16. delete from scanapp_popupuserhistory where 1;
  17. delete from scanapp_alluserstatisticsindex where 1;
  18. delete from scanapp_pushsubscription where 1;
  19. delete from scanapp_alluserstatistics where 1;