Blame

Date:
Message:
Allow management of mailboxes from an account This introduces a new type, called account. An account can manage domains and, in turn, mailboxes.
Actions:
History | Blob | Raw File
 1 901f37ea 2022-02-27 o CREATE TABLE accounts (

 2 901f37ea 2022-02-27 o 	id INTEGER PRIMARY KEY AUTOINCREMENT,

 3 901f37ea 2022-02-27 o 	name TEXT NOT NULL,

 4 901f37ea 2022-02-27 o 	username TEXT NOT NULL,

 5 901f37ea 2022-02-27 o 	password TEXT NOT NULL

 6 901f37ea 2022-02-27 o );

 7 901f37ea 2022-02-27 o 

 8 901f37ea 2022-02-27 o CREATE TABLE domains (

 9 901f37ea 2022-02-27 o 	id INTEGER PRIMARY KEY AUTOINCREMENT,

10 901f37ea 2022-02-27 o 	account_id INTEGER NOT NULL,

11 901f37ea 2022-02-27 o 	domain VARCHAR(255) NOT NULL

12 901f37ea 2022-02-27 o );

13 901f37ea 2022-02-27 o 

14 901f37ea 2022-02-27 o CREATE TABLE mailboxes (

15 901f37ea 2022-02-27 o 	id INTEGER PRIMARY KEY AUTOINCREMENT,

16 901f37ea 2022-02-27 o 	address VARCHAR(255) NOT NULL,

17 901f37ea 2022-02-27 o 	password VARCHAR(255) NOT NULL,

18 901f37ea 2022-02-27 o 	domain_id INTEGER NOT NULL

19 901f37ea 2022-02-27 o );

20 901f37ea 2022-02-27 o 

21 1aed0ca2 2022-02-26 o CREATE TABLE aliases (

22 1aed0ca2 2022-02-26 o 	id INTEGER PRIMARY KEY AUTOINCREMENT,

23 1aed0ca2 2022-02-26 o 	recipient VARCHAR(255) NOT NULL,

24 1aed0ca2 2022-02-26 o 	destination VARCHAR(255) NOT NULL

25 1aed0ca2 2022-02-26 o );