PC SOFT
DEPOT EN LIGNE
POUR WINDEVWEBDEV ET WINDEV MOBILE

SECWINDEV 27 - VERSAO 4.0 - ANALYSIS DE DADOS - EM DESENVOLVIMENTO
Publié par Boller
dans la catégorie Outils
Nouveautés



Description
SECWINDEV 27 - VERSAO 4.0 - ANALYSIS DE DADOS - EM DESENVOLVIMENTO

Nome oficial do projeto: SECWINDEV27

ADICIONADO AS TELAS DE CONEXAO A BASE DE DADOS TIPO SAAS E AO SERVIDOR SOCKET

SCRIPT SECWINDEV - VERSAO 27 WX - SCRIPT PARA RODAR NO POSTGRESQL

-- script generated by WINDEV on 13/09/2022 22:31:56
-- tables of anasecwindev.wda analysis
-- for postgresql

-- creating the sec00_config table
create table "sec00_config" (
"sec00_config_id" serial8 primary key not null ,
"sec00_descricao" varchar(1024) ,
"sec00_valor" text ,
"sec05_app_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec02_cnpj" varchar(20) );
create index "wdidx_sec00_config_sec00_descricao" on "sec00_config" ("sec00_descricao");
create index "wdidx_sec00_config_sec05_app_id" on "sec00_config" ("sec05_app_id");
create index "wdidx_sec00_config_sec02_cnpj" on "sec00_config" ("sec02_cnpj");

-- creating the sec00_config_bkp table
create table "sec00_config_bkp" (
"sec00_config_id" serial8 primary key not null ,
"sec00_descricao" varchar(1024) ,
"sec00_valor" text ,
"sec05_app_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec02_cnpj" varchar(20) );
create index "wdidx_sec00_config_bkp_sec00_descricao" on "sec00_config_bkp" ("sec00_descricao");
create index "wdidx_sec00_config_bkp_sec05_app_id" on "sec00_config_bkp" ("sec05_app_id");
create index "wdidx_sec00_config_bkp_sec02_cnpj" on "sec00_config_bkp" ("sec02_cnpj");

-- creating the sec01_users table
create table "sec01_users" (
"sec01_user_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec01_nome" varchar(100) unique ,
"sec01_login" varchar(50) not null unique ,
"sec01_senha" varchar(2048) ,
"sec01_supervisor" bool default false,
"sec01_administrador" bool default false,
"sec01_usuario" bool default false,
"sec01_status" bool default false,
"sec01_telefone" varchar(20) ,
"sec01_email" varchar(100) ,
"sec01_obs" text ,
"sec02_empresa_id" varchar(20) ,
"sec01_cep" varchar(20) ,
"sec01_endereco" varchar(50) ,
"sec01_numero" integer default 0,
"sec01_bairro" varchar(50) ,
"sec01_cidade" varchar(50) ,
"sec01_estado" varchar(2) ,
"sec01_pais" varchar(30) ,
"sec03_setor_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_trocar_senha" bool default false,
"sec04_grupo_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_data_expira" date ,
"sec01_token" varchar(2048) ,
"sec01_deletado" bool default false,
"sec01_id_audit" serial8 primary key not null ,
"sec01_diretoria" bool default false,
"sec01_bloqueado_ate" timestamp ,
"sec01_sexo" smallint default 0,
"sec01_nascimento" date ,
"sec01_pergunta_secreta" varchar(512) ,
"sec01_resposta_secreta" varchar(512) ,
"sec01_user_skin" varchar(50) ,
"sec01_cpf" varchar(15) unique );
create index "wdidx_sec01_users_sec01_senha" on "sec01_users" ("sec01_senha");
create index "wdidx_sec01_users_sec01_telefone" on "sec01_users" ("sec01_telefone");
create index "wdidx_sec01_users_sec01_email" on "sec01_users" ("sec01_email");
create index "wdidx_sec01_users_sec02_empresa_id" on "sec01_users" ("sec02_empresa_id");
create index "wdidx_sec01_users_sec01_cep" on "sec01_users" ("sec01_cep");
create index "wdidx_sec01_users_sec03_setor_id" on "sec01_users" ("sec03_setor_id");
create index "wdidx_sec01_users_sec04_grupo_id" on "sec01_users" ("sec04_grupo_id");
create index "wdidx_sec01_users_sec01_token" on "sec01_users" ("sec01_token");
create index "wdidx_sec01_users_sec01_sexo" on "sec01_users" ("sec01_sexo");
create index "wdidx_sec01_users_sec01_nascimento" on "sec01_users" ("sec01_nascimento");

