Table categories

From Zen Cart(tm) Wiki
Jump to: navigation, search

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

categories_id

Indexed Fields

parent_id
categories_id
categories_status
sort_order


Columns

categories_id Primary Key Index

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 Foreign Key Index

Links the record to a parent category. Recursive foreign key to categories_id.
Type: int(11)
Null: No
Default: 0
Info.png What it Means!
A value of 0 means that this is a top-level category.


sort_order Index

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 Index

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