# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                         127.0.0.1
# Database:                     link-style
# Server version:               5.1.33-community
# Server OS:                    Win32
# Target compatibility:         ANSI SQL
# HeidiSQL version:             4.0
# Date/time:                    2009-05-26 08:37:18
# --------------------------------------------------------

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Database structure for database 'link-style'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "link-style" /*!40100 DEFAULT CHARACTER SET latin1 */;

USE "link-style";


#
# Table structure for table 'activity'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "activity" (
  "ActivityID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "StartTimestamp" timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  "EndTimestamp" timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  "ActivityName" varchar(50) NOT NULL,
  "ActivityDetails" text NOT NULL,
  "ActivityLocation" varchar(50) DEFAULT NULL,
  "HostBy" int(10) unsigned NOT NULL,
  "HostType" char(1) DEFAULT 'l',
  "BasicInterestsType" varchar(50) DEFAULT NULL,
  "OtherInterestsType" varchar(50) DEFAULT NULL,
  "ImgPath" varchar(50) DEFAULT NULL,
  "Country" varchar(25) NOT NULL,
  "ActivityStatus" varchar(20) NOT NULL,
  "TimeCreated" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "ActivityType" varchar(10) NOT NULL,
  PRIMARY KEY ("ActivityID")
) AUTO_INCREMENT=4;



#
# Dumping data for table 'activity'
#

# No data found.



#
# Table structure for table 'ban'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "ban" (
  "BanID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "UserID" int(10) unsigned NOT NULL,
  "BanDate" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  "Reason" varchar(50) NOT NULL,
  "Rate" int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY ("BanID")
);



#
# Dumping data for table 'ban'
#

# No data found.



#
# Table structure for table 'buddy'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "buddy" (
  "BuddyID" int(11) NOT NULL AUTO_INCREMENT,
  "UserID" int(10) unsigned NOT NULL,
  "BuddyUserID" int(10) unsigned NOT NULL,
  "Group" varchar(30) DEFAULT NULL,
  PRIMARY KEY ("BuddyID")
);



#
# Dumping data for table 'buddy'
#

# No data found.



#
# Table structure for table 'chat'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "chat" (
  "ChatID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "PostMsg" varchar(50) NOT NULL,
  "PostBy" int(10) unsigned NOT NULL,
  "PostTime" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ("ChatID")
);



#
# Dumping data for table 'chat'
#

# No data found.



#
# Table structure for table 'goal'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "goal" (
  "GoalID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "GoalTitle" varchar(50) NOT NULL,
  "GoalDetails" text NOT NULL,
  "Priority" char(1) DEFAULT 'M',
  "StartDate" date NOT NULL,
  "EndDate" date NOT NULL,
  "Status" varchar(20) DEFAULT NULL,
  PRIMARY KEY ("GoalID")
);



#
# Dumping data for table 'goal'
#

# No data found.



#
# Table structure for table 'grp'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "grp" (
  "GroupID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "GroupName" varchar(50) NOT NULL,
  "GroupDetails" text NOT NULL,
  "BasicInterestsType" varchar(50) DEFAULT NULL,
  "OtherInterestsType" varchar(50) DEFAULT NULL,
  "Country" varchar(50) NOT NULL,
  "ImgPath" varchar(50) DEFAULT NULL,
  "Owner" int(10) unsigned NOT NULL,
  "TimeCreated" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ("GroupID")
);



#
# Dumping data for table 'grp'
#

# No data found.



#
# Table structure for table 'grp_member'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "grp_member" (
  "GroupMemberID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "GroupID" int(10) unsigned NOT NULL,
  "UserID" int(10) unsigned NOT NULL,
  "TimeJoined" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ("GroupMemberID")
);



#
# Dumping data for table 'grp_member'
#

# No data found.



#
# Table structure for table 'msg'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "msg" (
  "MsgID" int(11) NOT NULL AUTO_INCREMENT,
  "Recipient" int(10) unsigned NOT NULL,
  "SentBy" int(10) unsigned NOT NULL,
  "Subject" varchar(50) NOT NULL,
  "MsgDetails" text NOT NULL,
  "TimeSent" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ("MsgID")
);



#
# Dumping data for table 'msg'
#

# No data found.



#
# Table structure for table 'msg_attachment'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "msg_attachment" (
  "MsgAttachID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "MsgID" int(10) unsigned DEFAULT NULL,
  "FilePath" varchar(50) NOT NULL,
  PRIMARY KEY ("MsgAttachID")
);



#
# Dumping data for table 'msg_attachment'
#

# No data found.



