65d4e214bd753220cd3f1b9700f107ef1ae648da
chmalee
  Fri May 24 09:36:42 2024 -0700
Make hubSpace autoSql files, haven't created the table yet

diff --git src/hg/lib/hubSpace.sql src/hg/lib/hubSpace.sql
new file mode 100644
index 0000000..695a284
--- /dev/null
+++ src/hg/lib/hubSpace.sql
@@ -0,0 +1,26 @@
+# hubSpace.sql was originally generated by the autoSql program, which also 
+# generated hubSpace.c and hubSpace.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#file storage table for users to store uploaded tracks
+CREATE TABLE hubSpace (
+    userName varchar(255) not null,	# userName of user uploading file
+    fileName longblob not null,	# name of uploaded files. The actual path to this file is different
+    fileSize bigint not null,	# size of the uploaded file
+    fileType varchar(255) not null,	# track type of file
+    creationTime timestamp,	# first upload time
+    lastModified timestamp,	# last change time
+    hubNameList longblob,	# comma separated list of hubs this file is a part of
+    db varchar(255) not null,	# genome assembly associated with this file
+    location longblob not null,	# file system path or URL to file
+              #Indices
+    PRIMARY KEY(userName, fileName(25)),
+    INDEX(userName),
+    INDEX(fileName(25)),
+    INDEX(fileType),
+    INDEX(db),
+    INDEX(location(25)),
+    INDEX(creationTime),
+    INDEX(lastModified)
+);