wiki:DatabaseChanges

Version 2 (modified by mahouni, 6 years ago) (diff)

--

  • The current development of milestone 1.4 needs the following changes to the database:
/* Ticket #1695
CREATE TABLE groups_subgroups(id int(11) PRIMARY KEY auto_increment, group_id int(11), subgroup_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:

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';

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.

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