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

CREATE TABLE [dbo].[W@ctpPracticeM] (
	[PracticeType] [varchar] (8) NULL ,
	[PracticeCode] [varchar] (8) NOT NULL ,
	[PracticeSeq] [int] NULL ,
	[PackageMode] [varchar] (2) NULL ,
	[PracticeName] [varchar] (40) NULL ,
	[UnusedFlag] [tinyint] NULL ,
	[TCloseFlag] [tinyint] NULL ,
	[DefaultFlag] [smallint] NULL ,
	[ManageFlag] [smallint] NULL ,
	[MasterPwd] [varchar] (8) NULL ,
	[Remarks] [varchar] (250) NULL ,
	[BgImage] [varchar] (100) NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[NowDate] [datetime] NULL ,
	[Settlement] [smallint] NULL ,
	[ExCode] [varchar] (3) NULL ,
	[ExRate] [real] NULL ,
	[ExConsumptionTax] [money] NULL ,
	[ConsumptionTax] [money] NULL ,
	[ComputeFlag] [smallint] NULL ,
	[PCapitalAmount] [money] NULL ,
	[CCapitalAmount] [money] NULL ,
	[PCapitalAmountLock] [varchar] (2) NULL ,
	[CCapitalAmountLock] [varchar] (2) NULL ,
	[COfficeGuarantee] [money] NULL ,
	[COfficeRentalFee] [money] NULL ,
	[COfficeAssetsPrice] [money] NULL ,
	[HpOpeningCostH] [money] NULL ,
	[HpOpeningCostL] [money] NULL ,
	[HpRentalFeeH] [money] NULL ,
	[HpRentalFeeL] [money] NULL ,
	[HpManagerSalary] [money] NULL ,
	[HpClerkSalary] [money] NULL ,
	[HpIMaxSell] [smallint] NULL ,
	[HpIMaxBuy] [smallint] NULL ,
	[HpStockCheck] [smallint] NULL ,
	[HpStockAutoFlag] [smallint] NULL ,
	[HpVoteCheck] [smallint] NULL ,
	[HpVoteTitle1] [varchar] (50) NULL ,
	[HpVoteTitle2] [varchar] (50) NULL ,
	[HpVoteTitle3] [varchar] (50) NULL ,
	[HpVoteTitle4] [varchar] (50) NULL ,
	[HpVoteTitle5] [varchar] (50) NULL ,
	[HpNewItem] [varchar] (2) NULL ,
	[HpCompanyShopping] [varchar] (2) NULL ,
	[PBankLoanLimit] [money] NULL ,
	[CBankLoanLimit] [money] NULL ,
	[CCreditFee] [money] NULL ,
	[CCreditRate] [money] NULL ,
	[CCreditLimit] [money] NULL ,
	[PCreditLimit] [money] NULL ,
	[XCreditActFee] [money] NULL ,
	[XSecActFee] [money] NULL ,
	[XSecRate] [real] NULL ,
	[XSecTax] [money] NULL ,
	[PDealerDiscAmnt] [money] NULL ,
	[PDealerDiscRate] [real] NULL ,
	[CDealerDiscAmnt] [money] NULL ,
	[CDealerDiscRate] [real] NULL ,
	[PMakerDiscAmnt] [money] NULL ,
	[PMakerDiscRate] [real] NULL ,
	[PMakerMakeRate] [real] NULL ,
	[PMakerCostRate] [real] NULL ,
	[PMakerSellRate] [real] NULL ,
	[CMakerDiscAmnt] [money] NULL ,
	[CMakerDiscRate] [real] NULL ,
	[CMakerMakeRate] [real] NULL ,
	[CMakerCostRate] [real] NULL ,
	[CMakerSellRate] [real] NULL ,
	[CMakerMakeRateAdd] [real] NULL ,
	[CMakerCostRateAdd] [real] NULL ,
	[XAdFee] [money] NULL ,
	[XAdFee2] [money] NULL ,
	[SearchNGFlag] [smallint] NULL ,
	[POption01] [money] NULL ,
	[POption02] [money] NULL ,
	[POption03] [money] NULL ,
	[POption04] [money] NULL ,
	[POption05] [money] NULL ,
	[AddDate] [datetime] NULL ,
	[UpdDate] [datetime] NULL ,
	[AddProc] [varchar] (20) NULL ,
	[UpdProc] [varchar] (20) NULL ,
	[MasterID] [varchar] (12) NULL ,
	[MallCount] [int] NULL ,
	[CircularNotice] [varchar] (2) NULL ,
	[Ranking] [varchar] (2) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[W@ctpPracticeM] ADD 
	CONSTRAINT [DF_W@ctpPracticeM_PracticeSeq] DEFAULT (0) FOR [PracticeSeq],
	CONSTRAINT [DF_W@ctpPracticeM_UnusedFlag] DEFAULT (0) FOR [UnusedFlag],
	CONSTRAINT [DF_W@ctpPracticeM_TCloseFlag] DEFAULT (0) FOR [TCloseFlag],
	CONSTRAINT [DF_W@ctpPracticeM_DefaultFlag] DEFAULT (0) FOR [DefaultFlag],
	CONSTRAINT [DF_W@ctpPracticeM_ManageFlag] DEFAULT (0) FOR [ManageFlag],
	CONSTRAINT [DF_W@ctpPracticeM_Settlement] DEFAULT (0) FOR [Settlement],
	CONSTRAINT [DF_W@ctpPracticeM_ExRate] DEFAULT (0) FOR [ExRate],
	CONSTRAINT [DF_W@ctpPracticeM_ExConsumptionTax] DEFAULT (0) FOR [ExConsumptionTax],
	CONSTRAINT [DF_W@ctpPracticeM_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax],
	CONSTRAINT [DF_W@ctpPracticeM_ComputeFlag] DEFAULT (0) FOR [ComputeFlag],
	CONSTRAINT [DF_W@ctpPracticeM_PCapitalAmount] DEFAULT (0) FOR [PCapitalAmount],
	CONSTRAINT [DF_W@ctpPracticeM_CCapitalAmount] DEFAULT (0) FOR [CCapitalAmount],
	CONSTRAINT [DF_W@ctpPracticeM_COfficeGuarantee] DEFAULT (0) FOR [COfficeGuarantee],
	CONSTRAINT [DF_W@ctpPracticeM_COfficeRentalFee] DEFAULT (0) FOR [COfficeRentalFee],
	CONSTRAINT [DF_W@ctpPracticeM_COfficeAssetsPrice] DEFAULT (0) FOR [COfficeAssetsPrice],
	CONSTRAINT [DF_W@ctpPracticeM_HpOpeningCostH] DEFAULT (0) FOR [HpOpeningCostH],
	CONSTRAINT [DF_W@ctpPracticeM_HpOpeningCostL] DEFAULT (0) FOR [HpOpeningCostL],
	CONSTRAINT [DF_W@ctpPracticeM_HpRentalFeeH] DEFAULT (0) FOR [HpRentalFeeH],
	CONSTRAINT [DF_W@ctpPracticeM_HpRentalFeeL] DEFAULT (0) FOR [HpRentalFeeL],
	CONSTRAINT [DF_W@ctpPracticeM_HpManagerSalary] DEFAULT (0) FOR [HpManagerSalary],
	CONSTRAINT [DF_W@ctpPracticeM_HpClerkSalary] DEFAULT (0) FOR [HpClerkSalary],
	CONSTRAINT [DF_W@ctpPracticeM_HpIMaxSell] DEFAULT (0) FOR [HpIMaxSell],
	CONSTRAINT [DF_W@ctpPracticeM_HpIMaxBuy] DEFAULT (0) FOR [HpIMaxBuy],
	CONSTRAINT [DF_W@ctpPracticeM_HpStockCheck] DEFAULT (0) FOR [HpStockCheck],
	CONSTRAINT [DF_W@ctpPracticeM_HpStockAutoFlag] DEFAULT (0) FOR [HpStockAutoFlag],
	CONSTRAINT [DF_W@ctpPracticeM_HpVoteCheck] DEFAULT (0) FOR [HpVoteCheck],
	CONSTRAINT [DF_W@ctpPracticeM_PBankLoanLimit] DEFAULT (0) FOR [PBankLoanLimit],
	CONSTRAINT [DF_W@ctpPracticeM_CBankLoanLimit] DEFAULT (0) FOR [CBankLoanLimit],
	CONSTRAINT [DF_W@ctpPracticeM_CCreditFee] DEFAULT (0) FOR [CCreditFee],
	CONSTRAINT [DF_W@ctpPracticeM_CCreditRate] DEFAULT (0) FOR [CCreditRate],
	CONSTRAINT [DF_W@ctpPracticeM_CCreditLimit] DEFAULT (0) FOR [CCreditLimit],
	CONSTRAINT [DF_W@ctpPracticeM_PCreditLimit] DEFAULT (0) FOR [PCreditLimit],
	CONSTRAINT [DF_W@ctpPracticeM_XCreditActFee] DEFAULT (0) FOR [XCreditActFee],
	CONSTRAINT [DF_W@ctpPracticeM_XSecActFee] DEFAULT (0) FOR [XSecActFee],
	CONSTRAINT [DF_W@ctpPracticeM_XSecRate] DEFAULT (0) FOR [XSecRate],
	CONSTRAINT [DF_W@ctpPracticeM_XSecTax] DEFAULT (0) FOR [XSecTax],
	CONSTRAINT [DF_W@ctpPracticeM_PDealerDiscAmnt] DEFAULT (0) FOR [PDealerDiscAmnt],
	CONSTRAINT [DF_W@ctpPracticeM_PDealerDiscRate] DEFAULT (0) FOR [PDealerDiscRate],
	CONSTRAINT [DF_W@ctpPracticeM_CDealerDiscAmnt] DEFAULT (0) FOR [CDealerDiscAmnt],
	CONSTRAINT [DF_W@ctpPracticeM_CDealerDiscRate] DEFAULT (0) FOR [CDealerDiscRate],
	CONSTRAINT [DF_W@ctpPracticeM_PMakerDiscAmnt] DEFAULT (0) FOR [PMakerDiscAmnt],
	CONSTRAINT [DF_W@ctpPracticeM_PMakerDiscRate] DEFAULT (0) FOR [PMakerDiscRate],
	CONSTRAINT [DF_W@ctpPracticeM_PMakerMakeRate] DEFAULT (0) FOR [PMakerMakeRate],
	CONSTRAINT [DF_W@ctpPracticeM_PMakerCostRate] DEFAULT (0) FOR [PMakerCostRate],
	CONSTRAINT [DF_W@ctpPracticeM_PMakerSellRate] DEFAULT (0) FOR [PMakerSellRate],
	CONSTRAINT [DF_W@ctpPracticeM_CMakerDiscAmnt] DEFAULT (0) FOR [CMakerDiscAmnt],
	CONSTRAINT [DF_W@ctpPracticeM_CMakerDiscRate] DEFAULT (0) FOR [CMakerDiscRate],
	CONSTRAINT [DF_W@ctpPracticeM_CMakerMakeRate] DEFAULT (0) FOR [CMakerMakeRate],
	CONSTRAINT [DF_W@ctpPracticeM_CMakerCostRate] DEFAULT (0) FOR [CMakerCostRate],
	CONSTRAINT [DF_W@ctpPracticeM_CMakerSellRate] DEFAULT (0) FOR [CMakerSellRate],
	CONSTRAINT [DF_W@ctpPracticeM_XAdFee] DEFAULT (0) FOR [XAdFee],
	CONSTRAINT [DF_W@ctpPracticeM_XAdFee2] DEFAULT (0) FOR [XAdFee2],
	CONSTRAINT [DF_W@ctpPracticeM_SearchNGFlag] DEFAULT (0) FOR [SearchNGFlag],
	CONSTRAINT [DF_W@ctpPracticeM_POption01] DEFAULT (0) FOR [POption01],
	CONSTRAINT [DF_W@ctpPracticeM_POption02] DEFAULT (0) FOR [POption02],
	CONSTRAINT [DF_W@ctpPracticeM_POption03] DEFAULT (0) FOR [POption03],
	CONSTRAINT [DF_W@ctpPracticeM_POption04] DEFAULT (0) FOR [POption04],
	CONSTRAINT [DF_W@ctpPracticeM_POption05] DEFAULT (0) FOR [POption05],
	CONSTRAINT [PK_W@ctpPracticeM] PRIMARY KEY  CLUSTERED 
	(
		[PracticeCode]
	)  ON [PRIMARY] 
GO