# Logfile created on Mon Mar 03 21:20:04 -0500 2008SQL (0.000532)  SHOW client_min_messages
SQL (0.000239)  SET client_min_messages TO 'panic'
SQL (0.000228)  SHOW standard_conforming_strings
SQL (0.000203)  SET client_min_messages TO 'notice'
SQL (0.000539)  SELECT version()
SQL (0.000000)  PGError: ERROR: relation "schema_info" already exists
: CREATE TABLE schema_info (version integer)
SQL (0.004738)  SELECT version FROM schema_info
SQL (0.000489)  SELECT version FROM schema_info
SQL (0.000425)  SELECT version FROM schema_info
SQL (0.000423)  SELECT version FROM schema_info
SQL (0.000310)  SELECT version FROM schema_info
SQL (0.000422)  SELECT version FROM schema_info
SQL (0.000429)  SELECT version FROM schema_info
SQL (0.000422)  SELECT version FROM schema_info
SQL (0.000417)  SELECT version FROM schema_info
SQL (0.000369)  SELECT version FROM schema_info
SQL (0.000253)  SELECT version FROM schema_info
SQL (0.000271)  SELECT version FROM schema_info
SQL (0.000415)  SELECT version FROM schema_info
SQL (0.000412)  SELECT version FROM schema_info
SQL (0.000640)  SELECT * FROM schema_info
SQL (0.000416)  SHOW search_path
SQL (0.008127)   SELECT tablename
 FROM pg_tables
 WHERE schemaname IN (E'"$user"',E'public')
SQL (0.005401)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'firms'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.007318)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'firms'::regclass
SQL (0.005393)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'firms'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001810)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'line_items'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005722)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'line_items'::regclass
SQL (0.003519)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'line_items'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001622)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'offers'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005626)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'offers'::regclass
SQL (0.003653)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'offers'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001829)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'orders'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005668)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'orders'::regclass
SQL (0.003899)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'orders'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001851)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'pcheck_log_entries'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005529)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'pcheck_log_entries'::regclass
SQL (0.003176)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'pcheck_log_entries'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001790)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'permissions'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005735)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'permissions'::regclass
SQL (0.003974)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'permissions'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001976)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'products'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005689)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'products'::regclass
SQL (0.003800)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'products'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001849)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'request_log_entries'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005581)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'request_log_entries'::regclass
SQL (0.003394)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'request_log_entries'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001673)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'role_assignments'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005549)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'role_assignments'::regclass
SQL (0.003835)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'role_assignments'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001715)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'roles'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005662)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'roles'::regclass
SQL (0.004131)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'roles'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001804)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'sessions'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005785)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'sessions'::regclass
SQL (0.003703)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'sessions'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001544)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'stores'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005705)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'stores'::regclass
SQL (0.004001)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'stores'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001962)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'users'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
PK and serial sequence (0.005479)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'users'::regclass
SQL (0.003720)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'users'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname
SQL (0.001914)   SELECT tablename
 FROM pg_tables
 WHERE schemaname IN (E'"$user"',E'public')
