[pkg-bioc] svn commit r346 r346 - /branches/tools-ng/database_schema

[psychedelys-guest at users.alioth.debian.org]

Author: psychedelys-guest
Date: Sat Oct 13 14:35:10 2007
New Revision: 346

URL: http://svn.debian.org/wsvn/pkg-bioc/?sc=1&rev=346
Log:
updated the schema

Modified:
    branches/tools-ng/database_schema

Modified: branches/tools-ng/database_schema
URL: http://svn.debian.org/wsvn/pkg-bioc/branches/tools-ng/database_schema?rev=346&op=diff
==============================================================================
--- branches/tools-ng/database_schema (original)
+++ branches/tools-ng/database_schema Sat Oct 13 14:35:10 2007
@@ -7,7 +7,7 @@
 # I will not used sqlite.... 
  
 schema should work under mysql && postgresql, still in draft mode.
-TODO : rename some COLUMN to a more english native name....
+TODO : rename some COLUMN to a more native english name....
 
 # Howto support the any category ?
 CREATE TABLE IF NOT EXISTS architectures (
@@ -80,7 +80,8 @@ CREATE TABLE IF NOT EXISTS cannotbuild (
 
 # updated during r_pkg_ordering.
 # parsing all the Descriptions file.
-# status:  'error'|'clean'|'unclean' 
+# status: 'unknown'|'error'|'clean'|'unclean' 
+#            unknown : just inserted the package, status is unknown
 #            error : something happen before which block the package from being buildable.
 #            clean : everything goes without problem, parsed dependencies,....
 #            unclean: something happen during the parsing, check the log to see what
@@ -98,7 +99,7 @@ CREATE TABLE IF NOT EXISTS packages (
     URL TEXT,
     biocViews TEXT,
     isBinary BOOLEAN,
-    status ENUM('error','clean','unclean'),
+    status ENUM('unknown','error','clean','unclean'),
     FOREIGN KEY (id) REFERENCES packagesupdate(id)
 )