wiki:DatabaseChanges

Version 9 (modified by dima42, 6 years ago) (diff)

--

  • The current development of milestone 1.4 needs the following changes to the database:
/* Ticket #1695 */
CREATE TABLE groups_related(id int(11) PRIMARY KEY auto_increment, group_id int(11), related_id int(11), addedby int(11), deletedby int(11), ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);


/* Ticket #1823 */
INSERT INTO preferences(codeName, codeDescription, Description, DefaultValue, PossibleValues, Status) VALUES ('ShowMyGroupsTopicsOnly', 'ShowMyGroupsTopicsOnlyDes', 'ShowMyGroupsTopicsOnly description', 'No', 'No;Yes', 'Normal');



/* Ticket #1763 */

ALTER TABLE `preferences` ADD `position` INT NOT NULL AFTER `id`;

/* In case the implementation changes sometime keep language at the top */
UPDATE preferences SET position = 10 WHERE Id = 1;

/* Move profile visits to public profile */
/* Unfortunately public profile isn't stored in preferences */
UPDATE preferences SET position = 21 WHERE Id = 23;

/* Now group the advanced function and the spam folder */
UPDATE preferences SET position = 30 WHERE Id = 7;
UPDATE preferences SET position = 35 WHERE Id = 5;

/* All forum related stuff */
UPDATE preferences SET position = 40 WHERE Id = 12;
UPDATE preferences SET position = 45 WHERE Id = 25;

/* All notification and newsletter stuff */
UPDATE preferences SET position = 50 WHERE Id = 8;
UPDATE preferences SET position = 55 WHERE Id = 13;

/* All time related stuff */
UPDATE preferences SET position = 60 WHERE Id = 17;
UPDATE preferences SET position = 65 WHERE Id = 21;

/* All inactive items at the end in random order */
/* Just in case someone activates them */
UPDATE preferences SET position = 100 WHERE status = 'Inactive';


Planned changes (not yet announced "officially") for milestone 1.5:

/* Ticket #1858 */
ALTER TABLE `broadcast` CHANGE `Type` `Type` ENUM( 'Normal', 'RemindToLog', 'Specific' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Normal' COMMENT 'Normal or Reinder to logs in';

/* Ticket #1892 */
INSERT INTO `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.

Only one level (10) needed (as there''s only one treasurer) and scope should always be "ALL".');

ALTER 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`;