markzz/aurweb.git/support/schema, branch 1.8.2

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

gendummydata.py: Do not touch output file until we need it.

2011-03-30T08:27:23Z

Ensures there's no leftover (empty) file if something during initialization fails. 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

Use a single transaction to write dummy data

2011-03-04T09:29:13Z

This is immensely faster when using InnoDB since we don't need to sync after each and every INSERT statement. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Remove database recreation code from "support/schema/reloadtestdb.sh".

2011-02-28T08:45:29Z

Database is being dropped and recreated in the schema, so there's no need to do this in "reloadtestdb.sh" as well. 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

Fix some minor bugs in "support/schema/gendummydata.py".

2011-02-27T18:46:30Z

The dummy data generation script used to create wrong package IDs for both "PackageVotes" and "PackageDepends" tables which led to errors when reloading the test data (constraints failed). This is fixed by no longer creating entries with zero ("0") package IDs. 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