[pkg-bioc] svn commit r346 r346 - /branches/tools-ng/database_schema
psychedelys-guest at users.alioth.debian.org
psychedelys-guest at users.alioth.debian.org
Sat Oct 13 14:35:10 UTC 2007
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)
)
More information about the pkg-bioc-devel
mailing list