5CCH6egD

1CREATE TABLE IF NOT EXISTS `auctionlocation` (
2  `al_Id` int(11) NOT NULL auto_increment,
3  `al_title` varchar(255) NOT NULL COMMENT 'title of auction event',
4  `al_address1` varchar(255) default NULL,
5  `al_address2` varchar(255) default NULL,
6  `al_city` varchar(255) default NULL,
7  `al_state` varchar(255) default NULL,
8  `al_zip` varchar(255) default NULL,
9  `al_marketingRemarks` text,
10  `al_internalNotes` text,
11  `al_datePromo` date default NULL,
12  `al_type` enum('REO','NewHome','LiveOnly') default NULL,
13  `al_openTime` time default NULL,
14  `al_phone` varchar(20) NOT NULL,
15  `al_email` varchar(50) NOT NULL,
16  `create_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
17  `al_primarylender` int(11) NOT NULL,
18  `inspectionInfo` text NOT NULL,
19  `openHouseInfo` text NOT NULL,
20  `emailAlias` varchar(100) NOT NULL,
21  `openHouseDate` varchar(200) NOT NULL,
22  `openHouseTime` varchar(200) NOT NULL,
23  `banner` varchar(200) NOT NULL,
24  `previewStart` timestamp NOT NULL default '0000-00-00 00:00:00',
25  `previewEnd` timestamp NOT NULL default '0000-00-00 00:00:00',
26  `bidStart` timestamp NOT NULL default '0000-00-00 00:00:00',
27  `bidEnd` timestamp NOT NULL default '0000-00-00 00:00:00',
28  `buyStart` timestamp NOT NULL default '0000-00-00 00:00:00',
29  `buyEnd` timestamp NOT NULL default '0000-00-00 00:00:00',
30  `mailtext` text NOT NULL COMMENT 'mail in deposit text',
31  `mailaddress` text NOT NULL COMMENT 'mail in deposit address',
32  `homeurl` varchar(255) NOT NULL,
33  `bidderno_range` varchar(10) NOT NULL,
34  `sequence` int(11) NOT NULL,
35  `long` varchar(10) NOT NULL,
36  `lat` varchar(10) NOT NULL,
37  `property_type` varchar(20) NOT NULL,
38  PRIMARY KEY  (`al_Id`)
39) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='auction physical location ' AUTO_INCREMENT=23 ;