--------------------------------------------------------
--  File created - Sobota-leden-26-2008   
--------------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE CLASS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into CLASS
Insert into CLASS (ID,NAME) values (0,'E1');
Insert into CLASS (ID,NAME) values (1,'P1A');
Insert into CLASS (ID,NAME) values (2,'P1B');
Insert into CLASS (ID,NAME) values (3,'M1');
Insert into CLASS (ID,NAME) values (4,'S1');
Insert into CLASS (ID,NAME) values (5,'E2');
Insert into CLASS (ID,NAME) values (6,'P2A');
Insert into CLASS (ID,NAME) values (7,'P2B');
Insert into CLASS (ID,NAME) values (8,'M2');
Insert into CLASS (ID,NAME) values (9,'S2A');
Insert into CLASS (ID,NAME) values (10,'S2B');
Insert into CLASS (ID,NAME) values (11,'E3');
Insert into CLASS (ID,NAME) values (12,'P3A');
Insert into CLASS (ID,NAME) values (13,'P3B');
Insert into CLASS (ID,NAME) values (14,'S3');
Insert into CLASS (ID,NAME) values (15,'E4');
Insert into CLASS (ID,NAME) values (16,'P4');
Insert into CLASS (ID,NAME) values (17,'M4');
Insert into CLASS (ID,NAME) values (18,'S4');