-- creating the sec01_users_bkp table
create table "sec01_users_bkp" (
"sec01_user_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec01_nome" varchar(100) unique ,
"sec01_login" varchar(50) unique ,
"sec01_senha" varchar(2048) ,
"sec01_supervisor" bool default false,
"sec01_administrador" bool default false,
"sec01_usuario" bool default false,
"sec01_status" bool default false,
"sec01_telefone" varchar(20) ,
"sec01_email" varchar(100) ,
"sec01_obs" text ,
"sec02_empresa_id" varchar(20) ,
"sec01_cep" varchar(20) ,
"sec01_endereco" varchar(50) ,
"sec01_numero" integer default 0,
"sec01_bairro" varchar(50) ,
"sec01_cidade" varchar(50) ,
"sec01_estado" varchar(2) ,
"sec01_pais" varchar(30) ,
"sec03_setor_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_trocar_senha" bool default false,
"sec04_grupo_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_data_expira" date ,
"sec01_token" varchar(2048) ,
"sec01_deletado" bool default false,
"sec01_id_audit" serial8 primary key not null ,
"sec01_diretoria" bool default false,
"sec01_bloqueado_ate" timestamp ,
"sec01_sexo" smallint default 0,
"sec01_nascimento" date ,
"sec01_pergunta_secreta" varchar(512) ,
"sec01_resposta_secreta" varchar(512) ,
"sec01_user_skin" varchar(50) ,
"sec01_cpf" varchar(15) unique );
create index "wdidx_sec01_users_bkp_sec01_senha" on "sec01_users_bkp" ("sec01_senha");
create index "wdidx_sec01_users_bkp_sec01_telefone" on "sec01_users_bkp" ("sec01_telefone");
create index "wdidx_sec01_users_bkp_sec01_email" on "sec01_users_bkp" ("sec01_email");
create index "wdidx_sec01_users_bkp_sec02_empresa_id" on "sec01_users_bkp" ("sec02_empresa_id");
create index "wdidx_sec01_users_bkp_sec01_cep" on "sec01_users_bkp" ("sec01_cep");
create index "wdidx_sec01_users_bkp_sec03_setor_id" on "sec01_users_bkp" ("sec03_setor_id");
create index "wdidx_sec01_users_bkp_sec04_grupo_id" on "sec01_users_bkp" ("sec04_grupo_id");
create index "wdidx_sec01_users_bkp_sec01_token" on "sec01_users_bkp" ("sec01_token");
create index "wdidx_sec01_users_bkp_sec01_sexo" on "sec01_users_bkp" ("sec01_sexo");
create index "wdidx_sec01_users_bkp_sec01_nascimento" on "sec01_users_bkp" ("sec01_nascimento");

-- creating the sec02_empresas table
create table "sec02_empresas" (
"sec02_empresa_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec02_razao" varchar(100) unique ,
"sec02_fantasia" varchar(100) unique ,
"sec02_cnpj" varchar(20) not null unique ,
"sec02_endereco" varchar(100) ,
"sec02_numero" integer default 0,
"sec02_bairro" varchar(50) ,
"sec02_cidade" varchar(50) ,
"sec02_estado" varchar(2) ,
"sec02_pais" varchar(30) ,
"sec02_cep" varchar(20) ,
"sec02_cxpostal" varchar(20) ,
"sec02_telefone" varchar(20) ,
"sec02_email" varchar(100) ,
"sec02_logotipo" bytea ,
"sec02_obs" text ,
"sec02_id_audity" serial8 primary key not null ,
"sec02_host_ip_dns_db" varchar(255) ,
"sec02_database_db" varchar(255) ,
"sec02_user_db" varchar(255) ,
"sec02_password_db" varchar(255) ,
"sec02_porta_db" integer default 0);
create index "wdidx_sec02_empresas_sec02_cep" on "sec02_empresas" ("sec02_cep");

