Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `categorydisplayconfig` (
- `categoryid` int(11) NOT NULL,
- `countryid` int(11) NOT NULL,
- `cityid` int(11) NOT NULL,
- `order` int(11) NOT NULL,
- `active` tinyint(1) NOT NULL DEFAULT '1',
- `numads` int(11) NOT NULL DEFAULT '0',
- KEY `categoryid` (`categoryid`,`cityid`),
- KEY `cityid` (`cityid`),
- KEY `countryid` (`countryid`),
- KEY `categoryid_countryid` (`categoryid`,`countryid`),
- KEY `numads` (`numads`),
- KEY `categoryid_countryid_cityid` (`categoryid`,`countryid`,`cityid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement