re: 'mysqldump' doesn't preserve REFERENCES

2003-03-08 Thread Egor Egorov
On Saturday 08 March 2003 03:06, Daevid Vincent wrote: > If I create a table that uses REFERENCES in it, then mysqldump it, the > REFERENCES isn't there > > > Notice the `contact_dept_table_id` field in both of the below outputs: > > CREATE TABLE `contact_table` ( > `contact_id` mediumint(8) unsi

'mysqldump' doesn't preserve REFERENCES

2003-03-07 Thread Daevid Vincent
If I create a table that uses REFERENCES in it, then mysqldump it, the REFERENCES isn't there Notice the `contact_dept_table_id` field in both of the below outputs: CREATE TABLE `contact_table` ( `contact_id` mediumint(8) unsigned NOT NULL auto_increment, `contact_timestamp` timestamp(14) NO