YovoAds

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

---

CREATE TABLE `adblocks` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `AccID` int(11) unsigned NOT NULL,
  `AppID` int(6) NOT NULL,
  `PackageName` varchar(50) DEFAULT '',
  `Title` varchar(45) NOT NULL DEFAULT '',
  `Description` varchar(100) DEFAULT '',
  `TextColor` varchar(10) DEFAULT '#000000',
  `AdType` int(11) NOT NULL DEFAULT '0',
  `Icon` varchar(255) DEFAULT '',
  `Image` varchar(255) DEFAULT '',
  `ImageH` int(11) NOT NULL DEFAULT '0',
  `ImageW` varchar(45) NOT NULL DEFAULT '0',
  `Rating` tinyint(4) DEFAULT '0',
  `Utm_content` varchar(50) DEFAULT '',
  `Tracking` varchar(50) NOT NULL DEFAULT '',
  `State` enum('NotConfirmed','Confirmed','Blocked') NOT NULL DEFAULT 'NotConfirmed',
  `ImageOrientation` enum('Landscape','Portrait','Any') NOT NULL DEFAULT 'Any',
  `ImageRatio` float NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`),
  KEY `Account` (`AccID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;