-- creating the sec02_empresas_bkp table
create table "sec02_empresas_bkp" (
"sec02_empresa_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec02_razao" varchar(100) unique ,
"sec02_fantasia" varchar(100) unique ,
"sec02_cnpj" varchar(20) unique ,
"sec02_endereco" varchar(100) ,
"sec02_numero" integer default 0,
"sec02_bairro" varchar(50) ,
"sec02_cidade" varchar(50) ,
"sec02_estado" varchar(2) ,
"sec02_pais" varchar(30) ,
"sec02_cep" varchar(20) ,
"sec02_cxpostal" varchar(20) ,
"sec02_telefone" varchar(20) ,
"sec02_email" varchar(100) ,
"sec02_logotipo" bytea ,
"sec02_obs" text ,
"sec02_id_audity" serial8 primary key not null ,
"sec02_host_ip_dns_db" varchar(255) ,
"sec02_database_db" varchar(255) ,
"sec02_user_db" varchar(255) ,
"sec02_password_db" varchar(255) ,
"sec02_porta_db" integer default 0);
create index "wdidx_sec02_empresas_bkp_sec02_cep" on "sec02_empresas_bkp" ("sec02_cep");

-- creating the sec03_setores table
create table "sec03_setores" (
"sec03_setor_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec03_setor" varchar(100) unique ,
"sec03_telefone_setor" varchar(20) ,
"sec03_id_audity" serial8 primary key not null ,
"sec03_ramal" varchar(10) );
create index "wdidx_sec03_setores_sec03_telefone_setor" on "sec03_setores" ("sec03_telefone_setor");

-- creating the sec04_grupos table
create table "sec04_grupos" (
"sec04_grupo_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec04_grupo" varchar(50) unique ,
"sec04_id_audity" serial8 primary key not null );

-- creating the sec05_apps table
create table "sec05_apps" (
"sec05_app_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec05_nome_app" varchar(100) not null unique ,
"sec02_cnpj" varchar(20) ,
"sec05_pin" bigint default 0,
"sec05_puk" bigint default 0,
"sec05_data_ativacao" timestamp ,
"sec05_data_expira" timestamp ,
"sec05_contra_senha" varchar(255) ,
"sec05_tipo_ativacao" smallint default 0,
"sec05_status" bool default false,
"sec05_checksum_modulos" integer default 0,
"sec05_versao" varchar(20) ,
"sec05_senha_ativacao" varchar(255) ,
"sec05_serial_hd" varchar(50) ,
"sec05_mac_address" varchar(50) ,
"sec05_id_audity" serial8 primary key not null ,
"sec05_qtde_terminais" integer default 0);
create index "wdidx_sec05_apps_sec02_cnpj" on "sec05_apps" ("sec02_cnpj");
create index "wdidx_sec05_apps_sec05_versao" on "sec05_apps" ("sec05_versao");

-- creating the sec05_apps_bkp table
create table "sec05_apps_bkp" (
"sec05_app_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec05_nome_app" varchar(100) unique ,
"sec02_cnpj" varchar(20) ,
"sec05_pin" bigint default 0,
"sec05_puk" bigint default 0,
"sec05_data_ativacao" timestamp ,
"sec05_data_expira" timestamp ,
"sec05_contra_senha" varchar(255) ,
"sec05_tipo_ativacao" smallint default 0,
"sec05_status" bool default false,
"sec05_checksum_modulos" integer default 0,
"sec05_versao" varchar(20) ,
"sec05_senha_ativacao" varchar(255) ,
"sec05_serial_hd" varchar(50) ,
"sec05_mac_address" varchar(50) ,
"sec05_id_audity" serial8 primary key not null ,
"sec05_qtde_terminais" integer default 0);
create index "wdidx_sec05_apps_bkp_sec02_cnpj" on "sec05_apps_bkp" ("sec02_cnpj");
create index "wdidx_sec05_apps_bkp_sec05_versao" on "sec05_apps_bkp" ("sec05_versao");

-- creating the sec06_app_modulos table
create table "sec06_app_modulos" (
"sec06_app_modulo_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec06_modulo" varchar(100) unique ,
"sec05_app_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec06_status" bool default false,
"sec06_id_audity" serial8 primary key not null );
create index "wdidx_sec06_app_modulos_sec05_app_id" on "sec06_app_modulos" ("sec05_app_id");
create index "wdidx_sec06_app_modulos_sec06_status" on "sec06_app_modulos" ("sec06_status");

