MyISAM Transaction Emulation

This page walks through a typical transaction scenario on a pretty simplistic demo database.

At the end of the page the transaction will be rolled back.

Wherever data is presented in tabular format it's being pulled - during the flow of the page - from the database so each table represents the current position of the database.

The page render is linear.

Table Structures

The database is made up of three tables.. users, companies and a little change log.

The User Table

CREATE TABLE demo_users (
user_id int unsigned NOT NULL auto_increment PRIMARY KEY,
user_company int unsigned,
user_name varchar(64),
user_email varchar(64),
user_created datetime,
user_updated timestamp
);

The Companies Table

CREATE TABLE demo_companies (
company_id int unsigned NOT NULL auto_increment PRIMARY KEY,
company_primary_contact int unsigned,
company_name varchar(64),
user_created datetime,
user_updated timestamp
);

The Log Table

CREATE TABLE demo_history_log (
log_id int unsigned NOT NULL auto_increment PRIMARY KEY,
log_user int unsigned,
log_line varchar(64),
log_created timestamp DEFAULT CURRENT_TIMESTAMP
);

Our Full Transaction

Running a 7 stage transaction as follows:
  1. Add user Celine Dion.
  2. Log the removal of Barbara Streisand...
  3. .. and remove Barbara Streisand from the database.
  4. Log the demotion of the primary contact at Company 2...
  5. ... demote the primary contact by making Celine the primary contact...
  6. ... and log her creation to the top-spot.
  7. Finally log some other nonsense.
  8. An UPDATE SET x=x+y1
  9. An INSERT ON DUPLICATE KEY1
1 : Added by popular demand! ;-)

Our Data

At each stage of the process a little method is called that plucks the data out of the database and pops it into html.

Here is the data as it looks right now:

The red text signifies change from the last time the table was rendered. It's just a little MD5 magic, nothing special
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58

Running the process

An here goes... from here on while the html is rendering each command is being executed on the database.

For each execution you can see the dumped tables - fresh from the DB.

Starting the transaction. ID: 1089258508

When you start a transaction you're given a unique ID back from the library. Ours is 1089258508. The library assumes that you're always talking about the most recently started transaction by default but explicitly executing a command against a specific transaction ID allows allows you to intermix concurrent requests to the database and then rollback or commit different transcations independantly.

1: Add Celine [Executed]

INSERT INTO demo_users (user_name,user_email,user_created) VALUES ('Celine Dion','celine@killmenow.com',now())
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58

2: Log the removal of Barbara Streisand... [Failed]

INSERT INTO demo_history_log (log_user,log_line) SELECT user_id,
'Record Deleted'
FROM demo_users
WHERE user_email = 'barbara@killmenow.com'
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58

3: .. and remove Barbara Streisand from the database. [Failed]

DELETE
FROM demo_users
WHERE user_email = 'barbara@killmenow.com'
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58

4: Log the demotion of Company 2's Primary Contact [Executed]

INSERT INTO demo_history_log (log_user,log_line) SELECT user_id,
'User Demoted'
FROM demo_users,
demo_companies
WHERE company_id = 2
AND user_id = company_primary_contact
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20

5: ... demote the primary contact by making Celine the primary contact... [Executed]

UPDATE demo_users,demo_companies SET user_company = 2,
company_primary_contact = user_id
WHERE company_id = 2
AND user_email = 'celine@killmenow.com'
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 2 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20

6: ... and log her creation to the top-spot. [Executed]

INSERT INTO demo_history_log (log_user,log_line) SELECT user_id,
'New Primary Created'
FROM demo_users,
demo_companies
WHERE company_id = 2
AND user_id = company_primary_contact
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 2 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20
172 8 New Primary Created 2010-03-12 06:23:20

7: Finally log some other nonsense. [Executed]

