Changeset 6730


Ignore:
Timestamp:
Jul 29, 2010, 1:33:08 PM (14 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.