# Logfile created on Sat Oct 29 09:08:51 CDT 2005 by logger.rb/1.5.2.4 SQL (0.191909) DROP TABLE users SQL (0.002950) CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, crypted_password varchar(255), crypted_creditcard varchar(255), login varchar(50), type varchar(20))  SQL (0.000000) table schema_info already exists: CREATE TABLE schema_info (version integer) SQL (0.000688) PRAGMA table_info(schema_info) SQL (0.003226) UPDATE schema_info SET version = 1 User Load (0.001195) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.001331) PRAGMA table_info(users) User Load (0.001179) SELECT * FROM users WHERE (users.id = 2) LIMIT 1 SQL (0.001179) PRAGMA table_info(users) SQL (0.000573) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES(NULL, NULL, NULL, 'jones') User Update (0.001806) UPDATE users SET 'login' = 'jones', 'type' = NULL, 'crypted_password' = NULL, 'crypted_creditcard' = 'KUOKbSP2XPiYKSzxcopQBLnJD+IyhHycAAerMdzDahbg3u99l4YpuYfezO8C DQOvyxZ45VjD/7L1rvHcXlkyYw== ' WHERE id = 3 SQL (0.000540) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES(NULL, NULL, NULL, 'jones') User Update (0.001746) UPDATE users SET 'login' = 'jones', 'type' = NULL, 'crypted_password' = NULL, 'crypted_creditcard' = 'B5cvT3e38Mf2Ck44ld3ZGpaM8ubnzLuri+zHqaPQUmEU9SkD4/Ff9idx7LJF 5Zv9wchYUzG7vh0++25TU3e7cg== ' WHERE id = 3 User Load (0.001146) SELECT * FROM users WHERE (users.id = 2) LIMIT 1 User Load (0.001099) SELECT * FROM users WHERE (users.id = 2) LIMIT 1 User Load (0.001175) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.001334) PRAGMA table_info(users) SQL (0.000558) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'ShaUser', NULL, 'bob') SQL (0.001294) PRAGMA table_info(users) SQL (0.000570) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'DangerousUser', NULL, 'bob') User Load (0.001139) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.000537) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('0XlmUuNpE2k= ', 'SymmetricUser', NULL, 'bob') User Load (0.001262) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 User Load (0.001121) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.119978) DROP TABLE users SQL (0.026073) CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, crypted_password varchar(255), crypted_creditcard varchar(255), login varchar(50), type varchar(20))  SQL (0.000000) table schema_info already exists: CREATE TABLE schema_info (version integer) SQL (0.000674) PRAGMA table_info(schema_info) SQL (0.004633) UPDATE schema_info SET version = 1 User Load (0.001196) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.001339) PRAGMA table_info(users) User Load (0.001147) SELECT * FROM users WHERE (users.id = 2) LIMIT 1 SQL (0.001198) PRAGMA table_info(users) SQL (0.000582) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES(NULL, NULL, NULL, 'jones') User Update (0.001720) UPDATE users SET 'login' = 'jones', 'type' = NULL, 'crypted_password' = NULL, 'crypted_creditcard' = 'DLIh4equrhSTs6yK2f+w82K4xt7bROoHbkYXp+eynjF0FD9WRv4Ont5bOSDZ QjyBWLYsekOqbR+EbIkEmNcHeA== ' WHERE id = 3 SQL (0.000573) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES(NULL, NULL, NULL, 'jones') User Update (0.001698) UPDATE users SET 'login' = 'jones', 'type' = NULL, 'crypted_password' = NULL, 'crypted_creditcard' = 'eQOiEbqm6S9YylKEIY/uKIamJoNWmb0x2Zth+N8LCEoZRh66bQFfyh4H1k5r p5HUIZpNnol1bMhVtqWG31lWjw== ' WHERE id = 3 User Load (0.001134) SELECT * FROM users WHERE (users.id = 2) LIMIT 1 User Load (0.001122) SELECT * FROM users WHERE (users.id = 2) LIMIT 1 User Load (0.001154) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.001791) PRAGMA table_info(users) SQL (0.000602) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'ShaUser', NULL, 'bob') SQL (0.001591) PRAGMA table_info(users) SQL (0.000550) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'DangerousUser', NULL, 'bob') User Load (0.003733) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.000532) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('0XlmUuNpE2k= ', 'SymmetricUser', NULL, 'bob') User Load (0.001268) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 User Load (0.001492) SELECT * FROM users WHERE (users.id = 1) LIMIT 1 SQL (0.208598) DROP TABLE users SQL (0.003186) CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, crypted_password varchar(255), crypted_creditcard varchar(255), login varchar(50), type varchar(20))  SQL (0.000000) table schema_info already exists: CREATE TABLE schema_info (version integer) SQL (0.000686) PRAGMA table_info(schema_info) SQL (0.003169) UPDATE schema_info SET version = 1 SQL (0.001369) PRAGMA table_info(users) SQL (0.000543) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'ShaUser', NULL, 'bob') SQL (0.001211) PRAGMA table_info(users) SQL (0.000614) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'DangerousUser', NULL, 'bob') SQL (0.208579) DROP TABLE users SQL (0.003693) CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, crypted_password varchar(255), crypted_creditcard varchar(255), login varchar(50), type varchar(20))  SQL (0.000000) table schema_info already exists: CREATE TABLE schema_info (version integer) SQL (0.000644) PRAGMA table_info(schema_info) SQL (0.003024) UPDATE schema_info SET version = 1 SQL (0.002309) PRAGMA table_info(users) SQL (0.000523) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'ShaUser', NULL, 'bob') SQL (0.001247) PRAGMA table_info(users) SQL (0.000551) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'DangerousUser', NULL, 'bob') SQL (0.004938) DROP TABLE users SQL (0.003801) CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, crypted_password varchar(255), crypted_creditcard varchar(255), login varchar(50), type varchar(20))  SQL (0.000000) table schema_info already exists: CREATE TABLE schema_info (version integer) SQL (0.000648) PRAGMA table_info(schema_info) SQL (0.003591) UPDATE schema_info SET version = 1 SQL (0.001882) PRAGMA table_info(users) SQL (0.000592) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'ShaUser', NULL, 'bob') SQL (0.001319) PRAGMA table_info(users) SQL (0.000643) INSERT INTO users ('crypted_password', 'type', 'crypted_creditcard', 'login') VALUES('f438229716cab43569496f3a3630b3727524b81b', 'DangerousUser', NULL, 'bob')