SQLize | PHPize | SQLtest

CREATE DATABASE [AccessCorpUsers]; GO USE [AccessCorpUsers] GO ALTER ROLE [db_owner] ADD MEMBER [accesscorpusersa] GO /****** Object: User [accesscorpusersa] Script Date: 13/05/2025 20:30:36 ******/ CREATE USER [accesscorpusersa] FOR LOGIN [accesscorpusersa] WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: Table [dbo].[__EFMigrationsHistory] Script Date: 13/05/2025 20:30:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[__EFMigrationsHistory]( [MigrationId] [nvarchar](150) NOT NULL, [ProductVersion] [nvarchar](32) NOT NULL, CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY CLUSTERED ( [MigrationId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Administrators] Script Date: 13/05/2025 20:30:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Administrators]( [Id] [uniqueidentifier] NOT NULL, [Name] [nvarchar](max) NOT NULL, [LastName] [nvarchar](max) NOT NULL, [Email] [nvarchar](max) NOT NULL, [Phone] [nvarchar](max) NOT NULL, [Cpf] [nvarchar](max) NOT NULL, [Cep] [nvarchar](max) NOT NULL, [HouseNumber] [int] NOT NULL, [Password] [nvarchar](max) NOT NULL, [IdentityId] [uniqueidentifier] NOT NULL, [Image] [nvarchar](max) NOT NULL, [ImageUpload] [varbinary](max) NOT NULL, CONSTRAINT [PK_Administrators] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Deliveries] Script Date: 13/05/2025 20:30:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Deliveries]( [Id] [uniqueidentifier] NOT NULL, [Receiver] [nvarchar](max) NOT NULL, [DeliveryDate] [datetime2](7) NOT NULL, [Enterprise] [nvarchar](max) NOT NULL, [DeliveredTo] [nvarchar](max) NOT NULL, [NumberHouse] [int] NOT NULL, [Cep] [nvarchar](max) NOT NULL, CONSTRAINT [PK_Deliveries] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Doormans] Script Date: 13/05/2025 20:30:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Doormans]( [Id] [uniqueidentifier] NOT NULL, [Name] [nvarchar](max) NOT NULL, [LastName] [nvarchar](max) NOT NULL, [Email] [nvarchar](max) NOT NULL, [Phone] [nvarchar](max) NOT NULL, [Cpf] [nvarchar](max) NOT NULL, [Cep] [nvarchar](max) NOT NULL, [Password] [nvarchar](max) NOT NULL, [IdentityId] [uniqueidentifier] NOT NULL, [AdministratorId] [uniqueidentifier] NULL, CONSTRAINT [PK_Doormans] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Guests] Script Date: 13/05/2025 20:30:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Guests]( [Id] [uniqueidentifier] NOT NULL, [Name] [nvarchar](max) NOT NULL, [LastName] [nvarchar](max) NOT NULL, [Email] [nvarchar](max) NOT NULL, [Phone] [nvarchar](max) NOT NULL, [Cpf] [nvarchar](max) NOT NULL, [DoormanId] [uniqueidentifier] NULL, [Cep] [nvarchar](max) NOT NULL, [CepGuest] [nvarchar](max) NOT NULL, CONSTRAINT [PK_Guests] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Residents] Script Date: 13/05/2025 20:30:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Residents]( [Id] [uniqueidentifier] NOT NULL, [Name] [nvarchar](max) NOT NULL, [LastName] [nvarchar](max) NOT NULL, [Email] [nvarchar](max) NOT NULL, [Phone] [nvarchar](max) NOT NULL, [Cpf] [nvarchar](max) NOT NULL, [Cep] [nvarchar](max) NOT NULL, [HouseNumber] [int] NOT NULL, [AdministratorId] [uniqueidentifier] NULL, [Image] [nvarchar](max) NOT NULL, [ImageUpload] [varbinary](max) NOT NULL, CONSTRAINT [PK_Residents] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[Administrators] ADD DEFAULT (N'') FOR [Image] GO ALTER TABLE [dbo].[Administrators] ADD DEFAULT (0x) FOR [ImageUpload] GO ALTER TABLE [dbo].[Guests] ADD DEFAULT (N'') FOR [Cep] GO ALTER TABLE [dbo].[Guests] ADD DEFAULT (N'') FOR [CepGuest] GO ALTER TABLE [dbo].[Residents] ADD DEFAULT (N'') FOR [Image] GO ALTER TABLE [dbo].[Residents] ADD DEFAULT (0x) FOR [ImageUpload] GO ALTER TABLE [dbo].[Doormans] WITH CHECK ADD CONSTRAINT [FK_Doormans_Administrators_AdministratorId] FOREIGN KEY([AdministratorId]) REFERENCES [dbo].[Administrators] ([Id]) GO ALTER TABLE [dbo].[Doormans] CHECK CONSTRAINT [FK_Doormans_Administrators_AdministratorId] GO ALTER TABLE [dbo].[Guests] WITH CHECK ADD CONSTRAINT [FK_Guests_Doormans_DoormanId] FOREIGN KEY([DoormanId]) REFERENCES [dbo].[Doormans] ([Id]) GO ALTER TABLE [dbo].[Guests] CHECK CONSTRAINT [FK_Guests_Doormans_DoormanId] GO ALTER TABLE [dbo].[Residents] WITH CHECK ADD CONSTRAINT [FK_Residents_Administrators_AdministratorId] FOREIGN KEY([AdministratorId]) REFERENCES [dbo].[Administrators] ([Id]) GO ALTER TABLE [dbo].[Residents] CHECK CONSTRAINT [FK_Residents_Administrators_AdministratorId] GO