CREATE TABLE IF NOT EXISTS TMDALists
(
        ListName VARCHAR(20) NOT NULL,
        Address TEXT NOT NULL,
        Action VARCHAR(40),
        OutAction VARCHAR(40),
        Comment TEXT,
        Source ENUM('USER','BARE APPEND','CONFIRM','PENDING') DEFAULT 'USER',
        ActivityDate TIMESTAMP,
        PRIMARY KEY (ListName, Address(80))
);
