BANNER_COURSESET

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
1 min read
CREATE TABLE SAKAI_EXTERNAL.BANNER_COURSESET ( 
    EID             	VARCHAR2(59) NULL,
    TITLE           	VARCHAR2(90) NULL,
    DESCRIPTION     	VARCHAR2(90) NULL,
    CATEGORY        	VARCHAR2(10) NULL,
    PARENT          	VARCHAR2(255) NULL,
    CREATEDBY       	CHAR(6) NULL,
    CREATEDDATE     	DATE NULL,
    LASTMODIFIEDBY  	CHAR(6) NULL,
    LASTMODIFIEDDATE	DATE NULL 
    )
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE( INITIAL 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_COURSESET_PARENT_IDX
    ON SAKAI_EXTERNAL.BANNER_COURSESET(PARENT)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE UNIQUE INDEX SAKAI_EXTERNAL.BANNER_COURSESET_PIDX
    ON SAKAI_EXTERNAL.BANNER_COURSESET(EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_COURSESET TO SAKAI_EXTERNAL_SELECT
GO