1 Star 0 Fork 0

DataManagement / Relation-autotuning

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
drop_cons.sql 763 Bytes
一键复制 编辑 原始数据 按行查看 历史
Whn 提交于 2019-09-30 19:36 . First commit
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
ALTER TABLE district DROP FOREIGN KEY fkey_district_1;
ALTER TABLE customer DROP FOREIGN KEY fkey_customer_1;
ALTER TABLE history DROP FOREIGN KEY fkey_history_1;
ALTER TABLE history DROP FOREIGN KEY fkey_history_2;
ALTER TABLE new_orders DROP FOREIGN KEY fkey_new_orders_1;
ALTER TABLE orders DROP FOREIGN KEY fkey_orders_1;
ALTER TABLE order_line DROP FOREIGN KEY fkey_order_line_1;
ALTER TABLE order_line DROP FOREIGN KEY fkey_order_line_2;
ALTER TABLE stock DROP FOREIGN KEY fkey_stock_1;
ALTER TABLE stock DROP FOREIGN KEY fkey_stock_2;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
1
https://gitee.com/HITMassiveData/Relation-autotuning.git
git@gitee.com:HITMassiveData/Relation-autotuning.git
HITMassiveData
Relation-autotuning
Relation-autotuning
master

搜索帮助