mlloreda

#!/bin/bash

function write_config() {
    cat <<EOF > "$CONFIG"                                                                                                                                                                         
pathtomusic="$path"                                                                                                                                                                               
continue="$cont"                                                                                                                                                                                  
EOF                                                                                                                                                                                               
}

write_config

mlloreda

insert into QUESTION values(0, 0, 0, 'question about association rule 1', 'ans1', 5, 0);
insert into QUESTION values(1, 0, 0, 'question about association rule 2', 'ans2', 5, 0);
insert into QUESTION values(2, 0, 0, 'question about concurrent transactions 3', 'ans3', 5, 0);

insert into QUESTION values(3, 1, 0, 'question about association rule 1', 'ans1', 5, 1);
insert into QUESTION values(4, 1, 0, 'question about outlier detection 2', 'ans2', 5, 1);
insert into QUESTION values(5, 1, 0, 'question about concurrent transactions 3', 'ans3', 5, 1);

insert into QUESTION values(6, 2, 0, 'question about association rule 1', 'ans1', 5, 2);
insert into QUESTION values(7, 2, 0, 'question about outlier detection 2', 'ans2', 5, 2);

mlloreda

CREATE TABLE _USER
(
	username 	char(20)	primary key,
	password 	char(20)
);


CREATE TABLE _ADMIN
(		
	title 		varchar(15) 	not null primary key foreign key references _USER(username)