[tracker] Remove unused sqlite-user-data.sql



commit d4a2414e6369c8bbbebbe7d6d298703f1af13420
Author: Jürg Billeter <j bitron ch>
Date:   Wed Apr 15 15:41:45 2009 +0200

    Remove unused sqlite-user-data.sql
---
 data/db/Makefile.am          |    3 +--
 data/db/sqlite-user-data.sql |   24 ------------------------
 2 files changed, 1 insertions(+), 26 deletions(-)

diff --git a/data/db/Makefile.am b/data/db/Makefile.am
index fe56065..6cf05db 100644
--- a/data/db/Makefile.am
+++ b/data/db/Makefile.am
@@ -12,7 +12,6 @@ config_DATA =				\
 	sqlite-service-types.sql 	\
 	sqlite-stored-procs.sql 	\
 	sqlite-tracker.sql 		\
-	sqlite-tracker-triggers.sql 	\
-	sqlite-user-data.sql 		
+	sqlite-tracker-triggers.sql
 
 EXTRA_DIST = $(config_DATA)
diff --git a/data/db/sqlite-user-data.sql b/data/db/sqlite-user-data.sql
deleted file mode 100644
index 83bddfa..0000000
--- a/data/db/sqlite-user-data.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-/* basic info for a user defined file or service object */
-CREATE TABLE  UserServices
-(
-	ID            		Integer primary key not null,
-	Path 			Text  not null, 
-	Name	 		Text, 
-
-    	unique (Path, Name)
-
-);
-
-
-
-/* de-normalised metadata which is unprocessed (not normalized or casefolded) for display only - never used for searching */
-CREATE TABLE  UserMetaDataDisplay 
-(
-	ServiceID		Integer not null,
-	MetaDataID 		Integer  not null,
-	UserValue		Text,
-	Length			Integer.	
-	
-	primary key (ServiceID, MetaDataID)
-);
-



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]