Add version information to existing sqllite databse

[AaronG]

I have an already existing sql database that I want to start doing migrations on with Goose. I created a sql migration table with a schema identical to the existing databases.

How do I setup the versioning table so Goose recognizes that its up to date. I tried doing

CREATE TABLE goose_db_version ( id INT4 IDENTITY(1,1) NOT NULL PRIMARY KEY, version_id INT8 NOT NULL, is_applied BOOL NOT NULL, tstamp TIMESTAMP NOT NULL DEFAULT SYSDATE );

INSERT INTO goose_db_version (id, version_id, is_applied) VALUES (0, 1, 1);

but that didn't help