Forums / General Questions / is there any document for zen-cart dababase?

is there any document for zen-cart dababase?

Locked

Results 1 to 9 of 9

This thread is locked. New replies are disabled.

29 Jun 2009, 1:57 AM

ghopper

New Zenner

Join Date:: Jan 2008
Posts:: 39
Plugin Contributions:: 0

is there any document for zen-cart dababase?

some fields in the tables are confused for me.

29 Jun 2009, 5:06 AM

data_digger

Zen Follower

Join Date:: Jan 2009
Posts:: 222
Plugin Contributions:: 2

Re: is there any document for zen-cart dababase?

As far as I can tell there's no such document. You can always ask here for meaning of particular columns.

29 Jun 2009, 5:14 AM

ghopper

New Zenner

Join Date:: Jan 2008
Posts:: 39
Plugin Contributions:: 0

Re: is there any document for zen-cart dababase?

In this table zencart_customers,

customers_dob datetime NOT NULL default '0001-01-01 00:00:00',

what's the mean of _dob ?

29 Jun 2009, 5:24 AM

kiddo

Totally Zenned

Join Date:: Jul 2006
Location:: SF Bay Area
Posts:: 837
Plugin Contributions:: 1

Re: is there any document for zen-cart dababase?

Date of Birth

29 Jun 2009, 9:51 AM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 177

Re: is there any document for zen-cart dababase?

data_digger:

As far as I can tell there's no such document.
http://www.zen-cart.com/wiki/index.php/Table_customers

30 Jun 2009, 1:01 AM

ghopper

New Zenner

Join Date:: Jan 2008
Posts:: 39
Plugin Contributions:: 0

Re: is there any document for zen-cart dababase?

thanks.

another question,
what's the mean of "dob" ?
is it related to birthday?
:D

30 Jun 2009, 1:09 AM

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,606
Plugin Contributions:: 0

Re: is there any document for zen-cart dababase?

Read post #4 again.

30 Jun 2009, 2:27 AM

ghopper

New Zenner

Join Date:: Jan 2008
Posts:: 39
Plugin Contributions:: 0

Re: is there any document for zen-cart dababase?

I got it. :smile:

how do I get to this page? I wanna see other tables.
http://www.zen-cart.com/wiki/index.php/Table_customers

The tables type is MyISAM. So the foreign keys don't work, do they?

1 Jul 2009, 11:54 PM

kiddo

Totally Zenned

Join Date:: Jul 2006
Location:: SF Bay Area
Posts:: 837
Plugin Contributions:: 1

Re: is there any document for zen-cart dababase?

the phpMyAdmin tool (not part of ZC) is excellent for exploring the ZC database and tables. The table and field names are (usually) pretty clear to figure out.