[syntax type=”js”]CREATE TABLE ModuleHouseTradingPackage(
Id INT NOT NULL PRIMARY KEY,
LanguageId INT NOT NULL FOREIGN KEY REFERENCES dbo.Language(Id),
Name NVARCHAR(MAX) NULL,
Description NVARCHAR(MAX) NULL,
HouseLimit INT NOT NULL DEFAULT 0, –0 Is Unlimited
ImgLimit INT NOT NULL DEFAULT 0, –0 Is Unlimited
Price DECIMAL NOT NULL DEFAULT 0, –Price of package
CurrencyId INT NOT NULL FOREIGN KEY REFERENCES dbo.Currency(Id)
);[/syntax]