Does it exist? I’m adding some tables to the database, and one of the tables will include a foreign key to the products. Does anybody know which table I should use? I assume it’s product and the primary key is product_id, but I want to be sure, since there are a bunch of product-related tables. Thanks.
[quote name=‘NBO_Mike’]Does it exist? I’m adding some tables to the database, and one of the tables will include a foreign key to the products. Does anybody know which table I should use? I assume it’s product and the primary key is product_id, but I want to be sure, since there are a bunch of product-related tables. Thanks.[/QUOTE]
Have fun
I had to work out everything myself as AFAIK, CS Cart hasn’t provided documentation. The primary key for most product tables (cscart_products) is indeed product_id.
If you need any info on some other tables, just ask. FYI, data in certain fields are serialised.
Thanks for the responses.
[quote]FYI, data in certain fields are serialised.[/quote]
What are the implications of serialized data?
ETInteractive, thanks for the file. I just wish there was a file describing what the fields represent. A database schema model would be nice, too.
[quote name=‘NBO_Mike’]Thanks for the responses.
What are the implications of serialized data?[/QUOTE]
[url]PHP: Manual Quick Reference
[url]PHP: Manual Quick Reference