segescginf/meag14 repository overview

  CREATE SCHEMA [Apoio]
  GO
  
  /****** Object:  Table [Apoio].[User]  e [Apoio].[log_auto]  ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [Apoio].[User](
        [id] [bigint] IDENTITY(1,1) NOT NULL,
        [userNome] [varchar](150) NOT NULL,
        [userEmail] [varchar](150) NOT NULL,
        [password_hash] [varchar](128) NOT NULL,
        [email_confirmation_sent_on] [datetime] NULL,
        [email_confirmed] [bit] NULL,
        [email_confirmed_on] [datetime] NULL,
        [registered_on] [datetime] NULL,
        [last_logged_in] [datetime] NULL,
        [current_logged_in] [datetime] NULL,
        [userEnvia] [bit] NULL,
        [userAtivo] [bit] NULL,
        [avaliadorId] [bigint] NULL,
   CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
  (
  	[id] 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
  
  CREATE TABLE [Apoio].[log_auto](
        [id] [bigint] IDENTITY(1,1) NOT NULL,
        [data_hora] [datetime] NOT NULL,
        [user_id] [bigint] NOT NULL,
        [msg] [varchar](300) NOT NULL,
   CONSTRAINT [PK_log_auto] PRIMARY KEY CLUSTERED 
  (
  	[id] 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

  ALTER TABLE [Apoio].[log_auto]  WITH CHECK ADD  CONSTRAINT [FK_log_auto_user_id] FOREIGN KEY([user_id])
  REFERENCES [Apoio].[User] ([id])
  GO
  
  ALTER TABLE [Apoio].[log_auto] CHECK CONSTRAINT [FK_log_auto_user_id]
  GO

docker run -dp 5000:5000 -e DB_SERVER="servidor do banco sqlserver do sisgp" -e DB_PORT="1433" -e DB_DATABASE="DBSISGP" -e DB_USER="usuário de acesso ao banco" -e DB_PWD="senha de acesso ao banco" -e MAIL_SERVER="servidor de e-mail" -e MAIL_PORT="587" -e MAIL_USE_TLS="True" -e MAIL_USER="email que o APP irá utilizar" -e MAIL_PWD="senha do e-mail"  -e APIPGDME_URL="http://hom.api.programadegestao.economia.gov.br -> este é a url de testes" -e APIPGDME_AUTH_USER="user da credencial" -e APIPGDME_AUTH_PASSWORD="senha da credencial"  meag14:[TAG]