Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +------------+
- | version() |
- +------------+
- | 5.6.51-log |
- +------------+
- +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Table | Create Table |
- +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | ppl | CREATE TABLE `ppl` (
- `PPLKEY` int(11) NOT NULL AUTO_INCREMENT,
- `PPLFID` varchar(3) COLLATE latin1_general_cs NOT NULL,
- `PPLBCD` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `PPLCPO` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `PPLSTS` varchar(4) COLLATE latin1_general_cs NOT NULL,
- `PPLTYP` varchar(4) COLLATE latin1_general_cs NOT NULL,
- `PPLSKU` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `PPLSHA` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLDOC` varchar(10) COLLATE latin1_general_cs NOT NULL,
- `PPLBIN` varchar(10) COLLATE latin1_general_cs NOT NULL,
- `PPLCRDR` datetime NOT NULL,
- `PPLCSTM` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `pplcuid` varchar(50) COLLATE latin1_general_cs NOT NULL,
- `PPLLUDR` datetime NOT NULL,
- `PPLLSTM` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `pplluid` varchar(50) COLLATE latin1_general_cs NOT NULL,
- `PPLFILD` varchar(3) COLLATE latin1_general_cs NOT NULL,
- `PPLITY` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLVEN` varchar(10) COLLATE latin1_general_cs NOT NULL,
- `PPLCST` decimal(13,4) NOT NULL,
- `PPLIVC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLPTYP` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLSPQ` int(11) NOT NULL,
- `PPLMIOQ` int(11) NOT NULL,
- `PPLSERC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLRAI` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `pplpuid` varchar(50) COLLATE latin1_general_cs NOT NULL,
- `PPLPCGN` varchar(80) COLLATE latin1_general_cs NOT NULL,
- `PPLPONO` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `PPLLTIM` int(11) NOT NULL,
- `PPLLTUM` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLOLTM` int(11) NOT NULL,
- `PPLOLTU` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLCOC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLQSTS` varchar(4) COLLATE latin1_general_cs NOT NULL,
- `PPLIGE` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLNBDY` int(11) NOT NULL,
- `PPLDDMD` decimal(13,4) NOT NULL,
- `PPLINVB` decimal(13,4) NOT NULL,
- `PPLIBUM` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLSIB` decimal(13,4) NOT NULL,
- `PPLSBUM` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLTTRN` decimal(13,4) NOT NULL,
- `PPLNOB` int(11) NOT NULL,
- `PPLBQTY` int(11) NOT NULL,
- `PPLCSRC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLCINV` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLMACQ` decimal(13,4) NOT NULL,
- `PPLMNOC` int(11) NOT NULL,
- `PPLLCKS` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLLTTC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLSUGB` decimal(13,4) NOT NULL,
- `PPLMINB` decimal(13,4) NOT NULL,
- `PPLMAXB` decimal(13,4) NOT NULL,
- `PPLNOAC` int(11) NOT NULL,
- `PPLCNOC` int(11) NOT NULL,
- `PPLNNOC` int(11) NOT NULL,
- `PPLNUPB` int(11) NOT NULL,
- `pplnrbq` decimal(13,4) NOT NULL,
- `PPLNPPB` int(11) NOT NULL,
- `PPLTPT` int(11) NOT NULL,
- `PPLROPQ` int(11) NOT NULL,
- `PPLSFLG` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLMLTH` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLCPRF` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLDPLS` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA0` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA1` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA2` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA3` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA4` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA5` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA6` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA7` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA8` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCA9` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB0` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB1` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB2` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB3` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB4` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB5` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB6` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB7` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB8` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSCB9` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `PPLSQA0` int(11) NOT NULL,
- `pplsqa1` decimal(13,4) NOT NULL,
- `pplsqa2` decimal(13,4) NOT NULL,
- `pplsqa3` decimal(13,4) NOT NULL,
- `pplsqa4` decimal(13,4) NOT NULL,
- `PPLSQA5` int(11) NOT NULL,
- `PPLSQA6` int(11) NOT NULL,
- `PPLSQA7` int(11) NOT NULL,
- `PPLSQA8` int(11) NOT NULL,
- `pplsqa9` decimal(13,4) NOT NULL,
- `PPLSDA0` decimal(13,4) NOT NULL,
- `PPLSDA1` decimal(13,4) NOT NULL,
- `PPLSDA2` decimal(13,4) NOT NULL,
- `PPLSDA3` decimal(13,4) NOT NULL,
- `PPLSDA4` decimal(13,4) NOT NULL,
- `PPLSDA5` decimal(13,4) NOT NULL,
- `PPLSDA6` decimal(13,4) NOT NULL,
- `PPLSDA7` decimal(13,4) NOT NULL,
- `PPLSDA8` decimal(13,4) NOT NULL,
- `PPLSDA9` decimal(13,4) NOT NULL,
- `PPLSDT0` datetime NOT NULL,
- `PPLSTM0` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT1` datetime NOT NULL,
- `PPLSTM1` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT2` datetime NOT NULL,
- `PPLSTM2` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT3` datetime NOT NULL,
- `PPLSTM3` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT4` datetime NOT NULL,
- `PPLSTM4` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT5` datetime NOT NULL,
- `PPLSTM5` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT6` datetime NOT NULL,
- `PPLSTM6` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT7` datetime NOT NULL,
- `PPLSTM7` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT8` datetime NOT NULL,
- `PPLSTM8` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLSDT9` datetime NOT NULL,
- `PPLSTM9` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG0` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG1` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG2` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG3` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG4` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG5` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG6` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG7` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG8` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `PPLFLG9` varchar(1) COLLATE latin1_general_cs NOT NULL,
- UNIQUE KEY `PPLKEY` (`PPLKEY`),
- UNIQUE KEY `PPL_PPLBCDC` (`PPLBCD`,`PPLFID`),
- KEY `PPL_PPLDOCK` (`PPLDOC`,`PPLFID`,`PPLKEY`),
- KEY `PPL_PPLVENC` (`PPLVEN`,`PPLFID`,`PPLSKU`,`PPLDOC`,`PPLKEY`),
- KEY `PPL_PPLPONOC` (`PPLPONO`,`PPLFID`,`PPLSKU`,`PPLKEY`),
- KEY `PPL_PPLSKUC` (`PPLSKU`,`PPLFID`,`PPLVEN`,`PPLKEY`),
- KEY `PPL_PPLFID` (`PPLFID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=112935 DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs |
- +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Table | Create Table |
- +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | ror | CREATE TABLE `ror` (
- `RORKEY` int(11) NOT NULL AUTO_INCREMENT,
- `RORFID` varchar(3) COLLATE latin1_general_cs NOT NULL,
- `RORBCD` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `RORCPO` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `RORSTS` varchar(4) COLLATE latin1_general_cs NOT NULL,
- `RORTYP` varchar(4) COLLATE latin1_general_cs NOT NULL,
- `RORSKU` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `RORSHA` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORDOC` varchar(10) COLLATE latin1_general_cs NOT NULL,
- `RORBIN` varchar(10) COLLATE latin1_general_cs NOT NULL,
- `RORCRDR` datetime NOT NULL,
- `RORCSTM` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `rorcuid` varchar(50) COLLATE latin1_general_cs NOT NULL,
- `RORLUDR` datetime NOT NULL,
- `RORLSTM` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `rorluid` varchar(50) COLLATE latin1_general_cs NOT NULL,
- `RORFILD` varchar(3) COLLATE latin1_general_cs NOT NULL,
- `RORITY` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORVEN` varchar(10) COLLATE latin1_general_cs NOT NULL,
- `RORCST` decimal(13,4) NOT NULL,
- `RORIVC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORPTYP` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSPQ` int(11) NOT NULL,
- `RORMIOQ` int(11) NOT NULL,
- `RORSERC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORRAI` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `rorpuid` varchar(50) COLLATE latin1_general_cs NOT NULL,
- `RORPCGN` varchar(80) COLLATE latin1_general_cs NOT NULL,
- `RORPONO` varchar(22) COLLATE latin1_general_cs NOT NULL,
- `RORLTIM` int(11) NOT NULL,
- `RORLTUM` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `ROROLTM` int(11) NOT NULL,
- `ROROLTU` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORCOC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORQSTS` varchar(4) COLLATE latin1_general_cs NOT NULL,
- `RORIGE` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORNBDY` int(11) NOT NULL,
- `RORDDMD` decimal(13,4) NOT NULL,
- `RORINVB` decimal(13,4) NOT NULL,
- `RORIBUM` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSIB` decimal(13,4) NOT NULL,
- `RORSBUM` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORTTRN` decimal(13,4) NOT NULL,
- `RORNOB` int(11) NOT NULL,
- `RORBQTY` int(11) NOT NULL,
- `RORCSRC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORCINV` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORMACQ` decimal(13,4) NOT NULL,
- `RORMNOC` int(11) NOT NULL,
- `RORLCKS` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORLTTC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSUGB` decimal(13,4) NOT NULL,
- `RORMINB` decimal(13,4) NOT NULL,
- `RORMAXB` decimal(13,4) NOT NULL,
- `RORNOAC` int(11) NOT NULL,
- `RORCNOC` int(11) NOT NULL,
- `RORNNOC` int(11) NOT NULL,
- `RORNUPB` int(11) NOT NULL,
- `rornrbq` decimal(13,4) NOT NULL,
- `RORNPPB` int(11) NOT NULL,
- `RORTPT` int(11) NOT NULL,
- `RORROPQ` int(11) NOT NULL,
- `RORSFLG` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORMLTH` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORCPRF` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORDPLS` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSCA0` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA1` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA2` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA3` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA4` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA5` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA6` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA7` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA8` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCA9` varchar(30) COLLATE latin1_general_cs NOT NULL,
- `RORSCB0` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB1` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB2` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB3` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB4` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB5` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB6` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB7` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB8` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSCB9` varchar(60) COLLATE latin1_general_cs NOT NULL,
- `RORSQA0` int(11) NOT NULL,
- `rorsqa1` decimal(13,4) NOT NULL,
- `rorsqa2` decimal(13,4) NOT NULL,
- `rorsqa3` decimal(13,4) NOT NULL,
- `rorsqa4` decimal(13,4) NOT NULL,
- `RORSQA5` int(11) NOT NULL,
- `RORSQA6` int(11) NOT NULL,
- `RORSQA7` int(11) NOT NULL,
- `RORSQA8` int(11) NOT NULL,
- `rorsqa9` decimal(13,4) NOT NULL,
- `RORSDA0` decimal(13,4) NOT NULL,
- `RORSDA1` decimal(13,4) NOT NULL,
- `RORSDA2` decimal(13,4) NOT NULL,
- `RORSDA3` decimal(13,4) NOT NULL,
- `RORSDA4` decimal(13,4) NOT NULL,
- `RORSDA5` decimal(13,4) NOT NULL,
- `RORSDA6` decimal(13,4) NOT NULL,
- `RORSDA7` decimal(13,4) NOT NULL,
- `RORSDA8` decimal(13,4) NOT NULL,
- `RORSDA9` decimal(13,4) NOT NULL,
- `RORSDT0` datetime NOT NULL,
- `RORSTM0` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT1` datetime NOT NULL,
- `RORSTM1` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT2` datetime NOT NULL,
- `RORSTM2` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT3` datetime NOT NULL,
- `RORSTM3` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT4` datetime NOT NULL,
- `RORSTM4` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT5` datetime NOT NULL,
- `RORSTM5` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT6` datetime NOT NULL,
- `RORSTM6` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT7` datetime NOT NULL,
- `RORSTM7` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT8` datetime NOT NULL,
- `RORSTM8` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDT9` datetime NOT NULL,
- `RORSTM9` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSFG0` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG1` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG2` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG3` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG4` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG5` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG6` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG7` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG8` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSFG9` varchar(1) COLLATE latin1_general_cs NOT NULL,
- `RORSDTA` datetime NOT NULL,
- `RORSTMA` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDTB` datetime NOT NULL,
- `RORSTMB` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORSDTC` datetime NOT NULL,
- `RORSTMC` varchar(6) COLLATE latin1_general_cs NOT NULL,
- `RORFREC` varchar(1) COLLATE latin1_general_cs NOT NULL,
- UNIQUE KEY `RORKEY` (`RORKEY`),
- UNIQUE KEY `ROR_RORRORK` (`RORSCA0`,`RORFID`),
- UNIQUE KEY `ROR_RORPONOK` (`RORPONO`,`RORFID`,`RORSKU`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- UNIQUE KEY `ROR_RORVENK` (`RORVEN`,`RORFID`,`RORSKU`,`RORDOC`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- KEY `ROR_RORDOCK` (`RORDOC`,`RORFID`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- KEY `ROR_RORSKUK` (`RORSKU`,`RORFID`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- KEY `ROR_RORBCDK` (`RORBCD`,`RORFID`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- KEY `ROR_RORSTSK` (`RORSTS`,`RORFID`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- KEY `ROR_RORCRDTK` (`RORCRDR`,`RORCSTM`,`RORFID`,`RORKEY`),
- KEY `ROR_RORCNSK` (`RORSCA1`,`RORFID`,`RORKEY`),
- KEY `ROR_RORCUIDK` (`rorcuid`,`RORFID`,`RORCRDR`,`RORCSTM`,`RORKEY`),
- KEY `ROR_RORVSTSK` (`RORVEN`,`RORFID`,`RORSTS`,`RORKEY`),
- KEY `ROR_RORUSTSK` (`rorpuid`,`RORFID`,`RORSTS`,`RORKEY`),
- KEY `ROR_RORBSTSK` (`RORBCD`,`RORFID`,`RORSTS`,`RORKEY`),
- KEY `ROR_RORSDT3K` (`RORBCD`,`RORFID`,`RORSDT3`,`RORKEY`),
- KEY `ROR_RORGMOQK` (`RORFID`,`RORSQA8`,`RORSKU`,`RORKEY`)
- ) ENGINE=InnoDB AUTO_INCREMENT=412163 DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs |
- +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Add Comment
Please, Sign In to add comment