示例#1
0
        public static void CreateIndexIfNotExists(this sqlite3 db, string table, string column)
        {
            var exists = TableColumnExists(db, table, column);

            if (exists)
            {
                return;
            }

            var query = $"CREATE INDEX IF NOT EXISTS {table}_{column} ON {table}({column})";

            db.Execute(query);
        }