From 20d338a073cff64e04abdd7665fd4f2ad0b16798 Mon Sep 17 00:00:00 2001
From: Sunil Shetye
Date: Fri, 5 Apr 2024 19:49:30 +0530
Subject: truncate table and remove the ignore clause

---
 data/refactorold.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/data/refactorold.sql b/data/refactorold.sql
index 174f418d..77f15f48 100644
--- a/data/refactorold.sql
+++ b/data/refactorold.sql
@@ -4,11 +4,11 @@ FROM (SELECT block_id, p_order, p_value_initial FROM xcosblocks_newblockparamete
 WHERE N.block_id = xcosblocks_block.id
 AND N.p_order = 0;
 
-INSERT OR IGNORE INTO xcosblocks_blockparameter (
-    block_id, p000, p000_help, p000_type_id
-) SELECT block_id, p_label, p_help, p_type_id
+DELETE FROM xcosblocks_blockparameter;
+DELETE FROM SQLITE_SEQUENCE WHERE name = 'xcosblocks_blockparameter';
+INSERT INTO xcosblocks_blockparameter (block_id)
+SELECT DISTINCT block_id
 FROM xcosblocks_newblockparameter
-WHERE p_order = 0
 ORDER BY block_id;
 
 UPDATE xcosblocks_blockparameter
-- 
cgit