get_charset_collate(); $table_applications = $wpdb->prefix . 'axilweb_ajl_applications'; $schema_jobs = "CREATE TABLE IF NOT EXISTS `$table_applications` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `job_id` int UNSIGNED NOT NULL, `process_id` int UNSIGNED NOT NULL, `previous_process_id` int UNSIGNED NULL, `is_read` int UNSIGNED NOT NULL DEFAULT '0', `created_at` datetime NULL, `created_by` int UNSIGNED NOT NULL, `updated_at` datetime NULL, `updated_by` int UNSIGNED NULL, `deleted_at` datetime NULL, `deleted_by` int UNSIGNED NULL, PRIMARY KEY (`id`), KEY `job_id` (`job_id`), KEY `process_id` (`process_id`), KEY `created_by` (`created_by`), KEY `updated_by` (`updated_by`), KEY `deleted_by` (`deleted_by`) ) $charset_collate"; // Create the tables. dbDelta( $schema_jobs ); } }