Hello,
I'm doing a freinds network type of site. I wanted to know if i should create a new talbe called MemberFriends and keep adding rows for EVERY friend a member has OR
should i do only one row and keep appending to the data in the row.
Example:
option1:
create table TblmemberFriends
id int not null auto_increment,
memberid int not null
memberid_friend int not null
primary key(id)
insert into TblmemberFriends values ('',1,2);
insert into TblmemberFriends values ('',1,3);
insert into TblmemberFriends values ('',1,4);
insert into TblmemberFriends values ('',1,5);
option 2:
create table TblmemberFriends
memberid int not null
memberid_friend text
primary key(memberid)
insert into TblmemberFriends values (1,'5|');
insert into TblmemberFriends values (1,'5|3');
insert into TblmemberFriends values (1,'5|3|1|');
Option 3:
I do the above option 2 but without creating a new table, simply placing it inside my TblMemberProfiles.
CREATE TABLE TblMember (
member_id int NOT NULL auto_increment,
fname varchar(15) NOT NULL default '',
lname varchar(15) NOT NULL default '',
email_address varchar(100) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(10) NOT NULL default '',
latlogin datetime NOT NULL default '00000000 00:00:00',
create_date date NOT NULL default '00000000',
PRIMARY KEY (member_id)
) TYPE=MyISAM;
CREATE TABLE TblMemberProfiles (
TblMember_member_id int NOT NULL default '0',
gender int(1) NOT NULL default '0',
birthday int(8) NOT NULL default '0',
TblCountries_id int NOT NULL default '0',
Tblzip_z_zipCode int(11) NOT NULL default '0',
TblLanguage_id int NOT NULL default '0',
TblPreferTo_id int NOT NULL default '0',
TblPolitics_id int NOT NULL default '0',
TblPreference_id int NOT NULL default '0',
AboutMe blob NOT NULL,
WhoYouWanttoMeet blob NOT NULL,
ReceiveNewslettersandSpecialUpdates int(1) NOT NULL default '0',
ReceiveFriendUpdates int(1) NOT NULL default '0',
DisplayMyBirthdaytoFriends int(1) NOT NULL default '0',
block_list varchar(255) NOT NULL default '',
PRIMARY KEY (TblMember_member_id)
) TYPE=MyISAM;
