USE clientDatabase_23;

CREATE TABLE weeklyTips (
leadID MEDIUMINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
userID MEDIUMINT UNSIGNED NOT NULL,
userIP VARBINARY(16) NOT NULL, #NOTE: Using PHP function inet_pton/inet_ntop.
timeSubmitted TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
unread BOOL NOT NULL DEFAULT TRUE,
	comment TEXT
) ENGINE=MyISAM;
INSERT INTO tableIndex (name,description) VALUES ('seminarSignup','Seminar Sign Up');
INSERT INTO autoResponders (pageName,subject) VALUES ('seminarSignup','Thank You');