function dln_core_install_notification() { $sql = array(); $charset_collate = dln_core_set_charset(); $dln_prefix = dln_core_get_table_prefix(); $sql[] = "CREATE TABLE {$dln_prefix}dln_notifications (\n\t \t\t id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n\t \t\t bp_id bigint(20) NOT NULL,\n\t\t\t user_id bigint(20) NOT NULL,\n\t\t\t item_id bigint(20) NOT NULL,\n\t\t\t secondary_item_id bigint(20),\n\t \t\t component_name varchar(75) NOT NULL,\n\t\t\t component_action varchar(75) NOT NULL,\n\t \t\t date_notified datetime NOT NULL,\n\t\t\t is_new bool NOT NULL DEFAULT 0,\n\t\t KEY item_id (item_id),\n\t\t\t KEY secondary_item_id (secondary_item_id),\n\t\t\t KEY user_id (user_id),\n\t\t\t KEY is_new (is_new),\n\t\t\t KEY component_name (component_name),\n\t \t \t KEY component_action (component_action),\n\t\t\t KEY useritem (user_id,is_new)\n\t\t ) {$charset_collate};"; dbDelta($sql); }
private function setup_globals() { if (empty($this->table_prefix)) { $this->table_prefix = dln_core_get_table_prefix(); } // Notifications Table $this->core = new stdClass(); $this->core->table_name_notifications = $this->table_prefix . 'dln_notifications'; }