BiTel

INSERT INTO `contract` (`id`, `gr`, `title`, `title_pattern_id`, `pswd`, `date1`, `date2`, `mode`, `closesumma`, `pgid`, `pfid`, `fc`, `comment`, `del`, `scid`, `sub_list`, `sub_mode`, `status`, `status_date`, `last_tariff_change`, `crm_customer_id`) VALUES

(200000, 8, '3593', 0, 'IGOSnnZI', '2003-04-01 00:00:00.000', 'NULL', 1, -50.00, 0, 0, 0, 'Хламов Хлам Хламович', 0, 0, '', 0, 0, NULL, '2010-06-22 14:31:25', 0);

--

INSERT INTO `contract_parameter_type_1` (`cid`, `pid`, `val`) VALUES

(200000, 1, 'Ф 12/25'),

(200000, 2, '9999 999999 от 24.06.2003 Центральным РОВД Хламосково УВД Хламовской обл. '),

(200000, 5, 'export bdk'),

(200000, 13, 'Хламов'),

(200000, 14, 'Хлам'),

(200000, 15, 'Хламович');

--

INSERT INTO `contract_parameter_type_2` (`cid`, `pid`, `hid`, `flat`, `room`, `pod`, `floor`, `address`, `comment`) VALUES

(200000, 6, 441, '25', '', -1, -1, 'Урюбинск,Хламово, д. 12, кв. 25', '');

--

INSERT INTO `contract_parameter_type_6` (`cid`, `pid`, `val`) VALUES

(200000, 16, '2003-04-01 00:00:00.000'),

(200000, 19, '2010-01-02 00:00:00.000');

--

INSERT INTO `contract_parameter_type_9` (`pid`, `value`, `phone1`, `phone_format1`, `phone_comm1`, `phone2`, `phone_format2`, `phone_comm2`, `phone3`, `phone_format3`, `phone_comm3`, `phone4`, `phone_format4`, `phone_comm4`, `phone5`, `phone_format5`, `phone_comm5`, `cid`) VALUES

(11, '999999999 []; ', '9999999999', '13', '9999999999 []', '99999999999', '00', '', '', '00', '', '', '00', '', '', '00', '', 200000);

--

INSERT INTO `contract_module` (`cid` ,`mid`) VALUES

(200000, '3');

--

INSERT INTO `npay_service_object_3` (`cid`, `sid`, `date1`, `col`) VALUES

('200000', '4', '2010-12-06', 1);

--

INSERT INTO `npay_service_object_3` (`cid`, `sid`, `date1`, `col`) VALUES

('200000', '12', '2010-12-06', 1);

--

INSERT INTO `bgbilling`.`contract_tariff` (`id` ,`cid` ,`tpid` ,`date1` ,`date2` ,`comment` ,`lm` ,`pos` ,`emid` ,`eid`) VALUES

(NULL , 200000, 273, '2010-12-01 00:00:00' , NULL , '', '0000-00-00 00:00:00', '0', '0', '0');