MAth-Cloud-3.0.0/api.ipsocloud.com/sql/localhost.sql

-- Adminer 4.7.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';



CREATE DATABASE `iimt_mathcloud` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `iimt_mathcloud`;

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `abacus`;
CREATE TABLE `abacus` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `sex` varchar(1) NOT NULL,
  `race` varchar(128) NOT NULL,
  `side` varchar(16) NOT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `abacus` (`ID`, `name`, `sex`, `race`, `side`, `data`) VALUES
(1,	'Europe, France, 30-79 years, PARC 2009 (Mean)',	'M',	'',	'',	'[{\r\n\"age\":30,\r\n\"min\":0.574,\r\n\"mean\":0.616,\r\n\"max\":0.672\r\n},{\r\n\"age\":40,\r\n\"min\":0.586,\r\n\"mean\":0.653,\r\n\"max\":0.705\r\n},{\r\n\"age\":50,\r\n\"min\":0.637,\r\n\"mean\":0.701,\r\n\"max\":0.787\r\n},{\r\n\"age\":60,\r\n\"min\":0.663,\r\n\"mean\":0.738,\r\n\"max\":0.842\r\n},{\r\n\"age\":70,\r\n\"min\":0.743,\r\n\"mean\":0.798,\r\n\"max\":0.907\r\n}]\r\n'),
(2,	'Europe, France, 30-79 years, PARC 2009 (Mean)',	'F',	'',	'',	'[{\r\n\"age\":30,\r\n\"min\":0.537,\r\n\"mean\":0.588,\r\n\"max\":0.635\r\n},{\r\n\"age\":40,\r\n\"min\":0.576,\r\n\"mean\":0.64,\r\n\"max\":0.691\r\n},{\r\n\"age\":50,\r\n\"min\":0.619,\r\n\"mean\":0.669,\r\n\"max\":0.737\r\n},{\r\n\"age\":60,\r\n\"min\":0.665,\r\n\"mean\":0.752,\r\n\"max\":0.817\r\n},{\r\n\"age\":70,\r\n\"min\":0.71,\r\n\"mean\":0.758,\r\n\"max\":0.841\r\n}]\r\n'),
(3,	'USA, 35-85 years, Caucasian, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'M',	'white',	'right',	'[{\r\n\"age\":35,\r\n\"min\":0.43,\r\n\"mean\":0.48,\r\n\"max\":0.55\r\n},{\r\n\"age\":45,\r\n\"min\":0.50,\r\n\"mean\":0.57,\r\n\"max\":0.66\r\n},{\r\n\"age\":55,\r\n\"min\":0.57,\r\n\"mean\":0.66,\r\n\"max\":0.77\r\n},{\r\n\"age\":65,\r\n\"min\":0.65,\r\n\"mean\":0.76,\r\n\"max\":0.90\r\n},{\r\n\"age\":75,\r\n\"min\":0.73,\r\n\"mean\":0.86,\r\n\"max\":1.03\r\n},{\r\n\"age\":85,\r\n\"min\":0.80,\r\n\"mean\":0.95,\r\n\"max\":1.14\r\n}]\r\n'),
(4,	'USA, 35-85 years, Caucasian, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'M',	'white',	'left',	'[{\r\n\"age\":35,\r\n\"min\":0.45,\r\n\"mean\":0.520,\r\n\"max\":0.6\r\n},{\r\n\"age\":45,\r\n\"min\":0.52,\r\n\"mean\":0.6,\r\n\"max\":0.7\r\n},{\r\n\"age\":55,\r\n\"min\":0.59,\r\n\"mean\":0.68,\r\n\"max\":0.8\r\n},{\r\n\"age\":65,\r\n\"min\":0.65,\r\n\"mean\":0.77,\r\n\"max\":0.93\r\n},{\r\n\"age\":75,\r\n\"min\":0.71,\r\n\"mean\":0.86,\r\n\"max\":1.06\r\n},{\r\n\"age\":85,\r\n\"min\":0.78,\r\n\"mean\":0.97,\r\n\"max\":1.18\r\n}]\r\n'),
(5,	'USA, 35-85 years, Caucasian, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'F',	'white',	'right',	'[{\r\n\"age\":35,\r\n\"min\":0.39,\r\n\"mean\":0.44,\r\n\"max\":0.51\r\n},{\r\n\"age\":45,\r\n\"min\":0.47,\r\n\"mean\":0.53,\r\n\"max\":0.61\r\n},{\r\n\"age\":55,\r\n\"min\":0.55,\r\n\"mean\":0.62,\r\n\"max\":0.71\r\n},{\r\n\"age\":65,\r\n\"min\":0.6,\r\n\"mean\":0.69,\r\n\"max\":0.81\r\n},{\r\n\"age\":75,\r\n\"min\":0.65,\r\n\"mean\":0.76,\r\n\"max\":0.91\r\n},{\r\n\"age\":85,\r\n\"min\":0.72,\r\n\"mean\":0.88,\r\n\"max\":1.01\r\n}]\r\n'),
(6,	'USA, 35-85 years, Caucasian, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'F',	'white',	'left',	'[{\r\n\"age\":35,\r\n\"min\":0.4,\r\n\"mean\":0.46,\r\n\"max\":0.51\r\n},{\r\n\"age\":45,\r\n\"min\":0.47,\r\n\"mean\":0.54,\r\n\"max\":0.61\r\n},{\r\n\"age\":55,\r\n\"min\":0.54,\r\n\"mean\":0.62,\r\n\"max\":0.71\r\n},{\r\n\"age\":65,\r\n\"min\":0.61,\r\n\"mean\":0.71,\r\n\"max\":0.81\r\n},{\r\n\"age\":75,\r\n\"min\":0.68,\r\n\"mean\":0.8,\r\n\"max\":0.91\r\n},{\r\n\"age\":85,\r\n\"min\":0.74,\r\n\"mean\":0.84,\r\n\"max\":1.01\r\n}]\r\n'),
(7,	'USA, 35-85 years, African American, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'M',	'african',	'right',	'[{\r\n\"age\":35,\r\n\"min\":0.43,\r\n\"mean\":0.5,\r\n\"max\":0.58\r\n},{\r\n\"age\":45,\r\n\"min\":0.52,\r\n\"mean\":0.61,\r\n\"max\":0.71\r\n},{\r\n\"age\":55,\r\n\"min\":0.61,\r\n\"mean\":0.72,\r\n\"max\":0.84\r\n},{\r\n\"age\":65,\r\n\"min\":0.72,\r\n\"mean\":0.85,\r\n\"max\":1.01\r\n},{\r\n\"age\":75,\r\n\"min\":0.83,\r\n\"mean\":0.98,\r\n\"max\":1.14\r\n},{\r\n\"age\":85,\r\n\"min\":0.94,\r\n\"mean\":1.06,\r\n\"max\":1.28\r\n}]\r\n'),
(8,	'USA, 35-85 years, African American, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'M',	'african',	'left',	'[{\r\n\"age\":35,\r\n\"min\":0.45,\r\n\"mean\":0.53,\r\n\"max\":0.61\r\n},{\r\n\"age\":45,\r\n\"min\":0.53,\r\n\"mean\":0.62,\r\n\"max\":0.72\r\n},{\r\n\"age\":55,\r\n\"min\":0.61,\r\n\"mean\":0.71,\r\n\"max\":0.83\r\n},{\r\n\"age\":65,\r\n\"min\":0.69,\r\n\"mean\":0.82,\r\n\"max\":0.99\r\n},{\r\n\"age\":75,\r\n\"min\":0.77,\r\n\"mean\":0.93,\r\n\"max\":1.16\r\n},{\r\n\"age\":85,\r\n\"min\":0.94,\r\n\"mean\":1.10,\r\n\"max\":1.36\r\n}]\r\n'),
(9,	'USA, 35-85 years, African American, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'F',	'african',	'right',	'[{\r\n\"age\":35,\r\n\"min\":0.43,\r\n\"mean\":0.48,\r\n\"max\":0.52\r\n},{\r\n\"age\":45,\r\n\"min\":0.51,\r\n\"mean\":0.58,\r\n\"max\":0.65\r\n},{\r\n\"age\":55,\r\n\"min\":0.59,\r\n\"mean\":0.68,\r\n\"max\":0.78\r\n},{\r\n\"age\":65,\r\n\"min\":0.63,\r\n\"mean\":0.74,\r\n\"max\":0.85\r\n},{\r\n\"age\":75,\r\n\"min\":0.67,\r\n\"mean\":0.8,\r\n\"max\":0.92\r\n},{\r\n\"age\":85,\r\n\"min\":0.74,\r\n\"mean\":0.9,\r\n\"max\":1.06\r\n}]\r\n'),
(10,	'USA, 35-85 years, African American, ARIC 1993 (R+L). Extrapolated values below 45 and over 65',	'F',	'african',	'left',	'[{\r\n\"age\":35,\r\n\"min\":0.42,\r\n\"mean\":0.47,\r\n\"max\":0.53\r\n},{\r\n\"age\":45,\r\n\"min\":0.49,\r\n\"mean\":0.56,\r\n\"max\":0.64\r\n},{\r\n\"age\":55,\r\n\"min\":0.56,\r\n\"mean\":0.65,\r\n\"max\":0.75\r\n},{\r\n\"age\":65,\r\n\"min\":0.62,\r\n\"mean\":0.72,\r\n\"max\":0.85\r\n},{\r\n\"age\":75,\r\n\"min\":0.68,\r\n\"mean\":0.79,\r\n\"max\":0.95\r\n},{\r\n\"age\":85,\r\n\"min\":0.78,\r\n\"mean\":0.86,\r\n\"max\":1.06\r\n}]\r\n');

DROP TABLE IF EXISTS `broker`;
CREATE TABLE `broker` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `config` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `broker` (`ID`, `name`, `config`) VALUES
(1,	'braintree-sandbox',	'{\r\n \"MerchantID\": \"tqbv9j5p3fmbmzx4\",\r\n \"PublicKey\": \"vsyr2294699hj6z5\",\r\n \"PrivateKey\": \"70184b99b13aafb398827f4702e2648a\"\r\n}');

DROP TABLE IF EXISTS `clinical_trial`;
CREATE TABLE `clinical_trial` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `number` varchar(64) NOT NULL,
  `name` text NOT NULL,
  `start` date NOT NULL,
  `patient_expected` smallint(6) NOT NULL,
  `center_count` tinyint(4) NOT NULL,
  `inclusion_month` tinyint(4) NOT NULL,
  `followup_month` tinyint(4) NOT NULL,
  `visit_per_patient` tinyint(4) NOT NULL,
  `visit_interval` tinyint(4) NOT NULL,
  `image_per_visit` tinyint(4) NOT NULL,
  `video_per_visit` tinyint(4) NOT NULL,
  `measure_per_timepoint` tinyint(4) NOT NULL,
  `comment` text NOT NULL,
  `max_readers` tinyint(4) NOT NULL,
  `max_investigators` tinyint(4) NOT NULL,
  `anon_percent` smallint(6) NOT NULL,
  `fk_user` int(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `context`;
CREATE TABLE `context` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `fk_visit` int(255) NOT NULL,
  `risks` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{}',
  `phistory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{}',
  `fhistory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{}',
  `examination` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{}',
  `treatments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `alpha2` varchar(2) NOT NULL,
  `alpha3` varchar(3) NOT NULL,
  `name_en` char(128) NOT NULL,
  `name_fr` char(128) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `country` (`ID`, `alpha2`, `alpha3`, `name_en`, `name_fr`) VALUES
(1,	'AE',	'ARE',	'United Arab Emirates',	'Emirats Arabes Unis'),
(2,	'AF',	'AFG',	'Afghanistan',	'Afghanistan'),
(3,	'AG',	'ATG',	'Antigua and Barbuda',	'Antigua-et-Barbuda'),
(4,	'AI',	'AIA',	'Anguilla',	'Anguilla'),
(5,	'AL',	'ALB',	'Albania',	'Albanie'),
(6,	'AM',	'ARM',	'Armenia',	'Arménie'),
(7,	'AN',	'ANT',	'Netherlands Antilles',	'Antilles néerlandaises'),
(8,	'AO',	'AGO',	'Angola',	'Angola'),
(9,	'AQ',	'ATA',	'Antarctica',	'Antarctique'),
(10,	'AR',	'ARG',	'Argentina',	'Argentine'),
(11,	'AS',	'ASM',	'American Samoa',	'Samoa américaines'),
(12,	'AT',	'AUT',	'Austria',	'Autriche'),
(13,	'AU',	'AUS',	'Australia',	'Australie'),
(14,	'AW',	'ABW',	'Aruba',	'Aruba'),
(15,	'AZ',	'AZE',	'Azerbaijan',	'Azerbaïdjan'),
(16,	'BA',	'BIH',	'Bosnia and Herzegovina',	'Bosnie Herzégovine'),
(17,	'BB',	'BRB',	'Barbados',	'Barbade'),
(18,	'BD',	'BGD',	'Bangladesh',	'Bangladesh'),
(19,	'BE',	'BEL',	'Belgium',	'Belgique'),
(20,	'BF',	'BFA',	'Burkina Faso',	'Burkina Faso'),
(21,	'BG',	'BGR',	'Bulgaria',	'Bulgarie'),
(22,	'BH',	'BHR',	'Bahrain',	'Bahreïn'),
(23,	'BI',	'BDI',	'Burundi',	'Burundi'),
(24,	'BJ',	'BEN',	'Benin',	'Bénin'),
(25,	'BM',	'BMU',	'Bermuda',	'Bermudes'),
(26,	'BN',	'BRN',	'Brunei',	'Brunei'),
(27,	'BO',	'BOL',	'Bolivia',	'Bolivie'),
(28,	'BR',	'BRA',	'Brazil',	'Brésil'),
(29,	'BS',	'BHS',	'Bahamas',	'Bahamas'),
(30,	'BT',	'BTN',	'Bhutan',	'Bhoutan'),
(31,	'BV',	'BVT',	'Bouvet Island',	'Île Bouvet'),
(32,	'BW',	'BWA',	'Botswana',	'Botswana'),
(33,	'BY',	'BLR',	'Belarus',	'Biélorussie'),
(34,	'BZ',	'BLZ',	'Belize',	'Belize'),
(35,	'CA',	'CAN',	'Canada',	'Canada'),
(36,	'CC',	'CCK',	'Cocos (Keeling) Islands',	'Îles Cocos (Keeling)'),
(37,	'CD',	'COD',	'Congo, The Democratic Republic of the',	'Congo, République démocratique du'),
(38,	'CF',	'CAF',	'Central African Republic',	'République centrafricaine'),
(39,	'CG',	'COG',	'Congo',	'Congo'),
(40,	'CH',	'CHE',	'Switzerland',	'Suisse'),
(41,	'CI',	'CIV',	'Côte d\'Ivoire',	'Côte Ivoire'),
(42,	'CK',	'COK',	'Cook Islands',	'Îles Cook'),
(43,	'CL',	'CHL',	'Chile',	'Chili'),
(44,	'CM',	'CMR',	'Cameroon',	'Cameroun'),
(45,	'CN',	'CHN',	'China',	'Chine'),
(46,	'CO',	'COL',	'Colombia',	'Colombie'),
(47,	'CR',	'CRI',	'Costa Rica',	'Costa Rica'),
(48,	'CU',	'CUB',	'Cuba',	'Cuba'),
(49,	'CV',	'CPV',	'Cape Verde',	'Cap-Vert'),
(50,	'CX',	'CXR',	'Christmas Island',	'île de noël'),
(51,	'CY',	'CYP',	'Cyprus',	'Chypre'),
(52,	'CZ',	'CZE',	'Czech Republic',	'République Tchèque'),
(53,	'DE',	'DEU',	'Germany',	'Allemagne'),
(54,	'DJ',	'DJI',	'Djibouti',	'Djibouti'),
(55,	'DK',	'DNK',	'Denmark',	'Danemark'),
(56,	'DM',	'DMA',	'Dominica',	'Dominique'),
(57,	'DO',	'DOM',	'Dominican Republic',	'République Dominicaine'),
(58,	'DZ',	'DZA',	'Algeria',	'Algérie'),
(59,	'EC',	'ECU',	'Ecuador',	'Equateur'),
(60,	'EE',	'EST',	'Estonia',	'Estonie'),
(61,	'EG',	'EGY',	'Egypt',	'Egypte'),
(62,	'EH',	'ESH',	'Western Sahara',	'Sahara occidental'),
(63,	'ER',	'ERI',	'Eritrea',	'Érythrée'),
(64,	'ES',	'ESP',	'Spain',	'Espagne'),
(65,	'ET',	'ETH',	'Ethiopia',	'Ethiopie'),
(66,	'FI',	'FIN',	'Finland',	'Finlande'),
(67,	'FJ',	'FJI',	'Fiji Islands',	'Iles Fidji'),
(68,	'FK',	'FLK',	'Falkland Islands',	'îles Falkland'),
(69,	'FM',	'FSM',	'Micronesia, Federated States of',	'Micronésie, États fédérés de'),
(70,	'FO',	'FRO',	'Faroe Islands',	'Îles Féroé'),
(71,	'FR',	'FRA',	'France',	'France'),
(72,	'GA',	'GAB',	'Gabon',	'Gabon'),
(73,	'GB',	'GBR',	'United Kingdom',	'Royaume-Uni'),
(74,	'GD',	'GRD',	'Grenada',	'Grenade'),
(75,	'GE',	'GEO',	'Georgia',	'Géorgie'),
(76,	'GF',	'GUF',	'French Guiana',	'Guyane Française'),
(77,	'GH',	'GHA',	'Ghana',	'Ghana'),
(78,	'GI',	'GIB',	'Gibraltar',	'Gibraltar'),
(79,	'GL',	'GRL',	'Greenland',	'Groenland'),
(80,	'GM',	'GMB',	'Gambia',	'Gambie'),
(81,	'GN',	'GIN',	'Guinea',	'Guinée'),
(82,	'GP',	'GLP',	'Guadeloupe',	'Guadeloupe'),
(83,	'GQ',	'GNQ',	'Equatorial Guinea',	'Guinée Équatoriale'),
(84,	'GR',	'GRC',	'Greece',	'Grèce'),
(85,	'GS',	'SGS',	'South Georgia and the South Sandwich Islands',	'Géorgie du Sud et îles Sandwich du Sud'),
(86,	'GT',	'GTM',	'Guatemala',	'Guatemala'),
(87,	'GU',	'GUM',	'Guam',	'Guam'),
(88,	'GW',	'GNB',	'Guinea-Bissau',	'Guinée-Bissau'),
(89,	'GY',	'GUY',	'Guyana',	'Guyane'),
(90,	'HK',	'HKG',	'Hong Kong',	'Hong Kong'),
(91,	'HM',	'HMD',	'Heard Island and McDonald Islands',	'Îles Heard et McDonald'),
(92,	'HN',	'HND',	'Honduras',	'Honduras'),
(93,	'HR',	'HRV',	'Croatia',	'Croatie'),
(94,	'HT',	'HTI',	'Haiti',	'Haïti'),
(95,	'HU',	'HUN',	'Hungary',	'Hongrie'),
(96,	'ID',	'IDN',	'Indonesia',	'Indonésie'),
(97,	'IE',	'IRL',	'Ireland',	'Irlande'),
(98,	'IL',	'ISR',	'Israel',	'Israël'),
(99,	'IN',	'IND',	'India',	'Inde'),
(100,	'IO',	'IOT',	'British Indian Ocean Territory',	'Territoire britannique de l\'océan Indien'),
(101,	'IQ',	'IRQ',	'Iraq',	'Irak'),
(102,	'IR',	'IRN',	'Iran',	'Iran'),
(103,	'IS',	'ISL',	'Iceland',	'Islande'),
(104,	'IT',	'ITA',	'Italy',	'Italie'),
(105,	'JM',	'JAM',	'Jamaica',	'Jamaïque'),
(106,	'JO',	'JOR',	'Jordan',	'Jordan'),
(107,	'JP',	'JPN',	'Japan',	'Japon'),
(108,	'KE',	'KEN',	'Kenya',	'Kenya'),
(109,	'KG',	'KGZ',	'Kyrgyzstan',	'Kirghizistan'),
(110,	'KH',	'KHM',	'Cambodia',	'Cambodge'),
(111,	'KI',	'KIR',	'Kiribati',	'Kiribati'),
(112,	'KM',	'COM',	'Comoros',	'Comores'),
(113,	'KN',	'KNA',	'Saint Kitts and Nevis',	'Saint-Christophe-et-Niévès'),
(114,	'KP',	'PRK',	'North Korea',	'Corée du Nord'),
(115,	'KR',	'KOR',	'South Korea',	'Corée du Sud'),
(116,	'KW',	'KWT',	'Kuwait',	'Koweit'),
(117,	'KY',	'CYM',	'Cayman Islands',	'Îles Caïmans'),
(118,	'KZ',	'KAZ',	'Kazakstan',	'Kazakstan'),
(119,	'LA',	'LAO',	'Laos',	'Laos'),
(120,	'LB',	'LBN',	'Lebanon',	'Liban'),
(121,	'LC',	'LCA',	'Saint Lucia',	'Sainte-Lucie'),
(122,	'LI',	'LIE',	'Liechtenstein',	'Liechtenstein'),
(123,	'LK',	'LKA',	'Sri Lanka',	'Sri Lanka'),
(124,	'LR',	'LBR',	'Liberia',	'Libéria'),
(125,	'LS',	'LSO',	'Lesotho',	'Lesotho'),
(126,	'LT',	'LTU',	'Lithuania',	'Lituanie'),
(127,	'LU',	'LUX',	'Luxembourg',	'Luxembourg'),
(128,	'LV',	'LVA',	'Latvia',	'Lettonie'),
(129,	'LY',	'LBY',	'Libyan Arab Jamahiriya',	'Jamahiriya arabe libyenne'),
(130,	'MA',	'MAR',	'Morocco',	'Maroc'),
(131,	'MC',	'MCO',	'Monaco',	'Monaco'),
(132,	'MD',	'MDA',	'Moldova',	'Moldavie'),
(133,	'MG',	'MDG',	'Madagascar',	'Madagascar'),
(134,	'MH',	'MHL',	'Marshall Islands',	'Iles Marshall'),
(135,	'MK',	'MKD',	'Macedonia',	'Macédoine'),
(136,	'ML',	'MLI',	'Mali',	'Mali'),
(137,	'MM',	'MMR',	'Myanmar',	'Myanmar'),
(138,	'MN',	'MNG',	'Mongolia',	'Mongolie'),
(139,	'MO',	'MAC',	'Macao',	'Macao'),
(140,	'MP',	'MNP',	'Northern Mariana Islands',	'Îles Mariannes du Nord'),
(141,	'MQ',	'MTQ',	'Martinique',	'Martinique'),
(142,	'MR',	'MRT',	'Mauritania',	'Mauritanie'),
(143,	'MS',	'MSR',	'Montserrat',	'Montserrat'),
(144,	'MT',	'MLT',	'Malta',	'Malte'),
(145,	'MU',	'MUS',	'Mauritius',	'Ile Maurice'),
(146,	'MV',	'MDV',	'Maldives',	'Maldives'),
(147,	'MW',	'MWI',	'Malawi',	'Malawi'),
(148,	'MX',	'MEX',	'Mexico',	'Mexique'),
(149,	'MY',	'MYS',	'Malaysia',	'Malaisie'),
(150,	'MZ',	'MOZ',	'Mozambique',	'Mozambique'),
(151,	'NA',	'NAM',	'Namibia',	'Namibie'),
(152,	'NC',	'NCL',	'New Caledonia',	'Nouvelle Calédonie'),
(153,	'NE',	'NER',	'Niger',	'Niger'),
(154,	'NF',	'NFK',	'Norfolk Island',	'Ile de Norfolk'),
(155,	'NG',	'NGA',	'Nigeria',	'Nigeria'),
(156,	'NI',	'NIC',	'Nicaragua',	'Nicaragua'),
(157,	'NL',	'NLD',	'Netherlands',	'Pays-Bas'),
(158,	'NO',	'NOR',	'Norway',	'Norvège'),
(159,	'NP',	'NPL',	'Nepal',	'Népal'),
(160,	'NR',	'NRU',	'Nauru',	'Nauru'),
(161,	'NU',	'NIU',	'Niue',	'Niue'),
(162,	'NZ',	'NZL',	'New Zealand',	'Nouvelle-Zélande'),
(163,	'OM',	'OMN',	'Oman',	'Oman'),
(164,	'PA',	'PAN',	'Panama',	'Panama'),
(165,	'PE',	'PER',	'Peru',	'Pérou'),
(166,	'PF',	'PYF',	'French Polynesia',	'Polynésie française'),
(167,	'PG',	'PNG',	'Papua New Guinea',	'Papouasie Nouvelle Guinée'),
(168,	'PH',	'PHL',	'Philippines',	'Philippines'),
(169,	'PK',	'PAK',	'Pakistan',	'Pakistan'),
(170,	'PL',	'POL',	'Poland',	'Pologne'),
(171,	'PM',	'SPM',	'Saint Pierre and Miquelon',	'Saint-Pierre-et-Miquelon'),
(172,	'PN',	'PCN',	'Pitcairn',	'Pitcairn'),
(173,	'PR',	'PRI',	'Puerto Rico',	'Porto Rico'),
(174,	'PS',	'PSE',	'Palestine',	'Palestine'),
(175,	'PT',	'PRT',	'Portugal',	'le Portugal'),
(176,	'PW',	'PLW',	'Palau',	'Palau'),
(177,	'PY',	'PRY',	'Paraguay',	'Paraguay'),
(178,	'QA',	'QAT',	'Qatar',	'Qatar'),
(179,	'RE',	'REU',	'RÚunion',	'Réunion'),
(180,	'RO',	'ROM',	'Romania',	'Roumanie'),
(181,	'RU',	'RUS',	'Russian Federation',	'Fédération Russe'),
(182,	'RW',	'RWA',	'Rwanda',	'Rwanda'),
(183,	'SA',	'SAU',	'Saudi Arabia',	'Arabie Saoudite'),
(184,	'SB',	'SLB',	'Solomon Islands',	'Iles Salomon'),
(185,	'SC',	'SYC',	'Seychelles',	'Seychelles'),
(186,	'SD',	'SDN',	'Sudan',	'Soudan'),
(187,	'SE',	'SWE',	'Sweden',	'Suède'),
(188,	'SG',	'SGP',	'Singapore',	'Singapour'),
(189,	'SH',	'SHN',	'Saint Helena',	'Sainte-Hélène'),
(190,	'SI',	'SVN',	'Slovenia',	'Slovénie'),
(191,	'SJ',	'SJM',	'Svalbard and Jan Mayen',	'Svalbard et Jan Mayen'),
(192,	'SK',	'SVK',	'Slovakia',	'Slovaquie'),
(193,	'SL',	'SLE',	'Sierra Leone',	'Sierra Leone'),
(194,	'SM',	'SMR',	'San Marino',	'Saint Marin'),
(195,	'SN',	'SEN',	'Senegal',	'Sénégal'),
(196,	'SO',	'SOM',	'Somalia',	'Somalie'),
(197,	'SR',	'SUR',	'Suriname',	'Suriname'),
(198,	'ST',	'STP',	'Sao Tome and Principe',	'Sao Tomé et Principe'),
(199,	'SV',	'SLV',	'El Salvador',	'Salvador'),
(200,	'SY',	'SYR',	'Syria',	'Syrie'),
(201,	'SZ',	'SWZ',	'Swaziland',	'Swaziland'),
(202,	'TC',	'TCA',	'Turks and Caicos Islands',	'Iles Turques-et-Caïques'),
(203,	'TD',	'TCD',	'Chad',	'Tchad'),
(204,	'TF',	'ATF',	'French Southern territories',	'Territoires du Sud français'),
(205,	'TG',	'TGO',	'Togo',	'Togo'),
(206,	'TH',	'THA',	'Thailand',	'Thaïlande'),
(207,	'TJ',	'TJK',	'Tajikistan',	'Tadjikistan'),
(208,	'TK',	'TKL',	'Tokelau',	'Tokelau'),
(209,	'TM',	'TKM',	'Turkmenistan',	'Turkménistan'),
(210,	'TN',	'TUN',	'Tunisia',	'Tunisie'),
(211,	'TO',	'TON',	'Tonga',	'Tonga'),
(212,	'TP',	'TMP',	'East Timor',	'Timor oriental'),
(213,	'TR',	'TUR',	'Turkey',	'Turquie'),
(214,	'TT',	'TTO',	'Trinidad and Tobago',	'Trinité-et-Tobago'),
(215,	'TV',	'TUV',	'Tuvalu',	'Tuvalu'),
(216,	'TW',	'TWN',	'Taiwan',	'Taïwan'),
(217,	'TZ',	'TZA',	'Tanzania',	'Tanzanie'),
(218,	'UA',	'UKR',	'Ukraine',	'Ukraine'),
(219,	'UG',	'UGA',	'Uganda',	'Ouganda'),
(220,	'UM',	'UMI',	'United States Minor Outlying Islands',	'Îles mineures éloignées des États-Unis'),
(221,	'US',	'USA',	'United States',	'États Unis'),
(222,	'UY',	'URY',	'Uruguay',	'Uruguay'),
(223,	'UZ',	'UZB',	'Uzbekistan',	'Ouzbékistan'),
(224,	'VA',	'VAT',	'Holy See (Vatican City State)',	'Saint-Siège (État de la Cité du Vatican)'),
(225,	'VC',	'VCT',	'Saint Vincent and the Grenadines',	'Saint-Vincent-et-les-Grenadines'),
(226,	'VE',	'VEN',	'Venezuela',	'Venezuela'),
(227,	'VG',	'VGB',	'Virgin Islands, British',	'Îles Vierges britanniques'),
(228,	'VI',	'VIR',	'Virgin Islands, U.S.',	'Îles Vierges américaines, États-Unis'),
(229,	'VN',	'VNM',	'Vietnam',	'Vietnam'),
(230,	'VU',	'VUT',	'Vanuatu',	'Vanuatu'),
(231,	'WF',	'WLF',	'Wallis and Futuna',	'Wallis et Futuna'),
(232,	'WS',	'WSM',	'Samoa',	'Samoa'),
(233,	'YE',	'YEM',	'Yemen',	'Yémen'),
(234,	'YT',	'MYT',	'Mayotte',	'Mayotte'),
(235,	'YU',	'YUG',	'Yugoslavia',	'Yougoslavie'),
(236,	'ZA',	'ZAF',	'South Africa',	'Afrique du Sud'),
(237,	'ZM',	'ZMB',	'Zambia',	'Zambie'),
(238,	'ZW',	'ZWE',	'Zimbabwe',	'Zimbabwe');

DROP TABLE IF EXISTS `credit`;
CREATE TABLE `credit` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `ID_user` int(255) NOT NULL,
  `stamp` datetime NOT NULL DEFAULT current_timestamp(),
  `count` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `credit_usage`;
CREATE TABLE `credit_usage` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `fk_user` int(255) NOT NULL,
  `fk_media` int(255) NOT NULL,
  `stamp` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ct_center`;
CREATE TABLE `ct_center` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `fk_organization` int(255) NOT NULL,
  `fk_probe` int(255) NOT NULL,
  `stamp` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `lst_coronary_type`;
CREATE TABLE `lst_coronary_type` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `lst_coronary_type` (`ID`, `code`) VALUES
(1,	'{\"fr\":\"Insuffisance coronarienne\", \"en\": \"Coronary insufficiency\"}'),
(2,	'{\"fr\":\"Athérosclérose\", \"en\": \"Atherosclerosis\"}'),
(3,	'{\"fr\":\"Infarctus\", \"en\": \"Infarctus\"}');

DROP TABLE IF EXISTS `lst_stroke_type`;
CREATE TABLE `lst_stroke_type` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `lst_stroke_type` (`ID`, `code`) VALUES
(1,	'{\"fr\":\"Hémorragie\", \"en\": \"Hemorrhage\"}'),
(2,	'{\"fr\":\"AIT\", \"en\": \"TIA\"}'),
(3,	'{\"fr\":\"Infarctus territorial\", \"en\": \"Territorial Infarction\"}'),
(4,	'{\"fr\":\"Lacunaire\", \"en\": \"Lacunar\"}');

DROP TABLE IF EXISTS `measure`;
CREATE TABLE `measure` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `type` varchar(64) NOT NULL,
  `points` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `computation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `fk_media` int(255) NOT NULL,
  `frame` tinyint(4) NOT NULL DEFAULT 0,
  `fk_user` int(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `media`;
CREATE TABLE `media` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `side` varchar(16) DEFAULT NULL,
  `location` varchar(16) DEFAULT NULL,
  `incidence` varchar(32) DEFAULT NULL,
  `filename` varchar(64) NOT NULL,
  `metrics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `fk_visit` int(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `fk_user` int(255) NOT NULL,
  `name` varchar(128) NOT NULL,
  `fk_country` int(255) NOT NULL,
  `zip` varchar(32) NOT NULL,
  `city` varchar(128) NOT NULL,
  `address` text NOT NULL,
  `phone` varchar(32) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `patient`;
CREATE TABLE `patient` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `patientID` varchar(128) NOT NULL,
  `ctPatientID` varchar(128) DEFAULT NULL,
  `firstname` varchar(128) NOT NULL,
  `lastname` varchar(128) NOT NULL,
  `gender` char(1) NOT NULL DEFAULT 'M',
  `birthDate` date NOT NULL,
  `height` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `race` enum('white','african','indian','asian','other') DEFAULT NULL,
  `fk_birthCountry` int(255) DEFAULT NULL,
  `fk_residenceCountry` int(255) DEFAULT NULL,
  `fk_user` int(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `probe`;
CREATE TABLE `probe` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `fk_user` int(255) NOT NULL,
  `name` varchar(128) NOT NULL,
  `brand` varchar(128) NOT NULL,
  `type` varchar(128) NOT NULL,
  `year` int(4) DEFAULT NULL,
  `frequency` float NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `recipient`;
CREATE TABLE `recipient` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `email` varchar(128) NOT NULL,
  `fk_user` int(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `settings` (`ID`, `data`) VALUES
(1,	'{\"patientListFields\":[{\"name\":\"Sex\",\"display\":0},{\"name\":\"PatientID\",\"display\":1},{\"name\":\"Firstname\",\"display\":1},{\"name\":\"Lastname\",\"display\":0},{\"name\":\"Birthdate\",\"display\":1},{\"name\":\"Height\",\"display\":0},{\"name\":\"Weight\",\"display\":0},{\"name\":\"Last visit\",\"display\":0},{\"name\":\"Visit count\",\"display\":0},{\"name\":\"Image count\",\"display\":0},{\"name\":\"Video count\",\"display\":1}],\"newPatientFields\":[{\"name\":\"Visit date\",\"display\":1,\"required\":0},{\"name\":\"Firstname\",\"display\":1,\"required\":1},{\"name\":\"Lastname\",\"display\":1,\"required\":0},{\"name\":\"Sex\",\"display\":1,\"required\":1},{\"name\":\"Birthdate\",\"display\":1,\"required\":1},{\"name\":\"Height\",\"display\":0,\"required\":0},{\"name\":\"Weight\",\"display\":0,\"required\":0},{\"name\":\"Birth country\",\"display\":1,\"required\":0},{\"name\":\"Residence country\",\"display\":1,\"required\":0}],\"videoDurationMax\":8}');

DROP TABLE IF EXISTS `settings_pacs`;
CREATE TABLE `settings_pacs` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `fk_physician` int(255) DEFAULT NULL,
  `fk_center` int(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `activation_token` varchar(127) NOT NULL,
  `activation_expire` datetime NOT NULL,
  `activation` datetime DEFAULT NULL,
  `password` varchar(128) NOT NULL,
  `firstname` varchar(128) NOT NULL,
  `lastname` varchar(128) NOT NULL,
  `email` varchar(128) NOT NULL,
  `phone` varchar(32) NOT NULL,
  `type` enum('imt-master','physician','cro','reader','investigator') NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1,
  `stamp` datetime NOT NULL DEFAULT current_timestamp(),
  `fk_center` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `visit`;
CREATE TABLE `visit` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `number` varchar(128) NOT NULL,
  `visitDate` date NOT NULL,
  `area` varchar(16) DEFAULT NULL,
  `markers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '[]',
  `completed` datetime DEFAULT NULL,
  `fk_patient` int(255) NOT NULL,
  `fk_reader` int(255) DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;






CREATE DATABASE `iimt_mathcloud_shadow` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `iimt_mathcloud_shadow`;

DROP TABLE IF EXISTS `media`;
CREATE TABLE `media` (
  `ID` int(255) NOT NULL AUTO_INCREMENT,
  `side` varchar(16) NOT NULL,
  `location` varchar(16) NOT NULL,
  `incidence` varchar(32) NOT NULL,
  `filename` varchar(64) NOT NULL,
  `metrics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `fk_visit` int(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;






CREATE DATABASE IF NOT EXISTS `iimt_mathcloud_audit` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `iimt_mathcloud_audit`;

-- --------------------------------------------------------

--
-- Table structure for table `activity`
--

DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
  `ID` int(255) NOT NULL,
  `ID_ray` int(255) NOT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `stamp` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `ray`
--

DROP TABLE IF EXISTS `ray`;
CREATE TABLE `ray` (
  `ID` int(255) NOT NULL,
  `userAgent` text NOT NULL,
  `apiKey` varchar(128) NOT NULL,
  `ipData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `locationData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `userData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `stamp` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity`
--
ALTER TABLE `activity`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ray`
--
ALTER TABLE `ray`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity`
--
ALTER TABLE `activity`
  MODIFY `ID` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ray`
--
ALTER TABLE `ray`
  MODIFY `ID` int(255) NOT NULL AUTO_INCREMENT;
COMMIT;