summaryrefslogtreecommitdiff
path: root/support/schema/aur-schema.sql
AgeCommit message (Collapse)Author
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