summaryrefslogtreecommitdiff
path: root/support/schema/aur-schema.sql
AgeCommit message (Collapse)Author
2008-03-27Remove references to AURMaintainerUIDCallan Barrett
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-23Make all references to AUR database consistentLoui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com> Signed-off-by: Simo Leone <simo@archlinux.org>
2008-01-20Bug in uploading PKGBUILDs and aur schemaCallan Barrett
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-20Add support for variable length votes in voting applicationCallan Barrett
Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
2008-01-20AUR Voting ApplicationCallan Barrett
Added support for TU voting through AUR Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
2008-01-20Fix for safe-removal.eliott
2008-01-20Hand diff of simo's patch to remove flag safe functionality.eliott
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-19Added AurJSON code.eliott
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-17committed old schema change from old versionpjmattal
2007-02-01Added the DepCondition field to the table PackageDepends.dsa
2006-08-22Applied license patch from dsa (closes #4085).swiergot
2006-08-10of course, max length for Description must be 255, not 256pjmattal
2006-08-03upped length on Description in Package table to 256 from 128pjmattal
as per discussions with simo and dsa
2005-07-29committed schema change for swiergot's checking patchpjmattal
2005-06-08SQL CHANGES: New table CommentNotify with fields:simo
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-08Added ModifiedTS to Packages databasesimo
Implemented ModifiedTS such that: -ModifiedTS changed ONLY when package updated -SubmittedTS changed ONLY when new package Also made DummyPkg fixups in tupkgupdate
2005-04-09changed db name from AUR to aurpjmattal
moved db config for webapp into the config file
2005-04-06many changes in prep for launchpjmattal
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-20added comments/category editing, and closed #2280eric
2005-03-06started working on pkgedit for commentseric
2005-03-05started working on package commentseric
2005-01-24fixed dummy-data, schema, gendummydata to use md5 passwordseric
2004-12-15renumber none to one, hide none from category/location dropdownspjmattal
2004-12-15removed my url path and fs path from the packages tablejchu
2004-12-15tweaks to package functions and schemapjmattal
2004-12-15added a url path and fs path to the packages tablejchu
2004-12-15added a url path and fs path to the contents and took out filenamejchu
2004-12-06fixed the aur schema, added use AUR; line to make itpjmattal
re-find the db after drop and cr-create
2004-09-20added upload comments/history, still need to finish the actual db callseric
2004-07-01still working on pkgsearch.php::do_Detailseric
2004-06-29yet another schema changeeric
2004-06-28re-working pkgsearch, NumVotes add to Packages tableeric
2004-06-23added dummy data for testingeric
2004-06-23account adding/editing is workingeric
2004-06-22pulled out account functions into separate include fileeric
2004-06-21working on the accounts stufferic
2004-06-19started working on the logineric
2004-06-18finishing touches on genpopo, started playing with _real_ PHP code and svn ↵eric
keywords
2004-06-13Schema file now loads properly into MySQL.eric
2004-06-13initial importeric