1. Is this table set up correctly

CREATE TABLE IF NOT EXISTS `Calendar` (
`ID_Column` int(11) NOT NULL auto_increment,
`Title_Column` text,
`Start_Column` datetime default NULL,
`stop_Column` datetime default NULL,
`Type_Column` int(2) default NULL,
`Description_Column` text,
`Link_Column` text,
`own_id` int(8) default NULL,
`rentor_name` text,
`rental_month` text,
`rental_year` text,
`rental_deposit` decimal(6,2) default NULL,
`rental_amount` decimal(6,2) default NULL,
PRIMARY KEY (`ID_Column`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Event Calendar Ajax Table' AUTO_INCREMENT=2 ;


2. In the DMX Template

how can I change the style of the Year that shows - too fuzzy looking

3. How do Dates need to be entered

Can they just be entered as Dates as I don't need times
Can I use the DMZ Calendar to enter the min the form if so in what format

4. Is a time required ?

In the Start & Stop dates

5. Event Type needs to be an integer correct


6. Do the Title & Description Fields need to have value ?

7. What id the link field use for ?

Note: I would suggest you include a sample sql file in future releases

Know it's a lot of questions so thank you in advance for answering them

Hello,

1. Yes, this table seems correct. HOwever it is more important how you populate it.

2. What exactly you want to change?

3.1. If you enter dates as only date portion the MySQL will add 00 : 00 : 00 for the time portion.
3.2. Please clarify:

Quote

Can I use the DMZ Calendar to enter the min the form if so in what format

4. Time is required since dates are calculated as milliseconds.

5. It can be VARCHAR as well but INT is not a problem.

6. Do you refer to an default value?

7. Please, clarify your question.

NOTE: In user interface you can CREATE new table in you database.

Regards,