#
# Table structure for table 'notification'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "notification" (
  "NotificationID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "NotificationTitle" varchar(50) NOT NULL,
  "NotificationDetails" text NOT NULL,
  "NotificationType" char(1) NOT NULL,
  "NotifyFrom" int(10) unsigned DEFAULT NULL,
  "NotifyTo" int(10) unsigned NOT NULL,
  PRIMARY KEY ("NotificationID")
);



#
# Dumping data for table 'notification'
#

# No data found.



#
# Table structure for table 'participation'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "participation" (
  "ParticipationID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "UserID" int(10) unsigned NOT NULL,
  "ActivityID" int(10) unsigned NOT NULL,
  "ParticipationStatus" varchar(20) DEFAULT NULL,
  "TimeJoined" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  "Role" varchar(20) NOT NULL,
  PRIMARY KEY ("ParticipationID")
);



#
# Dumping data for table 'participation'
#

# No data found.



#
# Table structure for table 'photo'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "photo" (
  "PhotoID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "UploadTo" int(10) unsigned DEFAULT NULL,
  "UploadBy" int(10) unsigned NOT NULL,
  "TimeAdded" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  "FilePath" varchar(50) NOT NULL,
  "ResidesIn" varchar(15) DEFAULT NULL,
  "GroupName" varchar(30) DEFAULT NULL,
  PRIMARY KEY ("PhotoID")
);



#
# Dumping data for table 'photo'
#

# No data found.



#
# Table structure for table 'report'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "report" (
  "ReportID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "ReportBy" int(10) unsigned NOT NULL,
  "ReportTarget" int(10) unsigned NOT NULL,
  "AbuseType" char(1) NOT NULL,
  "ReportTime" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  "ReportDetails" text NOT NULL,
  PRIMARY KEY ("ReportID")
);



#
# Dumping data for table 'report'
#

# No data found.



#
# Table structure for table 'reward'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "reward" (
  "RewardID" int(11) NOT NULL AUTO_INCREMENT,
  "RewardName" varchar(100) NOT NULL,
  "PointsNeeded" int(5) unsigned DEFAULT NULL,
  "ImgPath" varchar(50) NOT NULL,
  "RedeemBy" int(10) unsigned DEFAULT NULL,
  "DeliverTo" varchar(50) DEFAULT NULL,
  PRIMARY KEY ("RewardID")
);



#
# Dumping data for table 'reward'
#

# No data found.



#
# Table structure for table 'twitter'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "twitter" (
  "TwitterID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "Text" varchar(100) NOT NULL,
  "UserID" int(10) unsigned NOT NULL,
  "EntryTime" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ("TwitterID")
);



#
# Dumping data for table 'twitter'
#

# No data found.



#
# Table structure for table 'user'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "user" (
  "UserID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "Email" varchar(50) NOT NULL,
  "Password" varchar(15) NOT NULL,
  "Gender" char(1) NOT NULL,
  "DOB" date DEFAULT NULL,
  "DisplayName" varchar(20) NOT NULL,
  "FirstName" varchar(50) DEFAULT NULL,
  "LastName" varchar(50) DEFAULT NULL,
  "Country" varchar(25) NOT NULL,
  "ZipCode" int(6) unsigned NOT NULL,
  "BasicInterests" varchar(50) DEFAULT NULL,
  "OtherInterests" varchar(50) DEFAULT NULL,
  "HealthStatus" varchar(50) NOT NULL,
  "LastActivityDate" date NOT NULL,
  "RewardPoints" int(10) unsigned NOT NULL,
  "NumOfParticipation" int(10) unsigned NOT NULL,
  "AccumulatedPoints" int(10) unsigned NOT NULL,
  "ImgPath" varchar(50) DEFAULT NULL,
  "ParticipatedEvents" text,
  "OnlineStatus" char(1) DEFAULT 'F',
  "MobileContact" char(8) DEFAULT NULL,
  "HomeContact" char(8) DEFAULT NULL,
  "Height" int(3) unsigned DEFAULT NULL,
  "Weight" int(3) unsigned DEFAULT NULL,
  PRIMARY KEY ("UserID")
);



#
# Dumping data for table 'user'
#

# No data found.



#
# Table structure for table 'video'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "video" (
  "VideoID" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "UploadTo" int(10) unsigned DEFAULT NULL,
  "UploadBy" int(10) unsigned NOT NULL,
  "TimeAdded" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  "FilePath" varchar(50) NOT NULL,
  "ResidesIn" varchar(15) DEFAULT NULL,
  "GroupName" varchar(30) DEFAULT NULL,
  PRIMARY KEY ("VideoID")
);



#
# Dumping data for table 'video'
#

# No data found.

/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/