use myDb_itSys5

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[syggVer] (
	[_id] [int] IDENTITY (1, 1) NOT NULL ,
	[_soft] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_ver] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_SupplierComp] (
	[_autoNum] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_supplier] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_Contact] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_phone] [nchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mobilePhone] [nchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fax] [nchar] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[_qq] [nchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mail] [nchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_addr] [nchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_accountNumberManage] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_accountNum] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_pass] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_backFilePath] (
	[_backFilePath] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_borrow] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_borrowDate] [datetime] NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [nchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_number] [int] NULL ,
	[_use] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_borrower] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_foreCastDate] [datetime] NULL ,
	[_returnDate] [datetime] NULL ,
	[_enterDate] [datetime] NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_enterFrom] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rejectDate] [datetime] NULL ,
	[_SN] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cardID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userNameID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_autoNumStore] [nchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_buy] (
	[_autoNum] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_buyDate] [datetime] NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_buyer] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_supplyCompany] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_price] [decimal](19, 2) NULL ,
	[_number] [int] NULL ,
	[_rejectDate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_deskPhone] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_shortTelNum] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[_longTelNum] [char] (9) COLLATE Chinese_PRC_CI_AS NULL ,
	[_telPower] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_buildingName] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_floorNum] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[_outPortNum] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[_inPortNum] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[_floorPortNum] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[_inPortNumOld] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[_floorPortNumOld] [char] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_deskPhoneInf] (
	[_deskPhoneInf] [char] (300) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fileManagePath] (
	[_path] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_filePath] (
	[_path] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_filePath_FixedAssets] (
	[_path] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fittingAdd] (
	[_id] [int] IDENTITY (1, 1) NOT NULL ,
	[_NO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_dep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_station] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fitting] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSpecifications] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_doUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_addReason] [char] (54) COLLATE Chinese_PRC_CI_AS NULL ,
	[_addDate] [datetime] NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_AutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingName] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_autoNumID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fittingReject] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[_NO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_dep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_station] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingAutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fitting] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSpecifications] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_doUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rejectReason] [char] (54) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rejectDate] [datetime] NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_AutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fittingRemove] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[_oldNO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldName] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldStation] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newNO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newName] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newStation] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldFitting] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldFittingSpecifications] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldFittingSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newFitting] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_removeReason] [char] (54) COLLATE Chinese_PRC_CI_AS NULL ,
	[_doUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_removeDate] [datetime] NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldAutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newAutoNumNew] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldFittingAutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fittingStock] (
	[_fittingID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingType] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fitting] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingRejectDate] [datetime] NULL ,
	[_fittingName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_autoNumID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fittingTakeOut] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[_NO] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_dep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_station] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingAutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fitting] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSpecifications] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_doUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_takeOutReason] [char] (54) COLLATE Chinese_PRC_CI_AS NULL ,
	[_takeOutDate] [datetime] NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_AutoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fixedAssets] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_NO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_buyDate] [datetime] NULL ,
	[_supplier] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_identificationNo] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_identificationDate] [datetime] NULL ,
	[_freeRepairationDate] [datetime] NULL ,
	[_useDate] [datetime] NULL ,
	[_useYear] [int] NULL ,
	[_rejectDate] [datetime] NULL ,
	[_useState] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[_station] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_model] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mainboardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mainboard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mainboardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuFanID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuFan] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuFanSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetFanID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetFan] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetFanSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_networkCardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_networkCard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_networkCardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_soundCardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_soundCard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_soundCardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardPort] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardVolume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_power] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerRating] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1Type] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2Type] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinet] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitor] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorSize] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorRejectDate] [datetime] NULL ,
	[_keyID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_key] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keySN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keyPort] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keyType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouseID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouse] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouseSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mousePort] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouseType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_macAddress] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[_IPAddress1] [char] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[_IPAddress2] [char] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[_accountNumber] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_safeLevel] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_HaveAttachments] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy1] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy2] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy3] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy4] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy5] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy6] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy7] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy8] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy9] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy10] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy11] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy12] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy13] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy14] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy15] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy16] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy17] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy18] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy19] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy20] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy21] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy22] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy23] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy24] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy25] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy26] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy27] [nchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy28] [nchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy29] [datetime] NULL ,
	[_zdy30] [datetime] NULL ,
	[_zdy31] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy32] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_hide] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keyRejectDate] [datetime] NULL ,
	[_mouseRejectDate] [datetime] NULL ,
	[_powerRejectDate] [datetime] NULL ,
	[_mainboardRejectDate] [datetime] NULL ,
	[_networkCardRejectDate] [datetime] NULL ,
	[_soundCardRejectDate] [datetime] NULL ,
	[_videoCardRejectDate] [datetime] NULL ,
	[_cpuRejectDate] [datetime] NULL ,
	[_disk1RejectDate] [datetime] NULL ,
	[_disk2RejectDate] [datetime] NULL ,
	[_disk3RejectDate] [datetime] NULL ,
	[_disk4RejectDate] [datetime] NULL ,
	[_memory1RejectDate] [datetime] NULL ,
	[_memory2RejectDate] [datetime] NULL ,
	[_memory3RejectDate] [datetime] NULL ,
	[_memory4RejectDate] [datetime] NULL ,
	[_rom1RejectDate] [datetime] NULL ,
	[_rom2RejectDate] [datetime] NULL ,
	[_zdy1ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy1RejectDate] [datetime] NULL ,
	[_zdy3ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy3RejectDate] [datetime] NULL ,
	[_zdy5ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy5RejectDate] [datetime] NULL ,
	[_zdy7ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy7RejectDate] [datetime] NULL ,
	[_oldPrice] [decimal](18, 0) NULL ,
	[_inputId] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fixedAssetsReject] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_NO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_buyDate] [datetime] NULL ,
	[_supplier] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_identificationNo] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_identificationDate] [datetime] NULL ,
	[_freeRepairationDate] [datetime] NULL ,
	[_useDate] [datetime] NULL ,
	[_useYear] [int] NULL ,
	[_rejectDate] [datetime] NULL ,
	[_useState] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[_station] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_model] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mainboardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mainboard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mainboardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuFanID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuFan] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cpuFanSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetFanID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetFan] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetFanSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_networkCardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_networkCard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_networkCardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_soundCardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_soundCard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_soundCardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCard] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardPort] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_videoCardVolume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_power] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_powerRating] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk1Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk2Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk3Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_disk4Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory1Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory2Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory3Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_memory4Volume] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom1Type] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2ID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2SN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2Port] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rom2Type] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinet] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cabinetSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitor] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorSize] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_monitorRejectDate] [datetime] NULL ,
	[_keyID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_key] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keySN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keyPort] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keyType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouseID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouse] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouseSN] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mousePort] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_mouseType] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_macAddress] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[_IPAddress1] [char] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[_IPAddress2] [char] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[_accountNumber] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_safeLevel] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_HaveAttachments] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy1] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy2] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy3] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy4] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy5] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy6] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy7] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy8] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy9] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy10] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy11] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy12] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy13] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy14] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy15] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy16] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy17] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy18] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy19] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy20] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy21] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy22] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy23] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy24] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy25] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy26] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy27] [nchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy28] [nchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy29] [datetime] NULL ,
	[_zdy30] [datetime] NULL ,
	[_zdy31] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy32] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_hide] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_keyRejectDate] [datetime] NULL ,
	[_mouseRejectDate] [datetime] NULL ,
	[_powerRejectDate] [datetime] NULL ,
	[_mainboardRejectDate] [datetime] NULL ,
	[_networkCardRejectDate] [datetime] NULL ,
	[_soundCardRejectDate] [datetime] NULL ,
	[_videoCardRejectDate] [datetime] NULL ,
	[_cpuRejectDate] [datetime] NULL ,
	[_disk1RejectDate] [datetime] NULL ,
	[_disk2RejectDate] [datetime] NULL ,
	[_disk3RejectDate] [datetime] NULL ,
	[_disk4RejectDate] [datetime] NULL ,
	[_memory1RejectDate] [datetime] NULL ,
	[_memory2RejectDate] [datetime] NULL ,
	[_memory3RejectDate] [datetime] NULL ,
	[_memory4RejectDate] [datetime] NULL ,
	[_rom1RejectDate] [datetime] NULL ,
	[_rom2RejectDate] [datetime] NULL ,
	[_zdy1ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy1RejectDate] [datetime] NULL ,
	[_zdy3ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy3RejectDate] [datetime] NULL ,
	[_zdy5ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy5RejectDate] [datetime] NULL ,
	[_zdy7ID] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_zdy7RejectDate] [datetime] NULL ,
	[_oldPrice] [decimal](18, 0) NULL ,
	[_inputId] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rejectReson] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fixedAssetsRemove] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_NO] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_removeFromDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_newUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_removeToDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_doUser] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_removeDate] [datetime] NULL ,
	[_removeReason] [nchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[_nowStation] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_oldStation] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fixedAssetsSimple] (
	[序号] [int] IDENTITY (1, 1) NOT NULL ,
	[资产名称] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[类型] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[供应商] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[所在位置] [char] (28) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fixedAssetsSimpleSetTable] (
	[_columnName] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_format] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_hide] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_fixedAssetsType] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_jfxj] (
	[_id] [int] IDENTITY (1, 1) NOT NULL ,
	[_xjTime] [datetime] NULL ,
	[_xjAdr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_xjState] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_xjNote] [char] (110) COLLATE Chinese_PRC_CI_AS NULL ,
	[_xjName] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_menu_Maintenance] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_nameTJR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_nameFZR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_nameTZR] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_tzfs] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_bossQZ] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[_cdrb] [char] (26) COLLATE Chinese_PRC_CI_AS NULL ,
	[_pud] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_pos] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[_modifyDate] [datetime] NULL ,
	[_snapPic] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_mobilePhone] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_phoneNum] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[_shortNum] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[_useState] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[_comboType] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[_telPower] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_receiveDate] [datetime] NULL ,
	[_returnDate] [datetime] NULL ,
	[_note] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_SN] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_brand] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_model] [char] (15) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_mobilePhoneComboType] (
	[_comboTypeName] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_comboTypeDetail] [char] (80) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_mobilePhoneNum] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_mobilePhoneNum] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_SN] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_brand] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_model] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_shortTelNum] [char] (5) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_netWkMain] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_fDate] [datetime] NULL ,
	[_pcNum] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_proType] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_programe] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[_method] [varchar] (700) COLLATE Chinese_PRC_CI_AS NULL ,
	[_note] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_HaveAttachments] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[_Finished] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[_lDate] [datetime] NULL ,
	[_doUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_netWorkMainProType] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_receive] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_receiveDate] [datetime] NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [nchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_number] [int] NULL ,
	[_receiver] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_receiveReason] [nchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_returnDate] [datetime] NULL ,
	[_autoNumStore] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_enterDate] [datetime] NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_enterFrom] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rejectDate] [datetime] NULL ,
	[_note] [char] (60) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_remind] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_frequency] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_time] [datetime] NULL ,
	[_content] [nchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
	[_isGq] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_repair] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_repairDate] [datetime] NULL ,
	[_sbbh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [nchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_repairFitting] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSpecifications] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_fittingSN] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_repairType] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userDep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_repairComp] [nchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_programe] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_note] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[_repairBackDate] [datetime] NULL ,
	[_repairMethod] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_price] [decimal](18, 0) NULL ,
	[_typeInUser] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_number] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_softManage] (
	[_id] [int] IDENTITY (1, 1) NOT NULL ,
	[_softNo] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[_softName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_ver] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_SN] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userNum] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[_usefulLife] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[_usefulLifeDate] [datetime] NULL ,
	[_applicant] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[_applicantDep] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_buyer] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[_buyDate] [datetime] NULL ,
	[_supplier] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userPosition] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[_note] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[_haveAttachment] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_stock] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_enterDate] [datetime] NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [nchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_number] [int] NULL ,
	[_enterFrom] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[_rejectDate] [datetime] NULL ,
	[_note] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_stock_sb] (
	[_autoNum] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_specifications] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_telNum] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_shortTelNum] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[_longTelNum] [char] (9) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_user] (
	[_id] [int] IDENTITY (1, 1) NOT NULL ,
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_user] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_userName] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_pass] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[u_role] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_userName] (
	[_autoNum] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[_cardID] [char] (23) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userNameID] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[_userName] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[_dep] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[tb_fixedAssetsSimple] ADD 
	CONSTRAINT [pk_101] PRIMARY KEY  CLUSTERED 
	(
		[序号]
	)  ON [PRIMARY] 
