All pastes #492881 Raw Edit

Max wsy

public text v1 · immutable

·published 2007-05-17 14:04 UTC

CREATE TABLE `tmpnegreport` (
  `id_tmp` int(20) NOT NULL auto_increment,
  `manufCateg` char(3) collate latin1_general_ci NOT NULL,
  `mnf_name` varchar(50) collate latin1_general_ci NOT NULL,
  `OfficeName` varchar(50) collate latin1_general_ci NOT NULL,
  `negStartDate` datetime NOT NULL,
  `difStartDate` int(10) NOT NULL,
  `maximo00` datetime NOT NULL,
  `difStatusDate` int(10) NOT NULL,
  `LANOTAMAXIMA` text collate latin1_general_ci NOT NULL,
  `ngtStatus` char(3) collate latin1_general_ci NOT NULL,
  `ngtBuyer` varchar(50) collate latin1_general_ci NOT NULL,
  `ngtCode` int(20) NOT NULL,
  `procurCode` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id_tmp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;