markzz/aurweb.git/support/schema/aur-schema.sql, branch v2.3.0aurweb working repositoryhttps://git.markzz.net/markzz/aurweb.git/atom/support/schema/aur-schema.sql?h=v2.3.02013-08-28T14:37:56ZAdd a registration time stamp to the "Users" table2013-08-28T14:37:56ZLukas Fleischerarchlinux@cryptocrack.de2013-08-28T14:37:56Zurn:sha1:d225366f31aae250981f9f5bf8e43e633c631c73
This allows for easily detecting old accounts that registered and never
used the confirmation e-mail to set an initial password.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add a "fonts" package category2013-08-27T00:46:55ZLukas Fleischerarchlinux@cryptocrack.de2013-08-27T00:46:55Zurn:sha1:7b0495cee23b14d4315a48962f86ad36ba097233
Implements FS#34666.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add a quorum column to TU_VoteInfo2013-08-22T15:48:16ZLukas Fleischerarchlinux@cryptocrack.de2013-08-04T15:16:17Zurn:sha1:64bfa6e8282744ee14b0bde4bb8caacb43400562
This allows for specifying a quorum per vote and sets a basis for
implementing automated acceptance/rejection of TU votes later.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Store the number of TUs when starting a vote2013-08-22T15:47:51ZLukas Fleischerarchlinux@cryptocrack.de2013-08-04T13:08:05Zurn:sha1:9ff082be25d444535ce99410363e63f6cca5f30d
This will be used for automated calculation of vote participation later.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Allow for setting an account's inactivity status2013-08-22T15:43:13ZLukas Fleischerarchlinux@cryptocrack.de2013-08-04T12:19:32Zurn:sha1:6844f6c1d2965cd5ec2ad72c887baeed9517c246
This adds a field to the users table and corresponding fields to the
account edit and display forms that allow for setting an (in-)activity
status.
This might turn out to be useful if a user is on vacation and can not
respond to update/orphan/deletion requests.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add "Bans" table to database schema2013-03-24T21:12:08Zcanyonknightcanyonknight@gmail.com2013-03-20T00:17:58Zurn:sha1:de2392fed016f80d4c0e10328c204f1e94ef54dd
The "Bans" table creates a DB structure for the ability to ban IP
addresses. It takes an IP address converted by ip2long().
The table will eventually be able to be populated directly through
the web interface by Trusted Users and Developers.
Signed-off-by: canyonknight <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Save last login IP address2013-03-21T21:26:46ZLukas Fleischerarchlinux@cryptocrack.de2013-03-19T13:49:34Zurn:sha1:5660816ea079585c70583a9e470e22c4cf66c022
Save the IP address used for the last login in the "Users" table. This
makes it a bit easier to create IP ban lists for spammers without
looking at web server logs.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Use HTTPS links everywhere for Arch sites2012-10-22T10:33:11ZDan McGeedan@archlinux.org2012-10-21T16:05:51Zurn:sha1:5222bf09320ebc1cd5da799970fcc0d2dd32bb3f
The main site, wiki, and BBS are using HTTPS exclusively, so link
directly to the correct protocol rather than forcing a redirect.
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add field for PGP key in profile information2012-03-24T09:34:32ZLukas Fleischerarchlinux@cryptocrack.de2012-03-22T08:27:44Zurn:sha1:985795a21000ea92bcc9e817ddc3a17c380b1ed1
This is handy for verifying the PGP key of new Trusted Users. Also, this
could potentially used as a basis to allow signed package uploads in the
future.
Implements FS#29028.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Add LastLogin column to Users table2011-10-24T15:57:53ZDan McGeedan@archlinux.org2011-10-21T21:03:41Zurn:sha1:a21739aae5daece7098652a0f7f8b7fd36b8fcc6
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>