summaryrefslogtreecommitdiff
path: root/support/schema/aur-schema.sql
AgeCommit message (Expand)Author
2012-10-22Use HTTPS links everywhere for Arch sitesDan McGee
2012-03-24Add field for PGP key in profile informationLukas Fleischer
2011-10-24Add LastLogin column to Users tableDan McGee
2011-10-24Remove explicit utf8 declarations in table creationDan McGee
2011-06-25Fix performance issues with new PackageDepends lookupsDan McGee
2011-04-13Remove "NewPkgNotify" column from "Users" table.Lukas Fleischer
2011-04-12Fix syntax error in "CREATE TABLE" statement in the SQL schema.Lukas Fleischer
2011-04-03Remove Dummy Package conceptDan McGee
2011-03-04Ensure users can be deleted when foreign keys are presentDan McGee
2011-03-04Allow DB connection values to come from the environmentDan McGee
2011-02-28Specify utf8 in database schema.Loui Chang
2011-02-27Add "ENGINE = InnoDB" to "CREATE TABLE" statements in the SQL schema.Lukas Fleischer
2011-02-27Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".Lukas Fleischer
2011-02-27Define "PackageComments.DelUsersID" as "NULL".Lukas Fleischer
2011-02-26Add missing foreign keys and constraints to the DB.Lukas Fleischer
2011-02-11Use VARCHAR instead of CHAR in "PackageBlacklist" table.Lukas Fleischer
2011-02-11Add a package name blacklist.Lukas Fleischer
2011-02-10Remove unused fulltext index from "Packages" table.Lukas Fleischer
2011-02-09Use VARCHAR instead of CHAR where appropriate.Lukas Fleischer
2011-02-01Drop "PackageContents" table and references.Lukas Fleischer
2011-02-01Remove "FSPath" column from "Packages" table.Lukas Fleischer
2011-02-01Drop PackageLocations table and referencesDan McGee
2011-01-24Build URLs from package names (fixes FS#15308, FS#19327).Lukas Fleischer
2010-11-10Add timestamp when a package is flagged out-of-date (FS#20848).Lukas Fleischer
2010-04-17Support for storing salted passwordsDenis
2009-11-29aur-schema.sql: Expand LangPreference field to allow for longer lang codes.Loui Chang
2009-11-13Implement 'Password Reset' facility (FS#3061)Evangelos Foutras
2009-06-18Add multicolumn indexes on votes and notifications tablesDan McGee
2008-03-27Remove references to AURMaintainerUIDCallan Barrett
2008-03-23Make all references to AUR database consistentLoui Chang
2008-01-20Bug in uploading PKGBUILDs and aur schemaCallan Barrett
2008-01-20Add support for variable length votes in voting applicationCallan Barrett
2008-01-20AUR Voting ApplicationCallan Barrett
2008-01-20Fix for safe-removal.eliott
2008-01-20Hand diff of simo's patch to remove flag safe functionality.eliott
2008-01-19Added AurJSON code.eliott
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
2005-07-29committed schema change for swiergot's checking patchpjmattal
2005-06-08SQL CHANGES: New table CommentNotify with fields:simo
2005-05-08Added ModifiedTS to Packages databasesimo
2005-04-09changed db name from AUR to aurpjmattal
2005-04-06many changes in prep for launchpjmattal
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
generated by cgit v1.2.3-54-g00ecf (git 2.45.2) at 2024-11-01 08:06:28 +0000