Changeset 26926

Timestamp:

Feb 12, 2010, 12:09:34 PM (16 years ago)

Author:

bills

Message:

add hide column to dsFileset to allow filesets to be set to invisible
without actually deleting them

Location:

trunk/DataStoreServer/scripts

Files:

• dsprodindex (modified) (1 diff)
• tabledefs.sql (modified) (1 diff)

trunk/DataStoreServer/scripts/dsprodindex

@@ -80 +80 @@
 }
         
-$stmt = $dbh->prepare("SELECT * FROM dsFileset WHERE prod_id = $prod_id  $after_clause ORDER BY fileset_id");
+$stmt = $dbh->prepare("SELECT * FROM dsFileset WHERE prod_id = $prod_id AND hide = 0  $after_clause ORDER BY fileset_id");
 $stmt->execute();
 

trunk/DataStoreServer/scripts/tabledefs.sql

@@ -30 +30 @@
     fileset_name VARCHAR(64) NOT NULL,
     reg_time    datetime NOT NULL,
+    hide        TINYINT DEFAULT 0,
     type        VARCHAR(64),
     prod_col_0  VARCHAR(64),        # values for product specific columns