# Logfile created on Sun Jan 06 21:03:11 +0100 2008 by /
  [4;36;1mSQL (0.000000)[0m   [0;1mSET SQL_AUTO_IS_NULL=0[0m
  [4;35;1mSQL (0.197000)[0m   [0mCREATE TABLE schema_info (version int(11))[0m
  [4;36;1mSQL (0.059000)[0m   [0;1mINSERT INTO schema_info (version) VALUES(0)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Table 'schema_info' already exists: CREATE TABLE schema_info (version int(11))[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mSELECT version FROM schema_info[0m
Migrating to AddPersonAndGroceryListsAndFoodItemsTables (1)
  [4;35;1mSQL (0.965000)[0m   [0mCREATE TABLE people (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT NULL) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.169000)[0m   [0;1mCREATE TABLE grocery_lists (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT NULL, `person_id` int(11) DEFAULT NULL) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.147000)[0m   [0mCREATE TABLE food_items (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `grocery_list_id` int(11) DEFAULT NULL, `position` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `quantity` int(11) DEFAULT NULL) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.085000)[0m   [0;1mUPDATE schema_info SET version = 1[0m
  [4;35;1mSQL (0.000000)[0m   [0mSELECT * FROM schema_info[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mSHOW TABLES[0m
  [4;35;1mSQL (0.062000)[0m   [0mSHOW FIELDS FROM food_items[0m
  [4;36;1mSQL (0.002000)[0m   [0;1mSHOW KEYS FROM food_items[0m
  [4;35;1mSQL (0.015000)[0m   [0mSHOW FIELDS FROM grocery_lists[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mSHOW KEYS FROM grocery_lists[0m
  [4;35;1mSQL (0.047000)[0m   [0mSHOW FIELDS FROM people[0m
  [4;36;1mSQL (0.002000)[0m   [0;1mSHOW KEYS FROM people[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mSET SQL_AUTO_IS_NULL=0[0m
  [4;35;1mPerson Columns (0.019000)[0m   [0mSHOW FIELDS FROM people[0m
  [4;36;1mSQL (0.013000)[0m   [0;1mBEGIN[0m
  [4;35;1mSQL (0.022000)[0m   [0mINSERT INTO people (`name`) VALUES('Kelly')[0m
  [4;36;1mSQL (0.098000)[0m   [0;1mCOMMIT[0m
  [4;35;1mGroceryList Columns (0.079000)[0m   [0mSHOW FIELDS FROM grocery_lists[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mBEGIN[0m
  [4;35;1mSQL (0.001000)[0m   [0mINSERT INTO grocery_lists (`name`, `person_id`) VALUES('Obiad z dziadkami', 1)[0m
  [4;36;1mSQL (0.120000)[0m   [0;1mCOMMIT[0m
  [4;35;1mFoodItem Columns (0.006000)[0m   [0mSHOW FIELDS FROM food_items[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mBEGIN[0m
  [4;35;1mFoodItem Load (0.041000)[0m   [0mSELECT * FROM food_items WHERE (grocery_list_id = 1) ORDER BY position DESC LIMIT 1[0m
  [4;36;1mSQL (0.002000)[0m   [0;1mINSERT INTO food_items (`name`, `quantity`, `position`, `grocery_list_id`) VALUES('Kilogram mki', 1, 1, 1)[0m
  [4;35;1mSQL (0.026000)[0m   [0mCOMMIT[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mBEGIN[0m
  [4;35;1mFoodItem Load (0.001000)[0m   [0mSELECT * FROM food_items WHERE (grocery_list_id = 1) ORDER BY position DESC LIMIT 1[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mINSERT INTO food_items (`name`, `quantity`, `position`, `grocery_list_id`) VALUES('Kilogram woowiny', 2, 2, 1)[0m
  [4;35;1mSQL (0.192000)[0m   [0mCOMMIT[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mBEGIN[0m
  [4;35;1mFoodItem Load (0.001000)[0m   [0mSELECT * FROM food_items WHERE (grocery_list_id = 1) ORDER BY position DESC LIMIT 1[0m
  [4;36;1mSQL (0.001000)[0m   [0;1mINSERT INTO food_items (`name`, `quantity`, `position`, `grocery_list_id`) VALUES('Gwka czosnku', 1, 3, 1)[0m
  [4;35;1mSQL (0.166000)[0m   [0mCOMMIT[0m
  [4;36;1mFoodItem Load (0.001000)[0m   [0;1mSELECT * FROM food_items WHERE (food_items.grocery_list_id = 1) AND (food_items.`name` = 'Torba mki') LIMIT 1[0m
  [4;35;1mFoodItem Load (0.001000)[0m   [0mSELECT * FROM food_items WHERE (food_items.grocery_list_id = 1) AND (food_items.`name` = 'Kilogram mki') LIMIT 1[0m
