Thanks for that Monte, On 27 September 2010 13:44, Monte Goulding <mo...@sweattechnologies.com>wrote:
> UNIQUE INDEX `mykey` (`name`, `type`, `location`, `handler_num`) ); > > Or you can use a separate Create Unique Index statement. > OK - will have to read up more on Indexes - I thought they were just for speeding up searches - looks like they have some relationship to constraints as well. > PS MYSQL Workbench is free, cross platform and make nice diagrams ;-) > Yes - started using it after your earlier post. Also started using the Lua scritping - there si a script for exporting the schema as sqlite create sql that I am using. Trouble is it is easy to start making really big schema's :) _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution