-- noudattaa tietokantaa v0.0.13

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 `TEXT`;
DROP TABLE IF EXISTS `USER`;
DROP TABLE IF EXISTS `USERGROUP`;


CREATE TABLE USER (
USER_userID INTEGER NOT NULL AUTO_INCREMENT,
USER_name VARCHAR(100) NOT NULL,
USER_password VARCHAR(100) NOT NULL,
USER_description VARCHAR(1000) NOT NULL,
USER_rowStatus VARCHAR(10) NOT NULL,

CONSTRAINT USER_PK 
	PRIMARY KEY (USER_userID)
)
;


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

CONSTRAINT RESEARCH_PK 
	PRIMARY KEY (RESEARCH_researchID)
)
;


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

CONSTRAINT ROLE_PK 
	PRIMARY KEY (ROLE_roleID)
)
;


CREATE TABLE TASKTYPE (
TASKTYPE_taskTypeID INTEGER NOT NULL AUTO_INCREMENT,
TASKTYPE_description VARCHAR(1000) 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(10) NOT NULL,

CONSTRAINT TASKTYPE_PK 
	PRIMARY KEY (TASKTYPE_taskTypeID)
)
;


CREATE TABLE EVENTTYPE (
EVENTTYPE_eventTypeID INTEGER NOT NULL AUTO_INCREMENT,
EVENTTYPE_description VARCHAR(1000) NOT NULL,
EVENTTYPE_rowStatus VARCHAR(10) 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_hoursLeft INTEGER NULL,
EVENTTIME_rowStatus VARCHAR(10) 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(1000) NULL,
USERGROUP_editedBy INTEGER NOT NULL,
USERGROUP_editTime TIMESTAMP NOT NULL,
USERGROUP_RESEARCH_researchID INTEGER NOT NULL,
USERGROUP_ROLE_roleID INTEGER NOT NULL,
USERGROUP_rowStatus VARCHAR(10) NOT NULL,

CONSTRAINT USERGROUP_PK 
	PRIMARY KEY (USERGROUP_usergroupID),
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 SCHEDULE (
SCHEDULE_scheduleID INTEGER NOT NULL AUTO_INCREMENT,
SCHEDULE_zeroTime DATE NOT NULL,
SCHEDULE_rowStatus VARCHAR(10) NOT NULL,
SCHEDULE_description VARCHAR(1000) NOT NULL,
SCHEDULE_USERGROUP_usergroupID INTEGER DEFAULT -1,

CONSTRAINT SCHEDULE_PK 
	PRIMARY KEY (SCHEDULE_scheduleID),
CONSTRAINT SCHEDULE_usergroupID
        FOREIGN KEY (SCHEDULE_USERGROUP_usergroupID)
        REFERENCES USERGROUP (USERGROUP_usergroupID)
                 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(1000) NOT NULL,
EVENT_estimatedTime INTEGER NULL,
EVENT_status INTEGER NOT NULL,
EVENT_origEventID INTEGER NOT NULL,
EVENT_SCHEDULE_scheduleID INTEGER NOT NULL,
EVENT_EVENTTYPE_eventTypeID INTEGER NOT NULL,
EVENT_EVENTTIME_eventTimeID INTEGER NOT NULL,
EVENT_rowStatus VARCHAR(10) 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(1000) NULL,
TASK_content VARCHAR(100) NULL,
TASK_url VARCHAR(100) NULL,
TASK_sequence INTEGER NOT NULL,
TASK_posX INTEGER NOT NULL,
TASK_posY INTEGER NOT NULL,
TASK_EVENT_eventID INTEGER NOT NULL,
TASK_TASKTYPE_taskTypeID INTEGER NOT NULL,
TASK_rowStatus VARCHAR(10) 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(1000) 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(10) 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 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
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_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 TEXT (
TEXT_textID INTEGER NOT NULL AUTO_INCREMENT,
TEXT_sequence INTEGER NOT NULL,
TEXT_TASKDATA_taskDataID INTEGER NOT NULL,
TEXT_rowStatus VARCHAR(10) NOT NULL,

CONSTRAINT TEXT_PK 
	PRIMARY KEY (TEXT_textID),
CONSTRAINT TEXT_taskDataID 
	FOREIGN KEY (TEXT_TASKDATA_taskDataID)
	REFERENCES TASKDATA (TASKDATA_taskDataID)
		ON DELETE NO ACTION
		ON UPDATE CASCADE
)
;


CREATE TABLE ADMINISTERS (
ADMINISTERS_editTime TIMESTAMP NOT NULL,
ADMINISTERS_description INTEGER NOT NULL,
ADMINISTERS_USER_userID INTEGER NOT NULL,
ADMINISTERS_EVENT_eventID INTEGER NOT NULL,
ADMINISTERS_rowStatus VARCHAR(10) 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 TIMESTAMP NOT NULL,
BELONGS_USERGROUP_usergroupID INTEGER NOT NULL,
BELONGS_USER_userID INTEGER NOT NULL,
BELONGS_rowStatus VARCHAR(10) 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, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. yksi', 1);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. kaksi', 3);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. kolme', 3);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. neljä', 4);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. viisi', 1);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. kuusi', 2);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. seitsemän', 2);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-04-30', 'ACTIVE', 'Aikataulu nro. kahdeksan', 2);
insert into SCHEDULE (SCHEDULE_zeroTime, SCHEDULE_rowStatus, SCHEDULE_description, SCHEDULE_USERGROUP_usergroupID) values ('2012-05-02', 'ACTIVE', 'Aikataulu nro. yhdeksän', NULL);

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

insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testiyllapitaja', 'salasana', 'Overlord', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testitutkija1', 'salasana', 'Tutkija 1', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testitutkija2', 'salasana', 'Tutkija 2', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testikuntoutettava1', 'salasana', 'Kuntoutettava 1', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testikuntoutettava2', 'salasana', 'Kuntoutettava 2','ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testikuntoutettava3', 'salasana', 'Kuntoutettava 3','ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Testikuntoutettava4', 'salasana', 'Kuntoutettava 4','ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('TestiDeleted1', 'salasana', 'Kuntoutettava 1 Deleted','DELETED');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('TestiDeleted2', 'salasana', 'Kuntoutettava 2 Deleted','DELETED');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Santanen_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Santanen_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Lyytinen_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Lyytinen_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('PLappalainen_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('PLappalainen_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('RLappalainen_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('RLappalainen_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Kaartinen_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Kaartinen_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Suutama_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Suutama_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Kallioinen_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Kallioinen_t', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Valkama_k', 'salasana', '', 'ACTIVE');
insert into USER (USER_name, USER_password, USER_description, USER_rowStatus) values ('Valkama_t', 'salasana', '', 'ACTIVE');

insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus) values ('Testitutkijaryhma1', 'Testitutkijaryhmä 1', '0', '2012-04-04', '1', '1', 'ACTIVE');                                                                                        
insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus) values ('Testitutkijaryhma2', 'Testitutkijaryhmä 2', '0', '2012-04-04', '2', '1', 'ACTIVE');                                                                                        
insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus) values ('Testikayttajaryhma1', 'Testikäyttäjäryhmä 1', '0', '2012-04-04', '1', '2', 'ACTIVE');                                                                                      
insert into USERGROUP (USERGROUP_name, USERGROUP_description, USERGROUP_editedBy, USERGROUP_editTime, USERGROUP_RESEARCH_researchID, USERGROUP_ROLE_roleID, USERGROUP_rowStatus) values ('Testikayttajaryhma2', 'Testikäyttäjäryhmä 2', '0', '2012-04-04', '2', '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 TASKTYPE (TASKTYPE_description, TASKTYPE_binarydataMin, TASKTYPE_binarydataMax, TASKTYPE_textMin, TASKTYPE_textMax, TASKTYPE_rowStatus) values ('Audio', '0', '0', '0', '0', 'ACTIVE');
insert into TASKTYPE (TASKTYPE_description, TASKTYPE_binarydataMin, TASKTYPE_binarydataMax, TASKTYPE_textMin, TASKTYPE_textMax, TASKTYPE_rowStatus) values ('Video', '0', '0', '0', '0', 'ACTIVE');
INSERT INTO `TASKTYPE` (`TASKTYPE_taskTypeID`, `TASKTYPE_description`, `TASKTYPE_binarydataMin`, `TASKTYPE_textMin`, `TASKTYPE_textMax`, `TASKTYPE_binarydataMax`, `TASKTYPE_rowStatus`) VALUES (NULL, 'Slider', '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_year, EVENTTIME_month, EVENTTIME_day, EVENTTIME_weekday, EVENTTIME_minute, EVENTTIME_fromHour, EVENTTIME_hoursLeft, EVENTTIME_rowStatus) values ('0','2012' ,'4','26', '3', '15', '12', '21', 'ACTIVE');
insert into EVENTTIME (EVENTTIME_absolute, EVENTTIME_year, EVENTTIME_month, EVENTTIME_day, EVENTTIME_weekday, EVENTTIME_minute, EVENTTIME_fromHour, EVENTTIME_hoursLeft, EVENTTIME_rowStatus) values ('0', '2012','3','14', '4', '20', '12', '17', 'ACTIVE');
insert into EVENTTIME (EVENTTIME_absolute, EVENTTIME_year, EVENTTIME_month, EVENTTIME_day, EVENTTIME_weekday, EVENTTIME_minute, EVENTTIME_fromHour, EVENTTIME_hoursLeft, EVENTTIME_rowStatus) values ('0', '2013', '7', '17', '1', '30', '14', '18','ACTIVE');
insert into EVENTTIME (EVENTTIME_absolute, EVENTTIME_year, EVENTTIME_month, EVENTTIME_day, EVENTTIME_weekday, EVENTTIME_minute, EVENTTIME_fromHour, EVENTTIME_hoursLeft, EVENTTIME_rowStatus) values ('0', '2012', '5', '1', '2', '30', '14', '1800','ACTIVE');

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

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

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

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

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', '-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', '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', '-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', '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', '-1', 'ACTIVE');

insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '1', 'ACTIVE', '2012-01-01 10:00:00');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('2', '2', 'ACTIVE', '2012-01-02');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('2', '3', 'ACTIVE', '2012-01-03');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '4', 'ACTIVE', '2012-01-04');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '5', 'ACTIVE', '2012-01-05');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '6', 'ACTIVE', '2012-01-06');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('4', '6', 'ACTIVE', '2012-01-08');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '7', 'ACTIVE', '2012-01-07');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('4', '7', 'ACTIVE', '2012-01-09');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('4', '8', 'DELETED', '2012-01-10');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('2', '9', 'DELETED', '2012-01-11');

insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '10', 'ACTIVE', '2012-05-02 10:00:00');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '11', 'ACTIVE', '2012-05-02 10:00:01');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '12', 'ACTIVE', '2012-05-02 10:00:02');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '13', 'ACTIVE', '2012-05-02 10:00:03');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '14', 'ACTIVE', '2012-05-02 10:00:04');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '15', 'ACTIVE', '2012-05-02 10:00:05');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '16', 'ACTIVE', '2012-05-02 10:00:06');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '17', 'ACTIVE', '2012-05-02 10:00:07');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '18', 'ACTIVE', '2012-05-02 10:00:08');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '19', 'ACTIVE', '2012-05-02 10:00:09');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '20', 'ACTIVE', '2012-05-02 10:00:10');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '21', 'ACTIVE', '2012-05-02 10:00:11');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '22', 'ACTIVE', '2012-05-02 10:00:12');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '23', 'ACTIVE', '2012-05-02 10:00:13');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('3', '24', 'ACTIVE', '2012-05-02 10:00:14');
insert into BELONGS (BELONGS_USERGROUP_usergroupID, BELONGS_USER_userID, BELONGS_rowStatus, BELONGS_editTime) values ('1', '25', 'ACTIVE', '2012-05-02 10:00:15');

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');

insert into TASKDATA (TASKDATA_USER_userID, TASKDATA_CHOICE_choiceID, TASKDATA_sequence, TASKDATA_rowStatus) values ('7', '1', '1', 'ACTIVE');
insert into TASKDATA (TASKDATA_USER_userID, TASKDATA_CHOICE_choiceID, TASKDATA_sequence, TASKDATA_rowStatus) values ('7', '4', '2', 'ACTIVE');
insert into TASKDATA (TASKDATA_USER_userID, TASKDATA_CHOICE_choiceID, TASKDATA_sequence, TASKDATA_rowStatus) values ('7', '5', '3', 'ACTIVE');