wp-all-import
Last commit date
actions
13 years ago
classes
13 years ago
config
13 years ago
controllers
13 years ago
filters
13 years ago
helpers
13 years ago
history
13 years ago
libraries
13 years ago
models
13 years ago
shortcodes
13 years ago
static
13 years ago
upload
13 years ago
views
13 years ago
plugin.php
13 years ago
readme.txt
13 years ago
schema.php
13 years ago
schema.php
65 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 | PRIMARY KEY (id) |
| 37 | ) $charset_collate; |
| 38 | CREATE TABLE {$table_prefix}imports ( |
| 39 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 40 | name VARCHAR(255) NOT NULL DEFAULT '', |
| 41 | type VARCHAR(32) NOT NULL DEFAULT '', |
| 42 | path TEXT, |
| 43 | xpath VARCHAR(255) NOT NULL DEFAULT '', |
| 44 | template LONGTEXT, |
| 45 | options TEXT, |
| 46 | scheduled VARCHAR(64) NOT NULL DEFAULT '', |
| 47 | registered_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 48 | PRIMARY KEY (id) |
| 49 | ) $charset_collate; |
| 50 | CREATE TABLE {$table_prefix}posts ( |
| 51 | post_id BIGINT(20) UNSIGNED NOT NULL, |
| 52 | import_id BIGINT(20) UNSIGNED NOT NULL, |
| 53 | unique_key TEXT, |
| 54 | PRIMARY KEY (post_id) |
| 55 | ) $charset_collate; |
| 56 | CREATE TABLE {$table_prefix}files ( |
| 57 | id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 58 | import_id BIGINT(20) UNSIGNED NOT NULL, |
| 59 | name VARCHAR(255) NOT NULL DEFAULT '', |
| 60 | path TEXT, |
| 61 | registered_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 62 | PRIMARY KEY (id) |
| 63 | ) $charset_collate; |
| 64 | SCHEMA; |
| 65 |