aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Leis <explodes@users.noreply.github.com>2018-02-05 21:42:01 -0800
committerGitHub <noreply@github.com>2018-02-05 21:42:01 -0800
commite33a38751e76c65cfec681fd5c739043fd9a21bb (patch)
treef3920c8603743f8dccf4003618fae2520b350197
parent5e1e01b7560c8b7dd356e756d4e0a09b5a044064 (diff)
downloadmigrations-go-e33a38751e76c65cfec681fd5c739043fd9a21bb.zip
migrations-go-e33a38751e76c65cfec681fd5c739043fd9a21bb.tar.gz
[sample] correct sqlite sqlHEADmaster
-rw-r--r--sample/sample.go8
1 files changed, 4 insertions, 4 deletions
diff --git a/sample/sample.go b/sample/sample.go
index 8e23371..075ff38 100644
--- a/sample/sample.go
+++ b/sample/sample.go
@@ -36,21 +36,21 @@ const (
DowngradeNotSupported = ``
UpgradeInitial = `
CREATE TABLE users (
- id BIGSERIAL PRIMARY KEY,
+ id INTEGER PRIMARY KEY,
username VARCHAR(64),
email VARCHAR(128)
);
CREATE TABLE post (
- id BIGSERIAL PRIMARY KEY,
- user_id INT NOT NULL,
+ id INTEGER PRIMARY KEY,
+ user_id INTEGER NOT NULL,
content TEXT NOT NULL,
FOREIGN KEY (user_id) REFERENCES users (id)
);
`
UpgradeImages = `
CREATE TABLE images (
- id BIGSERIAL PRIMARY KEY,
+ id INTEGER PRIMARY KEY,
url TEXT
)
`