summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
AgeCommit message (Collapse)AuthorFilesLines
2008-03-23Make all references to AUR database consistentLoui Chang1-3/+3
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 Barrett1-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-20Add support for variable length votes in voting applicationCallan Barrett1-0/+1
Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
2008-01-20AUR Voting ApplicationCallan Barrett1-0/+21
Added support for TU voting through AUR Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
2008-01-20Fix for safe-removal.eliott1-2/+0
2008-01-20Hand diff of simo's patch to remove flag safe functionality.eliott1-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-20Added AurJSON code.eliott1-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-17committed old schema change from old versionpjmattal1-1/+1
2007-02-01Added the DepCondition field to the table PackageDepends.dsa1-0/+1
2006-08-22Applied license patch from dsa (closes #4085).swiergot1-0/+1
2006-08-10of course, max length for Description must be 255, not 256pjmattal1-1/+1
2006-08-03upped length on Description in Package table to 256 from 128pjmattal1-1/+1
as per discussions with simo and dsa
2005-07-29committed schema change for swiergot's checking patchpjmattal1-0/+4
2005-06-08SQL CHANGES: New table CommentNotify with fields:simo1-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-08Added ModifiedTS to Packages databasesimo1-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-09changed db name from AUR to aurpjmattal1-3/+3
moved db config for webapp into the config file
2005-04-06many changes in prep for launchpjmattal1-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-20added comments/category editing, and closed #2280eric1-0/+2
2005-03-06started working on pkgedit for commentseric1-0/+2
2005-03-05started working on package commentseric1-3/+3
2005-01-24fixed dummy-data, schema, gendummydata to use md5 passwordseric1-3/+3
2004-12-15renumber none to one, hide none from category/location dropdownspjmattal1-9/+9
2004-12-15removed my url path and fs path from the packages tablejchu1-2/+0
2004-12-15tweaks to package functions and schemapjmattal1-2/+8
2004-12-15added a url path and fs path to the packages tablejchu1-0/+2
2004-12-15added a url path and fs path to the contents and took out filenamejchu1-3/+2
2004-12-06fixed the aur schema, added use AUR; line to make itpjmattal1-0/+1
re-find the db after drop and cr-create
2004-09-20added upload comments/history, still need to finish the actual db callseric1-0/+13
2004-07-02still working on pkgsearch.php::do_Detailseric1-1/+18
2004-06-29yet another schema changeeric1-3/+6
2004-06-28re-working pkgsearch, NumVotes add to Packages tableeric1-0/+2
2004-06-23added dummy data for testingeric1-0/+3
2004-06-23account adding/editing is workingeric1-1/+5
2004-06-22pulled out account functions into separate include fileeric1-2/+2
2004-06-21working on the accounts stufferic1-0/+2
2004-06-19started working on the logineric1-2/+3
2004-06-18finishing touches on genpopo, started playing with _real_ PHP code and svn ↵eric1-0/+1
keywords
2004-06-13Schema file now loads properly into MySQL.eric1-45/+49
2004-06-13initial importeric1-0/+139