; DB: tpweb
; 2008-11-06 17:44:07

[settings]
version="1.2.0.0"

[tables]
adapters="serial_num|char(32) NOT NULL"
audits="audit_time|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';user_id|int(11) unsigned NOT NULL DEFAULT '0';code|smallint(5) unsigned NOT NULL DEFAULT '0';level|tinyint(3) unsigned NOT NULL DEFAULT '0';object_table|varchar(50) NOT NULL;object_id|int(11) unsigned NOT NULL DEFAULT '0';object_name_field|varchar(50) NOT NULL;param|text NOT NULL"
cal_params="upload_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';sensor_id|int(10) unsigned NOT NULL DEFAULT '0';range_min|float NOT NULL DEFAULT '0';range_max|float NOT NULL DEFAULT '0';et_min|float NOT NULL DEFAULT '0';et_max|float NOT NULL DEFAULT '0';et_units|tinyint(3) unsigned NOT NULL DEFAULT '0';et_raport|varchar(255) NOT NULL;et_date|date NOT NULL DEFAULT '0000-00-00';et_nextdate|date NOT NULL DEFAULT '0000-00-00';et_b0|float NOT NULL DEFAULT '0';et_b1|float NOT NULL DEFAULT '0';et_b2|float NOT NULL DEFAULT '0';et_b3|float NOT NULL DEFAULT '0';adc_shift|float NOT NULL DEFAULT '0';adc_slope|float NOT NULL DEFAULT '1'"
config="param|varchar(50) NOT NULL;value|varchar(255) NOT NULL;boolean|tinyint(3) unsigned NOT NULL DEFAULT '0';editable|tinyint(3) NOT NULL DEFAULT '1';descr|varchar(255) NOT NULL;limits|varchar(50) NOT NULL"
loggers="serial_num|varchar(20) NOT NULL;type|int(10) unsigned NOT NULL DEFAULT '0';visible|tinyint(3) unsigned NOT NULL DEFAULT '1'"
login_history="user_id|int(11) unsigned NOT NULL DEFAULT '0';sdate|date NOT NULL DEFAULT '0000-00-00';shour|tinyint(3) unsigned NOT NULL DEFAULT '0'"
messages="from_user_id|int(11) unsigned NOT NULL DEFAULT '0';to_user_id|int(11) unsigned NOT NULL DEFAULT '0';subject|varchar(255) NOT NULL;sent_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';read_flag|tinyint(1) unsigned NOT NULL DEFAULT '0';read_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';msg_text|mediumtext NOT NULL;priority|enum('low','normal','high') NOT NULL DEFAULT 'normal';visible|tinyint(1) unsigned NOT NULL DEFAULT '1'"
mission_alarms="mission_id|int(10) unsigned NOT NULL DEFAULT '0';input_num|char(1) NOT NULL;from_time|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';to_time|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';type|char(1) NOT NULL"
mission_cal="mission_id|int(10) unsigned NOT NULL DEFAULT '0';input_num|char(1) NOT NULL;cal_id|int(10) unsigned NOT NULL DEFAULT '0'"
mission_comments="mission_id|int(10) unsigned NOT NULL DEFAULT '0';user_id|int(10) unsigned NOT NULL DEFAULT '0';s_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';comments|text NOT NULL"
mission_data="mission_id|int(10) unsigned NOT NULL DEFAULT '0';input_num|char(1) NOT NULL;s_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';value|float NOT NULL DEFAULT '0'"
mission_limits="mission_id|int(10) unsigned NOT NULL DEFAULT '0';input_num|char(1) NOT NULL;low_limit|float NOT NULL DEFAULT '0';high_limit|float NOT NULL DEFAULT '0';soft_low_limit|float NOT NULL DEFAULT '0';soft_high_limit|float NOT NULL DEFAULT '0';max_oor|smallint(5) unsigned NOT NULL DEFAULT '0';convert_to_units|int(10) unsigned NOT NULL DEFAULT '0'"
missions="created_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';programmed_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';downloaded_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';descr|varchar(255) NOT NULL;state|char(1) NOT NULL DEFAULT 'n';logger_type|int(10) unsigned NOT NULL DEFAULT '0';logger_id|int(10) unsigned NOT NULL DEFAULT '0';visible|tinyint(1) unsigned NOT NULL DEFAULT '1';sample_rate|int(10) unsigned NOT NULL DEFAULT '0';start_delay_type|tinyint(3) unsigned NOT NULL DEFAULT '0';start_delay|int(10) unsigned NOT NULL DEFAULT '0';start_delay_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';duration|int(10) unsigned NOT NULL DEFAULT '0';enable_rollover|tinyint(1) unsigned NOT NULL DEFAULT '0';rollover_happened|tinyint(1) unsigned NOT NULL DEFAULT '0';high_resolution|tinyint(1) unsigned NOT NULL DEFAULT '0';created_user_id|int(10) unsigned NOT NULL DEFAULT '0';programmed_user_id|int(10) unsigned NOT NULL DEFAULT '0';downloaded_user_id|int(10) unsigned NOT NULL DEFAULT '0';from_site_id|int(10) unsigned NOT NULL DEFAULT '0';to_site_id|int(10) unsigned NOT NULL DEFAULT '0';timezone|float NOT NULL DEFAULT '0';programmed_gsc|int(10) unsigned NOT NULL DEFAULT '0';downloaded_gsc|int(10) unsigned NOT NULL DEFAULT '0';limits_exceeded|tinyint(3) unsigned NOT NULL DEFAULT '0'"
online_users="user_id|int(11) unsigned NOT NULL DEFAULT '0';access_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00'"
pwd_history="user_id|int(11) unsigned NOT NULL DEFAULT '0';reg_date|date NOT NULL DEFAULT '0000-00-00';pwd|char(32) NOT NULL"
sensors="logger_id|int(10) unsigned NOT NULL DEFAULT '0';input_num|char(1) NOT NULL;cal_id|int(10) unsigned NOT NULL DEFAULT '0';visible|tinyint(1) unsigned NOT NULL DEFAULT '1'"
sites="name|varchar(50) NOT NULL;timezone_offset|tinyint(4) NOT NULL DEFAULT '0';visible|tinyint(3) unsigned NOT NULL DEFAULT '0'"
templates="name|varchar(255) NOT NULL;params|text NOT NULL;visible|tinyint(3) unsigned NOT NULL DEFAULT '1'"
users="first_name|varchar(50) NOT NULL;name|varchar(50) NOT NULL;regno|varchar(20) NOT NULL;login|varchar(50) NOT NULL;reg_date|datetime NOT NULL DEFAULT '0000-00-00 00:00:00';active|tinyint(1) unsigned NOT NULL DEFAULT '1';pwd_hash|varchar(32) NOT NULL;pwd_exp_date|date NOT NULL DEFAULT '0000-00-00';auto_block|tinyint(1) unsigned NOT NULL DEFAULT '0';access_level|smallint(5) unsigned NOT NULL DEFAULT '0';language|char(2) NOT NULL DEFAULT 'fr';recs_per_page|tinyint(3) unsigned NOT NULL DEFAULT '0';email|varchar(50) NOT NULL;site_id|int(10) unsigned NOT NULL DEFAULT '0';visible|tinyint(1) unsigned NOT NULL DEFAULT '1'"

