Re: oscom table structure
Hi Andrew, Thanks for the reply, that makes your question clearer, but I havent had a chance yet to try the system you described. Sorry, unfortunately at this time I am unable to help. Best regards Nils Valentin 2003年 7月 20日 日曜日 03:48、olinux さんは書きました: > There is a diagram of the database included in the > milestone releases. it's in the top directory named > tep_database_2.2CVS.pdf or something like that. > > olinux > > --- Andrew <[EMAIL PROTECTED]> wrote: > > 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] > > __ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com -- --- 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]
RE: oscom table structure
There is a diagram of the database included in the milestone releases. it's in the top directory named tep_database_2.2CVS.pdf or something like that. olinux --- Andrew <[EMAIL PROTECTED]> wrote: > 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] > __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: oscom table structure
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]
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]
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]
