Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- tbl_user
- --------------------------------
- id - int UNIQUE PRIMARY AUTO INCREMENT
- username - varchar
- password - varchar
- status - int
- since - DATE
- id: Entry ID
- username: User ID
- password: User Password as HASH
- status: Account Status (0 - not confirmed | 1 - confirmed | 2 - banned)
- since: Date of registration
- tbl_friendship
- --------------------------------
- id - int UNIQUE PRIMARY AUTO INCREMENT
- user_a - varchar
- user_b - varchar
- status - int
- since - DATE
- id: Entry ID
- user_a: User ID
- user_b: User ID
- status: Friend Status (0 - pending | 1 - approved)
- since: Date of approval (if pending creation Date)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement