SQLite Forum

SQLDIFF to Import
Login
I'm using sqldiff to produce the following in Windows

```
>sqldiff NULL LTNNetwork.db3 --schema
CREATE TABLE [NetworkList](
  [GameID] INTEGER NOT NULL,
  [NetworkID] INTEGER NOT NULL);
CREATE TABLE [TrainStyleList](
  [StyleID] INTEGER REFERENCES [tblSavedGames]([GameID]) ON DELETE CASCADE,
  [Title] CHAR);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE [tblSavedGames](
  [GameID] INTEGER PRIMARY KEY AUTOINCREMENT,
  [GameName] CHAR,
  [Description] CHAR);
```

I'm taking this file and putting it into a resource file to be build in to have a "new file" created based on the current schema of the database.  For what this program does, there is no concern for future proofing or upgrades or whatever as the program will probably only ever be run by me and recompiled when I blow my system away.  I just want to make sure that after a reinstall of Windows, when I run the app, the DB is created on the fly, and is completely empty.

The issue I have is the **CREATE TABLE sqlite_sequence(name,seq);** statement.  Do I need to programaticaly filter out statements like this?  Basically read line by line each statement and ignore the **CREATE TABLE sqlite_ ** entries that may come along?  When running, I'm getting an (expected) error stating that I can't create due to the reserved wording.