Hi,
The structure of the repligard table:
-------------------------------------------
CREATE TABLE `repligard` (
`id` int(11) NOT NULL default '0',
`changed` timestamp(14) NOT NULL,
`updated` timestamp(14) NOT NULL default '00000000000000',
`realm` varchar(32) NOT NULL default '',
`guid` varchar(32) NOT NULL default '',
`action` enum('create','update','delete') NOT NULL default 'create',
`sitegroup` int(11) NOT NULL default '0',
PRIMARY KEY (`guid`),
KEY `realm` (`realm`,`id`)
) TYPE=MyISAM;
-------------------------------------------
This structure definitly allows more than one guid for an object.
The line:
KEY `realm` (`realm`,`id`)
should be:
UNIQUE `realm` (`realm`,`id`)
Output of:
SELECT COUNT( id ) AS c, id, realm, MIN( guid ) , MAX( guid )
FROM `repligard`
GROUP BY id, realm
HAVING c >
1
+------------------------------------------------------------------------------
|c|id|realm |MIN( guid ) |MAX( guid )
+-+--+-------+--------------------------------+--------------------------------
|2|11|grp
|81807947746a42a5dcb9e55afe564646|96e693effa8752d87e862cf1681efe53
|2|16|article|47f8242124444af9eaedfe95cc2e616d|a423829274681e960efb65d987420f9b
|2|96|article|1998fba2946ca029dee0fac9bb549694|9daa660ffade41c30e54b83d074ced58
|2|97|article|1437332a8753667f47ad16049a71a092|c4d06bb1409521745359cc63c821d1a7
|2|98|article|596b31adb7632d16b92781dedf990d32|6ca617cdf8292454ce7febc740e57c24
|2|99|article|4d8b8b20c7d11deb3ca5a9f0381c7422|6a8e1e20c5cc01a436ac92851ce28d50
-----------------------------------------------------------------------------------------------
Maybe, these entries are a result bad administration in the past (i took
over this job a few weeks ago). But in my opinion, the db-structure
shouldn't allow this...
I haven't been working with midgard before, so my question is: Am i right or
is there something i don't understand:)) ??
regards
Gernot
--
NEU : GMX Internet.FreeDSL
Ab sofort DSL-Tarif ohne Grundgeb�hr: http://www.gmx.net/info
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
