1include/master-slave.inc
2Warnings:
3Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
4Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
5[connection master]
6SET @saved_slave_type_conversions = @@slave_type_conversions;
7SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY';
8CREATE DATABASE track;
9USE track;
10SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
11Warnings:
12Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
13CREATE TABLE `visits` (
14`visits_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
15`myid` varchar(32) NOT NULL DEFAULT '',
16`src` varchar(64) NOT NULL DEFAULT '',
17`ip` int(10) unsigned NOT NULL DEFAULT '0',
18`cc` char(2) NOT NULL DEFAULT '',
19`org` varchar(80) DEFAULT NULL,
20`ref` varchar(255) NOT NULL DEFAULT '',
21`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
22`host` varchar(30) NOT NULL DEFAULT '',
23`entry` varchar(255) NOT NULL DEFAULT '',
24`visit_exit` varchar(255) NOT NULL DEFAULT '',
25`user_id` int(11) unsigned NOT NULL DEFAULT '0',
26`visit_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
27PRIMARY KEY (`visits_id`),
28KEY `ip` (`ip`),
29KEY `time` (`time`),
30KEY `user_id` (`user_id`)
31) AUTO_INCREMENT=21293381 DEFAULT CHARSET=latin1;
32SET sql_mode = default;
33CREATE TABLE `visits_events` (
34`event_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
35`visit_id` int(11) unsigned NOT NULL DEFAULT '0',
36`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
37`src` varchar(64) NOT NULL DEFAULT '',
38`data` varchar(255) NOT NULL DEFAULT '',
39`visits_events_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
40PRIMARY KEY (`visits_events_id`),
41KEY `event_id` (`event_id`),
42KEY `visit_id` (`visit_id`),
43KEY `data` (`data`)
44) AUTO_INCREMENT=33900731 DEFAULT CHARSET=latin1;
45/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
46/*!40019 SET @@session.max_insert_delayed_threads=0*/;
47Warnings:
48Warning	1287	'@@max_insert_delayed_threads' is deprecated and will be removed in a future release.
49/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
50BINLOG '
51O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
52AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
53'/*!*/;
54BINLOG '
55Bk3vRhO0AQAAOAAAALcLyQkAAJlXFwIAAAAABXRyYWNrAA12aXNpdHNfZXZlbnRzAAYJAwcPDwM=
56Bk3vRhe0AQAAWgAAABEMyQkQAJlXFwIAAAEABv/AIE4AvvVDAQZN70YAK0Rvd25sb2Fkcy9NeVNR
57TC00LjEvbXlzcWwtNC4xLjEyYS13aW4zMi56aXBPaAIC
58'/*!*/;
59ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
60SET INSERT_ID=21231039/*!*/;
61/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
62use track/*!*/;
63SET TIMESTAMP=1190087942/*!*/;
64SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
65SET @@session.sql_mode=0/*!*/;
66Warnings:
67Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
68SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
69SET @@session.time_zone='UTC'/*!*/;
70INSERT INTO visits (myid, user_id, src, ip, cc, org, ref, time, host, entry, visit_exit, visit_start)
71VALUES ('3m3l4rhs6do0sf5p1i9lr94g928a272v', '', '', INET_ATON('71.118.124.98'), '', '', 'http://dev.mysql.com/downloads/connector/j/3.0.html', NULL, 'dev.mysql.com', '/get/Downloads/Connector-J/mysql-connector-java-3.0.17-ga.zip/from/pick', '/get/Downloads/Connector-J/mysql-connector-java-3.0.17-ga.zip/from/pick', NOW())/*!*/;
72Warnings:
73Warning	1366	Incorrect integer value: '' for column 'user_id' at row 1
74SELECT * FROM visits;
75visits_id	myid	src	ip	cc	org	ref	time	host	entry	visit_exit	user_id	visit_start
7621231039	3m3l4rhs6do0sf5p1i9lr94g928a272v		1198947426			http://dev.mysql.com/downloads/connector/j/3.0.html	2007-09-18 03:59:02	dev.mysql.com	/get/Downloads/Connector-J/mysql-connector-java-3.0.17-ga.zip/from/pick	/get/Downloads/Connector-J/mysql-connector-java-3.0.17-ga.zip/from/pick	0	2007-09-18 03:59:02
77SELECT * FROM visits_events;
78event_id	visit_id	timestamp	src	data	visits_events_id
79SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
80DROP DATABASE track;
81include/sync_slave_sql_with_master.inc
82End of 5.1 tests
83include/rpl_end.inc
84