INSERT INTO demo_history_log (log_user,log_line) VALUES ( 1,
'Something happened..'),( 2,
'Something happened..'),( 1,
'Something else happened..')
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-12-03 14:01:14 2010-03-12 01:35:59
2 1 Padington Bear padington@marmlade.com 2002-07-29 14:01:14 2010-03-12 01:35:58
3 1 Philip Starky phil@marmlade.com 2003-02-19 14:01:14 2010-03-12 01:35:58
4 2 Terence Trent Derby terry@killmenow.com 2002-11-04 14:01:14 2010-03-12 01:35:58
8 2 Celine Dion celine@killmenow.com 2003-11-21 05:41:29 2010-03-12 01:35:58
9 2 Celine Dion celine@killmenow.com 2002-10-04 09:15:01 2010-03-12 01:35:58
7 2 Celine Dion celine@killmenow.com 2004-02-04 00:32:13 2010-03-12 01:35:58
10 2 Celine Dion celine@killmenow.com 2006-02-15 10:35:16 2010-03-12 01:35:58
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-09-18 10:35:44 2010-03-12 01:35:58
12 2 Celine Dion celine@killmenow.com 2005-12-15 10:35:46 2010-03-12 01:35:58
13 2 Celine Dion celine@killmenow.com 2006-05-05 10:35:55 2010-03-12 01:35:58
14 2 Celine Dion celine@killmenow.com 2006-03-17 02:36:42 2010-03-12 01:35:58
15 2 Celine Dion celine@killmenow.com 2006-02-17 02:36:44 2010-03-12 01:35:58
16 2 Celine Dion celine@killmenow.com 2006-07-07 08:56:12 2010-03-12 01:35:58
17 2 Celine Dion celine@killmenow.com 2006-07-11 08:57:24 2010-03-12 01:35:58
18 2 Celine Dion celine@killmenow.com 2007-01-20 08:58:18 2010-03-12 01:35:58
19 2 Celine Dion celine@killmenow.com 2007-06-29 09:01:31 2010-03-12 01:35:58
20 2 Celine Dion celine@killmenow.com 2006-08-08 09:05:54 2010-03-12 01:35:58
21 2 Celine Dion celine@killmenow.com 2006-09-25 12:35:06 2010-03-12 01:35:58
22 2 Celine Dion celine@killmenow.com 2007-02-14 02:59:33 2010-03-12 01:35:58
23 2 Celine Dion celine@killmenow.com 2007-05-21 09:32:01 2010-03-12 01:35:58
24 2 Celine Dion celine@killmenow.com 2008-02-26 01:53:46 2010-03-12 01:35:58
25 2 Celine Dion celine@killmenow.com 2007-08-31 17:07:25 2010-03-12 01:35:58
26 2 Celine Dion celine@killmenow.com 2007-05-26 05:25:17 2010-03-12 01:35:58
27 2 Celine Dion celine@killmenow.com 2007-12-31 07:45:23 2010-03-12 01:35:58
28 2 Celine Dion celine@killmenow.com 2007-06-08 10:08:03 2010-03-12 01:35:58
29 2 Celine Dion celine@killmenow.com 2008-08-20 10:46:31 2010-03-12 01:35:58
30 2 Celine Dion celine@killmenow.com 2008-06-02 09:51:24 2010-03-12 01:35:58
31 2 Celine Dion celine@killmenow.com 2008-09-26 09:53:08 2010-03-12 01:35:58
32 2 Celine Dion celine@killmenow.com 2008-09-27 13:31:07 2010-03-12 01:35:58
33 2 Celine Dion celine@killmenow.com 2008-06-19 21:55:35 2010-03-12 01:35:58
34 2 Celine Dion celine@killmenow.com 2008-12-13 11:22:57 2010-03-12 01:35:58
35 2 Celine Dion celine@killmenow.com 2009-01-12 15:40:48 2010-03-12 01:35:58
36 2 Celine Dion celine@killmenow.com 2009-03-24 20:57:09 2010-03-12 01:35:58
37 2 Celine Dion celine@killmenow.com 2009-07-10 06:40:05 2010-03-12 01:35:58
38 2 Celine Dion celine@killmenow.com 2009-04-07 09:30:51 2010-03-12 01:35:58
39 2 Celine Dion celine@killmenow.com 2009-06-08 12:17:28 2010-03-12 01:35:58
40 2 Celine Dion celine@killmenow.com 2009-12-04 03:21:47 2010-03-12 01:35:58
41 2 Celine Dion celine@killmenow.com 2009-10-21 11:56:32 2010-03-12 01:35:58
42 2 Celine Dion celine@killmenow.com 2010-01-01 01:35:58 2010-03-12 01:35:58
43 2 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20
172 8 New Primary Created 2010-03-12 06:23:20
173 1 Something happened.. 2010-03-12 06:23:20
174 2 Something happened.. 2010-03-12 06:23:20
175 1 Something else happened.. 2010-03-12 06:23:20

