1
0

002_AssetStore.sql 419 B

12345678910
  1. BEGIN TRANSACTION;
  2. CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
  3. INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
  4. DROP TABLE assets;
  5. CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data);
  6. INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
  7. DROP TABLE assets_backup;
  8. COMMIT;