????1.?????????????????
????Alter TABLE [dbo].[CustomerBackupConfig] Add [Stamp] [timestamp] NULL
????GO
????2.??????????????????
????Alter Table tblStates Add [TaxRate] money not null default 0??
????[Transit] int not null default 0
????GO
????3.???????????????
????Alter Table [dbo].[tblOrder] Drop Column [CookieID]
????GO
????4.?????????????ε????
????Alter Table [dbo].[tblOrder] Alter Column [CookieID] int not null
????GO
????5.????????
????Drop Table tblTaxRate
????GO
????6.???????????????????????????????????????
????Alter TABLE [dbo].[OrderPackageOption] Drop CONSTRAINT [FK_OrderPackageOption_OrderPackage]
????ALTER TABLE [dbo].[OrderPackageOption] ADD
????CONSTRAINT [FK_OrderPackageOption_OrderPackage] FOREIGN KEY
????(
????[OrderPackageID]
????) REFERENCES [dbo].[OrderPackage] (
????[OrderPackageID]
????)
????GO
????7. ?????????????????????????????????????????????????????????????
????ALTER TABLE [dbo].[Account] ADD
????CONSTRAINT [FK_Account_State] FOREIGN KEY
????(
????[StateID]
????) REFERENCES [dbo].[State] (
????[StateID]
????)??
????CONSTRAINT [FK_Account_TimeZones] FOREIGN KEY
????(
????[TimeZoneID]
????) REFERENCES [dbo].[TimeZones] (
????[timeid]
????)
????GO
????Alter table [dbo].[Account] NoCheck Constraint [FK_Account_TimeZones]
????GO
????8. ????????????鵱?????
????ALTER TABLE [dbo].[Account] With NoCheck
????ADD CONSTRAINT [FK_Account_AccountType]
????FOREIGN KEY
????(
????[TypeID]
????) REFERENCES [dbo].[AccountType] (
????[TypeID]
????)
????GO
????9????????????????????????????????identity_insert??????????????????????????????е??飬?????в????????
????set identity_insert [dbo].[PSTNUsageNotes] on
????--????????ж?PSTNUsageNotes??????????????
????set identity_insert [dbo].[PSTNUsageNotes] off