diff options
author | Friendika <info@friendika.com> | 2011-08-24 01:21:24 -0700 |
---|---|---|
committer | Friendika <info@friendika.com> | 2011-08-24 01:21:24 -0700 |
commit | 2aa23843e401e7f448c3d12f844934da6c27f8ef (patch) | |
tree | f36ffd56669d32b1ace2034ceb0cb3a3178a6f7d /database.sql | |
parent | 2cfdcee29a80e355307d013fe71d23a7300f8d98 (diff) | |
download | volse-hubzilla-2aa23843e401e7f448c3d12f844934da6c27f8ef.tar.gz volse-hubzilla-2aa23843e401e7f448c3d12f844934da6c27f8ef.tar.bz2 volse-hubzilla-2aa23843e401e7f448c3d12f844934da6c27f8ef.zip |
D* queue
Diffstat (limited to 'database.sql')
-rw-r--r-- | database.sql | 36 |
1 files changed, 18 insertions, 18 deletions
diff --git a/database.sql b/database.sql index f659e8049..f6ae4c7c6 100644 --- a/database.sql +++ b/database.sql @@ -38,7 +38,7 @@ CREATE TABLE IF NOT EXISTS `config` ( `k` char(255) NOT NULL, `v` text NOT NULL, PRIMARY KEY (`id`) -) ENGINE=MYISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -428,7 +428,7 @@ CREATE TABLE IF NOT EXISTS `register` ( `password` CHAR(255) NOT NULL, `language` CHAR(16) NOT NULL, PRIMARY KEY (`id`) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `clients` ( @@ -436,7 +436,7 @@ CREATE TABLE IF NOT EXISTS `clients` ( `pw` VARCHAR( 20 ) NOT NULL , `redirect_uri` VARCHAR( 200 ) NOT NULL , PRIMARY KEY ( `client_id` ) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `tokens` ( `id` VARCHAR( 40 ) NOT NULL , @@ -444,7 +444,7 @@ CREATE TABLE IF NOT EXISTS `tokens` ( `expires` INT NOT NULL , `scope` VARCHAR( 200 ) NOT NULL , PRIMARY KEY ( `id` ) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `auth_codes` ( `id` VARCHAR( 40 ) NOT NULL , @@ -453,7 +453,7 @@ CREATE TABLE IF NOT EXISTS `auth_codes` ( `expires` INT NOT NULL , `scope` VARCHAR( 250 ) NOT NULL , PRIMARY KEY ( `id` ) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `queue` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , @@ -462,7 +462,7 @@ CREATE TABLE IF NOT EXISTS `queue` ( `created` DATETIME NOT NULL , `last` DATETIME NOT NULL , `content` MEDIUMTEXT NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `pconfig` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , @@ -470,7 +470,7 @@ CREATE TABLE IF NOT EXISTS `pconfig` ( `cat` CHAR( 255 ) NOT NULL , `k` CHAR( 255 ) NOT NULL , `v` MEDIUMTEXT NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `hook` ( @@ -478,7 +478,7 @@ CREATE TABLE IF NOT EXISTS `hook` ( `hook` CHAR( 255 ) NOT NULL , `file` CHAR( 255 ) NOT NULL , `function` CHAR( 255 ) NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `addon` ( @@ -488,7 +488,7 @@ CREATE TABLE IF NOT EXISTS `addon` ( `installed` TINYINT( 1 ) NOT NULL DEFAULT '0' , `timestamp` BIGINT NOT NULL DEFAULT '0' , `plugin_admin` TINYINT( 1 ) NOT NULL DEFAULT '0' -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `event` ( @@ -509,13 +509,13 @@ CREATE TABLE IF NOT EXISTS `event` ( `allow_gid` MEDIUMTEXT NOT NULL , `deny_cid` MEDIUMTEXT NOT NULL , `deny_gid` MEDIUMTEXT NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `cache` ( `k` CHAR( 255 ) NOT NULL PRIMARY KEY , `v` TEXT NOT NULL, `updated` DATETIME NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `fcontact` ( @@ -536,14 +536,14 @@ CREATE TABLE IF NOT EXISTS `fcontact` ( `updated` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', INDEX ( `addr` ), INDEX ( `network` ) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ffinder` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `uid` INT UNSIGNED NOT NULL , `cid` INT UNSIGNED NOT NULL , `fid` INT UNSIGNED NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `fsuggest` ( @@ -556,7 +556,7 @@ CREATE TABLE IF NOT EXISTS `fsuggest` ( `photo` CHAR( 255 ) NOT NULL , `note` TEXT NOT NULL , `created` DATETIME NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `mailacct` ( @@ -571,7 +571,7 @@ CREATE TABLE IF NOT EXISTS `mailacct` ( `reply_to` CHAR( 255 ) NOT NULL , `pubmail` TINYINT(1) NOT NULL DEFAULT '0', `last_check` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `attach` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , @@ -587,13 +587,13 @@ CREATE TABLE IF NOT EXISTS `attach` ( `allow_gid` MEDIUMTEXT NOT NULL , `deny_cid` MEDIUMTEXT NOT NULL , `deny_gid` MEDIUMTEXT NOT NULL -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `guid` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `guid` CHAR( 64 ) NOT NULL , INDEX ( `guid` ) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `sign` ( @@ -603,6 +603,6 @@ CREATE TABLE IF NOT EXISTS `sign` ( `signature` TEXT NOT NULL , `signer` CHAR( 255 ) NOT NULL , INDEX ( `iid` ) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MyISAM DEFAULT CHARSET=utf8; |