# [EMAIL PROTECTED] / 2003-03-30 17:49:27 +0200:
> Hello, I was starting a php/mysql project in december and seeked for help on
> this mailing list, it has been a great help for solving problems.
> My application is a website where you can order meals from restaurants that
> are within your postcode area (UK only)
>
> The database structure has grown up to 30 tables. My biggest project yet.
> I would like to validate the database structure to SQL experts, in
> particular regarding mySQL indexes that I am not sure if it'll help or not,
> as there should be lots of select query while browsing the
> restaurants/menus.
> And I wonder how it will manage when there'll be 1000 restaurants or more.
>
> Here the sql dump of the main tables, please don't get scared ;-)
>
> CREATE TABLE `tgl_address` (
> `addressID` int(11) NOT NULL auto_increment,
> `address` varchar(255) NOT NULL default '',
> `postcode` varchar(10) NOT NULL default '',
> `city` varchar(30) NOT NULL default 'London',
> `website` varchar(255) NOT NULL default '',
> `email` varchar(100) NOT NULL default '',
> `phone` varchar(20) NOT NULL default '',
> `fax` varchar(20) NOT NULL default '',
> `sms` varchar(20) NOT NULL default '',
> `contact` varchar(20) NOT NULL default '',
> PRIMARY KEY (`addressID`),
> UNIQUE KEY `addressID` (`addressID`)
this is unnecessary duplication
(...)
the table structure is not very interesting without seeing how the
tables are related. could you post a schema somewhere on the web, or
otherwise describe the relations?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
