summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
AgeCommit message (Collapse)AuthorFilesLines
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-19Added 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-01still 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