private static void MakeDB()
{
ExecuteNonQuery(@"CREATE TABLE IF NOT EXISTS [VERSION] ([Version] INTEGER NOT NULL); INSERT INTO VERSION (version) VALUES (@Version);", "version", DBVersion);
ExecuteNonQuery(@"
CREATE TABLE IF NOT EXISTS [DIR] (
[DirId] INTEGER PRIMARY KEY NOT NULL,
[ParentDirId] INTEGER NULL,
[name] NVARCHAR(300) NOT NULL,
[fullname] NVARCHAR(300) NOT NULL,
[expanded] BOOLEAN DEFAULT 1 NOT NULL,
[found] BOOLEAN DEFAULT 1,
[RomTotal] INTEGER NULL,
[RomGot] iNTEGER NULL,
[RomNoDump] INTEGER NULL
);
");
RvDat.MakeDB();
RvGame.MakeDB();
RvRom.MakeDB();
RvFile.MakeDB();
}
