DROP TABLE IF EXISTS `ADMINISTERS`;
DROP TABLE IF EXISTS `BELONGS`;
DROP TABLE IF EXISTS `BINARYDATA`;
DROP TABLE IF EXISTS `CHOICE`;
DROP TABLE IF EXISTS `EVENT`;
DROP TABLE IF EXISTS `EVENTTIME`;
DROP TABLE IF EXISTS `EVENTTYPE`;
DROP TABLE IF EXISTS `RESEARCH`;
DROP TABLE IF EXISTS `ROLE`;
DROP TABLE IF EXISTS `SCHEDULE`;
DROP TABLE IF EXISTS `TASK`;
DROP TABLE IF EXISTS `TASKDATA`;
DROP TABLE IF EXISTS `TASKTYPE`;
DROP TABLE IF EXISTS `TEXTDATA`;
DROP TABLE IF EXISTS `USER`;
DROP TABLE IF EXISTS `USERGROUP`;


CREATE TABLE USER (
USER_userID INTEGER NOT NULL AUTO_INCREMENT,
USER_userName VARCHAR(100) NOT NULL,
USER_password VARCHAR(100) NOT NULL,
USER_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT USER_PK 
	PRIMARY KEY (USER_userID)
)
;


CREATE TABLE SCHEDULE (
SCHEDULE_scheduleID INTEGER NOT NULL AUTO_INCREMENT,
SCHEDULE_zeroTime DATE NOT NULL,
SCHEDULE_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT SCHEDULE_PK 
	PRIMARY KEY (SCHEDULE_scheduleID)
)
;


CREATE TABLE RESEARCH (
RESEARCH_researchID INTEGER NOT NULL AUTO_INCREMENT,
RESEARCH_description VARCHAR(100) NOT NULL,
RESEARCH_name VARCHAR(100) NOT NULL,
RESEARCH_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT RESEARCH_PK 
	PRIMARY KEY (RESEARCH_researchID)
)
;


CREATE TABLE ROLE (
ROLE_roleID INTEGER NOT NULL AUTO_INCREMENT,
ROLE_description VARCHAR(100) NOT NULL,
ROLE_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT ROLE_PK 
	PRIMARY KEY (ROLE_roleID)
)
;


CREATE TABLE TASKTYPE (
TASKTYPE_taskTypeID INTEGER NOT NULL AUTO_INCREMENT,
TASKTYPE_description VARCHAR(100) NOT NULL,
TASKTYPE_binarydataMin INTEGER NOT NULL,
TASKTYPE_textMin INTEGER NOT NULL,
TASKTYPE_textMax INTEGER NOT NULL,
TASKTYPE_binarydataMax INTEGER NOT NULL,
TASKTYPE_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT TASKTYPE_PK 
	PRIMARY KEY (TASKTYPE_taskTypeID)
)
;


CREATE TABLE EVENTTYPE (
EVENTTYPE_eventTypeID INTEGER NOT NULL AUTO_INCREMENT,
EVENTTYPE_description VARCHAR(100) NOT NULL,
EVENTTYPE_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT EVENTTYPE_PK 
	PRIMARY KEY (EVENTTYPE_eventTypeID)
)
;


CREATE TABLE EVENTTIME (
EVENTTIME_eventTimeID INTEGER NOT NULL AUTO_INCREMENT,
EVENTTIME_absolute INTEGER NOT NULL,
EVENTTIME_year INTEGER NULL,
EVENTTIME_month INTEGER NULL,
EVENTTIME_day INTEGER NULL,
EVENTTIME_weekday INTEGER NULL,
EVENTTIME_minute INTEGER NULL,
EVENTTIME_week INTEGER NULL,
EVENTTIME_fromHour INTEGER NULL,
EVENTTIME_toHour INTEGER NULL,
EVENTTIME_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT EVENTTIME_PK 
	PRIMARY KEY (EVENTTIME_eventTimeID)
)
;


