From ac4b1523cdb6cf2dbdbdea60196ffbd84ffc7a45 Mon Sep 17 00:00:00 2001 From: Ian Beckwith Date: Tue, 19 Oct 2010 21:16:35 +0100 Subject: [PATCH] reverse default sort order in schema --- lib/ID3FS/DB.pm | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/lib/ID3FS/DB.pm b/lib/ID3FS/DB.pm index a776653..909d7f1 100644 --- a/lib/ID3FS/DB.pm +++ b/lib/ID3FS/DB.pm @@ -528,19 +528,19 @@ CREATE TABLE id3fs ( CREATE TABLE paths ( id INTEGER, name text, - PRIMARY KEY(id DESC) + PRIMARY KEY(id ASC) ); CREATE TABLE artists ( id INTEGER, name text, - PRIMARY KEY(id DESC) + PRIMARY KEY(id ASC) ); CREATE TABLE albums ( id INTEGER, name text, - PRIMARY KEY(id DESC) + PRIMARY KEY(id ASC) ); CREATE TABLE files ( @@ -549,7 +549,7 @@ CREATE TABLE files ( artists_id, albums_id, paths_id, - PRIMARY KEY(id DESC), + PRIMARY KEY(id ASC), FOREIGN KEY(artists_id) REFERENCES artists(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY(albums_id) REFERENCES albums(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY(paths_id) REFERENCES paths(id) ON DELETE CASCADE ON UPDATE CASCADE @@ -559,7 +559,7 @@ CREATE TABLE tags ( id INTEGER, parents_id INTEGER, name text, - PRIMARY KEY(id DESC) + PRIMARY KEY(id ASC) ); CREATE TABLE files_x_tags ( -- 2.11.0