Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.72 KB | None | 0 0
  1. --------------------------------------------------------
  2. -- File created - Friday-February-12-2016
  3. --------------------------------------------------------
  4. --------------------------------------------------------
  5. -- DDL for Table AUTHORS
  6. --------------------------------------------------------
  7.  
  8. CREATE TABLE "VADIM"."AUTHORS"
  9. ( "AUTH_ID" NUMBER(20,0),
  10. "AUTH_NAME" NVARCHAR2(30),
  11. "AUTH_EXPIRED" TIMESTAMP (6)
  12. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  13. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  14. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  15. TABLESPACE "SYSTEM" ;
  16. --------------------------------------------------------
  17. -- DDL for Table AUTHOR_NEWS
  18. --------------------------------------------------------
  19.  
  20. CREATE TABLE "VADIM"."AUTHOR_NEWS"
  21. ( "AUNE_NEWS_ID" NUMBER(20,0),
  22. "AUNE_AUTHOR_ID" NUMBER(20,0)
  23. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  24. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  25. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  26. TABLESPACE "SYSTEM" ;
  27. --------------------------------------------------------
  28. -- DDL for Table COMMENTS
  29. --------------------------------------------------------
  30.  
  31. CREATE TABLE "VADIM"."COMMENTS"
  32. ( "COMM_ID" NUMBER(20,0),
  33. "COMM_NEWS_ID" NUMBER(20,0),
  34. "COMM_TEXT" NVARCHAR2(100),
  35. "COMM_CREATION_DATE" TIMESTAMP (6)
  36. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  37. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  38. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  39. TABLESPACE "SYSTEM" ;
  40. --------------------------------------------------------
  41. -- DDL for Table NEWS
  42. --------------------------------------------------------
  43.  
  44. CREATE TABLE "VADIM"."NEWS"
  45. ( "NEWS_ID" NUMBER(20,0),
  46. "NEWS_TITLE" NVARCHAR2(30),
  47. "NEWS_SHORT_TEXT" NVARCHAR2(100),
  48. "NEWS_FULL_TEXT" NVARCHAR2(2000),
  49. "NEWS_CREATION_DATE" TIMESTAMP (6),
  50. "NEWS_MODIFICATION_DATE" DATE
  51. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  52. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  53. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  54. TABLESPACE "SYSTEM" ;
  55. --------------------------------------------------------
  56. -- DDL for Table NEWS_TAGS
  57. --------------------------------------------------------
  58.  
  59. CREATE TABLE "VADIM"."NEWS_TAGS"
  60. ( "NETA_NEWS_ID" NUMBER(20,0),
  61. "NETA_TAG_ID" NUMBER(20,0)
  62. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  63. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  64. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  65. TABLESPACE "SYSTEM" ;
  66. --------------------------------------------------------
  67. -- DDL for Table ROLES
  68. --------------------------------------------------------
  69.  
  70. CREATE TABLE "VADIM"."ROLES"
  71. ( "ROLS_USER_ID" NUMBER(20,0),
  72. "ROLS_NAME" VARCHAR2(50 BYTE)
  73. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  74. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  75. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  76. TABLESPACE "SYSTEM" ;
  77. --------------------------------------------------------
  78. -- DDL for Table TAGS
  79. --------------------------------------------------------
  80.  
  81. CREATE TABLE "VADIM"."TAGS"
  82. ( "TAGS_ID" NUMBER(20,0),
  83. "TAGS_NAME" VARCHAR2(30 BYTE)
  84. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  85. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  86. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  87. TABLESPACE "SYSTEM" ;
  88. --------------------------------------------------------
  89. -- DDL for Table USERS
  90. --------------------------------------------------------
  91.  
  92. CREATE TABLE "VADIM"."USERS"
  93. ( "USRS_ID" NUMBER(20,0),
  94. "USRS_NAME" NVARCHAR2(50),
  95. "USRS_LOGIN" VARCHAR2(30 BYTE),
  96. "USRS_PASSWORD" VARCHAR2(30 BYTE)
  97. ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  98. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  99. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  100. TABLESPACE "SYSTEM" ;
  101. REM INSERTING into VADIM.AUTHORS
  102. SET DEFINE OFF;
  103. Insert into VADIM.AUTHORS (AUTH_ID,AUTH_NAME,AUTH_EXPIRED) values (0,'AUTHOR',null);
  104. REM INSERTING into VADIM.AUTHOR_NEWS
  105. SET DEFINE OFF;
  106. REM INSERTING into VADIM.COMMENTS
  107. SET DEFINE OFF;
  108. REM INSERTING into VADIM.NEWS
  109. SET DEFINE OFF;
  110. REM INSERTING into VADIM.NEWS_TAGS
  111. SET DEFINE OFF;
  112. REM INSERTING into VADIM.ROLES
  113. SET DEFINE OFF;
  114. REM INSERTING into VADIM.TAGS
  115. SET DEFINE OFF;
  116. REM INSERTING into VADIM.USERS
  117. SET DEFINE OFF;
  118. --------------------------------------------------------
  119. -- DDL for Index AUTHORS_PK
  120. --------------------------------------------------------
  121.  
  122. CREATE UNIQUE INDEX "VADIM"."AUTHORS_PK" ON "VADIM"."AUTHORS" ("AUTH_ID")
  123. PCTFREE 10 INITRANS 2 MAXTRANS 255
  124. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  125. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  126. TABLESPACE "SYSTEM" ;
  127. --------------------------------------------------------
  128. -- DDL for Index NEWS_PK
  129. --------------------------------------------------------
  130.  
  131. CREATE UNIQUE INDEX "VADIM"."NEWS_PK" ON "VADIM"."NEWS" ("NEWS_ID")
  132. PCTFREE 10 INITRANS 2 MAXTRANS 255
  133. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  134. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  135. TABLESPACE "SYSTEM" ;
  136. --------------------------------------------------------
  137. -- DDL for Index COMMENTS_PK
  138. --------------------------------------------------------
  139.  
  140. CREATE UNIQUE INDEX "VADIM"."COMMENTS_PK" ON "VADIM"."COMMENTS" ("COMM_ID")
  141. PCTFREE 10 INITRANS 2 MAXTRANS 255
  142. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  143. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  144. TABLESPACE "SYSTEM" ;
  145. --------------------------------------------------------
  146. -- DDL for Index USERS_PK
  147. --------------------------------------------------------
  148.  
  149. CREATE UNIQUE INDEX "VADIM"."USERS_PK" ON "VADIM"."USERS" ("USRS_ID")
  150. PCTFREE 10 INITRANS 2 MAXTRANS 255
  151. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  152. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  153. TABLESPACE "SYSTEM" ;
  154. --------------------------------------------------------
  155. -- DDL for Index TAGS_PK
  156. --------------------------------------------------------
  157.  
  158. CREATE UNIQUE INDEX "VADIM"."TAGS_PK" ON "VADIM"."TAGS" ("TAGS_ID")
  159. PCTFREE 10 INITRANS 2 MAXTRANS 255
  160. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  161. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  162. TABLESPACE "SYSTEM" ;
  163. --------------------------------------------------------
  164. -- Constraints for Table ROLES
  165. --------------------------------------------------------
  166.  
  167. ALTER TABLE "VADIM"."ROLES" MODIFY ("ROLS_USER_ID" NOT NULL ENABLE);
  168.  
  169. ALTER TABLE "VADIM"."ROLES" MODIFY ("ROLS_NAME" NOT NULL ENABLE);
  170. --------------------------------------------------------
  171. -- Constraints for Table COMMENTS
  172. --------------------------------------------------------
  173.  
  174. ALTER TABLE "VADIM"."COMMENTS" ADD CONSTRAINT "COMMENTS_PK" PRIMARY KEY ("COMM_ID")
  175. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  176. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  177. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  178. TABLESPACE "SYSTEM" ENABLE;
  179.  
  180. ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_NEWS_ID" NOT NULL ENABLE);
  181.  
  182. ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_TEXT" NOT NULL ENABLE);
  183.  
  184. ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_CREATION_DATE" NOT NULL ENABLE);
  185.  
  186. ALTER TABLE "VADIM"."COMMENTS" MODIFY ("COMM_ID" NOT NULL ENABLE);
  187. --------------------------------------------------------
  188. -- Constraints for Table NEWS_TAGS
  189. --------------------------------------------------------
  190.  
  191. ALTER TABLE "VADIM"."NEWS_TAGS" MODIFY ("NETA_NEWS_ID" NOT NULL ENABLE);
  192.  
  193. ALTER TABLE "VADIM"."NEWS_TAGS" MODIFY ("NETA_TAG_ID" NOT NULL ENABLE);
  194. --------------------------------------------------------
  195. -- Constraints for Table USERS
  196. --------------------------------------------------------
  197.  
  198. ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_NAME" NOT NULL ENABLE);
  199.  
  200. ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_LOGIN" NOT NULL ENABLE);
  201.  
  202. ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_PASSWORD" NOT NULL ENABLE);
  203.  
  204. ALTER TABLE "VADIM"."USERS" MODIFY ("USRS_ID" NOT NULL ENABLE);
  205.  
  206. ALTER TABLE "VADIM"."USERS" ADD CONSTRAINT "USERS_PK" PRIMARY KEY ("USRS_ID")
  207. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  208. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  209. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  210. TABLESPACE "SYSTEM" ENABLE;
  211. --------------------------------------------------------
  212. -- Constraints for Table AUTHOR_NEWS
  213. --------------------------------------------------------
  214.  
  215. ALTER TABLE "VADIM"."AUTHOR_NEWS" MODIFY ("AUNE_NEWS_ID" NOT NULL ENABLE);
  216.  
  217. ALTER TABLE "VADIM"."AUTHOR_NEWS" MODIFY ("AUNE_AUTHOR_ID" NOT NULL ENABLE);
  218. --------------------------------------------------------
  219. -- Constraints for Table TAGS
  220. --------------------------------------------------------
  221.  
  222. ALTER TABLE "VADIM"."TAGS" MODIFY ("TAGS_ID" NOT NULL ENABLE);
  223.  
  224. ALTER TABLE "VADIM"."TAGS" MODIFY ("TAGS_NAME" NOT NULL ENABLE);
  225.  
  226. ALTER TABLE "VADIM"."TAGS" ADD CONSTRAINT "TAGS_PK" PRIMARY KEY ("TAGS_ID")
  227. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  228. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  229. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  230. TABLESPACE "SYSTEM" ENABLE;
  231. --------------------------------------------------------
  232. -- Constraints for Table AUTHORS
  233. --------------------------------------------------------
  234.  
  235. ALTER TABLE "VADIM"."AUTHORS" ADD CONSTRAINT "AUTHORS_PK" PRIMARY KEY ("AUTH_ID")
  236. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  237. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  238. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  239. TABLESPACE "SYSTEM" ENABLE;
  240.  
  241. ALTER TABLE "VADIM"."AUTHORS" MODIFY ("AUTH_ID" NOT NULL ENABLE);
  242.  
  243. ALTER TABLE "VADIM"."AUTHORS" MODIFY ("AUTH_NAME" NOT NULL ENABLE);
  244. --------------------------------------------------------
  245. -- Constraints for Table NEWS
  246. --------------------------------------------------------
  247.  
  248. ALTER TABLE "VADIM"."NEWS" ADD CONSTRAINT "NEWS_PK" PRIMARY KEY ("NEWS_ID")
  249. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  250. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  251. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  252. TABLESPACE "SYSTEM" ENABLE;
  253.  
  254. ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_ID" NOT NULL ENABLE);
  255.  
  256. ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_TITLE" NOT NULL ENABLE);
  257.  
  258. ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_SHORT_TEXT" NOT NULL ENABLE);
  259.  
  260. ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_FULL_TEXT" NOT NULL ENABLE);
  261.  
  262. ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_MODIFICATION_DATE" NOT NULL ENABLE);
  263.  
  264. ALTER TABLE "VADIM"."NEWS" MODIFY ("NEWS_CREATION_DATE" NOT NULL ENABLE);
  265. --------------------------------------------------------
  266. -- Ref Constraints for Table AUTHOR_NEWS
  267. --------------------------------------------------------
  268.  
  269. ALTER TABLE "VADIM"."AUTHOR_NEWS" ADD CONSTRAINT "AUNE_AUTH_AUTHOR_ID" FOREIGN KEY ("AUNE_NEWS_ID")
  270. REFERENCES "VADIM"."AUTHORS" ("AUTH_ID") ENABLE;
  271.  
  272. ALTER TABLE "VADIM"."AUTHOR_NEWS" ADD CONSTRAINT "AUNE_NEWS_NEWS_ID" FOREIGN KEY ("AUNE_NEWS_ID")
  273. REFERENCES "VADIM"."NEWS" ("NEWS_ID") ENABLE;
  274. --------------------------------------------------------
  275. -- Ref Constraints for Table COMMENTS
  276. --------------------------------------------------------
  277.  
  278. ALTER TABLE "VADIM"."COMMENTS" ADD CONSTRAINT "COMM_NEWS_NEWS_ID" FOREIGN KEY ("COMM_ID")
  279. REFERENCES "VADIM"."NEWS" ("NEWS_ID") ENABLE;
  280. --------------------------------------------------------
  281. -- Ref Constraints for Table NEWS_TAGS
  282. --------------------------------------------------------
  283.  
  284. ALTER TABLE "VADIM"."NEWS_TAGS" ADD CONSTRAINT "NETA_NEWS_NEWS_ID" FOREIGN KEY ("NETA_NEWS_ID")
  285. REFERENCES "VADIM"."NEWS" ("NEWS_ID") ENABLE;
  286.  
  287. ALTER TABLE "VADIM"."NEWS_TAGS" ADD CONSTRAINT "NETA_TAGS_TAG_ID" FOREIGN KEY ("NETA_NEWS_ID")
  288. REFERENCES "VADIM"."TAGS" ("TAGS_ID") ENABLE;
  289. --------------------------------------------------------
  290. -- Ref Constraints for Table ROLES
  291. --------------------------------------------------------
  292.  
  293. ALTER TABLE "VADIM"."ROLES" ADD CONSTRAINT "ROLES_FK1" FOREIGN KEY ("ROLS_USER_ID")
  294. REFERENCES "VADIM"."USERS" ("USRS_ID") ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement