text: --------------------------------------------------------
  --  File created - ×åòâúðòúê-Àïðèë-17-2014   
  --------------------------------------------------------
  --------------------------------------------------------
  --  DDL for Table ARTICLE
  --------------------------------------------------------
  
    CREATE TABLE "ELSYS"."ARTICLE" 
     (	"ID" NUMBER, 
  	"CREATED_ON" DATE, 
  	"CONTENT" VARCHAR2(255 BYTE), 
  	"NAME" VARCHAR2(255 BYTE), 
  	"TAG_ID" NUMBER
     ) SEGMENT CREATION IMMEDIATE 
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "SYSTEM" ;
  --------------------------------------------------------
  --  DDL for Table CATEGORY
  --------------------------------------------------------
  
    CREATE TABLE "ELSYS"."CATEGORY" 
     (	"ID" NUMBER, 
  	"CREATED_BY" VARCHAR2(255 BYTE), 
  	"PRIORITY" NUMBER
     ) SEGMENT CREATION IMMEDIATE 
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "SYSTEM" ;
  --------------------------------------------------------
  --  DDL for Table TAG_PART1
  --------------------------------------------------------
  
    CREATE TABLE "ELSYS"."TAG_PART1" 
     (	"DESCRIPTION" VARCHAR2(20 BYTE)
     ) SEGMENT CREATION IMMEDIATE 
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "SYSTEM" ;
  --------------------------------------------------------
  --  DDL for Table TAG_PART2
  --------------------------------------------------------
  
    CREATE TABLE "ELSYS"."TAG_PART2" 
     (	"ID" NUMBER, 
  	"NAME" VARCHAR2(255 BYTE), 
  	"USER_ID" NUMBER
     ) SEGMENT CREATION IMMEDIATE 
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "SYSTEM" ;
  --------------------------------------------------------
  --  DDL for Table USER_CATEGORY
  --------------------------------------------------------
  
    CREATE TABLE "ELSYS"."USER_CATEGORY" 
     (	"U_ID" NUMBER, 
  	"C_ID" NUMBER
     ) SEGMENT CREATION IMMEDIATE 
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "SYSTEM" ;
  --------------------------------------------------------
  --  DDL for Table USERS
  --------------------------------------------------------
  
    CREATE TABLE "ELSYS"."USERS" 
     (	"ID" NUMBER, 
  	"NAME" VARCHAR2(255 BYTE), 
  	"DESCRIPTION" VARCHAR2(255 BYTE), 
  	"PICTURE_URL" VARCHAR2(255 BYTE)
     ) SEGMENT CREATION IMMEDIATE 
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "SYSTEM" ;
  REM INSERTING into ELSYS.ARTICLE
  SET DEFINE OFF;
  Insert into ELSYS.ARTICLE (ID,CREATED_ON,CONTENT,NAME,TAG_ID) values (1,to_date('2012-11-11','RRRR-MM-DD'),'ascasc','scas',1);
  Insert into ELSYS.ARTICLE (ID,CREATED_ON,CONTENT,NAME,TAG_ID) values (2,to_date('2012-11-11','RRRR-MM-DD'),'casc','ascasc',1);
  REM INSERTING into ELSYS.CATEGORY
  SET DEFINE OFF;
  Insert into ELSYS.CATEGORY (ID,CREATED_BY,PRIORITY) values (1,'2012-11-11',213);
  Insert into ELSYS.CATEGORY (ID,CREATED_BY,PRIORITY) values (1,'2012-11-11',12312);
  REM INSERTING into ELSYS.TAG_PART1
  SET DEFINE OFF;
  Insert into ELSYS.TAG_PART1 (DESCRIPTION) values ('ascascas');
  Insert into ELSYS.TAG_PART1 (DESCRIPTION) values ('cascs');
  REM INSERTING into ELSYS.TAG_PART2
  SET DEFINE OFF;
  Insert into ELSYS.TAG_PART2 (ID,NAME,USER_ID) values (1,'asca',1);
  Insert into ELSYS.TAG_PART2 (ID,NAME,USER_ID) values (2,'ascasc',1);
  REM INSERTING into ELSYS.USER_CATEGORY
  SET DEFINE OFF;
  Insert into ELSYS.USER_CATEGORY (U_ID,C_ID) values (1,2);
  Insert into ELSYS.USER_CATEGORY (U_ID,C_ID) values (2,1);
  Insert into ELSYS.USER_CATEGORY (U_ID,C_ID) values (1,1);
  REM INSERTING into ELSYS.USERS
  SET DEFINE OFF;
  Insert into ELSYS.USERS (ID,NAME,DESCRIPTION,PICTURE_URL) values (1,'aascas','cascasc','casc');
  Insert into ELSYS.USERS (ID,NAME,DESCRIPTION,PICTURE_URL) values (1,'cascasc','aascccasas','ascacas');
  