[TYPO3-irre] can I use a table twice

[Ulrich Fischer]

Hi Olly,

I use an mnasym connection
(m:n bidirectional anti-symmetric relations using intermediate table).
Like in your tutorial

#
# Table structure for table 'tx_irretutorial_mnasym_offer'
#
CREATE TABLE tx_irretutorial_mnasym_offer (
	uid int(11) NOT NULL auto_increment,
         ...
	hotels int(11) DEFAULT '0' NOT NULL,
         ...
);

I do not really understand what role this hotels field plays?

I want to use the table tx_irretutorial_mnasym_offer twice
(in my case it is a table with all countries in the world).
Is it possible to use it twice, and is it necessary to
have new int-field for the second connection?


for example:
CREATE TABLE tx_irretutorial_mnasym_offer (
	uid int(11) NOT NULL auto_increment,
         ...
	hotels int(11) DEFAULT '0' NOT NULL,
         events int(11) DEFAULT '0' NOT NULL,
         ...
);

Thank you for bringing the light

;-)Greetings

Ulrich

-- 
http://www.sunfish.de