2 namespace App\Test\Fixture;
4 use Cake\TestSuite\Fixture\TestFixture;
7 * CategoriesLocationsFixture
10 class CategoriesLocationsFixture extends TestFixture
18 // @codingStandardsIgnoreStart
20 'id' => ['type' => 'integer', 'length' => 11, 'unsigned' => true, 'null' => false, 'default' => null, 'comment' => '', 'autoIncrement' => true, 'precision' => null],
21 'location_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => true, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
22 'category_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => true, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
23 'created' => ['type' => 'datetime', 'length' => null, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null],
24 'modified' => ['type' => 'datetime', 'length' => null, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null],
26 'location_id' => ['type' => 'index', 'columns' => ['location_id'], 'length' => []],
27 'category_id' => ['type' => 'index', 'columns' => ['category_id'], 'length' => []],
30 'primary' => ['type' => 'primary', 'columns' => ['id'], 'length' => []],
31 'categories_locations_ibfk_1' => ['type' => 'foreign', 'columns' => ['location_id'], 'references' => ['locations', 'id'], 'update' => 'restrict', 'delete' => 'restrict', 'length' => []],
32 'categories_locations_ibfk_2' => ['type' => 'foreign', 'columns' => ['category_id'], 'references' => ['categories', 'id'], 'update' => 'restrict', 'delete' => 'restrict', 'length' => []],
36 'collation' => 'utf8_general_ci'
39 // @codingStandardsIgnoreEnd
51 'created' => '2017-05-01 18:36:01',
52 'modified' => '2017-05-01 18:36:01'