PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Mohamed Abdulalim   Persistence   tests/Fixtures/MySql/create_global_ordering_table.sql   Download  
File: tests/Fixtures/MySql/create_global_ordering_table.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Persistence
Retrieve database table records by a given order
Author: By
Last change:
Date: 20 days ago
Size: 371 bytes
 

Contents

Class file image Download 
CREATE TABLE `maa_persistence_test_global_ordering` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `display_order` INT NOT NULL,
  `deleted_at` DATETIME NULL DEFAULT NULL,
  `label` VARCHAR(191) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_maa_persistence_test_global_ordering_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci