CREATE TABLE channel_$mid
(	
	id int(11) NOT NULL auto_increment,
	title varchar(200) NOT NULL default '',
	PRIMARY KEY  (id) 
);

CREATE TABLE channel_mapping_$mid
(
	id int(11) NOT NULL auto_increment,
	chid int(11) NOT NULL default '0',
	date1 date default NULL,
	date2 date default NULL,
	chcode int(11) NOT NULL default '0',
	cncode int(11) NOT NULL default '0',
	comment varchar(250) NOT NULL default '',
	PRIMARY KEY  (id),
	KEY chid (chid),
	KEY chcode (cncode) 
);

CREATE TABLE packet_$mid
(
	id int(11) NOT NULL auto_increment,
	title varchar(200) NOT NULL default '',
	sid int(11) NOT NULL default '0',
	virtual_cinema TINYINT(1)  NOT NULL, 
	PRIMARY KEY (id) 
);

CREATE TABLE packet_channel_$mid
(
	id int(11) NOT NULL auto_increment,
	pid int(11) NOT NULL default '0',
	chid int(11) NOT NULL default '0',
	date1 date default NULL,
	date2 date default NULL,
	comment varchar(250) NOT NULL default '',
	PRIMARY KEY  (id) 
);

CREATE TABLE event_log_$mid
(
	cpid int(11) NOT NULL default '0',
	dt date default NULL,
	type tinyint(4) NOT NULL default '0',
	uid int(11) NOT NULL default '0',
	UNIQUE KEY cpid_dtime (dt,cpid),
	KEY cpid (cpid) 
);

CREATE TABLE user_card_$mid
(
	id int(11) NOT NULL auto_increment,
	cid int(11) NOT NULL default '0',
	number int(11) NOT NULL default '0',
	date1 date default NULL,
	date2 date default NULL,
	subscr_dt DATE,
	comment varchar(250) NOT NULL default '',
	PRIMARY KEY  (id),
	KEY cid (cid),
	KEY number (number) 
);

CREATE TABLE card_packet_$mid
(
	id int(11) NOT NULL auto_increment,
	cid int(11) NOT NULL default '0',
	ucid int(11) NOT NULL default '0',
	status tinyint(4) NOT NULL default '0',
	pid int(11) NOT NULL default '0',
	date1 datetime default NULL,
	date2 datetime default NULL,
	comment varchar(250) NOT NULL default '',
	PRIMARY KEY  (id),
	KEY cid (cid),
	KEY pid (pid),
	KEY ucid (ucid) 
);

CREATE TABLE card_$mid
(
	number INT NOT NULL, 
	pswd VARCHAR(200) NOT NULL,
	dealer_id INT NOT NULL,
	pass_dt DATE, 
	cid INT NOT NULL,
	contract_dt DATE, 
	PRIMARY KEY(number), 
	UNIQUE(number) 
);

CREATE TABLE dealer_$mid
(
	id INT NOT NULL AUTO_INCREMENT, 
	title VARCHAR (200) NOT NULL, 
	date1 DATE, 
	date2 DATE, 
	comment VARCHAR (250) NOT NULL, 
	PRIMARY KEY(id)
);

ALTER TABLE packet_$mid ADD virtual_cinema TINYINT(1)  NOT NULL;
ALTER TABLE card_packet_$mid CHANGE date1 date1 datetime default NULL;
ALTER TABLE card_packet_$mid CHANGE date2 date2 datetime default NULL;

ALTER TABLE channel_mapping_$mid ADD scode INT NOT NULL DEFAULT 0;

ALTER TABLE card_$mid ADD pswd VARCHAR(200) NOT NULL;

CREATE TABLE packet_detail_$mid	( 
	id INT auto_increment,
	pid INT NOT NULL, 
	yy SMALLINT NOT NULL, 
	mm 	SMALLINT NOT NULL,
	day SMALLINT NOT NULL,
	summa	float NOT NULL,
	PRIMARY KEY  (id),
	KEY client_packet (pid,yy,mm,day));
	
ALTER TABLE `channel_mapping_$mid` MODIFY COLUMN `chcode` VARCHAR(100) NOT NULL DEFAULT '0';

ALTER TABLE `user_card_$mid` MODIFY COLUMN `number` BIGINT NOT NULL;
	
ALTER TABLE `packet_$mid` ADD COLUMN `depends` VARCHAR(255) NOT NULL AFTER `virtual_cinema`,
 ADD COLUMN `unacceptable` VARCHAR(255) NOT NULL AFTER `depends`;

CREATE TABLE user_card_copy_$mid
(	
	id INT auto_increment,
	uid INT(11) NOT NULL,
	date1 date default NULL,
	date2 date default NULL,
	comment varchar(250) NOT NULL default '',
	PRIMARY KEY(id),
	KEY number(uid)
);

ALTER TABLE `packet_$mid` ADD COLUMN `free` tinyint(3) unsigned NOT NULL default '0';
 
ALTER TABLE `packet_$mid` ADD COLUMN `pcode` VARCHAR(100) NOT NULL;

ALTER TABLE `packet_$mid` ADD COLUMN `comment` TEXT NULL;

ALTER TABLE `user_card_$mid` ADD COLUMN `basecardId` INTEGER NOT NULL DEFAULT 0;

ALTER TABLE `user_card_$mid` ADD COLUMN `object_id` INT  NOT NULL DEFAULT -1;

ALTER TABLE `user_card_$mid` ADD COLUMN `need_sync` TINYINT(1)  NULL DEFAULT 0;

CREATE TABLE `cerbercrypt_user_devices_$mid` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(256) NULL ,
  `comment` TEXT NULL ,
  `config` TEXT NULL ,
  PRIMARY KEY (`id`) );

ALTER TABLE `user_card_$mid` ADD COLUMN `userdevice_id` INT(11) NOT NULL DEFAULT 0;

CREATE TABLE `cerbercrypt_gradually_subscription_$mid` (
  `entityId` INT NOT NULL ,
  `date` DATE NOT NULL ,
  PRIMARY KEY (`entityId`) );

ALTER TABLE `packet_$mid` CHANGE COLUMN `pcode` `pcode` VARCHAR(100) NULL;

ALTER TABLE `packet_$mid` ADD COLUMN `can_web_open` TINYINT(1) NOT NULL DEFAULT 0  AFTER `sid` , ADD COLUMN `can_web_close` TINYINT(1) NOT NULL DEFAULT 0  AFTER `can_web_open` ;

-- #BLOCK#
DELETE FROM script_event_type WHERE mid=$mid;
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 1, '  ');
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 2, '   ');
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 3, '   ');
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 4, '  ');
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 5, '  ');
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES ($mid, 'ru.bitel.bgbilling.kernel.event.events.CalculateEvent', 0, '');
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 7, '   ');
-- #ENDB#

