markzz/aurweb.git/support/schema/aur-schema.sql, branch 1.8.1aurweb working repositoryhttps://git.markzz.net/markzz/aurweb.git/atom/support/schema/aur-schema.sql?h=1.8.12011-03-04T09:29:14ZEnsure users can be deleted when foreign keys are present2011-03-04T09:29:14ZDan McGeedan@archlinux.org2011-03-01T16:21:06Zurn:sha1:f9eba12312fc6a1758f7f1051a8f30b435175f94
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 <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Allow DB connection values to come from the environment2011-03-04T09:29:14ZDan McGeedan@archlinux.org2011-03-01T15:59:03Zurn:sha1:abd41bbb51ea2340bd06648cc0cd5b9144cce91e
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 <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Specify utf8 in database schema.2011-02-28T08:38:14ZLoui Changlouipc.ist@gmail.com2011-02-28T01:38:45Zurn:sha1:c638a89314422ab98e91c585e24267bf8a1f79c3
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add "ENGINE = InnoDB" to "CREATE TABLE" statements in the SQL schema.2011-02-27T18:46:29ZLukas Fleischerarchlinux@cryptocrack.de2011-02-27T16:17:57Zurn:sha1:816a0cf8d7b2365d38699b72322c785b338350f1
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".2011-02-27T18:46:19ZLukas Fleischerarchlinux@cryptocrack.de2011-02-27T16:12:43Zurn:sha1:1e3fa38de5f940fef474fc3961c70b357b976308
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Define "PackageComments.DelUsersID" as "NULL".2011-02-27T15:20:02ZLukas Fleischerarchlinux@cryptocrack.de2011-02-27T15:16:40Zurn:sha1:40ccf77ca0c6745d8b75e925e915cdf51a924312
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add missing foreign keys and constraints to the DB.2011-02-26T20:11:25ZLukas Fleischerarchlinux@cryptocrack.de2011-02-26T20:11:25Zurn:sha1:ac632980c3789cd99a80d61861b8820ddad14704
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Use VARCHAR instead of CHAR in "PackageBlacklist" table.2011-02-11T13:43:24ZLukas Fleischerarchlinux@cryptocrack.de2011-02-10T08:08:11Zurn:sha1:59055776943f4c6ef0865cefdb82b5a40d24e95e
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add a package name blacklist.2011-02-11T13:43:22ZLukas Fleischerarchlinux@cryptocrack.de2011-02-02T17:03:09Zurn:sha1:b69f548065e78d14afcdc91548d73539762f8d93
Can be used to blacklist package names for normal users. TUs and
developers are not affected. This is especially useful if used together
with a cron job that updates the blacklist periodically, e.g. to reject
packages which are available in the binary repos (FS#12902).
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Remove unused fulltext index from "Packages" table.2011-02-10T07:17:53ZLukas Fleischerarchlinux@cryptocrack.de2011-02-09T08:57:25Zurn:sha1:881bfcced4b1b0906d7ef57af55f4e7201ad2474
Drop fulltext indexes, which prevent the use of InnoDB, from "Packages"
table. All search routines use "LIKE" patterns, so fulltext search has
actually never been used.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>