markzz/aurweb.git/UPGRADING, branch 1.8.2

Release 1.8.2.

2011-04-10T13:38:28Z

Signed-off-by: Lukas Fleischer

Remove File_Find PEAR module from code base.

2011-04-05T09:31:12Z

We removed the code depending on this a long time ago - drop it and add some note to "UPGRADING". Signed-off-by: Lukas Fleischer

Remove Dummy Package concept

2011-04-03T20:59:32Z

Instead, we just store dependencies directly in the PackageDepends table. Since we don't use this info anywhere besides the package details page, there is little value in precalculating what is in the AUR vs. what is not. An upgrade path is provided via several SQL statements in the UPGRADING document. There should be no user-visible change from this, but the DB schema gets a bit more sane and we no longer have loads of junk packages in our tables that are never shown to the end user. This should also help the MySQL query planner in several cases as we no longer have to be careful to exclude dummy packages on every query. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Always set ModifiedTS including new packages

2011-04-03T20:59:31Z

Set it equal to the SubmittedTS field, which will be our indication the package is new when we show the logo on the front page of the AUR. This results in the ability to remove the use of the unindexable GREATEST() function from the AUR code everywhere we had to use it before to handle the 0 timestamp case. Note that there is no race condition here in calling UNIX_TIMESTAMP() twice- it always returns the time at the beginning of statment execution: mysql> select unix_timestamp(), sleep(2), unix_timestamp(); +------------------+----------+------------------+ | unix_timestamp() | sleep(2) | unix_timestamp() | +------------------+----------+------------------+ | 1300851746 | 0 | 1300851746 | +------------------+----------+------------------+ 1 row in set (2.00 sec) Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Add note on merging "web/lib/config.inc.proto" to "UPGRADING".

2011-02-27T18:46:30Z

Signed-off-by: Lukas Fleischer

Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".

2011-02-27T18:46:19Z

Signed-off-by: Lukas Fleischer

Add note on upgrading from MyISAM to InnoDB to "UPGRADING".

2011-02-27T15:29:40Z

Signed-off-by: Lukas Fleischer

Define "PackageComments.DelUsersID" as "NULL".

2011-02-27T15:20:02Z

Signed-off-by: Lukas Fleischer

Add missing foreign keys and constraints to the DB.

2011-02-26T20:11:25Z

Signed-off-by: Lukas Fleischer

Add note on InnoDB compatibility to "UPGRADING".

2011-02-15T07:29:28Z

Signed-off-by: Lukas Fleischer