Subversion Repositories computer_asset_manager_v2

Rev

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

Rev 19 Rev 20
Line 22... Line 22...
22 
   _user_id     int unsigned not null auto_increment,
 22 
   _user_id     int unsigned not null auto_increment,
23 
   username     varchar(32) not null comment 'user name for logging in',
 23 
   username     varchar(32) not null comment 'user name for logging in',
24 
   name         varchar(64) comment 'common name of user',
 24 
   name         varchar(64) comment 'common name of user',
25 
   email        varchar(64) comment 'email address of user',
 25 
   email        varchar(64) comment 'email address of user',
26 
   notes        text comment 'any notes about user',
 26 
   notes        text comment 'any notes about user',
27 
   pass         varchar(256) comment 'encrypted password of user',
 27 
   passwd       varchar(256) comment 'encrypted password of user',
28 
   access       text comment 'sql to determine what records user can view',
 28 
   access       text comment 'sql to determine what records user can view',
29 
   added_date   date not null comment 'Date record added to database',
 29 
   added_date   date not null comment 'Date record added to database',
30 
   removed_date date default null comment 'Date record marked as removed',
 30 
   removed_date date default null comment 'Date record marked as removed',
31 
   primary key ( _user_id )
 31 
   primary key ( _user_id )
32 
) comment 'user access to program';
 32 
) comment 'user access to program';