uninstall.sql

来自「售票网站系统」· SQL 代码 · 共 47 行

/* - uninstall.sql for hbpc_shop
**
**  Unloads tables created by the Wizard for the hbpc_shop store
*/

/* drop existing tables: */
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_promo_cross') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_promo_cross 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_promo_price') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_promo_price 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_dept_prod') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_dept_prod 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_dept') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_dept 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_single_val_attr') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_single_val_attr 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_multi_val_attr') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_multi_val_attr 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_variant') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_variant 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_product') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_product 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_receipt') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_receipt 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_receipt_item') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_receipt_item 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_basket') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_basket 
GO
if exists (SELECT * FROM sysobjects WHERE id = object_id('hbpc_shop_shopper') and sysstat & 0xf = 3)
    DROP TABLE hbpc_shop_shopper 
GO