Subversion Repositories computer_asset_manager_v2

Rev

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

Rev 59 Rev 61
Line 112... Line 112...
112 
*/
 112 
*/
113 
drop table if exists device_type;
 113 
drop table if exists device_type;
114 
create table device_type (
 114 
create table device_type (
115 
   device_type_id int unsigned not null auto_increment,
 115 
   device_type_id int unsigned not null auto_increment,
116 
   name           varchar(64) comment 'name of device type',
 116 
   name           varchar(64) comment 'name of device type',
117 
   is_system      boolean comment 'if true, this is a system, ie a computer or virtual',
 - 
 
118 
   created        date comment 'date record was created',
 117 
   created        date comment 'date record was created',
119 
   removed        date comment 'date record was removed',
 118 
   removed        date comment 'date record was removed',
120 
   primary key    (device_type_id)
 119 
   primary key    (device_type_id)
121 
) comment 'simple child table to determine the type of device we have';
 120 
) comment 'simple child table to determine the type of device we have';
122
121