数据库脚本.sql

广州收费标准自动化测试程序

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DecToHex]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[DecToHex]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HexToBin]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[HexToBin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HexToDec]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[HexToDec]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ReturnVaues]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[ReturnVaues]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddCompany]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AddCompany]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddUserInfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AddUserInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Add_Bm]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Add_Bm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ConsumeTotal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ConsumeTotal]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Del_Bm]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Del_Bm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InSertDoorTimeDetail]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InSertDoorTimeDetail]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_SaveArrangeWork]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_SaveArrangeWork]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_SetWorkTime]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_SetWorkTime]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_Statistical]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_Statistical]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_Statistical_test]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_Statistical_test]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_UserTJ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_UserTJ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_UserTJKQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_UserTJKQ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_UserTJKQ_1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_UserTJKQ_1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_UserTJKQ_new]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_UserTJKQ_new]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_UserTotalReport]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_UserTotalReport]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_UserTotalReport1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[KQ_UserTotalReport1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_AddRecordData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_AddRecordData]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_IcIssue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_IcIssue]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_Init]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_Init]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_KQInit]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_KQInit]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_LostCard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_LostCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_SaveUserTimeGroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_SaveUserTimeGroup]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[M_SysSetup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[M_SysSetup]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Park_Init]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Park_Init]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PatrolCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PatrolCount]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[QuitICCard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[QuitICCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[S_IcIssue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[S_IcIssue]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sf_Init]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Sf_Init]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_CardIssue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[T_CardIssue]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ComeGoRecord]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[T_ComeGoRecord]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Z_LostCard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Z_LostCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Z_SysSetup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Z_SysSetup]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pSf_ConsumeTotal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[pSf_ConsumeTotal]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[psf_Issue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[psf_Issue]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tAutoWriteCarGo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tAutoWriteCarGo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindCarRecordDay]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindCarRecordDay]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindCarRecordPig]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindCarRecordPig]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindDayReport]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindDayReport]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindDayReportPig]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindDayReportPig]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindMonthReport]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindMonthReport]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindMonthReportPig]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindMonthReportPig]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindYearReport]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindYearReport]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tFindYearReportPig]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tFindYearReportPig]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tGetDateFile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tGetDateFile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tGetSumYear]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tGetSumYear]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tWriteCarGo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tWriteCarGo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tWriteCarGo_tw]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tWriteCarGo_tw]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tWriteStore]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[tWriteStore]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_CountMoney_BJ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[t_CountMoney_BJ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_Countmoney_GZ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[t_Countmoney_GZ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_szCharge]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[t_szCharge]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[z_Init]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[z_Init]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[z_QuitCard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[z_QuitCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[z_SignQuitCard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[z_SignQuitCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddERR]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AddERR]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v_FxCard]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v_FxCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v_FxUser]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v_FxUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v_LostCard]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v_LostCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Account]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Account]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AlarmTimeGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AlarmTimeGroup]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BaseInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BaseInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CardInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CardInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CompanyName]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CompanyName]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Dept]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DoorInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DoorInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DoorRight]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DoorRight]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DoorTimeGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DoorTimeGroup]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Door_Elec_Pic_Total]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Door_Elec_Pic_Total]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExitCard]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ExitCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FX_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FX_User]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Gzerr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Gzerr]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HourMoney]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[HourMoney]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ICLost]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ICLost]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQMachno]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KQMachno]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_ArrangeWork]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KQ_ArrangeWork]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KQ_Leave]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KQ_Leave]
GO