GO

insert tb_user(_user,_pass) values ('admin','')
insert tb_user(_user,_pass) values ('操作员1','')

insert syggVer(_soft,_ver) values ('gzcf','V5.0')
insert syggVer(_soft,_ver) values ('cgxd','V4.0')
insert syggVer(_soft,_ver) values ('itsys','V5.0')

insert tb_fileManagePath values ('D:\')
insert tb_filePath values ('D:\ITsys附件\维护日志')
insert tb_filePath_FixedAssets values ('D:\ITsys附件\固定资产')

insert tb_fixedAssetsType(_autoNum,_type) values ('1','台式机')
insert tb_fixedAssetsType(_autoNum,_type) values ('2','笔记本')
insert tb_fixedAssetsType(_autoNum,_type) values ('3','打印机')
insert tb_fixedAssetsType(_autoNum,_type) values ('4','复印机')
insert tb_fixedAssetsType(_autoNum,_type) values ('5','传真机')

insert tb_netWorkMainProType(_autoNum,_type) values ('1','网络')
insert tb_netWorkMainProType(_autoNum,_type) values ('2','系统')
insert tb_netWorkMainProType(_autoNum,_type) values ('3','ERP-财务')
insert tb_netWorkMainProType(_autoNum,_type) values ('4','ERP-采购')

insert tb_fixedAssetsSimpleSetTable(_columnName,_format,_hide) values ('序号','文本','是')
insert tb_fixedAssetsSimpleSetTable(_columnName,_format,_hide) values ('资产名称','文本','是')
insert tb_fixedAssetsSimpleSetTable(_columnName,_format,_hide) values ('类型','文本','是')
insert tb_fixedAssetsSimpleSetTable(_columnName,_format,_hide) values ('供应商','文本','是')
insert tb_fixedAssetsSimpleSetTable(_columnName,_format,_hide) values ('部门','文本','是')
insert tb_fixedAssetsSimpleSetTable(_columnName,_format,_hide) values ('所在位置','文本','是')

insert tb_fixedAssets(_autoNum,_NO,_hide) values ('00','0','是')

insert tb_userName(_autoNum,_cardID,_userNameID,_userName,_dep) values ('001','12581','H001','张三','电脑部')
insert tb_userName(_autoNum,_cardID,_userNameID,_userName,_dep) values ('002','36982','H002','李四','采购部')

insert tb_stock(_autoNum,_enterDate,_name,_specifications,_type,_number,_enterFrom,_rejectDate,_note) values ('N-201110151710110000','2011-10-15','三星500G硬盘SATA','SATA','硬盘','2','手工录入','2015-10-15','原始库存')

insert tb_telNum(_autoNum,_shortTelNum,_longTelNum) values ('N-20111016172731','8000','2289800')
insert tb_telNum(_autoNum,_shortTelNum,_longTelNum) values ('N-20111016172731','8011','2289811')

insert tb_mobilePhoneComboType(_comboTypeName,_comboTypeDetail) values ('100元套餐','包月300分钟。省内3毛一分钟，漫游5毛一分钟。')
insert tb_mobilePhoneComboType(_comboTypeName,_comboTypeDetail) values ('200元套餐','包月700分钟。省内3毛一分钟，漫游5毛一分钟。')

insert tb_stock_sb(_autoNum,_name,_specifications,_type) values ('001','三星500G硬盘SATA','SATA','硬盘')
insert tb_stock_sb(_autoNum,_name,_specifications,_type) values ('002','金士顿2G内存DDR3','DDR3 1333','内存')

insert tb_remind(_autoNum,_name,_frequency,_time,_content,_isGq) values ('N-20111016173519','开会','1次','2011-10-16 17:35:00','9点开会。经理级例会。','是')

insert tb_accountNumberManage(_autoNum,_accountNum,_pass,_type,_userDep,_user) values ('N-20111016173900','dc01','dc01','阿里旺旺','采购部','李四')

insert tb_SupplierComp(_autoNum,_supplier,_type,_Contact,_phone,_mobilePhone,_fax,_qq,_mail,_addr) values ('001','电脑维修公司A','维修商','张三','0755-2588558','1387878787','0755-2588559','2525858','zs@163.com','广东省深圳电脑城')
insert tb_SupplierComp(_autoNum,_supplier,_type,_Contact,_phone,_mobilePhone,_fax,_qq,_mail,_addr) values ('002','电脑专卖公司A','供应商','李四','0755-2536368','1356855587','0755-2536989','3689858','232@163.com','广东省深圳电脑城')

insert tb_fixedAssets(_autoNum,_NO,_name,_specifications,_type,_buyDate,_supplier,_identificationNo,_identificationDate,_freeRepairationDate,_useDate,_useYear,_oldPrice,_rejectDate,_useState,_station,_user,_userDep,_model,_zdy29,_zdy30,_mainboardID,_mainboard,_mainboardSN,_cpuID,_cpu,_cpuSN,_networkCardID,_networkCard,_networkCardSN,_soundCardID,_soundCard,_soundCardSN,_videoCardID,_videoCard,_videoCardSN,_videoCardPort,_videoCardVolume,_powerID,_power,_powerSN,_powerType,_powerRating,_disk1ID,_disk1,_disk1SN,_disk1Port,_disk1Volume,_memory1ID,_memory1,_memory1SN,_memory1Port,_memory1Volume,_rom1ID,_rom1,_rom1SN,_rom1Port,_rom1Type,_monitorID,_monitor,_monitorSN,_monitorType,_monitorSize,_keyID,_key,_keySN,_keyPort,_keyType,_mouseID,_mouse,_mouseSN,_mousePort,_mouseType) values ('201110142115020000','pc102','台式电脑','组装机','电脑','2011-10-14','电脑专卖公司A','C1025812','2011-1-2','2014-10-14','2011-10-14','5','3000','2016-10-12','使用','电脑部','张三','电脑部','组装','2011-10-14','2011-10-14','N-20111114092007','华硕MV550','S10253632858','N-20111114092008','AMD5800','S36987569883','N-20111114092009','集成','','N-20111114092010','集成','','N-20111114092011','七彩虹M365S','S36989696369','PCI-E','1G','N-20111114092012','长城静音大师300W','S36963655566','ATX','300W','N-20111114092013','希捷Barracuda 7200.12 500G单碟','S25254545454','串口 ','500G','N-20111114092014','金士顿DDR3 1333 2G','S858586558856','DDR3','2G','N-20111114092015','三星TS-H353C/CHXH(SATA)','S586565655656','串口','DVD光驱','N-20111114092016','三星S22A330BW','S587878585585','液晶','22寸','N-20111114092017','罗技K120','S369689898996','USB','有线','N-20111114092018','双飞燕G9-500F','S368988955836','USB','无线')


