Plume/migrations/sqlite/2018-04-23-111655_create_blog_authors/up.sql

-- Your SQL goes here
CREATE TABLE blog_authors (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    blog_id INTEGER REFERENCES blogs(id) ON DELETE CASCADE NOT NULL,
    author_id INTEGER REFERENCES users(id) ON DELETE CASCADE NOT NULL,
    is_owner BOOLEAN NOT NULL DEFAULT 'f'
)
Add relation between blogs and authors 2018-04-23 13:27:27 +02:00			`-- Your SQL goes here`
			`CREATE TABLE blog_authors (`
align types between sqlite & postgres this one's achieved by adding "NOT NULL" at the correct position in SQLite's create tables. 2018-09-17 11:08:58 +02:00			`id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,`
Add relation between blogs and authors 2018-04-23 13:27:27 +02:00			`blog_id INTEGER REFERENCES blogs(id) ON DELETE CASCADE NOT NULL,`
			`author_id INTEGER REFERENCES users(id) ON DELETE CASCADE NOT NULL,`
			`is_owner BOOLEAN NOT NULL DEFAULT 'f'`
			`)`