CREATE TABLE USERGROUP (
USERGROUP_usergroupID INTEGER NOT NULL AUTO_INCREMENT,
USERGROUP_name VARCHAR(100) NOT NULL,
USERGROUP_description VARCHAR(100) NULL,
USERGROUP_editedBy INTEGER NOT NULL,
USERGROUP_editTime DATE NOT NULL,
USERGROUP_SCHEDULE_scheduleID INTEGER NOT NULL,
USERGROUP_RESEARCH_researchID INTEGER NOT NULL,
USERGROUP_ROLE_roleID INTEGER NOT NULL,
USERGROUP_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT USERGROUP_PK 
	PRIMARY KEY (USERGROUP_usergroupID),
CONSTRAINT USERGROUP_scheduleID 
	FOREIGN KEY (USERGROUP_SCHEDULE_scheduleID)
	REFERENCES SCHEDULE (SCHEDULE_scheduleID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT USERGROUP_researchID 
	FOREIGN KEY (USERGROUP_RESEARCH_researchID)
	REFERENCES RESEARCH (RESEARCH_researchID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT USERGROUP_roleID 
	FOREIGN KEY (USERGROUP_ROLE_roleID)
	REFERENCES ROLE (ROLE_roleID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE EVENT (
EVENT_eventID INTEGER NOT NULL AUTO_INCREMENT,
EVENT_title VARCHAR(100) NOT NULL,
EVENT_description VARCHAR(100) NOT NULL,
EVENT_estimatedTime INTEGER NULL,
EVENT_status INTEGER NOT NULL,
EVENT_SCHEDULE_scheduleID INTEGER NOT NULL,
EVENT_EVENTTYPE_eventTypeID INTEGER NOT NULL,
EVENT_EVENTTIME_eventTimeID INTEGER NOT NULL,
EVENT_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT EVENT_PK 
	PRIMARY KEY (EVENT_eventID),
CONSTRAINT EVENT_scheduleID 
	FOREIGN KEY (EVENT_SCHEDULE_scheduleID)
	REFERENCES SCHEDULE (SCHEDULE_scheduleID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT EVENT_eventTypeID 
	FOREIGN KEY (EVENT_EVENTTYPE_eventTypeID)
	REFERENCES EVENTTYPE (EVENTTYPE_eventTypeID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT EVENT_eventTimeID 
	FOREIGN KEY (EVENT_EVENTTIME_eventTimeID)
	REFERENCES EVENTTIME (EVENTTIME_eventTimeID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE TASK (
TASK_taskID INTEGER NOT NULL AUTO_INCREMENT,
TASK_description VARCHAR(100) NULL,
TASK_content VARCHAR(100) NULL,
TASK_url VARCHAR(100) NULL,
TASK_sequence INTEGER NOT NULL,
TASK_EVENT_eventID INTEGER NOT NULL,
TASK_TASKTYPE_taskTypeID INTEGER NOT NULL,
TASK_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT TASK_PK 
	PRIMARY KEY (TASK_taskID),
CONSTRAINT TASK_eventID 
	FOREIGN KEY (TASK_EVENT_eventID)
	REFERENCES EVENT (EVENT_eventID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT TASK_taskTypeID 
	FOREIGN KEY (TASK_TASKTYPE_taskTypeID)
	REFERENCES TASKTYPE (TASKTYPE_taskTypeID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE CHOICE (
CHOICE_choiceID INTEGER NOT NULL AUTO_INCREMENT,
CHOICE_description VARCHAR(100) NULL,
CHOICE_sequence INTEGER NOT NULL,
CHOICE_value INTEGER NOT NULL,
CHOICE_TASK_contains_taskID INTEGER NOT NULL,
CHOICE_TASK_leadsto_taskID INTEGER NULL,
CHOICE_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT CHOICE_PK 
	PRIMARY KEY (CHOICE_choiceID),
CONSTRAINT CHOICE_contains_taskID 
	FOREIGN KEY (CHOICE_TASK_contains_taskID)
	REFERENCES TASK (TASK_taskID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT CHOICE_leadsto_taskID 
	FOREIGN KEY (CHOICE_TASK_contains_taskID)
	REFERENCES TASK (TASK_taskID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE TASKDATA (
TASKDATA_taskDataID INTEGER NOT NULL AUTO_INCREMENT,
TASKDATA_executionTime DATE NOT NULL,
TASKDATA_sequence INTEGER NOT NULL,
TASKDATA_USER_userID INTEGER NOT NULL,
TASKDATA_CHOICE_choiceID INTEGER NOT NULL,
TASKDATA_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT TASKDATA_PK 
	PRIMARY KEY (TASKDATA_taskDataID),
CONSTRAINT TASKDATA_userID 
	FOREIGN KEY (TASKDATA_USER_userID)
	REFERENCES USER (USER_userID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT TASKDATA_choiceID 
	FOREIGN KEY (TASKDATA_CHOICE_choiceID)
	REFERENCES CHOICE (CHOICE_choiceID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE BINARYDATA (
BINARYDATA_binarydataID INTEGER NOT NULL AUTO_INCREMENT,
BINARYDATA_sequence INTEGER NOT NULL,
BINARYDATA_TASKDATA_taskDataID INTEGER NOT NULL,
BINARYDATA_data BLOB NOT NULL,
BINARYDATA_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT BINARYDATA_PK 
	PRIMARY KEY (BINARYDATA_binarydataID),
CONSTRAINT BINARYDATA_taskDataID 
	FOREIGN KEY (BINARYDATA_TASKDATA_taskDataID)
	REFERENCES TASKDATA (TASKDATA_taskDataID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE TEXTDATA (
TEXTDATA_textDataID INTEGER NOT NULL AUTO_INCREMENT,
TEXTDATA_sequence INTEGER NOT NULL,
TEXTDATA_TASKDATA_taskDataID INTEGER NOT NULL,
TEXTDATA_data VARCHAR(1000) NOT NULL,
TEXTDATA_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT TEXTDATA_PK 
	PRIMARY KEY (TEXTDATA_textDataID),
CONSTRAINT TEXTDATA_taskDataID 
	FOREIGN KEY (TEXTDATA_TASKDATA_taskDataID)
	REFERENCES TASKDATA (TASKDATA_taskDataID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE ADMINISTERS (
ADMINISTERS_editTime DATE NOT NULL,
ADMINISTERS_description INTEGER NOT NULL,
ADMINISTERS_USER_userID INTEGER NOT NULL,
ADMINISTERS_EVENT_eventID INTEGER NOT NULL,
ADMINISTERS_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT ADMINISTERS_PK
	PRIMARY KEY (ADMINISTERS_USER_userID,ADMINISTERS_EVENT_eventID),
CONSTRAINT ADMINISTERS_userID 
	FOREIGN KEY (ADMINISTERS_USER_userID)
	REFERENCES USER (USER_userID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT ADMINISTERS_eventID 
	FOREIGN KEY (ADMINISTERS_EVENT_eventID)
	REFERENCES EVENT (EVENT_eventID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE BELONGS (
BELONGS_editTime DATE NOT NULL,
BELONGS_USERGROUP_usergroupID INTEGER NOT NULL,
BELONGS_USER_userID INTEGER NOT NULL,
BELONGS_rowStatus VARCHAR(100) NOT NULL,

CONSTRAINT BELONGS_PK
	PRIMARY KEY (BELONGS_USERGROUP_usergroupID,BELONGS_USER_userID),
CONSTRAINT BELONGS_usergroupID 
	FOREIGN KEY (BELONGS_USERGROUP_usergroupID)
	REFERENCES USERGROUP (USERGROUP_usergroupID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE,
CONSTRAINT BELONGS_userID 
	FOREIGN KEY (BELONGS_USER_userID)
	REFERENCES USER (USER_userID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


insert into RESEARCH (RESEARCH_description, RESEARCH_name, RESEARCH_rowStatus) values ('Testitutkimus 1', 'Testitutkimus1', 'ACTIVE');
insert into RESEARCH (RESEARCH_description, RESEARCH_name, RESEARCH_rowStatus) values ('Testitutkimus 2', 'Testitutkimus2', 'ACTIVE');

insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus) values ('2012-04-30', 'ACTIVE');
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus) values ('2012-04-30', 'ACTIVE');
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus) values ('2012-04-30', 'ACTIVE');

insert into ROLE (ROLE_description, ROLE_rowStatus) values ('Testitutkijarooli1', 'ACTIVE');
insert into ROLE (ROLE_description, ROLE_rowStatus) values ('Testikäyttäjärooli1', 'ACTIVE');

insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testiyllapitaja', 'salasana', 'ACTIVE');
insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testitutkija1', 'salasana', 'ACTIVE');
insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testitutkija2', 'salasana', 'ACTIVE');
insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testikuntoutettava1', 'salasana', 'ACTIVE');
insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testikuntoutettava2', 'salasana', 'ACTIVE');
insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testikuntoutettava3', 'salasana', 'ACTIVE');
insert into USER (USER_userName, USER_password, USER_rowStatus) values ('Testikuntoutettava4', 'salasana', 'ACTIVE');

insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_SCHEDULE_scheduleID, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus)
values ('Testitutkijaryhma1', 'Testitutkijaryhmä 1', '0', '2012-04-04', '1', '1', '1', 'ACTIVE');                                                                                        
insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_SCHEDULE_scheduleID, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus)
values ('Testitutkijaryhma2', 'Testitutkijaryhmä 2', '0', '2012-04-04', '1', '1', '1', 'ACTIVE');                                                                                        
insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_SCHEDULE_scheduleID, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus)
values ('Testikayttajaryhma1', 'Testikäyttäjäryhmä 1', '0', '2012-04-04', '2', '1', '2', 'ACTIVE');                                                                                      
insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_SCHEDULE_scheduleID, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus)
values ('Testikayttajaryhma2', 'Testikäyttäjäryhmä 2', '0', '2012-04-04', '2', '1', '2', 'ACTIVE');

insert into TASKTYPE (TASKTYPE_description, TASKTYPE_binarydataMin, TASKTYPE_binarydataMax, TASKTYPE_textMin, TASKTYPE_textMax, TASKTYPE_rowStatus) values ('Teksti', '0', '0', '0', '0', 'ACTIVE');
insert into TASKTYPE (TASKTYPE_description, TASKTYPE_binarydataMin, TASKTYPE_binarydataMax, TASKTYPE_textMin, TASKTYPE_textMax, TASKTYPE_rowStatus) values ('Radio', '0', '0', '0', '0', 'ACTIVE');
insert into TASKTYPE (TASKTYPE_description, TASKTYPE_binarydataMin, TASKTYPE_binarydataMax, TASKTYPE_textMin, TASKTYPE_textMax, TASKTYPE_rowStatus) values ('Sensori', '0', '0', '0', '0', 'ACTIVE');

insert into EVENTTYPE (EVENTTYPE_description, EVENTTYPE_rowStatus) values ('Liikunta', 'ACTIVE');
insert into EVENTTYPE (EVENTTYPE_description, EVENTTYPE_rowStatus) values ('Kysely', 'ACTIVE');
insert into EVENTTYPE (EVENTTYPE_description, EVENTTYPE_rowStatus) values ('Aivojumppa', 'ACTIVE');

insert into EVENTTIME (EVENTTIME_absolute, EVENTTIME_day, EVENTTIME_rowStatus) values ('0', '3', 'ACTIVE');
insert into EVENTTIME (EVENTTIME_absolute, EVENTTIME_day, EVENTTIME_rowStatus) values ('0', '5', 'ACTIVE');
insert into EVENTTIME (EVENTTIME_absolute, EVENTTIME_day, EVENTTIME_rowStatus) values ('0', '7', 'ACTIVE');

insert into EVENT (EVENT_title, EVENT_description, EVENT_estimatedTime, EVENT_status, EVENT_SCHEDULE_scheduleID, EVENT_EVENTTYPE_eventTypeID, EVENT_EVENTTIME_eventTimeID, EVENT_rowStatus)
values ('Mielikuvaharjoitus', 'Seuraava tapahtuma jumppaa älynystyröitäsi.', '5', 'Scheduled', '2', '3', '1', 'ACTIVE');
insert into EVENT (EVENT_title, EVENT_description, EVENT_estimatedTime, EVENT_status, EVENT_SCHEDULE_scheduleID, EVENT_EVENTTYPE_eventTypeID, EVENT_EVENTTIME_eventTimeID, EVENT_rowStatus)
values ('Kävely', 'Seuraava tapahtuma jumppaa jalkojasi.', '60', 'Scheduled', '2', '1', '2', 'ACTIVE');
insert into EVENT (EVENT_title, EVENT_description, EVENT_estimatedTime, EVENT_status, EVENT_SCHEDULE_scheduleID, EVENT_EVENTTYPE_eventTypeID, EVENT_EVENTTIME_eventTimeID, EVENT_rowStatus)
values ('Kysely', 'Hyvinvointikysely.', '10', 'Scheduled', '2', '2', '3', 'ACTIVE');

insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Lue seuraava teksti.', 'Ajattele punaista omenaa...', NULL, '1', '1', '1', 'ACTIVE');
insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Mitä mieltä olet juuri lukemastasi tekstistä?', NULL, NULL, '2', '1', '2', 'ACTIVE');
insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Tapahtuma päättyi.', NULL, NULL, '3', '1', '1', 'ACTIVE');

insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Lähde kävelylle.', 'Paina painiketta käynnistääksesi sen ja sen.', NULL, '1', '2', '1', 'ACTIVE');
insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Olet kävelemässä.', 'Paina painiketta lopettaaksesi sen ja sen.', NULL, '2', '2', '3', 'ACTIVE');
insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Kävely päättyi.', NULL, NULL, '3', '2', '1', 'ACTIVE');

insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Vastaa seuraaviin kysymyksiin.', 'Jappa dappa.', NULL, '1', '3', '1', 'ACTIVE');
insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Sapettaako?', NULL, NULL, '2', '3', '2', 'ACTIVE');
insert into TASK (TASK_description, TASK_content, TASK_url, TASK_sequence, TASK_EVENT_eventID, TASK_TASKTYPE_taskTypeID, TASK_rowStatus) 
values ('Kysely päättyi.', NULL, NULL, '3', '3', '1', 'ACTIVE');

insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL,          '0',  '1', '1', '2', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values ('Pidin.',      '10', '1', '2', '3', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values ('Menetteli.',  '5',  '2', '2', '3', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values ('En pitänyt.', '1',  '3', '2', '3', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL,          '0',  '1', '3', NULL, 'ACTIVE');
                                                                                                                              
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL, '0', '1', '4', '5', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL, '0', '1', '5', '6', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL, '0', '1', '6', NULL, 'ACTIVE');
                                                                                                                              
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL,             '0',  '1', '7', '8', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values ('Kyllä.',         '1',  '1', '8', '9', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values ('En osaa sanoa.', '5',  '2', '8', '9', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values ('Ei.',            '10', '3', '8', '9', 'ACTIVE');
insert into CHOICE (CHOICE_description, CHOICE_value, CHOICE_sequence, CHOICE_TASK_contains_taskID, CHOICE_TASK_leadsto_taskID, CHOICE_rowStatus) values (NULL,             '0',  '1', '9', NULL, 'ACTIVE');

insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('1', '1', 'ACTIVE');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('2', '2', 'ACTIVE');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('2', '3', 'ACTIVE');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('3', '4', 'ACTIVE');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('3', '5', 'ACTIVE');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('4', '6', 'ACTIVE');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus) values ('4', '7', 'ACTIVE');

insert into ADMINISTERS (ADMINISTERS_editTime, ADMINISTERS_description, ADMINISTERS_USER_userID, ADMINISTERS_EVENT_eventID, ADMINISTERS_rowStatus) values ('2012-04-04', 'Täyteteksti', '1', '1', 'ACTIVE');
insert into ADMINISTERS (ADMINISTERS_editTime, ADMINISTERS_description, ADMINISTERS_USER_userID, ADMINISTERS_EVENT_eventID, ADMINISTERS_rowStatus) values ('2012-04-04', 'Täyteteksti', '1', '2', 'ACTIVE');
insert into ADMINISTERS (ADMINISTERS_editTime, ADMINISTERS_description, ADMINISTERS_USER_userID, ADMINISTERS_EVENT_eventID, ADMINISTERS_rowStatus) values ('2012-04-04', 'Täyteteksti', '1', '3', 'ACTIVE');