7: An UPDATE SET x=x+y. [Executed]

UPDATE demo_users SET user_created = DATE_SUB( user_created,
INTERVAL
ROUND(RAND()*100) DAY )
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-11-27 14:01:14 2010-03-12 06:23:20
2 1 Padington Bear padington@marmlade.com 2002-06-12 14:01:14 2010-03-12 06:23:20
3 1 Philip Starky phil@marmlade.com 2003-02-01 14:01:14 2010-03-12 06:23:20
4 2 Terence Trent Derby terry@killmenow.com 2002-09-16 14:01:14 2010-03-12 06:23:20
8 2 Celine Dion celine@killmenow.com 2003-08-22 05:41:29 2010-03-12 06:23:20
9 2 Celine Dion celine@killmenow.com 2002-09-25 09:15:01 2010-03-12 06:23:20
7 2 Celine Dion celine@killmenow.com 2003-11-23 00:32:13 2010-03-12 06:23:20
10 2 Celine Dion celine@killmenow.com 2006-01-10 10:35:16 2010-03-12 06:23:20
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 01:35:59
11 2 Celine Dion celine@killmenow.com 2005-07-17 10:35:44 2010-03-12 06:23:20
12 2 Celine Dion celine@killmenow.com 2005-12-08 10:35:46 2010-03-12 06:23:20
13 2 Celine Dion celine@killmenow.com 2006-03-21 10:35:55 2010-03-12 06:23:20
14 2 Celine Dion celine@killmenow.com 2006-03-12 02:36:42 2010-03-12 06:23:20
15 2 Celine Dion celine@killmenow.com 2005-11-20 02:36:44 2010-03-12 06:23:20
16 2 Celine Dion celine@killmenow.com 2006-06-06 08:56:12 2010-03-12 06:23:20
17 2 Celine Dion celine@killmenow.com 2006-04-14 08:57:24 2010-03-12 06:23:20
18 2 Celine Dion celine@killmenow.com 2006-12-06 08:58:18 2010-03-12 06:23:20
19 2 Celine Dion celine@killmenow.com 2007-04-29 09:01:31 2010-03-12 06:23:20
20 2 Celine Dion celine@killmenow.com 2006-05-29 09:05:54 2010-03-12 06:23:20
21 2 Celine Dion celine@killmenow.com 2006-07-14 12:35:06 2010-03-12 06:23:20
22 2 Celine Dion celine@killmenow.com 2006-12-23 02:59:33 2010-03-12 06:23:20
23 2 Celine Dion celine@killmenow.com 2007-04-07 09:32:01 2010-03-12 06:23:20
24 2 Celine Dion celine@killmenow.com 2007-12-24 01:53:46 2010-03-12 06:23:20
25 2 Celine Dion celine@killmenow.com 2007-06-07 17:07:25 2010-03-12 06:23:20
26 2 Celine Dion celine@killmenow.com 2007-04-24 05:25:17 2010-03-12 06:23:20
27 2 Celine Dion celine@killmenow.com 2007-12-23 07:45:23 2010-03-12 06:23:20
28 2 Celine Dion celine@killmenow.com 2007-04-28 10:08:03 2010-03-12 06:23:20
29 2 Celine Dion celine@killmenow.com 2008-05-29 10:46:31 2010-03-12 06:23:20
30 2 Celine Dion celine@killmenow.com 2008-03-03 09:51:24 2010-03-12 06:23:20
31 2 Celine Dion celine@killmenow.com 2008-09-20 09:53:08 2010-03-12 06:23:20
32 2 Celine Dion celine@killmenow.com 2008-08-02 13:31:07 2010-03-12 06:23:20
33 2 Celine Dion celine@killmenow.com 2008-04-15 21:55:35 2010-03-12 06:23:20
34 2 Celine Dion celine@killmenow.com 2008-10-19 11:22:57 2010-03-12 06:23:20
35 2 Celine Dion celine@killmenow.com 2008-10-25 15:40:48 2010-03-12 06:23:20
36 2 Celine Dion celine@killmenow.com 2009-02-21 20:57:09 2010-03-12 06:23:20
37 2 Celine Dion celine@killmenow.com 2009-06-21 06:40:05 2010-03-12 06:23:20
38 2 Celine Dion celine@killmenow.com 2008-12-29 09:30:51 2010-03-12 06:23:20
39 2 Celine Dion celine@killmenow.com 2009-04-28 12:17:28 2010-03-12 06:23:20
40 2 Celine Dion celine@killmenow.com 2009-11-25 03:21:47 2010-03-12 06:23:20
41 2 Celine Dion celine@killmenow.com 2009-10-01 11:56:32 2010-03-12 06:23:20
42 2 Celine Dion celine@killmenow.com 2009-10-21 01:35:58 2010-03-12 06:23:20
43 2 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20
172 8 New Primary Created 2010-03-12 06:23:20
173 1 Something happened.. 2010-03-12 06:23:20
174 2 Something happened.. 2010-03-12 06:23:20
175 1 Something else happened.. 2010-03-12 06:23:20

