|
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 |
|
| |
(Pour noter la ressource, cliquez sur Ecrire un avis) |
| |
pour pouvoir poster un avis |
| | |
| | |
Aucun avis ou commentaire ? Soyez le premier ! |
// Summary: <specify the procedure action> // Syntax: //[ <Result> = ] evento_lista_formularios () // // Parameters: // None // Example: // <Specify a usage example> // // Return value: PROCEDURE evento_lista_formularios()
WindowName is string = ""
<COMPILE IF Configuration="64-bit Windows executable" OR Configuration="Site">
<COMPILE IF Configuration="64-bit Windows executable"> // Enumerate the windows of a project WindowName = EnumElement(enumWindow) <END>
<COMPILE IF Configuration="Site"> // Enumerate the windows of a project WindowName = EnumElement(enumPage) <END>
// Browse all the windows arrayNameObj is array of strings
WHILE WindowName <> "" // Go to the next window WindowName = EnumElement(enumAll) Add(arrayNameObj,WindowName +" - enumAll") <COMPILE IF Configuration="Site"> WindowName = EnumElement(enumDynamicPage) Add(arrayNameObj,WindowName +" - enumDynamicPage") WindowName = EnumElement(enumPageTemplate) Add(arrayNameObj,WindowName +" - enumPageTemplate") <END> <COMPILE IF Configuration="64-bit Windows executable"> WindowName = EnumElement(enumInternalWindow) Add(arrayNameObj,WindowName +" - enumInternalWindow") WindowName = EnumElement(enumWindow) Add(arrayNameObj,WindowName +" - enumWindow") <END> WindowName = EnumElement(enumFirst) Add(arrayNameObj,WindowName +" - enumFirst") WindowName = EnumElement(enumExternalComponent) Add(arrayNameObj,WindowName +" - enumExternalComponent") WindowName = EnumElement(enumGPU) Add(arrayNameObj,WindowName +" - enumGPU") WindowName = EnumElement(enumQuery) Add(arrayNameObj,WindowName +" - enumQuery") WindowName = EnumElement(enumReport) Add(arrayNameObj,WindowName +" - enumReport") WindowName = EnumElement(enumReportTemplate) Add(arrayNameObj,WindowName +" - enumReportTemplate") WindowName = EnumElement(enumWindowTemplate) Add(arrayNameObj,WindowName +" - enumWindowTemplate") END
RESULT arrayNameObj
<END> |
| LISTAR OS CONTOLES E OBJETOS DE UMA JANELA OU PAGE
PROCEDURE evento_lista_objetos_gpw(ninstancia)
//variaiveis auxiliares i is int = 1 objs_form is string = "" sControlName is string = ""
ninstancia = ninstancia
<COMPILE IF Configuration<>"iOS application" AND Configuration<> "Android application"> arrayControles is array of string
IF ninstancia = 0 THEN RESULT "" ELSE NomeForm is string = m_Tabela[ninstancia].gs_nomeJanela WHEN EXCEPTION IN sControlName = gpwEnumControl(NomeForm, i) indirection is string = NoSpace(NomeForm) +"."+ NoSpace(sControlName) Add(arrayControles,indirection) LOOP(5000) // Next control i++ sControlName = gpwEnumControl(NomeForm, i) IF sControlName <> "" indirection = NoSpace(NomeForm) +"."+ NoSpace(sControlName) Add(arrayControles,indirection) Trace(indirection) ELSE BREAK END END RESULT arrayControles DO IF ExceptionInfo(errCode) THEN RESULT arrayControles END END END
<END> |
| | |
|