---------------------------------------------------
--   END DATA FOR TABLE CLASS
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE CLIENT
--   FILTER = none used
---------------------------------------------------
-- INSERTING into CLIENT
Insert into CLIENT (ID,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (0,10,0,0);
Insert into CLIENT (ID,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (1,10,0,0);

---------------------------------------------------
--   END DATA FOR TABLE CLIENTUSER
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE DATABASE
--   FILTER = none used
---------------------------------------------------
-- INSERTING into DATABASE
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (0,'TEST','TEST','TEST','TEST','TEST','itl','spa');
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (1,'jedna','one','ein','una',null,'une','une');
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (2,'dva','two','zwo','deux',null,null,null);
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (3,'okno','window',null,null,null,null,null);
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (4,'dvere','door',null,null,null,null,null);
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (5,'stul','table',null,null,null,null,null);
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (6,'vlasy','hair',null,null,null,null,null);
Insert into DATABASE (ID,LANG3,LANG4,LANG5,LANG6,COMMENTS,LANG1,LANG2) values (7,'mobil','mobil','mobil',null,'To je zajinavy',null,null);

---------------------------------------------------
--   END DATA FOR TABLE DATABASE
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE DICT
--   FILTER = none used
---------------------------------------------------
-- INSERTING into DICT
Insert into DICT (FROM_LANG,TO_LANG,DATABAS_ID) values ('CZE','GER',1);
Insert into DICT (FROM_LANG,TO_LANG,DATABAS_ID) values ('ENG','CZE',3);
Insert into DICT (FROM_LANG,TO_LANG,DATABAS_ID) values ('CZE','ENG',2);
Insert into DICT (FROM_LANG,TO_LANG,DATABAS_ID) values ('CZE','ITL',4);
Insert into DICT (FROM_LANG,TO_LANG,DATABAS_ID) values ('CZE','ENG',5);

---------------------------------------------------
--   END DATA FOR TABLE DICT
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE DICWORD
--   FILTER = none used
---------------------------------------------------
-- INSERTING into DICWORD

---------------------------------------------------
--   END DATA FOR TABLE DICWORD
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE EVENTS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into EVENTS
Insert into EVENTS (ID,DATETIME,COMMENTS,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (0,to_date('08.01.08','DD.MM.RR'),'Client connected',10,0,0);
Insert into EVENTS (ID,DATETIME,COMMENTS,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (2,to_date('08.01.08','DD.MM.RR'),'Client disconnected',10,0,0);
Insert into EVENTS (ID,DATETIME,COMMENTS,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (1,to_date('08.01.08','DD.MM.RR'),'Lection created',10,0,0);
Insert into EVENTS (ID,DATETIME,COMMENTS,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (3,to_date('07.01.08','DD.MM.RR'),'Client connected',10,0,0);
Insert into EVENTS (ID,DATETIME,COMMENTS,SERVER_MAXCLIENTS,SERVER_CLIENTU_ID,SERVER_DATABAS_ID) values (4,to_date('07.01.08','DD.MM.RR'),'Client disconnected',10,0,0);

---------------------------------------------------
--   END DATA FOR TABLE EVENTS
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE GETLECT
--   FILTER = none used
---------------------------------------------------
-- INSERTING into GETLECT

---------------------------------------------------
--   END DATA FOR TABLE GETLECT
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE GETWORD
--   FILTER = none used
---------------------------------------------------
-- INSERTING into GETWORD

---------------------------------------------------
--   END DATA FOR TABLE GETWORD
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE LECTION
--   FILTER = none used
---------------------------------------------------
-- INSERTING into LECTION
Insert into LECTION (NAME,EVENTS_ID,EVENTS_SERVER_MAXCLIENTS,EVENTS_SERVER_CLIENTU_ID,EVENTS_SERVER_DATABAS_ID,LECTIONNAME) values (0,1,10,0,0,null);

---------------------------------------------------
--   END DATA FOR TABLE LOGIN
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE MEMBER
--   FILTER = none used
---------------------------------------------------
-- INSERTING into MEMBER
Insert into MEMBER (IS_MEMBER,CLASS_ID) values (1,0);
Insert into MEMBER (IS_MEMBER,CLASS_ID) values (1,1);
Insert into MEMBER (IS_MEMBER,CLASS_ID) values (1,2);
Insert into MEMBER (IS_MEMBER,CLASS_ID) values (1,3);
Insert into MEMBER (IS_MEMBER,CLASS_ID) values (1,4);

---------------------------------------------------
--   END DATA FOR TABLE MEMBER
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE MEMBERCLASS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into MEMBERCLASS

---------------------------------------------------
--   END DATA FOR TABLE MEMBERCLASS
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE SERVER
--   FILTER = none used
---------------------------------------------------
-- INSERTING into SERVER
Insert into SERVER (LICEN_ID,NOWCLIENTS,MAXCLIENTS,CLIENTU_ID,DATABAS_ID,ID) values (0,1,10,0,0,0);

---------------------------------------------------
--   END DATA FOR TABLE SERVER
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE STAT
--   FILTER = none used
---------------------------------------------------
-- INSERTING into STAT

---------------------------------------------------
--   END DATA FOR TABLE STAT
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE STATISTICS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into STATISTICS
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (0,0,10,1,9,1,10,to_date('08.01.08','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (1,1,20,2,18,2,25,to_date('01.01.08','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (2,0,10,1,10,0,30,to_date('07.01.08','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (3,0,10,3,9,1,30,to_date('08.10.06','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (4,2,11,3,11,0,30,to_date('07.01.08','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (5,1,10,2,10,0,30,to_date('12.11.07','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (6,1,10,5,10,0,30,to_date('08.01.05','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (7,1,10,4,10,0,30,to_date('08.01.08','DD.MM.RR'));
Insert into STATISTICS (ID,LECTION,WORDS_COUNT,USERNAME,GOOD_WORDS_COUNT,BAD_WORDS_COUNT,TIMER,DATETIME) values (8,3,10,1,10,10,35,to_date('08.01.08','DD.MM.RR'));

---------------------------------------------------
--   END DATA FOR TABLE STATISTICS
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE STATSPART
--   FILTER = none used
---------------------------------------------------
-- INSERTING into STATSPART
Insert into STATSPART (WRONG_ID,STATW_ID) values (0,0);

---------------------------------------------------
--   END DATA FOR TABLE STATSPART
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE SUPERVISOR
--   FILTER = none used
---------------------------------------------------
-- INSERTING into SUPERVISOR
Insert into SUPERVISOR (BOOLCREATEUSER,BOOLEDITDB,BOOLSTATS,CLIENTU_ID) values (1,1,1,0);
Insert into SUPERVISOR (BOOLCREATEUSER,BOOLEDITDB,BOOLSTATS,CLIENTU_ID) values (1,0,1,7);

---------------------------------------------------
--   END DATA FOR TABLE SUPERVISOR
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE VIEWSTATS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into VIEWSTATS
Insert into VIEWSTATS (SHOWS_ID,SUPER_CLIENTU_ID) values (0,0);
Insert into VIEWSTATS (SHOWS_ID,SUPER_CLIENTU_ID) values (1,7);

---------------------------------------------------
--   END DATA FOR TABLE VIEWSTATS
---------------------------------------------------

---------------------------------------------------
--   DATA FOR TABLE WRONGWORDS
--   FILTER = none used
---------------------------------------------------
-- INSERTING into WRONGWORDS
Insert into WRONGWORDS (LANG2,LANG1,STAT_ID,ID) values ('ahoj','hello',0,0);
Insert into WRONGWORDS (LANG2,LANG1,STAT_ID,ID) values ('ahoj','hello',1,1);
Insert into WRONGWORDS (LANG2,LANG1,STAT_ID,ID) values ('one','jedna',2,2);
Insert into WRONGWORDS (LANG2,LANG1,STAT_ID,ID) values ('dva','two',2,3);

---------------------------------------------------
--   END DATA FOR TABLE WRONGWORDS
---------------------------------------------------
