Members Warning SQL

[BamBam0077]

Code Select Expand


CREATE TABLE `member_warnings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`memberid` int(10) unsigned NOT NULL DEFAULT '1',
`warning_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`active_warning` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`strikes_against` int(10) unsigned NOT NULL DEFAULT '0',
`expiry_timeout` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`reasons` blob,
`notes` blob,
`warned_by` blob,
PRIMARY KEY (`id`),
KEY `memberid` (`memberid`),
KEY `expired_warning` (`expiry_timeout`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


hope this helps out yo!