aboutsummaryrefslogtreecommitdiffstats
path: root/config/create-tables.sql
blob: 9f6d93ab69d9b018e415b2f6dec3f7b143f2cc9c (plain)
1
2
3
4
5
6
7
DROP TABLE IF EXISTS emails;
CREATE TABLE emails (
	sender TEXT NOT NULL PRIMARY KEY,
	count INTEGER DEFAULT 20,
	created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);