internal static void ToIntPtr(SQLiteIndex index, IntPtr pIndex, bool includeInput)
        {
            if (index == null)
            {
                return;
            }
            SQLiteIndexOutputs outputs = index.Outputs;

            if (outputs == null)
            {
                return;
            }
            SQLiteIndexConstraintUsage[] constraintUsages = outputs.ConstraintUsages;
            if (constraintUsages == null)
            {
                return;
            }
            SQLiteIndexInputs inputs = null;

            SQLiteIndexConstraint[] constraints = null;
            SQLiteIndexOrderBy[]    orderBys    = null;
            if (includeInput)
            {
                inputs = index.Inputs;
                if (inputs == null)
                {
                    return;
                }
                constraints = inputs.Constraints;
                if (constraints == null)
                {
                    return;
                }
                orderBys = inputs.OrderBys;
                if (orderBys == null)
                {
                    return;
                }
            }
            if (pIndex == IntPtr.Zero)
            {
                return;
            }
            int num  = 0;
            int num1 = SQLiteMarshal.ReadInt32(pIndex, num);

            if (includeInput && num1 != (int)constraints.Length)
            {
                return;
            }
            if (num1 != (int)constraintUsages.Length)
            {
                return;
            }
            num = SQLiteMarshal.NextOffsetOf(num, 4, IntPtr.Size);
            if (includeInput)
            {
                IntPtr intPtr = SQLiteMarshal.ReadIntPtr(pIndex, num);
                int    num2   = Marshal.SizeOf(typeof(UnsafeNativeMethods.sqlite3_index_constraint));
                for (int i = 0; i < num1; i++)
                {
                    UnsafeNativeMethods.sqlite3_index_constraint sqlite3IndexConstraint = new UnsafeNativeMethods.sqlite3_index_constraint(constraints[i]);
                    Marshal.StructureToPtr(sqlite3IndexConstraint, SQLiteMarshal.IntPtrForOffset(intPtr, i * num2), false);
                }
            }
            num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, 4);
            int num3 = (includeInput ? SQLiteMarshal.ReadInt32(pIndex, num) : 0);

            if (includeInput && num3 != (int)orderBys.Length)
            {
                return;
            }
            num = SQLiteMarshal.NextOffsetOf(num, 4, IntPtr.Size);
            if (includeInput)
            {
                IntPtr intPtr1 = SQLiteMarshal.ReadIntPtr(pIndex, num);
                int    num4    = Marshal.SizeOf(typeof(UnsafeNativeMethods.sqlite3_index_orderby));
                for (int j = 0; j < num3; j++)
                {
                    UnsafeNativeMethods.sqlite3_index_orderby sqlite3IndexOrderby = new UnsafeNativeMethods.sqlite3_index_orderby(orderBys[j]);
                    Marshal.StructureToPtr(sqlite3IndexOrderby, SQLiteMarshal.IntPtrForOffset(intPtr1, j * num4), false);
                }
            }
            num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, IntPtr.Size);
            IntPtr intPtr2 = SQLiteMarshal.ReadIntPtr(pIndex, num);
            int    num5    = Marshal.SizeOf(typeof(UnsafeNativeMethods.sqlite3_index_constraint_usage));

            for (int k = 0; k < num1; k++)
            {
                UnsafeNativeMethods.sqlite3_index_constraint_usage sqlite3IndexConstraintUsage = new UnsafeNativeMethods.sqlite3_index_constraint_usage(constraintUsages[k]);
                Marshal.StructureToPtr(sqlite3IndexConstraintUsage, SQLiteMarshal.IntPtrForOffset(intPtr2, k * num5), false);
            }
            num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, 4);
            SQLiteMarshal.WriteInt32(pIndex, num, outputs.IndexNumber);
            num = SQLiteMarshal.NextOffsetOf(num, 4, IntPtr.Size);
            SQLiteMarshal.WriteIntPtr(pIndex, num, SQLiteString.Utf8IntPtrFromString(outputs.IndexString));
            num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, 4);
            SQLiteMarshal.WriteInt32(pIndex, num, (outputs.NeedToFreeIndexString != 0 ? outputs.NeedToFreeIndexString : 1));
            num = SQLiteMarshal.NextOffsetOf(num, 4, 4);
            SQLiteMarshal.WriteInt32(pIndex, num, outputs.OrderByConsumed);
            num = SQLiteMarshal.NextOffsetOf(num, 4, 8);
            if (outputs.EstimatedCost.HasValue)
            {
                SQLiteMarshal.WriteDouble(pIndex, num, outputs.EstimatedCost.GetValueOrDefault());
            }
            num = SQLiteMarshal.NextOffsetOf(num, 8, 8);
            if (outputs.CanUseEstimatedRows() && outputs.EstimatedRows.HasValue)
            {
                SQLiteMarshal.WriteInt64(pIndex, num, outputs.EstimatedRows.GetValueOrDefault());
            }
            num = SQLiteMarshal.NextOffsetOf(num, 8, 4);
            if (outputs.CanUseIndexFlags() && outputs.IndexFlags.HasValue)
            {
                SQLiteMarshal.WriteInt32(pIndex, num, (int)outputs.IndexFlags.GetValueOrDefault());
            }
            num = SQLiteMarshal.NextOffsetOf(num, 4, 8);
            if (outputs.CanUseColumnsUsed() && outputs.ColumnsUsed.HasValue)
            {
                SQLiteMarshal.WriteInt64(pIndex, num, outputs.ColumnsUsed.GetValueOrDefault());
            }
        }
        internal static void FromIntPtr(IntPtr pIndex, bool includeOutput, ref SQLiteIndex index)
        {
            if (pIndex == IntPtr.Zero)
            {
                return;
            }
            int num  = 0;
            int num1 = SQLiteMarshal.ReadInt32(pIndex, num);

            num = SQLiteMarshal.NextOffsetOf(num, 4, IntPtr.Size);
            IntPtr intPtr = SQLiteMarshal.ReadIntPtr(pIndex, num);

            num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, 4);
            int num2 = SQLiteMarshal.ReadInt32(pIndex, num);

            num = SQLiteMarshal.NextOffsetOf(num, 4, IntPtr.Size);
            IntPtr intPtr1 = SQLiteMarshal.ReadIntPtr(pIndex, num);
            IntPtr zero    = IntPtr.Zero;

            if (includeOutput)
            {
                num  = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, IntPtr.Size);
                zero = SQLiteMarshal.ReadIntPtr(pIndex, num);
            }
            index = new SQLiteIndex(num1, num2);
            SQLiteIndexInputs inputs = index.Inputs;

            if (inputs == null)
            {
                return;
            }
            SQLiteIndexConstraint[] constraints = inputs.Constraints;
            if (constraints == null)
            {
                return;
            }
            SQLiteIndexOrderBy[] orderBys = inputs.OrderBys;
            if (orderBys == null)
            {
                return;
            }
            Type type = typeof(UnsafeNativeMethods.sqlite3_index_constraint);
            int  num3 = Marshal.SizeOf(type);

            for (int i = 0; i < num1; i++)
            {
                IntPtr intPtr2 = SQLiteMarshal.IntPtrForOffset(intPtr, i * num3);
                UnsafeNativeMethods.sqlite3_index_constraint structure = (UnsafeNativeMethods.sqlite3_index_constraint)Marshal.PtrToStructure(intPtr2, type);
                constraints[i] = new SQLiteIndexConstraint(structure);
            }
            Type type1 = typeof(UnsafeNativeMethods.sqlite3_index_orderby);
            int  num4  = Marshal.SizeOf(type1);

            for (int j = 0; j < num2; j++)
            {
                IntPtr intPtr3 = SQLiteMarshal.IntPtrForOffset(intPtr1, j * num4);
                UnsafeNativeMethods.sqlite3_index_orderby sqlite3IndexOrderby = (UnsafeNativeMethods.sqlite3_index_orderby)Marshal.PtrToStructure(intPtr3, type1);
                orderBys[j] = new SQLiteIndexOrderBy(sqlite3IndexOrderby);
            }
            if (includeOutput)
            {
                SQLiteIndexOutputs outputs = index.Outputs;
                if (outputs == null)
                {
                    return;
                }
                SQLiteIndexConstraintUsage[] constraintUsages = outputs.ConstraintUsages;
                if (constraintUsages == null)
                {
                    return;
                }
                Type type2 = typeof(UnsafeNativeMethods.sqlite3_index_constraint_usage);
                int  num5  = Marshal.SizeOf(type2);
                for (int k = 0; k < num1; k++)
                {
                    IntPtr intPtr4 = SQLiteMarshal.IntPtrForOffset(zero, k * num5);
                    UnsafeNativeMethods.sqlite3_index_constraint_usage sqlite3IndexConstraintUsage = (UnsafeNativeMethods.sqlite3_index_constraint_usage)Marshal.PtrToStructure(intPtr4, type2);
                    constraintUsages[k] = new SQLiteIndexConstraintUsage(sqlite3IndexConstraintUsage);
                }
                num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, 4);
                outputs.IndexNumber = SQLiteMarshal.ReadInt32(pIndex, num);
                num = SQLiteMarshal.NextOffsetOf(num, 4, IntPtr.Size);
                outputs.IndexString = SQLiteString.StringFromUtf8IntPtr(SQLiteMarshal.ReadIntPtr(pIndex, num));
                num = SQLiteMarshal.NextOffsetOf(num, IntPtr.Size, 4);
                outputs.NeedToFreeIndexString = SQLiteMarshal.ReadInt32(pIndex, num);
                num = SQLiteMarshal.NextOffsetOf(num, 4, 4);
                outputs.OrderByConsumed = SQLiteMarshal.ReadInt32(pIndex, num);
                num = SQLiteMarshal.NextOffsetOf(num, 4, 8);
                outputs.EstimatedCost = new double?(SQLiteMarshal.ReadDouble(pIndex, num));
                num = SQLiteMarshal.NextOffsetOf(num, 8, 8);
                if (outputs.CanUseEstimatedRows())
                {
                    outputs.EstimatedRows = new long?(SQLiteMarshal.ReadInt64(pIndex, num));
                }
                num = SQLiteMarshal.NextOffsetOf(num, 8, 4);
                if (outputs.CanUseIndexFlags())
                {
                    outputs.IndexFlags = new SQLiteIndexFlags?((SQLiteIndexFlags)SQLiteMarshal.ReadInt32(pIndex, num));
                }
                num = SQLiteMarshal.NextOffsetOf(num, 4, 8);
                if (outputs.CanUseColumnsUsed())
                {
                    outputs.ColumnsUsed = new long?(SQLiteMarshal.ReadInt64(pIndex, num));
                }
            }
        }