Changeset 6730


Ignore:
Timestamp:
07/29/10 13:33:08 (10 years ago)
Author:
grum
Message:

"user_tags_defs" table definition was not correct

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/AMetaData/amd_install.class.inc.php

    r6729 r6730  
    9999);", 
    100100"CREATE TABLE `".$this->tables['user_tags_def']."` ( 
    101   `defId` int(10) unsigned NOT NULL auto_increment, 
     101  `numId` int(10) unsigned NOT NULL COMMENT 'Id of the tag', 
     102  `defId` int(10) unsigned NOT NULL default '0' COMMENT 'also used for ordering', 
    102103  `parentId` int(10) unsigned NOT NULL default '0' COMMENT 'Id of the parent', 
    103   `numId` int(10) unsigned NOT NULL COMMENT 'Id of the tag', 
    104   `order` int(10) unsigned NOT NULL COMMENT 'Order, relative to the parent', 
     104  `order` int(10) unsigned NOT NULL, 
    105105  `type` char(1) NOT NULL default 'T' COMMENT 'T = static text ; M = metadata value ; C = condition', 
    106106  `value` varchar(200) NOT NULL, 
    107107  `conditionType` char(2) NOT NULL default 'E', 
    108108  `conditionValue` varchar(200) NOT NULL, 
    109   PRIMARY KEY  (`defId`), 
    110   KEY `byTagNumId` (`numId`,`parentId`,`order`), 
    111   KEY `byTagParentId` (`parentId`,`order`) 
     109  PRIMARY KEY  (`numId`,`defId`), 
     110  KEY `byTagParentId` USING BTREE (`numId`,`parentId`,`order`), 
     111  KEY `byTagOrder` (`numId`,`order`) 
    112112);", 
    113113      ); 
     
    204204);", 
    205205"CREATE TABLE `".$this->tables['user_tags_def']."` ( 
    206   `defId` int(10) unsigned NOT NULL auto_increment, 
     206  `numId` int(10) unsigned NOT NULL COMMENT 'Id of the tag', 
     207  `defId` int(10) unsigned NOT NULL default '0' COMMENT 'also used for ordering', 
    207208  `parentId` int(10) unsigned NOT NULL default '0' COMMENT 'Id of the parent', 
    208   `numId` int(10) unsigned NOT NULL COMMENT 'Id of the tag', 
    209   `order` int(10) unsigned NOT NULL COMMENT 'Order, relative to the parent', 
     209  `order` int(10) unsigned NOT NULL, 
    210210  `type` char(1) NOT NULL default 'T' COMMENT 'T = static text ; M = metadata value ; C = condition', 
    211211  `value` varchar(200) NOT NULL, 
    212212  `conditionType` char(2) NOT NULL default 'E', 
    213213  `conditionValue` varchar(200) NOT NULL, 
    214   PRIMARY KEY  (`defId`), 
    215   KEY `byTagNumId` (`numId`,`parentId`,`order`), 
    216   KEY `byTagParentId` (`parentId`,`order`) 
     214  PRIMARY KEY  (`numId`,`defId`), 
     215  KEY `byTagParentId` USING BTREE (`numId`,`parentId`,`order`), 
     216  KEY `byTagOrder` (`numId`,`order`) 
    217217);" 
    218218      ); 
Note: See TracChangeset for help on using the changeset viewer.