X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=008d00a0da3132fe8241c8be6a03d88080d754c2;hb=b6b2997b435d9e7df6040d208fa0c68503fc1ee9;hp=c15a9ad9cb3aadca222e702aca8320f2182da366;hpb=4cff911939b263993eb41682ca558c975e2db01f;p=friendica.git diff --git a/database.sql b/database.sql index c15a9ad9cb..008d00a0da 100644 --- a/database.sql +++ b/database.sql @@ -288,6 +288,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `profile-name` char(255) NOT NULL, `is-default` tinyint(1) NOT NULL DEFAULT '0', `hide-friends` tinyint(1) NOT NULL DEFAULT '0', + `hidewall` tinyint(1) NOT NULL DEFAULT '0', `name` char(255) NOT NULL, `pdesc` char(255) NOT NULL, `dob` char(32) NOT NULL DEFAULT '0000-00-00', @@ -406,6 +407,7 @@ CREATE TABLE IF NOT EXISTS `register` ( `created` DATETIME NOT NULL , `uid` INT(11) UNSIGNED NOT NULL, `password` CHAR(255) NOT NULL, + `language` CHAR(16) NOT NULL, PRIMARY KEY (`id`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; @@ -525,6 +527,8 @@ CREATE TABLE IF NOT EXISTS `mailacct` ( CREATE TABLE IF NOT EXISTS `attach` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `uid` INT NOT NULL , +`hash` CHAR(64) NOT NULL, +`filename` CHAR(255) NOT NULL, `filetype` CHAR( 64 ) NOT NULL , `filesize` INT NOT NULL , `data` LONGBLOB NOT NULL ,