|
1
by brian
clean slate |
1 |
stop slave; |
2 |
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; |
|
3 |
reset master; |
|
4 |
reset slave; |
|
5 |
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; |
|
6 |
start slave; |
|
7 |
CREATE DATABASE track; |
|
8 |
USE track; |
|
9 |
CREATE TABLE `visits` ( |
|
10 |
`visits_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
|
11 |
`myid` varchar(32) NOT NULL DEFAULT '', |
|
12 |
`src` varchar(64) NOT NULL DEFAULT '', |
|
13 |
`ip` int(10) unsigned NOT NULL DEFAULT '0', |
|
14 |
`cc` char(2) NOT NULL DEFAULT '', |
|
15 |
`org` varchar(80) DEFAULT NULL, |
|
16 |
`ref` varchar(255) NOT NULL DEFAULT '', |
|
17 |
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
|
18 |
`host` varchar(30) NOT NULL DEFAULT '', |
|
19 |
`entry` varchar(255) NOT NULL DEFAULT '', |
|
20 |
`visit_exit` varchar(255) NOT NULL DEFAULT '', |
|
21 |
`user_id` int(11) unsigned NOT NULL DEFAULT '0', |
|
22 |
`visit_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
|
23 |
PRIMARY KEY (`visits_id`), |
|
24 |
KEY `ip` (`ip`), |
|
25 |
KEY `time` (`time`), |
|
26 |
KEY `user_id` (`user_id`) |
|
27 |
) ENGINE=MyISAM AUTO_INCREMENT=21293381 DEFAULT CHARSET=latin1; |
|
28 |
CREATE TABLE `visits_events` ( |
|
29 |
`event_id` mediumint(8) unsigned NOT NULL DEFAULT '0', |
|
30 |
`visit_id` int(11) unsigned NOT NULL DEFAULT '0', |
|
31 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
|
32 |
`src` varchar(64) NOT NULL DEFAULT '', |
|
33 |
`data` varchar(255) NOT NULL DEFAULT '', |
|
34 |
`visits_events_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
|
35 |
PRIMARY KEY (`visits_events_id`), |
|
36 |
KEY `event_id` (`event_id`), |
|
37 |
KEY `visit_id` (`visit_id`), |
|
38 |
KEY `data` (`data`) |
|
39 |
) ENGINE=MyISAM AUTO_INCREMENT=33900731 DEFAULT CHARSET=latin1; |
|
40 |
/*!40019 SET @@session.max_insert_delayed_threads=0*/; |
|
41 |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
|
42 |
BINLOG ' |
|
43 |
O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
|
|
44 |
AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
|
|
45 |
'/*!*/; |
|
46 |
BINLOG ' |
|
47 |
Bk3vRhO0AQAAOAAAALcLyQkAAJlXFwIAAAAABXRyYWNrAA12aXNpdHNfZXZlbnRzAAYJAwcPDwM=
|
|
48 |
Bk3vRhe0AQAAWgAAABEMyQkQAJlXFwIAAAEABv/AIE4AvvVDAQZN70YAK0Rvd25sb2Fkcy9NeVNR
|
|
49 |
TC00LjEvbXlzcWwtNC4xLjEyYS13aW4zMi56aXBPaAIC
|
|
50 |
'/*!*/; |
|
51 |
SET INSERT_ID=21231039/*!*/; |
|
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 '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 |
DROP DATABASE track; |
|
69 |
End of 5.1 tests |