Skip to content
GitLab
This project is mirrored from https://:*****@gitlab.archlinux.org/archlinux/aurweb.git. Pull mirroring updated .
  1. 10 Aug, 2014 1 commit
  3. 15 Jul, 2014 1 commit
  5. 30 Jun, 2014 1 commit
  7. 25 Jun, 2014 3 commits
  9. 05 Jun, 2014 1 commit
  11. 06 May, 2014 1 commit
  13. 26 Apr, 2014 3 commits
  15. 18 Apr, 2014 1 commit
  17. 17 Apr, 2014 1 commit
  19. 05 Apr, 2014 3 commits
    • Lukas Fleischer's avatar
      Store comments on a per-package base basis · d35cf67f
      Lukas Fleischer authored 
      

Move comments from the Packages table to PackageBases. Sharing comments
makes sense since they almost always refer to a source package.

Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      d35cf67f
    • Lukas Fleischer's avatar
      Add provisional support for package bases · b7941073
      Lukas Fleischer authored 
      

This adds a PackageBases table to the database schema and moves the
following fields from the Packages table to PackageBases:

* CategoryID
* NumVotes
* OutOfDateTS
* SubmittedTS
* ModifiedTS
* SubmitterUID
* MaintainerUID

It also fixes all database accesses to comply with the new layout.

Having a separate PackageBases table is the first step to split package
support. By now, we create one PackageBases entry per package (where the
package base has the same name as the corresponding package). When
adding full support for split packages later, the package base name will
be derived from the pkgbase variable and a single package base will be
shared amongst all packages built from one source package.

Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      b7941073
    • Lukas Fleischer's avatar
      Fix database schema · 85629875
      Lukas Fleischer authored 
      Replace "ON SET NULL" with "ON DELETE SET NULL". Fixes a regression
introduced in commit fb7bde3a

 (Add support for anonymous comments,
2014-02-04).

Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      85629875
  21. 09 Feb, 2014 1 commit
  23. 06 Feb, 2014 1 commit
  25. 04 Feb, 2014 1 commit
  27. 28 Aug, 2013 1 commit
  29. 27 Aug, 2013 1 commit
  31. 22 Aug, 2013 3 commits
  33. 24 Mar, 2013 1 commit
  35. 21 Mar, 2013 1 commit
  37. 22 Oct, 2012 1 commit
  39. 24 Mar, 2012 1 commit
  41. 24 Oct, 2011 2 commits
  43. 25 Jun, 2011 1 commit
  45. 13 Apr, 2011 1 commit
  47. 12 Apr, 2011 1 commit
  49. 03 Apr, 2011 1 commit
    • Dan McGee's avatar
      Remove Dummy Package concept · 7c91c592
      Dan McGee authored 
      

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: default avatarDan McGee <dan@archlinux.org>
Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      7c91c592
  51. 04 Mar, 2011 2 commits
  53. 28 Feb, 2011 1 commit
  55. 27 Feb, 2011 3 commits