   r2p_Value text NOT NULL
 ) TYPE=MyISAM;
 
+
+CREATE TABLE result_res (
+  res_ID mediumint(9) NOT NULL auto_increment,
+  res_echotype1 text NOT NULL,
+  res_echotype2 text NOT NULL,
+  res_echotype3 text NOT NULL,
+  res_authorization text NOT NULL,
+  res_order_number text NOT NULL,
+  res_reference text NOT NULL,
+  res_status text NOT NULL,
+  res_avs_result text NOT NULL,
+  res_security_result text NOT NULL,
+  res_mac text NOT NULL,
+  res_decline_code text NOT NULL,
+  res_tran_date text NOT NULL,
+  res_merchant_name text NOT NULL,
+  res_version text NOT NULL,
+  res_EchoServer text NOT NULL,
+  PRIMARY KEY  (res_ID)
+) TYPE=MyISAM;
 
 CREATE TABLE user_usr (
   usr_per_ID mediumint(9) unsigned NOT NULL default '0',

CREATE TABLE canvas05_c05 (
  c05_famID smallint(9) NOT NULL default '0',
  c05_churchColor text,

  plg_CheckNo bigint(16) unsigned default NULL,
  plg_Problem tinyint(1) default NULL,
  plg_scanString text,
  plg_aut_ID mediumint(9) NOT NULL default '0',
  plg_aut_Cleared tinyint(1) NOT NULL default '0',
  plg_aut_ResultID mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (plg_plgID)
) TYPE=MyISAM;


CREATE TABLE property_pro (
  pro_ID mediumint(8) unsigned NOT NULL auto_increment,
