All pastes #625441 Raw Edit

Mine

public text v1 · immutable
·published 2007-07-18 22:59 UTC
rendered paste body
{
	0: [
		"CREATE TABLE settings ('name' VARCHAR NOT NULL, 'val' VARCHAR NOT NULL)",
		"INSERT INTO settings VALUES ('version', '4')",
		"CREATE TABLE log ('id' INTEGER PRIMARY KEY AUTOINCREMENT, 'tm' INT NOT NULL, 'path' VARCHAR NOT NULL, 'event' CHAR(1) NOT NULL, 'sz' INT NOT NULL, 'uid' INT NOT NULL default 0)",
		"CREATE INDEX logtm ON log ('tm')",
		"CREATE INDEX loguid ON log ('uid')",
		"CREATE INDEX logevent ON log ('event')",
		"CREATE INDEX logpath ON log ('path')",
		"CREATE TABLE sig ('id' INTEGER PRIMARY KEY AUTOINCREMENT, 'path' VARCHAR NOT NULL, 'hash' VARCHAR NOT NULL)",
		"CREATE INDEX sigpath ON sig ('path')",
		"CREATE TABLE pending ('tm' INT NOT NULL, 'path' VARCHAR NOT NULL, 'event' CHAR(1) NOT NULL)",
		"CREATE INDEX pendingpath ON pending ('path')"],
	
	1: [
		"CREATE INDEX logtm ON log ('tm')",
		"CREATE INDEX logevent ON log ('event')",
		"CREATE INDEX logpath ON log ('path')",
		"UPDATE settings SET val='2' WHERE name='version'"],
	
	2: [
		"CREATE TABLE sig ('id' INTEGER PRIMARY KEY AUTOINCREMENT, 'path' VARCHAR NOT NULL, 'hash' VARCHAR NOT NULL)",
		"CREATE INDEX sigpath ON sig ('path')",
		"CREATE TABLE pending ('tm' INT NOT NULL, 'path' VARCHAR NOT NULL, 'event' CHAR(1) NOT NULL)",
		"CREATE INDEX pendingpath ON pending ('path')",
		"UPDATE settings SET val='3' WHERE name='version'"],
	
	3: [
		"ALTER TABLE log ADD 'uid' INT NOT NULL default 0",
		"CREATE INDEX loguid ON log ('uid')",
		"UPDATE settings SET val='4' WHERE name='version'"]}