# Logfile created on Sat Feb 14 10:24:59 -0500 2009 by /
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.rollback
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
Transaction.begin
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
Transaction.commit
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
PRAGMA table_info('foo')
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE ((`state` NOT IN ('parked')) AND (`state` = 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` IN ('parked', 'idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('idling'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('parked')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 2) LIMIT 1
INSERT INTO `foo` (`state`) VALUES ('first_gear')
SELECT * FROM `foo` WHERE (`id` = 3) LIMIT 1
SELECT * FROM `foo` WHERE (`state` NOT IN ('first_gear'))
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES (NULL)
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
SELECT COUNT(*) FROM `foo` LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
INSERT INTO `foo` (`state`) VALUES ('idling')
SELECT * FROM `foo` WHERE (`id` = 1) LIMIT 1
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)
DROP TABLE `foo`
CREATE TABLE `foo` (`id` integer PRIMARY KEY AUTOINCREMENT, `state` string)