7: INSERT ON DUPLICATE KEY. [Executed]

INSERT INTO demo_users (user_id,
user_name) VALUES (1,'Key Hit'),(5,'No Key Hit (Where Babs was)')
ON DUPLICATE KEY UPDATE user_email = 'hitme@keyupdate.com'
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-11-27 14:01:14 2010-03-12 06:23:20
2 1 Padington Bear padington@marmlade.com 2002-06-12 14:01:14 2010-03-12 06:23:20
3 1 Philip Starky phil@marmlade.com 2003-02-01 14:01:14 2010-03-12 06:23:20
4 2 Terence Trent Derby terry@killmenow.com 2002-09-16 14:01:14 2010-03-12 06:23:20
8 2 Celine Dion celine@killmenow.com 2003-08-22 05:41:29 2010-03-12 06:23:20
9 2 Celine Dion celine@killmenow.com 2002-09-25 09:15:01 2010-03-12 06:23:20
7 2 Celine Dion celine@killmenow.com 2003-11-23 00:32:13 2010-03-12 06:23:20
10 2 Celine Dion celine@killmenow.com 2006-01-10 10:35:16 2010-03-12 06:23:20
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 06:23:20
11 2 Celine Dion celine@killmenow.com 2005-07-17 10:35:44 2010-03-12 06:23:20
12 2 Celine Dion celine@killmenow.com 2005-12-08 10:35:46 2010-03-12 06:23:20
13 2 Celine Dion celine@killmenow.com 2006-03-21 10:35:55 2010-03-12 06:23:20
14 2 Celine Dion celine@killmenow.com 2006-03-12 02:36:42 2010-03-12 06:23:20
15 2 Celine Dion celine@killmenow.com 2005-11-20 02:36:44 2010-03-12 06:23:20
16 2 Celine Dion celine@killmenow.com 2006-06-06 08:56:12 2010-03-12 06:23:20
17 2 Celine Dion celine@killmenow.com 2006-04-14 08:57:24 2010-03-12 06:23:20
18 2 Celine Dion celine@killmenow.com 2006-12-06 08:58:18 2010-03-12 06:23:20
19 2 Celine Dion celine@killmenow.com 2007-04-29 09:01:31 2010-03-12 06:23:20
20 2 Celine Dion celine@killmenow.com 2006-05-29 09:05:54 2010-03-12 06:23:20
21 2 Celine Dion celine@killmenow.com 2006-07-14 12:35:06 2010-03-12 06:23:20
22 2 Celine Dion celine@killmenow.com 2006-12-23 02:59:33 2010-03-12 06:23:20
23 2 Celine Dion celine@killmenow.com 2007-04-07 09:32:01 2010-03-12 06:23:20
24 2 Celine Dion celine@killmenow.com 2007-12-24 01:53:46 2010-03-12 06:23:20
25 2 Celine Dion celine@killmenow.com 2007-06-07 17:07:25 2010-03-12 06:23:20
26 2 Celine Dion celine@killmenow.com 2007-04-24 05:25:17 2010-03-12 06:23:20
27 2 Celine Dion celine@killmenow.com 2007-12-23 07:45:23 2010-03-12 06:23:20
28 2 Celine Dion celine@killmenow.com 2007-04-28 10:08:03 2010-03-12 06:23:20
29 2 Celine Dion celine@killmenow.com 2008-05-29 10:46:31 2010-03-12 06:23:20
30 2 Celine Dion celine@killmenow.com 2008-03-03 09:51:24 2010-03-12 06:23:20
31 2 Celine Dion celine@killmenow.com 2008-09-20 09:53:08 2010-03-12 06:23:20
32 2 Celine Dion celine@killmenow.com 2008-08-02 13:31:07 2010-03-12 06:23:20
33 2 Celine Dion celine@killmenow.com 2008-04-15 21:55:35 2010-03-12 06:23:20
34 2 Celine Dion celine@killmenow.com 2008-10-19 11:22:57 2010-03-12 06:23:20
35 2 Celine Dion celine@killmenow.com 2008-10-25 15:40:48 2010-03-12 06:23:20
36 2 Celine Dion celine@killmenow.com 2009-02-21 20:57:09 2010-03-12 06:23:20
37 2 Celine Dion celine@killmenow.com 2009-06-21 06:40:05 2010-03-12 06:23:20
38 2 Celine Dion celine@killmenow.com 2008-12-29 09:30:51 2010-03-12 06:23:20
39 2 Celine Dion celine@killmenow.com 2009-04-28 12:17:28 2010-03-12 06:23:20
40 2 Celine Dion celine@killmenow.com 2009-11-25 03:21:47 2010-03-12 06:23:20
41 2 Celine Dion celine@killmenow.com 2009-10-01 11:56:32 2010-03-12 06:23:20
42 2 Celine Dion celine@killmenow.com 2009-10-21 01:35:58 2010-03-12 06:23:20
43 2 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20
172 8 New Primary Created 2010-03-12 06:23:20
173 1 Something happened.. 2010-03-12 06:23:20
174 2 Something happened.. 2010-03-12 06:23:20
175 1 Something else happened.. 2010-03-12 06:23:20

