<?php

namespace Linksy\SearchAndReplace;

/**
 * Migration version 1
 * @param string $collate
 * 
 * @return array CREATE TABLE SQL statements
 */
return function (string $collate) {
    global $wpdb;
    return ["CREATE TABLE {$wpdb->prefix}example_table (\n            id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\n            batch INT(20) NOT NULL,\n            pointer DATETIME NOT NULL,\n            processed INT(11) NOT NULL DEFAULT '0',\n            failed INT(11) NOT NULL DEFAULT '0',\n            date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n            PRIMARY KEY  (id)\n        ) {$collate};"];
};
