schema definition.txt
9270d993aa95ms_access_migration

schema definition.txt
View Options

			CREATE TABLE `cryptokeys` (
			`ID_ck` int(11) NOT NULL AUTO_INCREMENT,
			`ID_p` int(11) DEFAULT NULL,
			`value` blob,
			`isPublic` bit(1) NOT NULL,
			PRIMARY KEY (`ID_ck`)
			);

			CREATE TABLE `m_p` (
			`ID_p` int(11) NOT NULL,
			`ID_m` varchar(20) NOT NULL,
			`enc_genotype_1` blob,
			`enc_genotype_2` blob,
			KEY `marker_patient` (`ID_p`,`ID_m`),
			KEY `ID_p` (`ID_p`),
			KEY `ID_m` (`ID_m`)
			);

			CREATE TABLE `cf_p` (
			`ID_p` int(11) NOT NULL,
			`ID_cf` varchar(45) NOT NULL,
			`enc_cf_1` blob,
			`enc_cf_2` blob
			);

			CREATE TABLE `hla_p` (
			`ID_p` int(11) NOT NULL,
			`enc_hla_A_1` blob,
			`enc_hla_A_2` blob,
			`enc_hla_B_1` blob,
			`enc_hla_B_2` blob,
			`enc_hla_C_1` blob,
			`enc_hla_C_2` blob,
			PRIMARY KEY (`ID_p`)
			);

			CREATE TABLE `database_name`.`rqt_in` (

			`ID_p` INT(11) NOT NULL,

			`timestamp` INT NOT NULL,

			`val` TEXT NULL,

			PRIMARY KEY (`ID_p`)
			);


			CREATE TABLE `database_name`.`rqt_out` (

			`ID_p` INT(11) NOT NULL,

			`timestamp` INT NOT NULL,

			`val` TEXT NULL,

			PRIMARY KEY (`ID_p`)
			);