-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: 2024-08-02 02:50:34
-- 服务器版本： 5.7.26
-- PHP Version: 5.4.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `b_ocqx1amg20240521`
--

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

--
-- 表的结构 `as_finance`
--

CREATE TABLE IF NOT EXISTS `as_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_find_defects`
--

CREATE TABLE IF NOT EXISTS `as_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(50) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_instructs`
--

CREATE TABLE IF NOT EXISTS `as_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(200) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_pics`
--

CREATE TABLE IF NOT EXISTS `as_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_projects`
--

CREATE TABLE IF NOT EXISTS `as_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_reports`
--

CREATE TABLE IF NOT EXISTS `as_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(255) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(150) NOT NULL DEFAULT '',
  `tbShortQty` varchar(150) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_serial1`
--

CREATE TABLE IF NOT EXISTS `as_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_serial2`
--

CREATE TABLE IF NOT EXISTS `as_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `as_tested`
--

CREATE TABLE IF NOT EXISTS `as_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_finance`
--

CREATE TABLE IF NOT EXISTS `ft_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_find_defects`
--

CREATE TABLE IF NOT EXISTS `ft_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(50) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_instructs`
--

CREATE TABLE IF NOT EXISTS `ft_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(200) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_pics`
--

CREATE TABLE IF NOT EXISTS `ft_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_projects`
--

CREATE TABLE IF NOT EXISTS `ft_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_reports`
--

CREATE TABLE IF NOT EXISTS `ft_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(255) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(150) NOT NULL DEFAULT '',
  `tbShortQty` varchar(150) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_serial1`
--

CREATE TABLE IF NOT EXISTS `ft_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_serial2`
--

CREATE TABLE IF NOT EXISTS `ft_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `ft_tested`
--

CREATE TABLE IF NOT EXISTS `ft_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_finance`
--

CREATE TABLE IF NOT EXISTS `pu_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_find_defects`
--

CREATE TABLE IF NOT EXISTS `pu_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(4) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_find_defects_1`
--

CREATE TABLE IF NOT EXISTS `pu_find_defects_1` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(4) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_instructs`
--

CREATE TABLE IF NOT EXISTS `pu_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(50) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_pics`
--

CREATE TABLE IF NOT EXISTS `pu_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_pics_1`
--

CREATE TABLE IF NOT EXISTS `pu_pics_1` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_projects`
--

CREATE TABLE IF NOT EXISTS `pu_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_reports`
--

CREATE TABLE IF NOT EXISTS `pu_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(255) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(100) NOT NULL DEFAULT '',
  `tbShortQty` varchar(100) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_serial1`
--

CREATE TABLE IF NOT EXISTS `pu_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL DEFAULT '',
  `tbSerialNumber` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_serial2`
--

CREATE TABLE IF NOT EXISTS `pu_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pu_tested`
--

CREATE TABLE IF NOT EXISTS `pu_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `si_companys`
--

CREATE TABLE IF NOT EXISTS `si_companys` (
  `tbCompanyID` int(11) NOT NULL,
  `tbType` char(1) NOT NULL DEFAULT '',
  `tbCompanyName` varchar(100) NOT NULL DEFAULT '',
  `tbShortName` varchar(5) NOT NULL DEFAULT '',
  `tbPrefix` varchar(4) NOT NULL,
  `tbNickName` varchar(50) NOT NULL DEFAULT '',
  `tbCountry` varchar(50) NOT NULL DEFAULT '',
  `tbAddress` varchar(255) NOT NULL DEFAULT '',
  `tbTel` varchar(20) NOT NULL DEFAULT '',
  `tbFax` varchar(20) NOT NULL DEFAULT '',
  `tbContactPerson` varchar(50) NOT NULL DEFAULT '',
  `tbCooperation` char(20) NOT NULL DEFAULT '',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(4) NOT NULL DEFAULT '0',
  `tbHourCharge` int(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `si_defects`
--

CREATE TABLE IF NOT EXISTS `si_defects` (
  `tbSN` int(11) NOT NULL,
  `tbCategory` varchar(50) NOT NULL DEFAULT '',
  `tbTopical` varchar(250) NOT NULL DEFAULT '',
  `tbDescript` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `si_items`
--

CREATE TABLE IF NOT EXISTS `si_items` (
  `tbSN` int(11) NOT NULL,
  `tbCheckPoint` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `si_test_items`
--

CREATE TABLE IF NOT EXISTS `si_test_items` (
  `tbSN` int(11) NOT NULL,
  `tbCheckPoint` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `si_users`
--

CREATE TABLE IF NOT EXISTS `si_users` (
  `tbID` int(11) NOT NULL,
  `tbCompanyID` varchar(4) NOT NULL DEFAULT '',
  `tbUserName` varchar(16) NOT NULL DEFAULT '',
  `tbPassword` varchar(16) NOT NULL DEFAULT '',
  `tbOpen` char(1) NOT NULL DEFAULT '',
  `tbName` varchar(50) NOT NULL DEFAULT '',
  `tbCnName` varchar(50) NOT NULL,
  `tbMail` varchar(50) NOT NULL DEFAULT '',
  `tbRank` char(2) NOT NULL DEFAULT '',
  `tbTitle` varchar(50) NOT NULL,
  `tbDepartment` varchar(40) NOT NULL DEFAULT '',
  `tbPhoneNumber` varchar(20) NOT NULL DEFAULT '',
  `tbCellNumber` varchar(20) NOT NULL DEFAULT '',
  `tbVisitCount` int(11) NOT NULL DEFAULT '0',
  `tbLastTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tbSentMail` char(1) NOT NULL DEFAULT '',
  `tbCnSent` char(1) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_finance`
