Table categories
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Contains all the information about a given category that can't reasonably be translated into multiple languages. All of the contained information is consistent across all installed languages.
- Language-specific data about each category is found in the categories_description table.
Table Details
Primary Key
Indexed Fields
Columns
categories_id 
- A unique, auto incremented value, to identify each category record.
Type: int(11) Null: No Default: Extra: auto_increment
categories_image
- The path to the category image for the category relative to DIR_WS_CATALOG/images/.
Type: varchar(64) Null: Yes Default: NULL
parent_id 
- Links the record to a parent category. Recursive foreign key to categories_id.
Type: int(11) Null: No Default: 0
What it Means!
A value of 0 means that this is a top-level category.
sort_order
- The sort order of this category. 0 = top.
Type: int(3) Null: Yes Default: NULL
date_added
- The date and time this category was added to the database.
Type: datetime Null: Yes Default: NULL
last_modified
- The date and time this category was last modified.
Type: datetime Null: Yes Default: NULL
categories_status
- The status of the category. Can be set to 0 (disabled) or 1 (enabled).
Type: tinyint(1) Null: No Default: 1
Default Entries (assuming demo data installed)
categories_id: 1 categories_image: categories/category_hardware.gif parent_id: 0 sort_order: 1 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:32:17 categories_status: 1
categories_id: 2 categories_image: categories/category_software.gif parent_id: 0 sort_order: 2 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-22 21:14:57 categories_status: 1
categories_id: 3 categories_image: categories/category_dvd_movies.gif parent_id: 0 sort_order: 3 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:22:39 categories_status: 1
categories_id: 4 categories_image: categories/subcategory_graphic_cards.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 5 categories_image: categories/subcategory_printers.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 6 categories_image: categories/subcategory_monitors.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 7 categories_image: categories/subcategory_speakers.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 8 categories_image: categories/subcategory_keyboards.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 9 categories_image: categories/subcategory_mice.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:34:10 categories_status: 1
categories_id: 10 categories_image: categories/subcategory_action.gif parent_id: 3 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:39:17 categories_status: 1
categories_id: 11 categories_image: categories/subcategory_science_fiction.gif parent_id: 3 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 12 categories_image: categories/subcategory_comedy.gif parent_id: 3 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 13 categories_image: categories/subcategory_cartoons.gif parent_id: 3 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:23:13 categories_status: 1
categories_id: 14 categories_image: categories/subcategory_thriller.gif parent_id: 3 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 15 categories_image: categories/subcategory_drama.gif parent_id: 3 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 16 categories_image: categories/subcategory_memory.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 17 categories_image: categories/subcategory_cdrom_drives.gif parent_id: 1 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 18 categories_image: categories/subcategory_simulation.gif parent_id: 2 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 19 categories_image: categories/subcategory_action_games.gif parent_id: 2 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 20 categories_image: categories/subcategory_strategy.gif parent_id: 2 sort_order: 0 date_added: 2003-12-23 03:18:19 last_modified: NULL categories_status: 1
categories_id: 21 categories_image: categories/gv_25.gif parent_id: 0 sort_order: 4 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:26:06 categories_status: 1
categories_id: 22 categories_image: categories/box_of_color.gif parent_id: 0 sort_order: 5 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-21 00:28:43 categories_status: 1
categories_id: 23 categories_image: waybkgnd.gif parent_id: 0 sort_order: 500 date_added: 2003-12-28 02:26:19 last_modified: 2003-12-29 23:21:35 categories_status: 1
categories_id: 24 categories_image: categories/category_free.gif parent_id: 0 sort_order: 600 date_added: 2003-12-28 11:48:46 last_modified: 2004-01-02 19:13:45 categories_status: 1
categories_id: 25 categories_image: sample_image.gif parent_id: 0 sort_order: 515 date_added: 2003-12-31 02:39:17 last_modified: 2004-01-24 01:49:12 categories_status: 1
categories_id: 27 categories_image: sample_image.gif parent_id: 49 sort_order: 10 date_added: 2004-01-04 14:13:08 last_modified: 2004-01-24 16:16:23 categories_status: 1
categories_id: 28 categories_image: sample_image.gif parent_id: 0 sort_order: 510 date_added: 2004-01-04 17:13:47 last_modified: 2004-01-05 23:54:23 categories_status: 1
categories_id: 31 categories_image: sample_image.gif parent_id: 48 sort_order: 30 date_added: 2004-01-04 23:16:46 last_modified: 2004-01-24 01:48:29 categories_status: 1
categories_id: 32 categories_image: sample_image.gif parent_id: 48 sort_order: 40 date_added: 2004-01-05 01:34:56 last_modified: 2004-01-24 01:48:36 categories_status: 1
categories_id: 33 categories_image: categories/subcategory.gif parent_id: 0 sort_order: 700 date_added: 2004-01-05 02:08:31 last_modified: 2004-05-20 10:35:31 categories_status: 1
categories_id: 34 categories_image: categories/subcategory.gif parent_id: 33 sort_order: 10 date_added: 2004-01-05 02:08:50 last_modified: 2004-05-20 10:35:57 categories_status: 1
categories_id: 35 categories_image: categories/subcategory.gif parent_id: 33 sort_order: 20 date_added: 2004-01-05 02:09:01 last_modified: 2004-01-24 00:07:33 categories_status: 1
categories_id: 36 categories_image: categories/subcategory.gif parent_id: 33 sort_order: 30 date_added: 2004-01-05 02:09:12 last_modified: 2004-01-24 00:07:41 categories_status: 1
categories_id: 37 categories_image: categories/subcategory.gif parent_id: 35 sort_order: 10 date_added: 2004-01-05 02:09:28 last_modified: 2004-01-24 00:22:39 categories_status: 1
categories_id: 38 categories_image: categories/subcategory.gif parent_id: 35 sort_order: 20 date_added: 2004-01-05 02:09:39 last_modified: 2004-01-24 00:22:46 categories_status: 1
categories_id: 39 categories_image: categories/subcategory.gif parent_id: 35 sort_order: 30 date_added: 2004-01-05 02:09:49 last_modified: 2004-01-24 00:22:53 categories_status: 1
categories_id: 40 categories_image: categories/subcategory.gif parent_id: 34 sort_order: 10 date_added: 2004-01-05 02:17:27 last_modified: 2004-05-20 10:36:19 categories_status: 1
categories_id: 41 categories_image: categories/subcategory.gif parent_id: 36 sort_order: 10 date_added: 2004-01-05 02:21:02 last_modified: 2004-01-24 00:23:04 categories_status: 1
categories_id: 42 categories_image: categories/subcategory.gif parent_id: 36 sort_order: 30 date_added: 2004-01-05 02:21:14 last_modified: 2004-01-24 00:23:18 categories_status: 1
categories_id: 43 categories_image: categories/subcategory.gif parent_id: 34 sort_order: 20 date_added: 2004-01-05 02:21:29 last_modified: 2004-01-24 00:21:37 categories_status: 1
categories_id: 44 categories_image: categories/subcategory.gif parent_id: 36 sort_order: 20 date_added: 2004-01-05 02:21:47 last_modified: 2004-01-24 00:23:11 categories_status: 1
categories_id: 45 categories_image: sample_image.gif parent_id: 48 sort_order: 10 date_added: 2004-01-05 23:54:56 last_modified: 2004-01-24 01:48:22 categories_status: 1
categories_id: 46 categories_image: sample_image.gif parent_id: 50 sort_order: 10 date_added: 2004-01-06 00:01:48 last_modified: 2004-01-24 01:39:56 categories_status: 1
categories_id: 47 categories_image: sample_image.gif parent_id: 48 sort_order: 20 date_added: 2004-01-06 03:09:57 last_modified: 2004-01-24 01:48:05 categories_status: 1
categories_id: 48 categories_image: sample_image.gif parent_id: 0 sort_order: 1000 date_added: 2004-01-07 02:24:07 last_modified: 2004-01-07 02:44:26 categories_status: 1
categories_id: 49 categories_image: sample_image.gif parent_id: 0 sort_order: 1100 date_added: 2004-01-07 02:27:31 last_modified: 2004-01-07 02:44:34 categories_status: 1
categories_id: 50 categories_image: sample_image.gif parent_id: 0 sort_order: 1200 date_added: 2004-01-07 02:28:18 last_modified: 2004-01-07 02:47:19 categories_status: 1
categories_id: 51 categories_image: sample_image.gif parent_id: 50 sort_order: 20 date_added: 2004-01-07 02:33:55 last_modified: 2004-01-24 01:40:05 categories_status: 1
categories_id: 52 categories_image: sample_image.gif parent_id: 49 sort_order: 20 date_added: 2004-01-24 16:09:35 last_modified: 2004-01-24 16:16:33 categories_status: 1
categories_id: 53 categories_image: categories/subcategory.gif parent_id: 0 sort_order: 1500 date_added: 2004-04-25 23:07:41 last_modified: NULL categories_status: 1
categories_id: 54 categories_image: categories/subcategory.gif parent_id: 0 sort_order: 1510 date_added: 2004-04-26 12:02:35 last_modified: 2004-05-20 11:45:20 categories_status: 1
categories_id: 55 categories_image: categories/subcategory.gif parent_id: 54 sort_order: 0 date_added: 2004-04-28 01:48:47 last_modified: 2004-05-20 11:45:51 categories_status: 1
categories_id: 56 categories_image: categories/subcategory.gif parent_id: 54 sort_order: 0 date_added: 2004-04-28 01:49:16 last_modified: 2004-04-28 01:53:14 categories_status: 1
categories_id: 57 categories_image: categories/subcategory.gif parent_id: 54 sort_order: 0 date_added: 2004-05-01 01:29:13 last_modified: NULL categories_status: 1
categories_id: 58 categories_image: categories/subcategory.gif parent_id: 54 sort_order: 110 date_added: 2004-05-02 12:35:02 last_modified: 2004-05-18 10:46:13 categories_status: 1
categories_id: 60 categories_image: categories/subcategory.gif parent_id: 54 sort_order: 0 date_added: 2004-05-02 23:45:21 last_modified: NULL categories_status: 1
categories_id: 61 categories_image: categories/subcategory.gif parent_id: 54 sort_order: 100 date_added: 2004-05-18 10:13:46 last_modified: 2004-05-18 10:46:02 categories_status: 1
categories_id: 62 categories_image: sample_image.gif parent_id: 0 sort_order: 1520 date_added: 2003-12-23 03:18:19 last_modified: 2004-05-22 21:14:57 categories_status: 1
categories_id: 63 categories_image: categories/subcategory.gif parent_id: 0 sort_order: 1530 date_added: 2003-12-23 03:18:19 last_modified: 2004-07-12 17:45:24 categories_status: 1
categories_id: 64 categories_image: categories/subcategory.gif parent_id: 0 sort_order: 1550 date_added: 2004-07-12 15:22:27 last_modified: NULL categories_status: 1
