0000287: optimize database structure and adapt code - PacketFence

Bug Tracking System

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000287

PacketFence 1.7

public

2008-01-29 12:09

2008-06-16 12:54

Reporter

rbalzard

Assigned To

user4

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

monotone

Summary

0000287: optimize database structure and adapt code

Description

Here 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);

Tags

No tags attached.

fixed in mtn revision

Attached Files

Relationships

related to

0000316

closed

user4

add locationlog_history table

Notes
(0000634) rbalzard (administrator) 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

Issue History
Date Modified	Username	Field	Change
2008-01-29 12:09	rbalzard	New Issue
2008-01-29 12:26	rbalzard	Note Added: 0000634
2008-02-01 09:20	user4	Status	new => assigned
2008-02-01 09:20	user4	Assigned To	=> user4
2008-05-12 15:59	user4	Relationship added	related to 0000316
2008-06-16 12:54	user4	Status	assigned => closed
2008-06-16 12:54	user4	Note Added: 0000739
2008-06-16 12:54	user4	Resolution	open => fixed
2008-06-16 12:54	user4	Fixed in Version	=> monotone