-- http://www.phpmyadmin.net
-- 
-- Ö÷»ú: localhost
-- Éú³ÉÈÕÆÚ: 2014 Äê 12 ÔÂ 09 ÈÕ 06:06
-- ·þÎñÆ÷°æ±¾: 5.5.31
-- PHP °æ±¾: 5.5.0
-- 
-- Êý¾Ý¿â: `da8w-work`
-- 

-- --------------------------------------------------------

-- 
-- ±íµÄ½á¹¹ `mov_main`
-- 

CREATE TABLE `mov_main` (
  `SrcId` varchar(8) NOT NULL,
  `OkFlag` varchar(2) NOT NULL DEFAULT '0',
  `SrcCat` varchar(2) NOT NULL,
  `MovRes` varchar(2) NOT NULL DEFAULT '0',
  `MovTitle` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MovAttr` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MovRole` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MovDir` varchar(50) NOT NULL,
  `MovArea` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MovYear` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MovDesc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `EpsCnt` int(5) DEFAULT '1',
  `RankFlag` varchar(2) NOT NULL DEFAULT '0',
  `TxtCnt` int(5) NOT NULL,
  `JpgCnt` int(5) NOT NULL,
  `Mp4Cnt` int(5) NOT NULL,
  `FlvCnt` int(5) NOT NULL,
  `ElsCnt` int(5) NOT NULL,
  `SrcPath` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`SrcId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
