/gist:64514e6991b57a8b294c Secret

## gistfile1.txt
BEGIN
/*!*/;
# at 798155263
#150601 18:49:04 server id 1  end_log_pos 79835468      Query   thread_id=433   exec_time=0     error_code=0
UPDATE assignmentuser SET state='YToxOntpOjIzNTM7YToxOntpOjI7czoxNDoiYW9fc2NvXzAwXzE4ODYiO319' WHERE assignmentid='3058' AND userid='4101698'
/*!*/;
# at 79835468
#150601 18:49:04 server id 1  end_log_pos 79855495      Xid = 141678
COMMIT/*!*/;


BEGIN
/*!*/;
# at 79835567
#150601 18:49:04 server id 1  end_log_pos 79835793      Query   thread_id=435   exec_time=0     error_code=0
use `yshop_14`/*!*/;
/*!*/;
# at 79835793
#150601 18:49:04 server id 1  end_log_pos 79835821      Intvar
SET INSERT_ID=3152125/*!*/;
# at 79835821
#150601 18:49:04 server id 1  end_log_pos 79836058      Query   thread_id=435   exec_time=0     error_code=0
/*!*/;
# at 79836058
#150601 18:49:04 server id 1  end_log_pos 79836085      Xid = 15715
COMMIT/*!*/;

BEGIN
/*!*/;
# at 14988913
#150602 18:12:01 server id 1  end_log_pos 14988941      Intvar
SET INSERT_ID=11446/*!*/;
# at 14988941
#150602 18:12:01 server id 1  end_log_pos 14989804      Query   thread_id=27291 exec_time=0     error_code=0
use `iteach_14`/*!*/;
SET TIMESTAMP=1433261521/*!*/;
INSERT INTO `user` (^M
                                                        login,^M
                                                        password,^M
                                                        password_salt,^M
                                                        role_id,^M
                                                        firstname,^M
                                                        lastname,^M
                                                        email,^M
                                                        processallow,^M
                                                        allow_remind_email,^M
                                                        created,^M
                                                        sso_id,^M
                                                        quota,^M
                                                        trial_period_date,^M
                                                        active,^M
                                                        creator_id,^M
                                                        info_message_counter,^M
                                                        giodo_accept_date,^M
                                                        uid^M
                                                ) VALUES(^M
                                                        'somename',^M
                                                        '68319866167f18364375ca61a',^M
                                                        '8e7ae',^M
                                                        4,^M
                                                        'name',^M
                                                        'surname',^M
                                                        'nsurname@d.edu',^M
                                                        1,^M
                                                        1,^M
                                                        143321,^M
                                                        '149b242acbb51ec344a501',^M
                                                        '50',^M
                                                        0,^M
                                                        '1',^M
                                                        0,^M
                                                        0,^M
                                                        0,^M
                                                        '149b24fc9d402acbb51ec344a501'^M
                                                )
/*!*/;
# at 14989804
#150602 18:12:01 server id 1  end_log_pos 14989831      Xid = 675698
COMMIT/*!*/;

BEGIN
/*!*/;
# at 96031080
#150601 23:45:01 server id 1  end_log_pos 96031108      Intvar
SET INSERT_ID=481699/*!*/;
# at 96031108
#150601 23:45:01 server id 1  end_log_pos 96031339      Query   thread_id=9961  exec_time=0     error_code=0
INSERT INTO codes (package_id,code,add_date,exp_date,licence_duration,students_licences,comment) VALUES ('1693', 'vvvv', 1443109600, 15381293600, '12', '1', NULL)
/*!*/;
# at 96031339
#150601 23:45:01 server id 1  end_log_pos 96031366      Xid = 228697
COMMIT/*!*/;

 BEGIN
