| SQL command |
| show create table mike_au_meetings |
| SQL command to create table |
| mike_au_meetings |
CREATE TABLE `mike_au_meetings` (
`meeting_date_time` datetime NOT NULL,
`meeting_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_speakers` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_location_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_location_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_location_3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_location_4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_location_5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_sponser` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_sponser_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meeting_contact` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ip_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ip_address_on_update` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`date_created` datetime NOT NULL,
`date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`delete_flag` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
`cancel_flag` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cancel_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
|