Guest Posted June 3, 2003 Posted June 3, 2003 Hello: Can someone help me understand the relationship between information I define for my store (e.g., categories, products, manufacturers) and the SQL database behind the scenes? From the Control Panel, after choosing MySQL, I see there are two databases: - One called ProductSales (locked by OSCommerce) - One called PGP (I'm) pretty sure I made this one After clicking on phyMyAdmin, I notice that there are only two databases: - One called PGP - One called TEST The TEST database has no tables. The PGP data base has information it it, but nothing that looks like my data (I see what appears to be info from the dafault database with OSCommerce). Any thoughts are appreciated. Thanks, Jack
Dave_L Posted June 3, 2003 Posted June 3, 2003 [2.2-MS1] The file catalog/install/oscommerce.sql contains the SQL queries that set up the osCommerce database. Using that file, you can see what tables and columns are used by osCommerce, so that may help you figure this out.
Guest Posted June 3, 2003 Posted June 3, 2003 Dave_L: Thanks for the reply. The SQL statements you refer to basically show me what schema was created when the database was initialized. I can see all of these same structures when I browse the database using the phyMyadmin tool. I can also see the data in those tables. The puzzling thing is that none of the data for my products, categories, etc., appears to be in the database. I was under the impesssion that much of the shop configuration you do writes to these database tables. Nothing's really broken here (yet!). I am just trying to figure out the [database?] information for my shop is being stored - I am an old DB guy...reliving the good old days 8) Thanks again, Jack
Guest Posted June 4, 2003 Posted June 4, 2003 Sorry for the confusion folks. Please ingore this thread. I was looking at the wrong database (PGP); the correct one was ProductSales. As expected, I can see all of the info (Categories, Products, etc.) that I added through the OSC admin tool. Hopefully, my next post will have more value to me and others :oops:
Recommended Posts
Archived
This topic is now archived and is closed to further replies.