CREATE TABLE [dbo].[por_portlet_applic]
(
[portlet_applic_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[portlet_applic_version] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[web_applic_id] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[custom_portlet_modes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[custom_window_states] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[portlet_user_attributes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[security_constraints] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[portlet_applic_edition] [int] NULL,
[creation_date] [bigint] NULL,
[last_modification_date] [bigint] NULL,
[portlet_applic_alias] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[portal_instance_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[por_portlet_applic] ADD CONSTRAINT [xpkportlet_application] PRIMARY KEY NONCLUSTERED ([portlet_applic_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$por_p_u000035f300000000] ON [dbo].[por_portlet_applic] ([portlet_applic_alias], [portal_instance_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xak1portlet_application] ON [dbo].[por_portlet_applic] ([portlet_applic_alias], [portal_instance_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[por_portlet_applic] ADD CONSTRAINT [$por_p_r000036bc00000000] FOREIGN KEY ([portal_instance_id]) REFERENCES [dbo].[por_portal_instance] ([portal_instance_id])
GO
GRANT SELECT ON  [dbo].[por_portlet_applic] TO [portaldba_group]
GRANT INSERT ON  [dbo].[por_portlet_applic] TO [portaldba_group]
GRANT DELETE ON  [dbo].[por_portlet_applic] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[por_portlet_applic] TO [portaldba_group]
GO