Changeset 395

Show
Ignore:
Timestamp:
06/27/09 14:28:49 (11 years ago)
Author:
kovell
Message:

Fixes: Incorrect indexing on installation files & surplus ')'

Location:
dev/packages/database
Files:
2 modified

Legend:

Unmodified
Added
Removed
  • dev/packages/database/kb3_config/table.xml

    r394 r395  
    77  `cfg_key` char(32) NOT NULL, 
    88  `cfg_value` text NOT NULL, 
    9   PRIMARY KEY `cfg_site` (`cfg_site`,`cfg_key`)) 
     9  PRIMARY KEY (`cfg_site`,`cfg_key`) 
    1010) Type=MyISAM  DEFAULT CHARSET=utf8;</structure> 
    1111</kb3> 
  • dev/packages/database/kb3_roles/table.xml

    r376 r395  
    88  `rol_name` char(150) NOT NULL, 
    99  `rol_descr` char(150) NOT NULL, 
    10   PRIMARY KEY  (`rol_id`), 
    11   UNIQUE KEY `rol_name` (`rol_name`), 
     10  PRIMARY KEY  (`rol_id`, `rol_site`), 
     11  KEY `rol_name` (`rol_name`), 
    1212  KEY `rol_site` (`rol_site`,`rol_name`,`rol_descr`) 
    1313) Type=MyISAM  DEFAULT CHARSET=utf8;</structure>