注册和登录模块

if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_BoardAdmin_RegLogin_Board]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_BoardAdmin] DROP CONSTRAINT FK_RegLogin_BoardAdmin_RegLogin_Board GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Topic_RegLogin_Board]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Topic] DROP CONSTRAINT FK_RegLogin_Topic_RegLogin_Board GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Board_RegLogin_Category]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Board] DROP CONSTRAINT FK_RegLogin_Board_RegLogin_Category GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_BoardAdmin_RegLogin_RegUser]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_BoardAdmin] DROP CONSTRAINT FK_RegLogin_BoardAdmin_RegLogin_RegUser GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Favorite_RegLogin_RegUser]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Favorite] DROP CONSTRAINT FK_RegLogin_Favorite_RegLogin_RegUser GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Mail_RegLogin_RegUser]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Mail] DROP CONSTRAINT FK_RegLogin_Mail_RegLogin_RegUser GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Reply_RegLogin_RegUser]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Reply] DROP CONSTRAINT FK_RegLogin_Reply_RegLogin_RegUser GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Topic_RegLogin_RegUser]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Topic] DROP CONSTRAINT FK_RegLogin_Topic_RegLogin_RegUser GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Favorite_RegLogin_Topic]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Favorite] DROP CONSTRAINT FK_RegLogin_Favorite_RegLogin_Topic GO if exists (select * from sysobjects where id = object_id(N'[FK_RegLogin_Reply_RegLogin_Topic]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [RegLogin_Reply] DROP CONSTRAINT FK_RegLogin_Reply_RegLogin_Topic GO if exists (select * from sysobjects where id = object_id(N'[TRIG_LWordInserted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_LWordInserted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_LWordDeleted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_LWordDeleted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_MailReceived_deleted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_MailReceived_deleted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_ReplyInserted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_ReplyInserted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_ReplyDeleted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_ReplyDeleted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_TopicInserted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_TopicInserted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_TopicDeleted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_TopicDeleted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_TopicUpdate]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_TopicUpdate] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_UpFileInserted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_UpFileInserted] GO if exists (select * from sysobjects where id = object_id(N'[TRIG_UpFileDeleted]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [TRIG_UpFileDeleted]