1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
<?php
// phpcs:ignoreFile
namespace AutomateWoo\DatabaseTables;
use AutomateWoo\Database_Table;
if ( ! defined( 'ABSPATH' ) ) exit;
/**
* Carts database table class.
*
* @since 2.8.2
*/
class Carts extends Database_Table {
function __construct() {
global $wpdb;
$this->name = $wpdb->prefix . 'automatewoo_abandoned_carts';
$this->primary_key = 'id';
}
/**
* @return array
*/
function get_columns() {
return [
'id' => '%d',
'status' => '%s',
'user_id' => '%d',
'guest_id' => '%d',
'last_modified' => '%s',
'created' => '%s',
'items' => '%s',
'coupons' => '%s',
'fees' => '%s',
'shipping_tax_total' => '%d',
'shipping_total' => '%d',
'total' => '%s',
'token' => '%s',
'currency' => '%s'
];
}
/**
* @return string
*/
function get_install_query() {
return "CREATE TABLE {$this->get_name()} (
id bigint(20) NOT NULL AUTO_INCREMENT,
status varchar(100) NOT NULL default '',
user_id bigint(20) NOT NULL default 0,
guest_id bigint(20) NOT NULL default 0,
last_modified datetime NULL,
created datetime NULL,
items longtext NOT NULL,
coupons longtext NOT NULL,
fees longtext NOT NULL,
shipping_tax_total double DEFAULT 0 NOT NULL,
shipping_total double DEFAULT 0 NOT NULL,
total double DEFAULT 0 NOT NULL,
token varchar(32) NOT NULL default '',
currency varchar(8) NOT NULL default '',
PRIMARY KEY (id),
KEY status (status),
KEY user_id (user_id),
KEY guest_id (guest_id),
KEY last_modified (last_modified),
KEY created (created)
) {$this->get_collate()};";
}
}
|