All pastes #150177 Raw Edit

Mine

public text v1 · immutable
#150177 ·published 2006-08-26 16:37 UTC
rendered paste body
begin; \
CREATE TABLE IF NOT EXISTS Dir(Id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, Path TEXT UNIQUE, Parent INTEGER); \
CREATE TABLE IF NOT EXISTS File(Id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, Path TEXT, Size INTEGER, Parent INTEGER); \
CREATE TABLE IF NOT EXISTS Block(File INTEGER, Block INTEGER, Location INTEGER); \
CREATE TABLE IF NOT EXISTS DirXATTR(Id INTEGER, Name TEXT, Data BLOB); \
CREATE TABLE IF NOT EXISTS FileXATTR(Id INTEGER, Name TEXT, Data BLOB); \
CREATE TABLE IF NOT EXISTS BlockData(Id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, Data BLOB, DataChecksum INTEGER, Compressed INTEGER); \
commit; \