summaryrefslogtreecommitdiffstats
path: root/support/schema
AgeCommit message (Expand)AuthorFilesLines
2011-03-04Allow DB connection values to come from the environmentDan McGee3-21/+33
2011-03-04Use a single transaction to write dummy dataDan McGee1-0/+2
2011-02-28Remove database recreation code from "support/schema/reloadtestdb.sh".Lukas Fleischer1-6/+0
2011-02-28Specify utf8 in database schema.Loui Chang1-4/+4
2011-02-27Fix some minor bugs in "support/schema/gendummydata.py".Lukas Fleischer1-2/+2
2011-02-27Add "ENGINE = InnoDB" to "CREATE TABLE" statements in the SQL schema.Lukas Fleischer1-13/+13
2011-02-27Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".Lukas Fleischer2-3/+8
2011-02-27Define "PackageComments.DelUsersID" as "NULL".Lukas Fleischer1-1/+1
2011-02-26Add missing foreign keys and constraints to the DB.Lukas Fleischer1-5/+11
2011-02-11Use VARCHAR instead of CHAR in "PackageBlacklist" table.Lukas Fleischer1-1/+1
2011-02-11Add a package name blacklist.Lukas Fleischer1-0/+9
2011-02-10Remove unused fulltext index from "Packages" table.Lukas Fleischer1-1/+0
2011-02-09Use VARCHAR instead of CHAR where appropriate.Lukas Fleischer1-14/+14
2011-02-01Drop "PackageContents" table and references.Lukas Fleischer2-39/+0
2011-02-01Remove "FSPath" column from "Packages" table.Lukas Fleischer1-1/+0
2011-02-01Drop PackageLocations table and referencesDan McGee2-97/+29
2011-01-24Use "python2" shebang for "newpackage-notify" and "gendummydata.py".Lukas Fleischer1-1/+1
2011-01-24Build URLs from package names (fixes FS#15308, FS#19327).Lukas Fleischer2-15/+8
2010-11-10Add timestamp when a package is flagged out-of-date (FS#20848).Lukas Fleischer1-2/+1
2010-04-17Support for storing salted passwordsDenis1-0/+1
2009-11-29aur-schema.sql: Expand LangPreference field to allow for longer lang codes.Loui Chang1-1/+1
2009-11-13Implement 'Password Reset' facility (FS#3061)Evangelos Foutras1-1/+1
2009-06-18Add multicolumn indexes on votes and notifications tablesDan McGee1-1/+2
2008-03-27Remove references to AURMaintainerUIDCallan Barrett2-6/+3
2008-03-23Generate valid dummy data entriesLoui Chang1-12/+5
2008-03-23Make all references to AUR database consistentLoui Chang1-3/+3
2008-01-20Bug in uploading PKGBUILDs and aur schemaCallan Barrett1-2/+2
2008-01-20Add support for variable length votes in voting applicationCallan Barrett1-0/+1
2008-01-20AUR Voting ApplicationCallan Barrett1-0/+21
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
2008-01-20Remove dummy data from GITDan McGee1-0/+0
2008-01-20Added AurJSON code.eliott1-0/+1
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
2005-07-29committed schema change for swiergot's checking patchpjmattal1-0/+4
2005-06-08SQL CHANGES: New table CommentNotify with fields:simo1-0/+9
2005-05-08Added ModifiedTS to Packages databasesimo1-0/+1
2005-04-09changed db name from AUR to aurpjmattal1-3/+3
2005-04-06many changes in prep for launchpjmattal1-5/+5
2005-03-20added comments/category editing, and closed #2280eric1-0/+2
2005-03-06started working on pkgedit for commentseric3-2/+4
2005-03-05started working on package commentseric3-9/+35
2005-01-24fixed dummy-data, schema, gendummydata to use md5 passwordseric3-12/+12
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