ช่วยด้วยคับ!! Import Sql ลง localhost(Appserv) ช้ามากๆคับ

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- โฮสต์: localhost
-- เวลาในการสร้าง: 
-- รุ่นของเซิร์ฟเวอร์: 5.0.51
-- รุ่นของ PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- ฐานข้อมูล: `storeengineering`
-- 
CREATE DATABASE `storeengineering` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `storeengineering`;

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

-- 
-- โครงสร้างตาราง `tb_admin`
-- 

CREATE TABLE `tb_admin` (
  `id_admin` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL,
  `password` varchar(32) NOT NULL,
  `name` varchar(80) NOT NULL,
  `class` int(11) NOT NULL,
  PRIMARY KEY  (`id_admin`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- dump ตาราง `tb_admin`
-- 

INSERT INTO `tb_admin` VALUES (1, 'admin', '1234', 'jarrukorn pensalaphan', 1);
INSERT INTO `tb_admin` VALUES (2, 'admin2', '1234', 'pae', 2);

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

-- 
-- โครงสร้างตาราง `tb_inven`
-- 

CREATE TABLE `tb_inven` (
  `id_inven` int(11) NOT NULL auto_increment,
  `code` varchar(50) NOT NULL,
  `description` varchar(200) NOT NULL,
  `location` varchar(50) NOT NULL,
  `main_location` int(11) NOT NULL,
  `unit` int(11) NOT NULL,
  `non` varchar(20) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `note` varchar(200) NOT NULL,
  PRIMARY KEY  (`id_inven`),
  KEY `location` (`location`),
  KEY `main_location` (`main_location`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2534 ;

-- 
-- dump ตาราง `tb_inven`
-- 

INSERT INTO `tb_inven` VALUES (1, 'PK105802', 'SUS SPRING GUIDE ROD, SIZE 1/4"Dx16CM(L), (DANCING ROLLER/ FW-7)', 'C2-S1', 0, 0, '', 'PK105802.jpg', '');
INSERT INTO `tb_inven` VALUES (2, 'PK105800', 'SPRING, COMPRESSION, J97 NO.6 (FW7)', 'C2-S1', 0, 0, '', 'PK105800.jpg', '');
INSERT INTO `tb_inven` VALUES (3, 'PK105608', 'BLADE, LOCK, J85 NO.12 (FW7)', 'R01-2-2', 0, 0, '', 'PK105608.JPG', '');
INSERT INTO `tb_inven` VALUES (4, 'PK105607', 'VARIABLE RESISTER NO15 FOR FW7', 'C2-S1', 0, 0, '', 'PK105607.JPG', '');
INSERT INTO `tb_inven` VALUES (5, 'PK105000', 'LIMIT SWITCH, OMRON,LS-Z-15GW25-B,FOR FILM SENSOR KAWA 623', 'C1-S4', 0, 0, 'non', 'non.jpg', '');



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

-- 
-- โครงสร้างตาราง `tb_inven_action`
-- 

CREATE TABLE `tb_inven_action` (
  `action_no` int(11) NOT NULL auto_increment,
  `id_inven_action` int(11) NOT NULL,
  `action_date` date NOT NULL,
  `action_time` time NOT NULL,
  `action_income` int(11) NOT NULL,
  `action_use` int(11) NOT NULL,
  `action_total` int(11) NOT NULL,
  PRIMARY KEY  (`action_no`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

-- 
-- dump ตาราง `tb_inven_action`
-- 

INSERT INTO `tb_inven_action` VALUES (1, 6, '2011-05-02', '15:29:46', 10, 0, 10);
INSERT INTO `tb_inven_action` VALUES (2, 6, '2011-05-02', '15:29:52', 0, -10, 0);
INSERT INTO `tb_inven_action` VALUES (3, 6, '2011-05-02', '15:35:53', 10, 0, 10);
INSERT INTO `tb_inven_action` VALUES (4, 6, '2011-05-02', '15:35:58', 0, -10, 0);
INSERT INTO `tb_inven_action` VALUES (5, 6, '2011-05-03', '21:12:51', 10, 0, 10);
INSERT INTO `tb_inven_action` VALUES (6, 6, '2011-05-03', '21:13:04', 0, -10, 0);
INSERT INTO `tb_inven_action` VALUES (7, 2, '2011-05-08', '20:22:37', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (8, 2, '2011-05-08', '20:29:24', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (9, 2, '2011-05-08', '20:29:32', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (10, 2, '2011-05-08', '20:30:28', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (11, 2, '2011-05-08', '20:30:38', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (12, 2, '2011-05-08', '20:31:27', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (13, 2, '2011-05-08', '20:31:35', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (14, 2, '2011-05-08', '20:31:45', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (15, 2, '2011-05-08', '20:31:52', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (16, 2, '2011-05-08', '20:37:02', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (17, 2, '2011-05-08', '20:37:27', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (18, 2, '2011-05-08', '20:38:08', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (19, 2, '2011-05-08', '20:38:16', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (20, 2, '2011-05-08', '20:40:34', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (21, 2, '2011-05-08', '20:40:42', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (22, 2, '2011-05-08', '20:43:19', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (23, 2, '2011-05-08', '20:43:26', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (24, 2, '2011-05-08', '20:43:49', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (25, 2, '2011-05-08', '20:43:57', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (26, 2, '2011-05-11', '22:52:42', 4, 0, 4);
INSERT INTO `tb_inven_action` VALUES (27, 2, '2011-05-11', '22:52:49', 0, -4, 0);
INSERT INTO `tb_inven_action` VALUES (28, 6, '2011-11-21', '10:03:50', 10, 0, 10);

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

-- 
-- โครงสร้างตาราง `tb_inven_control`
-- 

CREATE TABLE `tb_inven_control` (
  `id_inven_control` int(11) NOT NULL auto_increment,
  `type` varchar(5) NOT NULL,
  `max` varchar(255) NOT NULL,
  `rop` varchar(255) NOT NULL,
  `min` varchar(255) NOT NULL,
  PRIMARY KEY  (`id_inven_control`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2534 ;

-- 
-- dump ตาราง `tb_inven_control`
-- 

INSERT INTO `tb_inven_control` VALUES (1, 'C', '-', '-', '-');
INSERT INTO `tb_inven_control` VALUES (2, 'C', '4', '2', '1');
INSERT INTO `tb_inven_control` VALUES (3, 'C', '-', '-', '-');
INSERT INTO `tb_inven_control` VALUES (4, 'C', '1', '0', '0');


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

-- 
-- โครงสร้างตาราง `tb_inven_income`
-- 

CREATE TABLE `tb_inven_income` (
  `id_inven_income` int(255) NOT NULL,
  `income_no` varchar(255) NOT NULL,
  `action_date` date NOT NULL,
  `action_time` time NOT NULL,
  `income_amount` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- dump ตาราง `tb_inven_income`
-- 

INSERT INTO `tb_inven_income` VALUES (6, '1', '2011-05-02', '15:29:46', 10);
INSERT INTO `tb_inven_income` VALUES (6, '3', '2011-05-02', '15:35:53', 10);
INSERT INTO `tb_inven_income` VALUES (6, '5', '2011-05-03', '21:12:51', 10);
INSERT INTO `tb_inven_income` VALUES (2, '8', '2011-05-08', '20:29:24', 4);
INSERT INTO `tb_inven_income` VALUES (2, '10', '2011-05-08', '20:30:28', 4);
INSERT INTO `tb_inven_income` VALUES (2, '12', '2011-05-08', '20:31:27', 4);
INSERT INTO `tb_inven_income` VALUES (2, '14', '2011-05-08', '20:31:45', 4);
INSERT INTO `tb_inven_income` VALUES (2, '16', '2011-05-08', '20:37:02', 4);
INSERT INTO `tb_inven_income` VALUES (2, '18', '2011-05-08', '20:38:08', 4);
INSERT INTO `tb_inven_income` VALUES (2, '20', '2011-05-08', '20:40:34', 4);
INSERT INTO `tb_inven_income` VALUES (2, '22', '2011-05-08', '20:43:19', 4);
INSERT INTO `tb_inven_income` VALUES (2, '24', '2011-05-08', '20:43:49', 4);
INSERT INTO `tb_inven_income` VALUES (2, '26', '2011-05-11', '22:52:42', 4);
INSERT INTO `tb_inven_income` VALUES (6, '28', '2011-11-21', '10:03:50', 10);

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

-- 
-- โครงสร้างตาราง `tb_inven_net`
-- 

CREATE TABLE `tb_inven_net` (
  `id_inven_net` int(11) NOT NULL auto_increment,
  `net_date` date NOT NULL,
  `net_time` time NOT NULL,
  `net_amount` int(255) NOT NULL,
  PRIMARY KEY  (`id_inven_net`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2534 ;

-- 
-- dump ตาราง `tb_inven_net`
-- 

INSERT INTO `tb_inven_net` VALUES (1, '0000-00-00', '00:00:00', 3);
INSERT INTO `tb_inven_net` VALUES (2, '2011-05-11', '22:52:49', 0);
INSERT INTO `tb_inven_net` VALUES (3, '2011-04-20', '11:17:27', 0);
INSERT INTO `tb_inven_net` VALUES (4, '2011-04-18', '15:41:38', 0);
INSERT INTO `tb_inven_net` VALUES (5, '0000-00-00', '00:00:00', 0);
INSERT INTO `tb_inven_net` VALUES (6, '2011-11-21', '10:03:50', 10);
INSERT INTO `tb_inven_net` VALUES (7, '0000-00-00', '00:00:00', 0);


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

-- 
-- โครงสร้างตาราง `tb_location`
-- 

CREATE TABLE `tb_location` (
  `id_loca` int(11) NOT NULL auto_increment,
  `id_loca_no` int(11) NOT NULL,
  `name_loca` varchar(255) NOT NULL,
  `id_main_loca_in_loca` int(11) NOT NULL,
  PRIMARY KEY  (`id_loca`),
  KEY `id_main_loca_in_loca` (`id_main_loca_in_loca`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- dump ตาราง `tb_location`
-- 

INSERT INTO `tb_location` VALUES (4, 1, 'R01-1-1', 6);
INSERT INTO `tb_location` VALUES (8, 2, 'R01-1-2', 6);
INSERT INTO `tb_location` VALUES (9, 3, 'C1', 11);
INSERT INTO `tb_location` VALUES (10, 10, 'R01-1-3', 12);

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

-- 
-- โครงสร้างตาราง `tb_main_location`
-- 

CREATE TABLE `tb_main_location` (
  `id_main_loca` int(11) NOT NULL auto_increment,
  `id_main_loca_no` int(11) NOT NULL,
  `name_main_loca` varchar(255) NOT NULL,
  PRIMARY KEY  (`id_main_loca`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- 
-- dump ตาราง `tb_main_location`
-- 

INSERT INTO `tb_main_location` VALUES (6, 1, 'SP1');
INSERT INTO `tb_main_location` VALUES (11, 2, 'SP2');
INSERT INTO `tb_main_location` VALUES (12, 12, 'SP3');

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

-- 
-- โครงสร้างตาราง `tb_now`
-- 

CREATE TABLE `tb_now` (
  `id_now` int(11) NOT NULL auto_increment,
  `now_date` date NOT NULL,
  PRIMARY KEY  (`id_now`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- dump ตาราง `tb_now`
-- 

INSERT INTO `tb_now` VALUES (1, '2011-12-12');

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

-- 
-- โครงสร้างตาราง `tb_spr`
-- 

CREATE TABLE `tb_spr` (
  `spr_no` int(11) NOT NULL,
  `spr_no_date` date NOT NULL,
  `spr_no_time` time NOT NULL,
  `spr_id_inven` int(11) NOT NULL,
  `spr_max` int(11) NOT NULL,
  `spr_rop` int(11) NOT NULL,
  `spr_onhand` int(11) NOT NULL,
  `spr_amount` int(11) NOT NULL,
  `spr_date` date NOT NULL,
  `spr_time` time NOT NULL,
  `spr_admin` varchar(255) NOT NULL,
  `spr_note` varchar(255) NOT NULL,
  `spr_note2` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- dump ตาราง `tb_spr`
-- 

INSERT INTO `tb_spr` VALUES (1, '2011-05-03', '20:21:31', 6, 10, 0, 0, 10, '2011-05-02', '15:35:58', 'admin', 'end', 'part');
INSERT INTO `tb_spr` VALUES (1, '2011-05-03', '20:21:31', 11, 4, 2, 0, 4, '2011-05-02', '15:16:19', 'admin', 'end', '');
INSERT INTO `tb_spr` VALUES (1, '2011-05-03', '20:21:31', 25, 4, 0, 0, 4, '0000-00-00', '00:00:00', 'admin', 'end', '');
INSERT INTO `tb_spr` VALUES (2, '2011-05-03', '21:04:44', 28, 1, 0, 0, 1, '0000-00-00', '00:00:00', 'admin', 'end', '');
INSERT INTO `tb_spr` VALUES (3, '2011-05-03', '21:39:46', 6, 10, 0, 0, 10, '2011-05-03', '21:13:04', 'admin', 'end', 'part');

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

-- 
-- โครงสร้างตาราง `tb_unit`
-- 

CREATE TABLE `tb_unit` (
  `id_unit` int(11) NOT NULL auto_increment,
  `name_unit` varchar(255) NOT NULL,
  PRIMARY KEY  (`id_unit`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- dump ตาราง `tb_unit`
-- 

INSERT INTO `tb_unit` VALUES (1, 'pcs');
INSERT INTO `tb_unit` VALUES (4, 'set');

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

-- 
-- โครงสร้างตาราง `tb_year`
-- 

CREATE TABLE `tb_year` (
  `id_year` int(11) NOT NULL auto_increment,
  `year` date NOT NULL,
  PRIMARY KEY  (`id_year`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- dump ตาราง `tb_year`
-- 

INSERT INTO `tb_year` VALUES (1, '2011-04-04');

-- 
-- Constraints for dumped tables
-- 

-- 
-- Constraints for table `tb_inven_control`
-- 
ALTER TABLE `tb_inven_control`
  ADD CONSTRAINT `tb_inven_control_ibfk_1` FOREIGN KEY (`id_inven_control`) REFERENCES `tb_inven` (`id_inven`) ON DELETE CASCADE;

-- 
-- Constraints for table `tb_inven_net`
-- 
ALTER TABLE `tb_inven_net`
  ADD CONSTRAINT `tb_inven_net_ibfk_1` FOREIGN KEY (`id_inven_net`) REFERENCES `tb_inven` (`id_inven`) ON DELETE CASCADE;

-- 
-- Constraints for table `tb_location`
-- 
ALTER TABLE `tb_location`
  ADD CONSTRAINT `tb_location_ibfk_1` FOREIGN KEY (`id_main_loca_in_loca`) REFERENCES `tb_main_location` (`id_main_loca`);