Differences From:

File tools/cvs2fossil/lib/c2f_pcollrev.tcl part of check-in [808fbc4745] - Added comments explaining the select statement checking revision/file/project/metadata integrity by aku on 2007-12-08 02:59:09. [view]

To:

File tools/cvs2fossil/lib/c2f_pcollrev.tcl part of check-in [6809145eb1] - More comments on sql statements. by aku on 2008-01-19 06:07:49. [view]

@@ -248,12 +248,12 @@
 	    UNIQUE (name)
 	    UNIQUE (plural)
 	}
 	state run {
-	    INSERT INTO symtype VALUES (0,'excluded', 'excluded');
-	    INSERT INTO symtype VALUES (1,'tag',      'tags');
-	    INSERT INTO symtype VALUES (2,'branch',   'branches');
-	    INSERT INTO symtype VALUES (3,'undefined','undefined');
+	    INSERT INTO symtype VALUES (0,'excluded', 'excluded');  -- The ids are the fixed
+	    INSERT INTO symtype VALUES (1,'tag',      'tags');      -- pieces, see project::sym,
+	    INSERT INTO symtype VALUES (2,'branch',   'branches');  -- getsymtypes and associated
+	    INSERT INTO symtype VALUES (3,'undefined','undefined'); -- typevariables.
 	}
 
 	state extend meta {
 	    -- Meta data of revisions. See revision.mid for the
@@ -286,15 +286,15 @@
 	# Authors and commit messages are fully global, i.e. per
 	# repository.
 
 	state extend author {
-	    aid  INTEGER  NOT NULL  PRIMARY KEY  AUTOINCREMENT,
-	    name TEXT     NOT NULL  UNIQUE
+	    aid  INTEGER  NOT NULL  PRIMARY KEY  AUTOINCREMENT, -- Pool of the unique
+	    name TEXT     NOT NULL  UNIQUE                      -- author names.
 	}
 
 	state extend cmessage {
-	    cid  INTEGER  NOT NULL  PRIMARY KEY  AUTOINCREMENT,
-	    text TEXT     NOT NULL  UNIQUE
+	    cid  INTEGER  NOT NULL  PRIMARY KEY  AUTOINCREMENT, -- Pool of the unique
+	    text TEXT     NOT NULL  UNIQUE                      -- log messages
 	}
 
 	project::sym getsymtypes
 	file::rev    getopcodes