summaryrefslogtreecommitdiffstats
path: root/UPGRADING
diff options
context:
space:
mode:
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING644
1 files changed, 0 insertions, 644 deletions
diff --git a/UPGRADING b/UPGRADING
deleted file mode 100644
index 0e8edf0..0000000
--- a/UPGRADING
+++ /dev/null
@@ -1,644 +0,0 @@
-Upgrading
-=========
-
-From 3.1.0 to 3.2.0
--------------------
-
-1. Add support for package requests to the database:
-
-----
-CREATE TABLE RequestTypes (
- ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(32) NOT NULL DEFAULT '',
- PRIMARY KEY (ID)
-) ENGINE = InnoDB;
-INSERT INTO RequestTypes VALUES (1, 'deletion');
-INSERT INTO RequestTypes VALUES (2, 'orphan');
-INSERT INTO RequestTypes VALUES (3, 'merge');
-
-CREATE TABLE PackageRequests (
- ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
- ReqTypeID TINYINT UNSIGNED NOT NULL,
- PackageBaseID INTEGER UNSIGNED NULL,
- PackageBaseName VARCHAR(255) NOT NULL,
- MergeBaseName VARCHAR(255) NULL,
- UsersID INTEGER UNSIGNED NULL DEFAULT NULL,
- Comments TEXT NOT NULL DEFAULT '',
- RequestTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
- Status TINYINT UNSIGNED NOT NULL DEFAULT 0,
- PRIMARY KEY (ID),
- INDEX (UsersID),
- INDEX (PackageBaseID),
- FOREIGN KEY (ReqTypeID) REFERENCES RequestTypes(ID) ON DELETE NO ACTION,
- FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE SET NULL,
- FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE SET NULL
-) ENGINE = InnoDB;
-----
-
-From 3.0.0 to 3.1.0
--------------------
-
-1. Increase the size of all fields containing package names, license names,
-group names or package versions:
-
-----
-ALTER TABLE PackageBases MODIFY Name VARCHAR(255) NOT NULL;
-ALTER TABLE Packages
- MODIFY Name VARCHAR(255) NOT NULL,
- MODIFY Version VARCHAR(255) NOT NULL DEFAULT '';
-ALTER TABLE Licenses MODIFY Name VARCHAR(255) NOT NULL;
-ALTER TABLE Groups MODIFY Name VARCHAR(255) NOT NULL;
-ALTER TABLE PackageDepends MODIFY DepCondition VARCHAR(255);
-ALTER TABLE PackageRelations MODIFY RelCondition VARCHAR(255);
-----
-
-From 2.3.1 to 3.0.0
--------------------
-
-1. Drop the user ID foreign key from the "PackageComments" table:
-
-`ALTER TABLE PackageComments DROP FOREIGN KEY PackageComments_ibfk_1;` should
-work in most cases. Otherwise, check the output of `SHOW CREATE TABLE
-PackageComments;` and use the foreign key name shown there.
-
-2. Add support for anonymous comments:
-
-----
-ALTER TABLE PackageComments
- MODIFY UsersID INTEGER UNSIGNED NULL DEFAULT NULL,
- ADD FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE SET NULL;
-----
-
-3. Create the PackageBases table:
-
-----
-CREATE TABLE PackageBases (
- ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(64) NOT NULL,
- CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1,
- NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0,
- OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL,
- SubmittedTS BIGINT UNSIGNED NOT NULL,
- ModifiedTS BIGINT UNSIGNED NOT NULL,
- SubmitterUID INTEGER UNSIGNED NULL DEFAULT NULL,
- MaintainerUID INTEGER UNSIGNED NULL DEFAULT NULL,
- PackagerUID INTEGER UNSIGNED NULL DEFAULT NULL,
- PRIMARY KEY (ID),
- UNIQUE (Name),
- INDEX (CategoryID),
- INDEX (NumVotes),
- INDEX (SubmitterUID),
- INDEX (MaintainerUID),
- INDEX (PackagerUID),
- FOREIGN KEY (CategoryID) REFERENCES PackageCategories(ID) ON DELETE NO ACTION,
- -- deleting a user will cause packages to be orphaned, not deleted
- FOREIGN KEY (SubmitterUID) REFERENCES Users(ID) ON DELETE SET NULL,
- FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE SET NULL,
- FOREIGN KEY (PackagerUID) REFERENCES Users(ID) ON DELETE SET NULL
-) ENGINE = InnoDB;
-----
-
-4. Migrate data from Packages to PackageBases:
-
-----
-INSERT INTO PackageBases
- SELECT ID, Name, CategoryID, NumVotes, OutOfDateTS, SubmittedTS,
- ModifiedTS, SubmitterUID, MaintainerUID, NULL FROM Packages;
-----
-
-5. Delete unneeded foreign keys from Packages:
-
-First, drop the foreign keys on CategoryID, SubmitterUID and MaintainerUID. The
-following queries should work in most cases:
-
-----
-ALTER TABLE Packages
- DROP FOREIGN KEY Packages_ibfk_1,
- DROP FOREIGN KEY Packages_ibfk_2,
- DROP FOREIGN KEY Packages_ibfk_3;
-----
-
-You can use `SHOW CREATE TABLE Packages;` to check whether you should use
-different names for your setup.
-
-6. Delete unneeded fields from Packages:
-
-----
-ALTER TABLE Packages
- DROP COLUMN CategoryID,
- DROP COLUMN NumVotes,
- DROP COLUMN OutOfDateTS,
- DROP COLUMN SubmittedTS,
- DROP COLUMN ModifiedTS,
- DROP COLUMN SubmitterUID,
- DROP COLUMN MaintainerUID;
-----
-
-7. Add package base references to the Packages table:
-
-----
-ALTER TABLE Packages ADD COLUMN PackageBaseID INTEGER UNSIGNED NULL;
-UPDATE Packages SET PackageBaseID = ID;
-ALTER TABLE Packages
- MODIFY PackageBaseID INTEGER UNSIGNED NOT NULL,
- ADD FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE;
-----
-
-8. Delete foreign keys from PackageVotes, PackageComments and CommentNotify:
-
-----
-ALTER TABLE PackageVotes
- DROP FOREIGN KEY PackageVotes_ibfk_1,
- DROP FOREIGN KEY PackageVotes_ibfk_2;
-ALTER TABLE PackageComments
- DROP FOREIGN KEY PackageComments_ibfk_3;
-ALTER TABLE CommentNotify
- DROP FOREIGN KEY CommentNotify_ibfk_1,
- DROP FOREIGN KEY CommentNotify_ibfk_2;
-----
-
-We highly recommend to use `SHOW CREATE TABLE PackageVotes;` etc. to check
-whether you should use different names for your setup.
-
-9. Delete indexes from PackageVotes and CommentNotify:
-
-----
-ALTER TABLE PackageVotes DROP INDEX VoteUsersIDPackageID;
-ALTER TABLE CommentNotify DROP INDEX NotifyUserIDPkgID;
-----
-
-10. Migrate PackageVotes, PackageComments and CommentNotify to refer to package
-bases:
-
-----
-ALTER TABLE PackageVotes ADD COLUMN PackageBaseID INTEGER UNSIGNED NOT NULL;
-UPDATE PackageVotes SET PackageBaseID = PackageID;
-ALTER TABLE PackageVotes DROP COLUMN PackageID;
-ALTER TABLE PackageComments ADD COLUMN PackageBaseID INTEGER UNSIGNED NOT NULL;
-UPDATE PackageComments SET PackageBaseID = PackageID;
-ALTER TABLE PackageComments DROP COLUMN PackageID;
-ALTER TABLE CommentNotify ADD COLUMN PackageBaseID INTEGER UNSIGNED NOT NULL;
-UPDATE CommentNotify SET PackageBaseID = PkgID;
-ALTER TABLE CommentNotify DROP COLUMN PkgID;
-----
-
-11. Recreate missing foreign keys and indexes:
-
-----
-ALTER TABLE PackageVotes
- ADD FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE;
-ALTER TABLE PackageComments
- ADD FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE;
-ALTER TABLE CommentNotify
- ADD FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE;
-CREATE UNIQUE INDEX VoteUsersIDPackageID ON PackageVotes (UsersID, PackageBaseID);
-CREATE UNIQUE INDEX NotifyUserIDPkgID ON CommentNotify (UserID, PackageBaseID);
-----
-
-12. Create a new table to store package dependency types:
-
-----
-CREATE TABLE DependencyTypes (
- ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(32) NOT NULL DEFAULT '',
- PRIMARY KEY (ID)
-) ENGINE = InnoDB;
-INSERT INTO DependencyTypes VALUES (1, 'depends');
-INSERT INTO DependencyTypes VALUES (2, 'makedepends');
-INSERT INTO DependencyTypes VALUES (3, 'checkdepends');
-INSERT INTO DependencyTypes VALUES (4, 'optdepends');
-----
-
-13. Add a field to store the dependency type to the PackageDepends table:
-
-----
-ALTER TABLE PackageDepends ADD COLUMN DepTypeID TINYINT UNSIGNED NOT NULL;
-UPDATE PackageDepends SET DepTypeID = 1;
-ALTER TABLE PackageDepends
- ADD FOREIGN KEY (DepTypeID) REFERENCES DependencyTypes(ID) ON DELETE NO ACTION;
-----
-
-14. Resize the package dependency name field:
-
-----
-ALTER TABLE PackageDepends MODIFY DepName VARCHAR(255) NOT NULL;
-----
-
-15. Create a new table to store package relation types:
-
-----
-CREATE TABLE RelationTypes (
- ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(32) NOT NULL DEFAULT '',
- PRIMARY KEY (ID)
-) ENGINE = InnoDB;
-INSERT INTO RelationTypes VALUES (1, 'conflicts');
-INSERT INTO RelationTypes VALUES (2, 'provides');
-INSERT INTO RelationTypes VALUES (3, 'replaces');
-----
-
-16. Create a new table to store package relations:
-
-----
-CREATE TABLE PackageRelations (
- PackageID INTEGER UNSIGNED NOT NULL,
- RelTypeID TINYINT UNSIGNED NOT NULL,
- RelName VARCHAR(255) NOT NULL,
- RelCondition VARCHAR(20),
- INDEX (PackageID),
- INDEX (RelName),
- FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
- FOREIGN KEY (RelTypeID) REFERENCES RelationTypes(ID) ON DELETE NO ACTION
-) ENGINE = InnoDB;
-----
-
-17. Create tables to store package groups:
-
-----
-CREATE TABLE Groups (
- ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(64) NOT NULL,
- PRIMARY KEY (ID),
- UNIQUE (Name)
-) ENGINE = InnoDB;
-CREATE TABLE PackageGroups (
- PackageID INTEGER UNSIGNED NOT NULL,
- GroupID INTEGER UNSIGNED NOT NULL,
- PRIMARY KEY (PackageID, GroupID),
- FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
- FOREIGN KEY (GroupID) REFERENCES Groups(ID) ON DELETE CASCADE
-) ENGINE = InnoDB;
-----
-
-18. Create tables to store package licenses:
-
-----
-CREATE TABLE Licenses (
- ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(64) NOT NULL,
- PRIMARY KEY (ID),
- UNIQUE (Name)
-) ENGINE = InnoDB;
-CREATE TABLE PackageLicenses (
- PackageID INTEGER UNSIGNED NOT NULL,
- LicenseID INTEGER UNSIGNED NOT NULL,
- PRIMARY KEY (PackageID, LicenseID),
- FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
- FOREIGN KEY (LicenseID) REFERENCES Licenses(ID) ON DELETE CASCADE
-) ENGINE = InnoDB;
-----
-
-19. Convert existing licenses to the new storage format:
-
-----
-INSERT INTO Licenses (Name) SELECT DISTINCT License FROM Packages;
-INSERT INTO PackageLicenses (PackageID, LicenseID)
- SELECT Packages.ID, Licenses.ID FROM Packages
- INNER JOIN Licenses ON Licenses.Name = Packages.License;
-----
-
-20. Delete the license column from the Packages table:
-
-----
-ALTER TABLE Packages DROP COLUMN License;
-----
-
-From 2.2.0 to 2.3.0
--------------------
-
-1. Add registration and inactivity time stamps to the "Users" table:
-
-----
-ALTER TABLE Users
- ADD COLUMN RegistrationTS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- ADD COLUMN InactivityTS BIGINT NOT NULL DEFAULT 0;
-----
-
-2. Add fields to store the total number of TUs and the quorum to the
- "TU_VoteInfo" table:
-
-----
-ALTER TABLE TU_VoteInfo
- ADD COLUMN ActiveTUs tinyint(3) unsigned NOT NULL default '0',
- ADD COLUMN Quorum decimal(2, 2) unsigned NOT NULL;
-----
-
-3. Add a "fonts" category:
-
-----
-INSERT INTO PackageCategories (Category) VALUES ('fonts');
-----
-
-From 2.1.0 to 2.2.0
--------------------
-
-1. Add new "Users" table login IP address column:
-
-----
-ALTER TABLE Users
- ADD COLUMN LastLoginIPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0;
-----
-
-2. Add a new "Bans" table:
-
-----
-CREATE TABLE Bans (
- IPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0,
- BanTS TIMESTAMP NOT NULL,
- PRIMARY KEY (IPAddress)
-) ENGINE = InnoDB;
-----
-
-From 2.0.0 to 2.1.0
--------------------
-
-1. Update your aurblup setup to match configuration changes. See commit
-6dc61e7d9e87ad6821869dab61e5f005af2e0252 for details.
-
-From 1.9.1 to 2.0.0
--------------------
-
-1. Add new "Users" table login date and PGP key columns:
-
-----
-ALTER TABLE Users ADD COLUMN LastLogin BIGINT NOT NULL DEFAULT 0;
-ALTER TABLE Users ADD COLUMN PGPKey VARCHAR(40) NULL DEFAULT NULL;
-----
-
-2. Merge "web/lib/config.inc.php.proto" with "web/lib/config.inc.php".
-
-3. Enable the PDO MySQL extension (pdo_mysql.so) in "php.ini".
-
-4. Upgrade to PHP>=5.4.0 or enable "short_open_tag" in "php.ini".
-
-5. Install translations by running `make install` in "po/".
-
-From 1.9.0 to 1.9.1
--------------------
-
-1. Merge "web/lib/config.inc.php.proto" with "web/lib/config.inc.php".
-
-2. Install translations by running `make install` in "po/".
-
-From 1.8.2 to 1.9.0
--------------------
-
-1. Translation files are now gettext compatible and need to be compiled after
-each AUR upgrade by running `make install` in the "po/" directory.
-
-2. Remove the "NewPkgNotify" column from the "Users" table:
-
-ALTER TABLE Users DROP COLUMN NewPkgNotify;
-
-3. Fix up issues with depends performance on large dataset.
-
-ALTER TABLE PackageDepends ADD INDEX (DepName);
-
-4. Rename "web/lib/config.inc" to "web/lib/config.inc.php".
-
-5. Merge "web/lib/config.inc.php.proto" with "web/lib/config.inc.php".
-
-6. Run the upload directory transform script ("scripts/uploadbuckets.sh") and
-rotate the converted directory structure into place.
-
-7. In order to to provide backward compatible package URLs, enable mod_rewrite
-and add the following to your Apache configuration (inside the "VirtualHost"
-container or optionally create a ".htaccess" file in the upload directory):
-
-----
-RewriteEngine on
-RewriteRule ^/packages/([^/]{1,2})([^/]*/(PKGBUILD|[^/]*\.tar\.gz|))$ /packages/$1/$1$2
-----
-
-The following equivalent rule can be used for lighttpd setups:
-
-----
-url.rewrite-once = ( "^/packages/([^/]{1,2})([^/]*/(PKGBUILD|[^/]*\.tar\.gz|))$" => "/packages/$1/$1$2" )
-----
-
-If you use a non-standard URL_DIR, slight modifications might be necessary.
-
-8. Merge "scripts/aurblup/config.h.proto" with "scripts/aurblup/config.h".
-
-From 1.8.1 to 1.8.2
--------------------
-
-1. Update the modified package timestamp for new packages.
-
-UPDATE Packages SET ModifiedTS = SubmittedTS WHERE ModifiedTS = 0;
-
-2. Move to new method of storing package depends.
-
-----
-ALTER TABLE PackageDepends ADD COLUMN DepName VARCHAR(64) NOT NULL DEFAULT '' AFTER PackageID;
-UPDATE PackageDepends SET DepName = (SELECT Name FROM Packages WHERE ID = DepPkgID);
-ALTER TABLE PackageDepends MODIFY DepName VARCHAR(64) NOT NULL;
-ALTER TABLE PackageDepends DROP FOREIGN KEY `PackageDepends_ibfk_2`;
-ALTER TABLE PackageDepends DROP COLUMN DepPkgID;
-DELETE FROM Packages WHERE DummyPkg = 1;
-ALTER TABLE Packages DROP COLUMN DummyPkg;
-----
-
-3. The File_Find PEAR module is no longer required. You can safely uninstall it
-if nothing else depends on it.
-
-From 1.8.0 to 1.8.1
--------------------
-
-1. Drop foreign keys from the "Sessions" table:
-
-`ALTER TABLE Sessions DROP FOREIGN KEY Sessions_ibfk_1;` should work in most
-cases. Otherwise, check the output of `SHOW CREATE TABLE Sessions;` and use the
-foreign key name shown there.
-
-2. Run the following MySQL statements:
-
-----
-ALTER TABLE Sessions
- ADD FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE;
-ALTER TABLE PackageDepends
- ADD FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (DepPkgID) REFERENCES Packages(ID) ON DELETE CASCADE;
-ALTER TABLE PackageSources
- ADD FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE;
-ALTER TABLE TU_VoteInfo
- ADD FOREIGN KEY (SubmitterID) REFERENCES Users(ID) ON DELETE CASCADE;
-ALTER TABLE TU_Votes
- ADD FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE;
-ALTER TABLE PackageComments
- MODIFY DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL;
-UPDATE PackageComments SET DelUsersID = NULL WHERE DelUsersID = 0;
-ALTER TABLE Packages
- MODIFY SubmitterUID INTEGER UNSIGNED NULL DEFAULT NULL,
- MODIFY MaintainerUID INTEGER UNSIGNED NULL DEFAULT NULL;
-UPDATE Packages SET SubmitterUID = NULL WHERE SubmitterUID = 0;
-UPDATE Packages SET MaintainerUID = NULL WHERE MaintainerUID = 0;
-----
-
-3. (optional) If you converted your database from MyISAM to InnoDB during the
-upgrade process from 1.7.0 to 1.8.0 or from 1.8.0 to 1.8.1 without completely
-rebuilding the database from the MySQL schema, you should additionally run the
-following MySQL statements to add missing foreign keys:
-
-----
-ALTER TABLE Users
- ADD FOREIGN KEY (AccountTypeID) REFERENCES AccountTypes(ID) ON DELETE NO ACTION;
-ALTER TABLE Packages
- ADD FOREIGN KEY (CategoryID) REFERENCES PackageCategories(ID) ON DELETE NO ACTION,
- ADD FOREIGN KEY (SubmitterUID) REFERENCES Users(ID) ON DELETE NO ACTION,
- ADD FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE NO ACTION;
-ALTER TABLE PackageVotes
- ADD FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE;
-ALTER TABLE PackageComments
- ADD FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (DelUsersID) REFERENCES Users(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE;
-ALTER TABLE CommentNotify
- ADD FOREIGN KEY (PkgID) REFERENCES Packages(ID) ON DELETE CASCADE,
- ADD FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE;
-----
-
-4. Merge "web/lib/config.inc.proto" with "web/lib/config.inc".
-
-From 1.7.0 to 1.8.0
--------------------
-
-1. Run the following MySQL statements:
-
-----
-ALTER TABLE Packages ADD OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL;
-UPDATE Packages SET OutOfDateTS = UNIX_TIMESTAMP() WHERE OutOfDate = 1;
-ALTER TABLE Packages DROP OutOfDate, DROP FSPath, DROP URLPath, DROP LocationID;
-DROP TABLE PackageLocations, PackageContents;
-ALTER TABLE AccountTypes MODIFY AccountType VARCHAR(32) NOT NULL DEFAULT '';
-ALTER TABLE Users MODIFY Username VARCHAR(32) NOT NULL,
- MODIFY Email VARCHAR(64) NOT NULL,
- MODIFY RealName VARCHAR(64) NOT NULL DEFAULT '',
- MODIFY LangPreference VARCHAR(5) NOT NULL DEFAULT 'en',
- MODIFY IRCNick VARCHAR(32) NOT NULL DEFAULT '';
-ALTER TABLE PackageCategories MODIFY Category VARCHAR(32) NOT NULL;
-ALTER TABLE Packages MODIFY Name VARCHAR(64) NOT NULL,
- MODIFY Version VARCHAR(32) NOT NULL DEFAULT '',
- MODIFY Description VARCHAR(255) NOT NULL DEFAULT "An Arch Package",
- MODIFY URL VARCHAR(255) NOT NULL DEFAULT "https://www.archlinux.org",
- MODIFY License VARCHAR(40) NOT NULL DEFAULT '';
-ALTER TABLE PackageSources
- MODIFY Source VARCHAR(255) NOT NULL DEFAULT "/dev/null";
-ALTER TABLE TU_VoteInfo
- MODIFY User VARCHAR(32) collate latin1_general_ci NOT NULL;
-CREATE TABLE PackageBlacklist (
- ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- Name VARCHAR(64) NOT NULL,
- PRIMARY KEY (ID),
- UNIQUE (Name)
-);
-----
-
-2. Drop all fulltext indexes from the "Packages" table:
-
-Please do this with care. `ALTER TABLE Packages DROP INDEX Name;` will work in
-most cases but might remove the wrong index if your indexes have been created
-in a non-standard order (e.g. during some update process). You'd better run
-`SHOW INDEX FROM Packages;` before to ensure that your setup doesn't use a
-different naming.
-
-3. You will need to update all packages which are stored in the incoming dir as
-in 1.8.0, source tarballs are no longer extracted automatically and PKGBUILDs
-are from now on located in the same subdirectories as the tarballs themselves.
-The following script will do the conversion automatically when being run inside
-"$INCOMING_DIR":
-
-----
-#!/bin/bash
-
-for pkg in *; do
- if [ -d "${pkg}" -a ! -f "${pkg}/PKGBUILD" ]; then
- pkgbuild_file=$(find -P "${pkg}" -name PKGBUILD)
- [ -n "${pkgbuild_file}" ] && \
- cp "${pkgbuild_file}" "${pkg}/PKGBUILD"
- fi
-done
-----
-
-4. (optional): 1.8.0 includes a helper utility called "aurblup" that can be
-used to prevent users from uploading source packages with names identical to
-packages in predefined binary repos, e.g. the official repositories of your
-distribution. In order to build and install aurblup, enter the following
-commands:
-
- cd scripts/aurblup/
- make config.h
- $EDITOR config.h
- make install # as root
-
-Add something like "0 * * * * /usr/local/bin/aurblup" to root's crontab to make
-aurblup update the package blacklist every hour.
-
-NOTE: You can run aurblup as non-privileged user as well. Make sure that the
-user has read-write access to "/var/lib/aurblup/" (or whatever you defined with
-"ALPM_DBPATH") tho.
-
-5. (optional): As of 1.8.0, all MySQL tables should be InnoDB compatible. To
-convert a table, you can use this statement: `ALTER TABLE $foo ENGINE=InnoDB;`.
-If you want to stick with MyISAM or another storage engine that doesn't support
-transactions, you will need to disable the "MYSQL_USE_TRANSACTIONS" setting in
-"config.h" when setting up aurblup.
-
-From 1.6.0 to 1.7.0
--------------------
-ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT '';
-ALTER TABLE Users ADD ResetKey CHAR(32) NOT NULL DEFAULT '';
-ALTER TABLE Users MODIFY LangPreference CHAR(5) NOT NULL DEFAULT 'en';
-
-
-From 1.5.2 to 1.5.3
--------------------
-1. Ensure this appears in config.inc:
- define("DEFAULT_LANG", "en");
-
-
-From 1.5.1 to 1.5.2
--------------------
-1. Ensure Pear and File/Find.php are in the path. See web/README.txt.
-
-2. Update your running copy of support/scripts/newpackage-notify.
-
-3. Run this in web/lib:
-<?php
-
-# Run the script from within lib
-include('config.inc');
-include('aur.inc');
-
-$query = "UPDATE Packages SET " .
- "FSPath = CONCAT('" . INCOMING_DIR . "', Name, '/', Name,
-'.tar.gz'), " .
- "URLPath = CONCAT('" . URL_DIR . "', Name, '/', Name, '.tar.gz') " .
- "WHERE DummyPKG = 0 AND LocationID = 2;";
-
-$dbh = db_connect();
-db_query($query, $dbh);
-
-$query = "ALTER TABLE Packages DROP COLUMN AURMaintainerUID;";
-db_query($query, $dbh);
-
-
-1.3.0
------
-ALTER TABLE PackageDepends ADD COLUMN DepCondition VARCHAR(20) AFTER DepPkgID;
-ALTER TABLE Packages ADD License CHAR(40) NOT NULL DEFAULT '';
-
-
-1.2.10
-------
-ALTER TABLE Packages MODIFY Description CHAR(255) NOT NULL DEFAULT "An Arch Package";
-
-
-longerpkgname
--------------
-ALTER TABLE Packages MODIFY Name CHAR(64) NOT NULL;
-