Comparing versions 35 and 36.
Database Schema
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
- 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)
- 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.
- The administrator has the option of keeping or deleting the links – if kept, they are moved to the ‘unassigned’ category