创建数据库:db_webavtc
创建数据表:avcategory(素材类别)
id int primary key,
pid int ,
cname varchar(255),
cmemo varchar(1000)
CREATE TABLE `avcategory` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`pid` INT(11) NOT NULL,
`cname` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`cmemo` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
创建数据表:avtemplate(转码模板)
Id int primary key auto_increment,
tcTemplateId varchar(64),
tcTemplateName varchar(64),