--

CREATE TABLE IF NOT EXISTS `tt_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_find_defects`
--

CREATE TABLE IF NOT EXISTS `tt_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(50) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_instructs`
--

CREATE TABLE IF NOT EXISTS `tt_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(50) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_pics`
--

CREATE TABLE IF NOT EXISTS `tt_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_projects`
--

CREATE TABLE IF NOT EXISTS `tt_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_reports`
--

CREATE TABLE IF NOT EXISTS `tt_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(255) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(100) NOT NULL DEFAULT '',
  `tbShortQty` varchar(100) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_serial1`
--

CREATE TABLE IF NOT EXISTS `tt_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_serial2`
--

CREATE TABLE IF NOT EXISTS `tt_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `tt_tested`
--

CREATE TABLE IF NOT EXISTS `tt_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_finance`
--

CREATE TABLE IF NOT EXISTS `vc_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_find_defects`
--

CREATE TABLE IF NOT EXISTS `vc_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(50) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_instructs`
--

CREATE TABLE IF NOT EXISTS `vc_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(200) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_pics`
--

CREATE TABLE IF NOT EXISTS `vc_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_projects`
--

CREATE TABLE IF NOT EXISTS `vc_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_reports`
--

CREATE TABLE IF NOT EXISTS `vc_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(255) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(150) NOT NULL DEFAULT '',
  `tbShortQty` varchar(150) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_serial1`
--

CREATE TABLE IF NOT EXISTS `vc_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_serial2`
--

CREATE TABLE IF NOT EXISTS `vc_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `vc_tested`
--

CREATE TABLE IF NOT EXISTS `vc_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_finance`
--

CREATE TABLE IF NOT EXISTS `xy_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_find_defects`
--

CREATE TABLE IF NOT EXISTS `xy_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(50) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_instructs`
--

CREATE TABLE IF NOT EXISTS `xy_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(200) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_pics`
--

CREATE TABLE IF NOT EXISTS `xy_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_projects`
--

CREATE TABLE IF NOT EXISTS `xy_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_reports`
--

CREATE TABLE IF NOT EXISTS `xy_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(300) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(150) NOT NULL DEFAULT '',
  `tbShortQty` varchar(150) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_serial1`
--

CREATE TABLE IF NOT EXISTS `xy_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_serial2`
--

CREATE TABLE IF NOT EXISTS `xy_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `xy_tested`
--

CREATE TABLE IF NOT EXISTS `xy_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_finance`
--

CREATE TABLE IF NOT EXISTS `yo_finance` (
  `tbSN` int(11) NOT NULL,
  `tbInOut` char(1) NOT NULL DEFAULT '',
  `tbDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCategory` varchar(100) NOT NULL DEFAULT '',
  `tbItem` varchar(200) NOT NULL DEFAULT '',
  `tbSum` double NOT NULL DEFAULT '0',
  `tbRemark` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_find_defects`
--

