PacketFence - BTS - PacketFence 1.7
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000287PacketFence 1.7public2008-01-29 12:092008-06-16 12:54
Reporterrbalzard 
Assigned Touser4 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Versionmonotone 
fixed in mtn revision
Summary0000287: optimize database structure and adapt code
DescriptionHere are the optimizations I think are necessary:
- change node.status definition from varchar(15) to enum('reg','unreg')
- change violation.status definition from varchar(15) to enum('open','closed')
- change location_log.end_time definition to NOT NULL default '0000-00-00 00:00:00'
- create an index on node.status: alter table node add key status (status);
- create an index on iplog.end_time: alter table iplog add key end_time (end_time);
- create an index on locationlog.end_time: alter table locationlog add key end_time (end_time);
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
related to 0000316closed user4 add locationlog_history table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-01-29 12:09rbalzardNew Issue
2008-01-29 12:26rbalzardNote Added: 0000634
2008-02-01 09:20user4Statusnew => assigned
2008-02-01 09:20user4Assigned To => user4
2008-05-12 15:59user4Relationship addedrelated to 0000316
2008-06-16 12:54user4Statusassigned => closed
2008-06-16 12:54user4Note Added: 0000739
2008-06-16 12:54user4Resolutionopen => fixed
2008-06-16 12:54user4Fixed in Version => monotone

Notes
(0000634)
rbalzard   
2008-01-29 12:26   
Some other optimizations:
- in the tables node and location, make sure that, if possible, there is no field not defined with NOT NULL DEFAULT...
(0000739)
user4   
2008-06-16 12:54   
mtn revision f7557b4d02c17bfda7847deda3be06edc9d56b6d