CREATE TABLE PAINELORDERINDIC
(
    NRPAINELORDERINDIC      NUMBER         NOT NULL,
    CDOPERADOR              VARCHAR2(12)   NOT NULL,
    DASHGU                  VARCHAR2(2500) NOT NULL,
    DASHGO                  VARCHAR2(2500) NOT NULL,
    DASHTD                  VARCHAR2(2500) NOT NULL,
    DASHTA                  VARCHAR2(2500) NOT NULL,
	NRORG                   NUMBER 	       DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
    IDATIVO                 VARCHAR2(1)    DEFAULT 'S'					NOT NULL,
    DTINCLUSAO              DATE           DEFAULT SYSDATE,
    DTULTATU                DATE           DEFAULT SYSDATE,
    NRORGINCLUSAO           NUMBER         DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERINCLUSAO          VARCHAR2(12)   DEFAULT '1' 					NULL,
    NRORGULTATU             NUMBER         DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERULTATU            VARCHAR2(12)   DEFAULT '1',
		CONSTRAINT CKC_IDATIVO_PAINELORDERINDIC CHECK (IDATIVO IN ('S','N')),
		CONSTRAINT PK_PAINELORDERINDIC PRIMARY KEY (NRPAINELORDERINDIC)
)
/

ALTER TABLE FAVORITOS ADD PROJECT_ID NUMBER
/