mysql.sql

来自「采用模块化开发」· SQL 代码 · 共 12 行

DELETE FROM `phpcms_module` WHERE `module`='yp';
DROP TABLE IF EXISTS `phpcms_member_company`;
DROP TABLE IF EXISTS `phpcms_yp_apply`;
DROP TABLE IF EXISTS `phpcms_yp_article`;
DROP TABLE IF EXISTS `phpcms_yp_guestbook`;
DROP TABLE IF EXISTS `phpcms_yp_job`;
DROP TABLE IF EXISTS `phpcms_yp_product`;
DROP TABLE IF EXISTS `phpcms_yp_buy`;
DROP TABLE IF EXISTS `phpcms_yp_sales`;
DROP TABLE IF EXISTS `phpcms_yp_stock`;
DELETE FROM `phpcms_menu` WHERE name='我的简历';
DELETE FROM `phpcms_channel` WHERE `channelname`='企业黄页';