markzz/aurweb.git/support/schema/aur-schema.sql, branch 1.8.0aurweb working repositoryhttps://git.markzz.net/markzz/aurweb.git/atom/support/schema/aur-schema.sql?h=1.8.02011-02-11T13:43:24ZUse VARCHAR instead of CHAR in "PackageBlacklist" table.2011-02-11T13:43:24ZLukas Fleischerarchlinux@cryptocrack.de2011-02-10T08:08:11Zurn:sha1:59055776943f4c6ef0865cefdb82b5a40d24e95e
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add a package name blacklist.2011-02-11T13:43:22ZLukas Fleischerarchlinux@cryptocrack.de2011-02-02T17:03:09Zurn:sha1:b69f548065e78d14afcdc91548d73539762f8d93
Can be used to blacklist package names for normal users. TUs and
developers are not affected. This is especially useful if used together
with a cron job that updates the blacklist periodically, e.g. to reject
packages which are available in the binary repos (FS#12902).
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Remove unused fulltext index from "Packages" table.2011-02-10T07:17:53ZLukas Fleischerarchlinux@cryptocrack.de2011-02-09T08:57:25Zurn:sha1:881bfcced4b1b0906d7ef57af55f4e7201ad2474
Drop fulltext indexes, which prevent the use of InnoDB, from "Packages"
table. All search routines use "LIKE" patterns, so fulltext search has
actually never been used.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Use VARCHAR instead of CHAR where appropriate.2011-02-09T07:46:27ZLukas Fleischerarchlinux@cryptocrack.de2011-02-08T09:40:35Zurn:sha1:6d737c468454823808d609cfb3b3dc27b0c2ddb3
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Drop "PackageContents" table and references.2011-02-01T14:16:29ZLukas Fleischerarchlinux@cryptocrack.de2011-02-01T14:16:29Zurn:sha1:34ac351e82a4e774b5c0bc3380b0ff90cb5a486d
We don't even touch source tarballs anymore - except for extracting the
PKGBUILD, so this is no longer needed.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Remove "FSPath" column from "Packages" table.2011-02-01T14:01:56ZLukas Fleischerarchlinux@cryptocrack.de2011-02-01T14:01:56Zurn:sha1:366ea03118dcd06047dc178d0c8c620af8612530
This field is not used anymore, so drop it from the table and remove all
references.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Drop PackageLocations table and references2011-02-01T11:41:08ZDan McGeedan@archlinux.org2011-01-31T17:18:15Zurn:sha1:7f5af61c884b53a75a2b7f8b5146465f14a71f6b
We don't need this anymore since all packages managed here are
well...managed here. Rip out all of the places we were using this field,
many of which depended on the magic value '2' anyway.
On the display side of things, we had a column that was always showing
'unsupported' that is now gone, and you can no longer sort by this column.
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Build URLs from package names (fixes FS#15308, FS#19327).2011-01-24T17:08:29ZLukas Fleischerarchlinux@cryptocrack.de2011-01-24T17:08:29Zurn:sha1:556de318aeeef6019bb7628389beee1358de93f8
Drop the "URLPath" field from the "Packages" table, build URLs from
package names instead.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add timestamp when a package is flagged out-of-date (FS#20848).2010-11-10T19:50:35ZLukas Fleischerarchlinux@cryptocrack.de2010-10-06T02:25:53Zurn:sha1:eda713032ce9bed773b6c927b2f6ac4b445fe577
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
- resolve conflict and omit i18n changes.
Support for storing salted passwords2010-04-17T20:50:24ZDenisd.v.kobozev@gmail.com2010-04-05T13:41:30Zurn:sha1:290c436046327d9f04b7d12b5fda19f4dc14f574
To upgrade existing databases:
ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT '';
Signed-off-by: Loui Chang <louipc.ist@gmail.com>