Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------
- -- File created - Friday-February-12-2016
- --------------------------------------------------------
- --------------------------------------------------------
- -- DDL for Table AUTHORS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."AUTHORS"
- ( "AUTH_ID" NUMBER(20,0),
- "AUTH_NAME" NVARCHAR2(30),
- "AUTH_EXPIRED" TIMESTAMP (6)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table AUTHOR_NEWS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."AUTHOR_NEWS"
- ( "AUNE_NEWS_ID" NUMBER(20,0),
- "AUNE_AUTHOR_ID" NUMBER(20,0)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table COMMENTS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."COMMENTS"
- ( "COMM_ID" NUMBER(20,0),
- "COMM_NEWS_ID" NUMBER(20,0),
- "COMM_TEXT" NVARCHAR2(100),
- "COMM_CREATION_DATE" TIMESTAMP (6)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table NEWS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."NEWS"
- ( "NEWS_ID" NUMBER(20,0),
- "NEWS_TITLE" NVARCHAR2(30),
- "NEWS_SHORT_TEXT" NVARCHAR2(100),
- "NEWS_FULL_TEXT" NVARCHAR2(2000),
- "NEWS_CREATION_DATE" TIMESTAMP (6),
- "NEWS_MODIFICATION_DATE" DATE
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table NEWS_TAGS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."NEWS_TAGS"
- ( "NETA_NEWS_ID" NUMBER(20,0),
- "NETA_TAG_ID" NUMBER(20,0)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table ROLES
- --------------------------------------------------------
- CREATE TABLE "VADIM"."ROLES"
- ( "ROLS_USER_ID" NUMBER(20,0),
- "ROLS_NAME" VARCHAR2(50 BYTE)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table TAGS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."TAGS"
- ( "TAGS_ID" NUMBER(20,0),
- "TAGS_NAME" VARCHAR2(30 BYTE)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table USERS
- --------------------------------------------------------
- CREATE TABLE "VADIM"."USERS"
- ( "USRS_ID" NUMBER(20,0),
- "USRS_NAME" NVARCHAR2(50),
- "USRS_LOGIN" VARCHAR2(30 BYTE),
- "USRS_PASSWORD" VARCHAR2(30 BYTE)
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- REM INSERTING into VADIM.AUTHORS
- SET DEFINE OFF;
- Insert into VADIM.AUTHORS (AUTH_ID,AUTH_NAME,AUTH_EXPIRED) values (0,'AUTHOR',null);
- REM INSERTING into VADIM.AUTHOR_NEWS
- SET DEFINE OFF;
- REM INSERTING into VADIM.COMMENTS
- SET DEFINE OFF;
- REM INSERTING into VADIM.NEWS
- SET DEFINE OFF;
- REM INSERTING into VADIM.NEWS_TAGS
- SET DEFINE OFF;
- REM INSERTING into VADIM.ROLES
- SET DEFINE OFF;
- REM INSERTING into VADIM.TAGS
- SET DEFINE OFF;
- REM INSERTING into VADIM.USERS
- SET DEFINE OFF;
- --------------------------------------------------------
- -- DDL for Index AUTHORS_PK
- --------------------------------------------------------
- CREATE UNIQUE INDEX "VADIM"."AUTHORS_PK" ON "VADIM"."AUTHORS" ("AUTH_ID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Index NEWS_PK
- --------------------------------------------------------
- CREATE UNIQUE INDEX "VADIM"."NEWS_PK" ON "VADIM"."NEWS" ("NEWS_ID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Index COMMENTS_PK
- --------------------------------------------------------
- CREATE UNIQUE INDEX "VADIM"."COMMENTS_PK" ON "VADIM"."COMMENTS" ("COMM_ID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Index USERS_PK
- --------------------------------------------------------
- CREATE UNIQUE INDEX "VADIM"."USERS_PK" ON "VADIM"."USERS" ("USRS_ID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Index TAGS_PK
- --------------------------------------------------------
- CREATE UNIQUE INDEX "VADIM"."TAGS_PK" ON "VADIM"."TAGS" ("TAGS_ID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- Constraints for Table ROLES
- --------------------------------------------------------
- ALTER TABLE "VADIM"."ROLES" MODIFY ("ROLS_USER_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."ROLES" MODIFY ("ROLS_NAME" NOT NULL ENABLE);
- --------------------------------------------------------
- -- Constraints for Table COMMENTS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."COMMENTS" ADD CONSTRAINT "COMMENTS_PK" PRIMARY KEY ("COMM_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_NEWS_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_TEXT" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_CREATION_DATE" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_ID" NOT NULL ENABLE);
- --------------------------------------------------------
- -- Constraints for Table NEWS_TAGS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."NEWS_TAGS" MODIFY ("NETA_NEWS_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."NEWS_TAGS" MODIFY ("NETA_TAG_ID" NOT NULL ENABLE);
- --------------------------------------------------------
- -- Constraints for Table USERS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_NAME" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_LOGIN" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_PASSWORD" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."USERS" ADD CONSTRAINT "USERS_PK" PRIMARY KEY ("USRS_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- --------------------------------------------------------
- -- Constraints for Table AUTHOR_NEWS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."AUTHOR_NEWS" MODIFY ("AUNE_NEWS_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."AUTHOR_NEWS" MODIFY ("AUNE_AUTHOR_ID" NOT NULL ENABLE);
- --------------------------------------------------------
- -- Constraints for Table TAGS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."TAGS" MODIFY ("TAGS_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."TAGS" MODIFY ("TAGS_NAME" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."TAGS" ADD CONSTRAINT "TAGS_PK" PRIMARY KEY ("TAGS_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- --------------------------------------------------------
- -- Constraints for Table AUTHORS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."AUTHORS" ADD CONSTRAINT "AUTHORS_PK" PRIMARY KEY ("AUTH_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- ALTER TABLE "VADIM"."AUTHORS" MODIFY ("AUTH_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."AUTHORS" MODIFY ("AUTH_NAME" NOT NULL ENABLE);
- --------------------------------------------------------
- -- Constraints for Table NEWS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."NEWS" ADD CONSTRAINT "NEWS_PK" PRIMARY KEY ("NEWS_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_ID" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_TITLE" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_SHORT_TEXT" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_FULL_TEXT" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_MODIFICATION_DATE" NOT NULL ENABLE);
- ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_CREATION_DATE" NOT NULL ENABLE);
- --------------------------------------------------------
- -- Ref Constraints for Table AUTHOR_NEWS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."AUTHOR_NEWS" ADD CONSTRAINT "AUNE_AUTH_AUTHOR_ID" FOREIGN KEY ("AUNE_NEWS_ID")
- REFERENCES "VADIM"."AUTHORS" ("AUTH_ID") ENABLE;
- ALTER TABLE "VADIM"."AUTHOR_NEWS" ADD CONSTRAINT "AUNE_NEWS_NEWS_ID" FOREIGN KEY ("AUNE_NEWS_ID")
- REFERENCES "VADIM"."NEWS" ("NEWS_ID") ENABLE;
- --------------------------------------------------------
- -- Ref Constraints for Table COMMENTS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."COMMENTS" ADD CONSTRAINT "COMM_NEWS_NEWS_ID" FOREIGN KEY ("COMM_ID")
- REFERENCES "VADIM"."NEWS" ("NEWS_ID") ENABLE;
- --------------------------------------------------------
- -- Ref Constraints for Table NEWS_TAGS
- --------------------------------------------------------
- ALTER TABLE "VADIM"."NEWS_TAGS" ADD CONSTRAINT "NETA_NEWS_NEWS_ID" FOREIGN KEY ("NETA_NEWS_ID")
- REFERENCES "VADIM"."NEWS" ("NEWS_ID") ENABLE;
- ALTER TABLE "VADIM"."NEWS_TAGS" ADD CONSTRAINT "NETA_TAGS_TAG_ID" FOREIGN KEY ("NETA_NEWS_ID")
- REFERENCES "VADIM"."TAGS" ("TAGS_ID") ENABLE;
- --------------------------------------------------------
- -- Ref Constraints for Table ROLES
- --------------------------------------------------------
- ALTER TABLE "VADIM"."ROLES" ADD CONSTRAINT "ROLES_FK1" FOREIGN KEY ("ROLS_USER_ID")
- REFERENCES "VADIM"."USERS" ("USRS_ID") ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement