sqlsrv.sql 789 Bytes
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[#__wf_profiles]') AND type in (N'U'))
BEGIN
CREATE TABLE [#__wf_profiles](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](250) NOT NULL,
	[description] [text] NOT NULL,
	[users] [text] NOT NULL,
	[types] [text] NOT NULL,
	[components] [nvarchar](max) NOT NULL,
	[area] [smallint] NOT NULL,
    [device] [nvarchar](250) NOT NULL,
	[rows] [nvarchar](max) NOT NULL,
	[plugins] [nvarchar](max) NOT NULL,
	[published] [smallint] NOT NULL,
	[ordering] [int] NOT NULL,
	[checked_out] [int] NOT NULL,
	[checked_out_time] [datetime] NOT NULL,
	[params] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_#__wf_profiles_id] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END;