Chapter 7. For curious

Table of Contents
7.1. Directory tree
7.2. Database structure
7.2.1. LMS users ('users')
7.2.2. Customers ('customers')
7.2.3. Customer groups ('customergroups')
7.2.4. Customer groups - assignments ('customerassignments')
7.2.5. Customer groups - users access ('excludedgroups')
7.2.6. Networks ('networks')
7.2.7. Network devices ('netdevices')
7.2.8. Network connections ('netlinks')
7.2.9. Computers and IP addresses ('nodes')
7.2.10. MAC addresses ('macs')
7.2.11. Node groups ('nodegroups')
7.2.12. Node groups - assignments ('nodegroupassignments')
7.2.13. NAS Device Types ('nastypes')
7.2.14. Financial operations ('cash')
7.2.15. Import of financial operations ('cashimport')
7.2.16. Cash import sources ('cashsources')
7.2.17. Subscription fees ('tariffs')
7.2.18. Custom liabilities ('liabilities')
7.2.19. Solid payments ('payments')
7.2.20. Financial assignments ('assignments')
7.2.21. Nodes-tariffs assignments ('nodeassignments')
7.2.22. Tax rates ('taxes')
7.2.23. Documents numbering plans ('numberplans')
7.2.24. Numbering plans to divisions assignments ('numberplanassignments')
7.2.25. Cash registries ('cashregs')
7.2.26. Cash registries - access rights ('cashrights')
7.2.27. Cash registries - cash history ('cashreglog')
7.2.28. Documents: invoices, receipts, contracts, etc. ('documents')
7.2.29. Non-financial documents contents ('documentcontents')
7.2.30. Invoices ('invoicecontents')
7.2.31. Debit notes ('debitnotecontents')
7.2.32. Cash Receipts ('receiptcontents')
7.2.33. Documents - access rights ('docrights')
7.2.34. Internet Messengers ('imessengers')
7.2.35. Customers contacts ('customer contacts')
7.2.36. Domains ('domains')
7.2.37. DNS Records ('records')
7.2.38. Accounts ('passwd')
7.2.39. Aliases ('aliases')
7.2.40. Alias-to-account assignments ('aliasassignments')
7.2.41. VoIP Accounts ('voipaccounts')
7.2.42. Bandwidth consumption statistics ('stats')
7.2.43. Helpdesk - Request Tracking ('rtqueues')
7.2.44. Helpdesk - Request Tracking - continued... ('rttickets')
7.2.45. Helpdesk - Request Tracking - continued... ('rtmessages')
7.2.46. Helpdesk - Request Tracking - continued... ('rtattachments')
7.2.47. Helpdesk - Request Tracking - continued... ('rtnotes')
7.2.48. Helpdesk - Request Tracking - continued... ('rtrights')
7.2.49. LMS-UI Online Configuration ('uiconfig')
7.2.50. Timetable - events ('events')
7.2.51. Timetable - assignments ('eventassignments')
7.2.52. Sessions ('sessions')
7.2.53. Hosts ('hosts')
7.2.54. Daemon configuration - instances ('daemoninstances')
7.2.55. Daemon configuration - options ('daemonconfig')
7.2.56. States ('states')
7.2.57. Zip codes ('zipcodes')
7.2.58. Countries ('countries')
7.2.59. Companies/Divisions ('divisions')
7.2.60. Messages - list ('messages')
7.2.61. Messages - items ('messageitems')
7.2.62. 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
documentsDocuments archive
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