PacketFence - BTS - PacketFence 1.7
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000316PacketFence 1.7public2008-05-08 09:272008-06-11 12:19
Reporteruser4 
Assigned Touser4 
PrioritynormalSeverityfeatureReproducibilityalways
StatusclosedResolutionsuspended 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
fixed in mtn revision
Summary0000316: add locationlog_history table
DescriptionThe locationlog table used by pfsetvlan should only contain the latest entries. Everything historic should go into locationlog_history so that searches are faster.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
related to 0000287closed user4 optimize database structure and adapt code 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-08 09:27user4New Issue
2008-05-08 09:27user4Statusnew => assigned
2008-05-08 09:27user4Assigned To => user4
2008-05-08 09:27user4Note Added: 0000699
2008-05-08 09:29rbalzardNote Added: 0000700
2008-05-08 09:31rbalzardNote Added: 0000701
2008-05-12 15:59user4Relationship addedrelated to 0000287
2008-06-11 12:19user4Statusassigned => closed
2008-06-11 12:19user4Note Added: 0000736
2008-06-11 12:19user4Resolutionopen => suspended

Notes
(0000699)
user4   
2008-05-08 09:27   
Reminder sent to: rbalzard
(0000700)
rbalzard   
2008-05-08 09:29   
some columns should be resized (port should be varchar(5))
(0000701)
rbalzard   
2008-05-08 09:31   
should create a script that would be dedicated to DB maintenance:
- guest unregistration
- locationlog cleanup
- backup
- ...
(0000736)
user4   
2008-06-11 12:19   
optimzed keys in locationlog table in mtn revision 389828afbdc2cfca5569fb78c2155e8583c48133