BiTel

это тот файл который нужно разместить на диске C:
DROP DATABASE IF EXISTS bgbilling;
CREATE DATABASE bgbilling DEFAULT CHARACTER SET cp1251 COLLATE cp1251_general_ci;
USE bgbilling;


CREATE TABLE `contract` (
`id` int(10) unsigned NOT NULL auto_increment,
`gr` bigint(20) NOT NULL default '0',
`title` varchar(150) NOT NULL default '',
`title_pattern_id` int(11) NOT NULL,
`pswd` varchar(32) NOT NULL default '',
`date1` date default NULL,
`date2` date default NULL,
`mode` tinyint(4) NOT NULL default '0',
`closesumma` double NOT NULL default '0',
`pgid` int(11) NOT NULL default '0',
`pfid` int(11) NOT NULL default '0',
`fc` tinyint(1) NOT NULL default '0',
`comment` varchar(100) NOT NULL default '',
`del` tinyint(1) NOT NULL default '0',
`scid` int(11) NOT NULL default '0',
`sub_list` varchar(250) NOT NULL default '',
`sub_mode` tinyint(4) NOT NULL,
`status` tinyint(4) NOT NULL default '0',
`status_date` date default NULL,
`last_tariff_change` datetime default NULL,
`crm_customer_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pfid_id` (`pfid`,`id`),
UNIQUE KEY `id_pfid` (`id`,`pfid`),
UNIQUE KEY `pfid_date2_id` (`pfid`,`date2`,`id`),
UNIQUE KEY `pfid_gr_date2_id` (`pfid`,`gr`,`date2`,`id`),
KEY `date2_` (`date2`),
KEY `pfid_date2` (`pfid`,`date2`),
KEY `pfid_date2_gr` (`pfid`,`date2`,`gr`),
KEY `pfid_gr_date2` (`pfid`,`gr`,`date2`),
KEY `date1` (`date1`),
KEY `title` (`title`),
KEY `del` (`del`),
KEY `scid` (`scid`),
KEY `crm_id` (`crm_customer_id`)
);



CREATE TABLE `module` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '',
`package_client` varchar(150) NOT NULL default '',
`package_server` varchar(150) NOT NULL default '',
`name` varchar(16) NOT NULL default '',
`config_id` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
);



CREATE TABLE `installed_modules` (
`name` varchar(100) default '0',
`title` varchar(200) default '0',
`version` varchar(20) default '0',
`pack_server` varchar(200) default '0',
`pack_client` varchar(200) default '0',
`type` varchar(20) NOT NULL default '0',
`client_zip` longblob NOT NULL,
`init` longtext NOT NULL,
`id` int(11) NOT NULL auto_increment,
`enabled` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`name`)
);



CREATE TABLE `address_area` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '0',
`cityid` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`)
);



CREATE TABLE `address_city` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `address_quarter` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '0',
`gid` int(11) default NULL,
`cityid` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`)
);



