From 5cd89a88bdffdef71bf9ae578dda39b9c186581b Mon Sep 17 00:00:00 2001
From: Loui Chang <louipc.ist@gmail.com>
Date: Sat, 11 Sep 2010 15:05:13 -0400
Subject: UPGRADING: Add file describing needed steps for upgrading between
 versions.

Signed-off-by: Loui Chang <louipc.ist@gmail.com>
---
 UPGRADING | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 57 insertions(+)
 create mode 100644 UPGRADING

diff --git a/UPGRADING b/UPGRADING
new file mode 100644
index 0000000..743f404
--- /dev/null
+++ b/UPGRADING
@@ -0,0 +1,57 @@
+Upgrading
+=========
+
+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;
+
-- 
cgit v1.2.3-70-g09d2