USE [ScreenSistema]
GO
/****** Object:  User [betrace]    Script Date: 24/06/2016 10:22:53 ******/
CREATE USER [betrace] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
GO
ALTER ROLE [db_owner] ADD MEMBER [betrace]
GO
/****** Object:  Table [dbo].[USR_RST2_T000_Logs]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_RST2_T000_Logs](
	[IntT1000Id] [int] IDENTITY(1,1) NOT NULL,
	[IntT1000IdUtilizador] [int] NOT NULL,
	[StrT1000Login] [nvarchar](50) NOT NULL,
	[StrT1000Servidor] [nvarchar](50) NOT NULL,
	[StrT1000BD] [nvarchar](50) NOT NULL,
	[BitT1000In] [bit] NOT NULL,
	[DtmT1000DataHora] [datetime] NOT NULL,
	[StrT1000NomePC] [nvarchar](50) NOT NULL,
	[StrT1000Username] [nvarchar](50) NULL,
	[strT1000Acao] [nvarchar](max) NULL,
	[bit1000erro] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_Rst2_T1001Utilizadores]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_Rst2_T1001Utilizadores](
	[IntT1001IdUtilizador] [int] IDENTITY(1,1) NOT NULL,
	[IntT1001IdPerfil] [int] NULL,
	[IntT1001IdEticadata] [int] NULL,
	[StrT1001Login] [nvarchar](50) NOT NULL,
	[StrT1001Password] [nvarchar](50) NULL,
	[StrT1001Utilizador] [nvarchar](50) NULL,
	[Str1001Email] [nvarchar](50) NULL,
	[Str1001Telemovel] [nvarchar](50) NULL,
	[Str1001Telefone] [nvarchar](50) NULL,
	[Str1001VoipUser] [nvarchar](50) NULL,
	[Str1001VoipPassword] [nvarchar](50) NULL,
	[Str1001Lingua] [nvarchar](50) NULL,
	[Str1001SmtpServer] [nvarchar](50) NULL,
	[Bln1001SuperUtilizador] [bit] NULL,
	[Bln1001Administrador] [bit] NULL,
	[Bln1001Formulas] [bit] NULL,
	[Bln1001NaoConforme] [bit] NULL,
	[Bln1001Alertas] [bit] NULL,
	[Bln1001Ativo] [bit] NULL,
 CONSTRAINT [PK_TblUtilizadores] PRIMARY KEY CLUSTERED 
(
	[IntT1001IdUtilizador] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_Rst2_T1002AcessosMenus]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_Rst2_T1002AcessosMenus](
	[IntT1002IdPerfil] [int] NOT NULL,
	[StrT1002NomeMenu] [nvarchar](50) NOT NULL,
	[BitT1002Activo] [bit] NOT NULL,
	[StrT1002NomePai] [nvarchar](50) NULL,
	[IntT1002Ordem] [int] NULL,
	[IntT1002Nivel] [int] NULL,
	[StrT1002TextoMenu] [nvarchar](50) NULL,
 CONSTRAINT [PK_USR_RST2_T1002AcessosMenus] PRIMARY KEY CLUSTERED 
(
	[IntT1002IdPerfil] ASC,
	[StrT1002NomeMenu] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_Rst2_T1003Perfis]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_Rst2_T1003Perfis](
	[IntT1003IdPerfil] [int] IDENTITY(1,1) NOT NULL,
	[StrT1003NomePerfil] [nvarchar](50) NOT NULL,
	[BitT1003Activo] [bit] NOT NULL,
 CONSTRAINT [PK_USR_RST2_T1003Perfis] PRIMARY KEY CLUSTERED 
(
	[IntT1003IdPerfil] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_Rst2_T1004Menus]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_Rst2_T1004Menus](
	[IntT1004Id] [int] NOT NULL,
	[StrT1004Nome] [nvarchar](50) NOT NULL,
	[StrT1004NomePai] [nvarchar](max) NULL,
	[IntT1004Nivel] [int] NULL,
	[StrT1004Texto] [nvarchar](50) NULL,
 CONSTRAINT [PK_USR_Rst2_T1004Menus] PRIMARY KEY CLUSTERED 
(
	[IntT1004Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_Rst2_T1005MenusAcessos]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_Rst2_T1005MenusAcessos](
	[IntT1005IdPerfil] [int] NOT NULL,
	[IntT1005NomeMenu] [nvarchar](50) NOT NULL,
	[BitT1005Ativo] [bit] NULL,
 CONSTRAINT [PK_USR_Rst2_T1005MenusAcessos] PRIMARY KEY CLUSTERED 
(
	[IntT1005IdPerfil] ASC,
	[IntT1005NomeMenu] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_RST3_Departamento]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_RST3_Departamento](
	[intId] [int] IDENTITY(1,1) NOT NULL,
	[strDepartamento] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tbl_Departamento] PRIMARY KEY CLUSTERED 
(
	[intId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[USR_RST3_UtilizadorDepartamento]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_RST3_UtilizadorDepartamento](
	[intIdUtilizador] [int] NOT NULL,
	[intIdDepartamento] [int] NOT NULL,
	[bitAtivo] [bit] NOT NULL,
	[bitResponsavel] [bit] NOT NULL,
 CONSTRAINT [PK_USR_RST3_UtilizadorDepartamento] PRIMARY KEY CLUSTERED 
(
	[intIdUtilizador] ASC,
	[intIdDepartamento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  View [dbo].[USR_Rst3_ImportLogin]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[USR_Rst3_ImportLogin]
AS
SELECT     dbo.USR_Rst2_T1003Perfis.IntT1003IdPerfil, dbo.USR_Rst2_T1004Menus.StrT1004Nome, dbo.USR_Rst2_T1002AcessosMenus.BitT1002Activo
FROM         dbo.USR_Rst2_T1003Perfis INNER JOIN
                      dbo.USR_Rst2_T1002AcessosMenus ON dbo.USR_Rst2_T1003Perfis.IntT1003IdPerfil = dbo.USR_Rst2_T1002AcessosMenus.IntT1002IdPerfil RIGHT OUTER JOIN
                      dbo.USR_Rst2_T1004Menus ON dbo.USR_Rst2_T1002AcessosMenus.StrT1002NomeMenu = dbo.USR_Rst2_T1004Menus.StrT1004Nome
WHERE     (NOT (dbo.USR_Rst2_T1003Perfis.IntT1003IdPerfil IS NULL)) AND (NOT (dbo.USR_Rst2_T1004Menus.StrT1004Nome IS NULL))

GO
/****** Object:  View [dbo].[USR_Rst3_View_DepartamentoUtilizador]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[USR_Rst3_View_DepartamentoUtilizador]
AS
SELECT        dbo.USR_RST3_UtilizadorDepartamento.intIdUtilizador, dbo.USR_Rst2_T1001Utilizadores.StrT1001Login, dbo.USR_Rst2_T1001Utilizadores.StrT1001Utilizador, 
                         dbo.USR_RST3_UtilizadorDepartamento.intIdDepartamento, dbo.USR_RST3_Departamento.strDepartamento, dbo.USR_RST3_UtilizadorDepartamento.bitResponsavel, 
                         dbo.USR_Rst2_T1001Utilizadores.Bln1001Ativo
FROM            dbo.USR_Rst2_T1001Utilizadores INNER JOIN
                         dbo.USR_RST3_UtilizadorDepartamento ON dbo.USR_Rst2_T1001Utilizadores.IntT1001IdUtilizador = dbo.USR_RST3_UtilizadorDepartamento.intIdUtilizador INNER JOIN
                         dbo.USR_RST3_Departamento ON dbo.USR_RST3_UtilizadorDepartamento.intIdDepartamento = dbo.USR_RST3_Departamento.intId
WHERE        (dbo.USR_RST3_UtilizadorDepartamento.bitAtivo = 1)

GO
/****** Object:  View [dbo].[USR_Rst3_View_PerfisMenusAcessos]    Script Date: 24/06/2016 10:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[USR_Rst3_View_PerfisMenusAcessos]
AS
SELECT     dbo.USR_Rst2_T1003Perfis.IntT1003IdPerfil, dbo.USR_Rst2_T1003Perfis.StrT1003NomePerfil, dbo.USR_Rst2_T1004Menus.IntT1004Id, 
                      dbo.USR_Rst2_T1004Menus.StrT1004Nome, dbo.USR_Rst2_T1004Menus.StrT1004NomePai, dbo.USR_Rst2_T1004Menus.IntT1004Nivel, 
                      dbo.USR_Rst2_T1004Menus.StrT1004Texto, dbo.USR_Rst2_T1005MenusAcessos.BitT1005Ativo
FROM         dbo.USR_Rst2_T1005MenusAcessos INNER JOIN
                      dbo.USR_Rst2_T1003Perfis ON dbo.USR_Rst2_T1005MenusAcessos.IntT1005IdPerfil = dbo.USR_Rst2_T1003Perfis.IntT1003IdPerfil INNER JOIN
                      dbo.USR_Rst2_T1004Menus ON dbo.USR_Rst2_T1005MenusAcessos.IntT1005NomeMenu = dbo.USR_Rst2_T1004Menus.StrT1004Nome

GO
ALTER TABLE [dbo].[USR_Rst2_T1001Utilizadores] ADD  CONSTRAINT [DF_USR_Rst2_T1001Utilizadores_Bln1001Ativo]  DEFAULT ((1)) FOR [Bln1001Ativo]
GO
ALTER TABLE [dbo].[USR_RST3_UtilizadorDepartamento] ADD  CONSTRAINT [DF_USR_RST3_UtilizadorDepartamento_bitAtivo]  DEFAULT ((1)) FOR [bitAtivo]
GO
ALTER TABLE [dbo].[USR_RST3_UtilizadorDepartamento] ADD  CONSTRAINT [DF_USR_RST3_UtilizadorDepartamento_bitResponsavel]  DEFAULT ((0)) FOR [bitResponsavel]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[15] 2[6] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "USR_Rst2_T1003Perfis"
            Begin Extent = 
               Top = 223
               Left = 43
               Bottom = 316
               Right = 218
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "USR_Rst2_T1002AcessosMenus"
            Begin Extent = 
               Top = 80
               Left = 410
               Bottom = 290
               Right = 588
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "USR_Rst2_T1004Menus"
            Begin Extent = 
               Top = 82
               Left = 651
               Bottom = 190
               Right = 816
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'USR_Rst3_ImportLogin'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'USR_Rst3_ImportLogin'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "USR_Rst2_T1001Utilizadores"
            Begin Extent = 
               Top = 6
               Left = 481
               Bottom = 213
               Right = 691
            End
            DisplayFlags = 280
            TopColumn = 11
         End
         Begin Table = "USR_RST3_UtilizadorDepartamento"
            Begin Extent = 
               Top = 6
               Left = 254
               Bottom = 163
               Right = 443
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "USR_RST3_Departamento"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 102
               Right = 216
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1800
         Alias = 900
         Table = 3045
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'USR_Rst3_View_DepartamentoUtilizador'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'USR_Rst3_View_DepartamentoUtilizador'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "USR_Rst2_T1005MenusAcessos"
            Begin Extent = 
               Top = 10
               Left = 246
               Bottom = 103
               Right = 406
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "USR_Rst2_T1003Perfis"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 106
               Right = 213
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "USR_Rst2_T1004Menus"
            Begin Extent = 
               Top = 11
               Left = 448
               Bottom = 186
               Right = 613
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1935
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 2400
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'USR_Rst3_View_PerfisMenusAcessos'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'USR_Rst3_View_PerfisMenusAcessos'
GO


INSERT INTO [dbo].[USR_Rst2_T1003Perfis]
           ([StrT1003NomePerfil]
           ,[BitT1003Activo])
     VALUES
           ('Administrador'
           ,1)
GO

INSERT INTO [dbo].[USR_Rst2_T1001Utilizadores]
           ([IntT1001IdPerfil]
           ,[IntT1001IdEticadata]
           ,[StrT1001Login]
           ,[StrT1001Password]
           ,[StrT1001Utilizador]
           ,[Str1001Email]
           ,[Str1001Telemovel]
           ,[Str1001Telefone]
           ,[Str1001VoipUser]
           ,[Str1001VoipPassword]
           ,[Str1001Lingua]
           ,[Str1001SmtpServer]
           ,[Bln1001SuperUtilizador]
           ,[Bln1001Administrador]
           ,[Bln1001Formulas]
           ,[Bln1001NaoConforme]
           ,[Bln1001Alertas]
           ,[Bln1001Ativo])
     VALUES
           (1
           ,0
           ,'0000'
           ,'0000'
           ,'BETRACE'
           ,'geral@screen-in.pt'
           ,'+351968055384'
           ,'+351256181400'
           ,''
           ,''
           ,'Português'
           ,'mail.screen-in.com'
           ,1
           ,1
           ,1
           ,1
           ,1
           ,1)
GO