dbunit-clean.sql

来自「anewssystem新闻发布系统集成使用了spring hibernate f」· SQL 代码 · 共 14 行

delete from a_news_newstag;
delete from a_news;
update a_news_category set parent_id=null;
delete from a_news_category;

delete from A_SECURITY_ROLE_USER;
delete from A_SECURITY_MENU_ROLE;
delete from A_SECURITY_RESOURCE_ROLE;
update A_SECURITY_MENU set parent_id=null;
delete from A_SECURITY_MENU;
delete from A_SECURITY_USER;
update A_SECURITY_DEPT set parent_id=null;
delete from A_SECURITY_DEPT;