/*----25/10/08----*/
USE [dbLagstabud]
GO
/****** Object:  Table [dbo].[CurrencyPriceModifiers]    Script Date: 10/25/2008 20:20:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CurrencyPriceModifiers](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Currency] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[PriceModifier] [float] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
/*---------------------------------------------------------------------------*/
USE [dbLagstabud]
GO
/****** Object:  Table [dbo].[Settings]    Script Date: 10/25/2008 20:22:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Settings](
	[CompanyID] [int] NOT NULL,
	[Country] [int] NOT NULL,
	[LateFeePercentage] [int] NOT NULL,
	[MomsReg] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Settings]  WITH CHECK ADD  CONSTRAINT [FK_Settings_CompanyInfo] FOREIGN KEY([CompanyID])
REFERENCES [dbo].[CompanyInfo] ([CompanyID])
GO
ALTER TABLE [dbo].[Settings] CHECK CONSTRAINT [FK_Settings_CompanyInfo]
GO
ALTER TABLE [dbo].[Settings]  WITH CHECK ADD  CONSTRAINT [FK_Settings_Country] FOREIGN KEY([Country])
REFERENCES [dbo].[Country] ([CountryID])
GO
ALTER TABLE [dbo].[Settings] CHECK CONSTRAINT [FK_Settings_Country]
/*---------------------------------------------------------------------------*/
use dblagstabud;
/*10-Nov-2008*/
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.PaynovaLog ADD
	GatewayTransactionID nvarchar(255) NULL
GO
COMMIT    
/*---------------------------------------------------------------------------*/
use dblagstabud;
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.PaynovaLog ADD
	LocalTransactionID nvarchar(255) NULL
GO
COMMIT
/*---------------------------------------------------------------------------*/
use dblagstabud;
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
EXECUTE sp_rename N'dbo.CurrencyPriceModifiers.Currency', N'Tmp_CurrencyCode', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.CurrencyPriceModifiers.Tmp_CurrencyCode', N'CurrencyCode', 'COLUMN' 
GO
COMMIT