summaryrefslogtreecommitdiffstats
path: root/support/schema
AgeCommit message (Expand)AuthorFilesLines
2013-08-27Add a "fonts" package categoryLukas Fleischer1-0/+1
2013-08-22Add a quorum column to TU_VoteInfoLukas Fleischer1-0/+1
2013-08-22Store the number of TUs when starting a voteLukas Fleischer1-0/+1
2013-08-22Allow for setting an account's inactivity statusLukas Fleischer1-0/+1
2013-03-24Add "Bans" table to database schemacanyonknight1-0/+8
2013-03-21Save last login IP addressLukas Fleischer1-0/+1
2012-12-22gendummydata.py: Open all files with UTF-8 encodingcanyonknight1-3/+3
2012-12-22gendummydata.py: Remove need for fortune subprocesscanyonknight1-7/+11
2012-11-15gendummydata.py: Remove extra letter from dummy pkgrelcanyonknight1-1/+1
2012-10-22Use HTTPS links everywhere for Arch sitesDan McGee1-1/+1
2012-07-06gendummydata.py: Add ability to generate dummy trusted user proposalscanyonknight1-0/+26
2012-07-06gendummydata.py: Change variable to string to eliminate redundant codecanyonknight1-11/+5
2012-07-06gendummydata.py: Remove unused variablescanyonknight1-7/+0
2012-07-06gendummydata.py: Add check for command generating dummy commentscanyonknight1-1/+7
2012-03-24Add field for PGP key in profile informationLukas Fleischer1-0/+1
2011-10-24Add LastLogin column to Users tableDan McGee1-0/+1
2011-10-24Remove explicit utf8 declarations in table creationDan McGee1-2/+2
2011-06-25Fix performance issues with new PackageDepends lookupsDan McGee1-0/+1
2011-04-13Remove "NewPkgNotify" column from "Users" table.Lukas Fleischer1-2/+0
2011-04-13Make "gendummydata.py" Python 3 compliant.Lukas Fleischer2-15/+15
2011-04-12Fix dependency generation in "gendummydata.py".Lukas Fleischer1-2/+2
2011-04-12Fix syntax error in "CREATE TABLE" statement in the SQL schema.Lukas Fleischer1-1/+1
2011-04-12wrap long SQL commands to improve formatting and readabilityelij1-11/+23
2011-04-12replace print statements with logging module in gendummydataelij1-40/+22
2011-04-12remove mysql dependency from gendummydataelij1-41/+3
2011-04-03Remove Dummy Package conceptDan McGee1-4/+1
2011-03-30gendummydata.py: Do not touch output file until we need it.Lukas Fleischer1-5/+5
2011-03-04Ensure users can be deleted when foreign keys are presentDan McGee1-2/+3
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