INSERT INTO `cust_account_index` (`pkid`,`acc_code`,`name`,`description`,`acc_type`,`status`,`last_edit`,`userid_edit`,`username`,`password`,`name_first`,`name_last`,`nickname`,`title`,`designation`,`identity_number`,`main_address1`,`main_address2`,`main_address3`,`main_city`,`main_postcode`,`main_state`,`main_country`,`ship_address1`,`ship_address2`,`ship_address3`,`ship_city`,`ship_postcode`,`ship_state`,`ship_country`,`bill_address1`,`bill_address2`,`bill_address3`,`bill_city`,`bill_postcode`,`bill_state`,`bill_country`,`telephone1`,`telephone2`,`home_phone`,`mobile_phone`,`fax_no`,`homepage`,`email1`,`email2`,`email3`,`credit_limit`,`credit_terms`,`property1`,`property2`,`property3`,`property4`,`property5`,`note`,`salesman`,`state`,`dealer_code`,`factor_pricing`,`factor_discount`,`pricing_logic`,`pricing_scheme`,`area_code`,`dept_code`,`supplier_id`,`branch`,`pc_center`,`credit_option`,`monthly_fees`) VALUES (500,'cash','Cash','This is meant for one time customers that pay cash',20,'active','2001-01-01 00:00:01',500,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','-','-','-','-','-','','','','','10000000.0000',0,'','','','','','',0,'OK','','0.0000','0.0000','','','','',0,0,0,'','0.0000'); INSERT INTO `user_index` (`userid`,`username`,`password`,`namefirst`,`namelast`,`status`,`password2`) VALUES (0,'nobody','na','nobody','nobody','default','f9de48a18d041cf0eedc2e4002a2035bba380b97'), (500,'developer','96-22-B6-77-FA-9E-12-B9','Developer','Programmer','active','f9de48a18d041cf0eedc2e4002a2035bba380b97'), (501,'leehongfay','AE-2A-FA-A0-6E-87-21-D8','Vincent','Lee','hidden','f9de48a18d041cf0eedc2e4002a2035bba380b97'); |