Viewing File: /home/assersoft/tmp/sess_4af224b6abb0a8331db3da94956274c5
PMA_token |s:32:"6737396f26263f314f3f4c7044675679"; HMAC_secret |s:16:"w9g.T8IC'92\6E5V";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1724316637;}encryption_key|s:32:"�@�������eM���yw7+Q�(����";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.1";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:1:{s:12:"Console/Mode";s:4:"show";}s:2:"ts";i:1724316637;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:3:{s:15:"userprefs_mtime";i:1724315211;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1707934956;}s:18:"server_1_assersoft";a:18:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:5:{i:0;s:13:"assersoft\_SS";i:1;s:20:"assersoft\_Sakufmain";i:2;s:20:"assersoft\_ashcroft1";i:3;s:20:"assersoft\_audiogram";i:4;s:19:"assersoft\_sakufinn";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}s:19:"profiling_supported";b:1;s:17:"menu-levels-table";a:11:{s:6:"browse";s:6:"Browse";s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:6:"insert";s:6:"Insert";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:10:"privileges";s:10:"Privileges";s:9:"operation";s:10:"Operations";s:8:"tracking";s:8:"Tracking";s:8:"triggers";s:8:"Triggers";}s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:19:"assersoft@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:16:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:1:{i:0;a:2:{s:2:"db";s:19:"assersoft_audiogram";s:5:"table";s:5:"Users";}}}s:5:"query";a:10:{s:32:"0e34736435d7b5a4ae0062731551fe6a";a:8:{s:3:"sql";s:598:"create table if not exists TympanogramTests (
ID int primary key auto_increment,
Date datetime not null,
LeftVolume double not null default 0,
RightVolume double not null default 0,
LeftCompliance double not null default 0,
RightCompliance double not null default 0,
LeftPressure1 double not null default 0,
LeftPressure2 double not null default 0,
LeftPressure3 double not null default 0,
RightPressure1 double not null default 0,
RightPressure2 double not null default 0,
RightPressure3 double not null default 0,
PatientID int
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"31534c798826acfd3a38f510bc98de25";a:8:{s:3:"sql";s:233:"create table if not exists Frequencies (
ID int primary key auto_increment,
Pressure varchar(25) not null default 0,
Frequency double not null default 0,
Level double not null default 0,
TympanogramID int
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"e899974814c3e43cbcd16452d1e539aa";a:8:{s:3:"sql";s:210:"create table if not exists Users (
UserID int primary key auto_increment,
Username varchar(20) unique not null,
Password varchar(128) not null,
Usertype varchar(30) not null default 'local'
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"fa51cb9075ceaa0fdc38eee542245be8";a:8:{s:3:"sql";s:119:"alter table AudiogramTests
add constraint fk_Audiogram_Patient
foreign key(PatientID) references Patients(PatientID);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"1382a10dcd44745f82ad1ef2b7babfbb";a:8:{s:3:"sql";s:120:"alter table PureToneTests
add constraint fk_PureTone_Audiogram
foreign key(AudiogramID) references AudiogramTests(ID);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"8e6fee70104dd209b1b96955c3e9a33e";a:8:{s:3:"sql";s:116:"alter table SpeechTests
add constraint fk_Speech_Audiogram
foreign key(AudiogramID) references AudiogramTests(ID);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"dcdbcda74b0a682798dd5b0762e3d494";a:8:{s:3:"sql";s:123:"alter table TympanogramTests
add constraint fk_Tympanogram_Patient
foreign key(PatientID) references Patients(PatientID);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"2187621e58dd598dc622895d9120d61f";a:8:{s:3:"sql";s:127:"alter table Frequencies
add constraint fk_Frequencies_Tympanogram
foreign key(TympanogramID) references TympanogramTests(ID);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"d443629e30c5d5e36b7d22d67fea62d8";a:8:{s:3:"sql";s:137:"insert into Users(Username, Password, Usertype) values ("test", "$2b$10$nfsGx/1W44ouXgPjkXawHeuxiBL3NZANk1HC8Scwfm6wNnNJfWvF.", "admin");";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"182add4a4421b35ab5dd6c59d2509be2";a:8:{s:3:"sql";s:21:"SELECT * FROM `Users`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:19:"assersoft_audiogram";s:20:"possible_as_geometry";b:1;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:19:"assersoft_audiogram";a:1:{s:5:"Users";a:0:{}}}}}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:4:"show";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}__upload_status|a:1:{s:7:"handler";s:47:"PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin";}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:58:"index.php?route=/database/structure&db=assersoft_audiogram";}is_multi_query|b:0;sql_history|a:5:{i:0;a:3:{s:2:"db";s:0:"";s:5:"table";s:0:"";s:8:"sqlquery";s:344:"--
-- Database: `if0_37155211_audiogram`
--
-- --------------------------------------------------------
--
-- Table structure for table `AudiogramTests`
--
CREATE TABLE `AudiogramTests` (
`ID` int(11) NOT NULL,
`Date` datetime NOT NULL,
`PatientID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;";}i:1;a:3:{s:2:"db";s:19:"assersoft_audiogram";s:5:"table";s:0:"";s:8:"sqlquery";s:127:"alter table Frequencies
add constraint fk_Frequencies_Tympanogram
foreign key(TympanogramID) references TympanogramTests(ID);";}i:2;a:3:{s:2:"db";s:19:"assersoft_audiogram";s:5:"table";s:0:"";s:8:"sqlquery";s:137:"insert into Users(Username, Password, Usertype) values ("test", "$2b$10$nfsGx/1W44ouXgPjkXawHeuxiBL3NZANk1HC8Scwfm6wNnNJfWvF.", "admin");";}i:3;a:3:{s:2:"db";s:19:"assersoft_audiogram";s:5:"table";s:5:"Users";s:8:"sqlquery";s:21:"SELECT * FROM `Users`";}i:4;a:3:{s:2:"db";s:19:"assersoft_audiogram";s:5:"table";s:5:"Users";s:8:"sqlquery";s:21:"SELECT * FROM `Users`";}}flashMessages|a:0:{}errors|a:0:{}
Back to Directory
File Manager