D1Q4f101

1CREATE TABLE if not exists ddt
2(
3    ddtID int PRIMARY KEY NOT NULL AUTO_INCREMENT,
4    userID int NOT NULL,
5    ddtFrom text(50) NOT NULL COMMENT 'From address or part off, can match start or end only',
6    CONSTRAINT ddt_users_userID_fk FOREIGN KEY (ddtID) REFERENCES users (userID)
7);
8CREATE UNIQUE INDEX ddt_ddtID_uindex ON ddt (ddtID); 
9     
10|ddtID |UserID |ddtFrom|
11|1     |1      |@example.com|
12|2     |1      |noreply@| 
13     
14john@example.com
15jo@example.co.uk
16noreply@theendoftheworld.org
17hello@kitty.tv