scratch – Diff between revs 126 and 128

Subversion Repositories:
Rev:
Show entire file – Ignore whitespace
Rev 126 Rev 128
Line 103... Line 103...
103 try { 103 try {
Line 104... Line 104...
104 104
Line 105... Line 105...
105 $db->beginTransaction(); 105 $db->beginTransaction();
106 106
Line 107... Line 107...
107 ## Create tags table if it does not exist. 107 ## Create tags table if it does not exist.
108 $db->query('CREATE TABLE IF NOT EXISTS "tags" ("hash" text NOT NULL COLLATE NOCASE, "tag" text COLLATE NOCASE)'); 108 $db->query('CREATE TABLE IF NOT EXISTS "tags" ("hash" text NOT NULL COLLATE NOCASE, "tag" text COLLATE NOCASE, UNIQUE("hash", "tag") ON CONFLICT REPLACE)');
109 109
110 ## Now add all the tags. 110 ## Now add all the tags.