start on contacts/profiles

1 files changed, 8 insertions, 9 deletions

diff --git a/database.sql b/database.sql
index 08832af11..d96b7b554 100644
--- a/database.sql
+++ b/database.sql
@@ -700,16 +700,16 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `aid` int(10) unsigned NOT NULL DEFAULT '0',
   `uid` int(11) NOT NULL,
   `profile_name` char(255) NOT NULL,
-  `is-default` tinyint(1) NOT NULL DEFAULT '0',
-  `hide-friends` tinyint(1) NOT NULL DEFAULT '0',
+  `is_default` tinyint(1) NOT NULL DEFAULT '0',
+  `hide_friends` 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',
   `address` char(255) NOT NULL,
   `locality` char(255) NOT NULL,
   `region` char(255) NOT NULL,
-  `postal-code` char(32) NOT NULL,
-  `country-name` char(255) NOT NULL,
+  `postal_code` char(32) NOT NULL,
+  `country_name` char(255) NOT NULL,
   `hometown` char(255) NOT NULL,
   `gender` char(32) NOT NULL,
   `marital` char(255) NOT NULL,
@@ -737,20 +737,19 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `photo` char(255) NOT NULL,
   `thumb` char(255) NOT NULL,
   `publish` tinyint(1) NOT NULL DEFAULT '0',
-  `net-publish` tinyint(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
-  KEY `is-default` (`is-default`),
   KEY `locality` (`locality`),
-  KEY `postal-code` (`postal-code`),
-  KEY `country-name` (`country-name`),
   KEY `hometown` (`hometown`),
   KEY `gender` (`gender`),
   KEY `marital` (`marital`),
   KEY `sexual` (`sexual`),
   KEY `publish` (`publish`),
-  KEY `net-publish` (`net-publish`),
   KEY `aid` (`aid`),
+  KEY `is_default` (`is_default`),
+  KEY `hide_friends` (`hide_friends`),
+  KEY `postal_code` (`postal_code`),
+  KEY `country_name` (`country_name`),
   FULLTEXT KEY `pub_keywords` (`pub_keywords`),
   FULLTEXT KEY `prv_keywords` (`prv_keywords`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;