avmediainfo

CREATE TABLE `avmediainfo` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`avmiGUID` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avmiOutDir` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avmiOutName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`tcTaskIdxGUID` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avMakeFullname` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avSrcName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avSrcTitle` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avAssetId` INT(11) NULL DEFAULT NULL,

`createTime` DATETIME NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE,

INDEX `idx_by_avmakefullname` (`avMakeFullname`) USING BTREE,

INDEX `idx_by_guid` (`avmiGUID`) USING BTREE

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

AUTO_INCREMENT=57

;

avassets

CREATE TABLE `avassets` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`requestId` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`isAutoTC` INT(11) NULL DEFAULT '1',

`isDeleted` INT(11) NULL DEFAULT '0',

`avSrcName` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avTitle` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avMakeFullName` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avType` INT(11) NULL DEFAULT NULL,

`avCategoryId` INT(11) NULL DEFAULT NULL,

`avCategoryName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`fileSize` INT(11) NULL DEFAULT NULL,

`fileMD5` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avFrom` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`uploadTime` DATETIME NULL DEFAULT NULL,

`userId` INT(11) NULL DEFAULT NULL,

`avState` INT(11) NULL DEFAULT NULL,

`avPercent` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avTag` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avMemo` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avPoster` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avThumbnail1` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avThumbnail2` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avThumbnail3` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avMediaInfo` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`theTaskID` INT(11) NULL DEFAULT NULL,

`strTaskIdxGUID` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strTaskOutDir` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strTaskOutName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`tcTemplateIdxName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

PRIMARY KEY (`id`) USING BTREE,

INDEX `idx_by_avSrcName` (`avSrcName`(255)) USING BTREE,

INDEX `idx_by_avTitle` (`avTitle`) USING BTREE,

INDEX `idx_by_avMakeFullName` (`avMakeFullName`(255)) USING BTREE

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

AUTO_INCREMENT=79

;

avsnapshot

CREATE TABLE `avsnapshot` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`avssGUID` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avssOutDir` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avssJsonCfg` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avssOutName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`tcTaskIdxGUID` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avMakeFullname` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avSrcName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avSrcTitle` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`avAssetId` INT(11) NULL DEFAULT NULL,

`createTime` DATETIME NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE,

INDEX `idx_by_avmakefullname` (`avMakeFullname`) USING BTREE

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

AUTO_INCREMENT=67

;

watermark

CREATE TABLE `watermark` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`xxtype` INT(11) NULL DEFAULT NULL,

`xxcontent` VARCHAR(1024) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`imgFullName` VARCHAR(512) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`imgWidth` INT(11) NULL DEFAULT NULL,

`imgHeight` INT(11) NULL DEFAULT NULL,

`fontName` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`fontSize` INT(11) NULL DEFAULT NULL,

`fontColor` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`fontAlpha` INT(255) NULL DEFAULT NULL,

`initPosition` INT(255) NULL DEFAULT NULL,

`moveDirection` INT(11) NULL DEFAULT NULL,

`moveSpeed` INT(11) NULL DEFAULT NULL,

`xxtop` INT(255) NULL DEFAULT NULL,

`xxleft` INT(255) NULL DEFAULT NULL,

`xxstartTime` INT(11) NULL DEFAULT NULL,

`xxduration` INT(255) NULL DEFAULT NULL,

`xxinterval` INT(255) NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

ROW_FORMAT=COMPACT

;

avtranscodetask

CREATE TABLE `avtranscodetask` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`requestId` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strTaskIdxGUID` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strTCType` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`theInAssetID` INT(11) NULL DEFAULT NULL,

`strInAVTitle` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strInAVType` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strInSrcName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`tcInputFileUrl` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`isMultiOutput` INT(11) NULL DEFAULT NULL,

`tcOutputFileCount` INT(11) NULL DEFAULT NULL,

`strTaskOutDir` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`strTaskOutName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`isDeleted` INT(11) NULL DEFAULT '0',

`xxstate` INT(11) NULL DEFAULT '0',

`xxpriority` INT(11) NULL DEFAULT '0',

`xxcode` INT(11) NULL DEFAULT NULL,

`xxmessage` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`xxpercent` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`xxpercentold` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`xxpercentsametimes` INT(11) NULL DEFAULT '0',

`createTime` DATETIME NULL DEFAULT NULL,

`taskConsumeTime` INT(11) NULL DEFAULT NULL,

`taskStartTime` INT(11) NULL DEFAULT NULL,

`taskEndTime` INT(11) NULL DEFAULT NULL,

`threadsNum` INT(11) NULL DEFAULT NULL,

`tcStopFlag` INT(11) NULL DEFAULT '0',

`sockTCID` INT(11) NULL DEFAULT NULL,

`sockTCIP` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`sockTCMac` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

`sockTCPort` INT(11) NULL DEFAULT NULL,

`tcTemplateIdxName` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',

PRIMARY KEY (`id`) USING BTREE,

INDEX `idx_by_taskidxguid` (`strTaskIdxGUID`) USING BTREE,

INDEX `idx_by_xxstate` (`xxstate`) USING BTREE,

INDEX `idx_by_avsrcname` (`strInSrcName`) USING BTREE

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

ROW_FORMAT=COMPACT

AUTO_INCREMENT=57

;