HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Search
-
Re: Issue when creating multi-column Indexes using Vanilla's Database Class
-
Re: Issue when creating multi-column Indexes using Vanilla's Database Class
Looking at the code .... protected function _IndexSql($Columns, $KeyType = FALSE) { $Result = array(); $Keys = array(); $Prefixes = array('key' => 'FK_', 'index' => 'IX_', 'unique' => 'UX_', 'fulltext' => 'TX_'); // Gather the names of the columns. foreach ($Columns as $ColumnName => $Column) { $ColumnKeyTypes =… -
Issue when creating multi-column Indexes using Vanilla's Database Class
I was working with Vanilla's Database Class to create some tables for my plugin, and I noticed two issues in the mechanism that builds DDL statements. 1- It doesn't allow to create multi-column Indexes. I followed the code that applies schema changes (namely Gdn_MySQLStructure->_Create()) and I noticed there's no way to… -
Re: Issue when creating multi-column Indexes using Vanilla's Database Class
We've recently added the ability to create indexes on multiple keys. You use the following notation: Gdn::Structure() ->Table('MyTable') ->PrimaryKey('MyTableID') ->Column('SomeUniqueField', 'int', FALSE, 'unique') ->Column('FirstName', 'varchar(100)', FALSE, 'index.1') ->Column('LastName', 'varchar(100)', FALSE,…
4 results