Hi,

I've seen mention of removing the categories from the AUR several times in
aur-general, and someone mentioned that, while they serve no real purpose,
nobody has sent patches either.

Well, I gave this a try to see how well I could do and this *seems* to work
fine, though more granualar testing may be required (I'll do this if the patch
seems ok, and if its goal is deemed acceptable).

Feedback is, naturally, greatly appreciated.

Cheers,

-- 
Hugo Osvaldo Barrera
A: Because we read from top to bottom, left to right.
Q: Why should I start my reply below the quoted text?
From 3d6e2c08f98fc6fc0a1fc58ef634f6789f1e7e05 Mon Sep 17 00:00:00 2001
From: Hugo Osvaldo Barrera <[email protected]>
Date: Fri, 27 Feb 2015 08:41:53 -0300
Subject: [PATCH 1/3] Remove category support.

---
 web/html/pkgbase.php                |  2 -
 web/lib/aurjson.class.php           |  8 ++--
 web/lib/credentials.inc.php         |  3 +-
 web/lib/feedcreator.class.php       | 10 +----
 web/lib/pkgbasefuncs.inc.php        | 85 +------------------------------------
 web/lib/pkgfuncs.inc.php            | 27 +++---------
 web/template/pkg_details.php        | 30 -------------
 web/template/pkg_search_form.php    | 14 ------
 web/template/pkg_search_results.php |  2 -
 web/template/pkgbase_details.php    | 30 -------------
 10 files changed, 14 insertions(+), 197 deletions(-)