SQL (0.001240)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='firms')
SQL (0.001162)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='line_items')
SQL (0.001314)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='offers')
SQL (0.001109)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='orders')
SQL (0.001075)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='pcheck_log_entries')
SQL (0.001108)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='permissions')
SQL (0.000978)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='products')
SQL (0.000796)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='request_log_entries')
SQL (0.001118)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='role_assignments')
SQL (0.001111)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='roles')
SQL (0.000963)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='schema_notes')
SQL (0.000826)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='sessions')
SQL (0.001122)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='stores')
SQL (0.001100)  SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contype='f' AND conrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='users')
SQL (0.000729)  SHOW client_min_messages
SQL (0.000453)  SET client_min_messages TO 'panic'
SQL (0.000385)  SHOW standard_conforming_strings
SQL (0.000322)  SET client_min_messages TO 'notice'
SQL (0.001098)  SELECT version()
SQL (0.067170)  CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.007425)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'schema_notes'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
SQL (0.000467)  BEGIN
PK and serial sequence (0.021316)   SELECT attr.attname, seq.relname
 FROM pg_class seq,
 pg_attribute attr,
 pg_depend dep,
 pg_namespace name,
 pg_constraint cons
 WHERE seq.oid = dep.objid
 AND seq.relkind = 'S'
 AND attr.attrelid = dep.refobjid
 AND attr.attnum = dep.refobjsubid
 AND attr.attrelid = cons.conrelid
 AND attr.attnum = cons.conkey[1]
 AND cons.contype = 'p'
 AND dep.refobjid = 'schema_notes'::regclass
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.001466)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'firms', E'id')
SQL (0.000750)  SELECT currval('schema_notes_id_seq')
SQL (0.001173)  COMMIT
SQL (0.000357)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000848)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'firms', E'name')
SQL (0.000425)  SELECT currval('schema_notes_id_seq')
SQL (0.000952)  COMMIT
SQL (0.000371)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000774)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'firms', E'search_name')
SQL (0.000401)  SELECT currval('schema_notes_id_seq')
SQL (0.001152)  COMMIT
SQL (0.000408)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000701)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'firms', E'full_name')
SQL (0.000392)  SELECT currval('schema_notes_id_seq')
SQL (0.000899)  COMMIT
SQL (0.000552)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000868)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'firms', E'password_lifetime_days')
SQL (0.000447)  SELECT currval('schema_notes_id_seq')
SQL (0.000900)  COMMIT
SQL (0.000245)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000440)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'firms', E'max_bad_logins')
SQL (0.000241)  SELECT currval('schema_notes_id_seq')
SQL (0.000675)  COMMIT
SQL (0.000217)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000548)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'firms', E'bad_login_dead_minutes')
SQL (0.000266)  SELECT currval('schema_notes_id_seq')
SQL (0.000704)  COMMIT
SQL (0.000305)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000497)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'firms', E'created_at')
SQL (0.000264)  SELECT currval('schema_notes_id_seq')
SQL (0.000737)  COMMIT
SQL (0.000196)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000403)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'firms', E'updated_at')
SQL (0.000239)  SELECT currval('schema_notes_id_seq')
SQL (0.000725)  COMMIT
SQL (0.013619)  CREATE TABLE firms ("id" serial primary key, "name" character varying(100) NOT NULL, "search_name" character varying(100) NOT NULL, "full_name" character varying(100) NOT NULL, "password_lifetime_days" integer DEFAULT NULL, "max_bad_logins" integer DEFAULT NULL, "bad_login_dead_minutes" integer DEFAULT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
SQL (0.007731)  CREATE UNIQUE INDEX "index_firms_on_full_name" ON firms ("full_name")
SQL (0.004570)  CREATE UNIQUE INDEX "index_firms_on_search_name" ON firms ("search_name")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000256)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000479)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'line_items', E'id')
SQL (0.000266)  SELECT currval('schema_notes_id_seq')
SQL (0.000665)  COMMIT
SQL (0.000201)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000420)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'line_items', E'order_id')
SQL (0.000240)  SELECT currval('schema_notes_id_seq')
SQL (0.001296)  COMMIT
SQL (0.000212)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000459)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'line_items', E'offer_id')
SQL (0.000397)  SELECT currval('schema_notes_id_seq')
SQL (0.001159)  COMMIT
SQL (0.000263)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000555)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'line_items', E'quantity')
SQL (0.000314)  SELECT currval('schema_notes_id_seq')
SQL (0.000784)  COMMIT
SQL (0.008932)  CREATE TABLE line_items ("id" serial primary key, "order_id" integer NOT NULL, "offer_id" integer NOT NULL, "quantity" integer NOT NULL) 
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000345)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000734)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'offers', E'id')
SQL (0.000384)  SELECT currval('schema_notes_id_seq')
SQL (0.000852)  COMMIT
SQL (0.000285)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.011944)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'offers', E'product_id')
SQL (0.000398)  SELECT currval('schema_notes_id_seq')
SQL (0.000843)  COMMIT
SQL (0.000312)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000609)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'offers', E'store_id')
SQL (0.000372)  SELECT currval('schema_notes_id_seq')
SQL (0.000971)  COMMIT
SQL (0.000331)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000630)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'offers', E'discount_pct')
SQL (0.000375)  SELECT currval('schema_notes_id_seq')
SQL (0.000859)  COMMIT
SQL (0.000406)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000641)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'offers', E'owner_id')
SQL (0.000379)  SELECT currval('schema_notes_id_seq')
SQL (0.000856)  COMMIT
SQL (0.000389)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000830)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'offers', E'owner_firm_id')
SQL (0.000407)  SELECT currval('schema_notes_id_seq')
SQL (0.000785)  COMMIT
SQL (0.014952)  CREATE TABLE offers ("id" serial primary key, "product_id" integer NOT NULL, "store_id" integer NOT NULL, "discount_pct" integer DEFAULT NULL, "owner_id" integer NOT NULL, "owner_firm_id" integer NOT NULL) 
SQL (0.008654)  CREATE INDEX "offers_by_firm" ON offers ("owner_firm_id")
SQL (0.004465)  CREATE INDEX "offers_by_owner" ON offers ("owner_id")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000383)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000653)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'orders', E'id')
SQL (0.000393)  SELECT currval('schema_notes_id_seq')
SQL (0.000856)  COMMIT
SQL (0.000306)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000587)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'orders', E'store_id')
SQL (0.000456)  SELECT currval('schema_notes_id_seq')
SQL (0.000955)  COMMIT
SQL (0.000331)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000770)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 1000, NULL, E'orders', E'shipping_address')
SQL (0.000460)  SELECT currval('schema_notes_id_seq')
SQL (0.000855)  COMMIT
SQL (0.000363)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000751)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 50, NULL, E'orders', E'payment_authenticator')
SQL (0.000393)  SELECT currval('schema_notes_id_seq')
SQL (0.000854)  COMMIT
SQL (0.000378)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000826)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, 'f', E'orders', E'paid')
SQL (0.000396)  SELECT currval('schema_notes_id_seq')
SQL (0.001030)  COMMIT
SQL (0.000328)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000620)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, 'f', E'orders', E'shipped')
SQL (0.000374)  SELECT currval('schema_notes_id_seq')
SQL (0.000778)  COMMIT
SQL (0.000294)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000600)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'text', NULL, NULL, NULL, E'orders', E'notes')
SQL (0.000378)  SELECT currval('schema_notes_id_seq')
SQL (0.000755)  COMMIT
SQL (0.000292)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000599)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'orders', E'created_at')
SQL (0.000364)  SELECT currval('schema_notes_id_seq')
SQL (0.000921)  COMMIT
SQL (0.000363)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000711)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'orders', E'updated_at')
SQL (0.000415)  SELECT currval('schema_notes_id_seq')
SQL (0.000877)  COMMIT
SQL (0.000370)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000734)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'orders', E'owner_id')
SQL (0.000387)  SELECT currval('schema_notes_id_seq')
SQL (0.000768)  COMMIT
SQL (0.000351)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000615)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'orders', E'owner_firm_id')
SQL (0.000376)  SELECT currval('schema_notes_id_seq')
SQL (0.000712)  COMMIT
SQL (0.013322)  CREATE TABLE orders ("id" serial primary key, "store_id" integer NOT NULL, "shipping_address" character varying(1000) DEFAULT NULL, "payment_authenticator" character varying(50) DEFAULT NULL, "paid" boolean DEFAULT 'f' NOT NULL, "shipped" boolean DEFAULT 'f' NOT NULL, "notes" text DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "updated_at" timestamp DEFAULT NULL, "owner_id" integer NOT NULL, "owner_firm_id" integer NOT NULL) 
SQL (0.003909)  CREATE INDEX "orders_by_firm" ON orders ("owner_firm_id")
SQL (0.003839)  CREATE INDEX "orders_by_owner" ON orders ("owner_id")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000251)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000490)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'pcheck_log_entries', E'id')
SQL (0.000266)  SELECT currval('schema_notes_id_seq')
SQL (0.000682)  COMMIT
SQL (0.000187)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000420)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'pcheck_log_entries', E'request_log_entry_id')
SQL (0.000245)  SELECT currval('schema_notes_id_seq')
SQL (0.000737)  COMMIT
SQL (0.000188)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000376)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, 'f', E'pcheck_log_entries', E'success')
SQL (0.000235)  SELECT currval('schema_notes_id_seq')
SQL (0.000693)  COMMIT
SQL (0.000357)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000557)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'pcheck_log_entries', E'model_class')
SQL (0.000238)  SELECT currval('schema_notes_id_seq')
SQL (0.001168)  COMMIT
SQL (0.000275)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000542)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'pcheck_log_entries', E'model_id')
SQL (0.000285)  SELECT currval('schema_notes_id_seq')
SQL (0.000718)  COMMIT
SQL (0.000182)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000637)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 40, 'f', E'pcheck_log_entries', E'privilege')
SQL (0.000392)  SELECT currval('schema_notes_id_seq')
SQL (0.000834)  COMMIT
SQL (0.000312)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000606)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'pcheck_log_entries', E'user_id')
SQL (0.000370)  SELECT currval('schema_notes_id_seq')
SQL (0.000770)  COMMIT
SQL (0.002893)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000506)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'pcheck_log_entries', E'user_name')
SQL (0.000242)  SELECT currval('schema_notes_id_seq')
SQL (0.000787)  COMMIT
SQL (0.000318)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000593)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'pcheck_log_entries', E'created_at')
SQL (0.000369)  SELECT currval('schema_notes_id_seq')
SQL (0.000771)  COMMIT
SQL (0.000308)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000569)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'pcheck_log_entries', E'updated_at')
SQL (0.000238)  SELECT currval('schema_notes_id_seq')
SQL (0.000605)  COMMIT
SQL (0.011234)  CREATE TABLE pcheck_log_entries ("id" serial primary key, "request_log_entry_id" integer NOT NULL, "success" boolean NOT NULL, "model_class" character varying(100) NOT NULL, "model_id" integer DEFAULT NULL, "privilege" character varying(40) NOT NULL, "user_id" integer NOT NULL, "user_name" character varying(100) NOT NULL, "created_at" timestamp DEFAULT NULL, "updated_at" timestamp DEFAULT NULL) 
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000417)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000741)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'permissions', E'id')
SQL (0.000408)  SELECT currval('schema_notes_id_seq')
SQL (0.000826)  COMMIT
SQL (0.000294)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000623)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'permissions', E'role_id')
SQL (0.000377)  SELECT currval('schema_notes_id_seq')
SQL (0.003282)  COMMIT
SQL (0.000309)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000691)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, 'f', E'permissions', E'is_grant')
SQL (0.000251)  SELECT currval('schema_notes_id_seq')
SQL (0.000707)  COMMIT
SQL (0.000187)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000568)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, 'f', E'permissions', E'has_grant_option')
SQL (0.000230)  SELECT currval('schema_notes_id_seq')
SQL (0.001353)  COMMIT
SQL (0.000300)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000627)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 40, 'f', E'permissions', E'class_name')
SQL (0.000395)  SELECT currval('schema_notes_id_seq')
SQL (0.000967)  COMMIT
SQL (0.000345)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000766)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 40, 'f', E'permissions', E'privilege')
SQL (0.000418)  SELECT currval('schema_notes_id_seq')
SQL (0.001195)  COMMIT
SQL (0.000365)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000735)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, 'f', E'permissions', E'target_owned_by_self')
SQL (0.000401)  SELECT currval('schema_notes_id_seq')
SQL (0.000713)  COMMIT
SQL (0.000211)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000618)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'permissions', E'target_owner_id')
SQL (0.000320)  SELECT currval('schema_notes_id_seq')
SQL (0.000888)  COMMIT
SQL (0.000262)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000580)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'permissions', E'target_owner_firm_id')
SQL (0.000295)  SELECT currval('schema_notes_id_seq')
SQL (0.000917)  COMMIT
SQL (0.000220)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000593)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'permissions', E'target_id')
SQL (0.000364)  SELECT currval('schema_notes_id_seq')
SQL (0.001046)  COMMIT
SQL (0.000368)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000772)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, NULL, E'permissions', E'target_name')
SQL (0.000255)  SELECT currval('schema_notes_id_seq')
SQL (0.000749)  COMMIT
SQL (0.000360)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000706)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'permissions', E'created_at')
SQL (0.000396)  SELECT currval('schema_notes_id_seq')
SQL (0.000851)  COMMIT
SQL (0.000310)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000562)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'permissions', E'updated_at')
SQL (0.000227)  SELECT currval('schema_notes_id_seq')
SQL (0.000663)  COMMIT
SQL (0.000334)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000577)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, NULL, E'permissions', E'target_paid')
SQL (0.000363)  SELECT currval('schema_notes_id_seq')
SQL (0.000892)  COMMIT
SQL (0.012262)  CREATE TABLE permissions ("id" serial primary key, "role_id" integer DEFAULT NULL, "is_grant" boolean NOT NULL, "has_grant_option" boolean NOT NULL, "class_name" character varying(40) NOT NULL, "privilege" character varying(40) NOT NULL, "target_owned_by_self" boolean NOT NULL, "target_owner_id" integer DEFAULT NULL, "target_owner_firm_id" integer DEFAULT NULL, "target_id" integer DEFAULT NULL, "target_name" character varying(100) DEFAULT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "target_paid" boolean DEFAULT NULL) 
SQL (0.004556)  CREATE INDEX "index_permissions_on_role_id" ON permissions ("role_id")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000293)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000633)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'products', E'id')
SQL (0.000410)  SELECT currval('schema_notes_id_seq')
SQL (0.000853)  COMMIT
SQL (0.000298)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000665)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'products', E'name')
SQL (0.000403)  SELECT currval('schema_notes_id_seq')
SQL (0.000810)  COMMIT
SQL (0.000299)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000484)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'text', NULL, NULL, 'f', E'products', E'description')
SQL (0.000396)  SELECT currval('schema_notes_id_seq')
SQL (0.001446)  COMMIT
SQL (0.000350)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000765)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 400, NULL, E'products', E'image_url')
SQL (0.000527)  SELECT currval('schema_notes_id_seq')
SQL (0.001017)  COMMIT
SQL (0.000351)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000660)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(8, 2, E'decimal', NULL, NULL, 'f', E'products', E'price')
SQL (0.000275)  SELECT currval('schema_notes_id_seq')
SQL (0.000826)  COMMIT
SQL (0.003693)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000706)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'products', E'owner_id')
SQL (0.000398)  SELECT currval('schema_notes_id_seq')
SQL (0.002994)  COMMIT
SQL (0.000345)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000680)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'products', E'owner_firm_id')
SQL (0.000429)  SELECT currval('schema_notes_id_seq')
SQL (0.000878)  COMMIT
SQL (0.039818)  CREATE TABLE products ("id" serial primary key, "name" character varying(100) NOT NULL, "description" text NOT NULL, "image_url" character varying(400) DEFAULT NULL, "price" decimal(8,2) NOT NULL, "owner_id" integer NOT NULL, "owner_firm_id" integer NOT NULL) 
SQL (0.005188)  CREATE INDEX "products_by_firm" ON products ("owner_firm_id")
SQL (0.008580)  CREATE INDEX "products_by_owner" ON products ("owner_id")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000328)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000759)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'request_log_entries', E'id')
SQL (0.000393)  SELECT currval('schema_notes_id_seq')
SQL (0.001030)  COMMIT
SQL (0.000340)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000531)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'request_log_entries', E'created_at')
SQL (0.000409)  SELECT currval('schema_notes_id_seq')
SQL (0.000872)  COMMIT
SQL (0.000335)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000661)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'request_log_entries', E'updated_at')
SQL (0.000304)  SELECT currval('schema_notes_id_seq')
SQL (0.000836)  COMMIT
SQL (0.000304)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000579)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'request_log_entries', E'acting_user_id')
SQL (0.000381)  SELECT currval('schema_notes_id_seq')
SQL (0.000848)  COMMIT
SQL (0.000311)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000591)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'request_log_entries', E'user_of_record_id')
SQL (0.000382)  SELECT currval('schema_notes_id_seq')
SQL (0.000798)  COMMIT
SQL (0.000305)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000624)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, NULL, NULL, E'request_log_entries', E'acting_user_name')
SQL (0.000374)  SELECT currval('schema_notes_id_seq')
SQL (0.000812)  COMMIT
SQL (0.000373)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000849)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, NULL, NULL, E'request_log_entries', E'user_of_record_name')
SQL (0.000430)  SELECT currval('schema_notes_id_seq')
SQL (0.000885)  COMMIT
SQL (0.000332)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000796)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'request_log_entries', E'controller')
SQL (0.000450)  SELECT currval('schema_notes_id_seq')
SQL (0.000868)  COMMIT
SQL (0.000198)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000634)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'request_log_entries', E'action')
SQL (0.000440)  SELECT currval('schema_notes_id_seq')
SQL (0.000846)  COMMIT
SQL (0.000334)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000624)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 50, 'f', E'request_log_entries', E'http_method')
SQL (0.000391)  SELECT currval('schema_notes_id_seq')
SQL (0.000799)  COMMIT
SQL (0.000177)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000569)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'request_log_entries', E'status')
SQL (0.000385)  SELECT currval('schema_notes_id_seq')
SQL (0.000947)  COMMIT
SQL (0.000476)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000834)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, NULL, E'request_log_entries', E'model_class')
SQL (0.000432)  SELECT currval('schema_notes_id_seq')
SQL (0.000868)  COMMIT
SQL (0.000330)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000727)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'request_log_entries', E'model_id')
SQL (0.000404)  SELECT currval('schema_notes_id_seq')
SQL (0.000966)  COMMIT
SQL (0.000369)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000653)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 50, NULL, E'request_log_entries', E'remote_ip')
SQL (0.000400)  SELECT currval('schema_notes_id_seq')
SQL (0.000804)  COMMIT
SQL (0.021301)  CREATE TABLE request_log_entries ("id" serial primary key, "created_at" timestamp DEFAULT NULL, "updated_at" timestamp DEFAULT NULL, "acting_user_id" integer DEFAULT NULL, "user_of_record_id" integer DEFAULT NULL, "acting_user_name" character varying(255) DEFAULT NULL, "user_of_record_name" character varying(255) DEFAULT NULL, "controller" character varying(100) NOT NULL, "action" character varying(100) NOT NULL, "http_method" character varying(50) NOT NULL, "status" character varying(100) NOT NULL, "model_class" character varying(100) DEFAULT NULL, "model_id" integer DEFAULT NULL, "remote_ip" character varying(50) DEFAULT NULL) 
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000379)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000673)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'role_assignments', E'id')
SQL (0.000385)  SELECT currval('schema_notes_id_seq')
SQL (0.000906)  COMMIT
SQL (0.000318)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000746)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'role_assignments', E'user_id')
SQL (0.000321)  SELECT currval('schema_notes_id_seq')
SQL (0.000883)  COMMIT
SQL (0.000321)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000694)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'role_assignments', E'role_id')
SQL (0.000416)  SELECT currval('schema_notes_id_seq')
SQL (0.000809)  COMMIT
SQL (0.000269)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000612)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'role_assignments', E'default_user_id')
SQL (0.000383)  SELECT currval('schema_notes_id_seq')
SQL (0.000808)  COMMIT
SQL (0.000298)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000610)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'role_assignments', E'default_firm_id')
SQL (0.000382)  SELECT currval('schema_notes_id_seq')
SQL (0.000903)  COMMIT
SQL (0.000388)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000741)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'role_assignments', E'invalid_after')
SQL (0.000408)  SELECT currval('schema_notes_id_seq')
SQL (0.000907)  COMMIT
SQL (0.000368)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000714)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'role_assignments', E'created_at')
SQL (0.000463)  SELECT currval('schema_notes_id_seq')
SQL (0.000877)  COMMIT
SQL (0.000331)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000725)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'role_assignments', E'updated_at')
SQL (0.000451)  SELECT currval('schema_notes_id_seq')
SQL (0.000872)  COMMIT
SQL (0.028844)  CREATE TABLE role_assignments ("id" serial primary key, "user_id" integer NOT NULL, "role_id" integer NOT NULL, "default_user_id" integer DEFAULT NULL, "default_firm_id" integer DEFAULT NULL, "invalid_after" timestamp DEFAULT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000379)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000825)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'roles', E'id')
SQL (0.000396)  SELECT currval('schema_notes_id_seq')
SQL (0.000883)  COMMIT
SQL (0.000807)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000765)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'roles', E'name')
SQL (0.000388)  SELECT currval('schema_notes_id_seq')
SQL (0.001183)  COMMIT
SQL (0.000348)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000790)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'roles', E'search_name')
SQL (0.000437)  SELECT currval('schema_notes_id_seq')
SQL (0.000875)  COMMIT
SQL (0.000307)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000806)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'roles', E'created_at')
SQL (0.000399)  SELECT currval('schema_notes_id_seq')
SQL (0.000790)  COMMIT
SQL (0.000305)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000614)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'roles', E'updated_at')
SQL (0.000394)  SELECT currval('schema_notes_id_seq')
SQL (0.000827)  COMMIT
SQL (0.001286)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000874)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'roles', E'owner_id')
SQL (0.000682)  SELECT currval('schema_notes_id_seq')
SQL (0.000836)  COMMIT
SQL (0.000307)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000728)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'roles', E'owner_firm_id')
SQL (0.000422)  SELECT currval('schema_notes_id_seq')
SQL (0.000790)  COMMIT
SQL (0.011902)  CREATE TABLE roles ("id" serial primary key, "name" character varying(100) NOT NULL, "search_name" character varying(100) NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "owner_id" integer NOT NULL, "owner_firm_id" integer NOT NULL) 
SQL (0.008681)  CREATE UNIQUE INDEX "ix_role_by_name_and_owner" ON roles ("search_name", "owner_firm_id")
SQL (0.004560)  CREATE INDEX "roles_by_firm" ON roles ("owner_firm_id")
SQL (0.004558)  CREATE INDEX "roles_by_owner" ON roles ("owner_id")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000389)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000833)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'sessions', E'id')
SQL (0.000402)  SELECT currval('schema_notes_id_seq')
SQL (0.001865)  COMMIT
SQL (0.000401)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000813)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, NULL, 'f', E'sessions', E'session_id')
SQL (0.000600)  SELECT currval('schema_notes_id_seq')
SQL (0.000863)  COMMIT
SQL (0.000310)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000635)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'text', NULL, NULL, NULL, E'sessions', E'data')
SQL (0.000401)  SELECT currval('schema_notes_id_seq')
SQL (0.000760)  COMMIT
SQL (0.000301)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000615)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'sessions', E'created_at')
SQL (0.000381)  SELECT currval('schema_notes_id_seq')
SQL (0.000811)  COMMIT
SQL (0.000347)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000601)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'sessions', E'updated_at')
SQL (0.000478)  SELECT currval('schema_notes_id_seq')
SQL (0.000768)  COMMIT
SQL (0.016632)  CREATE TABLE sessions ("id" serial primary key, "session_id" character varying(255) NOT NULL, "data" text DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "updated_at" timestamp DEFAULT NULL) 
SQL (0.005507)  CREATE INDEX "index_sessions_on_session_id" ON sessions ("session_id")
SQL (0.004875)  CREATE INDEX "index_sessions_on_updated_at" ON sessions ("updated_at")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000361)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.001322)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'stores', E'id')
SQL (0.000469)  SELECT currval('schema_notes_id_seq')
SQL (0.011886)  COMMIT
SQL (0.000505)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000847)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'stores', E'name')
SQL (0.000946)  SELECT currval('schema_notes_id_seq')
SQL (0.000888)  COMMIT
SQL (0.000353)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000781)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'text', NULL, NULL, 'f', E'stores', E'description')
SQL (0.000450)  SELECT currval('schema_notes_id_seq')
SQL (0.000808)  COMMIT
SQL (0.000378)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000711)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'stores', E'owner_id')
SQL (0.000430)  SELECT currval('schema_notes_id_seq')
SQL (0.000921)  COMMIT
SQL (0.000307)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000672)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'stores', E'owner_firm_id')
SQL (0.000394)  SELECT currval('schema_notes_id_seq')
SQL (0.000843)  COMMIT
SQL (0.039247)  CREATE TABLE stores ("id" serial primary key, "name" character varying(100) NOT NULL, "description" text NOT NULL, "owner_id" integer NOT NULL, "owner_firm_id" integer NOT NULL) 
SQL (0.005401)  CREATE INDEX "stores_by_firm" ON stores ("owner_firm_id")
SQL (0.004693)  CREATE INDEX "stores_by_owner" ON stores ("owner_id")
SQL (0.000000)  PGError: ERROR: relation "schema_notes" already exists
: CREATE TABLE schema_notes ("id" serial primary key, "table_name" character varying(100) NOT NULL, "column_name" character varying(100) NOT NULL, "column_type" character varying(100) NOT NULL, "comment_decl" character varying(2000) DEFAULT NULL, "limit_decl" integer DEFAULT NULL, "scale_decl" integer DEFAULT NULL, "precision_decl" integer DEFAULT NULL, "null_decl" boolean DEFAULT NULL) 
SQL (0.000625)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000806)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'primary_key', NULL, NULL, NULL, E'users', E'id')
SQL (0.000422)  SELECT currval('schema_notes_id_seq')
SQL (0.001341)  COMMIT
SQL (0.000332)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.005752)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'users', E'name')
SQL (0.000360)  SELECT currval('schema_notes_id_seq')
SQL (0.001343)  COMMIT
SQL (0.000313)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000836)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'users', E'search_name')
SQL (0.000446)  SELECT currval('schema_notes_id_seq')
SQL (0.000932)  COMMIT
SQL (0.000381)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000779)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, 'f', E'users', E'full_name')
SQL (0.000442)  SELECT currval('schema_notes_id_seq')
SQL (0.000837)  COMMIT
SQL (0.000354)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000762)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, 'f', E'users', E'owner_firm_id')
SQL (0.000463)  SELECT currval('schema_notes_id_seq')
SQL (0.000826)  COMMIT
SQL (0.000300)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000690)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 100, NULL, E'users', E'password_hash')
SQL (0.000383)  SELECT currval('schema_notes_id_seq')
SQL (0.000721)  COMMIT
SQL (0.000428)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000708)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'string', NULL, 10, NULL, E'users', E'password_salt')
SQL (0.000420)  SELECT currval('schema_notes_id_seq')
SQL (0.000870)  COMMIT
SQL (0.000305)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000646)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'users', E'password_expires_at')
SQL (0.000391)  SELECT currval('schema_notes_id_seq')
SQL (0.000745)  COMMIT
SQL (0.000304)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.003288)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'users', E'bad_login_attempts')
SQL (0.000426)  SELECT currval('schema_notes_id_seq')
SQL (0.000851)  COMMIT
SQL (0.000381)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000778)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'integer', NULL, NULL, NULL, E'users', E'bad_logins_since_lockout')
SQL (0.000408)  SELECT currval('schema_notes_id_seq')
SQL (0.000770)  COMMIT
SQL (0.000409)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000723)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'users', E'no_login_until')
SQL (0.000397)  SELECT currval('schema_notes_id_seq')
SQL (0.000791)  COMMIT
SQL (0.000359)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000700)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'boolean', NULL, NULL, NULL, E'users', E'locked_out')
SQL (0.000386)  SELECT currval('schema_notes_id_seq')
SQL (0.001479)  COMMIT
SQL (0.004752)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000757)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, NULL, E'users', E'last_login_at')
SQL (0.000389)  SELECT currval('schema_notes_id_seq')
SQL (0.000774)  COMMIT
SQL (0.000326)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.000565)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'users', E'created_at')
SQL (0.000365)  SELECT currval('schema_notes_id_seq')
SQL (0.000754)  COMMIT
SQL (0.000284)  BEGIN
ActiveRecord::ConnectionAdapters::SchemaStatementsSlExt::SchemaNote Create (0.003197)  INSERT INTO schema_notes ("precision_decl", "scale_decl", "column_type", "comment_decl", "limit_decl", "null_decl", "table_name", "column_name") VALUES(NULL, NULL, E'datetime', NULL, NULL, 'f', E'users', E'updated_at')
SQL (0.000687)  SELECT currval('schema_notes_id_seq')
SQL (0.000834)  COMMIT
SQL (0.014762)  CREATE TABLE users ("id" serial primary key, "name" character varying(100) NOT NULL, "search_name" character varying(100) NOT NULL, "full_name" character varying(100) NOT NULL, "owner_firm_id" integer NOT NULL, "password_hash" character varying(100) DEFAULT NULL, "password_salt" character varying(10) DEFAULT NULL, "password_expires_at" timestamp DEFAULT NULL, "bad_login_attempts" integer DEFAULT NULL, "bad_logins_since_lockout" integer DEFAULT NULL, "no_login_until" timestamp DEFAULT NULL, "locked_out" boolean DEFAULT NULL, "last_login_at" timestamp DEFAULT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
SQL (0.006062)  CREATE UNIQUE INDEX "ix_user_by_firm_and_name" ON users ("search_name", "owner_firm_id")
SQL (0.006540)  ALTER TABLE line_items ADD CONSTRAINT line_items_ibfk_offer_id FOREIGN KEY (offer_id) REFERENCES offers (id)
SQL (0.004875)  ALTER TABLE line_items ADD CONSTRAINT line_items_ibfk_order_id FOREIGN KEY (order_id) REFERENCES orders (id)
SQL (0.005170)  ALTER TABLE offers ADD CONSTRAINT fk_offers_firm FOREIGN KEY (owner_firm_id) REFERENCES firms (id)
SQL (0.005755)  ALTER TABLE offers ADD CONSTRAINT fk_offers_owner FOREIGN KEY (owner_id) REFERENCES users (id)
SQL (0.005656)  ALTER TABLE offers ADD CONSTRAINT offers_ibfk_store_id FOREIGN KEY (store_id) REFERENCES stores (id)
SQL (0.005623)  ALTER TABLE offers ADD CONSTRAINT offers_ibfk_product_id FOREIGN KEY (product_id) REFERENCES products (id) ON DELETE CASCADE
SQL (0.005475)  ALTER TABLE orders ADD CONSTRAINT fk_orders_firm FOREIGN KEY (owner_firm_id) REFERENCES firms (id)
SQL (0.004984)  ALTER TABLE orders ADD CONSTRAINT fk_orders_owner FOREIGN KEY (owner_id) REFERENCES users (id)
SQL (0.005096)  ALTER TABLE orders ADD CONSTRAINT orders_ibfk_store_id FOREIGN KEY (store_id) REFERENCES stores (id)
SQL (0.006084)  ALTER TABLE pcheck_log_entries ADD CONSTRAINT fk_pcheck_req_log FOREIGN KEY (request_log_entry_id) REFERENCES request_log_entries (id)
SQL (0.005524)  ALTER TABLE permissions ADD CONSTRAINT fk_perm_target_firm FOREIGN KEY (target_owner_firm_id) REFERENCES firms (id)
SQL (0.005510)  ALTER TABLE permissions ADD CONSTRAINT fk_perm_target_owner FOREIGN KEY (target_owner_id) REFERENCES users (id)
SQL (0.005500)  ALTER TABLE permissions ADD CONSTRAINT permissions_ibfk_role_id FOREIGN KEY (role_id) REFERENCES roles (id) ON DELETE CASCADE
SQL (0.005030)  ALTER TABLE products ADD CONSTRAINT fk_products_firm FOREIGN KEY (owner_firm_id) REFERENCES firms (id)
SQL (0.005275)  ALTER TABLE products ADD CONSTRAINT fk_products_owner FOREIGN KEY (owner_id) REFERENCES users (id)
SQL (0.005399)  ALTER TABLE role_assignments ADD CONSTRAINT fk_role_assign_role FOREIGN KEY (default_firm_id) REFERENCES firms (id) ON DELETE CASCADE
SQL (0.005400)  ALTER TABLE role_assignments ADD CONSTRAINT fk_role_assign_user FOREIGN KEY (default_user_id) REFERENCES users (id) ON DELETE CASCADE
SQL (0.005273)  ALTER TABLE role_assignments ADD CONSTRAINT role_assignments_ibfk_role_id FOREIGN KEY (role_id) REFERENCES roles (id) ON DELETE CASCADE
SQL (0.005396)  ALTER TABLE role_assignments ADD CONSTRAINT role_assignments_ibfk_user_id FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE
SQL (0.005266)  ALTER TABLE roles ADD CONSTRAINT fk_roles_firm FOREIGN KEY (owner_firm_id) REFERENCES firms (id)
SQL (0.005720)  ALTER TABLE roles ADD CONSTRAINT fk_roles_owner FOREIGN KEY (owner_id) REFERENCES users (id)
SQL (0.005074)  ALTER TABLE stores ADD CONSTRAINT fk_stores_firm FOREIGN KEY (owner_firm_id) REFERENCES firms (id)
SQL (0.005145)  ALTER TABLE stores ADD CONSTRAINT fk_stores_owner FOREIGN KEY (owner_id) REFERENCES users (id)
SQL (0.005425)  ALTER TABLE users ADD CONSTRAINT users_ibfk_owner_firm_id FOREIGN KEY (owner_firm_id) REFERENCES firms (id)
SQL (0.003069)  CREATE TABLE schema_info (version integer)
SQL (0.002844)  INSERT INTO schema_info (version) VALUES(0)
SQL (0.002087)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'schema_info'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
SQL (0.001257)  UPDATE schema_info SET version = 14