Lines Matching full:create
36 * - CREATE TABLE/INDEX/TRIGGER/VIEW SQL
64 * Upgrade SQL for the cache DB is simple: drop everything, create
68 * Upgrade SQL for the persistent DB is simple: drop the indexes, create
71 * tables, create the latest schema, restore the data from the temp.
93 "CREATE TABLE idmap_cache (" \
107 "CREATE TABLE idmap_cache " \
124 "CREATE TABLE idmap_cache " \
149 "CREATE UNIQUE INDEX idmap_cache_sid_w2u ON idmap_cache" \
153 "CREATE UNIQUE INDEX idmap_cache_sid_w2u ON idmap_cache" \
157 "CREATE UNIQUE INDEX idmap_cache_pid_u2w ON idmap_cache" \
161 "CREATE TRIGGER idmap_cache_tolower_name_insert " \
169 "CREATE TRIGGER idmap_cache_tolower_name_update " \
177 "CREATE TABLE name_cache (" \
188 "CREATE TABLE name_cache (" \
198 "CREATE TRIGGER name_cache_tolower_name_insert " \
206 "CREATE TRIGGER name_cache_tolower_name_update " \
214 "CREATE UNIQUE INDEX name_cache_sid ON name_cache" \
218 "CREATE UNIQUE INDEX name_cache_name ON name_cache" \
281 "CREATE TABLE namerules (" \
305 "CREATE TABLE namerules " \
309 "CREATE UNIQUE INDEX namerules_w2u ON namerules" \
313 "CREATE UNIQUE INDEX namerules_w2u ON namerules" \
317 "CREATE UNIQUE INDEX namerules_u2w ON namerules" \
327 "CREATE TRIGGER namerules_tolower_name_insert " \
332 "CREATE TRIGGER namerules_tolower_name_update " \
350 "CREATE TRIGGER namerules_unique_insert " \
356 "CREATE TRIGGER namerules_unique_update " \
389 "CREATE TABLE namerules_new " TABLE_NAMERULES_BODY ";" \