--- viewvc-1.1.1/bin/make-database.tools	2009-03-18 17:45:10.000000000 +0100
+++ viewvc-1.1.1/bin/make-database	2009-06-05 11:11:19.000000000 +0200
@@ -46,15 +46,15 @@
 CREATE TABLE checkins (
   type enum('Change','Add','Remove'),
   ci_when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  whoid mediumint(9) DEFAULT '0' NOT NULL,
-  repositoryid mediumint(9) DEFAULT '0' NOT NULL,
-  dirid mediumint(9) DEFAULT '0' NOT NULL,
-  fileid mediumint(9) DEFAULT '0' NOT NULL,
+  whoid mediumint(9)  NOT NULL,
+  repositoryid mediumint(9)  NOT NULL,
+  dirid mediumint(9)  NOT NULL,
+  fileid mediumint(9)  NOT NULL,
   revision varchar(32) binary DEFAULT '' NOT NULL,
   stickytag varchar(255) binary DEFAULT '' NOT NULL,
-  branchid mediumint(9) DEFAULT '0' NOT NULL,
-  addedlines int(11) DEFAULT '0' NOT NULL,
-  removedlines int(11) DEFAULT '0' NOT NULL,
+  branchid mediumint(9)  NOT NULL,
+  addedlines int(11)  NOT NULL,
+  removedlines int(11)  NOT NULL,
   descid mediumint(9),
   UNIQUE repositoryid (repositoryid,dirid,fileid,revision),
   KEY ci_when (ci_when),
@@ -69,7 +69,7 @@
 CREATE TABLE descs (
   id mediumint(9) NOT NULL auto_increment,
   description text,
-  hash bigint(20) DEFAULT '0' NOT NULL,
+  hash bigint(20)  NOT NULL,
   PRIMARY KEY (id),
   KEY hash (hash)
 ) TYPE=MyISAM;
@@ -108,10 +108,10 @@
 
 DROP TABLE IF EXISTS tags;
 CREATE TABLE tags (
-  repositoryid mediumint(9) DEFAULT '0' NOT NULL,
-  branchid mediumint(9) DEFAULT '0' NOT NULL,
-  dirid mediumint(9) DEFAULT '0' NOT NULL,
-  fileid mediumint(9) DEFAULT '0' NOT NULL,
+  repositoryid mediumint(9)  NOT NULL,
+  branchid mediumint(9)  NOT NULL,
+  dirid mediumint(9)  NOT NULL,
+  fileid mediumint(9)  NOT NULL,
   revision varchar(32) binary DEFAULT '' NOT NULL,
   UNIQUE repositoryid (repositoryid,dirid,fileid,branchid,revision),
   KEY repositoryid_2 (repositoryid),