CREATE TABLE IF NOT EXISTS `yo_find_defects` (
  `tbFN` bigint(20) NOT NULL,
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbPic` varchar(50) NOT NULL,
  `tbDefection` varchar(300) NOT NULL DEFAULT '',
  `tbSerial_NO` varchar(150) NOT NULL DEFAULT '',
  `tbCritical` varchar(8) NOT NULL DEFAULT '',
  `tbMajor` varchar(8) NOT NULL DEFAULT '',
  `tbMinor` varchar(8) NOT NULL DEFAULT '',
  `tbCategory` varchar(20) NOT NULL DEFAULT '',
  `tbTopical` varchar(200) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_instructs`
--

CREATE TABLE IF NOT EXISTS `yo_instructs` (
  `tbWN` int(11) NOT NULL,
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbProductName` varchar(100) NOT NULL DEFAULT '',
  `tbDescript` varchar(200) NOT NULL DEFAULT '',
  `tbVersion` char(3) NOT NULL DEFAULT '',
  `tbIssueDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModel` text NOT NULL,
  `tbEffect` date NOT NULL DEFAULT '0000-00-00',
  `tbWI` varchar(4) NOT NULL DEFAULT '',
  `tbWPM` varchar(50) NOT NULL DEFAULT '',
  `tbPlan` varchar(50) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(10) NOT NULL DEFAULT '',
  `tbCritical` varchar(30) NOT NULL DEFAULT '',
  `tbMajor` varchar(30) NOT NULL DEFAULT '',
  `tbMinor` varchar(30) NOT NULL DEFAULT '',
  `tbCriteria` varchar(200) NOT NULL DEFAULT '',
  `tbTestPlan` varchar(200) NOT NULL DEFAULT '',
  `tbKitBom` varchar(200) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbTest` varchar(300) NOT NULL,
  `tbMeasure` varchar(300) NOT NULL,
  `tbFactoryID` char(3) NOT NULL,
  `tbProvide` char(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_pics`
--

CREATE TABLE IF NOT EXISTS `yo_pics` (
  `tbPN` int(11) NOT NULL,
  `tbReportNumber` text NOT NULL,
  `tbPackimg` text NOT NULL,
  `tbStyleimg` text NOT NULL,
  `tbAppearanceimg` text NOT NULL,
  `tbTestimg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_projects`
--

CREATE TABLE IF NOT EXISTS `yo_projects` (
  `tbSN` int(11) NOT NULL,
  `tbBookingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbCheckone` varchar(30) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFinishDate` date NOT NULL DEFAULT '0000-00-00',
  `tbShippingDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbInspectionTime` time NOT NULL DEFAULT '00:00:00',
  `tbFactoryBookNO` varchar(60) NOT NULL DEFAULT '',
  `tbPM` varchar(50) NOT NULL DEFAULT '',
  `tbStatus` varchar(30) NOT NULL DEFAULT '',
  `tbTeam` varchar(100) NOT NULL DEFAULT '',
  `tbFrom` varchar(50) NOT NULL DEFAULT '',
  `tbLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbDayCount` float NOT NULL DEFAULT '0',
  `tbCurrent` char(3) NOT NULL DEFAULT '',
  `tbDayCharge` int(11) NOT NULL DEFAULT '0',
  `tbHourCharge` int(11) NOT NULL DEFAULT '0',
  `tbTotalPrice` float NOT NULL DEFAULT '0',
  `tbOverTimeLabor` tinyint(2) NOT NULL DEFAULT '0',
  `tbOverTime` float NOT NULL DEFAULT '0',
  `tbOverCurrent` char(3) NOT NULL DEFAULT '',
  `tbOverTimePrice` int(11) NOT NULL DEFAULT '0',
  `tbOverTotal` float NOT NULL DEFAULT '0',
  `tbOverFinanceFrom` varchar(50) NOT NULL DEFAULT '',
  `tbTotalFinance` varchar(50) NOT NULL DEFAULT '0',
  `tbFinaceReporter` varchar(50) NOT NULL DEFAULT '',
  `tbRevisedCount` int(11) NOT NULL DEFAULT '0',
  `tbATeam` varchar(100) NOT NULL DEFAULT '',
  `tbOverWork` varchar(200) NOT NULL DEFAULT '',
  `tbTaxi` varchar(200) NOT NULL DEFAULT '',
  `tbConcessCharge` varchar(100) NOT NULL DEFAULT '',
  `tbMemo` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_reports`
--

CREATE TABLE IF NOT EXISTS `yo_reports` (
  `tbPN` int(11) NOT NULL,
  `tbPONumber` varchar(12) NOT NULL DEFAULT '',
  `tbReportNumber` varchar(20) NOT NULL DEFAULT '',
  `tbProductName` varchar(60) NOT NULL DEFAULT '',
  `tbClientID` varchar(4) NOT NULL DEFAULT '',
  `tbInspectionDate` date NOT NULL DEFAULT '0000-00-00',
  `tbFactoryID` varchar(4) NOT NULL DEFAULT '',
  `tbFactoryBookNO` varchar(50) NOT NULL DEFAULT '',
  `tbLotQty` varchar(10) NOT NULL DEFAULT '',
  `tbWI` varchar(10) NOT NULL DEFAULT '',
  `tbModelNO` text NOT NULL,
  `tbClientPONo` varchar(300) NOT NULL DEFAULT '',
  `tbOriginalQuantity` varchar(255) NOT NULL DEFAULT '',
  `tbShippingQty` varchar(255) NOT NULL DEFAULT '',
  `tbCTNQty` varchar(150) NOT NULL DEFAULT '',
  `tbShortQty` varchar(150) NOT NULL DEFAULT '',
  `tbInspectLevel` varchar(20) NOT NULL DEFAULT '',
  `tbAQL` varchar(50) NOT NULL DEFAULT '',
  `tbSampleSize` varchar(10) NOT NULL DEFAULT '',
  `tbSerialNO` text NOT NULL,
  `tbUnit` varchar(10) NOT NULL DEFAULT '',
  `tbSpec` varchar(100) DEFAULT NULL,
  `tbPiece` varchar(30) NOT NULL DEFAULT '',
  `tbRemark` text NOT NULL,
  `tbTestPlan` varchar(180) NOT NULL DEFAULT '',
  `tbKitBom` varchar(50) NOT NULL DEFAULT '',
  `tbPacking` text NOT NULL,
  `tbStyle` text NOT NULL,
  `tbMeasure` text NOT NULL,
  `tbSupplement` text NOT NULL,
  `tbCheckQuantity` varchar(20) NOT NULL DEFAULT '',
  `tbCheckPacking` varchar(20) NOT NULL DEFAULT '',
  `tbCheckSMC` varchar(20) NOT NULL DEFAULT '',
  `tbCheckAppearance` varchar(20) NOT NULL DEFAULT '',
  `tbCheckMeasure` varchar(20) NOT NULL DEFAULT '',
  `tbResult` varchar(50) NOT NULL DEFAULT '',
  `tbMS` varchar(50) NOT NULL DEFAULT '',
  `tbJudge` varchar(50) NOT NULL DEFAULT '',
  `tbReport` char(1) NOT NULL DEFAULT '0',
  `tbReportDate` date NOT NULL DEFAULT '0000-00-00',
  `tbCR` varchar(4) NOT NULL DEFAULT '',
  `tbMA` varchar(4) NOT NULL DEFAULT '',
  `tbMI` varchar(4) NOT NULL DEFAULT '',
  `tbVerifier` varchar(50) NOT NULL DEFAULT '',
  `tbVerifyDate` date NOT NULL DEFAULT '0000-00-00',
  `tbApproval` varchar(50) NOT NULL DEFAULT '',
  `tbAppDate` date NOT NULL DEFAULT '0000-00-00',
  `tbModify` varchar(50) NOT NULL DEFAULT '',
  `tbIssue` text NOT NULL,
  `tbModifyReason` text NOT NULL,
  `tbReInspectionNo` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_serial1`
--

CREATE TABLE IF NOT EXISTS `yo_serial1` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_serial2`
--

CREATE TABLE IF NOT EXISTS `yo_serial2` (
  `tbSN` int(11) NOT NULL,
  `tbReportNumber` varchar(30) NOT NULL,
  `tbSerialNumber` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `yo_tested`
--

CREATE TABLE IF NOT EXISTS `yo_tested` (
  `tbTN` int(11) NOT NULL,
  `tbReportNo` varchar(30) NOT NULL,
  `tbTestedID` varchar(100) NOT NULL,
  `tbQty` int(10) NOT NULL,
  `tbResult` varchar(10) NOT NULL,
  `tbSpec` varchar(300) NOT NULL,
  `tbPosition` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `as_finance`
--
ALTER TABLE `as_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `as_find_defects`
--
ALTER TABLE `as_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `as_instructs`
--
ALTER TABLE `as_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `as_pics`
--
ALTER TABLE `as_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `as_projects`
--
ALTER TABLE `as_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `as_reports`
--
ALTER TABLE `as_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `as_serial1`
--
ALTER TABLE `as_serial1`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `as_serial2`
--
ALTER TABLE `as_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `as_tested`
--
ALTER TABLE `as_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- Indexes for table `ft_finance`
--
ALTER TABLE `ft_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `ft_find_defects`
--
ALTER TABLE `ft_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `ft_instructs`
--
ALTER TABLE `ft_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `ft_pics`
--
ALTER TABLE `ft_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `ft_projects`
--
ALTER TABLE `ft_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `ft_reports`
--
ALTER TABLE `ft_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `ft_serial1`
--
ALTER TABLE `ft_serial1`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `ft_serial2`
--
ALTER TABLE `ft_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `ft_tested`
--
ALTER TABLE `ft_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- Indexes for table `pu_finance`
--
ALTER TABLE `pu_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `pu_find_defects`
--
ALTER TABLE `pu_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `pu_find_defects_1`
--
ALTER TABLE `pu_find_defects_1`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `pu_instructs`
--
ALTER TABLE `pu_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `pu_pics`
--
ALTER TABLE `pu_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `pu_pics_1`
--
ALTER TABLE `pu_pics_1`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `pu_projects`
--
ALTER TABLE `pu_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `pu_reports`
--
ALTER TABLE `pu_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `pu_serial1`
--
ALTER TABLE `pu_serial1`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `pu_serial2`
--
ALTER TABLE `pu_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `pu_tested`
--
ALTER TABLE `pu_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- Indexes for table `si_companys`
--
ALTER TABLE `si_companys`
  ADD PRIMARY KEY (`tbCompanyID`);

--
-- Indexes for table `si_defects`
--
ALTER TABLE `si_defects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `si_items`
--
ALTER TABLE `si_items`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `si_test_items`
--
ALTER TABLE `si_test_items`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `si_users`
--
ALTER TABLE `si_users`
  ADD PRIMARY KEY (`tbID`);

--
-- Indexes for table `tt_finance`
--
ALTER TABLE `tt_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `tt_find_defects`
--
ALTER TABLE `tt_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `tt_instructs`
--
ALTER TABLE `tt_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `tt_pics`
--
ALTER TABLE `tt_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `tt_projects`
--
ALTER TABLE `tt_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `tt_reports`
--
ALTER TABLE `tt_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `tt_serial1`
--
ALTER TABLE `tt_serial1`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `tt_serial2`
--
ALTER TABLE `tt_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `tt_tested`
--
ALTER TABLE `tt_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- Indexes for table `vc_finance`
--
ALTER TABLE `vc_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `vc_find_defects`
--
ALTER TABLE `vc_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `vc_instructs`
--
ALTER TABLE `vc_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `vc_pics`
--
ALTER TABLE `vc_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `vc_projects`
--
ALTER TABLE `vc_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `vc_reports`
--
ALTER TABLE `vc_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `vc_serial1`
--
ALTER TABLE `vc_serial1`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `vc_serial2`
--
ALTER TABLE `vc_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `vc_tested`
--
ALTER TABLE `vc_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- Indexes for table `xy_finance`
--
ALTER TABLE `xy_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `xy_find_defects`
--
ALTER TABLE `xy_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `xy_instructs`
--
ALTER TABLE `xy_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `xy_pics`
--
ALTER TABLE `xy_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `xy_projects`
--
ALTER TABLE `xy_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `xy_reports`
--
ALTER TABLE `xy_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `xy_serial1`
--
ALTER TABLE `xy_serial1`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `xy_serial2`
--
ALTER TABLE `xy_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `xy_tested`
--
ALTER TABLE `xy_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- Indexes for table `yo_finance`
--
ALTER TABLE `yo_finance`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `yo_find_defects`
--
ALTER TABLE `yo_find_defects`
  ADD PRIMARY KEY (`tbFN`);

--
-- Indexes for table `yo_instructs`
--
ALTER TABLE `yo_instructs`
  ADD PRIMARY KEY (`tbWN`);

--
-- Indexes for table `yo_pics`
--
ALTER TABLE `yo_pics`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `yo_projects`
--
ALTER TABLE `yo_projects`
  ADD PRIMARY KEY (`tbSN`);

--
-- Indexes for table `yo_reports`
--
ALTER TABLE `yo_reports`
  ADD PRIMARY KEY (`tbPN`);

--
-- Indexes for table `yo_serial1`
--
ALTER TABLE `yo_serial1`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `yo_serial2`
--
ALTER TABLE `yo_serial2`
  ADD PRIMARY KEY (`tbSN`),
  ADD KEY `tbSN` (`tbSN`);

--
-- Indexes for table `yo_tested`
--
ALTER TABLE `yo_tested`
  ADD PRIMARY KEY (`tbTN`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `as_finance`
--
ALTER TABLE `as_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_find_defects`
--
ALTER TABLE `as_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_instructs`
--
ALTER TABLE `as_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_pics`
--
ALTER TABLE `as_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_projects`
--
ALTER TABLE `as_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_reports`
--
ALTER TABLE `as_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_serial1`
--
ALTER TABLE `as_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_serial2`
--
ALTER TABLE `as_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `as_tested`
--
ALTER TABLE `as_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_finance`
--
ALTER TABLE `ft_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_find_defects`
--
ALTER TABLE `ft_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_instructs`
--
ALTER TABLE `ft_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_pics`
--
ALTER TABLE `ft_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_projects`
--
ALTER TABLE `ft_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_reports`
--
ALTER TABLE `ft_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_serial1`
--
ALTER TABLE `ft_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_serial2`
--
ALTER TABLE `ft_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ft_tested`
--
ALTER TABLE `ft_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_finance`
--
ALTER TABLE `pu_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_find_defects`
--
ALTER TABLE `pu_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_find_defects_1`
--
ALTER TABLE `pu_find_defects_1`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_instructs`
--
ALTER TABLE `pu_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_pics`
--
ALTER TABLE `pu_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_pics_1`
--
ALTER TABLE `pu_pics_1`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_projects`
--
ALTER TABLE `pu_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_reports`
--
ALTER TABLE `pu_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_serial1`
--
ALTER TABLE `pu_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_serial2`
--
ALTER TABLE `pu_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pu_tested`
--
ALTER TABLE `pu_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `si_companys`
--
ALTER TABLE `si_companys`
  MODIFY `tbCompanyID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `si_defects`
--
ALTER TABLE `si_defects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `si_items`
--
ALTER TABLE `si_items`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `si_test_items`
--
ALTER TABLE `si_test_items`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `si_users`
--
ALTER TABLE `si_users`
  MODIFY `tbID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_finance`
--
ALTER TABLE `tt_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_find_defects`
--
ALTER TABLE `tt_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_instructs`
--
ALTER TABLE `tt_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_pics`
--
ALTER TABLE `tt_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_projects`
--
ALTER TABLE `tt_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_reports`
--
ALTER TABLE `tt_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_serial1`
--
ALTER TABLE `tt_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_serial2`
--
ALTER TABLE `tt_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tt_tested`
--
ALTER TABLE `tt_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_finance`
--
ALTER TABLE `vc_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_find_defects`
--
ALTER TABLE `vc_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_instructs`
--
ALTER TABLE `vc_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_pics`
--
ALTER TABLE `vc_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_projects`
--
ALTER TABLE `vc_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_reports`
--
ALTER TABLE `vc_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_serial1`
--
ALTER TABLE `vc_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_serial2`
--
ALTER TABLE `vc_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vc_tested`
--
ALTER TABLE `vc_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_finance`
--
ALTER TABLE `xy_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_find_defects`
--
ALTER TABLE `xy_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_instructs`
--
ALTER TABLE `xy_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_pics`
--
ALTER TABLE `xy_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_projects`
--
ALTER TABLE `xy_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_reports`
--
ALTER TABLE `xy_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_serial1`
--
ALTER TABLE `xy_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_serial2`
--
ALTER TABLE `xy_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `xy_tested`
--
ALTER TABLE `xy_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_finance`
--
ALTER TABLE `yo_finance`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_find_defects`
--
ALTER TABLE `yo_find_defects`
  MODIFY `tbFN` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_instructs`
--
ALTER TABLE `yo_instructs`
  MODIFY `tbWN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_pics`
--
ALTER TABLE `yo_pics`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_projects`
--
ALTER TABLE `yo_projects`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_reports`
--
ALTER TABLE `yo_reports`
  MODIFY `tbPN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_serial1`
--
ALTER TABLE `yo_serial1`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_serial2`
--
ALTER TABLE `yo_serial2`
  MODIFY `tbSN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yo_tested`
--
ALTER TABLE `yo_tested`
  MODIFY `tbTN` int(11) NOT NULL AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
