<?php
/**
 * Database schema and helpers.
 *
 * @package Abstract_One_CRM_Form_Integration
 */

defined( 'ABSPATH' ) || exit;

/**
 * Class AOLI_Database
 */
class AOLI_Database {

	/**
	 * Table name without prefix.
	 */
	const TABLE = 'aoli_workflows';

	/**
	 * Get full table name.
	 *
	 * @return string
	 */
	public static function table_name() {
		global $wpdb;
		return $wpdb->prefix . self::TABLE;
	}

	/**
	 * Create plugin tables on activation.
	 */
	public static function create_tables() {
		global $wpdb;

		$table           = self::table_name();
		$charset_collate = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE {$table} (
			id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
			name varchar(191) NOT NULL DEFAULT '',
			description text NOT NULL,
			form_plugin varchar(20) NOT NULL DEFAULT '',
			form_id varchar(50) NOT NULL DEFAULT '',
			api_key_enc text NOT NULL,
			project_id varchar(50) NOT NULL DEFAULT '',
			campaign_id varchar(50) NOT NULL DEFAULT '',
			sub_source varchar(191) NOT NULL DEFAULT 'Organic',
			field_mapping longtext NOT NULL,
			status varchar(20) NOT NULL DEFAULT 'active',
			created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
			updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			PRIMARY KEY  (id),
			KEY form_lookup (form_plugin, form_id, status)
		) {$charset_collate};";

		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		dbDelta( $sql );

		update_option( 'aoli_db_version', AOLI_VERSION );
	}
}