And now roll back the whole thing! [Success]

... now hopefully (!.. let's check... phew, yep!) we should have rolled back the whole thing and be back where we started.

The only descernable thing you should see is that the row ids where the inserts are happening should be creeping up each time you reload this page..
user_id user_company user_name user_email user_created user_updated
1 1 John Doe hitme@keyupdate.com 2002-11-27 14:01:14 2010-03-12 06:23:20
2 1 Padington Bear padington@marmlade.com 2002-06-12 14:01:14 2010-03-12 06:23:20
3 1 Philip Starky phil@marmlade.com 2003-02-01 14:01:14 2010-03-12 06:23:20
4 2 Terence Trent Derby terry@killmenow.com 2002-09-16 14:01:14 2010-03-12 06:23:20
8 2 Celine Dion celine@killmenow.com 2003-08-22 05:41:29 2010-03-12 06:23:20
9 2 Celine Dion celine@killmenow.com 2002-09-25 09:15:01 2010-03-12 06:23:20
7 2 Celine Dion celine@killmenow.com 2003-11-23 00:32:13 2010-03-12 06:23:20
10 2 Celine Dion celine@killmenow.com 2006-01-10 10:35:16 2010-03-12 06:23:20
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2010-03-12 06:23:20
11 2 Celine Dion celine@killmenow.com 2005-07-17 10:35:44 2010-03-12 06:23:20
12 2 Celine Dion celine@killmenow.com 2005-12-08 10:35:46 2010-03-12 06:23:20
13 2 Celine Dion celine@killmenow.com 2006-03-21 10:35:55 2010-03-12 06:23:20
14 2 Celine Dion celine@killmenow.com 2006-03-12 02:36:42 2010-03-12 06:23:20
15 2 Celine Dion celine@killmenow.com 2005-11-20 02:36:44 2010-03-12 06:23:20
16 2 Celine Dion celine@killmenow.com 2006-06-06 08:56:12 2010-03-12 06:23:20
17 2 Celine Dion celine@killmenow.com 2006-04-14 08:57:24 2010-03-12 06:23:20
18 2 Celine Dion celine@killmenow.com 2006-12-06 08:58:18 2010-03-12 06:23:20
19 2 Celine Dion celine@killmenow.com 2007-04-29 09:01:31 2010-03-12 06:23:20
20 2 Celine Dion celine@killmenow.com 2006-05-29 09:05:54 2010-03-12 06:23:20
21 2 Celine Dion celine@killmenow.com 2006-07-14 12:35:06 2010-03-12 06:23:20
22 2 Celine Dion celine@killmenow.com 2006-12-23 02:59:33 2010-03-12 06:23:20
23 2 Celine Dion celine@killmenow.com 2007-04-07 09:32:01 2010-03-12 06:23:20
24 2 Celine Dion celine@killmenow.com 2007-12-24 01:53:46 2010-03-12 06:23:20
25 2 Celine Dion celine@killmenow.com 2007-06-07 17:07:25 2010-03-12 06:23:20
26 2 Celine Dion celine@killmenow.com 2007-04-24 05:25:17 2010-03-12 06:23:20
27 2 Celine Dion celine@killmenow.com 2007-12-23 07:45:23 2010-03-12 06:23:20
28 2 Celine Dion celine@killmenow.com 2007-04-28 10:08:03 2010-03-12 06:23:20
29 2 Celine Dion celine@killmenow.com 2008-05-29 10:46:31 2010-03-12 06:23:20
30 2 Celine Dion celine@killmenow.com 2008-03-03 09:51:24 2010-03-12 06:23:20
31 2 Celine Dion celine@killmenow.com 2008-09-20 09:53:08 2010-03-12 06:23:20
32 2 Celine Dion celine@killmenow.com 2008-08-02 13:31:07 2010-03-12 06:23:20
33 2 Celine Dion celine@killmenow.com 2008-04-15 21:55:35 2010-03-12 06:23:20
34 2 Celine Dion celine@killmenow.com 2008-10-19 11:22:57 2010-03-12 06:23:20
35 2 Celine Dion celine@killmenow.com 2008-10-25 15:40:48 2010-03-12 06:23:20
36 2 Celine Dion celine@killmenow.com 2009-02-21 20:57:09 2010-03-12 06:23:20
37 2 Celine Dion celine@killmenow.com 2009-06-21 06:40:05 2010-03-12 06:23:20
38 2 Celine Dion celine@killmenow.com 2008-12-29 09:30:51 2010-03-12 06:23:20
39 2 Celine Dion celine@killmenow.com 2009-04-28 12:17:28 2010-03-12 06:23:20
40 2 Celine Dion celine@killmenow.com 2009-11-25 03:21:47 2010-03-12 06:23:20
41 2 Celine Dion celine@killmenow.com 2009-10-01 11:56:32 2010-03-12 06:23:20
42 2 Celine Dion celine@killmenow.com 2009-10-21 01:35:58 2010-03-12 06:23:20
43 2 Celine Dion celine@killmenow.com 2010-03-12 06:23:20 2010-03-12 06:23:20
company_id company_primary_contact company_name user_created user_updated
1 2 Marmalade Inc. 2008-02-08 14:01:16 2008-02-08 14:01:16
2 8 Dodgy Records 2008-02-08 14:01:16 2010-02-27 10:35:16
log_id log_user log_line log_created
1 1 Created.. 2008-02-08 14:01:18
2 2 Created.. 2008-02-08 14:01:18
3 3 Created.. 2008-02-08 14:01:18
4 4 Created.. 2008-02-08 14:01:18
5 5 Created.. 2008-02-08 14:01:18
6 4 User Demoted 2010-02-27 10:35:16
7 8 New Primary Created 2010-02-27 10:35:16
8 1 Something happened.. 2010-02-27 10:35:16
9 2 Something happened.. 2010-02-27 10:35:16
10 1 Something else happened.. 2010-02-27 10:35:16
11 8 User Demoted 2010-02-27 10:35:44
12 8 New Primary Created 2010-02-27 10:35:44
13 1 Something happened.. 2010-02-27 10:35:44
14 2 Something happened.. 2010-02-27 10:35:44
15 1 Something else happened.. 2010-02-27 10:35:44
16 8 User Demoted 2010-02-27 10:35:46
17 8 New Primary Created 2010-02-27 10:35:46
18 1 Something happened.. 2010-02-27 10:35:46
19 2 Something happened.. 2010-02-27 10:35:46
20 1 Something else happened.. 2010-02-27 10:35:46
21 8 User Demoted 2010-02-27 10:35:55
22 8 New Primary Created 2010-02-27 10:35:55
23 1 Something happened.. 2010-02-27 10:35:55
24 2 Something happened.. 2010-02-27 10:35:55
25 1 Something else happened.. 2010-02-27 10:35:55
26 8 User Demoted 2010-03-01 02:36:42
27 8 New Primary Created 2010-03-01 02:36:42
28 1 Something happened.. 2010-03-01 02:36:42
29 2 Something happened.. 2010-03-01 02:36:42
30 1 Something else happened.. 2010-03-01 02:36:42
31 8 User Demoted 2010-03-01 02:36:44
32 8 New Primary Created 2010-03-01 02:36:44
33 1 Something happened.. 2010-03-01 02:36:44
34 2 Something happened.. 2010-03-01 02:36:44
35 1 Something else happened.. 2010-03-01 02:36:44
36 8 User Demoted 2010-03-01 08:56:12
37 8 New Primary Created 2010-03-01 08:56:12
38 1 Something happened.. 2010-03-01 08:56:12
39 2 Something happened.. 2010-03-01 08:56:12
40 1 Something else happened.. 2010-03-01 08:56:12
41 8 User Demoted 2010-03-01 08:57:24
42 8 New Primary Created 2010-03-01 08:57:24
43 1 Something happened.. 2010-03-01 08:57:24
44 2 Something happened.. 2010-03-01 08:57:24
45 1 Something else happened.. 2010-03-01 08:57:24
46 8 User Demoted 2010-03-01 08:58:18
47 8 New Primary Created 2010-03-01 08:58:18
48 1 Something happened.. 2010-03-01 08:58:18
49 2 Something happened.. 2010-03-01 08:58:18
50 1 Something else happened.. 2010-03-01 08:58:18
51 8 User Demoted 2010-03-01 09:01:31
52 8 New Primary Created 2010-03-01 09:01:31
53 1 Something happened.. 2010-03-01 09:01:31
54 2 Something happened.. 2010-03-01 09:01:31
55 1 Something else happened.. 2010-03-01 09:01:31
56 8 User Demoted 2010-03-01 09:05:54
57 8 New Primary Created 2010-03-01 09:05:54
58 1 Something happened.. 2010-03-01 09:05:54
59 2 Something happened.. 2010-03-01 09:05:54
60 1 Something else happened.. 2010-03-01 09:05:54
61 8 User Demoted 2010-03-01 12:35:06
62 8 New Primary Created 2010-03-01 12:35:06
63 1 Something happened.. 2010-03-01 12:35:06
64 2 Something happened.. 2010-03-01 12:35:06
65 1 Something else happened.. 2010-03-01 12:35:06
66 8 User Demoted 2010-03-03 02:59:33
67 8 New Primary Created 2010-03-03 02:59:33
68 1 Something happened.. 2010-03-03 02:59:34
69 2 Something happened.. 2010-03-03 02:59:34
70 1 Something else happened.. 2010-03-03 02:59:34
71 8 User Demoted 2010-03-03 09:32:01
72 8 New Primary Created 2010-03-03 09:32:01
73 1 Something happened.. 2010-03-03 09:32:01
74 2 Something happened.. 2010-03-03 09:32:01
75 1 Something else happened.. 2010-03-03 09:32:01
76 8 User Demoted 2010-03-04 01:53:46
77 8 New Primary Created 2010-03-04 01:53:46
78 1 Something happened.. 2010-03-04 01:53:46
79 2 Something happened.. 2010-03-04 01:53:46
80 1 Something else happened.. 2010-03-04 01:53:46
81 8 User Demoted 2010-03-04 17:07:25
82 8 New Primary Created 2010-03-04 17:07:25
83 1 Something happened.. 2010-03-04 17:07:25
84 2 Something happened.. 2010-03-04 17:07:25
85 1 Something else happened.. 2010-03-04 17:07:25
86 8 User Demoted 2010-03-05 05:25:17
87 8 New Primary Created 2010-03-05 05:25:17
88 1 Something happened.. 2010-03-05 05:25:17
89 2 Something happened.. 2010-03-05 05:25:17
90 1 Something else happened.. 2010-03-05 05:25:17
91 8 User Demoted 2010-03-05 07:45:23
92 8 New Primary Created 2010-03-05 07:45:23
93 1 Something happened.. 2010-03-05 07:45:23
94 2 Something happened.. 2010-03-05 07:45:23
95 1 Something else happened.. 2010-03-05 07:45:23
96 8 User Demoted 2010-03-05 10:08:03
97 8 New Primary Created 2010-03-05 10:08:03
98 1 Something happened.. 2010-03-05 10:08:03
99 2 Something happened.. 2010-03-05 10:08:03
100 1 Something else happened.. 2010-03-05 10:08:03
101 8 User Demoted 2010-03-07 10:46:31
102 8 New Primary Created 2010-03-07 10:46:31
103 1 Something happened.. 2010-03-07 10:46:31
104 2 Something happened.. 2010-03-07 10:46:31
105 1 Something else happened.. 2010-03-07 10:46:31
106 8 User Demoted 2010-03-08 09:51:25
107 8 New Primary Created 2010-03-08 09:51:25
108 1 Something happened.. 2010-03-08 09:51:25
109 2 Something happened.. 2010-03-08 09:51:25
110 1 Something else happened.. 2010-03-08 09:51:25
111 8 User Demoted 2010-03-08 09:53:08
112 8 New Primary Created 2010-03-08 09:53:09
113 1 Something happened.. 2010-03-08 09:53:09
114 2 Something happened.. 2010-03-08 09:53:09
115 1 Something else happened.. 2010-03-08 09:53:09
116 8 User Demoted 2010-03-08 13:31:07
117 8 New Primary Created 2010-03-08 13:31:07
118 1 Something happened.. 2010-03-08 13:31:07
119 2 Something happened.. 2010-03-08 13:31:07
120 1 Something else happened.. 2010-03-08 13:31:07
121 8 User Demoted 2010-03-08 21:55:35
122 8 New Primary Created 2010-03-08 21:55:35
123 1 Something happened.. 2010-03-08 21:55:35
124 2 Something happened.. 2010-03-08 21:55:35
125 1 Something else happened.. 2010-03-08 21:55:35
126 8 User Demoted 2010-03-09 11:22:57
127 8 New Primary Created 2010-03-09 11:22:57
128 1 Something happened.. 2010-03-09 11:22:58
129 2 Something happened.. 2010-03-09 11:22:58
130 1 Something else happened.. 2010-03-09 11:22:58
131 8 User Demoted 2010-03-09 15:40:48
132 8 New Primary Created 2010-03-09 15:40:48
133 1 Something happened.. 2010-03-09 15:40:48
134 2 Something happened.. 2010-03-09 15:40:48
135 1 Something else happened.. 2010-03-09 15:40:48
136 8 User Demoted 2010-03-09 20:57:09
137 8 New Primary Created 2010-03-09 20:57:09
138 1 Something happened.. 2010-03-09 20:57:09
139 2 Something happened.. 2010-03-09 20:57:09
140 1 Something else happened.. 2010-03-09 20:57:09
141 8 User Demoted 2010-03-10 06:40:05
142 8 New Primary Created 2010-03-10 06:40:05
143 1 Something happened.. 2010-03-10 06:40:05
144 2 Something happened.. 2010-03-10 06:40:05
145 1 Something else happened.. 2010-03-10 06:40:05
146 8 User Demoted 2010-03-10 09:30:51
147 8 New Primary Created 2010-03-10 09:30:51
148 1 Something happened.. 2010-03-10 09:30:51
149 2 Something happened.. 2010-03-10 09:30:51
150 1 Something else happened.. 2010-03-10 09:30:51
151 8 User Demoted 2010-03-10 12:17:28
152 8 New Primary Created 2010-03-10 12:17:28
153 1 Something happened.. 2010-03-10 12:17:28
154 2 Something happened.. 2010-03-10 12:17:28
155 1 Something else happened.. 2010-03-10 12:17:28
156 8 User Demoted 2010-03-11 03:21:47
157 8 New Primary Created 2010-03-11 03:21:47
158 1 Something happened.. 2010-03-11 03:21:47
159 2 Something happened.. 2010-03-11 03:21:47
160 1 Something else happened.. 2010-03-11 03:21:47
161 8 User Demoted 2010-03-11 11:56:32
162 8 New Primary Created 2010-03-11 11:56:32
163 1 Something happened.. 2010-03-11 11:56:32
164 2 Something happened.. 2010-03-11 11:56:32
165 1 Something else happened.. 2010-03-11 11:56:32
166 8 User Demoted 2010-03-12 01:35:58
167 8 New Primary Created 2010-03-12 01:35:58
168 1 Something happened.. 2010-03-12 01:35:58
169 2 Something happened.. 2010-03-12 01:35:58
170 1 Something else happened.. 2010-03-12 01:35:58
171 8 User Demoted 2010-03-12 06:23:20
172 8 New Primary Created 2010-03-12 06:23:20
173 1 Something happened.. 2010-03-12 06:23:20
174 2 Something happened.. 2010-03-12 06:23:20
175 1 Something else happened.. 2010-03-12 06:23:20



Tail »