Linkster

Database Schema

You can find the MySQL script on the SVN repository

Tables:

• lr_users
  • user_id
  • FK_group_id
  • FK_banned_id
  • FK_country_id
  • active [TINYINT 1]
  • name
  • surname
  • username
  • password
  • hash
  • email
  • join_date
  • activation_code
  • change_password
  • last_failure
  • failed_logins

• lr_user_groups
  • group_id
  • title
  • description

• lr_banned
  • id
  • reason

• lr_countries
  • id
  • country

• lr_sessions
  • session_id
  • ip_address
  • user_agent
  • last_activity

• lr_categories
  • category_id
  • name
  • description
  • entry_count

• lr_entries
  • entry_id
  • FK_category_id
  • FK_user_id
  • active [TINYINT 1]
  • title
  • description
  • date_added
  • url

• lr_pages
  • page_id
  • active
  • url
  • meta_description
  • meta_keywords
  • title
  • content

Specifications

Deleting a user:

• When a user is deleted his links are, too. This can be acomplished automatically with a DB relation (already done in the actually sql script)

Deleting a user group:

• There are two root groups that cannot be deleted: Users and Admins . If a child group is deleted, all members of that group are automatically moved to the parent group.

Deleting a category:

• The administrator has the option of keeping or deleting the links – if kept, they are moved to the ‘unassigned’ category