1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
Upgrading
=========
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 "http://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;
----
2. 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
----
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;
|