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 2005-02-11 14:01:14 2008-11-21 20:49:45
2 1 Padington Bear padington@marmlade.com 2005-05-18 14:01:14 2008-11-21 20:49:45
3 1 Philip Starky phil@marmlade.com 2005-01-29 14:01:14 2008-11-21 20:49:45
4 2 Terence Trent Derby terry@killmenow.com 2005-04-04 14:01:14 2008-11-21 20:49:45
8 2 Celine Dion celine@killmenow.com 2005-10-10 05:41:29 2008-11-21 20:49:45
9 2 Celine Dion celine@killmenow.com 2006-03-26 09:15:01 2008-11-21 20:49:45
11 2 Celine Dion celine@killmenow.com 2006-02-18 14:21:54 2008-11-21 20:49:45
7 2 Celine Dion celine@killmenow.com 2005-09-09 00:32:13 2008-11-21 20:49:45
130 2 Celine Dion celine@killmenow.com 2006-07-27 03:01:28 2008-11-21 20:49:45
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2008-11-21 20:49:45
131 2 Celine Dion celine@killmenow.com 2006-03-08 11:44:05 2008-11-21 20:49:45
132 2 Celine Dion celine@killmenow.com 2006-07-24 12:34:58 2008-11-21 20:49:45
133 2 Celine Dion celine@killmenow.com 2007-03-08 04:19:00 2008-11-21 20:49:45
134 2 Celine Dion celine@killmenow.com 2007-02-06 17:37:00 2008-11-21 20:49:45
135 2 Celine Dion celine@killmenow.com 2006-12-29 06:47:40 2008-11-21 20:49:45
136 2 Celine Dion celine@killmenow.com 2006-10-06 13:49:14 2008-11-21 20:49:45
137 2 Celine Dion celine@killmenow.com 2007-07-14 15:17:44 2008-11-21 20:49:45
138 2 Celine Dion celine@killmenow.com 2007-03-17 15:44:41 2008-11-21 20:49:45
139 2 Celine Dion celine@killmenow.com 2007-12-09 08:04:13 2008-11-21 20:49:45
140 2 Celine Dion celine@killmenow.com 2007-08-08 08:15:14 2008-11-21 20:49:45
141 2 Celine Dion celine@killmenow.com 2008-02-29 03:11:14 2008-11-21 20:49:45
142 2 Celine Dion celine@killmenow.com 2008-01-08 03:16:48 2008-11-21 20:49:45
143 2 Celine Dion celine@killmenow.com 2008-04-20 23:05:24 2008-11-21 20:49:45
144 2 Celine Dion celine@killmenow.com 2008-04-11 23:12:05 2008-11-21 20:49:45
145 2 Celine Dion celine@killmenow.com 2008-06-30 03:36:31 2008-11-21 20:49:45
146 2 Celine Dion celine@killmenow.com 2008-10-10 14:03:17 2008-11-21 20:49:45
147 2 Celine Dion celine@killmenow.com 2008-06-15 18:57:31 2008-11-21 20:49:45
148 2 Celine Dion celine@killmenow.com 2008-09-16 20:49:44 2008-11-21 20:49:45
149 2 Celine Dion celine@killmenow.com 2008-11-22 02:27:05 2008-11-22 02:27:06
150 2 Celine Dion celine@killmenow.com 2008-11-22 05:01:22 2008-11-22 05:01:23
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 2008-11-16 03:01:28
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
596 4 User Demoted 2008-11-16 03:01:28
597 8 New Primary Created 2008-11-16 03:01:28
598 1 Something happened.. 2008-11-16 03:01:28
599 2 Something happened.. 2008-11-16 03:01:28
600 1 Something else happened.. 2008-11-16 03:01:28
601 8 User Demoted 2008-11-16 11:44:05
602 8 New Primary Created 2008-11-16 11:44:05
603 1 Something happened.. 2008-11-16 11:44:05
604 2 Something happened.. 2008-11-16 11:44:05
605 1 Something else happened.. 2008-11-16 11:44:05
606 8 User Demoted 2008-11-16 12:34:58
607 8 New Primary Created 2008-11-16 12:34:58
608 1 Something happened.. 2008-11-16 12:34:58
609 2 Something happened.. 2008-11-16 12:34:58
610 1 Something else happened.. 2008-11-16 12:34:58
611 8 User Demoted 2008-11-17 04:19:01
612 8 New Primary Created 2008-11-17 04:19:01
613 1 Something happened.. 2008-11-17 04:19:03
614 2 Something happened.. 2008-11-17 04:19:03
615 1 Something else happened.. 2008-11-17 04:19:03
616 8 User Demoted 2008-11-17 17:37:00
617 8 New Primary Created 2008-11-17 17:37:00
618 1 Something happened.. 2008-11-17 17:37:00
619 2 Something happened.. 2008-11-17 17:37:00
620 1 Something else happened.. 2008-11-17 17:37:00
621 8 User Demoted 2008-11-18 06:47:40
622 8 New Primary Created 2008-11-18 06:47:40
623 1 Something happened.. 2008-11-18 06:47:40
624 2 Something happened.. 2008-11-18 06:47:40
625 1 Something else happened.. 2008-11-18 06:47:40
626 8 User Demoted 2008-11-18 13:49:14
627 8 New Primary Created 2008-11-18 13:49:14
628 1 Something happened.. 2008-11-18 13:49:14
629 2 Something happened.. 2008-11-18 13:49:14
630 1 Something else happened.. 2008-11-18 13:49:14
631 8 User Demoted 2008-11-18 15:17:44
632 8 New Primary Created 2008-11-18 15:17:44
633 1 Something happened.. 2008-11-18 15:17:44
634 2 Something happened.. 2008-11-18 15:17:44
635 1 Something else happened.. 2008-11-18 15:17:44
636 8 User Demoted 2008-11-18 15:44:41
637 8 New Primary Created 2008-11-18 15:44:41
638 1 Something happened.. 2008-11-18 15:44:41
639 2 Something happened.. 2008-11-18 15:44:41
640 1 Something else happened.. 2008-11-18 15:44:41
641 8 User Demoted 2008-11-19 08:04:13
642 8 New Primary Created 2008-11-19 08:04:13
643 1 Something happened.. 2008-11-19 08:04:13
644 2 Something happened.. 2008-11-19 08:04:13
645 1 Something else happened.. 2008-11-19 08:04:13
646 8 User Demoted 2008-11-19 08:15:14
647 8 New Primary Created 2008-11-19 08:15:14
648 1 Something happened.. 2008-11-19 08:15:14
649 2 Something happened.. 2008-11-19 08:15:14
650 1 Something else happened.. 2008-11-19 08:15:14
651 8 User Demoted 2008-11-20 03:11:14
652 8 New Primary Created 2008-11-20 03:11:14
653 1 Something happened.. 2008-11-20 03:11:14
654 2 Something happened.. 2008-11-20 03:11:14
655 1 Something else happened.. 2008-11-20 03:11:14
656 8 User Demoted 2008-11-20 03:16:48
657 8 New Primary Created 2008-11-20 03:16:48
658 1 Something happened.. 2008-11-20 03:16:48
659 2 Something happened.. 2008-11-20 03:16:48
660 1 Something else happened.. 2008-11-20 03:16:48
661 8 User Demoted 2008-11-20 23:05:24
662 8 New Primary Created 2008-11-20 23:05:24
663 1 Something happened.. 2008-11-20 23:05:24
664 2 Something happened.. 2008-11-20 23:05:24
665 1 Something else happened.. 2008-11-20 23:05:24
666 8 User Demoted 2008-11-20 23:12:05
667 8 New Primary Created 2008-11-20 23:12:05
668 1 Something happened.. 2008-11-20 23:12:05
669 2 Something happened.. 2008-11-20 23:12:05
670 1 Something else happened.. 2008-11-20 23:12:05
671 8 User Demoted 2008-11-21 03:36:31
672 8 New Primary Created 2008-11-21 03:36:31
673 1 Something happened.. 2008-11-21 03:36:31
674 2 Something happened.. 2008-11-21 03:36:31
675 1 Something else happened.. 2008-11-21 03:36:31
676 8 User Demoted 2008-11-21 14:03:18
677 8 New Primary Created 2008-11-21 14:03:18
678 8 User Demoted 2008-11-21 18:57:32
679 8 New Primary Created 2008-11-21 18:57:32
680 1 Something happened.. 2008-11-21 18:57:32
681 2 Something happened.. 2008-11-21 18:57:32
682 1 Something else happened.. 2008-11-21 18:57:32
683 8 User Demoted 2008-11-21 20:49:45
684 8 New Primary Created 2008-11-21 20:49:45
685 1 Something happened.. 2008-11-21 20:49:45
686 2 Something happened.. 2008-11-21 20:49:45
687 1 Something else happened.. 2008-11-21 20:49:45
688 8 User Demoted 2008-11-22 02:27:05
689 8 User Demoted 2008-11-22 05:01:23
690 8 New Primary Created 2008-11-22 05:01:23

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: 1682845239

