/** * Supplier Profiles Table * * @return string */ public static function supplier_profiles_table() { global $wpdb; return $wpdb->prefix . 'hqsh_supplier_profiles'; } /** * Create Supplier Profiles Table */ public static function create_supplier_profiles_table() { global $wpdb; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; $table_name = self::supplier_profiles_table(); $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE {$table_name} ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT(20) UNSIGNED NOT NULL, company_name VARCHAR(255) NOT NULL, company_logo BIGINT(20) UNSIGNED DEFAULT NULL, contact_person VARCHAR(255) DEFAULT NULL, phone VARCHAR(30) DEFAULT NULL, whatsapp VARCHAR(30) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, website VARCHAR(255) DEFAULT NULL, business_type VARCHAR(100) DEFAULT NULL, years_in_business INT DEFAULT 0, employees INT DEFAULT 0, monthly_capacity VARCHAR(100) DEFAULT NULL, country VARCHAR(100) DEFAULT NULL, state VARCHAR(100) DEFAULT NULL, city VARCHAR(100) DEFAULT NULL, address TEXT DEFAULT NULL, postal_code VARCHAR(20) DEFAULT NULL, cac_number VARCHAR(100) DEFAULT NULL, tin VARCHAR(100) DEFAULT NULL, registration_number VARCHAR(100) DEFAULT NULL, facebook VARCHAR(255) DEFAULT NULL, instagram VARCHAR(255) DEFAULT NULL, linkedin VARCHAR(255) DEFAULT NULL, tiktok VARCHAR(255) DEFAULT NULL, youtube VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_id (supplier_id) ) {$charset_collate};"; dbDelta( $sql ); } Juicers – HQ MARKETPLACE

Skip to main content

SHOP BY CATEGORIES

Become a Seller

Juicers

No products were found matching your selection.