Need to setup the code for this query

[ericgtr]

I have figured out how to add a new field but don't know how to write this up as a query for my instructions. This is being added to the attachmentviews table.

Field: timestamp
Type: DATE
Length/Values: (blank)
Attributes: (blank)
Null: not null
Default: 0000-00-00
Extra: (blank)

[ericgtr]

FYI..
I think this works, at least it did when I tested it.

ALTER TABLE attachmentviews ADD (
timestamp DATE NOT NULL DEFAULT '0000-00-00'
)