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");";