[char] (2) NOT NULL ,
[Description] [varchar] (100) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CodeCurrency] (
[Code] [char] (3) NOT NULL ,
[Description] [varchar] (100) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CodeFrequency] (
[Code] [char] (1) NOT NULL ,
[Description] [nvarchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CodeRegion] (
[Code] [char] (2) NOT NULL ,
[Description] [varchar] (100) NOT NULL ,
[Country] [char] (2) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FAQs] (
[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
[ModuleID] [int] NOT NULL ,
[CreatedByUser] [nvarchar] (100) NULL ,
[CreatedDate] [datetime] NULL ,
[Question] [text] NULL ,
[Answer] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[Files] (
[FileId] [int] IDENTITY (1, 1) NOT NULL ,
[PortalId] [int] NULL ,
[FileName] [nvarchar] (100) NOT NULL ,
[Extension] [nvarchar] (100) NOT NULL ,
[Size] [int] NOT NULL ,
[Width] [int] NULL ,
[Height] [int] NULL ,
[ContentType] [nvarchar] (200) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ModuleDefinitions] (
[ModuleDefID] [int] IDENTITY (1, 1) NOT NULL ,
[FriendlyName] [nvarchar] (128) NOT NULL ,
[DesktopSrc] [nvarchar] (256) NULL ,
[MobileSrc] [nvarchar] (256) NULL ,
[AdminOrder] [int] NULL ,
[EditSrc] [nvarchar] (256) NULL ,
[Secure] [bit] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Portals] (
[PortalID] [int] IDENTITY (-1, 1) NOT NULL ,
[PortalAlias] [nvarchar] (200) NOT NULL ,
[PortalName] [nvarchar] (128) NOT NULL ,
[UploadDirectory] [nvarchar] (100) NOT NULL ,
[LogoFile] [nvarchar] (50) NULL ,
[FooterText] [nvarchar] (100) NULL ,
[ExpiryDate] [datetime] NULL ,
[UserRegistration] [int] NULL ,
[BannerAdvertising] [int] NULL ,
[AdministratorId] [int] NULL ,
[PayPalId] [nvarchar] (50) NULL ,
[Currency] [char] (3) NULL ,
[HostFee] [nvarchar] (10) NULL ,
[HostSpace] [int] NULL ,
[AdministratorRoleId] [int] NULL ,
[RegisteredRoleId] [int] NULL ,
[GUID] [uniqueidentifier] NOT NULL CONSTRAINT DF_Portals_GUID DEFAULT newid()
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Users] (
[UserID] [int] IDENTITY (1, 1) NOT NULL ,
[FirstName] [nvarchar] (50) NOT NULL ,
[LastName] [nvarchar] (50) NULL ,
[Street] [nvarchar] (20) NULL ,
[City] [nvarchar] (20) NULL ,
[Region] [nvarchar] (20) NULL ,
[PostalCode] [nvarchar] (10) NULL ,
[Country] [nvarchar] (20) NULL ,
[Password] [nvarchar] (20) NOT NULL ,
[Email] [nvarchar] (100) NOT NULL ,
[CreatedDate] [datetime] NULL ,
[LastLoginDate] [datetime] NULL ,
[Unit] [nvarchar] (50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Version] (
[VersionId] [int] IDENTITY (1, 1) NOT NULL ,
[Major] [int] NOT NULL ,
[Minor] [int] NOT NULL ,
[Build] [int] NOT NULL ,
[Comment] [varchar] (100) NOT NULL ,
[CreatedDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Roles] (
[RoleID] [int] IDENTITY (0, 1) NOT NULL ,
[PortalID] [int] NULL ,
[RoleName] [nvarchar] (50) NOT NULL ,
[Description] [nvarchar] (1000) NULL ,
[ServiceFee] [decimal](5, 2) NULL ,
[BillingFrequency] [char] (1) NULL ,
[TrialPeriod] [int] NULL ,
[TrialFrequency] [char] (1) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[SiteLog] (
[SiteLogId] [int] IDENTITY (1, 1) NOT NULL ,
[DateTime] [smalldatetime] NOT NULL ,
[PortalId] [int] NOT NULL ,
[UserId] [int] NULL ,
[Referrer] [nvarchar] (255) NULL ,
[Url] [nvarchar] (255) NULL ,
[UserAgent] [nvarchar] (255) NULL ,
[UserHostAddress] [nvarchar] (255) NULL ,
[UserHostName] [nvarchar] (255) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tabs] (
[TabID] [int] IDENTITY (0, 1) NOT NULL ,
[TabOrder] [int] NOT NULL ,
[PortalID] [int] NULL ,
[TabName] [nvarchar] (50) NOT NULL ,
[MobileTabName] [nvarchar] (50) NOT NULL ,
[AuthorizedRoles] [nvarchar] (256) NULL ,
[ShowMobile] [bit] NOT NULL ,
[LeftPaneWidth] [nvarchar] (5) NOT NULL ,
[RightPaneWidth] [nvarchar] (5) NOT NULL ,
[IsVisible] [bit] NOT NULL
) ON [PRIMARY]
GO
how do iget around this?