Subversion Repositories computer_asset_manager_v2

Rev

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

Rev 34 Rev 37
Line 23... Line 23...
23 
drop table if exists attribute;
 23 
drop table if exists attribute;
24 
create table attribute (
 24 
create table attribute (
25 
   attribute_id   int unsigned not null auto_increment,
 25 
   attribute_id   int unsigned not null auto_increment,
26 
   name           varchar(64) not null comment 'name for display' ,
 26 
   name           varchar(64) not null comment 'name for display' ,
27 
   attribute_category_id int unsigned not null references attribute_category(attribute_category_id),
 27 
   attribute_category_id int unsigned not null references attribute_category(attribute_category_id),
- 
 
 28 
   display_in_summary boolean comment 'if true, indicates it should be displayed when device/site/client screen is open',
28 
   added          date,
 29 
   added          date,
29 
   removed        date default null,
 30 
   removed        date default null,
30 
   primary key    (attribute_id),
 31 
   primary key    (attribute_id),
31 
   index          (attribute_category_id)
 32 
   index          (attribute_category_id)
32 
) comment = 'stores attribute names (not values) for other tables';
 33 
) comment = 'stores attribute names (not values) for other tables';