<?php

//table askme -----------------------------------------------------------------
$TableStructure['askme'] = "CREATE TABLE `".PR_DATABASE_PREFIX."askme` (
  `askme_id` bigint(20) NOT NULL auto_increment,
  `askme_asker_name` varchar(255) default NULL,
  `askme_asker_url` varchar(255) default NULL,
  `askme_asker_mail` varchar(255) default NULL,
  `askme_question` text,
  `askme_question_time` datetime default NULL,
  `askme_answer` longtext,
  `askme_answer_time` datetime default NULL,
  `askme_status` set('toanswer','answered') default NULL,
  PRIMARY KEY  (`askme_id`)
)";

//table block ------------------------------------------------------------------
$TableStructure['block'] = "CREATE TABLE `".PR_DATABASE_PREFIX."block` (
  `block_id` bigint(20) NOT NULL auto_increment,
  `block_name` varchar(255) default NULL,
  `block_value` text,
  `block_category` set('sidebar','footer') default NULL,
  `block_status` set('show','hide') default NULL,
  PRIMARY KEY  (`block_id`)
)";

//table config -----------------------------------------------------------------
$TableStructure['config'] = "CREATE TABLE `".PR_DATABASE_PREFIX."config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) default NULL,
  PRIMARY KEY  (`config_name`)
)";

//table friend ------------------------------------------------------------------
$TableStructure['friend'] = "CREATE TABLE `".PR_DATABASE_PREFIX."friend` (
  `friend_id` bigint(20) NOT NULL auto_increment,
  `friend_name` varchar(255) default NULL,
  `friend_description` text,
  `friend_image` varchar(32) default NULL,
  `friend_realname` varchar(255) default NULL,
  `friend_sex` set('male','female') default NULL,
  `friend_email` varchar(255) default NULL,
  `friend_dateofbirth` varchar(255) default NULL,
  `friend_country` varchar(255) default NULL,
  `friend_city` varchar(255) default NULL,
  `friend_platform_id` varchar(255) default NULL,
  `friend_homepage` varchar(255) default NULL,
  `friend_time` datetime default NULL,
  `friend_label` varchar(32) default NULL,
  `friend_connect_url` varchar(255) default NULL,
  PRIMARY KEY  (`friend_id`)
)";


//table identity -------------------------------------------------------------------
$TableStructure['identity'] = "CREATE TABLE `".PR_DATABASE_PREFIX."identity` (
  `identity_name` varchar(255) NOT NULL default '',
  `identity_value` varchar(255) default NULL,
  PRIMARY KEY  (`identity_name`)
)";


//table link -----------------------------------------------------------------------
$TableStructure['link'] = "CREATE TABLE `".PR_DATABASE_PREFIX."link` (
  `link_id` bigint(20) NOT NULL auto_increment,
  `link_name` varchar(255) default NULL,
  `link_url` varchar(255) default NULL,
  `link_title` varchar(255) default NULL,
  `link_category` varchar(255) default NULL,
  PRIMARY KEY  (`link_id`)
)";


//table profile ----------------------------------------------------------------------
$TableStructure['profile'] = "CREATE TABLE `".PR_DATABASE_PREFIX."profile` (
  `profile_id` bigint(20) NOT NULL auto_increment,
  `profile_name` varchar(255) default NULL,
  `profile_value` text,
  `profile_category` varchar(255) default NULL,
  `profile_category_rank` int(11) default NULL,
  `profile_status` set('show','hide') default 'show',
  PRIMARY KEY  (`profile_id`)
)";


//table scratch ----------------------------------------------------------------------
$TableStructure['scratch'] = "CREATE TABLE `".PR_DATABASE_PREFIX."scratch` (
  `scratch_id` bigint(20) NOT NULL auto_increment,
  `scratch_user_name` varchar(32) default NULL,
  `scratch_user_url` varchar(255) default NULL,
  `scratch_user_mail` varchar(64) default NULL,
  `scratch_value` text,
  `scratch_time` datetime default NULL,
  `scratch_status` set('moderate','okay') default 'moderate',
  PRIMARY KEY  (`scratch_id`)
)";
?>