 --
 
 INSERT INTO `reff_tablekey` (`tablename`, `keyfields`, `fields`, `Condition`) VALUES
-('reff_users', 'userid', 'userid,password,groupid,full_name,address,phone_number,email_address,regionid,active', 'userid != ''admin''');
+('reff_users', 'userid', 'userid,password,groupid,full_name,address,phone_number,email_address,divisionid,active', 'userid != ''admin''');
 
 -- --------------------------------------------------------
 

  `email_address` varchar(200) DEFAULT NULL,
  `is_login` bit(1) NOT NULL,
  `active` bit(1) NOT NULL,
  `regionid` bigint(20) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
CREATE DATABASE `dbportalpgn` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `dbportalpgn`;

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

--
-- Table structure for table `reff_division`
--

CREATE TABLE IF NOT EXISTS `reff_division` (
  `divisionid` bigint(20) NOT NULL AUTO_INCREMENT,
  `description` varchar(250) NOT NULL,
  PRIMARY KEY (`divisionid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `reff_division`
--

INSERT INTO `reff_division` (`divisionid`, `description`) VALUES
(1, 'divisi tes');

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

