· 8 years ago · Apr 08, 2018, 02:08 AM
1CREATE TABLE IF NOT EXISTS `stores` (
2 `store` text,
3 `address1` text,
4 `address2` text,
5 `city` text,
6 `state` text,
7 `zip` text,
8 `phone` text,
9 `fax` text,
10 `drive_through` text,
11 `latitude` float DEFAULT NULL,
12 `longitude` float DEFAULT NULL,
13 `version_created` int(11) NOT NULL DEFAULT '1',
14 `version_modified` int(11) NOT NULL DEFAULT '1',
15 `delete_flag` int(11) NOT NULL DEFAULT '0'
16) ENGINE=MyISAM DEFAULT CHARSET=latin1;
17
18INSERT INTO `stores` (`store`, `address1`, `address2`, `city`, `state`, `zip`, `phone`, `fax`, `drive_through`, `latitude`, `longitude`, `version_created`, `version_modified`, `delete_flag`) VALUES
19('72', '1926 28th Ave. South', NULL, 'Birmingham', 'AL', '35209', '205-870-9771', '205-870-8566', NULL, 33.4812, -86.7883, 0, 0, 0),
20
21
22CREATE TABLE `Stores` (
23 `StoreID` varchar(36) NOT NULL,
24 `PartnerID` varchar(36) DEFAULT NULL,
25 `StoreType` int(11) DEFAULT NULL,
26 `ExStoreID` text,
27 `StoreLocationDetails` varchar(255) DEFAULT NULL,
28 `ParentStoreID` text COMMENT ' ',
29 `StoreStatus` int(11) DEFAULT NULL,
30 PRIMARY KEY (`StoreID`),
31 KEY `PartnerID` (`PartnerID`),
32 CONSTRAINT `PartnerID` FOREIGN KEY (`PartnerID`) REFERENCES `Partners` (`PartnerID`) ON DELETE NO ACTION ON UPDATE NO ACTION
33) ENGINE=InnoDB DEFAULT CHARSET=utf8