 -- http://www.phpmyadmin.net
 --
 -- Host: 127.0.0.1
--- Generation Time: Aug 10, 2016 at 06:25 PM
+-- Generation Time: Aug 13, 2016 at 10:46 PM
 -- Server version: 5.5.20
 -- PHP Version: 5.3.9
 

  `regionid` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`regionid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `reff_region`

  `maintable` varchar(150) NOT NULL,
  `refffield` varchar(150) NOT NULL,
  `reffquery` varchar(1000) NOT NULL,
  `reffqueryedit` varchar(1000) NOT NULL,
  `jointable` varchar(250) NOT NULL,
  `fieldjointable` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reff_table`
--

INSERT INTO `reff_table` (`maintable`, `refffield`, `reffquery`, `reffqueryedit`, `jointable`, `fieldjointable`) VALUES
('reff_users', 'groupid', 'select CONCAT(groupid,'' - '',description) as ''description'' FROM reff_groupid', 'select groupid,description FROM reff_groupid', 'reff_groupid', 'description'),
('reff_users', 'divisionid', 'select CONCAT(divisionid,'' - '',description) as ''description'' FROM reff_division', 'select divisionid,description FROM reff_division', 'reff_division', 'description');

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

