scratch – Diff between revs 126 and 128
?pathlinks?
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. |