| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
SET @saved_slave_type_conversions = @@slave_type_conversions; |
| 4 |
SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY'; |
| 5 |
CREATE DATABASE track; |
| 6 |
USE track; |
| 7 |
CREATE TABLE `visits` ( |
| 8 |
`visits_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| 9 |
`myid` varchar(32) NOT NULL DEFAULT '', |
| 10 |
`src` varchar(64) NOT NULL DEFAULT '', |
| 11 |
`ip` int(10) unsigned NOT NULL DEFAULT '0', |
| 12 |
`cc` char(2) NOT NULL DEFAULT '', |
| 13 |
`org` varchar(80) DEFAULT NULL, |
| 14 |
`ref` varchar(255) NOT NULL DEFAULT '', |
| 15 |
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 16 |
`host` varchar(30) NOT NULL DEFAULT '', |
| 17 |
`entry` varchar(255) NOT NULL DEFAULT '', |
| 18 |
`visit_exit` varchar(255) NOT NULL DEFAULT '', |
| 19 |
`user_id` int(11) unsigned NOT NULL DEFAULT '0', |
| 20 |
`visit_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 21 |
PRIMARY KEY (`visits_id`), |
| 22 |
KEY `ip` (`ip`), |
| 23 |
KEY `time` (`time`), |
| 24 |
KEY `user_id` (`user_id`) |
| 25 |
) ENGINE=MyISAM AUTO_INCREMENT=21293381 DEFAULT CHARSET=latin1; |
| 26 |
CREATE TABLE `visits_events` ( |
| 27 |
`event_id` mediumint(8) unsigned NOT NULL DEFAULT '0', |
| 28 |
`visit_id` int(11) unsigned NOT NULL DEFAULT '0', |
| 29 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 30 |
`src` varchar(64) NOT NULL DEFAULT '', |
| 31 |
`data` varchar(255) NOT NULL DEFAULT '', |
| 32 |
`visits_events_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| 33 |
PRIMARY KEY (`visits_events_id`), |
| 34 |
KEY `event_id` (`event_id`), |
| 35 |
KEY `visit_id` (`visit_id`), |
| 36 |
KEY `data` (`data`) |
| 37 |
) ENGINE=MyISAM AUTO_INCREMENT=33900731 DEFAULT CHARSET=latin1; |
| 38 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 39 |
/*!40019 SET @@session.max_delayed_threads=0*/; |
| 40 |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 41 |
BINLOG ' |
| 42 |
O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA |
| 43 |
AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC |
| 44 |
'/*!*/; |
| 45 |
BINLOG ' |
| 46 |
Bk3vRhO0AQAAOAAAALcLyQkAAJlXFwIAAAAABXRyYWNrAA12aXNpdHNfZXZlbnRzAAYJAwcPDwM= |
| 47 |
Bk3vRhe0AQAAWgAAABEMyQkQAJlXFwIAAAEABv/AIE4AvvVDAQZN70YAK0Rvd25sb2Fkcy9NeVNR |
| 48 |
TC00LjEvbXlzcWwtNC4xLjEyYS13aW4zMi56aXBPaAIC |
| 49 |
'/*!*/; |
| 50 |
SET INSERT_ID=21231039/*!*/; |
| 51 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
| 52 |
use track/*!*/; |
| 53 |
SET TIMESTAMP=1190087942/*!*/; |
| 54 |
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/; |
| 55 |
SET @@session.sql_mode=0/*!*/; |
| 56 |
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; |
| 57 |
SET @@session.time_zone='UTC'/*!*/; |
| 58 |
INSERT INTO visits (myid, user_id, src, ip, cc, org, ref, time, host, entry, visit_exit, visit_start) |
| 59 |
VALUES ('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())/*!*/; |
| 60 |
Warnings: |
| 61 |
Warning 1366 Incorrect integer value: '' for column `track`.`visits`.`user_id` at row 1 |
| 62 |
SELECT * FROM visits; |
| 63 |
visits_id myid src ip cc org ref time host entry visit_exit user_id visit_start |
| 64 |
21231039 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 |
| 65 |
SELECT * FROM visits_events; |
| 66 |
event_id visit_id timestamp src data visits_events_id |
| 67 |
20000 21231038 2007-09-18 03:59:02 Downloads/MySQL-4.1/mysql-4.1.12a-win32.zip 33712207 |
| 68 |
SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions; |
| 69 |
DROP DATABASE track; |
| 70 |
connection slave; |
| 71 |
End of 5.1 tests |
| 72 |
include/rpl_end.inc |