wp-all-import
Last commit date
actions
11 years ago
classes
11 years ago
config
11 years ago
controllers
11 years ago
filters
11 years ago
helpers
11 years ago
i18n
11 years ago
libraries
11 years ago
models
11 years ago
shortcodes
11 years ago
static
11 years ago
views
11 years ago
banner-772x250.png
11 years ago
plugin.php
11 years ago
readme.txt
11 years ago
schema.php
11 years ago
screenshot-1.png
11 years ago
screenshot-2.png
11 years ago
screenshot-3.png
11 years ago
screenshot-4.png
11 years ago
schema.php
100 lines
| 1 | <?php |
| 2 | /** |
| 3 | * Plugin database schema |
| 4 | * WARNING: |
| 5 | * dbDelta() doesn't like empty lines in schema string, so don't put them there; |
| 6 | * WPDB doesn't like NULL values so better not to have them in the tables; |
| 7 | */ |
| 8 | |
| 9 | /** |
| 10 | * The database character collate. |
| 11 | * @var string |
| 12 | * @global string |
| 13 | * @name $charset_collate |
| 14 | */ |
| 15 | $charset_collate = ''; |
| 16 | |
| 17 | // Declare these as global in case schema.php is included from a function. |
| 18 | global $wpdb, $plugin_queries; |
| 19 | |
| 20 | if ( ! empty($wpdb->charset)) |
| 21 | $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset"; |
| 22 | if ( ! empty($wpdb->collate)) |
| 23 | $charset_collate .= " COLLATE $wpdb->collate"; |
| 24 | |
| 25 | $table_prefix = PMXI_Plugin::getInstance()->getTablePrefix(); |
| 26 | |
| 27 | $plugin_queries = <<<SCHEMA |
| 28 | CREATE TABLE {$table_prefix}templates ( |
| 29 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 30 | options TEXT, |
| 31 | scheduled VARCHAR(64) NOT NULL DEFAULT '', |
| 32 | name VARCHAR(200) NOT NULL DEFAULT '', |
| 33 | title TEXT, |
| 34 | content LONGTEXT, |
| 35 | is_keep_linebreaks TINYINT(1) NOT NULL DEFAULT 0, |
| 36 | is_leave_html TINYINT(1) NOT NULL DEFAULT 0, |
| 37 | fix_characters TINYINT(1) NOT NULL DEFAULT 0, |
| 38 | meta LONGTEXT, |
| 39 | PRIMARY KEY (id) |
| 40 | ) $charset_collate; |
| 41 | CREATE TABLE {$table_prefix}imports ( |
| 42 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 43 | parent_import_id BIGINT(20) NOT NULL DEFAULT 0, |
| 44 | name VARCHAR(255) NOT NULL DEFAULT '', |
| 45 | friendly_name VARCHAR(255) NOT NULL DEFAULT '', |
| 46 | type VARCHAR(32) NOT NULL DEFAULT '', |
| 47 | feed_type ENUM('xml','csv','zip','gz','') NOT NULL DEFAULT '', |
| 48 | path TEXT, |
| 49 | xpath TEXT, |
| 50 | options TEXT, |
| 51 | registered_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 52 | root_element VARCHAR(255) DEFAULT '', |
| 53 | processing BOOL NOT NULL DEFAULT 0, |
| 54 | executing BOOL NOT NULL DEFAULT 0, |
| 55 | triggered BOOL NOT NULL DEFAULT 0, |
| 56 | queue_chunk_number BIGINT(20) NOT NULL DEFAULT 0, |
| 57 | first_import TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 58 | count BIGINT(20) NOT NULL DEFAULT 0, |
| 59 | imported BIGINT(20) NOT NULL DEFAULT 0, |
| 60 | created BIGINT(20) NOT NULL DEFAULT 0, |
| 61 | updated BIGINT(20) NOT NULL DEFAULT 0, |
| 62 | skipped BIGINT(20) NOT NULL DEFAULT 0, |
| 63 | deleted BIGINT(20) NOT NULL DEFAULT 0, |
| 64 | canceled BOOL NOT NULL DEFAULT 0, |
| 65 | canceled_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 66 | failed BOOL NOT NULL DEFAULT 0, |
| 67 | failed_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 68 | settings_update_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 69 | last_activity DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 70 | iteration BIGINT(20) NOT NULL DEFAULT 0, |
| 71 | PRIMARY KEY (id) |
| 72 | ) $charset_collate; |
| 73 | CREATE TABLE {$table_prefix}posts ( |
| 74 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 75 | post_id BIGINT(20) UNSIGNED NOT NULL, |
| 76 | import_id BIGINT(20) UNSIGNED NOT NULL, |
| 77 | unique_key TEXT, |
| 78 | product_key TEXT, |
| 79 | iteration BIGINT(20) NOT NULL DEFAULT 0, |
| 80 | PRIMARY KEY (id) |
| 81 | ) $charset_collate; |
| 82 | CREATE TABLE {$table_prefix}files ( |
| 83 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 84 | import_id BIGINT(20) UNSIGNED NOT NULL, |
| 85 | name VARCHAR(255) NOT NULL DEFAULT '', |
| 86 | path TEXT, |
| 87 | registered_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 88 | PRIMARY KEY (id) |
| 89 | ) $charset_collate; |
| 90 | CREATE TABLE {$table_prefix}history ( |
| 91 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 92 | import_id BIGINT(20) UNSIGNED NOT NULL, |
| 93 | type ENUM('manual','processing','trigger','continue','') NOT NULL DEFAULT '', |
| 94 | time_run TEXT, |
| 95 | date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 96 | summary TEXT, |
| 97 | PRIMARY KEY (id) |
| 98 | ) $charset_collate; |
| 99 | SCHEMA; |
| 100 |