• This script is to create a database table named "flagtick_locations" if it doesn't exist, insert predefined data into the table, and flush the rewrite rules.

$sql = "CREATE TABLE flagtick_locations (
   `id` bigint NOT NULL AUTO_INCREMENT,
   `name` varchar(20) DEFAULT NULL,
   `address` varchar(255) NOT NULL,
   `longitude` varchar(255) NOT NULL,
   `latitude` varchar(20) DEFAULT NULL,
   `is_status` varchar(50) DEFAULT NULL,
   `is_editable` tinyint NOT NULL DEFAULT '0',
   `full_text` text,
   `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
)";

global $wpdb;

$createTable = $wpdb->prepare($sql);
$wpdb->query($createTable);

• You can use INSERT command to update sample data after create table successfully.

$addData = $wpdb->prepare("INSERT INTO flagtick_locations
                                   (name, address) VALUES
                                   ('First Location', '123 Main Street'),
                                   ('Second Location', '456 Main Street')");
$wpdb->query($addData);