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

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

-- 
-- ±íµĽṹ `ajx_log`
-- 

CREATE TABLE `ajx_log` (
  `Tmk` varchar(14) NOT NULL,
  `Ip` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- ±íµĽṹ `driver_psw`
-- 

CREATE TABLE `driver_psw` (
  `PswId` bigint(8) unsigned DEFAULT NULL,
  `OkFlag` varchar(2) NOT NULL DEFAULT '0',
  `BusId` varchar(10) NOT NULL,
  `Psw` varchar(15) NOT NULL,
  `UserId` varchar(8) NOT NULL,
  `PswTmk` varchar(14) NOT NULL,
  UNIQUE KEY `Psw` (`Psw`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- ±íµĽṹ `gps_log`
-- 

CREATE TABLE `gps_log` (
  `Tmk` varchar(19) DEFAULT NULL,
  `Lng` double(8,5) NOT NULL,
  `Lat` double(8,5) NOT NULL,
  `Hight` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- ±íµĽṹ `home_log`
-- 

CREATE TABLE `home_log` (
  `HId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Ip` varchar(15) NOT NULL,
  `Mac` varchar(17) NOT NULL,
  `Tmk` varchar(14) NOT NULL,
  `Browser` varchar(100) DEFAULT NULL,
  `Nwf` varchar(2) NOT NULL,
  `Opt` varchar(2) NOT NULL,
  `ActStatus` varchar(2) NOT NULL,
  PRIMARY KEY (`HId`)
) ENGINE=InnoDB AUTO_INCREMENT=1292 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1292 ;

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

-- 
-- ±íµĽṹ `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;

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

-- 
-- ±íµĽṹ `music_main`
-- 

CREATE TABLE `music_main` (
  `SrcId` varchar(8) NOT NULL,
  `SrcCat` varchar(2) NOT NULL,
  `MscListId` varchar(3) DEFAULT NULL,
  `MscSong` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MscAttr` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MscSinger` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MscList` varchar(200) NOT NULL,
  `MscRank` varchar(3) DEFAULT NULL,
  `SrcPath` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SrcFN` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- ±íµĽṹ `page_log`
-- 

CREATE TABLE `page_log` (
  `Ip` varchar(15) NOT NULL,
  `Page` varchar(10) NOT NULL,
  `Tmk` varchar(14) NOT NULL,
  `Browser` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- ±íµĽṹ `play_log`
-- 

CREATE TABLE `play_log` (
  `SrcId` varchar(30) DEFAULT NULL,
  `SrcCat` varchar(2) NOT NULL,
  `Ip` varchar(15) NOT NULL,
  `PlayTmk` varchar(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- ±íµĽṹ `usr_ad`
-- 

CREATE TABLE `usr_ad` (
  `AdListId` bigint(8) unsigned NOT NULL AUTO_INCREMENT,
  `UserId` varchar(8) NOT NULL,
  `Ip` varchar(15) NOT NULL,
  `MovId` varchar(10) NOT NULL,
  `MovSec` int(4) unsigned NOT NULL,
  `PlayFlag` varchar(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`AdListId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- ±íµĽṹ `usr_main`
-- 

CREATE TABLE `usr_main` (
  `UserId` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) DEFAULT '0',
  `Ip` varchar(15) NOT NULL,
  `Mac` varchar(17) NOT NULL,
  `Cell` varchar(20) NOT NULL,
  `ActTmk` varchar(14) DEFAULT NULL,
  `AgreeTmk` varchar(14) NOT NULL,
  `PayTmOut` varchar(14) NOT NULL,
  `ActStatus` int(3) DEFAULT '0',
  `Quota` bigint(15) unsigned DEFAULT '0',
  `WanOut` bigint(15) unsigned NOT NULL,
  `WanIn` bigint(15) unsigned NOT NULL,
  `LanIn` bigint(15) unsigned NOT NULL,
  PRIMARY KEY (`UserId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

-- 
-- ±íµĽṹ `usr_vip`
-- 

CREATE TABLE `usr_vip` (
  `UserId` varchar(10) NOT NULL,
  `ListId` varchar(6) NOT NULL,
  `Status` varchar(2) NOT NULL,
  `TbId` varchar(12) NOT NULL,
  `TbHint` varchar(10) NOT NULL,
  `SubmitTmk` varchar(14) NOT NULL,
  `PaidTmk` varchar(14) NOT NULL,
  `TimeOut` varchar(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
