View Single Post
  #4  
Old 30th December 2013, 09:15
KrackerMan's Avatar
KrackerMan KrackerMan is offline
Senior Member
 
Join Date: Aug 2010
United States
Posts: 109
Default
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';
Reply With Quote
The Following User Says Thank You to KrackerMan For This Useful Post:
hatijahat (2nd January 2014)