ALTER TABLE "tbl_Movie"
 DROP PRIMARY KEY CASCADE;

DROP TABLE "tbl_Movie" CASCADE CONSTRAINTS;

CREATE TABLE "tbl_Movie"
(
  ID                INTEGER,
  "Name_eng"        VARCHAR2(250 BYTE),
  "Name_rus"        VARCHAR2(250 BYTE),
  "Link_kinopoisk"  VARCHAR2(250 BYTE),
  "Link_imdb"       VARCHAR2(250 BYTE),
  "Length"          INTEGER,
  "Year"            INTEGER,
  "View_count"      INTEGER,
  "Name_eng_lang"   VARCHAR2(4 BYTE),
  "Name_1"          VARCHAR2(250 BYTE),
  "Name_1_lang"     VARCHAR2(4 BYTE)
)
TABLESPACE USERS
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index TS.SYS_C0014308.
--  The object is created when the parent object is created.

ALTER TABLE "tbl_Movie" ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);
