Table newsletters

From Zen Cart(tm) Wiki
Revision as of 13:11, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores newsletters and information about them.


Table Details

Primary Key

newsletters_id

Indexed Fields

None.


Columns

newsletters_id Primary Key

A unique, auto incremented value, to identify each newsletters record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


title

The title of the newsletter.
Type: varchar(255)
Null: No
Default:


content

The text-only content of the newsletter.
Type: text
Null: No
Default:


content_html

The HTML content of the newsletter.
Type: text
Null: No
Default:


module

The type of newsletter being sent. By default, valid options are newsletter and product_notification.
Type: varchar(255)
Null: No
Default:


date_added

The date and time the newsletter was added.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


date_sent

The date and time the newsletter was sent.
Type: datetime
Null: Yes
Default: NULL


status

Indicates whether this newsletter has been sent or not. 0 = not sent, 1 = sent.
Type: int(1)
Null: Yes
Default: NULL

locked

Is the newsletter locked or unlocked. Newsletter must be locked before being sent. Can be set to 0 (unlocked) or 1 (locked).
Type: int(1)
Null: Yes
Default: 0


Default Entries

None.