-- creating the sec07_menu_dinamico table
create table "sec07_menu_dinamico" (
"sec07_menu_dinamico_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec07_menu" varchar(255) ,
"sec05_app_id" uuid ,
"sec07_status" bool default false,
"sec07_id_audity" serial8 primary key not null );
create index "wdidx_sec07_menu_dinamico_sec07_menu" on "sec07_menu_dinamico" ("sec07_menu");
create index "wdidx_sec07_menu_dinamico_sec05_app_id" on "sec07_menu_dinamico" ("sec05_app_id");
create index "wdidx_sec07_menu_dinamico_sec07_status" on "sec07_menu_dinamico" ("sec07_status");

-- creating the sec08_menu_item_dinamico table
create table "sec08_menu_item_dinamico" (
"sec08_menu_item_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec08_menu_item" varchar(255) ,
"sec07_menu_dinamico_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec08_status" bool default false,
"sec08_id_audity" serial8 primary key not null );
create index "wdidx_sec08_menu_item_dinamico_sec08_menu_item" on "sec08_menu_item_dinamico" ("sec08_menu_item");
create index "wdidx_sec08_menu_item_dinamico_sec07_menu_dinamico_id" on "sec08_menu_item_dinamico" ("sec07_menu_dinamico_id");
create index "wdidx_sec08_menu_item_dinamico_sec08_status" on "sec08_menu_item_dinamico" ("sec08_status");

-- creating the sec09_menu_subitem_dinamico table
create table "sec09_menu_subitem_dinamico" (
"sec08_menu_item_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec09_menu_subitem" varchar(255) ,
"sec07_menu_dinamico_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec09_menu_subitem_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec09_status" bool default false,
"sec09_id_audity" serial8 primary key not null );
create index "wdidx_sec09_menu_subitem_dinamico_sec08_menu_item_id" on "sec09_menu_subitem_dinamico" ("sec08_menu_item_id");
create index "wdidx_sec09_menu_subitem_dinamico_sec09_menu_subitem" on "sec09_menu_subitem_dinamico" ("sec09_menu_subitem");
create index "wdidx_sec09_menu_subitem_dinamico_sec07_menu_dinamico_id" on "sec09_menu_subitem_dinamico" ("sec07_menu_dinamico_id");
create index "wdidx_sec09_menu_subitem_dinamico_sec09_status" on "sec09_menu_subitem_dinamico" ("sec09_status");

-- creating the sec10_menu_x_users table
create table "sec10_menu_x_users" (
"sec10_menu_x_user_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec01_login" varchar(50) ,
"sec07_menu_dinamico_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec08_menu_item_id" uuid ,
"sec10_status" bool default false,
"sec09_menu_subitem_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec10_id_audity" serial8 primary key not null );
create index "wdidx_sec10_menu_x_users_sec01_login" on "sec10_menu_x_users" ("sec01_login");
create index "wdidx_sec10_menu_x_users_sec07_menu_dinamico_id" on "sec10_menu_x_users" ("sec07_menu_dinamico_id");
create index "wdidx_sec10_menu_x_users_sec08_menu_item_id" on "sec10_menu_x_users" ("sec08_menu_item_id");
create index "wdidx_sec10_menu_x_users_sec10_status" on "sec10_menu_x_users" ("sec10_status");
create index "wdidx_sec10_menu_x_users_sec09_menu_subitem_id" on "sec10_menu_x_users" ("sec09_menu_subitem_id");

-- creating the sec11_security_screen_report table
create table "sec11_security_screen_report" (
"sec11_security_screen_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec05_app_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec_name_screen" varchar(1024) ,
"sec11_id_audity" serial8 primary key not null );
create index "wdidx_sec11_security_screen_report_sec05_app_id" on "sec11_security_screen_report" ("sec05_app_id");
create index "wdidx_sec11_security_screen_report_sec_name_screen" on "sec11_security_screen_report" ("sec_name_screen");

-- creating the sec12_security_itens table
create table "sec12_security_itens" (
"sec12_security_item_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec11_security_screen_id" uuid ,
"sec12_name_item_screem" varchar(2048) ,
"sec12_id_audity" serial8 primary key not null ,
"sec12_tipo" smallint default 0);
create index "wdidx_sec12_security_itens_sec11_security_screen_id" on "sec12_security_itens" ("sec11_security_screen_id");
create index "wdidx_sec12_security_itens_sec12_name_item_screem" on "sec12_security_itens" ("sec12_name_item_screem");
create index "wdidx_sec12_security_itens_sec12_tipo" on "sec12_security_itens" ("sec12_tipo");

