aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql17
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;