diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql b/gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql new file mode 100644 index 0000000..1dfe419 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql @@ -0,0 +1,8 @@ +UPDATE gentoobrowse.packages p SET + name = ?, + categoryid = cn.categoryid +FROM gentoobrowse.categories co, gentoobrowse.categories cn +WHERE p.name = ? +AND p.categoryid = co.categoryid +AND co.name = ? +AND cn.name = ? |