icytv/migrations/004_email_subscribe.sql

-- Up
CREATE TABLE emailsub (
	id INTEGER PRIMARY KEY,
	unsubkey TEXT NOT NULL,
  activatekey TEXT NOT NULL,
	email TEXT NOT NULL,
	uuid TEXT NOT NULL,
  active INTEGER NOT NULL,
  created_at INTEGER NOT NULL
);

-- Down
DROP TABLE emailsub;