Code: Select all
CREATE TABLE mantis_tokens_table (
id INTEGER NOT NULL AUTO_INCREMENT,
owner INTEGER NOT NULL,
type INTEGER NOT NULL,
timestamp DATETIME NOT NULL,
expiry DATETIME,
value LONGTEXT NOT NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
SYSTEM WARNING: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given
SYSTEM WARNING: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given
CREATE TABLE mantis_user_pref_table (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
user_id INTEGER UNSIGNED NOT NULL DEFAULT 0,
project_id INTEGER UNSIGNED NOT NULL DEFAULT 0,
default_profile INTEGER UNSIGNED NOT NULL DEFAULT 0,
default_project INTEGER UNSIGNED NOT NULL DEFAULT 0,
advanced_report TINYINT NOT NULL DEFAULT '0',
advanced_view TINYINT NOT NULL DEFAULT '0',
advanced_update TINYINT NOT NULL DEFAULT '0',
refresh_delay INTEGER NOT NULL DEFAULT 0,
redirect_delay TINYINT NOT NULL DEFAULT '0',