function init_sql()
{
if (func_num_args() > 0) {
$arg_list = func_get_args();
$module_id = $arg_list[0];
}
module::execsql("CREATE TABLE `m_lib_questions` (" . "`question_id` float NOT NULL auto_increment," . "`question_rank` float NOT NULL default '0'," . "`answer_type` varchar(5) NOT NULL default ''," . "`alert_flag` char(1) NOT NULL default ''," . "`question_cat` varchar(5) NOT NULL default ''," . "`question_text` text NOT NULL," . "PRIMARY KEY (`question_id`)" . ") TYPE=InnoDB; ");
module::execsql("CREATE TABLE `m_lib_questioncat` (" . "`cat_id` varchar(5) NOT NULL default ''," . "`cat_name` varchar(50) NOT NULL default ''," . "PRIMARY KEY (`cat_id`)" . ") TYPE=InnoDB; ");
module::execsql("CREATE TABLE `m_complaint_question` (" . "`complaint_id` varchar(10) NOT NULL default ''," . "`question_id` float NOT NULL default '0'," . "`question_frequency` float NOT NULL default '0'," . "PRIMARY KEY (`question_id`,`complaint_id`)" . ") TYPE=InnoDB; ");
module::execsql("CREATE TABLE `m_consult_complaint_question` (" . "`consult_id` float NOT NULL default '0'," . "`question_id` float NOT NULL default '0'," . "`complaint_id` varchar(10) NOT NULL default ''," . "`answer` varchar(10) NOT NULL default ''," . "PRIMARY KEY (`consult_id`,`question_id`,`complaint_id`)" . ") TYPE=InnoDB; ");
module::execsql("CREATE TABLE `m_complaint_question_diagnosis` (" . "`complaint_id` varchar(10) NOT NULL default ''," . "`question_id` float NOT NULL default '0'," . "`answer` varchar(10) NOT NULL default ''," . "`diagnosis_code` varchar(50) NOT NULL default ''," . "PRIMARY KEY (`complaint_id`,`question_id`,`answer`)" . ") TYPE=InnoDB; ");
module::load_sql("question.sql");
module::execsql("UPDATE `m_lib_questions` SET question_rank = question_id;");
}
function init_sql() {
//
// create module tables
//
if (func_num_args()>0) {
$arg_list = func_get_args();
$module_id = $arg_list[0];
}
module::execsql("CREATE TABLE `m_patient_alert` (".
"`alert_id` bigint(20) NOT NULL auto_increment,".
"`alert_name` varchar(100) NOT NULL default '',".
"`alert_table` varchar(50) NOT NULL default '',".
"`alert_field` varchar(50) NOT NULL default '',".
"`alert_condition` varchar(100) NOT NULL default '',".
"`alert_message` varchar(100) NOT NULL default '',".
"PRIMARY KEY (`alert_id`)".
") TYPE=InnoDB; ");
module::load_sql("alerts.sql");
}
function create_system_tables()
{
//
// create system tables if not present
//
if (func_num_args() > 0) {
$arg_list = func_get_args();
$dbname = $arg_list[0];
}
mysql_query("CREATE DATABASE `{$dbname}`;") or die(mysql_errno() . ": " . mysql_error());
mysql_select_db($dbname);
module::load_sql("setup.sql");
}