-- creating the sec13_historico_connect table
create table "sec13_historico_connect" (
"sec13_historico_connect_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec13_data_hora_conexao" timestamp ,
"sec13_data_hora_desconexao" timestamp ,
"sec13_ip" varchar(20) ,
"sec01_login" varchar(50) ,
"sec05_app_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec13_id_audity" serial8 primary key not null );
create index "wdidx_sec13_historico_connect_sec13_data_hora_conexao" on "sec13_historico_connect" ("sec13_data_hora_conexao");
create index "wdidx_sec13_historico_connect_sec13_data_hora_desconexao" on "sec13_historico_connect" ("sec13_data_hora_desconexao");
create index "wdidx_sec13_historico_connect_sec13_ip" on "sec13_historico_connect" ("sec13_ip");
create index "wdidx_sec13_historico_connect_sec01_login" on "sec13_historico_connect" ("sec01_login");
create index "wdidx_sec13_historico_connect_sec05_app_id" on "sec13_historico_connect" ("sec05_app_id");

-- creating the sec14_security_x_users table
create table "sec14_security_x_users" (
"sec12_security_item_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec14_security_x_user_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec11_security_screen_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_login" varchar(50) ,
"sec14_status_item_screen" integer default 0,
"sec14_id_audity" serial8 primary key not null ,
"sec01_responsavel" varchar(50) ,
"sec14_data_hora" timestamp );
create index "wdidx_sec14_security_x_users_sec12_security_item_id" on "sec14_security_x_users" ("sec12_security_item_id");
create index "wdidx_sec14_security_x_users_sec11_security_screen_id" on "sec14_security_x_users" ("sec11_security_screen_id");
create index "wdidx_sec14_security_x_users_sec01_login" on "sec14_security_x_users" ("sec01_login");
create index "wdidx_sec14_security_x_users_sec14_status_item_screen" on "sec14_security_x_users" ("sec14_status_item_screen");
create index "wdidx_sec14_security_x_users_sec01_responsavel" on "sec14_security_x_users" ("sec01_responsavel");
create index "wdidx_sec14_security_x_users_sec14_data_hora" on "sec14_security_x_users" ("sec14_data_hora");
create index "wdidx_sec14_security_x_users_sec14_chave_busca_janela_item" on "sec14_security_x_users" ("sec11_security_screen_id","sec12_security_item_id","sec01_login");
create index "wdidx_sec14_security_x_users_sec14_chave_busca_janela" on "sec14_security_x_users" ("sec11_security_screen_id","sec01_login");

-- creating the sec14_security_x_users_bkp table
create table "sec14_security_x_users_bkp" (
"sec12_security_item_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec14_security_x_user_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec11_security_screen_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_login" varchar(50) ,
"sec14_status_item_screen" integer default 0,
"sec14_id_audity" serial8 primary key not null ,
"sec01_responsavel" varchar(50) ,
"sec14_data_hora" timestamp );
create index "wdidx_sec14_security_x_users_bkp_sec12_security_item_id" on "sec14_security_x_users_bkp" ("sec12_security_item_id");
create index "wdidx_sec14_security_x_users_bkp_sec11_security_screen_id" on "sec14_security_x_users_bkp" ("sec11_security_screen_id");
create index "wdidx_sec14_security_x_users_bkp_sec01_login" on "sec14_security_x_users_bkp" ("sec01_login");
create index "wdidx_sec14_security_x_users_bkp_sec14_status_item_screen" on "sec14_security_x_users_bkp" ("sec14_status_item_screen");
create index "wdidx_sec14_security_x_users_bkp_sec01_responsavel" on "sec14_security_x_users_bkp" ("sec01_responsavel");
create index "wdidx_sec14_security_x_users_bkp_sec14_data_hora" on "sec14_security_x_users_bkp" ("sec14_data_hora");
create index "wdidx_sec14_security_x_users_bkp_sec14_chave_busca_janela_item" on "sec14_security_x_users_bkp" ("sec11_security_screen_id","sec12_security_item_id","sec01_login");
create index "wdidx_sec14_security_x_users_bkp_sec14_chave_busca_janela" on "sec14_security_x_users_bkp" ("sec11_security_screen_id","sec01_login");

