Advertisement
Guest User

categorydisplayconfig

a guest
Sep 18th, 2014
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. CREATE TABLE `categorydisplayconfig` (
  2. `categoryid` int(11) NOT NULL,
  3. `countryid` int(11) NOT NULL,
  4. `cityid` int(11) NOT NULL,
  5. `order` int(11) NOT NULL,
  6. `active` tinyint(1) NOT NULL DEFAULT '1',
  7. `numads` int(11) NOT NULL DEFAULT '0',
  8. KEY `categoryid` (`categoryid`,`cityid`),
  9. KEY `cityid` (`cityid`),
  10. KEY `countryid` (`countryid`),
  11. KEY `categoryid_countryid` (`categoryid`,`countryid`),
  12. KEY `numads` (`numads`),
  13. KEY `categoryid_countryid_cityid` (`categoryid`,`countryid`,`cityid`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement