rendered paste body L"CREATE TABLE IF NOT EXISTS packages"
L"("
L"_id INTEGER PRIMARY KEY AUTOINCREMENT,"
L"_created TEXT(32) NOT NULL,"
L"_curseId TEXT(32) NOT NULL,"
L"_feedUrl TEXT(256) NOT NULL,"
L"_name TEXT(128) NOT NULL,"
L"_game TEXT(128) NOT NULL,"
L"_url TEXT(256) NOT NULL,"
L"_releaseName TEXT(64) NOT NULL,"
L"_releaseDate TEXT(32) NOT NULL,"
L"_summary TEXT(512) NOT NULL,"
L"_size INTEGER NOT NULL DEFAULT '0',"
L"UNIQUE (_feedUrl),"
L"UNIQUE (_game, _name)"
L");"
L"CREATE TABLE IF NOT EXISTS pkgdirs"
L"("
L"_pkgid INTEGER NOT NULL,"
L"_dirid INTEGER NOT NULL"
L");"
L"CREATE TABLE IF NOT EXISTS directories"
L"("
L"_id INTEGER PRIMARY KEY AUTOINCREMENT,"
L"_path TEXT(512) NOT NULL,"
L"_refc INTEGER UNSIGNED NOT NULL DEFAULT 1,"
L"UNIQUE (_path)"
L");"
L"CREATE TABLE IF NOT EXISTS pkgfiles"
L"("
L"_pkgid INTEGER NOT NULL,"
L"_fileid INTEGER NOT NULL"
L");"
L"CREATE TABLE IF NOT EXISTS files"
L"("
L"_id INTEGER PRIMARY KEY AUTOINCREMENT,"
L"_path TEXT(512) NOT NULL,"
L"_moddate TEXT(64) NOT NULL,"
L"_refc INTEGER UNSIGNED NOT NULL DEFAULT 1,"
L"UNIQUE(_path)"
L");"
L"CREATE TABLE IF NOT EXISTS authors"
L"("
L"_id INTEGER PRIMARY KEY AUTOINCREMENT,"
L"_pkgid INTEGER NOT NULL,"
L"_name TEXT(128) NOT NULL,"
L"_url TEXT(512) NOT NULL,"
L"_email TEXT(256) NOT NULL"
L");";