Chapter 7. For curious

Table of Contents
7.1. Directory tree
7.2. Database structure
7.2.1. LMS users ('admins')
7.2.2. Customers ('users')
7.2.3. Customer groups ('usergroups')
7.2.4. Customer groups - continued... ('userassignments')
7.2.5. Networks ('networks')
7.2.6. Computers and network devices ('nodes')
7.2.7. Network devices - continued... ('netdevices')
7.2.8. Network connections ('netlinks')
7.2.9. Financial operations ('cash')
7.2.10. Import of financial operations ('cashimport')
7.2.11. Subscription fees ('tariffs')
7.2.12. Solid payments ('payments')
7.2.13. Financial assignments ('assignments')
7.2.14. Invoices ('invoices')
7.2.15. Invoices - continued... ('invoicecontents')
7.2.16. Accounts ('passwd')
7.2.17. Domains ('domains')
7.2.18. Aliases ('aliases')
7.2.19. History ('timestamps')
7.2.20. Bandwidth consumption statistics ('stats')
7.2.21. Helpdesk - Request Tracking ('rtqueues')
7.2.22. Helpdesk - Request Tracking - continued... ('rttickets')
7.2.23. Helpdesk - Request Tracking - continued... ('rtmessages')
7.2.24. Helpdesk - Request Tracking - continued... ('rtattachments')
7.2.25. Helpdesk - Request Tracking - continued... ('rtrights')
7.2.26. LMS-UI Online Configuration ('uiconfig')
7.2.27. Timetable - events ('events')
7.2.28. Timetable - assignments ('eventassignments')
7.2.29. Sessions ('sessions')
7.2.30. Daemon configuration - hosts ('daemonhosts')
7.2.31. Daemon configuration - instances ('daemoninstances')
7.2.32. Daemon configuration - options ('daemonconfig')
7.2.33. Database information ('dbinfo')
7.3. Configuration file format
7.3.1. Comments
7.3.2. Sections, variables, values
7.3.3. Perl scripts variables
7.4. Filling DB with random data
7.5. Access levels
7.6. Restrictions
7.6.1. LMS project related
7.6.2. SQL engine related

7.1. Directory tree

Table 7-1. LMS directory tree

NameDescription
backupsBackup copies of LMS database
binExecutable lms-* Perl scripts
contribLMS user's contributions
daemonA.L.E.C's LMS Daemon
develDevelopers' scripts to build LMS package
docLMS Documentation
imgUser Interface Images
libSet of LMS and Smarty libraries
modulesUser Interface Modules
sampleSample scripts, configs and additions
templatesUser Interface Theme
templates_cSmarty Theme compilation directory