-- creating the sec15_log_users_x_screens table
create table "sec15_log_users_x_screens" (
"sec15_log_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec15_data_hora" timestamp ,
"sec15_antes" text ,
"sec15_depois" text ,
"sec01_login" varchar(50) ,
"sec11_security_screen_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec15_acao" integer default 0,
"sec15_tabela" varchar(50) );
create index "wdidx_sec15_log_users_x_screens_sec15_data_hora" on "sec15_log_users_x_screens" ("sec15_data_hora");
create index "wdidx_sec15_log_users_x_screens_sec15_antes" on "sec15_log_users_x_screens" ("sec15_antes");
create index "wdidx_sec15_log_users_x_screens_sec15_depois" on "sec15_log_users_x_screens" ("sec15_depois");
create index "wdidx_sec15_log_users_x_screens_sec01_login" on "sec15_log_users_x_screens" ("sec01_login");
create index "wdidx_sec15_log_users_x_screens_sec11_security_screen_id" on "sec15_log_users_x_screens" ("sec11_security_screen_id");
create index "wdidx_sec15_log_users_x_screens_sec15_acao" on "sec15_log_users_x_screens" ("sec15_acao");
create index "wdidx_sec15_log_users_x_screens_sec15_tabela" on "sec15_log_users_x_screens" ("sec15_tabela");

-- creating the sec16_users_x_reports table
create table "sec16_users_x_reports" (
"sec16_user_x_report_id" uuid default gen_random_uuid() not null unique ,
"sec01_login" varchar(50) ,
"sec16_status" bool default false,
"sec11_security_screen_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_responsavel" varchar(50) ,
"sec16_data_hora" timestamp ,
"sec16_id_audity" serial8 primary key not null );
create index "wdidx_sec16_users_x_reports_sec01_login" on "sec16_users_x_reports" ("sec01_login");
create index "wdidx_sec16_users_x_reports_sec16_status" on "sec16_users_x_reports" ("sec16_status");
create index "wdidx_sec16_users_x_reports_sec11_security_screen_id" on "sec16_users_x_reports" ("sec11_security_screen_id");
create index "wdidx_sec16_users_x_reports_sec01_responsavel" on "sec16_users_x_reports" ("sec01_responsavel");
create index "wdidx_sec16_users_x_reports_sec16_data_hora" on "sec16_users_x_reports" ("sec16_data_hora");
create index "wdidx_sec16_users_x_reports_sec16_busca" on "sec16_users_x_reports" ("sec01_login","sec11_security_screen_id");

-- creating the sec17_senhas_antigas table
create table "sec17_senhas_antigas" (
"sec17_senhas_antiga_id" uuid default gen_random_uuid() primary key not null ,
"sec01_user_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec01_senha" varchar(2048) ,
"sec17_data_hora_troca" timestamp );
create index "wdidx_sec17_senhas_antigas_sec01_user_id" on "sec17_senhas_antigas" ("sec01_user_id");
create index "wdidx_sec17_senhas_antigas_sec01_senha" on "sec17_senhas_antigas" ("sec01_senha");
create index "wdidx_sec17_senhas_antigas_sec17_data_hora_troca" on "sec17_senhas_antigas" ("sec17_data_hora_troca");

-- creating the sec18_biometria table
create table "sec18_biometria" (
"sec18_biometria_id" serial8 primary key not null ,
"sec18_bio_finger_img" bytea ,
"sec18_bio_finger_txt" text ,
"sec01_login" varchar(50) );
create index "wdidx_sec18_biometria_sec18_bio_finger_txt" on "sec18_biometria" ("sec18_bio_finger_txt");
create index "wdidx_sec18_biometria_sec01_login" on "sec18_biometria" ("sec01_login");

-- creating the sec19_fotos table
create table "sec19_fotos" (
"sec19_foto_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec01_user_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec19_imagem" bytea ,
"sec19_id_audity" serial8 primary key not null );
create index "wdidx_sec19_fotos_sec01_user_id" on "sec19_fotos" ("sec01_user_id");

