summaryrefslogtreecommitdiff
path: root/upgrading/2.3.0.txt
blob: d390d1c082f83ba4f98c595291eb7c989f520c86 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
1. Add registration and inactivity time stamps to the "Users" table:

----
ALTER TABLE Users
	ADD COLUMN RegistrationTS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	ADD COLUMN InactivityTS BIGINT NOT NULL DEFAULT 0;
----

2. Add fields to store the total number of TUs and the quorum to the
   "TU_VoteInfo" table:

----
ALTER TABLE TU_VoteInfo
	ADD COLUMN ActiveTUs tinyint(3) unsigned NOT NULL default '0',
	ADD COLUMN Quorum decimal(2, 2) unsigned NOT NULL;
----

3. Add a "fonts" category:

----
INSERT INTO PackageCategories (Category) VALUES ('fonts');
----