markzz/aurweb.git/support/schema/aur-schema.sql, branch v1.9.1

Fix performance issues with new PackageDepends lookups

2011-06-25T09:29:52Z

We do a lookup by DepName in the package details view, but I made the silly mistake of forgetting this index addition in the upgrade steps. Lukas: Fix numbering in "UPGRADING". Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Remove "NewPkgNotify" column from "Users" table.

2011-04-13T10:22:35Z

We do not require this column anymore. New package notifications are no longer supported. Signed-off-by: Lukas Fleischer

Fix syntax error in "CREATE TABLE" statement in the SQL schema.

2011-04-12T11:02:54Z

Regression introduced in commit 7c91c592458b7532806ef75fe09146f82f085f3b. 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

Ensure users can be deleted when foreign keys are present

2011-03-04T09:29:14Z

This change is necessary to prevent this: mysql> delete from Users where ID = 112; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`aur`.`Packages`, CONSTRAINT `Packages_ibfk_2` FOREIGN KEY (`SubmitterUID`) REFERENCES `Users` (`ID`) ON DELETE NO ACTION) As a bonus, due to foreign keys, orphaning of packages will be automatic. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Allow DB connection values to come from the environment

2011-03-04T09:29:14Z

Stop hardcoding everything everywhere for those of us that don't use the localhost/aur/aur/AUR setup. Also allow for the dummy data to be created in the reload script if it does not exist. Finally, remove two assumptions that the AUR database already exists. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Specify utf8 in database schema.

2011-02-28T08:38:14Z

Signed-off-by: Loui Chang Signed-off-by: Lukas Fleischer

Add "ENGINE = InnoDB" to "CREATE TABLE" statements in the SQL schema.

2011-02-27T18:46:29Z

Signed-off-by: Lukas Fleischer

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

2011-02-27T18:46:19Z

Signed-off-by: Lukas Fleischer

Define "PackageComments.DelUsersID" as "NULL".

2011-02-27T15:20:02Z

Signed-off-by: Lukas Fleischer