From b9a51c9ae80bee161ac076ffa48eda79b862ccbe Mon Sep 17 00:00:00 2001
From: blundellc <blundellc@edb9625f-4e0d-4859-8d74-9fd3b1da38cb>
Date: Sun, 21 Jun 2009 15:55:10 +0000
Subject: [PATCH] default values in blacklist table

git-svn-id: svn://svn.r-forge.r-project.org/svnroot/cran2deb@251 edb9625f-4e0d-4859-8d74-9fd3b1da38cb
---
 trunk/R/db.R | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/trunk/R/db.R b/trunk/R/db.R
index 2ebd756..a1c47cb 100644
--- a/trunk/R/db.R
+++ b/trunk/R/db.R
@@ -70,11 +70,11 @@ db_start <- function() {
     if (!dbExistsTable(con,'blacklist_packages')) {
         dbGetQuery(con,paste('CREATE TABLE blacklist_packages ('
                   ,' package TEXT PRIMARY KEY NOT NULL '
-                  ,',nonfree INTEGER NOT NULL '
-                  ,',obsolete INTEGER NOT NULL '
-                  ,',broken_dependency INTEGER NOT NULL '
-                  ,',unsatisfied_dependency INTEGER NOT NULL '
-                  ,',breaks_cran2deb INTEGER NOT NULL '
+                  ,',nonfree INTEGER NOT NULL DEFAULT 0'
+                  ,',obsolete INTEGER NOT NULL DEFAULT 0'
+                  ,',broken_dependency INTEGER NOT NULL DEFAULT 0'
+                  ,',unsatisfied_dependency INTEGER NOT NULL DEFAULT 0'
+                  ,',breaks_cran2deb INTEGER NOT NULL DEFAULT 0'
                   ,',explanation TEXT NOT NULL '
                   ,')'))
     }
-- 
2.39.5