/*!*/;
# at 14989903
#150602 18:12:01 server id 1  end_log_pos 14990129      Query   thread_id=27293 exec_time=0     error_code=0
use `yshop_14`/*!*/;
SET TIMESTAMP=1433261521/*!*/;
/*!*/;
# at 14990129
#150602 18:12:01 server id 1  end_log_pos 14990157      Intvar
SET INSERT_ID=2154510/*!*/;
# at 14990157
#150602 18:12:01 server id 1  end_log_pos 14990394      Query   thread_id=27293 exec_time=0     error_code=0
SET TIMESTAMP=1433261521/*!*/;
/*!*/;
# at 14990394
#150602 18:12:01 server id 1  end_log_pos 14990421      Xid = 675717
COMMIT/*!*/;


BEGIN
/*!*/;
# at 96031439
#150601 23:45:01 server id 1  end_log_pos 960211690     Query   thread_id=9961  exec_time=0     error_code=0
UPDATE codes SET code='xxxxx', status=0, students_licences='1', licences_used=NULL, unlock_date=NULL, licence_till=NULL, user_id=NULL, school_id=NULL, comment=NULL WHERE id='481699'
/*!*/;
# at 960211690
#150601 23:45:01 server id 1  end_log_pos 96021717      Xid = 2281699
COMMIT/*!*/;

BEGIN
/*!*/;
# at 15010641
#150602 18:12:16 server id 1  end_log_pos 15011393      Query   thread_id=27305 exec_time=0     error_code=0
use `iteach_14`/*!*/;
SET TIMESTAMP=1433261536/*!*/;
UPDATE^M
                                                        `user`^M
                                                SET ^M
                                                        login                                                   =       'name',^M
                                                        role_id                                                 =       '4',^M
                                                        firstname                                               =       'namen',^M
                                                        lastname                                                =       'surname',^M
                                                        email                                                   =       'dsafdasf@dasf.edu',^M
                                                        forcepasschange                                 =       0,^M
                                                        processallow                                    =       '0',^M
                                                        allow_remind_email                              =       '1',^M
                                                        sso_id                                                  =       '149b5b701f26b1402acbb51ec344a501',^M
                                                        trial_period_date                               =   '0',^M
                                                        quota                                                   =       '50',^M
                                                        active                                                  =       1,^M
                                                        creator_id                                              =       0,^M
                                                        info_message_counter                    =       0,^M
                                                        giodo_accept_date                               =       0,^M
                                                        uid                                                             =       '149b24fc9d945b701a501'^M
                                                        ^M
                                                WHERE^M
                                                        id = '11446'
