Friend and Love Project - Database Tables

HOME FORUM DEMO RECRUITMENTS ABOUT CONTACTS SPONSORS

Main Menu

Friend and Love

Project

Member Login

CB Workflows

You are not authorised to view this resource.
You need to login.

Who is Online

No Users Online

RSS Feeds

Project Info

Friend&Love is a free dating script written in PHP with MySQL Database. The basic features are included: profile, adult profile, send an unlimited note/wink, view track, who's online, who's new, profile search/auto search, set profile heading, upload photo.

Support Us

Help us grow the project faster, we invite you to contribute money to our project.

Language bother you?

Did weak English in this website bother you? Click here

Database Tables

This section will show you all table in project's database

This is a work in progress - not all tables have been described yet.
Feel free to help out by describing the missing tables.

The tables didn't put the prefix, usually is fnl_, in front of table name.

Table List in Alphabetical Order

account_status
action_type
charactors
country
height
join_for
messages - store the messages.
offense_list
online_status
photos
profile_detail
profile_general
sex
sex_orient
suggestion
term
users
user_level
user_log
user_penalty
user_pref
user_reserved

Table messages
This table use to store messages from member to member or system to member. Below is the table structure

Field: id
To identify the message.

Type: int(7)
Attributes: UNSIGNED ZEROFILL
Null: No
Extra: auto_increment
PRIMARY
Index
Unique

Field: timestamp
To record the message time

Type: varchar(14)
Null: No

Field: send_from
To identify the id of sender user

Type: int(7)
Attributes: UNSIGNED ZEROFILL
Null: No
Default: 0000000

Field: send_to
To identify the id of reciever

Type: int(7)
Attributes: UNSIGNED ZEROFILL
Null: No
Default: 0000000

Field: message
The message field

Type: text
Null: No

Field: attach_pic
Attach pic id, if any (future use)

Type: varchar(255)
Null: No

Field: mark_read
To identify if message is read or not

Type: tinyint(1)
Null: No
Default: 0

Field: notify_read
To tell the system if sender need notify after reciever read

Type: tinyint(1)
Null: No
Default: 0

Field: latest_reminder_sent
Timestamp of latest time that send reminder

Type: varchar(14)
Null: Yes

Last Updated ( Sunday, 07 January 2007 )

[ Back ]