Subversion Repositories computer_asset_manager_v1

create table network_connection (
   network_connection_id   int unsigned not null auto-increment,
   connector_id   varchar(20) default null comment 'Use this to put things like cable number',
   source_device  int unsigned not null comment 'ID of the source device',
   source_port    varchar(20) comment 'Things like eth0, or port 1 for switches',
   target_device  int unsigned not null comment 'ID of target device',
   target_port    varchar(20) comment 'Things like eth0, or port 1 for switches',
   created_date   datetime,
   removed_date   datetime,
   primary key    (network_connection_id)
) comment 'Stores information about network connections between devices';


insert into network_connection select null,'Cable 09',