Code:
CREATE TABLE `funds` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`cash` DECIMAL(8,2) NOT NULL DEFAULT '0.00',
`user` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`added` INT(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Quote:
ALTER TABLE users ADD `donoruntil` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE users ADD `donated` DECIMAL(8,2) NOT NULL DEFAULT '0.00';
ALTER TABLE users ADD `total_donated` DECIMAL(8,2) NOT NULL DEFAULT '0.00';
|