Table categories description

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 reasonably be translated into multiple languages. Each language for a given category will have it's own record in this table.


Non-language specific data about each category is found in the categories table.


Table Details

Primary Keys

categories_id
language_id

Indexed Fields

categories_name


Columns

categories_id Primary Key Foreign Key

Links the record to the corresponding data in the categories table. Foreign key to categories.categories_id.
Type: int(11)
Null: No
Default: 0


language_id Primary Key Foreign Key

Links the record to the corresponding data in the languages table. Foreign key to languages.languages_id.
Type: int(11)
Null: No
Default: 1


categories_name Index

The language-specific name of the category.
Type: varchar(32)
Null: No
Default:


categories_description

The language-specific description of the category.
Type: text
Null: No
Default:


Default Entries (assuming demo data installed)

categories_id: 1
language_id: 1
caegories_name: Hardware
categories_description: We offer a variety of Hardware from printers to graphics cards and mice to keyboards.


categories_id: 2
language_id: 1
caegories_name: Software
categories_description: Select from an exciting list of software titles. <br /><br />Not seeing a title that you are looking for?


categories_id: 3
language_id: 1
caegories_name: DVD Movies
categories_description: We offer a variety of DVD movies enjoyable for the whole family.<br /><br />Please browse the various categories to find your favorite movie today!


categories_id: 4
language_id: 1
caegories_name: Graphics Cards
categories_description:


categories_id: 5
language_id: 1
caegories_name: Printers
categories_description:


categories_id: 6
language_id: 1
caegories_name: Monitors
categories_description:


categories_id: 7
language_id: 1
caegories_name: Speakers
categories_description:


categories_id: 8
language_id: 1
caegories_name: Keyboards
categories_description:


categories_id: 9
language_id: 1
caegories_name: Mice
categories_description: Pick the right mouse for your individual computer needs!<br /><br />Contact Us if you are looking for a particular mouse that we do not currently have in stock.


categories_id: 10
language_id: 1
caegories_name: Action
categories_description: <p>Get into the action with our Action collection of DVD movies!<br /><br />Don't miss the excitement and order your's today!<br /><br /></p>


categories_id: 11
language_id: 1
caegories_name: Science Fiction
categories_description:


categories_id: 12
language_id: 1
caegories_name: Comedy
categories_description:


categories_id: 13
language_id: 1
caegories_name: Cartoons
categories_description: Something you can enjoy with children of all ages!


categories_id: 14
language_id: 1
caegories_name: Thriller
categories_description:


categories_id: 15
language_id: 1
caegories_name: Drama
categories_description:


categories_id: 16
language_id: 1
caegories_name: Memory
categories_description:


categories_id: 17
language_id: 1
caegories_name: CDROM Drives
categories_description:


categories_id: 18
language_id: 1
caegories_name: Simulation
categories_description:


categories_id: 19
language_id: 1
caegories_name: Action
categories_description:


categories_id: 20
language_id: 1
caegories_name: Strategy
categories_description:


categories_id: 60
language_id: 1
caegories_name: Downloads
categories_description:


categories_id: 58
language_id: 1
caegories_name: Real Sale
categories_description:


categories_id: 21
language_id: 1
caegories_name: Gift Certificates
categories_description: Send a Gift Certificate today!<br /><br />Gift Certificates are good for anything in the store.


categories_id: 57
language_id: 1
caegories_name: Text Pricing
categories_description:


categories_id: 56
language_id: 1
caegories_name: Attributes
categories_description:


categories_id: 22
language_id: 1
caegories_name: Big Linked
categories_description: All of these products are "Linked Products".<br /><br />This means that they appear in more than one Category.<br /><br />However, you only have to maintain the product in one place.<br /><br />The Master Product is used for pricing purposes.


categories_id: 55
language_id: 1
caegories_name: Discount Qty
categories_description: <p>Discount Quantities can be set for Products or on the individual attributes.<br /><br />Discounts on the Product do NOT reflect on the attributes price.<br /><br />Only discounts based on Special and Sale Prices are applied to attribute prices.</p>


categories_id: 23
language_id: 1
caegories_name: Test Examples
categories_description:


categories_id: 24
language_id: 1
caegories_name: Free Call Stuff
categories_description:


categories_id: 25
language_id: 1
caegories_name: Test 10% by Attrib
categories_description:


categories_id: 27
language_id: 1
caegories_name: $5.00 off
categories_description:


categories_id: 28
language_id: 1
caegories_name: Test 10%
categories_description:


categories_id: 31
language_id: 1
caegories_name: 10% off Skip
categories_description:


categories_id: 32
language_id: 1
caegories_name: 10% off Price
categories_description:


categories_id: 47
language_id: 1
caegories_name: 10% off Attrib
categories_description:


categories_id: 33
language_id: 1
caegories_name: A Top Level Cat
categories_description: <p>This is a top level catagories description.</p>


categories_id: 34
language_id: 1
caegories_name: SubLevel 2 A
categories_description: This is a sublevel categories description.


categories_id: 35
language_id: 1
caegories_name: SubLevel 2 B
categories_description:


categories_id: 36
language_id: 1
caegories_name: SubLevel 2 C
categories_description:


categories_id: 37
language_id: 1
caegories_name: Sub Sub Cat 2B1
categories_description:


categories_id: 38
language_id: 1
caegories_name: Sub Sub Cat 2B2
categories_description:


categories_id: 39
language_id: 1
caegories_name: Sub Sub Cat 2B3
categories_description:


categories_id: 40
language_id: 1
caegories_name: Sub Sub Cat 2A1
categories_description: This is a sub-sub level categories description.


categories_id: 41
language_id: 1
caegories_name: Sub Sub Cat 2C1
categories_description:


categories_id: 42
language_id: 1
caegories_name: Sub Sub Cat 2C3
categories_description:


categories_id: 43
language_id: 1
caegories_name: Sub Sub Cat 2A2
categories_description:


categories_id: 44
language_id: 1
caegories_name: Sub Sub Cat 2C2
categories_description:


categories_id: 45
language_id: 1
caegories_name: 10% off
categories_description:


categories_id: 46
language_id: 1
caegories_name: Set $100
categories_description:


categories_id: 48
language_id: 1
caegories_name: Sale Percentage
categories_description:


categories_id: 49
language_id: 1
caegories_name: Sale Deduction
categories_description:


categories_id: 50
language_id: 1
caegories_name: Sale New Price
categories_description:


categories_id: 51
language_id: 1
caegories_name: Set $100 Skip
categories_description:


categories_id: 52
language_id: 1
caegories_name: $5.00 off Skip
categories_description:


categories_id: 53
language_id: 1
caegories_name: Big Unlinked
categories_description:


categories_id: 54
language_id: 1
caegories_name: New v1.2
categories_description: <p>The New Products show many of the newest features that have been added to Zen Cart.<br /><br />Take the time to review these and the other Demo Products to better understand all the options and features that Zen Cart has to offer.</p>


categories_id: 61
language_id: 1
caegories_name: Real
categories_description:


categories_id: 62
language_id: 1
caegories_name: Music
categories_description:


categories_id: 63
language_id: 1
caegories_name: Documents
categories_description: Documents can now be added to the category tree. For example you may want to add servicing/Technical documents. Or use Documents as an integrated FAQ system on your site. The implemetation here is fairly spartan, but could be expanded to offer PDF downloads, links to purchaseable download files. The possibilities are endless and left to your imagination.


categories_id: 64
language_id: 1
caegories_name: Mixed Product Types
categories_description: This is a category with mixed product types.

This includes both products and documents. There are two types of documents - Documents that are for reading and Documents that are for reading and purchasing.