Changes between Version 6 and Version 7 of DatabaseChanges


Ignore:
Timestamp:
Feb 12, 2013, 11:49:23 AM (6 years ago)
Author:
jsfan
Comment:

added new columns to params table

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseChanges

    v6 v7  
    6161
    6262/* Ticket #1892 */
    63 INSERT INTO `bewelcome`.`rights` (`id`, `created`, `Name`, `Description`) VALUES (NULL, CURRENT_TIMESTAMP, 'Treasurer', 'This right enables the treasurer to keep the donations bar shown on /donate to be (more) accurate by adding bank tansfers to the database.
     63INSERT INTO `bewelcome`.`rights` (`id`, `created`, `Name`, `Description`) VALUES (NULL, CURRENT_TIMESTAMP, 'Treasurer', 'This right enables the treasurer to keep the donations bar shown on /donate to be (more) accurate by adding bank transfers to the database.
    6464
    6565Only one level (10) needed (as there''s only one treasurer) and scope should always be "ALL".');
     66
     67ALTER TABLE `params`  ADD `neededperyear` INT NOT NULL DEFAULT '1260' COMMENT 'Amount needed per year as shown during the donation campaign.' AFTER `ToggleDonateBar`,  ADD `campaignstartdate` DATE NOT NULL DEFAULT '2012-10-11' COMMENT 'The date the donation campaign started, used to gather the donated amount in this campaign.' AFTER `neededperyear`
    6668}}}
    6769
    68