-- MySQL dump 10.11
--
-- Host: localhost    Database: lonestar
-- ------------------------------------------------------
-- Server version	5.0.70-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `lonestar_cattle`
--

DROP TABLE IF EXISTS `lonestar_cattle`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_cattle` (
  `kill_date` date default NULL,
  `worksheet` varchar(10) default NULL,
  `usda_lot` varchar(10) default NULL,
  `owner` varchar(50) default NULL,
  `state` varchar(2) default NULL,
  `lot_number` varchar(8) default NULL,
  `cwt` decimal(4,3) default NULL,
  `holstein` varchar(1) default NULL,
  `regrade` varchar(2) default NULL,
  `hot_wt` int(4) default NULL,
  `class_code` int(1) default NULL,
  `classification` int(1) default NULL,
  `reported` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_imps`
--

DROP TABLE IF EXISTS `lonestar_imps`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_imps` (
  `code` int(3) NOT NULL default '0',
  `description` varchar(50) default NULL,
  `imps_code` varchar(5) default NULL,
  `class` int(1) NOT NULL default '0',
  `classification` int(1) NOT NULL default '0',
  `trim` int(1) NOT NULL default '0',
  `weight` int(1) NOT NULL default '0',
  `refrigeration` enum('1','2','3') NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_ls126`
--

DROP TABLE IF EXISTS `lonestar_ls126`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_ls126` (
  `po_num` varchar(8) NOT NULL default '',
  `reporting_date` date NOT NULL default '0000-00-00',
  `time` enum('0','1','2') NOT NULL default '1',
  `purchase_type` int(1) NOT NULL default '0',
  `refrigeration` int(1) NOT NULL default '0',
  `imps` int(3) NOT NULL default '0',
  `tot_weight` int(6) NOT NULL default '0',
  `cwt` decimal(5,4) default NULL,
  `user` varchar(15) default NULL,
  PRIMARY KEY  (`po_num`,`imps`),
  KEY `reporting_date` (`reporting_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_ls126_xwalk`
--

DROP TABLE IF EXISTS `lonestar_ls126_xwalk`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_ls126_xwalk` (
  `id` int(4) NOT NULL,
  `description` varchar(50) NOT NULL,
  `value` int(2) NOT NULL,
  `value_description` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_ls131`
--

DROP TABLE IF EXISTS `lonestar_ls131`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_ls131` (
  `reporting_date` date NOT NULL default '0000-00-00',
  `i10` decimal(4,3) default NULL,
  `i11` decimal(4,3) default NULL,
  `i12` decimal(4,3) default NULL,
  `i13` decimal(4,3) default NULL,
  `i14` decimal(4,3) default NULL,
  `i15` decimal(4,3) default NULL,
  `i16` decimal(4,3) default NULL,
  `i17` decimal(4,3) default NULL,
  `i18` decimal(4,3) default NULL,
  `i19` decimal(4,3) default NULL,
  `i20` decimal(4,3) default NULL,
  `i21` decimal(4,3) default NULL,
  `i22` decimal(4,3) default NULL,
  `i23` decimal(4,3) default NULL,
  `i24` decimal(4,3) default NULL,
  `reported` date default NULL,
  PRIMARY KEY  (`reporting_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_process`
--

DROP TABLE IF EXISTS `lonestar_process`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_process` (
  `process_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`process_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_states`
--

DROP TABLE IF EXISTS `lonestar_states`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_states` (
  `state_id` int(2) NOT NULL auto_increment,
  `state_abbreviation` char(2) default NULL,
  `state_name` varchar(30) default NULL,
  PRIMARY KEY  (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `lonestar_users`
--

DROP TABLE IF EXISTS `lonestar_users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `lonestar_users` (
  `user_id` int(2) NOT NULL auto_increment,
  `user_name` varchar(7) NOT NULL default '',
  `user_group` varchar(7) default NULL,
  `user_passwd` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  KEY `user_name` (`user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-04-14 16:34:58
