Subversion Repositories computer_asset_manager_v1

Rev

Rev 51 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 51 Rev 90
Line 9... Line 9...
9 
   removed_date   datetime,
 9 
   removed_date   datetime,
10 
   primary key    (network_connection_id)
 10 
   primary key    (network_connection_id)
11 
) comment 'Stores information about network connections between devices';
 11 
) comment 'Stores information about network connections between devices';
12 
 
 12 
 
13 
 
 13 
 
14 
insert into network_connection select null,'Cable 09',
 - 
 
15 
 
 14 
insert into network_connection select null,'Cable 09',
- 
 
 15 
 
- 
 
 16 
 
- 
 
 17 
create table network (
- 
 
 18 
   network_id     int unsigned not null auto_increment,
- 
 
 19 
   device_1       int unsigned not null references device(device_id),
- 
 
 20 
   port_1         varchar(16) comment 'Port it is plugged into',
- 
 
 21 
   device_2       int unsigned not null references device(device_id),
- 
 
 22 
   port_2         varchar(16) comment 'Port it is plugged into',
- 
 
 23 
   connector      int unsigned references connectors(connector_id)
- 
 
 24 
   primary key    (network_id)
- 
 
 25 
);
- 
 
 26 
 
- 
 
 27 
create table connectors (
- 
 
 28 
   connectors_id  int unsigned not null auto_increment,
- 
 
 29 
   cable          varchar(16),
- 
 
 30 
   markings       varchar(16),
- 
 
 31 
   primary key    (connectors_id)
- 
 
 32 
);
- 
 
 33