When you start a transaction you're given a unique ID back from the library. Ours is 1682845239. 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 2005-02-11 14:01:14 2008-11-21 20:49:45
2 1 Padington Bear padington@marmlade.com 2005-05-18 14:01:14 2008-11-21 20:49:45
3 1 Philip Starky phil@marmlade.com 2005-01-29 14:01:14 2008-11-21 20:49:45
4 2 Terence Trent Derby terry@killmenow.com 2005-04-04 14:01:14 2008-11-21 20:49:45
8 2 Celine Dion celine@killmenow.com 2005-10-10 05:41:29 2008-11-21 20:49:45
9 2 Celine Dion celine@killmenow.com 2006-03-26 09:15:01 2008-11-21 20:49:45
11 2 Celine Dion celine@killmenow.com 2006-02-18 14:21:54 2008-11-21 20:49:45
7 2 Celine Dion celine@killmenow.com 2005-09-09 00:32:13 2008-11-21 20:49:45
130 2 Celine Dion celine@killmenow.com 2006-07-27 03:01:28 2008-11-21 20:49:45
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2008-11-21 20:49:45
131 2 Celine Dion celine@killmenow.com 2006-03-08 11:44:05 2008-11-21 20:49:45
132 2 Celine Dion celine@killmenow.com 2006-07-24 12:34:58 2008-11-21 20:49:45
133 2 Celine Dion celine@killmenow.com 2007-03-08 04:19:00 2008-11-21 20:49:45
134 2 Celine Dion celine@killmenow.com 2007-02-06 17:37:00 2008-11-21 20:49:45
135 2 Celine Dion celine@killmenow.com 2006-12-29 06:47:40 2008-11-21 20:49:45
136 2 Celine Dion celine@killmenow.com 2006-10-06 13:49:14 2008-11-21 20:49:45
137 2 Celine Dion celine@killmenow.com 2007-07-14 15:17:44 2008-11-21 20:49:45
138 2 Celine Dion celine@killmenow.com 2007-03-17 15:44:41 2008-11-21 20:49:45
139 2 Celine Dion celine@killmenow.com 2007-12-09 08:04:13 2008-11-21 20:49:45
140 2 Celine Dion celine@killmenow.com 2007-08-08 08:15:14 2008-11-21 20:49:45
141 2 Celine Dion celine@killmenow.com 2008-02-29 03:11:14 2008-11-21 20:49:45
142 2 Celine Dion celine@killmenow.com 2008-01-08 03:16:48 2008-11-21 20:49:45
143 2 Celine Dion celine@killmenow.com 2008-04-20 23:05:24 2008-11-21 20:49:45
144 2 Celine Dion celine@killmenow.com 2008-04-11 23:12:05 2008-11-21 20:49:45
145 2 Celine Dion celine@killmenow.com 2008-06-30 03:36:31 2008-11-21 20:49:45
146 2 Celine Dion celine@killmenow.com 2008-10-10 14:03:17 2008-11-21 20:49:45
147 2 Celine Dion celine@killmenow.com 2008-06-15 18:57:31 2008-11-21 20:49:45
148 2 Celine Dion celine@killmenow.com 2008-09-16 20:49:44 2008-11-21 20:49:45
149 2 Celine Dion celine@killmenow.com 2008-11-22 02:27:05 2008-11-22 02:27:06
150 2 Celine Dion celine@killmenow.com 2008-11-22 05:01:22 2008-11-22 05:01:23
151 Celine Dion celine@killmenow.com 2008-11-22 06:34:46 2008-11-22 06:34:46
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 2008-11-16 03:01:28
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
596 4 User Demoted 2008-11-16 03:01:28
597 8 New Primary Created 2008-11-16 03:01:28
598 1 Something happened.. 2008-11-16 03:01:28
599 2 Something happened.. 2008-11-16 03:01:28
600 1 Something else happened.. 2008-11-16 03:01:28
601 8 User Demoted 2008-11-16 11:44:05
602 8 New Primary Created 2008-11-16 11:44:05
603 1 Something happened.. 2008-11-16 11:44:05
604 2 Something happened.. 2008-11-16 11:44:05
605 1 Something else happened.. 2008-11-16 11:44:05
606 8 User Demoted 2008-11-16 12:34:58
607 8 New Primary Created 2008-11-16 12:34:58
608 1 Something happened.. 2008-11-16 12:34:58
609 2 Something happened.. 2008-11-16 12:34:58
610 1 Something else happened.. 2008-11-16 12:34:58
611 8 User Demoted 2008-11-17 04:19:01
612 8 New Primary Created 2008-11-17 04:19:01
613 1 Something happened.. 2008-11-17 04:19:03
614 2 Something happened.. 2008-11-17 04:19:03
615 1 Something else happened.. 2008-11-17 04:19:03
616 8 User Demoted 2008-11-17 17:37:00
617 8 New Primary Created 2008-11-17 17:37:00
618 1 Something happened.. 2008-11-17 17:37:00
619 2 Something happened.. 2008-11-17 17:37:00
620 1 Something else happened.. 2008-11-17 17:37:00
621 8 User Demoted 2008-11-18 06:47:40
622 8 New Primary Created 2008-11-18 06:47:40
623 1 Something happened.. 2008-11-18 06:47:40
624 2 Something happened.. 2008-11-18 06:47:40
625 1 Something else happened.. 2008-11-18 06:47:40
626 8 User Demoted 2008-11-18 13:49:14
627 8 New Primary Created 2008-11-18 13:49:14
628 1 Something happened.. 2008-11-18 13:49:14
629 2 Something happened.. 2008-11-18 13:49:14
630 1 Something else happened.. 2008-11-18 13:49:14
631 8 User Demoted 2008-11-18 15:17:44
632 8 New Primary Created 2008-11-18 15:17:44
633 1 Something happened.. 2008-11-18 15:17:44
634 2 Something happened.. 2008-11-18 15:17:44
635 1 Something else happened.. 2008-11-18 15:17:44
636 8 User Demoted 2008-11-18 15:44:41
637 8 New Primary Created 2008-11-18 15:44:41
638 1 Something happened.. 2008-11-18 15:44:41
639 2 Something happened.. 2008-11-18 15:44:41
640 1 Something else happened.. 2008-11-18 15:44:41
641 8 User Demoted 2008-11-19 08:04:13
642 8 New Primary Created 2008-11-19 08:04:13
643 1 Something happened.. 2008-11-19 08:04:13
644 2 Something happened.. 2008-11-19 08:04:13
645 1 Something else happened.. 2008-11-19 08:04:13
646 8 User Demoted 2008-11-19 08:15:14
647 8 New Primary Created 2008-11-19 08:15:14
648 1 Something happened.. 2008-11-19 08:15:14
649 2 Something happened.. 2008-11-19 08:15:14
650 1 Something else happened.. 2008-11-19 08:15:14
651 8 User Demoted 2008-11-20 03:11:14
652 8 New Primary Created 2008-11-20 03:11:14
653 1 Something happened.. 2008-11-20 03:11:14
654 2 Something happened.. 2008-11-20 03:11:14
655 1 Something else happened.. 2008-11-20 03:11:14
656 8 User Demoted 2008-11-20 03:16:48
657 8 New Primary Created 2008-11-20 03:16:48
658 1 Something happened.. 2008-11-20 03:16:48
659 2 Something happened.. 2008-11-20 03:16:48
660 1 Something else happened.. 2008-11-20 03:16:48
661 8 User Demoted 2008-11-20 23:05:24
662 8 New Primary Created 2008-11-20 23:05:24
663 1 Something happened.. 2008-11-20 23:05:24
664 2 Something happened.. 2008-11-20 23:05:24
665 1 Something else happened.. 2008-11-20 23:05:24
666 8 User Demoted 2008-11-20 23:12:05
667 8 New Primary Created 2008-11-20 23:12:05
668 1 Something happened.. 2008-11-20 23:12:05
669 2 Something happened.. 2008-11-20 23:12:05
670 1 Something else happened.. 2008-11-20 23:12:05
671 8 User Demoted 2008-11-21 03:36:31
672 8 New Primary Created 2008-11-21 03:36:31
673 1 Something happened.. 2008-11-21 03:36:31
674 2 Something happened.. 2008-11-21 03:36:31
675 1 Something else happened.. 2008-11-21 03:36:31
676 8 User Demoted 2008-11-21 14:03:18
677 8 New Primary Created 2008-11-21 14:03:18
678 8 User Demoted 2008-11-21 18:57:32
679 8 New Primary Created 2008-11-21 18:57:32
680 1 Something happened.. 2008-11-21 18:57:32
681 2 Something happened.. 2008-11-21 18:57:32
682 1 Something else happened.. 2008-11-21 18:57:32
683 8 User Demoted 2008-11-21 20:49:45
684 8 New Primary Created 2008-11-21 20:49:45
685 1 Something happened.. 2008-11-21 20:49:45
686 2 Something happened.. 2008-11-21 20:49:45
687 1 Something else happened.. 2008-11-21 20:49:45
688 8 User Demoted 2008-11-22 02:27:05
689 8 User Demoted 2008-11-22 05:01:23
690 8 New Primary Created 2008-11-22 05:01:23

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 2005-02-11 14:01:14 2008-11-21 20:49:45
2 1 Padington Bear padington@marmlade.com 2005-05-18 14:01:14 2008-11-21 20:49:45
3 1 Philip Starky phil@marmlade.com 2005-01-29 14:01:14 2008-11-21 20:49:45
4 2 Terence Trent Derby terry@killmenow.com 2005-04-04 14:01:14 2008-11-21 20:49:45
8 2 Celine Dion celine@killmenow.com 2005-10-10 05:41:29 2008-11-21 20:49:45
9 2 Celine Dion celine@killmenow.com 2006-03-26 09:15:01 2008-11-21 20:49:45
11 2 Celine Dion celine@killmenow.com 2006-02-18 14:21:54 2008-11-21 20:49:45
7 2 Celine Dion celine@killmenow.com 2005-09-09 00:32:13 2008-11-21 20:49:45
130 2 Celine Dion celine@killmenow.com 2006-07-27 03:01:28 2008-11-21 20:49:45
5 No Key Hit (Where Babs was) hitme@keyupdate.com 2008-11-21 20:49:45
131 2 Celine Dion celine@killmenow.com 2006-03-08 11:44:05 2008-11-21 20:49:45
132 2 Celine Dion celine@killmenow.com 2006-07-24 12:34:58 2008-11-21 20:49:45
133 2 Celine Dion celine@killmenow.com 2007-03-08 04:19:00 2008-11-21 20:49:45
134 2 Celine Dion celine@killmenow.com 2007-02-06 17:37:00 2008-11-21 20:49:45
135 2 Celine Dion celine@killmenow.com 2006-12-29 06:47:40 2008-11-21 20:49:45
136 2 Celine Dion celine@killmenow.com 2006-10-06 13:49:14 2008-11-21 20:49:45
137 2 Celine Dion celine@killmenow.com 2007-07-14 15:17:44 2008-11-21 20:49:45
138 2 Celine Dion celine@killmenow.com 2007-03-17 15:44:41 2008-11-21 20:49:45
139 2 Celine Dion celine@killmenow.com 2007-12-09 08:04:13 2008-11-21 20:49:45
140 2 Celine Dion celine@killmenow.com 2007-08-08 08:15:14 2008-11-21 20:49:45
141 2 Celine Dion celine@killmenow.com 2008-02-29 03:11:14 2008-11-21 20:49:45
142 2 Celine Dion celine@killmenow.com 2008-01-08 03:16:48 2008-11-21 20:49:45
143 2 Celine Dion celine@killmenow.com 2008-04-20 23:05:24 2008-11-21 20:49:45
144 2 Celine Dion celine@killmenow.com 2008-04-11 23:12:05 2008-11-21 20:49:45
145 2 Celine Dion celine@killmenow.com 2008-06-30 03:36:31 2008-11-21 20:49:45
146 2 Celine Dion celine@killmenow.com 2008-10-10 14:03:17 2008-11-21 20:49:45
147 2 Celine Dion celine@killmenow.com 2008-06-15 18:57:31 2008-11-21 20:49:45
148 2 Celine Dion celine@killmenow.com 2008-09-16 20:49:44 2008-11-21 20:49:45
149 2 Celine Dion celine@killmenow.com 2008-11-22 02:27:05 2008-11-22 02:27:06
150 2 Celine Dion celine@killmenow.com 2008-11-22 05:01:22 2008-11-22 05:01:23
151 Celine Dion celine@killmenow.com 2008-11-22 06:34:46 2008-11-22 06:34:46
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 2008-11-16 03:01:28
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
596 4 User Demoted 2008-11-16 03:01:28
597 8 New Primary Created 2008-11-16 03:01:28
598 1 Something happened.. 2008-11-16 03:01:28
599 2 Something happened.. 2008-11-16 03:01:28
600 1 Something else happened.. 2008-11-16 03:01:28
601 8 User Demoted 2008-11-16 11:44:05
602 8 New Primary Created 2008-11-16 11:44:05
603 1 Something happened.. 2008-11-16 11:44:05
604 2 Something happened.. 2008-11-16 11:44:05
605 1 Something else happened.. 2008-11-16 11:44:05
606 8 User Demoted 2008-11-16 12:34:58
607 8 New Primary Created 2008-11-16 12:34:58
608 1 Something happened.. 2008-11-16 12:34:58
609 2 Something happened.. 2008-11-16 12:34:58
610 1 Something else happened.. 2008-11-16 12:34:58
611 8 User Demoted 2008-11-17 04:19:01
612 8 New Primary Created 2008-11-17 04:19:01
613 1 Something happened.. 2008-11-17 04:19:03
614 2 Something happened.. 2008-11-17 04:19:03
615 1 Something else happened.. 2008-11-17 04:19:03
616 8 User Demoted 2008-11-17 17:37:00
617 8 New Primary Created 2008-11-17 17:37:00
618 1 Something happened.. 2008-11-17 17:37:00
619 2 Something happened.. 2008-11-17 17:37:00
620 1 Something else happened.. 2008-11-17 17:37:00
621 8 User Demoted 2008-11-18 06:47:40
622 8 New Primary Created 2008-11-18 06:47:40
623 1 Something happened.. 2008-11-18 06:47:40
624 2 Something happened.. 2008-11-18 06:47:40
625 1 Something else happened.. 2008-11-18 06:47:40
626 8 User Demoted 2008-11-18 13:49:14
627 8