diff options
| author | Sunil Shetye | 2024-04-05 19:49:30 +0530 |
|---|---|---|
| committer | Sunil Shetye | 2024-04-05 19:49:30 +0530 |
| commit | 20d338a073cff64e04abdd7665fd4f2ad0b16798 (patch) | |
| tree | 42341c2493a970028a2407d65206197d648063ce | |
| parent | ed21b15269be998b7a4a17b38b0ff96974d19161 (diff) | |
| download | Common-Interface-Project-20d338a073cff64e04abdd7665fd4f2ad0b16798.tar.gz Common-Interface-Project-20d338a073cff64e04abdd7665fd4f2ad0b16798.tar.bz2 Common-Interface-Project-20d338a073cff64e04abdd7665fd4f2ad0b16798.zip | |
truncate table and remove the ignore clause
| -rw-r--r-- | data/refactorold.sql | 8 |
1 files 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 |