SHA1 Hash:	fb8dc7d07f8e9ac0dda84ee16a1d7b0a5b973f1a
Date:	2008-10-05 13:13:13
User:	drh
Comment:	The UNIQUE constraint on the default TICKET table was wrong. The tkt_uuid column should be unique unto itself, not in combination with tkt_time. Existing servers will need to fix their TICKET implementations using the setup menu. This check-in changes the default.
Timelines:	ancestors | descendants | both | trunk
Other Links:	files | ZIP archive | manifest

• branch=trunk inherited from [a28c83647d]
• sym-trunk inherited from [a28c83647d]

Modified src/schema.c from [73d36a924e] to [cf525ce8ed].

@@ -278,15 +278,29 @@
 @ );
 @ CREATE INDEX tagxref_i1 ON tagxref(tagid, mtime);
 @
 @ -- Template for the TICKET table
 @ --
+@ -- NB: when changing the schema of the TICKET table here, also make the
+@ -- same change in tktsetup.c.
+@ --
 @ CREATE TABLE ticket(
+@   -- Do not change any column that begins with tkt_
 @   tkt_id INTEGER PRIMARY KEY,
-@   tkt_uuid TEXT,
-@   tkt_mtime REAL,
-@   UNIQUE(tkt_uuid, tkt_mtime)
+@   tkt_uuid TEXT UNIQUE,
+@   tkt_mtime DATE,
+@   -- Add as many field as required below this line
+@   type TEXT,
+@   status TEXT,
+@   subsystem TEXT,
+@   priority TEXT,
+@   severity TEXT,
+@   foundin TEXT,
+@   private_contact TEXT,
+@   resolution TEXT,
+@   title TEXT,
+@   comment TEXT
 @ );
 ;
 
 /*
 ** Predefined tagid values

Modified src/tktsetup.c from [a85601ed8a] to [5326eea0e1].

@@ -65,11 +65,11 @@
 /* @-comment: ** */
 static const char zDefaultTicketTable[] =
 @ CREATE TABLE ticket(
 @   -- Do not change any column that begins with tkt_
 @   tkt_id INTEGER PRIMARY KEY,
-@   tkt_uuid TEXT,
+@   tkt_uuid TEXT UNIQUE,
 @   tkt_mtime DATE,
 @   -- Add as many field as required below this line
 @   type TEXT,
 @   status TEXT,
 @   subsystem TEXT,
@@ -77,13 +77,11 @@
 @   severity TEXT,
 @   foundin TEXT,
 @   private_contact TEXT,
 @   resolution TEXT,
 @   title TEXT,
-@   comment TEXT,
-@   -- Do not alter this UNIQUE clause:
-@   UNIQUE(tkt_uuid, tkt_mtime)
+@   comment TEXT
 @ );
 ;
 
 /*
 ** Return the ticket table definition