actually just add a little more to this, perhaps what I am after is some kind of tool that creates a DB schema layout , dare I say it like access ;) Is there something that does this for MySQL ?
Andrew >-----Original Message----- >From: Andrew [mailto:[EMAIL PROTECTED] >Sent: 19 July 2003 09:51 >To: Nils Valentin; [EMAIL PROTECTED]; MySQL-Lista >Subject: RE: oscom table structure > > >Thanks Nils, I will just add a little to the original question, I am >familar with the table structure in that I have access to the tables >ect. I have even installed a few versions of osc ;) > >I am asking if anyone has gone beyond looking at .sql and actually >worrking out how all the tables are related to one another and >possibly thereafter adding new tables to the existing structure. > >I have added tables to oscom but I really want to develop the >structure further, the plan is to add a full blown CMS > >Andrew > >>-----Original Message----- >>From: Nils Valentin [mailto:[EMAIL PROTECTED] >>Sent: 19 July 2003 01:25 >>To: [EMAIL PROTECTED]; MySQL-Lista >>Subject: Re: oscom table structure >> >> >>Hi Andrew, >> >> >>Unfortunately I am not, but I figured that it would probbaly take only 30-60 >>minutes to get the system set up on a machine ;-) >> >>Have you tried it yet ? >> >>You could login and use >> >>SHOW TABLES; >>DESCRIBE TABLES; >> >>to find the information you require. >> >>Best regards >> >>Nils Valentin >>Tokyo/Japan >> >> >> >>2003年 7月 19日 土曜日 01:24、Andrew さんは書きました: >>> are there any of you guys really familar with the mysql table structure of >>> oscommerce and in particular the search queries? >>> >>> Andrew >> >>-- >>--- >>Valentin Nils >>Internet Technology >> >> E-Mail: [EMAIL PROTECTED] >> URL: http://www.knowd.co.jp >> Personal URL: http://www.knowd.co.jp/staff/nils >> >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> >>--- >>Incoming mail is certified Virus Free. >>Checked by AVG anti-virus system (http://www.grisoft.com). >>Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003 >> >> > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]