CREATE TABLE `address_street` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '0',
`p_index` varchar(6) NOT NULL,
`cityid` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`)
);



CREATE TABLE `address_house` (
`id` int(10) unsigned NOT NULL auto_increment,
`cityid` int(10) unsigned NOT NULL default '0',
`streetid` int(10) unsigned NOT NULL default '0',
`house` int(11) NOT NULL default '0',
`frac` varchar(30) default NULL,
`amount` smallint(5) unsigned NOT NULL default '0',
`comment` varchar(100) default NULL,
`areaid` int(10) NOT NULL default '0',
`quarterid` int(10) NOT NULL default '0',
`box_index` varchar(10) default NULL,
`dt` date default NULL,
`pod_diapazon` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `House` (`cityid`,`house`,`streetid`,`frac`,`areaid`,`quarterid`)
);



CREATE TABLE `contract_balance` (
`yy` smallint(5) unsigned NOT NULL default '0',
`mm` tinyint(3) unsigned NOT NULL default '0',
`cid` int(10) unsigned NOT NULL default '0',
`summa1` float(10,2) NOT NULL default '0.00',
`summa2` float(10,2) NOT NULL default '0.00',
`summa3` float(10,2) NOT NULL default '0.00',
`summa4` float(10,2) NOT NULL default '0.00',
PRIMARY KEY (`cid`,`yy`,`mm`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_account` (
`yy` smallint(5) unsigned NOT NULL default '0',
`mm` tinyint(3) unsigned NOT NULL default '0',
`cid` int(10) unsigned NOT NULL default '0',
`sid` int(10) unsigned NOT NULL default '0',
`summa` float(15,5) NOT NULL,
PRIMARY KEY (`yy`,`mm`,`cid`,`sid`),
KEY `yy_mm_cid` (`yy`,`mm`,`cid`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_charge` (
`id` int(11) NOT NULL auto_increment,
`dt` date NOT NULL default '0000-00-00',
`cid` int(11) NOT NULL default '0',
`pt` int(11) NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`summa` float NOT NULL default '0',
`comment` char(200) NOT NULL default '',
`lm` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `dt_cid` (`dt`,`cid`),
KEY `dt` (`dt`),
KEY `pt` (`pt`),
KEY `uid` (`uid`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_charge_types` (
`id` int(11) NOT NULL auto_increment,
`title` char(50) NOT NULL default '',
`flag` tinyint(2) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`up` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_comment` (
`id` int(10) unsigned NOT NULL auto_increment,
`cid` int(10) unsigned NOT NULL default '0',
`uid` int(10) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`visibled` bit(1) NOT NULL default '\0',
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_delete_money` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`money` int(10) unsigned NOT NULL default '0',
`time` int(10) unsigned NOT NULL default '0',
`gr` bigint(20) NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_delete_time` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`time` int(10) unsigned NOT NULL default '0',
`gr` bigint(20) NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_error` (
`id` int(11) NOT NULL auto_increment,
`dt` date NOT NULL default '0000-00-00',
`hh` tinyint(3) unsigned NOT NULL default '0',
`cid` int(10) unsigned NOT NULL default '0',
`msg_title` varchar(100) NOT NULL default '',
`msg_data` text NOT NULL,
PRIMARY KEY (`id`),
KEY `dt` (`dt`,`cid`)
);



CREATE TABLE `contract_group` (
`id` tinyint(3) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`enable` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `enable` (`enable`)
);



CREATE TABLE `contract_parameter_group` (
`gid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
KEY `gid` (`gid`)
);



CREATE TABLE `contract_parameter_group_name` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` char(150) NOT NULL default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_parameter_type_1` (
`cid` int(10) unsigned NOT NULL default '0',
`pid` int(10) unsigned NOT NULL default '0',
`val` varchar(255) NOT NULL default '',
PRIMARY KEY (`cid`,`pid`),
UNIQUE KEY `pid_cid` (`pid`,`cid`)
);



CREATE TABLE `contract_parameter_type_2` (
`cid` int(10) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`hid` int(10) unsigned default NULL,
`flat` varchar(10) default NULL,
`room` varchar(5) NOT NULL default '',
`pod` int(10) default '0',
`floor` int(10) default '0',
`address` varchar(255) default NULL,
`comment` varchar(255) default NULL,
PRIMARY KEY (`cid`,`pid`),
KEY `hid` (`hid`)
);



CREATE TABLE `contract_parameter_type_3` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`email` varchar(200) default NULL,
`name` varchar(255) default NULL,
`comment` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cid_pid` (`cid`,`pid`)
);



CREATE TABLE `contract_parameters_pref` (
`id` int(11) NOT NULL auto_increment,
`pt` int(10) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`sort` int(10) unsigned NOT NULL default '0',
`script` text NOT NULL,
`lm` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `sort` (`sort`)
);



CREATE TABLE `contract_parameter_type_3_mail` (
`mailid` int(11) NOT NULL default '0',
`eid` int(11) NOT NULL default '0',
KEY `mailid` (`mailid`),
KEY `eid` (`eid`)
);



CREATE TABLE `contract_parameter_type_4` (
`cid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`val1` int(11) NOT NULL default '0',
`val2` int(11) NOT NULL default '0',
UNIQUE KEY `cid_pid_val1` (`cid`,`pid`,`val1`)
);



CREATE TABLE `contract_parameter_type_4_directory` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(150) default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_pattern` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '',
`closesumma` float NOT NULL default '0',
`tpid` varchar(250) NOT NULL default '',
`groups` bigint(20) NOT NULL default '0',
`mode` int(11) NOT NULL default '0',
`pgid` int(11) NOT NULL default '0',
`pfid` int(11) NOT NULL default '0',
`fc` tinyint(2) NOT NULL default '0',
`dtl` int(10) unsigned NOT NULL default '0',
`tgid` varchar(250) NOT NULL default '',
`scrid` tinyint(3) unsigned NOT NULL default '0',
`name_pattern` varchar(200) NOT NULL default '',
`data` blob,
`patid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_pattern_services` (
`pid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
KEY `pid` (`pid`)
);



CREATE TABLE `contract_payment` (
`id` int(11) NOT NULL auto_increment,
`dt` date NOT NULL default '0000-00-00',
`cid` int(10) unsigned NOT NULL default '0',
`pt` int(10) unsigned NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`summa` float NOT NULL default '0',
`comment` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `pt_dt` (`pt`,`dt`),
KEY `dt_cid` (`dt`,`cid`),
KEY `dt` (`dt`),
KEY `uid` (`uid`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_payment_types` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`up` int(11) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`flag` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `up` (`up`),
KEY `type` (`type`),
KEY `flag` (`flag`)
);



CREATE TABLE `contract_service` (
`id` int(10) unsigned NOT NULL auto_increment,
`cid` int(10) unsigned NOT NULL default '0',
`sid` int(10) unsigned NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`comment` varchar(255) NOT NULL default '',
`lm` date NOT NULL default '0000-00-00',
`emid` int(11) NOT NULL default '0',
`eid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sid` (`sid`),
KEY `date1` (`date1`),
KEY `date2` (`date2`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_tariff` (
`id` int(10) unsigned NOT NULL auto_increment,
`cid` int(10) unsigned NOT NULL default '0',
`tpid` int(10) unsigned NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`comment` varchar(255) NOT NULL default '',
`lm` datetime NOT NULL default '0000-00-00 00:00:00',
`pos` tinyint(4) NOT NULL default '0',
`emid` int(11) NOT NULL default '0',
`eid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);



CREATE TABLE `firm` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(150) NOT NULL default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `log_contract_limit` (
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`uid` int(11) NOT NULL default '0',
`nvalue` float(10,2) NOT NULL default '0.00',
`cid` int(11) NOT NULL default '0',
`comment` varchar(250) NOT NULL,
`days` varchar(4) NOT NULL,
KEY `cid` (`cid`)
);



CREATE TABLE `log_contract_mode` (
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`uid` int(11) NOT NULL default '0',
`mode` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0'
);



CREATE TABLE `log_contract_pswd` (
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`uid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
KEY `cid` (`cid`)
);



CREATE TABLE `module_config` (
`id` int(11) NOT NULL auto_increment,
`mid` int(3) unsigned default '0',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(150) NOT NULL default '0',
`active` tinyint(3) unsigned NOT NULL default '0',
`uid` int(11) unsigned default '0',
`config` text,
PRIMARY KEY (`id`),
KEY `mid_active` (`mid`,`active`)
);



CREATE TABLE `scheduled_class` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) default NULL,
`class` varchar(240) default NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `scheduled_tasks` (
`id` int(11) NOT NULL auto_increment,
`mm` bigint(20) NOT NULL default '0',
`dm` int(11) NOT NULL default '0',
`dw` tinyint(4) NOT NULL default '0',
`hh` int(10) NOT NULL default '0',
`min` bigint(20) NOT NULL default '0',
`prior` int(11) NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`status` tinyint(4) NOT NULL default '0',
`class_id` int(11) NOT NULL default '0',
`comment` varchar(255) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `service` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL,
`mid` int(11) NOT NULL default '0',
`lm` datetime NOT NULL default '0000-00-00 00:00:00',
`isusing` tinyint(1) default '1',
PRIMARY KEY (`id`),
KEY `mid` (`mid`)
);



CREATE TABLE `setup` (
`id` varchar(100) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);



CREATE TABLE `status_log` (
`from_date` datetime NOT NULL default '0000-00-00 00:00:00',
`to_date` datetime default NULL,
`cid` int(10) unsigned NOT NULL default '0',
`mid` int(10) unsigned NOT NULL default '0',
`status` tinyint(4) default NULL,
`uid` tinyint(4) NOT NULL default '0',
`comment` varchar(255) NOT NULL default '',
UNIQUE KEY `main_from_index` (`from_date`,`cid`,`mid`),
UNIQUE KEY `main_to_index` (`to_date`,`cid`,`mid`),
KEY `from_date_index` (`from_date`),
KEY `to_date_index` (`to_date`),
KEY `cid_index` (`cid`)
);



CREATE TABLE `subscr_contact` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`name` char(50) NOT NULL default '',
`email` char(50) NOT NULL default '',
`subject` char(50) NOT NULL default '',
PRIMARY KEY (`id`)
);



CREATE TABLE `tariff_plan` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`lm` datetime NOT NULL default '0000-00-00 00:00:00',
`actual` int(11) NOT NULL default '0',
`gr` bigint(20) NOT NULL,
`pattern` varchar(255) default NULL,
`face` tinyint(4) default NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL auto_increment,
`login` char(15) NOT NULL default '',
`name` char(50) NOT NULL default '',
`descr` char(255) NOT NULL default '',
`pswd` char(32) default NULL,
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`laf` char(100) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
`cgr` bigint(20) NOT NULL default '0',
`pids` varchar(120) default NULL,
`contract_pid` int(11) NOT NULL default '0',
`contract_cid` int(11) NOT NULL default '0',
`config` text NOT NULL,
`crm_user_id` int(11) NOT NULL,
`cgr_mode` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `login` (`login`)
);



CREATE TABLE `user_group` (
`gr_code` smallint(3) unsigned NOT NULL auto_increment,
`gr_name` char(60) default '0',
PRIMARY KEY (`gr_code`),
UNIQUE KEY `gr_code` (`gr_code`),
KEY `gr_code_2` (`gr_code`)
);



CREATE TABLE `user_group_access` (
`gr_code` smallint(3) unsigned NOT NULL default '0',
`ma_id` smallint(3) unsigned NOT NULL default '0',
KEY `gr_code` (`gr_code`,`ma_id`)
);



CREATE TABLE `user_group_entry` (
`gr_code` smallint(3) unsigned NOT NULL default '0',
`parent_gr_code` smallint(3) unsigned NOT NULL default '0',
KEY `gr_code` (`gr_code`,`parent_gr_code`)
);



CREATE TABLE `user_group_member` (
`user_id` smallint(3) unsigned default '0',
`gr_code` smallint(3) unsigned default '0',
KEY `user_id` (`user_id`,`gr_code`)
);



CREATE TABLE `user_module_action` (
`id` int(11) NOT NULL auto_increment,
`module` char(30) NOT NULL default '0',
`type` int(11) NOT NULL default '0',
`action` char(40) NOT NULL default '0',
`description` char(120) default '0',
PRIMARY KEY (`id`),
KEY `module_action` (`module`,`action`)
);



CREATE TABLE `user_user_access` (
`user_id` smallint(3) unsigned NOT NULL default '0',
`ma_id` smallint(3) unsigned default '0',
KEY `user_id_2` (`user_id`,`ma_id`)
);



CREATE TABLE `log_login_pswd` (
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`uid` int(11) NOT NULL default '0',
`mid` int(11) NOT NULL default '0',
`lid` int(11) NOT NULL default '0',
KEY `lid_mid` (`lid`,`mid`)
);



CREATE TABLE `module_tariff_tree` (
`id` int(10) NOT NULL auto_increment,
`mid` int(10) NOT NULL default '0',
`tree_id` int(10) NOT NULL default '0',
`parent_tree` int(10) NOT NULL default '0',
`lm` bigint(20) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `tree_id` (`tree_id`),
KEY `mid_tree` (`mid`,`tree_id`)
);



CREATE TABLE `mtree_node` (
`id` int(10) unsigned NOT NULL auto_increment,
`parent_node` int(10) unsigned NOT NULL default '0',
`mtree_id` int(10) unsigned NOT NULL default '0',
`type` varchar(20) NOT NULL default '',
`data` text NOT NULL,
`pos` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `tree_id` (`mtree_id`)
);



CREATE TABLE `tariff_tree` (
`id` int(10) NOT NULL auto_increment,
`parent_tree` int(3) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent` (`parent_tree`)
);



CREATE TABLE `tariff_tree_config` (
`module` varchar(20) NOT NULL default '0',
`data` longtext NOT NULL,
PRIMARY KEY (`module`)
);



CREATE TABLE `tariff_tree_link` (
`tpid` int(11) NOT NULL default '0',
`tree_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tpid`)
);



CREATE TABLE `contract_tree_link` (
`id` int(11) NOT NULL auto_increment,
`cid` int(10) NOT NULL default '0',
`tree_id` int(10) NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
`date1` date default NULL,
`date2` date default NULL,
`pos` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);



CREATE TABLE `mail_list` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(50) default '0',
`flag` int(1) unsigned default '0',
`type` tinyint(1) unsigned default '0',
`up` int(11) unsigned default '0',
PRIMARY KEY (`id`),
KEY `up` (`up`)
);



CREATE TABLE `mail_temp` (
`id` int(11) NOT NULL default '0',
`eid` int(11) default NULL,
`dt` datetime default NULL
);



CREATE TABLE `mail_list_message` (
`id` int(11) unsigned NOT NULL default '0',
`subject` varchar(255) default NULL,
`text` text,
PRIMARY KEY (`id`)
);



CREATE TABLE `user_dispatch` (
`id` int(10) unsigned NOT NULL auto_increment,
`cid` int(10) unsigned NOT NULL default '0',
`mails` varchar(200) NOT NULL default '',
`type` int(10) unsigned NOT NULL default '0',
`params` varchar(255) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`status` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);



CREATE TABLE `user_dispatch_reference` (
`id` int(3) unsigned NOT NULL auto_increment,
`mid` int(3) unsigned default '0',
`module` varchar(30) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`class_name` varchar(200) NOT NULL default '',
`web_action` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `mid` (`mid`)
);



CREATE TABLE `contract_limit_period` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`dt` date default NULL,
`value` float(10,2) NOT NULL default '0.00',
PRIMARY KEY (`id`),
KEY `dt` (`dt`)
);



CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`gr` bigint(20) NOT NULL default '0',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(150) NOT NULL default '',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `source` (
`id` int(11) NOT NULL auto_increment,
`mid` int(11) NOT NULL default '0',
`title` varchar(20) NOT NULL default '',
`date1` date default NULL,
`date2` date default NULL,
`comment` varchar(255) NOT NULL default '',
`source_type` tinyint(4) NOT NULL default '0',
`host_or_dir` varchar(250) NOT NULL,
`user` varchar(15) NOT NULL default '',
`pswd` varchar(15) NOT NULL default '',
`config` text NOT NULL,
`lm` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `mid` (`mid`),
KEY `date1` (`date1`),
KEY `date2` (`date2`)
);



CREATE TABLE `task_proccess` (
`id` int(10) unsigned NOT NULL auto_increment,
`mid` int(11) NOT NULL default '0',
`title` char(200) NOT NULL default '',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`param` int(11) NOT NULL default '0',
`start_process_time` datetime default NULL,
PRIMARY KEY (`id`),
KEY `spt` (`start_process_time`)
);



CREATE TABLE `task_load` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` char(200) NOT NULL default '',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`param` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`le` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `le` (`le`)
);



CREATE TABLE `contract_parameter_type_5` (
`cid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`val` int(2) NOT NULL default '0',
UNIQUE KEY `cid_pid` (`cid`,`pid`)
);



CREATE TABLE `contract_parameter_type_6` (
`cid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`val` date default NULL,
UNIQUE KEY `cid_pid` (`cid`,`pid`)
);



CREATE TABLE `contract_parameter_type_7` (
`cid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`val` int(11) NOT NULL default '0',
UNIQUE KEY `cid_pid` (`cid`,`pid`)
);



CREATE TABLE `contract_parameter_type_7_values` (
`id` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `pid` (`pid`)
);



CREATE TABLE `payment_register` (
`id` int(11) NOT NULL auto_increment,
`date` date default NULL,
`title` varchar(200) NOT NULL default '',
`pt` int(11) NOT NULL default '0',
`load_time` datetime default NULL,
`count` int(3) NOT NULL default '0',
`summa` decimal(10,2) NOT NULL default '0.00',
`processed` tinyint(2) NOT NULL default '0',
`process_time` datetime default NULL,
`load_log` text NOT NULL,
KEY `id` (`id`),
KEY `date` (`date`)
);



CREATE TABLE `payment_register_item` (
`id` int(11) NOT NULL auto_increment,
`rid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`summa` float(10,2) NOT NULL default '0.00',
`pid` int(11) NOT NULL default '0',
`comment` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `rid` (`rid`)
);



CREATE TABLE `tariff_group` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`tm` tinyint(3) NOT NULL default '0',
`df` int(11) NOT NULL default '0',
`beh` int(11) NOT NULL default '0',
`pos` int(11) NOT NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `tariff_group_tariff` (
`tgid` int(11) NOT NULL default '0',
`tpid` int(11) NOT NULL default '0',
KEY `tgid` (`tgid`)
);



CREATE TABLE `contract_tariff_group` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`gid` int(11) NOT NULL default '0',
`comment` char(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);



CREATE TABLE `contract_script` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`script_id` int(11) NOT NULL default '0',
`comment` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);



CREATE TABLE `script` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
);



CREATE TABLE `script_event_queue` (
`id` int(11) NOT NULL auto_increment,
`event` longblob NOT NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `script_event_type` (
`id` int(11) NOT NULL auto_increment,
`mid` varchar(100) NOT NULL,
`event_mode` tinyint(4) NOT NULL default '1',
`event_id` int(11) NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `mid_event` (`mid`,`event_id`)
);



CREATE TABLE `script_function` (
`id` int(11) NOT NULL auto_increment,
`script_id` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`code` text,
PRIMARY KEY (`id`),
KEY `script_id` (`script_id`)
);



CREATE TABLE `script_function_event_type` (
`fid` int(11) NOT NULL default '0',
`mid` varchar(100) NOT NULL,
`event_id` int(11) NOT NULL default '0',
KEY `fid` (`fid`)
);



CREATE TABLE `object_type` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`name_macros` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
);



CREATE TABLE `object_param` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`type` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
);



CREATE TABLE `object_type_param` (
`type_id` int(11) NOT NULL default '0',
`param_id` int(11) NOT NULL default '0',
`pos` int(11) NOT NULL default '0',
PRIMARY KEY (`type_id`,`param_id`)
);



CREATE TABLE `object` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`type_id` int(11) NOT NULL default '0',
`date1` date default NULL,
`date2` date default NULL,
`pos` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `cid` (`cid`),
KEY `pos` (`pos`)
);



CREATE TABLE `object_list_value` (
`id` int(11) NOT NULL auto_increment,
`param_id` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `param_id` (`param_id`)
);



CREATE TABLE `object_param_value_text` (
`object_id` int(11) NOT NULL default '0',
`param_id` int(11) NOT NULL default '0',
`value` varchar(250) NOT NULL default '',
PRIMARY KEY (`param_id`,`object_id`)
);



CREATE TABLE `object_param_value_address` (
`object_id` int(11) NOT NULL default '0',
`param_id` int(11) NOT NULL default '0',
`hid` int(11) NOT NULL default '0',
`flat` varchar(15) NOT NULL default '0',
`room` varchar(20) NOT NULL default '',
`pod` int(11) NOT NULL default '0',
`floor` int(11) NOT NULL default '0',
`address` varchar(250) NOT NULL default '',
`comment` varchar(250) NOT NULL default '',
PRIMARY KEY (`param_id`,`object_id`)
);



CREATE TABLE `object_param_value_date` (
`object_id` int(11) NOT NULL default '0',
`param_id` int(11) NOT NULL default '0',
`value` date default NULL,
PRIMARY KEY (`param_id`,`object_id`)
);



CREATE TABLE `object_param_value_list` (
`object_id` int(11) NOT NULL default '0',
`param_id` int(11) NOT NULL default '0',
`value` int(11) NOT NULL default '0',
PRIMARY KEY (`param_id`,`object_id`)
);



CREATE TABLE `user_tables` (
`userId` int(11) default NULL,
`table_module` varchar(100) default NULL,
`table_id` varchar(100) default NULL,
`widths` text,
`positions` text,
`hiddens` text,
KEY `userId` (`userId`),
KEY `table_module` (`table_module`)
);



CREATE TABLE `register_group_task_type` (
`gid` int(11) NOT NULL default '0',
`type_id` int(11) NOT NULL default '0',
KEY `gid` (`gid`)
);



CREATE TABLE `bgs_group` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`comment` varchar(250) NOT NULL default '',
`cgr` bigint(20) NOT NULL default '0',
`pids` varchar(120) default NULL,
`cgr_mode` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
);



CREATE TABLE `bgs_group_action` (
`gid` int(11) NOT NULL default '0',
`mid` varchar(10) NOT NULL,
`aid` int(11) NOT NULL default '0',
KEY `gid` (`gid`)
);



CREATE TABLE `bgs_user_group` (
`uid` int(11) NOT NULL default '0',
`gid` int(11) NOT NULL default '0',
KEY `uid` (`uid`),
KEY `gid` (`gid`)
);



CREATE TABLE `bgs_module_action` (
`module` varchar(100) NOT NULL default '',
`data` text NOT NULL,
PRIMARY KEY (`module`)
);



CREATE TABLE `bgs_user_action` (
`uid` int(11) NOT NULL default '0',
`mid` varchar(10) NOT NULL,
`aid` int(11) NOT NULL default '0',
KEY `uid` (`uid`)
);



CREATE TABLE `contract_parameter_type_8` (
`cid` int(11) NOT NULL default '0',
`pid` int(11) NOT NULL default '0',
`val` int(11) NOT NULL default '0',
UNIQUE KEY `cid_pid` (`cid`,`pid`)
);



CREATE TABLE `web_request_count` (
`cid` int(11) NOT NULL default '0',
`date` date NOT NULL default '0000-00-00',
`count` int(11) NOT NULL default '0',
UNIQUE KEY `cid` (`cid`)
);



CREATE TABLE `time_type` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_limit_manage` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL,
`clp_id` int(11) default NULL,
`summ` float(10,2) default NULL,
`date1` datetime NOT NULL,
`date2` date default NULL,
`pids` varchar(100) default NULL,
`rest` float(10,2) NOT NULL default '0.00',
`status` int(11) default '0',
PRIMARY KEY (`id`),
KEY `cid` (`cid`),
KEY `clp_id` (`clp_id`)
);



CREATE TABLE `contract_limit_manage_mode` (
`cid` int(11) NOT NULL,
`mode` int(11) NOT NULL default '0',
`cnt` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`)
);



CREATE TABLE `log_contract_limit_manage_mode` (
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`uid` int(11) NOT NULL default '0',
`mode` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
KEY `cid` (`cid`)
);



CREATE TABLE `web_request_limit` (
`cid` int(11) NOT NULL default '0',
`lim` int(11) default NULL,
PRIMARY KEY (`cid`)
);



CREATE TABLE `scheduled_task_run` (
`id` int(11) NOT NULL auto_increment,
`data` blob,
PRIMARY KEY (`id`)
);



CREATE TABLE `contract_logon_error` (
`lu` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`cid` int(11) NOT NULL,
`login` varchar(255) NOT NULL,
`dt` datetime NOT NULL,
`ip` varchar(15) NOT NULL,
`error_code` int(11) NOT NULL,
`request_data` text NOT NULL,
KEY `cid_dt` (`cid`,`dt`),
KEY `login_dt` (`login`,`dt`)
);



CREATE TABLE `contract_logon_last` (
`lu` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`cid` int(11) NOT NULL,
`dt` datetime NOT NULL,
`n` int(11) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`cid`),
KEY `new_index` (`cid`)
);



CREATE TABLE `contract_logon_ok` (
`lu` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`cid` int(11) NOT NULL,
`dt` datetime NOT NULL,
`ip` varchar(15) NOT NULL,
`session_id` varchar(32) NOT NULL,
`user` enum('p','c','a') NOT NULL default 'c',
KEY `new_index` (`cid`,`dt`)
);



CREATE TABLE `plugin_config` (
`pid` int(11) NOT NULL,
`config` text,
PRIMARY KEY USING BTREE (`pid`)
);



CREATE TABLE `contract_password_once` (
`lu` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`dt` datetime NOT NULL,
`contract_title` varchar(150) NOT NULL,
`password` varchar(64) NOT NULL,
UNIQUE KEY `password` USING BTREE (`password`)
);



CREATE TABLE `object_type_module` (
`type_id` int(11) NOT NULL,
`mid` int(11) NOT NULL,
UNIQUE KEY `type_mid` (`mid`,`type_id`)
);



CREATE TABLE `contract_status` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL,
`status` tinyint(4) NOT NULL,
`uid` int(11) NOT NULL,
`date1` date NOT NULL,
`date2` date default NULL,
`comment` varchar(250) NOT NULL,
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
);

INSERT INTO user (login, name, pswd, config) VALUES ('admin', 'admin', '21232F297A57A5A743894A0E4A801FC3', '');

INSERT INTO setup VALUES ( 1, "00.00.0000" );

INSERT INTO contract_group VALUES ( 0, 'Группа 00', 0 );
INSERT INTO contract_group VALUES ( 1, 'Группа 01', 0 );
INSERT INTO contract_group VALUES ( 2, 'Группа 02', 0 );
INSERT INTO contract_group VALUES ( 3, 'Группа 03', 0 );
INSERT INTO contract_group VALUES ( 4, 'Группа 04', 0 );
INSERT INTO contract_group VALUES ( 5, 'Группа 05', 0 );
INSERT INTO contract_group VALUES ( 6, 'Группа 06', 0 );
INSERT INTO contract_group VALUES ( 7, 'Группа 07', 0 );
INSERT INTO contract_group VALUES ( 8, 'Группа 08', 0 );
INSERT INTO contract_group VALUES ( 9, 'Группа 09', 0 );
INSERT INTO contract_group VALUES ( 10, 'Группа 10', 0 );
INSERT INTO contract_group VALUES ( 11, 'Группа 11', 0 );
INSERT INTO contract_group VALUES ( 12, 'Группа 12', 0 );
INSERT INTO contract_group VALUES ( 13, 'Группа 13', 0 );
INSERT INTO contract_group VALUES ( 14, 'Группа 14', 0 );
INSERT INTO contract_group VALUES ( 15, 'Группа 15', 0 );
INSERT INTO contract_group VALUES ( 16, 'Группа 16', 0 );
INSERT INTO contract_group VALUES ( 17, 'Группа 17', 0 );
INSERT INTO contract_group VALUES ( 18, 'Группа 18', 0 );
INSERT INTO contract_group VALUES ( 19, 'Группа 19', 0 );
INSERT INTO contract_group VALUES ( 20, 'Группа 20', 0 );
INSERT INTO contract_group VALUES ( 21, 'Группа 21', 0 );
INSERT INTO contract_group VALUES ( 22, 'Группа 22', 0 );
INSERT INTO contract_group VALUES ( 23, 'Группа 23', 0 );
INSERT INTO contract_group VALUES ( 24, 'Группа 24', 0 );
INSERT INTO contract_group VALUES ( 25, 'Группа 25', 0 );
INSERT INTO contract_group VALUES ( 26, 'Группа 26', 0 );
INSERT INTO contract_group VALUES ( 27, 'Группа 27', 0 );
INSERT INTO contract_group VALUES ( 28, 'Группа 28', 0 );
INSERT INTO contract_group VALUES ( 29, 'Группа 29', 0 );
INSERT INTO contract_group VALUES ( 30, 'Группа 30', 0 );
INSERT INTO contract_group VALUES ( 31, 'Группа 31', 0 );
INSERT INTO contract_group VALUES ( 32, 'Группа 32', 0 );
INSERT INTO contract_group VALUES ( 33, 'Группа 33', 0 );
INSERT INTO contract_group VALUES ( 34, 'Группа 34', 0 );
INSERT INTO contract_group VALUES ( 35, 'Группа 35', 0 );
INSERT INTO contract_group VALUES ( 36, 'Группа 36', 0 );
INSERT INTO contract_group VALUES ( 37, 'Группа 37', 0 );
INSERT INTO contract_group VALUES ( 38, 'Группа 38', 0 );
INSERT INTO contract_group VALUES ( 39, 'Группа 39', 0 );
INSERT INTO contract_group VALUES ( 40, 'Группа 40', 0 );
INSERT INTO contract_group VALUES ( 41, 'Группа 41', 0 );
INSERT INTO contract_group VALUES ( 42, 'Группа 42', 0 );
INSERT INTO contract_group VALUES ( 43, 'Группа 43', 0 );
INSERT INTO contract_group VALUES ( 44, 'Группа 44', 0 );
INSERT INTO contract_group VALUES ( 45, 'Группа 45', 0 );
INSERT INTO contract_group VALUES ( 46, 'Группа 46', 0 );
INSERT INTO contract_group VALUES ( 47, 'Группа 47', 0 );
INSERT INTO contract_group VALUES ( 48, 'Группа 48', 0 );
INSERT INTO contract_group VALUES ( 49, 'Группа 49', 0 );
INSERT INTO contract_group VALUES ( 50, 'Группа 50', 0 );
INSERT INTO contract_group VALUES ( 51, 'Группа 51', 0 );
INSERT INTO contract_group VALUES ( 52, 'Группа 52', 0 );
INSERT INTO contract_group VALUES ( 53, 'Группа 53', 0 );
INSERT INTO contract_group VALUES ( 54, 'Группа 54', 0 );
INSERT INTO contract_group VALUES ( 55, 'Группа 55', 0 );
INSERT INTO contract_group VALUES ( 56, 'Группа 56', 0 );
INSERT INTO contract_group VALUES ( 57, 'Группа 57', 0 );
INSERT INTO contract_group VALUES ( 58, 'Группа 58', 0 );
INSERT INTO contract_group VALUES ( 59, 'Группа 59', 0 );
INSERT INTO contract_group VALUES ( 60, 'Группа 60', 0 );
INSERT INTO contract_group VALUES ( 61, 'Группа 61', 0 );
INSERT INTO contract_group VALUES ( 62, 'Группа 62', 0 );

INSERT INTO scheduled_class( title, class ) VALUES( "Удаление старых договоров", "bitel.billing.server.contract.CleanerContract");
INSERT INTO scheduled_class( title, class ) VALUES( "Генератор заданий на загрузку логов", "bitel.billing.server.load.TaskGenerator");
INSERT INTO scheduled_class( title, class ) VALUES( "Рассыльщик почты", "bitel.billing.server.mail.MailSender");
INSERT INTO scheduled_class( title, class ) VALUES( "Восстановление лимитов", "bitel.billing.server.contract.LimitRestorer");
INSERT INTO scheduled_class( title, class ) VALUES( "Пользовательские рассылки", "bitel.billing.server.mail.UserDispatchSender");
INSERT INTO scheduled_class( title, class ) VALUES( "Мониторинг договоров", "bitel.billing.server.contract.ContractMonitor");
INSERT INTO scheduled_class( title, class ) VALUES( "Генератор событий таймера", "bitel.billing.server.script.TimerEventGenerate");
INSERT INTO scheduled_class( title, class ) VALUES( "Рассылка о понижении лимита", "bitel.billing.server.contract.DebtMailSender");
INSERT INTO scheduled_class( title, class ) VALUES( "Установка статусов договоров", "bitel.billing.server.contract.ContractStatusSetter");
INSERT INTO scheduled_class( title, class ) VALUES( "Загрузка платежей из файлов", "bitel.billing.server.admin.integration.PaymentLoader");

INSERT INTO user_dispatch_reference ( mid, module, title, class_name, web_action ) VALUES( 0, "contract", "Рассылка баланса", "bitel.billing.server.contract.bean.DispatchBalance", "DispatchBalance");

INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 1, "Приход платежа");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 3, "Таймер");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 2, "Занесение расхода");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 4, "Смена тарифа по заданию пользователя");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 5, "Договор создан");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 9, "Изменен параметр договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 10, "Перед удалением услуги договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 11, "Изменение/добавления услуги договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 12, "Получение списка доп. действия для Web статистики");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 15, "Получение списка доп. действия для договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 16, "Обработка доп. действия для договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 18, "Изменение статуса договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 19, "Статус договора изменен");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 20, "Запрос дат с которых разрешена смена тарифа через Web");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 21, "Перед изменением параметра договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 22, "Добавление объекта договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 23, "Изменение объекта договора");
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( 0, 24, "Удаление объекта договора");

GRANT ALL PRIVILEGES ON bgbilling.* TO 'bill'@'localhost' IDENTIFIED BY 'bgbilling';
GRANT ALL PRIVILEGES ON bgbilling.* TO 'bill'@'%' IDENTIFIED BY 'bgbilling';

java.sql.SQLException: Access denied for user 'bill'@'localhost' (using password: YES)
перевод конечно не требуется, но всетаки я не понимаю что не так?

Его нужно выполнить таким способом:

Т.е. его SQL сервер выполняет.

рекоменудется прочитать :
http://bgbilling.ru/v4.5/doc/ch01s05.html
и выполнить все по шагам

вот именно если делать так как там написано, то ни чего вооообще не работает, ни мускул не запускается, ни сервер

ну тогда давайте логи, ошикби ..что не запускается .. Если вы dump вообще не заливали, значит не делали как там написано

вотт в этих строках в конце дампа


как раз создается пользоватедль bill , а вы дамп не хотите заливать как я понимаю ..наверное по идиологическим соображениям

так, ладно с этим я разобрался, по видимому распоковка самого мускула прошла не совсем корректно, и сам mysql.exe был нулевого размера, переустановил и теперь уже эту ошибку не выдает, теперь ошибка "не удалось соединиться с сервером"

все заработало ОГРОМНОЕ СПАСИБО ЗА ПОДДЕРЖКУ
С Наступающим Вас Новым Годом

И Вам успехов в новом году!