diff --git a/web/html/pkgbase.php b/web/html/pkgbase.php
index ef9b2c4..800415e 100644
--- a/web/html/pkgbase.php
+++ b/web/html/pkgbase.php
@@ -91,8 +91,6 @@ if (check_token()) {
 		list($ret, $output) = pkgbase_notify($ids, false);
 	} elseif (current_action("do_DeleteComment")) {
 		list($ret, $output) = pkgbase_delete_comment();
-	} elseif (current_action("do_ChangeCategory")) {
-		list($ret, $output) = pkgbase_change_category($base_id);
 	} elseif (current_action("do_FileRequest")) {
 		list($ret, $output) = pkgreq_file($ids, $_POST['type'], $_POST['merge_into'], $_POST['comments']);
 	} elseif (current_action("do_CloseRequest")) {
diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php
index 745947e..ea141cd 100644
--- a/web/lib/aurjson.class.php
+++ b/web/lib/aurjson.class.php
@@ -19,7 +19,7 @@ class AurJSON {
 	private static $fields_v1 = array(
 		'Packages.ID', 'Packages.Name',
 		'PackageBases.ID AS PackageBaseID',
-		'PackageBases.Name AS PackageBase', 'Version', 'CategoryID',
+		'PackageBases.Name AS PackageBase', 'Version',
 		'Description', 'URL', 'NumVotes', 'OutOfDateTS AS OutOfDate',
 		'Users.UserName AS Maintainer',
 		'SubmittedTS AS FirstSubmitted', 'ModifiedTS AS LastModified',
@@ -28,14 +28,14 @@ class AurJSON {
 	private static $fields_v2 = array(
 		'Packages.ID', 'Packages.Name',
 		'PackageBases.ID AS PackageBaseID',
-		'PackageBases.Name AS PackageBase', 'Version', 'CategoryID',
+		'PackageBases.Name AS PackageBase', 'Version',
 		'Description', 'URL', 'NumVotes', 'OutOfDateTS AS OutOfDate',
 		'Users.UserName AS Maintainer',
 		'SubmittedTS AS FirstSubmitted', 'ModifiedTS AS LastModified'
 	);
 	private static $numeric_fields = array(
-		'ID', 'PackageBaseID', 'CategoryID', 'NumVotes', 'OutOfDate',
-		'FirstSubmitted', 'LastModified'
+                'ID', 'PackageBaseID', 'NumVotes', 'OutOfDate',
+                'FirstSubmitted', 'LastModified'
 	);
 
 	/*
diff --git a/web/lib/credentials.inc.php b/web/lib/credentials.inc.php
index b813b90..26119f1 100644
--- a/web/lib/credentials.inc.php
+++ b/web/lib/credentials.inc.php
@@ -8,7 +8,7 @@ define("CRED_ACCOUNT_SEARCH", 5);
 define("CRED_COMMENT_DELETE", 6);
 define("CRED_COMMENT_VIEW_DELETED", 22);
 define("CRED_PKGBASE_ADOPT", 7);
-define("CRED_PKGBASE_CHANGE_CATEGORY", 8);
+/* 8 sed to be "CRED_PKGBASE_CHANGE_CATEGORY" */
 define("CRED_PKGBASE_DELETE", 9);
 define("CRED_PKGBASE_DISOWN", 10);
 define("CRED_PKGBASE_EDIT_COMAINTAINERS", 24);
@@ -60,7 +60,6 @@ function has_credential($credential, $approved_users=array()) {
 	case CRED_COMMENT_DELETE:
 	case CRED_COMMENT_VIEW_DELETED:
 	case CRED_PKGBASE_ADOPT:
-	case CRED_PKGBASE_CHANGE_CATEGORY:
 	case CRED_PKGBASE_DELETE:
 	case CRED_PKGBASE_EDIT_COMAINTAINERS:
 	case CRED_PKGBASE_DISOWN:
diff --git a/web/lib/feedcreator.class.php b/web/lib/feedcreator.class.php
index 802eebb..8b6b184 100644
--- a/web/lib/feedcreator.class.php
+++ b/web/lib/feedcreator.class.php
@@ -183,7 +183,7 @@ class FeedItem extends HtmlDescribable {
 	/**
 	 * Optional attributes of an item.
 	 */
-	var $author, $authorEmail, $image, $category, $comments, $guid, $source, $creator;
+	var $author, $authorEmail, $image, $comments, $guid, $source, $creator;
 	
 	/**
 	 * Publishing date of an item. May be in one of the following formats:
@@ -467,7 +467,7 @@ class FeedCreator extends HtmlDescribable {
 	/**
 	 * Optional attributes of a feed.
 	 */
-	var $syndicationURL, $image, $language, $copyright, $pubDate, $lastBuildDate, $editor, $editorEmail, $webmaster, $category, $docs, $ttl, $rating, $skipHours, $skipDays;
+	var $syndicationURL, $image, $language, $copyright, $pubDate, $lastBuildDate, $editor, $editorEmail, $webmaster, $docs, $ttl, $rating, $skipHours, $skipDays;
 
 	/**
 	* The url of the external xsl stylesheet used to format the naked rss feed.
@@ -948,9 +948,6 @@ class RSSCreator091 extends FeedCreator {
 			$pubDate = new FeedDate($this->pubDate);
 			$feed.= "        <pubDate>".htmlspecialchars($pubDate->rfc822())."</pubDate>\n";
 		}
-		if ($this->category!="") {
-			$feed.= "        <category>".htmlspecialchars($this->category)."</category>\n";
-		}
 		if ($this->docs!="") {
 			$feed.= "        <docs>".FeedCreator::iTrunc(htmlspecialchars($this->docs),500)."</docs>\n";
 		}
@@ -983,9 +980,6 @@ class RSSCreator091 extends FeedCreator {
 					$feed.= "            <source>".htmlspecialchars($this->items[$i]->source)."</source>\n";
 			}
 			*/
-			if ($this->items[$i]->category!="") {
-				$feed.= "            <category>".htmlspecialchars($this->items[$i]->category)."</category>\n";
-			}
 			if ($this->items[$i]->comments!="") {
 				$feed.= "            <comments>".htmlspecialchars($this->items[$i]->comments)."</comments>\n";
 			}
diff --git a/web/lib/pkgbasefuncs.inc.php b/web/lib/pkgbasefuncs.inc.php
index 5741b01..3d1ed2d 100644
--- a/web/lib/pkgbasefuncs.inc.php
+++ b/web/lib/pkgbasefuncs.inc.php
@@ -3,25 +3,6 @@
 include_once("pkgreqfuncs.inc.php");
 
 /**
- * Get all package categories stored in the database
- *
- * @param \PDO An already established database connection
- *
- * @return array All package categories
- */
-function pkgbase_categories() {
-	$dbh = DB::connect();
-	$q = "SELECT * FROM PackageCategories WHERE ID != 1 ";
-	$q.= "ORDER BY Category ASC";
-	$result = $dbh->query($q);
-	if (!$result) {
-		return null;
-	}
-
-	return $result->fetchAll(PDO::FETCH_KEY_PAIR);
-}
-
-/**
  * Get the number of non-deleted comments for a specific package base
  *
  * @param string $base_id The package base ID to get comment count for
@@ -186,16 +167,14 @@ function pkgbase_get_details($base_id) {
 	$dbh = DB::connect();
 
 	$q = "SELECT PackageBases.ID, PackageBases.Name, ";
-	$q.= "PackageBases.CategoryID, PackageBases.NumVotes, ";
+	$q.= "PackageBases.NumVotes, ";
 	$q.= "PackageBases.OutOfDateTS, PackageBases.SubmittedTS, ";
 	$q.= "PackageBases.ModifiedTS, PackageBases.SubmitterUID, ";
 	$q.= "PackageBases.MaintainerUID, PackageBases.PackagerUID, ";
-	$q.= "PackageCategories.Category, ";
 	$q.= "(SELECT COUNT(*) FROM PackageRequests ";
 	$q.= " WHERE PackageRequests.PackageBaseID = PackageBases.ID ";
 	$q.= " AND PackageRequests.Status = 0) AS RequestCount ";
-	$q.= "FROM PackageBases, PackageCategories ";
-	$q.= "WHERE PackageBases.CategoryID = PackageCategories.ID ";
+	$q.= "FROM PackageBases ";
 	$q.= "AND PackageBases.ID = " . intval($base_id);
 	$result = $dbh->query($q);
 
@@ -870,66 +849,6 @@ function pkgbase_delete_comment() {
 }
 
 /**
- * Change package base category
- *
- * @param int Package base ID of the package base to modify
- *
- * @return array Tuple of success/failure indicator and error message
- */
-function pkgbase_change_category($base_id) {
-	$uid = uid_from_sid($_COOKIE["AURSID"]);
-	if (!$uid) {
-		return array(false, __("You must be logged in before you can edit package information."));
-	}
-
-	if (isset($_POST["category_id"])) {
-		$category_id = $_POST["category_id"];
-	} else {
-		return array(false, __("Missing category ID."));
-	}
-
-	$dbh = DB::connect();
-	$catArray = pkgbase_categories($dbh);
-	if (!array_key_exists($category_id, $catArray)) {
-		return array(false, __("Invalid category ID."));
-	}
-
-	$base_id = intval($base_id);
-
-	/* Verify package ownership. */
-	$q = "SELECT MaintainerUID FROM PackageBases WHERE ID = " . $base_id;
-	$result = $dbh->query($q);
-	if ($result) {
-		$row = $result->fetch(PDO::FETCH_ASSOC);
-	}
-
-	if (!$result || !has_credential(CRED_PKGBASE_CHANGE_CATEGORY, array($row["MaintainerUID"]))) {
-		return array(false, __("You are not allowed to change this package category."));
-	}
-
-	$q = "UPDATE PackageBases ";
-	$q.= "SET CategoryID = ".intval($category_id)." ";
-	$q.= "WHERE ID = ".intval($base_id);
-	$dbh->exec($q);
-	return array(true, __("Package category changed."));
-}
-
-/**
- * Change the category a package base belongs to
- *
- * @param int $base_id The package base ID to change the category for
- * @param int $category_id The new category ID for the package
- *
- * @return void
- */
-function pkgbase_update_category($base_id, $category_id) {
-	$dbh = DB::connect();
-	$q = sprintf("UPDATE PackageBases SET CategoryID = %d WHERE ID = %d",
-		$category_id, $base_id);
-	$dbh->exec($q);
-}
-
-/**
  * Get a list of package base co-maintainers
  *
  * @param int $base_id The package base ID to retrieve the co-maintainers for
diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index c71358a..f2fdb82 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -400,17 +400,16 @@ function pkg_get_details($id=0) {
 	$dbh = DB::connect();
 
 	$q = "SELECT Packages.*, PackageBases.ID AS BaseID, ";
-	$q.= "PackageBases.Name AS BaseName, PackageBases.CategoryID, ";
+	$q.= "PackageBases.Name AS BaseName, ";
 	$q.= "PackageBases.NumVotes, PackageBases.OutOfDateTS, ";
 	$q.= "PackageBases.SubmittedTS, PackageBases.ModifiedTS, ";
 	$q.= "PackageBases.SubmitterUID, PackageBases.MaintainerUID, ";
-	$q.= "PackageBases.PackagerUID, PackageCategories.Category, ";
+	$q.= "PackageBases.PackagerUID, ";
 	$q.= "(SELECT COUNT(*) FROM PackageRequests ";
 	$q.= " WHERE PackageRequests.PackageBaseID = Packages.PackageBaseID ";
 	$q.= " AND PackageRequests.Status = 0) AS RequestCount ";
-	$q.= "FROM Packages, PackageBases, PackageCategories ";
+	$q.= "FROM Packages, PackageBases ";
 	$q.= "WHERE PackageBases.ID = Packages.PackageBaseID ";
-	$q.= "AND PackageBases.CategoryID = PackageCategories.ID ";
 	$q.= "AND Packages.ID = " . intval($id);
 	$result = $dbh->query($q);
 
@@ -475,14 +474,12 @@ function pkg_display_details($id=0, $row, $SID="") {
  *  request vars:
  *    O  - starting result number
  *    PP - number of search hits per page
- *    C  - package category ID number
  *    K  - package search string
  *    SO - search hit sort order:
  *          values: a - ascending
  *                  d - descending
  *    SB - sort search hits by:
- *          values: c - package category
- *                  n - package name
+ *          values: n - package name
  *                  v - number of votes
  *                  m - maintainer username
  *    SeB- property that search string (K) represents
@@ -516,7 +513,6 @@ function pkg_search_page($SID="") {
 	 */
 	if ($SID)
 		$myuid = uid_from_sid($SID);
-	$cats = pkgbase_categories($dbh);
 
 	/* Sanitize paging variables. */
 	if (isset($_GET['O'])) {
@@ -543,16 +539,13 @@ function pkg_search_page($SID="") {
 			   PackageVotes.UsersID AS Voted, ";
 	}
 	$q_select .= "Users.Username AS Maintainer,
-	PackageCategories.Category,
 	Packages.Name, Packages.Version, Packages.Description,
 	PackageBases.NumVotes, Packages.ID, Packages.PackageBaseID,
 	PackageBases.OutOfDateTS ";
 
 	$q_from = "FROM Packages
 	LEFT JOIN PackageBases ON (PackageBases.ID = Packages.PackageBaseID)
-	LEFT JOIN Users ON (PackageBases.MaintainerUID = Users.ID)
-	LEFT JOIN PackageCategories
-	ON (PackageBases.CategoryID = PackageCategories.ID) ";
+	LEFT JOIN Users ON (PackageBases.MaintainerUID = Users.ID);
 	if ($SID) {
 		/* This is not needed for the total row count query. */
 		$q_from_extra = "LEFT JOIN PackageVotes
@@ -564,13 +557,6 @@ function pkg_search_page($SID="") {
 	}
 
 	$q_where = 'WHERE PackageBases.PackagerUID IS NOT NULL ';
-	/*
-	 * TODO: Possibly do string matching on category to make request
-	 * variable values more sensible.
-	 */
-	if (isset($_GET["C"]) && intval($_GET["C"])) {
-		$q_where .= "AND PackageBases.CategoryID = ".intval($_GET["C"])." ";
-	}
 
 	if (isset($_GET['K'])) {
 		if (isset($_GET["SeB"]) && $_GET["SeB"] == "m") {
@@ -625,9 +611,6 @@ function pkg_search_page($SID="") {
 	$q_sort = "ORDER BY ";
 	$sort_by = isset($_GET["SB"]) ? $_GET["SB"] : '';
 	switch ($sort_by) {
-	case 'c':
-		$q_sort .= "CategoryID " . $order . ", ";
-		break;
 	case 'v':
 		$q_sort .= "NumVotes " . $order . ", ";
 		break;
diff --git a/web/template/pkg_details.php b/web/template/pkg_details.php
index c1c07ba..e10c282 100644
--- a/web/template/pkg_details.php
+++ b/web/template/pkg_details.php
@@ -9,8 +9,6 @@ $uid = uid_from_sid($SID);
 $pkgid = intval($row['ID']);
 $base_id = intval($row['BaseID']);
 
-$catarr = pkgbase_categories();
-
 $submitter = username_from_id($row["SubmitterUID"]);
 $maintainer = username_from_id($row["MaintainerUID"]);
 $packager = username_from_id($row["PackagerUID"]);
@@ -186,34 +184,6 @@ $sources = pkg_sources($row["ID"]);
 			<th><?= __('Upstream URL') . ': ' ?></th>
 			<td><a href="<?= htmlspecialchars($row['URL'], ENT_QUOTES) ?>" title="<?= __('Visit the website for') . ' ' . htmlspecialchars( $row['Name'])?>"><?= htmlspecialchars($row['URL'], ENT_QUOTES) ?></a></td>
 		</tr>
-		<tr>
-			<th><?= __('Category') . ': ' ?></th>
-<?php
-if (has_credential(CRED_PKGBASE_CHANGE_CATEGORY, array($row["MaintainerUID"]))):
-?>
-			<td>
-				<form method="post" action="<?= htmlspecialchars(get_pkgbase_uri($row['BaseName']), ENT_QUOTES); ?>">
-					<div>
-						<input type="hidden" name="action" value="do_ChangeCategory" />
-						<?php if ($SID): ?>
-						<input type="hidden" name="token" value="<?= htmlspecialchars($_COOKIE['AURSID']) ?>" />
-						<?php endif; ?>
-						<select name="category_id">
-<?php
-	foreach ($catarr as $cid => $catname):
-?>
-							<option value="<?= $cid ?>"<?php if ($cid == $row["CategoryID"]) { ?> selected="selected" <?php } ?>><?= $catname ?></option>
-	<?php endforeach; ?>
-						</select>
-						<input type="submit" value="<?= __('Change category') ?>"/>
-					</div>
-				</form>
-<?php else: ?>
-			<td>
-				<a href="<?= get_uri('/packages/'); ?>?C=<?= $row['CategoryID'] ?>"><?= $row['Category'] ?></a>
-<?php endif; ?>
-			</td>
-		</tr>
 		<?php if (count($lics) > 0): ?>
 		<tr>
 			<th><?= __('Licenses') . ': ' ?></th>
diff --git a/web/template/pkg_search_form.php b/web/template/pkg_search_form.php
index 7428250..db1b0d3 100644
--- a/web/template/pkg_search_form.php
+++ b/web/template/pkg_search_form.php
@@ -19,7 +19,6 @@ $outdated_flags = array(
 
 $sortby = array(
 	'n' => __('Name'),
-	'c' => __('Category'),
 	'v' => __('Votes'),
 	'w' => __('Voted'),
 	'o' => __('Notify'),
@@ -44,19 +43,6 @@ $per_page = array(50, 100, 250);
 	<fieldset>
 		<legend><?= __('Enter search criteria') ?></legend>
 		<div>
-			<label for="id_category"><?= __("Category"); ?></label>
-			<select name='C' id="id_category">
-				<option value='0'><?= __("Any"); ?></option>
-				<?php foreach (pkgbase_categories() as $id => $cat): ?>
-				<?php if (isset($_REQUEST['C']) && $_REQUEST['C'] == $id): ?>
-				<option value="<?= $id ?>" selected="selected"><?= $cat; ?></option>
-				<?php else: ?>
-				<option value="<?= $id ?>"><?= $cat; ?></option>
-				<?php endif; ?>
-				<?php endforeach; ?>
-			</select>
-		</div>
-		<div>
 			<label for="id_method"><?= __("Search by"); ?></label>
 			<select name='SeB'>
 				<?php foreach ($searchby as $k => $v): ?>
diff --git a/web/template/pkg_search_results.php b/web/template/pkg_search_results.php
index e901408..8d524e0 100644
--- a/web/template/pkg_search_results.php
+++ b/web/template/pkg_search_results.php
@@ -32,7 +32,6 @@ if (!$result): ?>
 					<?php if ($SID): ?>
 					<th>&nbsp;</th>
 					<?php endif; ?>
-					<th><a href="?<?= mkurl('SB=c&SO=' . $SO_next) ?>"><?= __("Category") ?></a></th>
 					<th><a href="?<?= mkurl('SB=n&SO=' . $SO_next) ?>"><?= __("Name") ?></a></th>
 					<th><?= __("Version") ?></th>
 					<th><a href="?<?= mkurl('SB=v&SO=' . $SO_next) ?>"><?= __("Votes") ?></a></th>
@@ -51,7 +50,6 @@ if (!$result): ?>
 		<?php if ($SID): ?>
 		<td><input type="checkbox" name="IDs[<?= $row["PackageBaseID"] ?>]" value="1" /></td>
 		<?php endif; ?>
-		<td><?= htmlspecialchars($row["Category"]) ?></td>
 		<td><a href="<?= htmlspecialchars(get_pkg_uri($row["Name"]), ENT_QUOTES); ?>"><?= htmlspecialchars($row["Name"]) ?></a></td>
 		<td<?php if ($row["OutOfDateTS"]): ?> class="flagged"<?php endif; ?>><?= htmlspecialchars($row["Version"]) ?></td>
 		<td><?= $row["NumVotes"] ?></td>
diff --git a/web/template/pkgbase_details.php b/web/template/pkgbase_details.php
index 98a7219..03faef1 100644
--- a/web/template/pkgbase_details.php
+++ b/web/template/pkgbase_details.php
@@ -8,8 +8,6 @@ $uid = uid_from_sid($SID);
 
 $base_id = intval($row['ID']);
 
-$catarr = pkgbase_categories();
-
 $submitter = username_from_id($row["SubmitterUID"]);
 $maintainer = username_from_id($row["MaintainerUID"]);
 $packager = username_from_id($row["PackagerUID"]);
@@ -126,34 +124,6 @@ $pkgs = pkgbase_get_pkgnames($base_id);
 			</td>
 		</tr>
 		<tr>
-			<th><?= __('Category') . ': ' ?></th>
-<?php
-if (has_credential(CRED_PKGBASE_CHANGE_CATEGORY, array($row["MaintainerUID"]))):
-?>
-			<td>
-				<form method="post" action="<?= htmlspecialchars(get_pkgbase_uri($row['Name']), ENT_QUOTES); ?>">
-					<div>
-						<input type="hidden" name="action" value="do_ChangeCategory" />
-						<?php if ($SID): ?>
-						<input type="hidden" name="token" value="<?= htmlspecialchars($_COOKIE['AURSID']) ?>" />
-						<?php endif; ?>
-						<select name="category_id">
-<?php
-	foreach ($catarr as $cid => $catname):
-?>
-							<option value="<?= $cid ?>"<?php if ($cid == $row["CategoryID"]) { ?> selected="selected" <?php } ?>><?= $catname ?></option>
-	<?php endforeach; ?>
-						</select>
-						<input type="submit" value="<?= __('Change category') ?>"/>
-					</div>
-				</form>
-<?php else: ?>
-			<td>
-				<a href="<?= get_uri('/packages/'); ?>?C=<?= $row['CategoryID'] ?>"><?= $row['Category'] ?></a>
-<?php endif; ?>
-			</td>
-		</tr>
-		<tr>
 			<th><?= __('Submitter') .': ' ?></th>
 			<?php if ($row["SubmitterUID"] && $SID): ?>
 			<td><a href="<?= get_uri('/account/') . html_format_username($submitter, ENT_QUOTES) ?>" title="<?= __('View account information for %s', html_format_username($submitter)) ?>"><?= html_format_username($submitter) ?></a></td>
-- 
2.3.1

From bf07ab12407973e657db0a2d67bcf01244c0d9ed Mon Sep 17 00:00:00 2001
From: Hugo Osvaldo Barrera <[email protected]>
Date: Fri, 27 Feb 2015 08:42:36 -0300
Subject: [PATCH 2/3] Delete categories from the SQL schema.

---
 schema/aur-schema.sql  | 34 ----------------------------------
 schema/gendummydata.py |  9 +++------
 2 files changed, 3 insertions(+), 40 deletions(-)

diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 9c647d8..1c8abbe 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -64,43 +64,11 @@ CREATE TABLE Sessions (
 ) ENGINE = InnoDB;
 
 
--- Categories for grouping packages when they reside in
--- Unsupported or the AUR - based on the categories defined
--- in 'extra'.
---
-CREATE TABLE PackageCategories (
-	ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
-	Category VARCHAR(32) NOT NULL,
-	PRIMARY KEY (ID)
-) ENGINE = InnoDB;
-INSERT INTO PackageCategories (Category) VALUES ('none');
-INSERT INTO PackageCategories (Category) VALUES ('daemons');
-INSERT INTO PackageCategories (Category) VALUES ('devel');
-INSERT INTO PackageCategories (Category) VALUES ('editors');
-INSERT INTO PackageCategories (Category) VALUES ('emulators');
-INSERT INTO PackageCategories (Category) VALUES ('games');
-INSERT INTO PackageCategories (Category) VALUES ('gnome');
-INSERT INTO PackageCategories (Category) VALUES ('i18n');
-INSERT INTO PackageCategories (Category) VALUES ('kde');
-INSERT INTO PackageCategories (Category) VALUES ('lib');
-INSERT INTO PackageCategories (Category) VALUES ('modules');
-INSERT INTO PackageCategories (Category) VALUES ('multimedia');
-INSERT INTO PackageCategories (Category) VALUES ('network');
-INSERT INTO PackageCategories (Category) VALUES ('office');
-INSERT INTO PackageCategories (Category) VALUES ('science');
-INSERT INTO PackageCategories (Category) VALUES ('system');
-INSERT INTO PackageCategories (Category) VALUES ('x11');
-INSERT INTO PackageCategories (Category) VALUES ('xfce');
-INSERT INTO PackageCategories (Category) VALUES ('fonts');
-INSERT INTO PackageCategories (Category) VALUES ('wayland');
-
-
 -- Information on package bases
 --
 CREATE TABLE PackageBases (
 	ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 	Name VARCHAR(255) 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,
@@ -110,12 +78,10 @@ CREATE TABLE PackageBases (
 	PackagerUID INTEGER UNSIGNED NULL DEFAULT NULL,      -- Last packager
 	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,
diff --git a/schema/gendummydata.py b/schema/gendummydata.py
index 9ad5373..66f4c73 100755
--- a/schema/gendummydata.py
+++ b/schema/gendummydata.py
@@ -32,7 +32,6 @@ PKG_DEPS  = (1, 15)    # min/max depends a package has
 PKG_RELS  = (1, 5)     # min/max relations a package has
 PKG_SRC   = (1, 3)     # min/max sources a package has
 PKG_CMNTS = (1, 5)     # min/max number of comments a package has
-CATEGORIES_COUNT = 17  # the number of categories from aur-schema
 VOTING    = (0, .30)   # percentage range for package voting
 OPEN_PROPOSALS = 5 # number of open trusted user proposals
 CLOSE_PROPOSALS = 15 # number of closed trusted user proposals
@@ -77,8 +76,6 @@ def genVersion():
 	if random.randrange(0,2) == 0:
 		ver.append("%d" % random.randrange(0,100))
 	return ".".join(ver) + "-%d" % random.randrange(1,11)
-def genCategory():
-	return random.randrange(1,CATEGORIES_COUNT)
 def genUID():
 	return seen_users[user_keys[random.randrange(0,len(user_keys))]]
 def genFortune():
@@ -200,9 +197,9 @@ for p in list(seen_pkgs.keys()):
 
 	uuid = genUID() # the submitter/user
 
-	s = ("INSERT INTO PackageBases (ID, Name, CategoryID, SubmittedTS, "
-         "SubmitterUID, MaintainerUID) VALUES (%d, '%s', %d, %d, %d, %s);\n")
-	s = s % (seen_pkgs[p], p, genCategory(), NOW, uuid, muid)
+	s = ("INSERT INTO PackageBases (ID, Name, SubmittedTS, "
+         "SubmitterUID, MaintainerUID) VALUES (%d, '%s', %d, %d, %s);\n")
+	s = s % (seen_pkgs[p], p, NOW, uuid, muid)
 	out.write(s)
 
 	s = ("INSERT INTO Packages (ID, PackageBaseID, Name, Version) VALUES "
-- 
2.3.1

From 4cb22cfaaa6d2cba32bcc9f52fc74b0f478c7faa Mon Sep 17 00:00:00 2001
From: Hugo Osvaldo Barrera <[email protected]>
Date: Fri, 27 Feb 2015 08:42:59 -0300
Subject: [PATCH 3/3] Delete unused category-related translations.

---
 po/aur.pot  | 24 ------------------------
 po/ca.po    | 24 ------------------------
 po/cs.po    | 24 ------------------------
 po/da.po    | 24 ------------------------
 po/de.po    | 24 ------------------------
 po/el.po    | 24 ------------------------
 po/es.po    | 24 ------------------------
 po/fi.po    | 24 ------------------------
 po/fr.po    | 24 ------------------------
 po/he.po    | 24 ------------------------
 po/hr.po    | 24 ------------------------
 po/hu.po    | 24 ------------------------
 po/it.po    | 24 ------------------------
 po/ja.po    | 24 ------------------------
 po/nb.po    | 24 ------------------------
 po/nl.po    | 24 ------------------------
 po/pl.po    | 24 ------------------------
 po/pt_BR.po | 24 ------------------------
 po/pt_PT.po | 24 ------------------------
 po/ro.po    | 24 ------------------------
 po/ru.po    | 24 ------------------------
 po/sk.po    | 24 ------------------------
 po/sr.po    | 24 ------------------------
 po/tr.po    | 24 ------------------------
 po/uk.po    | 24 ------------------------
 po/zh_CN.po | 24 ------------------------
 26 files changed, 624 deletions(-)

diff --git a/po/aur.pot b/po/aur.pot
index 79de7ee..260ae86 100644
--- a/po/aur.pot
+++ b/po/aur.pot
@@ -454,12 +454,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr ""
-
-msgid "Select Category"
-msgstr ""
-
 msgid "Upload package file"
 msgstr ""
 
@@ -688,18 +682,6 @@ msgstr ""
 msgid "You are not allowed to delete this comment."
 msgstr ""
 
-msgid "Missing category ID."
-msgstr ""
-
-msgid "Invalid category ID."
-msgstr ""
-
-msgid "You are not allowed to change this package category."
-msgstr ""
-
-msgid "Package category changed."
-msgstr ""
-
 msgid "View packages details for"
 msgstr ""
 
@@ -901,12 +883,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr ""
-
-msgid "Change category"
-msgstr ""
-
 msgid "Submitter"
 msgstr ""
 
diff --git a/po/ca.po b/po/ca.po
index df9ef4c..2c1d7fc 100644
--- a/po/ca.po
+++ b/po/ca.po
@@ -483,12 +483,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Categoria del paquet"
-
-msgid "Select Category"
-msgstr "Seleccioneu categoria"
-
 msgid "Upload package file"
 msgstr "Puja arxiu del paquet"
 
@@ -731,18 +725,6 @@ msgstr "S'ha esborrat el comentari."
 msgid "You are not allowed to delete this comment."
 msgstr "No esteu autoritzat per esborrar aquest comentari."
 
-msgid "Missing category ID."
-msgstr "Manca la identificació de categoria."
-
-msgid "Invalid category ID."
-msgstr "L'identificador de la categoria no és vàlid."
-
-msgid "You are not allowed to change this package category."
-msgstr "No esteu autoritzats a canviar la categoria del paquet."
-
-msgid "Package category changed."
-msgstr "Ha canviat la categoria del paquet."
-
 msgid "View packages details for"
 msgstr "Veure els detalls del paquet per"
 
@@ -944,12 +926,6 @@ msgstr "Adoptar Paquet"
 msgid "Disown Package"
 msgstr "Desposseir-se del paquet"
 
-msgid "Category"
-msgstr "Categoria"
-
-msgid "Change category"
-msgstr "Canvi de categoria"
-
 msgid "Submitter"
 msgstr "Remitent"
 
diff --git a/po/cs.po b/po/cs.po
index 1c14a50..7a97508 100644
--- a/po/cs.po
+++ b/po/cs.po
@@ -458,12 +458,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Kategorie balíčku"
-
-msgid "Select Category"
-msgstr "Vybrat kategorii"
-
 msgid "Upload package file"
 msgstr "Nahrát soubor balíčku"
 
@@ -693,18 +687,6 @@ msgstr "Komentář byl smazán."
 msgid "You are not allowed to delete this comment."
 msgstr "Nemáte oprávnění pro smazání tohoto komentáře."
 
-msgid "Missing category ID."
-msgstr ""
-
-msgid "Invalid category ID."
-msgstr "Chybné ID kategorie."
-
-msgid "You are not allowed to change this package category."
-msgstr ""
-
-msgid "Package category changed."
-msgstr ""
-
 msgid "View packages details for"
 msgstr ""
 
@@ -907,12 +889,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr "Kategorie"
-
-msgid "Change category"
-msgstr ""
-
 msgid "Submitter"
 msgstr ""
 
diff --git a/po/da.po b/po/da.po
index 8b49ce2..65f7c64 100644
--- a/po/da.po
+++ b/po/da.po
@@ -455,12 +455,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Pakkekategori"
-
-msgid "Select Category"
-msgstr "Vælg kategori"
-
 msgid "Upload package file"
 msgstr "Send pakke"
 
@@ -689,18 +683,6 @@ msgstr "Kommentaren er slettet."
 msgid "You are not allowed to delete this comment."
 msgstr "Du har ikke rettigheder til at slette denne kommentar."
 
-msgid "Missing category ID."
-msgstr ""
-
-msgid "Invalid category ID."
-msgstr "Ugyldigt kategori ID."
-
-msgid "You are not allowed to change this package category."
-msgstr ""
-
-msgid "Package category changed."
-msgstr ""
-
 msgid "View packages details for"
 msgstr ""
 
@@ -902,12 +884,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr "Kategori"
-
-msgid "Change category"
-msgstr ""
-
 msgid "Submitter"
 msgstr ""
 
diff --git a/po/de.po b/po/de.po
index dfa0ef5..acb7374 100644
--- a/po/de.po
+++ b/po/de.po
@@ -515,12 +515,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Paket-Kategorie"
-
-msgid "Select Category"
-msgstr "Wähle eine Kategorie"
-
 msgid "Upload package file"
 msgstr "Hochladen der Paket-Datei"
 
@@ -764,18 +758,6 @@ msgstr "Kommentar wurde gelöscht."
 msgid "You are not allowed to delete this comment."
 msgstr "Du darfst diesen Kommentar nicht löschen."
 
-msgid "Missing category ID."
-msgstr "Kategorie-ID fehlt."
-
-msgid "Invalid category ID."
-msgstr "Kategorie-ID ungültig."
-
-msgid "You are not allowed to change this package category."
-msgstr "Du darfst diese Paketkategorie nicht ändern."
-
-msgid "Package category changed."
-msgstr "Die Kategorie des Pakets wurde verändert."
-
 msgid "View packages details for"
 msgstr "Paket-Informationen aufrufen für"
 
@@ -980,12 +962,6 @@ msgstr "Paket übernehmen"
 msgid "Disown Package"
 msgstr "Paket abgeben"
 
-msgid "Category"
-msgstr "Kategorie"
-
-msgid "Change category"
-msgstr "Kategorie wechseln"
-
 msgid "Submitter"
 msgstr "Eingereicht von"
 
diff --git a/po/el.po b/po/el.po
index ce53ec1..77aec52 100644
--- a/po/el.po
+++ b/po/el.po
@@ -506,12 +506,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Κατηγορία Πακέτου"
-
-msgid "Select Category"
-msgstr "Επιλέξτε κατηγορία"
-
 msgid "Upload package file"
 msgstr "Ανεβάστε το αρχείο του πακέτου"
 
@@ -758,18 +752,6 @@ msgstr "Το σχόλιο έχει διαγραφεί."
 msgid "You are not allowed to delete this comment."
 msgstr "Δεν σας επιτρέπεται να διαγράψετε αυτό το σχόλιο."
 
-msgid "Missing category ID."
-msgstr "Μη υπαρκτό ID κατηγορίας."
-
-msgid "Invalid category ID."
-msgstr "Μη έγκυρο ID κατηγορίας."
-
-msgid "You are not allowed to change this package category."
-msgstr "Δεν σας επιτρέπεται να αλλάξετε την κατηγορία αυτού του πακέτου."
-
-msgid "Package category changed."
-msgstr "Έγινε αλλαγή κατηγορίας πακέτου."
-
 msgid "View packages details for"
 msgstr "Δείτε τις λεπτομέρειες πακέτου για το"
 
@@ -971,12 +953,6 @@ msgstr "Υιοθετήστε το Πακέτο"
 msgid "Disown Package"
 msgstr "Aποδεσμεύστε το Πακέτο"
 
-msgid "Category"
-msgstr "Κατηγορία"
-
-msgid "Change category"
-msgstr "Αλλαγή κατηγορίας"
-
 msgid "Submitter"
 msgstr "Υποβάλλων"
 
diff --git a/po/es.po b/po/es.po
index 5bd7793..60bbbb4 100644
--- a/po/es.po
+++ b/po/es.po
@@ -508,12 +508,6 @@ msgid ""
 msgstr ""
 "Suba sus paquetes fuente aquí. Cree el paquete fuente con «makepkg --source»."
 
-msgid "Package Category"
-msgstr "Categoría del paquete"
-
-msgid "Select Category"
-msgstr "Seleccionar Categoría"
-
 msgid "Upload package file"
 msgstr "Subir archivo del paquete"
 
@@ -755,18 +749,6 @@ msgstr "Comentario borrado."
 msgid "You are not allowed to delete this comment."
 msgstr "No está autorizado a borrar este comentario."
 
-msgid "Missing category ID."
-msgstr "Falta el Identificador de categoría."
-
-msgid "Invalid category ID."
-msgstr "El identificador de categoría no es válido."
-
-msgid "You are not allowed to change this package category."
-msgstr "No puede cambiar la categoría de este paquete."
-
-msgid "Package category changed."
-msgstr "Categoría del paquete cambiada."
-
 msgid "View packages details for"
 msgstr "Ver detalles del paquete para"
 
@@ -973,12 +955,6 @@ msgstr "Adoptar paquete"
 msgid "Disown Package"
 msgstr "Abandonar paquete"
 
-msgid "Category"
-msgstr "Categoría"
-
-msgid "Change category"
-msgstr "Cambiar categoría"
-
 msgid "Submitter"
 msgstr "Primer encargado"
 
diff --git a/po/fi.po b/po/fi.po
index d79c731..7c3a106 100644
--- a/po/fi.po
+++ b/po/fi.po
@@ -478,12 +478,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Paketin kategoria"
-
-msgid "Select Category"
-msgstr "Valitse kategoria"
-
 msgid "Upload package file"
 msgstr "Lähdepaketti:"
 
@@ -712,18 +706,6 @@ msgstr "Kommentti on poistettu."
 msgid "You are not allowed to delete this comment."
 msgstr "Sinulla ei ole oikeuksia tämän kommentin poistamiseen."
 
-msgid "Missing category ID."
-msgstr "Kategorian ID puuttuu."
-
-msgid "Invalid category ID."
-msgstr "Kategorian ID ei ole kelvollinen."
-
-msgid "You are not allowed to change this package category."
-msgstr "Sinulla ei ole oikeuksia tämän paketin kategorian muuttamiseen."
-
-msgid "Package category changed."
-msgstr "Paketin kategoria vaihdettu."
-
 msgid "View packages details for"
 msgstr ""
 
@@ -925,12 +907,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr "Kategoria"
-
-msgid "Change category"
-msgstr "Vaihda kategoriaa"
-
 msgid "Submitter"
 msgstr "Lisääjä"
 
diff --git a/po/fr.po b/po/fr.po
index bc29308..f66f3f5 100644
--- a/po/fr.po
+++ b/po/fr.po
@@ -520,12 +520,6 @@ msgstr ""
 "Envoyez vos paquets source ici. Créez des paquets source avec « makepkg --"
 "source »."
 
-msgid "Package Category"
-msgstr "Catégorie du paquet"
-
-msgid "Select Category"
-msgstr "Sélectionnez une catégorie"
-
 msgid "Upload package file"
 msgstr "Fichier du paquet à transférer"
 
@@ -775,18 +769,6 @@ msgstr "Le commentaire a été supprimé."
 msgid "You are not allowed to delete this comment."
 msgstr "Vous n'êtes pas autorisé(e) à supprimer ce commentaire."
 
-msgid "Missing category ID."
-msgstr "ID de catégorie manquant."
-
-msgid "Invalid category ID."
-msgstr "ID de catégorie non valide."
-
-msgid "You are not allowed to change this package category."
-msgstr "Vous n'êtes pas autorisé à modifier la catégorie de ce paquet."
-
-msgid "Package category changed."
-msgstr "Catégorie du paquet changé."
-
 msgid "View packages details for"
 msgstr "Voir le paquet"
 
@@ -992,12 +974,6 @@ msgstr "Adopter ce paquet"
 msgid "Disown Package"
 msgstr "Destituer le paquet"
 
-msgid "Category"
-msgstr "Catégorie"
-
-msgid "Change category"
-msgstr "Changer de catégorie"
-
 msgid "Submitter"
 msgstr "Contributeur"
 
diff --git a/po/he.po b/po/he.po
index 6ffc077..ab02c47 100644
--- a/po/he.po
+++ b/po/he.po
@@ -455,12 +455,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "קטגוריית חבילה"
-
-msgid "Select Category"
-msgstr "נא לבחור קטגוריה"
-
 msgid "Upload package file"
 msgstr "העלאת קובץ חבילה"
 
@@ -689,18 +683,6 @@ msgstr "הערה נמחקה."
 msgid "You are not allowed to delete this comment."
 msgstr "אין לך הרשאה למחוק הערה זו."
 
-msgid "Missing category ID."
-msgstr ""
-
-msgid "Invalid category ID."
-msgstr "מס׳ הזיהוי של הקטגוריה אינו תקין"
-
-msgid "You are not allowed to change this package category."
-msgstr ""
-
-msgid "Package category changed."
-msgstr ""
-
 msgid "View packages details for"
 msgstr ""
 
@@ -902,12 +884,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr "קטגוריה"
-
-msgid "Change category"
-msgstr ""
-
 msgid "Submitter"
 msgstr ""
 
diff --git a/po/hr.po b/po/hr.po
index 32f61ed..d2a9a83 100644
--- a/po/hr.po
+++ b/po/hr.po
@@ -458,12 +458,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Kategorija paketa"
-
-msgid "Select Category"
-msgstr "Odaberi kategoriju"
-
 msgid "Upload package file"
 msgstr "Šalji datoteku paketa"
 
@@ -692,18 +686,6 @@ msgstr "Komentar je izbrisan."
 msgid "You are not allowed to delete this comment."
 msgstr "Brisanje ovog komentara Vam nije dozvoljeno."
 
-msgid "Missing category ID."
-msgstr ""
-
-msgid "Invalid category ID."
-msgstr "Neispravan ID kategorije."
-
-msgid "You are not allowed to change this package category."
-msgstr ""
-
-msgid "Package category changed."
-msgstr ""
-
 msgid "View packages details for"
 msgstr ""
 
@@ -906,12 +888,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr "Kategorija"
-
-msgid "Change category"
-msgstr ""
-
 msgid "Submitter"
 msgstr ""
 
diff --git a/po/hu.po b/po/hu.po
index 31e6627..a1f87dc 100644
--- a/po/hu.po
+++ b/po/hu.po
@@ -502,12 +502,6 @@ msgstr ""
 "Itt tölthetsz fel forráscsomagokat. Készíts forráscsomagokat a `makepkg --"
 "source` paranccsal."
 
-msgid "Package Category"
-msgstr "Csomagkategória"
-
-msgid "Select Category"
-msgstr "Válassz kategóriát"
-
 msgid "Upload package file"
 msgstr "Csomagfájl feltöltése"
 
@@ -748,18 +742,6 @@ msgstr "Megjegyzés törölve."
 msgid "You are not allowed to delete this comment."
 msgstr "Nem törölheted ezt a megjegyzést."
 
-msgid "Missing category ID."
-msgstr "Hiányzó kategóriaazonosító."
-
-msgid "Invalid category ID."
-msgstr "Érvénytelen kategóriaazonosító."
-
-msgid "You are not allowed to change this package category."
-msgstr "Nem változtathatod meg ennek a csomagnak a kategóriáját."
-
-msgid "Package category changed."
-msgstr "A csomag kategóriája megváltoztatva."
-
 msgid "View packages details for"
 msgstr "Csomag részleteinek megtekintése –"
 
@@ -961,12 +943,6 @@ msgstr "Csomag örökbe fogadása"
 msgid "Disown Package"
 msgstr "Csomag megtagadása"
 
-msgid "Category"
-msgstr "Kategória"
-
-msgid "Change category"
-msgstr "Kategória megváltoztatása"
-
 msgid "Submitter"
 msgstr "Beküldő"
 
diff --git a/po/it.po b/po/it.po
index 07f7688..afb4d5e 100644
--- a/po/it.po
+++ b/po/it.po
@@ -501,12 +501,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Categoria del pacchetto"
-
-msgid "Select Category"
-msgstr "Seleziona la categoria"
-
 msgid "Upload package file"
 msgstr "Pacchetto da inviare"
 
@@ -750,18 +744,6 @@ msgstr "Il commento è stato rimosso."
 msgid "You are not allowed to delete this comment."
 msgstr "Non puoi eliminare questo commento."
 
-msgid "Missing category ID."
-msgstr "Manca l'ID della categoria."
-
-msgid "Invalid category ID."
-msgstr "L'ID della categoria non è valido."
-
-msgid "You are not allowed to change this package category."
-msgstr "Non puoi modificare la categoria di questo pacchetto."
-
-msgid "Package category changed."
-msgstr "La categoria del pacchetto è stata modificata."
-
 msgid "View packages details for"
 msgstr "Visualizza i dettagli dei pacchetti di"
 
@@ -963,12 +945,6 @@ msgstr "Adotta il pacchetto"
 msgid "Disown Package"
 msgstr "Abbandona il pacchetto"
 
-msgid "Category"
-msgstr "Categoria"
-
-msgid "Change category"
-msgstr "Cambia la categoria"
-
 msgid "Submitter"
 msgstr "Contributore"
 
diff --git a/po/ja.po b/po/ja.po
index 1f0614d..9e26089 100644
--- a/po/ja.po
+++ b/po/ja.po
@@ -491,12 +491,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "パッケージカテゴリ"
-
-msgid "Select Category"
-msgstr "カテゴリを選んで下さい"
-
 msgid "Upload package file"
 msgstr "パッケージファイルのアップロード"
 
@@ -734,18 +728,6 @@ msgstr "コメントが削除されました。"
 msgid "You are not allowed to delete this comment."
 msgstr "このコメントを削除することはできません。"
 
-msgid "Missing category ID."
-msgstr "カテゴリ ID がありません。"
-
-msgid "Invalid category ID."
-msgstr "不正なカテゴリ ID です。"
-
-msgid "You are not allowed to change this package category."
-msgstr "このパッケージのカテゴリを変更することはできません。"
-
-msgid "Package category changed."
-msgstr "パッケージのカテゴリが変更されました。"
-
 msgid "View packages details for"
 msgstr "パッケージの詳細を見る"
 
@@ -947,12 +929,6 @@ msgstr "パッケージを承継する"
 msgid "Disown Package"
 msgstr "パッケージの放棄"
 
-msgid "Category"
-msgstr "カテゴリ"
-
-msgid "Change category"
-msgstr "カテゴリの変更"
-
 msgid "Submitter"
 msgstr "投稿者"
 
diff --git a/po/nb.po b/po/nb.po
index 6cd1548..b62dc20 100644
--- a/po/nb.po
+++ b/po/nb.po
@@ -487,12 +487,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Pakkekategori"
-
-msgid "Select Category"
-msgstr "Velg kategori"
-
 msgid "Upload package file"
 msgstr "Last opp pakkefil"
 
@@ -734,18 +728,6 @@ msgstr "Kommentar slettet."
 msgid "You are not allowed to delete this comment."
 msgstr "Du har ikke tilgang til å slette denne kommentaren."
 
-msgid "Missing category ID."
-msgstr "Manglende kategori-ID."
-
-msgid "Invalid category ID."
-msgstr "Ugyldig kategori-ID."
-
-msgid "You are not allowed to change this package category."
-msgstr "Du har ikke tilgang til å endre denne pakkekategorien."
-
-msgid "Package category changed."
-msgstr "Pakkekategori endret."
-
 msgid "View packages details for"
 msgstr "Vis pakkedetaljer for"
 
@@ -947,12 +929,6 @@ msgstr "Adopter pakke"
 msgid "Disown Package"
 msgstr "Gjør foreldreløs"
 
-msgid "Category"
-msgstr "Kategori"
-
-msgid "Change category"
-msgstr "Endre kategori"
-
 msgid "Submitter"
 msgstr "Innsender"
 
diff --git a/po/nl.po b/po/nl.po
index f0e5570..d395034 100644
--- a/po/nl.po
+++ b/po/nl.po
@@ -480,12 +480,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Pakketcategorie"
-
-msgid "Select Category"
-msgstr "Selecteer Categorie"
-
 msgid "Upload package file"
 msgstr "Upload pakket bestand"
 
@@ -730,18 +724,6 @@ msgstr "Comment is verwijderd."
 msgid "You are not allowed to delete this comment."
 msgstr "Je hebt geen toestemming deze comment te verwijderen."
 
-msgid "Missing category ID."
-msgstr "Missende categorie ID."
-
-msgid "Invalid category ID."
-msgstr "Ongeldige categorie ID."
-
-msgid "You are not allowed to change this package category."
-msgstr "Je hebt geen toestemming deze pakketcategorie aan te passen."
-
-msgid "Package category changed."
-msgstr "Pakketcategorie aangepast."
-
 msgid "View packages details for"
 msgstr "Toon pakketdetails voor"
 
@@ -943,12 +925,6 @@ msgstr "Adopteer Pakket"
 msgid "Disown Package"
 msgstr "Onteigen Pakket"
 
-msgid "Category"
-msgstr "Categorie"
-
-msgid "Change category"
-msgstr "Verander categorie"
-
 msgid "Submitter"
 msgstr "Inzender"
 
diff --git a/po/pl.po b/po/pl.po
index d554d6e..a7f3537 100644
--- a/po/pl.po
+++ b/po/pl.po
@@ -498,12 +498,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Kategoria pakietu"
-
-msgid "Select Category"
-msgstr "Wybierz kategorię"
-
 msgid "Upload package file"
 msgstr "Plik do załadowania"
 
@@ -746,18 +740,6 @@ msgstr "Komentarz został usunięty."
 msgid "You are not allowed to delete this comment."
 msgstr "Nie masz uprawnień do usunięcia tego komentarza."
 
-msgid "Missing category ID."
-msgstr "Brakujące ID kategorii."
-
-msgid "Invalid category ID."
-msgstr "Nieprawidłowy identyfikator kategorii."
-
-msgid "You are not allowed to change this package category."
-msgstr "Nie masz uprawnień, by zmienić kategorię tego pakietu."
-
-msgid "Package category changed."
-msgstr "Kategoria pakietu zmieniona."
-
 msgid "View packages details for"
 msgstr "Wyświetl informacje o pakiecie"
 
@@ -960,12 +942,6 @@ msgstr "Przejmij pakiet"
 msgid "Disown Package"
 msgstr "Porzuć pakiet"
 
-msgid "Category"
-msgstr "Kategoria"
-
-msgid "Change category"
-msgstr "Zmień kategorię."
-
 msgid "Submitter"
 msgstr "Nadesłał"
 
diff --git a/po/pt_BR.po b/po/pt_BR.po
index a367a5e..5c091c5 100644
--- a/po/pt_BR.po
+++ b/po/pt_BR.po
@@ -495,12 +495,6 @@ msgid ""
 msgstr ""
 "Envie seus pacotes fonte aqui. Crie pacotes fonte com \"makepkg --source\"."
 
-msgid "Package Category"
-msgstr "Categoria do pacote"
-
-msgid "Select Category"
-msgstr "Selecionar categoria"
-
 msgid "Upload package file"
 msgstr "Enviar o arquivo do pacote"
 
@@ -741,18 +735,6 @@ msgstr "O comentário foi excluído."
 msgid "You are not allowed to delete this comment."
 msgstr "Você não tem permissão para excluir esse comentário."
 
-msgid "Missing category ID."
-msgstr "Faltando ID de categoria."
-
-msgid "Invalid category ID."
-msgstr "ID de categoria inválido."
-
-msgid "You are not allowed to change this package category."
-msgstr "Você não tem permissão para alterar a categoria desse pacote."
-
-msgid "Package category changed."
-msgstr "Categoria do pacote alterada."
-
 msgid "View packages details for"
 msgstr "Ver detalhes de pacotes para"
 
@@ -956,12 +938,6 @@ msgstr "Adotar pacote"
 msgid "Disown Package"
 msgstr "Abandonar pacote"
 
-msgid "Category"
-msgstr "Categoria"
-
-msgid "Change category"
-msgstr "Alterar categoria"
-
 msgid "Submitter"
 msgstr "Criado por"
 
diff --git a/po/pt_PT.po b/po/pt_PT.po
index 9f1e799..52dc87c 100644
--- a/po/pt_PT.po
+++ b/po/pt_PT.po
@@ -491,12 +491,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Categoria do pacote."
-
-msgid "Select Category"
-msgstr "Seleccione a Categoria."
-
 msgid "Upload package file"
 msgstr "Submeter ficheiro de pacote."
 
@@ -740,18 +734,6 @@ msgstr "O comentário foi apagado."
 msgid "You are not allowed to delete this comment."
 msgstr "Não tem permissão para apagar este comentário."
 
-msgid "Missing category ID."
-msgstr "ID de categoria em falta."
-
-msgid "Invalid category ID."
-msgstr "ID de categoria inválido."
-
-msgid "You are not allowed to change this package category."
-msgstr "Não tem permissão para mudar a categoria deste pacote."
-
-msgid "Package category changed."
-msgstr "Categoria do pacote modificada."
-
 msgid "View packages details for"
 msgstr "Ver detalhes do pacote de"
 
@@ -953,12 +935,6 @@ msgstr "Adotar Pacote"
 msgid "Disown Package"
 msgstr "Renunciar Pacote"
 
-msgid "Category"
-msgstr "Categoria"
-
-msgid "Change category"
-msgstr "Mudar categoria"
-
 msgid "Submitter"
 msgstr "Submissor"
 
diff --git a/po/ro.po b/po/ro.po
index b232e5c..721d636 100644
--- a/po/ro.po
+++ b/po/ro.po
@@ -492,12 +492,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Categoria pachetului"
-
-msgid "Select Category"
-msgstr "Selectează categoria"
-
 msgid "Upload package file"
 msgstr "Încarcă pachetul"
 
@@ -743,18 +737,6 @@ msgstr "Comentariul a fost șters."
 msgid "You are not allowed to delete this comment."
 msgstr "Nu ai voie să ștergi acest comentariu."
 
-msgid "Missing category ID."
-msgstr "ID-ul categoriei lipsește."
-
-msgid "Invalid category ID."
-msgstr "ID-ul categoriei nu este valid."
-
-msgid "You are not allowed to change this package category."
-msgstr "Nu ai permisiunea de a schimba categoria acestui pachet."
-
-msgid "Package category changed."
-msgstr "Categoria pachetului a fost schimbată."
-
 msgid "View packages details for"
 msgstr "Vezi detaliile pachetelor pentru"
 
@@ -957,12 +939,6 @@ msgstr "Adoptă pachet"
 msgid "Disown Package"
 msgstr "Abandonează pachet"
 
-msgid "Category"
-msgstr "Categorie"
-
-msgid "Change category"
-msgstr "Schimbă categoria"
-
 msgid "Submitter"
 msgstr "Autor"
 
diff --git a/po/ru.po b/po/ru.po
index 07e12e2..6908c61 100644
--- a/po/ru.po
+++ b/po/ru.po
@@ -493,12 +493,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Категория пакета"
-
-msgid "Select Category"
-msgstr "Выберите категорию"
-
 msgid "Upload package file"
 msgstr "Файл пакета"
 
@@ -738,18 +732,6 @@ msgstr "Комментарий удален."
 msgid "You are not allowed to delete this comment."
 msgstr "У вас нет прав для удаления этого комментария."
 
-msgid "Missing category ID."
-msgstr "Отсутствует идентификатор категории."
-
-msgid "Invalid category ID."
-msgstr "Неверный идентификатор категории."
-
-msgid "You are not allowed to change this package category."
-msgstr "Вам не позволено менять категорию этого пакета."
-
-msgid "Package category changed."
-msgstr "Категория пакета изменилась."
-
 msgid "View packages details for"
 msgstr "Просмотреть информацию о пакете"
 
@@ -954,12 +936,6 @@ msgstr "Усыновить пакет"
 msgid "Disown Package"
 msgstr "Бросить пакет"
 
-msgid "Category"
-msgstr "Категория"
-
-msgid "Change category"
-msgstr "Изменить категорию"
-
 msgid "Submitter"
 msgstr "Автор"
 
diff --git a/po/sk.po b/po/sk.po
index 46b8d67..294de6a 100644
--- a/po/sk.po
+++ b/po/sk.po
@@ -487,12 +487,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Kategória"
-
-msgid "Select Category"
-msgstr "Vyberte kategóriu"
-
 msgid "Upload package file"
 msgstr "Nahraj súbor balíčka"
 
@@ -732,18 +726,6 @@ msgstr "Komentár bol vymazaný."
 msgid "You are not allowed to delete this comment."
 msgstr "Nemáte práva na vymazanie tohto komentára."
 
-msgid "Missing category ID."
-msgstr "Chýba ID kategórie."
-
-msgid "Invalid category ID."
-msgstr "Neplatné ID kategórie."
-
-msgid "You are not allowed to change this package category."
-msgstr "Na zmenu kategórie balíčka nemáte oprávnenie."
-
-msgid "Package category changed."
-msgstr "Kategória balíčka bola zmenená."
-
 msgid "View packages details for"
 msgstr "Pozri detaily balíčky pre"
 
@@ -946,12 +928,6 @@ msgstr "Adoptuj balíček"
 msgid "Disown Package"
 msgstr "Vyvlastni balíček"
 
-msgid "Category"
-msgstr "Kategória"
-
-msgid "Change category"
-msgstr "Zmeniť kategóriu"
-
 msgid "Submitter"
 msgstr "Prispievateľ"
 
diff --git a/po/sr.po b/po/sr.po
index 854a30a..1f570aa 100644
--- a/po/sr.po
+++ b/po/sr.po
@@ -477,12 +477,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Kategorija paketa"
-
-msgid "Select Category"
-msgstr "Izaberite kategoriju"
-
 msgid "Upload package file"
 msgstr "Pošalji fajl paketa"
 
@@ -711,18 +705,6 @@ msgstr "Komentar je obrisan."
 msgid "You are not allowed to delete this comment."
 msgstr "Nije vam dozvoljeno brisanje ovog komentara."
 
-msgid "Missing category ID."
-msgstr "Nedostaje ID kategorije."
-
-msgid "Invalid category ID."
-msgstr "Neispravan ID kategorije."
-
-msgid "You are not allowed to change this package category."
-msgstr "Nemate dozvolu da promenite kategoriju ovog paketa."
-
-msgid "Package category changed."
-msgstr "Kategorija paketa je izmenjena."
-
 msgid "View packages details for"
 msgstr ""
 
@@ -925,12 +907,6 @@ msgstr ""
 msgid "Disown Package"
 msgstr ""
 
-msgid "Category"
-msgstr "Kategorija"
-
-msgid "Change category"
-msgstr "Promeni kategoriju"
-
 msgid "Submitter"
 msgstr "Pošiljalac"
 
diff --git a/po/tr.po b/po/tr.po
index c678d40..abf6978 100644
--- a/po/tr.po
+++ b/po/tr.po
@@ -492,12 +492,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "Paket Kategorisi"
-
-msgid "Select Category"
-msgstr "Kategori Seçin"
-
 msgid "Upload package file"
 msgstr "Paket yükle"
 
@@ -736,18 +730,6 @@ msgstr "Yorum silindi."
 msgid "You are not allowed to delete this comment."
 msgstr "Bu yorumu silme yetkiniz yok."
 
-msgid "Missing category ID."
-msgstr "Kategori kimliği bulunamadı."
-
-msgid "Invalid category ID."
-msgstr "Geçersiz kategori."
-
-msgid "You are not allowed to change this package category."
-msgstr "Bu paket kategorisini değiştirmek için gerekli izne sahip değilsiniz."
-
-msgid "Package category changed."
-msgstr "Paket kategorisi değiştirildi."
-
 msgid "View packages details for"
 msgstr "Paket detaylarını görüntüle"
 
@@ -949,12 +931,6 @@ msgstr "Paketi Sahiplen"
 msgid "Disown Package"
 msgstr "Paket Sahipliğini Bırak"
 
-msgid "Category"
-msgstr "Kategori"
-
-msgid "Change category"
-msgstr "Kategori değiştir"
-
 msgid "Submitter"
 msgstr "Yükleyen"
 
diff --git a/po/uk.po b/po/uk.po
index 8249f77..c5a9761 100644
--- a/po/uk.po
+++ b/po/uk.po
@@ -492,12 +492,6 @@ msgstr ""
 "Тут додайте Ваш джерельний пакунок. Створіть джерельні пакунки за допомогою "
 "команди `makepkg --source`."
 
-msgid "Package Category"
-msgstr "Категорія пакунка"
-
-msgid "Select Category"
-msgstr "Виберіть категорію"
-
 msgid "Upload package file"
 msgstr "Початковий пакунок"
 
@@ -741,18 +735,6 @@ msgstr "Коментар вилучено."
 msgid "You are not allowed to delete this comment."
 msgstr "У вас немає прав, щоб вилучити цей коментар."
 
-msgid "Missing category ID."
-msgstr "Пропущено ідентифікатор категорії."
-
-msgid "Invalid category ID."
-msgstr "Неправильний ідентифікатор категорії."
-
-msgid "You are not allowed to change this package category."
-msgstr "Ви не можете змінити катеогрію цього пакунку."
-
-msgid "Package category changed."
-msgstr "Категорію пакунку змінено."
-
 msgid "View packages details for"
 msgstr "Показати деталі пакунку для "
 
@@ -955,12 +937,6 @@ msgstr "Прийняти пакунок"
 msgid "Disown Package"
 msgstr "Зректися пакунку"
 
-msgid "Category"
-msgstr "Категорія"
-
-msgid "Change category"
-msgstr "Змінити категорію"
-
 msgid "Submitter"
 msgstr "Подавач"
 
diff --git a/po/zh_CN.po b/po/zh_CN.po
index 61d77ab..7069926 100644
--- a/po/zh_CN.po
+++ b/po/zh_CN.po
@@ -470,12 +470,6 @@ msgid ""
 "source`."
 msgstr ""
 
-msgid "Package Category"
-msgstr "软件包类别"
-
-msgid "Select Category"
-msgstr "选择类别"
-
 msgid "Upload package file"
 msgstr "上传软件包文件"
 
@@ -712,18 +706,6 @@ msgstr "评论已被删除。"
 msgid "You are not allowed to delete this comment."
 msgstr "您没有权限删除此评论。"
 
-msgid "Missing category ID."
-msgstr "缺少分类 ID。"
-
-msgid "Invalid category ID."
-msgstr "非法的类别标识"
-
-msgid "You are not allowed to change this package category."
-msgstr "您无权修改此软件包的类别。"
-
-msgid "Package category changed."
-msgstr "软件包分类已更改。"
-
 msgid "View packages details for"
 msgstr "查看软件包详细信息"
 
@@ -924,12 +906,6 @@ msgstr "接管软件包"
 msgid "Disown Package"
 msgstr "弃置软件包"
 
-msgid "Category"
-msgstr "类别"
-
-msgid "Change category"
-msgstr "修改分类"
-
 msgid "Submitter"
 msgstr "提交人"
 
-- 
2.3.1

Attachment: signature.asc
Description: PGP signature

Reply via email to