How can I use SQL scripts in a database project with the System.Data.SQLite data provider?

I have a project where I am trying to use SQLite through System.Data.SQLite . In my attempts to keep the database under version control, I went ahead and created a database project in my VS2008. Sounds okay, right?

I created my first create script table and tried to run it by right clicking-> Run on script and I get this error message:

This operation is not supported by the provider or data source you are using.

Does anyone know if there is an automatic way to use scripts that are part of a database project for SQLite databases referenced by databases using the provider provided by the System.Data.SQLite installation?

I've tried all the options I can think of trying to run the script using the default Run or Run as default commands. Here the script in it is the most verbose and probably the wrong form:

USE Characters
GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'Skills')
  BEGIN
    DROP Table Skills
  END
GO

CREATE TABLE Skills
(
   SkillID INTEGER PRIMARY KEY AUTOINCREMENT,
   SkillName TEXT,
   Description TEXT
)
GO

      

        
        
        
      

    

Please note that this is my first attempt at using a database, and also the first time I have ever touched SQLite. In my attempts to make it work, I stripped everything and everything except the CREATE TABLE command.

UPDATE: Ok, as Robert Harvey points out below, this looks like a SQL Server Stored Procedure. I went into Server Explorer and used my connection (from the Database project) to do what he suggested to create the table. I can generate SQL to create the table and it turns out like this:

CREATE TABLE [Skills] (
    [SkillID] integer PRIMARY KEY NOT NULL,
    [SkillName] text NOT NULL,
    [Description] text NOT NULL
);

      

        
        
        
      

    

I can easily copy this and add it to the project (or add it to another project that handles the rest of my data access), but is there anyway to automate this on build? I suppose since SQLite is single file in this case, I could also keep an embedded versioned database.

Thoughts? Best practices for this instance?

UPDATE: I think since I am planning on using Fluent NHibernate I can just use the auto-resilient model to keep my database sniffed and control the source code efficiently. Thoughts? Traps? I think I'll have to separately add the original inserts to the original block, but it should work.