aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql28
1 files changed, 12 insertions, 16 deletions
diff --git a/database.sql b/database.sql
index d96b7b554..cbd2c235e 100644
--- a/database.sql
+++ b/database.sql
@@ -115,6 +115,7 @@ CREATE TABLE IF NOT EXISTS `config` (
CREATE TABLE IF NOT EXISTS `contact` (
`id` int(11) NOT NULL AUTO_INCREMENT,
+ `aid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL COMMENT 'owner uid',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`my_perms` int(10) unsigned NOT NULL DEFAULT '0',
@@ -130,9 +131,9 @@ CREATE TABLE IF NOT EXISTS `contact` (
`photo` text NOT NULL COMMENT 'remote photo URL initially until approved',
`thumb` text NOT NULL,
`micro` text NOT NULL,
- `site-pubkey` text NOT NULL,
- `issued-id` char(255) NOT NULL,
- `dfrn-id` char(255) NOT NULL,
+ `site_pubkey` text NOT NULL,
+ `issued_id` char(255) NOT NULL,
+ `dfrn_id` char(255) NOT NULL,
`url` char(255) NOT NULL,
`nurl` char(255) NOT NULL,
`addr` char(255) NOT NULL,
@@ -146,16 +147,12 @@ CREATE TABLE IF NOT EXISTS `contact` (
`confirm` text NOT NULL,
`poco` text NOT NULL,
`aes_allow` tinyint(1) NOT NULL DEFAULT '0',
- `ret-aes` tinyint(1) NOT NULL DEFAULT '0',
- `usehub` tinyint(1) NOT NULL DEFAULT '0',
- `subhub` tinyint(1) NOT NULL DEFAULT '0',
- `hub-verify` char(255) NOT NULL,
- `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`success_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `term-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `name_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `uri_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `avatar_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `term_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`priority` tinyint(3) NOT NULL,
`blocked` tinyint(1) NOT NULL DEFAULT '1',
`readonly` tinyint(1) NOT NULL DEFAULT '0',
@@ -169,14 +166,12 @@ CREATE TABLE IF NOT EXISTS `contact` (
`reason` text NOT NULL COMMENT 'why a rating was given - will help friends decide to make friends or not',
`closeness` tinyint(2) NOT NULL DEFAULT '99',
`info` mediumtext NOT NULL,
- `profile-id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default',
+ `profile_id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default',
`bdyear` char(4) NOT NULL COMMENT 'birthday notify flag',
`bd` date NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `self` (`self`),
- KEY `issued-id` (`issued-id`),
- KEY `dfrn-id` (`dfrn-id`),
KEY `blocked` (`blocked`),
KEY `readonly` (`readonly`),
KEY `network` (`network`),
@@ -193,7 +188,8 @@ CREATE TABLE IF NOT EXISTS `contact` (
KEY `forum` (`forum`),
KEY `notify` (`notify`),
KEY `my_perms` (`my_perms`),
- KEY `their_perms` (`their_perms`)
+ KEY `their_perms` (`their_perms`),
+ KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `conv` (