-- creating the sec20_schemas table
create table "sec20_schemas" (
"sec20_schema_id" uuid default gen_random_uuid() primary key not null ,
"sec02_empresa_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec20_schema" varchar(255) );
create index "wdidx_sec20_schemas_sec02_empresa_id" on "sec20_schemas" ("sec02_empresa_id");
create index "wdidx_sec20_schemas_sec20_schema" on "sec20_schemas" ("sec20_schema");

-- creating the sec21_maquinas_autorizadas table
create table "sec21_maquinas_autorizadas" (
"sec21_maquina_autorizada_id" uuid unique default '00000000-0000-0000-0000-000000000000',
"sec05_app_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec21_computador_name" varchar(50) ,
"sec21_autorizado" bool default false,
"sec01_user_id" uuid default '00000000-0000-0000-0000-000000000000',
"sec21_id_audity" serial8 primary key not null );
create index "wdidx_sec21_maquinas_autorizadas_sec05_app_id" on "sec21_maquinas_autorizadas" ("sec05_app_id");
create index "wdidx_sec21_maquinas_autorizadas_sec21_computador_name" on "sec21_maquinas_autorizadas" ("sec21_computador_name");
create index "wdidx_sec21_maquinas_autorizadas_sec21_autorizado" on "sec21_maquinas_autorizadas" ("sec21_autorizado");
create index "wdidx_sec21_maquinas_autorizadas_sec01_user_id" on "sec21_maquinas_autorizadas" ("sec01_user_id");
create index "wdidx_sec21_maquinas_autorizadas_sec21_busca" on "sec21_maquinas_autorizadas" ("sec05_app_id","sec01_user_id","sec21_computador_name");

