pagantis / woocommerce

controllers/notifyController.php

Spacing +7 added lines, -7 removed lines

@@ -86,7 +86,7 @@ 
             $this->insertLog($exception);

         }

 

-        if ($_SERVER['REQUEST_METHOD'] == 'POST') {

+        if ($_SERVER['REQUEST_METHOD']=='POST') {

             $jsonResponse->printResponse();

         } else {

             return $jsonResponse;

@@ -103,7 +103,7 @@ 
     private function checkConcurrency()

     {

         $this->woocommerceOrderId = $_GET['order-received'];

-        if ($this->woocommerceOrderId == '') {

+        if ($this->woocommerceOrderId=='') {

             throw new QuoteNotFoundException();

         }

     }

@@ -131,7 +131,7 @@ 
         $queryResult = $wpdb->get_row("select order_id from $tableName where id='".$this->woocommerceOrderId."'");

         $this->pagantisOrderId = $queryResult->order_id;

 

-        if ($this->pagantisOrderId == '') {

+        if ($this->pagantisOrderId=='') {

             throw new NoIdentificationException();

         }

     }

@@ -196,7 +196,7 @@ 
     {

         $pagantisAmount = $this->pagantisOrder->getShoppingCart()->getTotalAmount();

         $wcAmount = intval(strval(100 * $this->woocommerceOrder->get_total()));

-        if ($pagantisAmount != $wcAmount) {

+        if ($pagantisAmount!=$wcAmount) {

             throw new AmountMismatchException($pagantisAmount, $wcAmount);

         }

     }

@@ -237,7 +237,7 @@ 
         global $wpdb;

         $tableName = $wpdb->prefix.self::ORDERS_TABLE;

 

-        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName) {

+        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'")!=$tableName) {

             $charset_collate = $wpdb->get_charset_collate();

             $sql             = "CREATE TABLE $tableName (id int, order_id varchar(50), wc_order_id varchar(50), 

                   UNIQUE KEY id (id)) $charset_collate";

@@ -255,7 +255,7 @@ 
         global $wpdb;

         $tableName = $wpdb->prefix.self::LOGS_TABLE;

 

-        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName) {

+        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'")!=$tableName) {

             $charset_collate = $wpdb->get_charset_collate();

             $sql = "CREATE TABLE $tableName ( id int NOT NULL AUTO_INCREMENT, log text NOT NULL, 

                     createdAt timestamp DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY id (id)) $charset_collate";

@@ -354,7 +354,7 @@ 
 

         if ($exception instanceof \Exception) {

             $this->checkDbLogTable();

-            $logEntry= new LogEntry();

+            $logEntry = new LogEntry();

             $logEntryJson = $logEntry->error($exception)->toJson();

 

             $tableName = $wpdb->prefix.self::LOGS_TABLE;

WC_Pagantis.php

Spacing +12 added lines, -12 removed lines

@@ -77,8 +77,8 @@ 
      */
     public function loadPagantisTranslation($mofile, $domain)
     {
-        if ('pagantis' === $domain) {
-            $mofile = WP_LANG_DIR . '/../plugins/pagantis/languages/pagantis-' . get_locale() . '.mo';
+        if ('pagantis'===$domain) {
+            $mofile = WP_LANG_DIR.'/../plugins/pagantis/languages/pagantis-'.get_locale().'.mo';
         }
         return $mofile;
     }
@@ -92,7 +92,7 @@ 
         $tableName = $wpdb->prefix.self::CONFIG_TABLE;
 
         //Check if table exists
-        $tableExists = $wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName;
+        $tableExists = $wpdb->get_var("SHOW TABLES LIKE '$tableName'")!=$tableName;
         if ($tableExists) {
             $charset_collate = $wpdb->get_charset_collate();
             $sql = "CREATE TABLE IF NOT EXISTS $tableName (
@@ -146,9 +146,9 @@ 
         $locale = strtolower(strstr(get_locale(), '_', true));
         $allowedCountries = unserialize($this->extraConfig['PAGANTIS_ALLOWED_COUNTRIES']);
         $allowedCountry = (in_array(strtolower($locale), $allowedCountries));
-        if ($cfg['enabled'] !== 'yes' || $cfg['pagantis_public_key'] == '' || $cfg['pagantis_private_key'] == '' ||
-            $cfg['simulator'] !== 'yes' ||  $product->price < $this->extraConfig['PAGANTIS_DISPLAY_MIN_AMOUNT'] ||
-            !$allowedCountry ) {
+        if ($cfg['enabled']!=='yes' || $cfg['pagantis_public_key']=='' || $cfg['pagantis_private_key']=='' ||
+            $cfg['simulator']!=='yes' || $product->price < $this->extraConfig['PAGANTIS_DISPLAY_MIN_AMOUNT'] ||
+            !$allowedCountry) {
             return;
         }
 
@@ -174,7 +174,7 @@ 
      */
     public function addPagantisGateway($methods)
     {
-        if (! class_exists('WC_Payment_Gateway')) {
+        if (!class_exists('WC_Payment_Gateway')) {
             return $methods;
         }
 
@@ -229,7 +229,7 @@ 
      */
     public function pagantisRowMeta($links, $file)
     {
-        if ($file == plugin_basename(__FILE__)) {
+        if ($file==plugin_basename(__FILE__)) {
             $links[] = '<a href="'.WcPagantis::GIT_HUB_URL.'" target="_blank">'.__('Documentation', 'pagantis').'</a>';
             $links[] = '<a href="'.WcPagantis::PAGANTIS_DOC_URL.'" target="_blank">'.
             __('API documentation', 'pagantis').'</a>';
@@ -257,7 +257,7 @@ 
         $tableName = $wpdb->prefix.self::LOGS_TABLE;
         $query = "select * from $tableName where createdAt>$from and createdAt<$to order by createdAt desc";
         $results = $wpdb->get_results($query);
-        if (isset($results) && $privateKey == $secretKey) {
+        if (isset($results) && $privateKey==$secretKey) {
             foreach ($results as $key => $result) {
                 $response[$key]['timestamp'] = $result->createdAt;
                 $response[$key]['log']       = json_decode($result->log);
@@ -284,12 +284,12 @@ 
 
         $filters   = ($data->get_params());
         $secretKey = $filters['secret'];
-        $cfg  = get_option('woocommerce_pagantis_settings');
+        $cfg = get_option('woocommerce_pagantis_settings');
         $privateKey = isset($cfg['pagantis_private_key']) ? $cfg['pagantis_private_key'] : null;
-        if ($privateKey != $secretKey) {
+        if ($privateKey!=$secretKey) {
             $response['status'] = 401;
             $response['result'] = 'Unauthorized';
-        } elseif ($_SERVER['REQUEST_METHOD'] == 'POST') {
+        } elseif ($_SERVER['REQUEST_METHOD']=='POST') {
             if (count($_POST)) {
                 foreach ($_POST as $config => $value) {
                     if (isset($this->defaultConfigs[$config]) && $response['status']==null) {

templates/product_simulator.php

Spacing +4 added lines, -4 removed lines

@@ -1,7 +1,7 @@ 
 <script>
     function findPriceSelector()
     {
-        var priceSelectors = <?php echo json_encode($priceSelector);?>;
+        var priceSelectors = <?php echo json_encode($priceSelector); ?>;
         return priceSelectors.find(function(candidateSelector) {
             var priceDOM = document.querySelector(candidateSelector);
             return (priceDOM != null );
@@ -11,7 +11,7 @@ 
 
     function findQuantitySelector()
     {
-        var quantitySelectors = <?php echo json_encode($quantitySelector);?>;
+        var quantitySelectors = <?php echo json_encode($quantitySelector); ?>;
         return quantitySelectors.find(function(candidateSelector) {
             var priceDOM = document.querySelector(candidateSelector);
             return (priceDOM != null );
@@ -51,7 +51,7 @@ 
             return finishInterval();
         }
 
-        var price = '<?php echo $total;?>';
+        var price = '<?php echo $total; ?>';
 
         var locale = '<?php echo $locale; ?>';
         if (locale == 'es' || locale == '') {
@@ -60,7 +60,7 @@ 
             var sdk = pgSDK;
         }
 
-        var positionSelector = '<?php echo $positionSelector;?>';
+        var positionSelector = '<?php echo $positionSelector; ?>';
         if (positionSelector === 'default') {
             positionSelector = '.pagantisSimulator';
         }

controllers/paymentController.php

Spacing +53 added lines, -54 removed lines

@@ -54,36 +54,36 @@ 
         $this->title = $this->extraConfig['PAGANTIS_TITLE'];

 

         //Useful vars

-        $this->template_path = plugin_dir_path(__FILE__) . '../templates/';

+        $this->template_path = plugin_dir_path(__FILE__).'../templates/';

         $this->allowed_currencies = array("EUR");

-        $this->mainFileLocation = dirname(plugin_dir_path(__FILE__)) . '/WC_Pagantis.php';

+        $this->mainFileLocation = dirname(plugin_dir_path(__FILE__)).'/WC_Pagantis.php';

         $this->plugin_info = get_file_data($this->mainFileLocation, array('Version' => 'Version'), false);

         $this->language = strstr(get_locale(), '_', true);

 

-        if ($this->language == 'es' || $this->language == '') {

+        if ($this->language=='es' || $this->language=='') {

             $this->icon = esc_url(plugins_url('../assets/images/logopagamastarde.png', __FILE__));

         } else {

             $this->icon = esc_url(plugins_url('../assets/images/logo.png', __FILE__));

         }

 

         //Panel form fields

-        $this->form_fields = include(plugin_dir_path(__FILE__).'../includes/settings-pagantis.php');//Panel options

+        $this->form_fields = include(plugin_dir_path(__FILE__).'../includes/settings-pagantis.php'); //Panel options

         $this->init_settings();

 

         $this->extraConfig = $this->getExtraConfig();

 

-        $this->settings['ok_url'] = ($this->extraConfig['PAGANTIS_URL_OK']!='')?$this->extraConfig['PAGANTIS_URL_OK']:$this->generateOkUrl();

-        $this->settings['ko_url'] = ($this->extraConfig['PAGANTIS_URL_KO']!='')?$this->extraConfig['PAGANTIS_URL_KO']:$this->generateKoUrl();

+        $this->settings['ok_url'] = ($this->extraConfig['PAGANTIS_URL_OK']!='') ? $this->extraConfig['PAGANTIS_URL_OK'] : $this->generateOkUrl();

+        $this->settings['ko_url'] = ($this->extraConfig['PAGANTIS_URL_KO']!='') ? $this->extraConfig['PAGANTIS_URL_KO'] : $this->generateKoUrl();

         foreach ($this->settings as $setting_key => $setting_value) {

             $this->$setting_key = $setting_value;

         }

 

         //Hooks

-        add_action('woocommerce_update_options_payment_gateways_'.$this->id, array($this,'process_admin_options')); //Save plugin options

-        add_action('admin_notices', array($this, 'pagantisCheckFields'));                          //Check config fields

-        add_action('woocommerce_receipt_'.$this->id, array($this, 'pagantisReceiptPage'));          //Pagantis form

-        add_action('woocommerce_api_wcpagantisgateway', array($this, 'pagantisNotification'));      //Json Notification

-        add_filter('woocommerce_payment_complete_order_status', array($this,'pagantisCompleteStatus'), 10, 3);

+        add_action('woocommerce_update_options_payment_gateways_'.$this->id, array($this, 'process_admin_options')); //Save plugin options

+        add_action('admin_notices', array($this, 'pagantisCheckFields')); //Check config fields

+        add_action('woocommerce_receipt_'.$this->id, array($this, 'pagantisReceiptPage')); //Pagantis form

+        add_action('woocommerce_api_wcpagantisgateway', array($this, 'pagantisNotification')); //Json Notification

+        add_filter('woocommerce_payment_complete_order_status', array($this, 'pagantisCompleteStatus'), 10, 3);

         add_filter('load_textdomain_mofile', array($this, 'loadPagantisTranslation'), 10, 2);

     }

 

@@ -95,8 +95,8 @@ 
      */

     public function loadPagantisTranslation($mofile, $domain)

     {

-        if ('pagantis' === $domain) {

-            $mofile = WP_LANG_DIR . '/../plugins/pagantis/languages/pagantis-' . get_locale() . '.mo';

+        if ('pagantis'===$domain) {

+            $mofile = WP_LANG_DIR.'/../plugins/pagantis/languages/pagantis-'.get_locale().'.mo';

         }

         return $mofile;

     }

@@ -129,24 +129,24 @@ 
     public function pagantisCheckFields()

     {

         $error_string = '';

-        if ($this->settings['enabled'] !== 'yes') {

+        if ($this->settings['enabled']!=='yes') {

             return;

         } elseif (!version_compare(phpversion(), '5.3.0', '>=')) {

-            $error_string =  __(' is not compatible with your php and/or curl version', 'pagantis');

+            $error_string = __(' is not compatible with your php and/or curl version', 'pagantis');

             $this->settings['enabled'] = 'no';

         } elseif ($this->settings['pagantis_public_key']=="" || $this->settings['pagantis_private_key']=="") {

             $error_string = __(' is not configured correctly, the fields Public Key and Secret Key are mandatory for use this plugin', 'pagantis');

             $this->settings['enabled'] = 'no';

         } elseif (!in_array(get_woocommerce_currency(), $this->allowed_currencies)) {

-            $error_string =  __(' only can be used in Euros', 'pagantis');

+            $error_string = __(' only can be used in Euros', 'pagantis');

             $this->settings['enabled'] = 'no';

-        } elseif ($this->extraConfig['PAGANTIS_SIMULATOR_MAX_INSTALLMENTS']<'2'

-                  || $this->extraConfig['PAGANTIS_SIMULATOR_MAX_INSTALLMENTS']>'12') {

+        } elseif ($this->extraConfig['PAGANTIS_SIMULATOR_MAX_INSTALLMENTS'] < '2'

+                  || $this->extraConfig['PAGANTIS_SIMULATOR_MAX_INSTALLMENTS'] > '12') {

             $error_string = __(' only can be payed from 2 to 12 installments', 'pagantis');

-        } elseif ($this->extraConfig['PAGANTIS_SIMULATOR_START_INSTALLMENTS']<'2'

-                  || $this->extraConfig['PAGANTIS_SIMULATOR_START_INSTALLMENTS']>'12') {

+        } elseif ($this->extraConfig['PAGANTIS_SIMULATOR_START_INSTALLMENTS'] < '2'

+                  || $this->extraConfig['PAGANTIS_SIMULATOR_START_INSTALLMENTS'] > '12') {

             $error_string = __(' only can be payed from 2 to 12 installments', 'pagantis');

-        } elseif ($this->extraConfig['PAGANTIS_DISPLAY_MIN_AMOUNT']<0) {

+        } elseif ($this->extraConfig['PAGANTIS_DISPLAY_MIN_AMOUNT'] < 0) {

             $error_string = __(' can not have a minimum amount less than 0', 'pagantis');

         }

 

@@ -180,7 +180,7 @@ 
 

             $shippingAddress = $order->get_address('shipping');

             $billingAddress = $order->get_address('billing');

-            if ($shippingAddress['address_1'] == '') {

+            if ($shippingAddress['address_1']=='') {

                 $shippingAddress = $billingAddress;

             }

 

@@ -207,7 +207,7 @@ 
                 ->setNationalId($national_id)

                 ->setTaxId($tax_id)

             ;

-            $orderBillingAddress =  new Address();

+            $orderBillingAddress = new Address();

             $orderBillingAddress

                 ->setZipCode($billingAddress['postcode'])

                 ->setFullName($billingAddress['first_name']." ".$billingAddress['last_name'])

@@ -338,7 +338,7 @@ 
                 wc_get_template('iframe.php', $template_fields, '', $this->template_path);

             }

         } catch (\Exception $exception) {

-            wc_add_notice(__('Payment error ', 'pagantis') . $exception->getMessage(), 'error');

+            wc_add_notice(__('Payment error ', 'pagantis').$exception->getMessage(), 'error');

             $this->insertLog($exception);

             $checkout_url = get_permalink(wc_get_page_id('checkout'));

             wp_redirect($checkout_url);

@@ -352,7 +352,7 @@ 
     public function pagantisNotification()

     {

         try {

-            $origin = ($_SERVER['REQUEST_METHOD'] == 'POST') ? 'Notify' : 'Order';

+            $origin = ($_SERVER['REQUEST_METHOD']=='POST') ? 'Notify' : 'Order';

 

             include_once('notifyController.php');

             $notify = new WcPagantisNotify();

@@ -391,10 +391,10 @@ 
      */

     public function pagantisCompleteStatus($status, $order_id, $order)

     {

-        if ($order->get_payment_method() == WcPagantisGateway::METHOD_ID) {

-            if ($order->get_status() == 'failed') {

+        if ($order->get_payment_method()==WcPagantisGateway::METHOD_ID) {

+            if ($order->get_status()=='failed') {

                 $status = 'processing';

-            } elseif ($order->get_status() == 'pending' && $status=='completed') {

+            } elseif ($order->get_status()=='pending' && $status=='completed') {

                 $status = 'processing';

             }

         }

@@ -418,7 +418,7 @@ 
         $allowedCountries = unserialize($this->extraConfig['PAGANTIS_ALLOWED_COUNTRIES']);

         $allowedCountry = (in_array(strtolower($locale), $allowedCountries));

         if ($this->enabled==='yes' && $this->pagantis_public_key!='' && $this->pagantis_private_key!='' &&

-            (int)$this->get_order_total()>$this->extraConfig['PAGANTIS_DISPLAY_MIN_AMOUNT'] && $allowedCountry) {

+            (int) $this->get_order_total() > $this->extraConfig['PAGANTIS_DISPLAY_MIN_AMOUNT'] && $allowedCountry) {

             return true;

         }

 

@@ -446,7 +446,7 @@ 
 

             $redirectUrl = $order->get_checkout_payment_url(true); //pagantisReceiptPage function

             if (strpos($redirectUrl, 'order-pay=')===false) {

-                $redirectUrl.="&order-pay=".$order_id;

+                $redirectUrl .= "&order-pay=".$order_id;

             }

 

             return array(

@@ -455,7 +455,7 @@ 
             );

 

         } catch (Exception $e) {

-            wc_add_notice(__('Payment error ', 'pagantis') . $e->getMessage(), 'error');

+            wc_add_notice(__('Payment error ', 'pagantis').$e->getMessage(), 'error');

             return array();

         }

     }

@@ -515,7 +515,7 @@ 
     private function generateUrl($url)

     {

         $parsed_url = parse_url($url);

-        if ($parsed_url !== false) {

+        if ($parsed_url!==false) {

             $parsed_url['query'] = !isset($parsed_url['query']) ? '' : $parsed_url['query'];

             parse_str($parsed_url['query'], $arrayParams);

             foreach ($arrayParams as $keyParam => $valueParam) {

@@ -563,11 +563,10 @@ 
     private function getKeysUrl($order, $url)

     {

         $defaultFields = (get_class($order)=='WC_Order') ?

-            array('order-received'=>$order->get_id(), 'key'=>$order->get_order_key()) :

-            array();

+            array('order-received'=>$order->get_id(), 'key'=>$order->get_order_key()) : array();

 

         $parsedUrl = parse_url($url);

-        if ($parsedUrl !== false) {

+        if ($parsedUrl!==false) {

             //Replace parameters from url

             $parsedUrl['query'] = $this->getKeysParametersUrl($parsedUrl['query'], $defaultFields);

 

@@ -612,7 +611,7 @@ 
         foreach ($arrayParams as $keyParam => $valueParam) {

             preg_match('#\{{.*?}\}#', $valueParam, $match);

             if (count($match)) {

-                $key = str_replace(array('{{','}}'), array('',''), $match[0]);

+                $key = str_replace(array('{{', '}}'), array('', ''), $match[0]);

                 $arrayParams[$keyParam] = $defaultFields[$key];

             }

         }

@@ -627,13 +626,13 @@ 
      */

     private function unparseUrl($parsed_url)

     {

-        $scheme   = isset($parsed_url['scheme']) ? $parsed_url['scheme'] . '://' : '';

+        $scheme   = isset($parsed_url['scheme']) ? $parsed_url['scheme'].'://' : '';

         $host     = isset($parsed_url['host']) ? $parsed_url['host'] : '';

-        $port     = isset($parsed_url['port']) ? ':' . $parsed_url['port'] : '';

-        $query    = isset($parsed_url['query']) ? '?' . $parsed_url['query'] : '';

-        $fragment = isset($parsed_url['fragment']) ? '#' . $parsed_url['fragment'] : '';

+        $port     = isset($parsed_url['port']) ? ':'.$parsed_url['port'] : '';

+        $query    = isset($parsed_url['query']) ? '?'.$parsed_url['query'] : '';

+        $fragment = isset($parsed_url['fragment']) ? '#'.$parsed_url['fragment'] : '';

         $path     = $parsed_url['path'];

-        return $scheme . $host . $port . $path . $query . $fragment;

+        return $scheme.$host.$port.$path.$query.$fragment;

     }

 

     /**

@@ -655,20 +654,20 @@ 
             $is_guest = "false";

             $sign_up = substr($current_user->user_registered, 0, 10);

             $customer_orders = get_posts(array(

-                'numberposts' => - 1,

+                'numberposts' => -1,

                 'meta_key'    => '_customer_user',

                 'meta_value'  => $current_user->ID,

-                'post_type'   => array( 'shop_order' ),

-                'post_status' => array( 'wc-completed', 'wc-processing', 'wc-refunded' ),

+                'post_type'   => array('shop_order'),

+                'post_status' => array('wc-completed', 'wc-processing', 'wc-refunded'),

             ));

         } else {

             $is_guest = "true";

             $customer_orders = get_posts(array(

-                'numberposts' => - 1,

+                'numberposts' => -1,

                 'meta_key'    => '_billing_email',

                 'meta_value'  => $billingEmail,

-                'post_type'   => array( 'shop_order' ),

-                'post_status' => array( 'wc-completed', 'wc-processing', 'wc-refunded'),

+                'post_type'   => array('shop_order'),

+                'post_status' => array('wc-completed', 'wc-processing', 'wc-refunded'),

             ));

             foreach ($customer_orders as $customer_order) {

                 if (trim($sign_up)=='' ||

@@ -697,7 +696,7 @@ 
         //Check if id exists

         $resultsSelect = $wpdb->get_results("select * from $tableName where id='$orderId'");

         $countResults = count($resultsSelect);

-        if ($countResults == 0) {

+        if ($countResults==0) {

             $wpdb->insert(

                 $tableName,

                 array('id' => $orderId, 'order_id' => $pagantisOrderId),

@@ -722,7 +721,7 @@ 
         global $wpdb;

         $tableName = $wpdb->prefix.self::ORDERS_TABLE;

 

-        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName) {

+        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'")!=$tableName) {

             $charset_collate = $wpdb->get_charset_collate();

             $sql             = "CREATE TABLE $tableName ( id int, order_id varchar(50), wc_order_id varchar(50),  

                   UNIQUE KEY id (id)) $charset_collate";

@@ -755,9 +754,9 @@ 
      */

     private function getNationalId($order)

     {

-        foreach ((array)$order->get_meta_data() as $mdObject) {

+        foreach ((array) $order->get_meta_data() as $mdObject) {

             $data = $mdObject->get_data();

-            if ($data['key'] == 'vat_number') {

+            if ($data['key']=='vat_number') {

                 return $data['value'];

             }

         }

@@ -772,9 +771,9 @@ 
      */

     private function getTaxId($order)

     {

-        foreach ((array)$order->get_meta_data() as $mdObject) {

+        foreach ((array) $order->get_meta_data() as $mdObject) {

             $data = $mdObject->get_data();

-            if ($data['key'] == 'billing_cfpiva') {

+            if ($data['key']=='billing_cfpiva') {

                 return $data['value'];

             }

         }

@@ -804,7 +803,7 @@ 
     {

         global $wpdb;

         $tableName = $wpdb->prefix.self::LOGS_TABLE;

-        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName) {

+        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'")!=$tableName) {

             $charset_collate = $wpdb->get_charset_collate();

             $sql = "CREATE TABLE $tableName ( id int NOT NULL AUTO_INCREMENT, log text NOT NULL, 

                     createdAt timestamp DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY id (id)) $charset_collate";