CREATE TABLE `$table_warnings` (
`warnid` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 50 ) NOT NULL ,
`dateline` BIGINT( 30 ) NOT NULL ,
`status` VARCHAR( 8 ) NOT NULL ,
`post` VARCHAR( 36 ) NOT NULL ,
PRIMARY KEY ( `warnid` )
);

ALTER TABLE `$table_settings` ADD `warnstatus` char(3) NOT NULL default 'on';
ALTER TABLE `$table_settings` ADD `displaywarns` char(3) NOT NULL default 'on';
ALTER TABLE `$table_settings` ADD `warnstatuses` TEXT NOT NULL;
ALTER TABLE `$table_settings` ADD `moneywarn` CHAR(5) NOT NULL default '0';