/*!*/;
# at 15011393
#150602 18:12:16 server id 1  end_log_pos 15011420      Xid = 675924
COMMIT/*!*/;
	BEGIN
	/!/;
	# at 798155263
	#150601 18:49:04 server id 1 end_log_pos 79835468 Query thread_id=433 exec_time=0 error_code=0
	UPDATE assignmentuser SET state='YToxOntpOjIzNTM7YToxOntpOjI7czoxNDoiYW9fc2NvXzAwXzE4ODYiO319' WHERE assignmentid='3058' AND userid='4101698'
	/!/;
	# at 79835468
	#150601 18:49:04 server id 1 end_log_pos 79855495 Xid = 141678
	COMMIT/!/;


	BEGIN
	/!/;
	# at 79835567
	#150601 18:49:04 server id 1 end_log_pos 79835793 Query thread_id=435 exec_time=0 error_code=0
	use `yshop_14`/!/;
	/!/;
	# at 79835793
	#150601 18:49:04 server id 1 end_log_pos 79835821 Intvar
	SET INSERT_ID=3152125/!/;
	# at 79835821
	#150601 18:49:04 server id 1 end_log_pos 79836058 Query thread_id=435 exec_time=0 error_code=0
	/!/;
	# at 79836058
	#150601 18:49:04 server id 1 end_log_pos 79836085 Xid = 15715
	COMMIT/!/;

	BEGIN
	/!/;
	# at 14988913
	#150602 18:12:01 server id 1 end_log_pos 14988941 Intvar
	SET INSERT_ID=11446/!/;
	# at 14988941
	#150602 18:12:01 server id 1 end_log_pos 14989804 Query thread_id=27291 exec_time=0 error_code=0
	use `iteach_14`/!/;
	SET TIMESTAMP=1433261521/!/;
	INSERT INTO `user` (^M
	login,^M
	password,^M
	password_salt,^M
	role_id,^M
	firstname,^M
	lastname,^M
	email,^M
	processallow,^M
	allow_remind_email,^M
	created,^M
	sso_id,^M
	quota,^M
	trial_period_date,^M
	active,^M
	creator_id,^M
	info_message_counter,^M
	giodo_accept_date,^M
	uid^M
	) VALUES(^M
	'somename',^M
	'68319866167f18364375ca61a',^M
	'8e7ae',^M
	4,^M
	'name',^M
	'surname',^M
	'nsurname@d.edu',^M
	1,^M
	1,^M
	143321,^M
	'149b242acbb51ec344a501',^M
	'50',^M
	0,^M
	'1',^M
	0,^M
	0,^M
	0,^M
	'149b24fc9d402acbb51ec344a501'^M
	)
	/!/;
	# at 14989804
	#150602 18:12:01 server id 1 end_log_pos 14989831 Xid = 675698
	COMMIT/!/;

	BEGIN
	/!/;
	# at 96031080
	#150601 23:45:01 server id 1 end_log_pos 96031108 Intvar
	SET INSERT_ID=481699/!/;
	# at 96031108
	#150601 23:45:01 server id 1 end_log_pos 96031339 Query thread_id=9961 exec_time=0 error_code=0
	INSERT INTO codes (package_id,code,add_date,exp_date,licence_duration,students_licences,comment) VALUES ('1693', 'vvvv', 1443109600, 15381293600, '12', '1', NULL)
	/!/;
	# at 96031339
	#150601 23:45:01 server id 1 end_log_pos 96031366 Xid = 228697
	COMMIT/!/;

	BEGIN
	/!/;
	# at 14989903
	#150602 18:12:01 server id 1 end_log_pos 14990129 Query thread_id=27293 exec_time=0 error_code=0
	use `yshop_14`/!/;
	SET TIMESTAMP=1433261521/!/;
	/!/;
	# at 14990129
	#150602 18:12:01 server id 1 end_log_pos 14990157 Intvar
	SET INSERT_ID=2154510/!/;
	# at 14990157
	#150602 18:12:01 server id 1 end_log_pos 14990394 Query thread_id=27293 exec_time=0 error_code=0
	SET TIMESTAMP=1433261521/!/;
	/!/;
	# at 14990394
	#150602 18:12:01 server id 1 end_log_pos 14990421 Xid = 675717
	COMMIT/!/;


	BEGIN
	/!/;
	# at 96031439
	#150601 23:45:01 server id 1 end_log_pos 960211690 Query thread_id=9961 exec_time=0 error_code=0
	UPDATE codes SET code='xxxxx', status=0, students_licences='1', licences_used=NULL, unlock_date=NULL, licence_till=NULL, user_id=NULL, school_id=NULL, comment=NULL WHERE id='481699'
	/!/;
	# at 960211690
	#150601 23:45:01 server id 1 end_log_pos 96021717 Xid = 2281699
	COMMIT/!/;

	BEGIN
	/!/;
	# at 15010641
	#150602 18:12:16 server id 1 end_log_pos 15011393 Query thread_id=27305 exec_time=0 error_code=0
	use `iteach_14`/!/;
	SET TIMESTAMP=1433261536/!/;
	UPDATE^M
	`user`^M
	SET ^M
	login = 'name',^M
	role_id = '4',^M
	firstname = 'namen',^M
	lastname = 'surname',^M
	email = 'dsafdasf@dasf.edu',^M
	forcepasschange = 0,^M
	processallow = '0',^M
	allow_remind_email = '1',^M
	sso_id = '149b5b701f26b1402acbb51ec344a501',^M
	trial_period_date = '0',^M
	quota = '50',^M
	active = 1,^M
	creator_id = 0,^M
	info_message_counter = 0,^M
	giodo_accept_date = 0,^M
	uid = '149b24fc9d945b701a501'^M
	^M
	WHERE^M
	id = '11446'
	/!/;
	# at 15011393
	#150602 18:12:16 server id 1 end_log_pos 15011420 Xid = 675924
	COMMIT/!/;