[index]
adapters="id|UNIQUE INDEX id (id);id_2|INDEX id_2 (id);i_serial_num|INDEX i_serial_num (serial_num)"
audits="i_time|INDEX i_time (audit_time);i_code|INDEX i_code (code);i_user|INDEX i_user (user_id);i_object|INDEX i_object (object_id)"
cal_params="i_et_nextdate|INDEX i_et_nextdate (et_nextdate)"
config="i_param|UNIQUE INDEX i_param (param)"
loggers="i_serial_num|UNIQUE INDEX i_serial_num (serial_num);i_visible|INDEX i_visible (visible);i_type|INDEX i_type (type)"
login_history="i_all|UNIQUE INDEX i_all (user_id,sdate,shour);i_user_id|INDEX i_user_id (user_id);i_sdate|INDEX i_sdate (sdate)"
messages="NewIndex|INDEX NewIndex (from_user_id);NewIndex2|INDEX NewIndex2 (to_user_id);NewIndex3|INDEX NewIndex3 (sent_date);NewIndex4|INDEX NewIndex4 (read_flag,read_date);NewIndex5|INDEX NewIndex5 (priority);NewIndex6|INDEX NewIndex6 (visible)"
mission_alarms="id|UNIQUE INDEX id (id);id_2|INDEX id_2 (id);i_mission|INDEX i_mission (mission_id);i_input_num|INDEX i_input_num (input_num)"
mission_cal="id|UNIQUE INDEX id (id);id_2|INDEX id_2 (id,mission_id,input_num)"
mission_comments="id|UNIQUE INDEX id (id);id_2|INDEX id_2 (id,mission_id,s_date)"
mission_data="i_mission_id|INDEX i_mission_id (mission_id);i_input_num|INDEX i_input_num (input_num);i_s_date|INDEX i_s_date (s_date)"
mission_limits="i_mission_id|INDEX i_mission_id (mission_id);i_input_num|INDEX i_input_num (input_num)"
missions="i_created_date|INDEX i_created_date (created_date);i_state|INDEX i_state (state);i_logger_id|INDEX i_logger_id (logger_id);i_visible|INDEX i_visible (visible)"
online_users="i_user_id|INDEX i_user_id (user_id);i_access_date|INDEX i_access_date (access_date)"
pwd_history="NewIndex|INDEX NewIndex (user_id);NewIndex2|INDEX NewIndex2 (reg_date);NewIndex3|INDEX NewIndex3 (pwd)"
sensors="i_visible|INDEX i_visible (visible);i_logger_id|INDEX i_logger_id (logger_id);i_input_num|INDEX i_input_num (input_num)"
sites="id|UNIQUE INDEX id (id);id_2|INDEX id_2 (id,name,visible)"
templates="i_name|INDEX i_name (name);i_visible|INDEX i_visible (visible)"
users="i_login|INDEX i_login (login);i_pwd_hash|INDEX i_pwd_hash (pwd_hash);i_visible|INDEX i_visible (visible);i_name|INDEX i_name (name)"