Add version information to existing sqllite databse
Issue #49
new
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