MDSD00Uw

1Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ DROP TABLE IF EXISTS "books"
2Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ PRAGMA table_info('books')
3Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT sqlite_version(*)
4Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ CREATE TABLE "books" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "title" VARCHAR(50), "author_id" INTEGER)
5Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ DROP TABLE IF EXISTS "authors"
6Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ PRAGMA table_info('authors')
7Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ CREATE TABLE "authors" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50))
8Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "authors" ("name") VALUES ('Author #1')
9Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "authors" ("name") VALUES ('Author #2')
10Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (1, 'Book #0')
11Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (2, 'Book #1')
12Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (1, 'Book #2')
13Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (2, 'Book #3')
14Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (1, 'Book #4')
15Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (2, 'Book #5')
16Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (1, 'Book #6')
17Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (2, 'Book #7')
18Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (1, 'Book #8')
19Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ INSERT INTO "books" ("author_id", "title") VALUES (2, 'Book #9')
20================================================================================
21Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "title", "author_id" FROM "books"
22Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 1 LIMIT 1
23Book #0 by Author #1
24Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 2 LIMIT 1
25Book #1 by Author #2
26Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 1 LIMIT 1
27Book #2 by Author #1
28Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 2 LIMIT 1
29Book #3 by Author #2
30Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 1 LIMIT 1
31Book #4 by Author #1
32Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 2 LIMIT 1
33Book #5 by Author #2
34Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 1 LIMIT 1
35Book #6 by Author #1
36Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 2 LIMIT 1
37Book #7 by Author #2
38Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 1 LIMIT 1
39Book #8 by Author #1
40Sun, 15 Jun 2008 22:24:16 GMT ~ debug ~ SELECT "id", "name" FROM "authors" WHERE "id" = 2 LIMIT 1
41Book #9 by Author #2