CREATE TABLE IF NOT EXISTS trayinfo_login_$mid
( 
	id int(11) NOT NULL auto_increment,
	type int NOT NULL,
	cid int NOT NULL,
	pswd char(100) NOT NULL default '',
	date1 date default NULL,
	date2 date default NULL,
	PRIMARY KEY ( id ),
	KEY type( type )
);

CREATE TABLE IF NOT EXISTS trayinfo_type_$mid
( 
	id int NOT NULL auto_increment,
	title varchar(100) NOT NULL,
	pt int NOT NULL,
	cost float NOT NULL,
	days int NOT NULL,
	date1 date default NULL,
	date2 date default NULL,
	PRIMARY KEY ( id ),
	KEY date1( date1 ),
	KEY date2( date2 )
);

-- #BLOCK#
DELETE FROM script_event_type WHERE mid="$mid";
INSERT INTO script_event_type ( mid, event_id, title ) VALUES( '$mid', 100, " " );
-- #ENDB#