Proyecto

General

Perfil

Descargar (636 Bytes)

Feature #374 » script agregar campos ES_SuveyConfig.sql

Script nuevos campos y nueva tabla - Aracely Sánchez, 2024-11-14 23:57

 
ALTER TABLE "ES_SuveyConfig" add "Anonimo" BOOLEAN;
ALTER TABLE "ES_SuveyConfig" add "IdProyect" VARCHAR(5);
ALTER TABLE "ES_SuveyConfig" add "Token" VARCHAR(50);


CREATE TABLE IF NOT EXISTS public."ES_ProjectGroup"
(
"Id" integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
"IdEmpresa" integer NOT NULL,
"IdProject" integer,
"IdGroup" integer,
"NumEval" integer,
"TotEvalAsign" integer
CONSTRAINT "PK_ES_ProjectGroup" PRIMARY KEY ("Id")
)

TABLESPACE pg_default;

ALTER TABLE public."ES_ProjectGroup"
OWNER to azure_pg_admin;

    (1-1/1)