-- ------------------------------------------
-- Friendica 2020.03-dev (Dalmatian Bellflower)
--- DB_UPDATE_VERSION 1331
+-- DB_UPDATE_VERSION 1333
-- ------------------------------------------
`reason` text COMMENT '',
`closeness` tinyint unsigned NOT NULL DEFAULT 99 COMMENT '',
`info` mediumtext COMMENT '',
- `profile-id` int unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `profile-id` int unsigned COMMENT 'Deprecated',
`bdyear` varchar(4) NOT NULL DEFAULT '' COMMENT '',
`bd` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
`notify_new_posts` boolean NOT NULL DEFAULT '0' COMMENT '',
CREATE TABLE IF NOT EXISTS `profile` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
- `profile-name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the profile',
- `is-default` boolean NOT NULL DEFAULT '0' COMMENT 'Mark this profile as default profile',
+ `profile-name` varchar(255) COMMENT 'Deprecated',
+ `is-default` boolean COMMENT 'Deprecated',
`hide-friends` boolean NOT NULL DEFAULT '0' COMMENT 'Hide friend list from viewers of this profile',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `pdesc` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title or description',
+ `pdesc` varchar(255) COMMENT 'Deprecated',
`dob` varchar(32) NOT NULL DEFAULT '0000-00-00' COMMENT 'Day of birth',
`address` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`locality` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`region` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`postal-code` varchar(32) NOT NULL DEFAULT '' COMMENT '',
`country-name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `hometown` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `gender` varchar(32) NOT NULL DEFAULT '' COMMENT '',
- `marital` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `with` text COMMENT '',
- `howlong` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `sexual` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `politic` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `religion` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `hometown` varchar(255) COMMENT 'Deprecated',
+ `gender` varchar(32) COMMENT 'Deprecated',
+ `marital` varchar(255) COMMENT 'Deprecated',
+ `with` text COMMENT 'Deprecated',
+ `howlong` datetime COMMENT 'Deprecated',
+ `sexual` varchar(255) COMMENT 'Deprecated',
+ `politic` varchar(255) COMMENT 'Deprecated',
+ `religion` varchar(255) COMMENT 'Deprecated',
`pub_keywords` text COMMENT '',
`prv_keywords` text COMMENT '',
- `likes` text COMMENT '',
- `dislikes` text COMMENT '',
- `about` text COMMENT '',
- `summary` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `music` text COMMENT '',
- `book` text COMMENT '',
- `tv` text COMMENT '',
- `film` text COMMENT '',
- `interest` text COMMENT '',
- `romance` text COMMENT '',
- `work` text COMMENT '',
- `education` text COMMENT '',
- `contact` text COMMENT '',
+ `likes` text COMMENT 'Deprecated',
+ `dislikes` text COMMENT 'Deprecated',
+ `about` text COMMENT 'Profile description',
+ `summary` varchar(255) COMMENT 'Deprecated',
+ `music` text COMMENT 'Deprecated',
+ `book` text COMMENT 'Deprecated',
+ `tv` text COMMENT 'Deprecated',
+ `film` text COMMENT 'Deprecated',
+ `interest` text COMMENT 'Deprecated',
+ `romance` text COMMENT 'Deprecated',
+ `work` text COMMENT 'Deprecated',
+ `education` text COMMENT 'Deprecated',
+ `contact` text COMMENT 'Deprecated',
`homepage` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',