| Age | Commit message (Collapse) | Author | Files | Lines | |
|---|---|---|---|---|---|
| 2009-06-18 | Add multicolumn indexes on votes and notifications tables | Dan McGee | 1 | -1/+2 | |
| To put a long story short, when we do joins on these tables in our pkg_search_page() function, we always join on both the user ID and package ID columns. By creating multicolumn indices, we can always get the exact row we are looking for in the table. The benefits of adding a unique index should also speak for themselves, as we previously did not have this on either of these tables. This is part one of a two-part series to address the fact that this query was often showing up in our slow query logs. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com> | |||||
| 2008-03-27 | Remove references to AURMaintainerUID | Callan Barrett | 1 | -4/+1 | |
| This (should) get rid of anything to do with the unused column AURMaintainerUID in the scripts and schema files Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> Signed-off-by: Simo Leone <simo@archlinux.org> | |||||
| 2008-03-23 | Make all references to AUR database consistent | Loui Chang | 1 | -3/+3 | |
| Signed-off-by: Loui Chang <louipc.ist@gmail.com> Signed-off-by: Simo Leone <simo@archlinux.org> | |||||
| 2008-01-20 | Bug in uploading PKGBUILDs and aur schema | Callan Barrett | 1 | -2/+2 | |
| This fixes a bug where TUs and devs couldn't upload packages because the query would have an extra column in it to mark the pkgbuild safe automatically, guessing it got missed when the safe flags were removed. Also fixes a screw up I made with the schema file when I added the tables for the voting app. Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> | |||||
| 2008-01-20 | Add support for variable length votes in voting application | Callan Barrett | 1 | -0/+1 | |
| Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> | |||||
| 2008-01-20 | AUR Voting Application | Callan Barrett | 1 | -0/+21 | |
| Added support for TU voting through AUR Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> | |||||
| 2008-01-20 | Fix for safe-removal. | eliott | 1 | -2/+0 | |
| 2008-01-20 | Hand diff of simo's patch to remove flag safe functionality. | eliott | 1 | -2/+0 | |
| Simo's original commit text: The idea of safe flagging is unclear, poorly named, misunderstood, and not even used. At the time this patch was created, less than a third of the packages in unsupported were flagged safe, and less than a tenth of users knew how to interpret it. The safe flag has been replaced by a disclaimer on the main page. | |||||
| 2008-01-20 | Added AurJSON code. | eliott | 1 | -0/+1 | |
| Added a JSON interface to the aur. This should make it easier for developers to integrate command line utilities and poll against the AUR itself. | |||||
| 2007-09-17 | committed old schema change from old version | pjmattal | 1 | -1/+1 | |
| 2007-02-01 | Added the DepCondition field to the table PackageDepends. | dsa | 1 | -0/+1 | |
| 2006-08-22 | Applied license patch from dsa (closes #4085). | swiergot | 1 | -0/+1 | |
| 2006-08-10 | of course, max length for Description must be 255, not 256 | pjmattal | 1 | -1/+1 | |
| 2006-08-03 | upped length on Description in Package table to 256 from 128 | pjmattal | 1 | -1/+1 | |
| as per discussions with simo and dsa | |||||
| 2005-07-29 | committed schema change for swiergot's checking patch | pjmattal | 1 | -0/+4 | |
| 2005-06-08 | SQL CHANGES: New table CommentNotify with fields: | simo | 1 | -0/+9 | |
| PkgID UserID This implements emailing comment notifications, including a user option to enable/disable it on the package page. It uses php's mail() function to do it and sends to everyone on the notify list as BCC. This needs some more testing before public consumption. | |||||
| 2005-05-08 | Added ModifiedTS to Packages database | simo | 1 | -0/+1 | |
| Implemented ModifiedTS such that: -ModifiedTS changed ONLY when package updated -SubmittedTS changed ONLY when new package Also made DummyPkg fixups in tupkgupdate | |||||
| 2005-04-09 | changed db name from AUR to aur | pjmattal | 1 | -3/+3 | |
| moved db config for webapp into the config file | |||||
| 2005-04-06 | many changes in prep for launch | pjmattal | 1 | -5/+5 | |
| new doc page added changed AUR to community lower-cased unsupported fixed half of the bug with changing categories: categories now can't be changed for packages in community however they can still be changed out from under maintainers by joe users for unsupported packages debugged problem with package details not found when unsupported uploads were with Category 0 (changed default to 19) | |||||
| 2005-03-20 | added comments/category editing, and closed #2280 | eric | 1 | -0/+2 | |
| 2005-03-06 | started working on pkgedit for comments | eric | 1 | -0/+2 | |
| 2005-03-05 | started working on package comments | eric | 1 | -3/+3 | |
| 2005-01-24 | fixed dummy-data, schema, gendummydata to use md5 passwords | eric | 1 | -3/+3 | |
| 2004-12-15 | renumber none to one, hide none from category/location dropdowns | pjmattal | 1 | -9/+9 | |
| 2004-12-15 | removed my url path and fs path from the packages table | jchu | 1 | -2/+0 | |
| 2004-12-15 | tweaks to package functions and schema | pjmattal | 1 | -2/+8 | |
| 2004-12-15 | added a url path and fs path to the packages table | jchu | 1 | -0/+2 | |
| 2004-12-15 | added a url path and fs path to the contents and took out filename | jchu | 1 | -3/+2 | |
| 2004-12-06 | fixed the aur schema, added use AUR; line to make it | pjmattal | 1 | -0/+1 | |
| re-find the db after drop and cr-create | |||||
| 2004-09-20 | added upload comments/history, still need to finish the actual db calls | eric | 1 | -0/+13 | |
| 2004-07-02 | still working on pkgsearch.php::do_Details | eric | 1 | -1/+18 | |
| 2004-06-29 | yet another schema change | eric | 1 | -3/+6 | |
| 2004-06-28 | re-working pkgsearch, NumVotes add to Packages table | eric | 1 | -0/+2 | |
| 2004-06-23 | added dummy data for testing | eric | 1 | -0/+3 | |
| 2004-06-23 | account adding/editing is working | eric | 1 | -1/+5 | |
| 2004-06-22 | pulled out account functions into separate include file | eric | 1 | -2/+2 | |
| 2004-06-21 | working on the accounts stuff | eric | 1 | -0/+2 | |
| 2004-06-19 | started working on the login | eric | 1 | -2/+3 | |
| 2004-06-18 | finishing touches on genpopo, started playing with _real_ PHP code and svn ↵ | eric | 1 | -0/+1 | |
| keywords | |||||
| 2004-06-13 | Schema file now loads properly into MySQL. | eric | 1 | -45/+49 | |
| 2004-06-13 | initial import | eric | 1 | -0/+139 | |
 |
index : aur | |
| Main repo is at http://projects.archlinux.org/aur.git/ | Florian Pritz |
| summaryrefslogtreecommitdiffstats |