-- creating the sec22_log_socket table
create table "sec22_log_socket" (
"sec22_log_socket_id" uuid not null unique default '00000000-0000-0000-0000-000000000000',
"sec22_data_hora_conexao" timestamp ,
"sec22_data_hora_desconexao" timestamp ,
"sec22_ip" varchar(50) ,
"sec22_ultima_acao" varchar(2048) ,
"sec22_socket" varchar(255) ,
"sec22_id_audity" bigint unique ,
"sec01_login" varchar(50) ,
"sec02_cnpj" varchar(20) ,
"sec05_nome_app" varchar(100) ,
"sec22_serial_hd" varchar(50) ,
"sec22_name_computer" varchar(50) );
create index "wdidx_sec22_log_socket_sec22_data_hora_conexao" on "sec22_log_socket" ("sec22_data_hora_conexao");
create index "wdidx_sec22_log_socket_sec22_data_hora_desconexao" on "sec22_log_socket" ("sec22_data_hora_desconexao");
create index "wdidx_sec22_log_socket_sec22_ip" on "sec22_log_socket" ("sec22_ip");
create index "wdidx_sec22_log_socket_sec22_ultima_acao" on "sec22_log_socket" ("sec22_ultima_acao");
create index "wdidx_sec22_log_socket_sec22_socket" on "sec22_log_socket" ("sec22_socket");
create index "wdidx_sec22_log_socket_sec01_login" on "sec22_log_socket" ("sec01_login");
create index "wdidx_sec22_log_socket_sec02_cnpj" on "sec22_log_socket" ("sec02_cnpj");
create index "wdidx_sec22_log_socket_sec05_nome_app" on "sec22_log_socket" ("sec05_nome_app");
create index "wdidx_sec22_log_socket_sec22_serial_hd" on "sec22_log_socket" ("sec22_serial_hd");
create index "wdidx_sec22_log_socket_sec22_name_computer" on "sec22_log_socket" ("sec22_name_computer");
-- integrity constraints
alter table "sec01_users" add foreign key ("sec02_empresa_id") references "sec02_empresas" ("sec02_cnpj");
alter table "sec01_users" add foreign key ("sec03_setor_id") references "sec03_setores" ("sec03_setor_id");
alter table "sec01_users" add foreign key ("sec04_grupo_id") references "sec04_grupos" ("sec04_grupo_id");
alter table "sec05_apps" add foreign key ("sec02_cnpj") references "sec02_empresas" ("sec02_cnpj");
alter table "sec06_app_modulos" add foreign key ("sec05_app_id") references "sec05_apps" ("sec05_app_id");
alter table "sec08_menu_item_dinamico" add foreign key ("sec07_menu_dinamico_id") references "sec07_menu_dinamico" ("sec07_menu_dinamico_id");
alter table "sec07_menu_dinamico" add foreign key ("sec05_app_id") references "sec05_apps" ("sec05_app_id");
alter table "sec00_config" add foreign key ("sec05_app_id") references "sec05_apps" ("sec05_app_id");
alter table "sec10_menu_x_users" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec10_menu_x_users" add foreign key ("sec07_menu_dinamico_id") references "sec07_menu_dinamico" ("sec07_menu_dinamico_id");
alter table "sec10_menu_x_users" add foreign key ("sec08_menu_item_id") references "sec08_menu_item_dinamico" ("sec08_menu_item_id");
alter table "sec09_menu_subitem_dinamico" add foreign key ("sec08_menu_item_id") references "sec08_menu_item_dinamico" ("sec08_menu_item_id");
alter table "sec09_menu_subitem_dinamico" add foreign key ("sec07_menu_dinamico_id") references "sec07_menu_dinamico" ("sec07_menu_dinamico_id");
alter table "sec10_menu_x_users" add foreign key ("sec09_menu_subitem_id") references "sec09_menu_subitem_dinamico" ("sec09_menu_subitem_id");
alter table "sec00_config" add foreign key ("sec02_cnpj") references "sec02_empresas" ("sec02_cnpj");
alter table "sec11_security_screen_report" add foreign key ("sec05_app_id") references "sec05_apps" ("sec05_app_id");
alter table "sec12_security_itens" add foreign key ("sec11_security_screen_id") references "sec11_security_screen_report" ("sec11_security_screen_id");
alter table "sec14_security_x_users" add foreign key ("sec11_security_screen_id") references "sec11_security_screen_report" ("sec11_security_screen_id");
alter table "sec14_security_x_users" add foreign key ("sec12_security_item_id") references "sec12_security_itens" ("sec12_security_item_id");
alter table "sec14_security_x_users" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec13_historico_connect" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec15_log_users_x_screens" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec15_log_users_x_screens" add foreign key ("sec11_security_screen_id") references "sec11_security_screen_report" ("sec11_security_screen_id");
alter table "sec22_log_socket" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec13_historico_connect" add foreign key ("sec05_app_id") references "sec05_apps" ("sec05_app_id");
alter table "sec22_log_socket" add foreign key ("sec05_nome_app") references "sec05_apps" ("sec05_nome_app");
alter table "sec22_log_socket" add foreign key ("sec02_cnpj") references "sec02_empresas" ("sec02_cnpj");
alter table "sec17_senhas_antigas" add foreign key ("sec01_user_id") references "sec01_users" ("sec01_user_id");
alter table "sec18_biometria" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec19_fotos" add foreign key ("sec01_user_id") references "sec01_users" ("sec01_user_id");
alter table "sec20_schemas" add foreign key ("sec02_empresa_id") references "sec02_empresas" ("sec02_empresa_id");
alter table "sec21_maquinas_autorizadas" add foreign key ("sec05_app_id") references "sec05_apps" ("sec05_app_id");
alter table "sec21_maquinas_autorizadas" add foreign key ("sec01_user_id") references "sec01_users" ("sec01_user_id");
alter table "sec16_users_x_reports" add foreign key ("sec01_login") references "sec01_users" ("sec01_login");
alter table "sec16_users_x_reports" add foreign key ("sec11_security_screen_id") references "sec11_security_screen_report" ("sec11_security_screen_id");


Prezados,

Se você usa e gosta do nosso atendimento e pode contribuir com as nossas atividades de suporte aqui no grupo de forma expontanea e mensal e queira fazer uma contribuição de qualquer valor para melhorarmos o nosso atendimento e manutenção dos nossos servidores, segue abaixo o link para fazer a sua doação:

https://www.paypal.com/donate/?hosted_button_id=JU7GAW6Q8YY42
Illustrations, copies d'écran
none
none
Avis des utilisateurs
(Pour noter la ressource, cliquez sur Ecrire un avis)
Aucun avis ou commentaire ? Soyez le premier !
A PROPOS
EVALUATION :
00Aucune évaluation
TELECHARGEMENTS :
32
MISE À JOUR :
06 octobre 2022
VERSION :
27
CONCERNE :
WINDEV, WEBDEV, WINDEV Mobile
Version minimale : 27
TAILLE :
3,9 Mo