YovoAds

Это старая версия документа!

---

CREATE TABLE `queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accid` int(11) NOT NULL,
  `adtypeid` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `rules` varchar(255) NOT NULL,
  `targetingcountry` varchar(1024) NOT NULL,
  `targetingbundle` varchar(8196) NOT NULL,
  `cycle` int(1) NOT NULL,
  `isactive` int(1) NOT NULL,
  `dt_changed` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `isdefault` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• `adtypeid`
• `number`
• `rules`
• `targetingcountry`
• `targetingbundle`
• `cycle`
• `isactive`
• `isdefault`