-- phpMyAdmin SQL Dump -- version 2.11.9.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 28, 2008 at 07:46 AM -- Server version: 4.1.22 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 */; -- -- Database: `dreemeho_wcpdb` -- -- -------------------------------------------------------- -- -- Table structure for table `wcp_brand_mast` -- CREATE TABLE IF NOT EXISTS `wcp_brand_mast` ( `slno` int(11) NOT NULL auto_increment, `brand_name` varchar(255) NOT NULL default '', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `wcp_brand_mast` -- -- -------------------------------------------------------- -- -- Table structure for table `wcp_cat_mast` -- CREATE TABLE IF NOT EXISTS `wcp_cat_mast` ( `slno` int(11) NOT NULL auto_increment, `cat_name` varchar(255) NOT NULL default '', `brand_name` varchar(255) NOT NULL default '', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ; -- -- Dumping data for table `wcp_cat_mast` -- INSERT INTO `wcp_cat_mast` (`slno`, `cat_name`, `brand_name`) VALUES (6, '4CG05', '4CG05'), (7, '4N302', '4N302'), (8, '4N301', '4N301'), (9, '4N303', '4N303'), (10, '4CH01', '4CH01'), (11, '4C101', '4C101'), (12, '4C102', '4C102'), (13, '4C104', '4C104'), (14, '4C108', '4C108'), (15, '4C113', '4C113'), (16, '4C114', '4C114'), (17, '4C110', '4C110'), (18, '4C111', '4C111'), (19, '4C107', '4C107'), (20, '4C209', '4C209'), (21, '4C103', '4C103'), (22, '4C115', '4C115'), (23, '4N305', '4N305'), (24, '4K706', '4K706'), (25, '43208', '43208'), (26, '43209', '43209'), (27, '48103', '48103'), (28, '48AA4', '48AA4'), (29, '48A02', '48A02'), (30, '48112', '48112'), (31, '48109', '48109'), (32, '48108', '48108'), (33, '48110', '48110'), (34, '48101', '48101'), (35, '47101', '47101'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_favs` -- CREATE TABLE IF NOT EXISTS `wcp_favs` ( `id` int(11) NOT NULL auto_increment, `name` varchar(200) NOT NULL default '', `catid` int(11) NOT NULL default '0', `itemid` int(11) NOT NULL default '0', `userid` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `wcp_favs` -- INSERT INTO `wcp_favs` (`id`, `name`, `catid`, `itemid`, `userid`) VALUES (1, 't1', 0, 0, 'test'), (2, 'x', 8, 16, 'test'), (3, 'XX', 8, 0, 'test'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_fav_categories` -- CREATE TABLE IF NOT EXISTS `wcp_fav_categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(200) NOT NULL default '', `userid` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `wcp_fav_categories` -- INSERT INTO `wcp_fav_categories` (`id`, `name`, `userid`) VALUES (9, 'new', 'test'), (8, 'Parts', 'test'), (7, 'Pens', 'test'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_item_mast` -- CREATE TABLE IF NOT EXISTS `wcp_item_mast` ( `slno` int(11) NOT NULL auto_increment, `item_name` varchar(255) NOT NULL default '', `brand_name` varchar(255) NOT NULL default '', `cat_name` varchar(255) NOT NULL default '', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `wcp_item_mast` -- -- -------------------------------------------------------- -- -- Table structure for table `wcp_orderreport` -- CREATE TABLE IF NOT EXISTS `wcp_orderreport` ( `rep_id` int(11) NOT NULL auto_increment, `rep_name` varchar(255) NOT NULL default '', `rep_cat` varchar(255) NOT NULL default '', `rep_qty` varchar(255) NOT NULL default '', `rep_price` varchar(255) NOT NULL default '', `rep_tot` varchar(255) NOT NULL default '', `rep_date` date NOT NULL default '0000-00-00', `rep_user` varchar(255) NOT NULL default '', `rep_userid` varchar(255) NOT NULL default '', PRIMARY KEY (`rep_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=233 ; -- -- Dumping data for table `wcp_orderreport` -- INSERT INTO `wcp_orderreport` (`rep_id`, `rep_name`, `rep_cat`, `rep_qty`, `rep_price`, `rep_tot`, `rep_date`, `rep_user`, `rep_userid`) VALUES (11, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-01', 'test', '0474342a91a8355505b9a7fc781abfef'), (12, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-01', 'test', '0474342a91a8355505b9a7fc781abfef'), (13, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-01', 'test', '0474342a91a8355505b9a7fc781abfef'), (14, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '3', '39', '117', '2008-07-01', 'p', '900556b97cfafeb1b194c9095f379369'), (17, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (16, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-04', 'd', '6760dd210ee92249ac579676c6a1ea81'), (18, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (19, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (20, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (21, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (22, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (23, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (24, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (25, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (26, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (27, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (28, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (29, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (30, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (31, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (32, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (33, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (34, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (35, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (36, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (37, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (38, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (39, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (40, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (41, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (42, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (43, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (44, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (45, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (46, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (47, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (48, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (49, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (50, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (51, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (52, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (53, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (54, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (55, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (56, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (57, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (58, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (59, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (60, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (61, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (62, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (63, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (64, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (65, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (66, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (67, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (68, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (69, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (70, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (71, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (72, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (73, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (74, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (75, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (76, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (77, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (78, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (79, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (80, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (81, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (82, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (83, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (84, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (85, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (86, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (87, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (88, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (89, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (90, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (91, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (92, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (93, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (94, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (95, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (96, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (97, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (98, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (99, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (100, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (101, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (102, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (103, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (104, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (105, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (106, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (107, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (108, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (109, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (110, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (111, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (112, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (113, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (114, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (115, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (116, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (117, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (118, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (119, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (120, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (121, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (122, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (123, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (124, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (125, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (126, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (127, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (128, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (129, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (130, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (131, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (132, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (133, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (134, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (135, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (136, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (137, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (138, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (139, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (140, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (141, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (142, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (143, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (144, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (145, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (146, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (147, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (148, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (149, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (150, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (151, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (152, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (153, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (154, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (155, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (156, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (157, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (158, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (159, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (160, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (161, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (162, 'CRYSTALFILE EXTRA PORTA FOLDER', 'SUSPENSION FILING', '1', '17.52', '17.52', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (163, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (164, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (165, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (166, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (167, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (168, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (169, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (170, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (171, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (172, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (173, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (174, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (175, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (176, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (177, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (178, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (179, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (180, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (181, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (182, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (183, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (184, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (185, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (186, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (187, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (188, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (189, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (190, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (191, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (192, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (193, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (194, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (195, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (196, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (197, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (198, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (199, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (200, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (201, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (202, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (203, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (204, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (205, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (206, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-09', 'test', '8b677e8ac55679f048080f0bbb4b3e53'), (207, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (208, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (209, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (210, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (211, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (212, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (213, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (214, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (215, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (216, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (217, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (218, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (219, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-14', 'test', '8010aa40cc748bf7bf558661fb4e40ec'), (220, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (221, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (222, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (223, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (224, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (225, 'CRYSTALFILE EXTRA POLY SUSP FILE', 'SUSPENSION FILING', '1', '39', '39', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (226, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (227, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (228, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (229, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (230, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-15', 'test', '89ea0b71b5048b7326a9a2ab6971bda1'), (231, 'CRYSTALFILE TOPFILES F/CAP', 'SUSPENSION FILING', '1', '135.49', '135.49', '2008-07-16', 'd', '1e74ea51aee105b64a702ccc88dbae3f'), (232, 'CRYSTALFILE SUSP FILE FRAMES', 'SUSPENSION FILING', '1', '10.67', '10.67', '2008-08-01', 'test', 'f0ae5ab7395e001533874d8715857ed3'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_order_status` -- CREATE TABLE IF NOT EXISTS `wcp_order_status` ( `id` int(11) NOT NULL auto_increment, `orderid` varchar(100) NOT NULL default '', `status` varchar(50) NOT NULL default '', `eta` varchar(100) NOT NULL default '', `warehouse` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `wcp_order_status` -- INSERT INTO `wcp_order_status` (`id`, `orderid`, `status`, `eta`, `warehouse`) VALUES (3, '0474342a91a8355505b9a7fc781abfef', 'Dispatched', '3rd August2', '2'), (4, '1e74ea51aee105b64a702ccc88dbae3f', 'Dispatched', 'eeee', '4'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_products` -- CREATE TABLE IF NOT EXISTS `wcp_products` ( `slno` int(11) NOT NULL auto_increment, `prd_name` varchar(255) NOT NULL default '', `brand_name` varchar(255) NOT NULL default '', `cat_name` varchar(255) NOT NULL default '', `item_name` varchar(255) NOT NULL default '', `item_num` varchar(100) NOT NULL default '', `img_name` varchar(255) NOT NULL default '', `prd_desc` mediumtext NOT NULL, `prd_colors` varchar(255) NOT NULL default '', `prd_sizes` varchar(255) NOT NULL default '', `prd_price` varchar(255) default NULL, `ship` varchar(255) NOT NULL default '', `int_ship` varchar(255) NOT NULL default '', `user_ip` varchar(255) NOT NULL default '', `upd_date` date NOT NULL default '0000-00-00', `dis_special` varchar(255) NOT NULL default '', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=786 ; -- -- Dumping data for table `wcp_products` -- INSERT INTO `wcp_products` (`slno`, `prd_name`, `brand_name`, `cat_name`, `item_name`, `item_num`, `img_name`, `prd_desc`, `prd_colors`, `prd_sizes`, `prd_price`, `ship`, `int_ship`, `user_ip`, `upd_date`, `dis_special`) VALUES (25, 'FILE FLAT A4 STANDARD BLUE (CLEAR FRONT)', '', '4CG05', '', '1001001', 'ACO1001001.jpg', 'FILE FLAT A4 STANDARD BLUE (CLEAR FRONT)', '', '', '0.58', '', '', '', '0000-00-00', ''), (26, 'FILE FLAT A4 STANDARD BLACK (CLEAR FRONT)', '', '4CG05', '', '1001002', 'ACO1001002.jpg', 'FILE FLAT A4 STANDARD BLACK (CLEAR FRONT)', '', '', '0.72', '', '', '', '0000-00-00', ''), (27, 'FILE FLAT A4 STANDARD RED (CLEAR FRONT)', '', '4CG05', '', '1001003', 'ACO1001003.jpg', 'FILE FLAT A4 STANDARD RED (CLEAR FRONT)', '', '', '0.58', '', '', '', '0000-00-00', ''), (28, 'FILE FLAT A4 STANDARD GREEN (CLEAR FRONT)', '', '4CG05', '', '1001004', 'ACO1001004.jpg', 'FILE FLAT A4 STANDARD GREEN (CLEAR FRONT)', '', '', '0.55', '', '', '', '0000-00-00', ''), (29, 'FILE FLAT A4 STANDARD YELLOW (CLEAR FRONT)', '', '4CG05', '', '1001005', 'ACO1001005.jpg', 'FILE FLAT A4 STANDARD YELLOW (CLEAR FRONT)', '', '', '0.58', '', '', '', '0000-00-00', ''), (30, 'PLANNER SASCO EXECUTIVE ALUMINIUM FRAME YEAR 420X594MM', '', '4N302', '', '10560708', 'ACO10560809.jpg', 'PLANNER SASCO EXECUTIVE ALUMINIUM FRAME YEAR 420X594MM', '', '', '72.8', '', '', '', '0000-00-00', ''), (31, 'PLANNER SASCO YEAR 2009 875X610MM', '', '4N301', '', '414100', 'ACO10580.jpg', 'PLANNER SASCO YEAR 2009 875X610MM', '', '', '12.85', '', '', '', '0000-00-00', ''), (32, 'PLANNER SASCO REPOSITIONABLE A2 420X594MM 12 MONTH', '', '4N303', '', '105900', 'ACO10590.jpg', 'PLANNER SASCO REPOSITIONABLE A2 420X594MM 12 MONTH', '', '', '19.95', '', '', '', '0000-00-00', ''), (33, 'FOLDER PRESENTATION A4 WHITE GLOSS PK5', '', '4CH01', '', '11000', 'ACO11000.jpg', 'FOLDER PRESENTATION A4 WHITE GLOSS PK5', '', '', '6.34', '', '', '', '0000-00-00', ''), (34, 'FOLDER PRESENTATION A4 WHITE GLOSS WITH WINDOW PK5', '', '4CH01', '', '11010', 'ACO11010.jpg', 'FOLDER PRESENTATION A4 WHITE GLOSS WITH WINDOW PK5', '', '', '6.34', '', '', '', '0000-00-00', ''), (35, 'FOLDER PRESENTATION A4 WHITE GLOSS PK50', '', '4CH01', '', '11015', 'ACO11015.jpg', 'FOLDER PRESENTATION A4 WHITE GLOSS PK50', '', '', '44.5', '', '', '', '0000-00-00', ''), (36, 'FOLDER PRESENTATION LEATHERGRAIN BLUE', '', '4CH01', '', '1102001', 'ACO1102001.jpg', 'FOLDER PRESENTATION LEATHERGRAIN BLUE', '', '', '12.32', '', '', '', '0000-00-00', ''), (37, 'FOLDER PRESENTATION LEATHERGRAIN BLACK', '', '4CH01', '', '1102002', 'ACO1102002.jpg', 'FOLDER PRESENTATION LEATHERGRAIN BLACK', '', '', '12.32', '', '', '', '0000-00-00', ''), (38, 'FOLDER PRESENTATION LEATHERGRAIN MAROON', '', '4CH01', '', '1102021', 'ACO1102021.jpg', 'FOLDER PRESENTATION LEATHERGRAIN MAROON', '', '', '12.32', '', '', '', '0000-00-00', ''), (39, 'FILE SUSPENSION CRYSTALFILE COMPLETE BOX 50', '', '4C101', '', '54216', 'ACO111130.jpg', 'FILE SUSPENSION CRYSTALFILE COMPLETE BOX 50', '', '', '37.84', '', '', '', '0000-00-00', ''), (40, 'FILE SUSPENSION TWINLOCK CRYSTAL 111190 FILES ONLY', '', '4C101', '', '470201', 'ACO111190.jpg', 'FILE SUSPENSION TWINLOCK CRYSTAL 111190 FILES ONLY', '', '', '26.41', '', '', '', '0000-00-00', ''), (41, 'SUSPENSION FILE CRYSTALFILE CLASSIC COMPLETE PK10', '', '4C102', '', '54205', 'ACO111191.jpg', 'SUSPENSION FILE CRYSTALFILE CLASSIC COMPLETE PK10', '', '', '12.1', '', '', '', '0000-00-00', ''), (42, 'FILE SUSPENSION F/CAP CRYSTALFILE RED PK10', '', '4C104', '', '470022', 'ACO111221.jpg', 'FILE SUSPENSION F/CAP CRYSTALFILE RED PK10', '', '', '17.15', '', '', '', '0000-00-00', ''), (43, 'FILE SUSPENSION F/CAP CRYSTALFILE BLUE PK10', '', '4C104', '', '111222', 'ACO111222.jpg', 'FILE SUSPENSION F/CAP CRYSTALFILE BLUE PK10', '', '', '12.61', '', '', '', '0000-00-00', ''), (44, 'FILE SUSPENSION F/CAP CRYSTALFILE YELLOW PK10', '', '4C104', '', '470009', 'ACO111224.jpg', 'FILE SUSPENSION F/CAP CRYSTALFILE YELLOW PK10', '', '', '12.47', '', '', '', '0000-00-00', ''), (45, 'CRYSTALFILE DOUBLE CAP SUSPENSION FILES BX50', '', '4C108', '', '470011', 'ACO111250.jpg', 'CRYSTALFILE DOUBLE CAP SUSPENSION FILES BX50', '', '', '77.28', '', '', '', '0000-00-00', ''), (46, 'TAB SUSPENSION CRYSTAL CLEAR PK50', '', '4C113', '', '470250', 'ACO111360.jpg', 'TAB SUSPENSION CRYSTAL CLEAR PK50', '', '', '7.88', '', '', '', '0000-00-00', ''), (47, 'INSERT CRYSTALTAB WHITE', '', '4C114', '', '470309', 'ACO111540.jpg', 'INSERT CRYSTALTAB WHITE', '', '', '1.02', '', '', '', '0000-00-00', ''), (48, 'INSERT CRYSTALTAB RED', '', '4C114', '', '54282', 'ACO111541.jpg', 'INSERT CRYSTALTAB RED', '', '', '0.74', '', '', '', '0000-00-00', ''), (49, 'INSERT CRYSTALTAB BLUE', '', '4C114', '', '470296', 'ACO111542.jpg', 'INSERT CRYSTALTAB BLUE', '', '', '1.02', '', '', '', '0000-00-00', ''), (50, 'INSERT CRYSTALTAB GREEN', '', '4C114', '', '470299', 'ACO111543.jpg', 'INSERT CRYSTALTAB GREEN', '', '', '1.02', '', '', '', '0000-00-00', ''), (51, 'INSERT CRYSTALTAB YELLOW', '', '4C114', '', '470300', 'ACO111544.jpg', 'INSERT CRYSTALTAB YELLOW', '', '', '1.02', '', '', '', '0000-00-00', ''), (52, 'INSERT CRYSTALTAB ORANGE', '', '4C114', '', '470297', 'ACO111545.jpg', 'INSERT CRYSTALTAB ORANGE', '', '', '1.02', '', '', '', '0000-00-00', ''), (53, 'INSERT CRYSTALTAB PINK', '', '4C114', '', '470298', 'ACO111546.jpg', 'INSERT CRYSTALTAB PINK', '', '', '1.02', '', '', '', '0000-00-00', ''), (54, 'CRYSTALFILE POLYPROP BLUE BX20 SUSP FILE', '', '4C110', '', '111601', 'ACO111601.jpg', 'CRYSTALFILE POLYPROP BLUE BX20 SUSP FILE', '', '', '36.7', '', '', '', '0000-00-00', ''), (55, 'FOLDER CRYSTALFILE EXTRA PORTA BLACK', '', '4C111', '', '111802', 'ACO111802.jpg', 'FOLDER CRYSTALFILE EXTRA PORTA BLACK', '', '', '15.52', '', '', '', '0000-00-00', ''), (56, 'FILE SUSPENSION F/CAP CRYSTALFILE RAINBOW PK25', '', '4C104', '', '112478', 'ACO112478.jpg', 'FILE SUSPENSION F/CAP CRYSTALFILE RAINBOW PK25', '', '', '25.47', '', '', '', '0000-00-00', ''), (57, 'FILE TOP FILES COMPLETE GREEN BX50', '', '4C107', '', '470252', 'ACO112610.jpg', 'FILE TOP FILES COMPLETE GREEN BX50', '', '', '127.51', '', '', '', '0000-00-00', ''), (58, 'FILES LATERAL A4 COMPLETE BX50', '', '4C209', '', '470190', 'ACO113330.jpg', 'FILES LATERAL A4 COMPLETE BX50', '', '', '100.82', '', '', '', '0000-00-00', ''), (59, 'TAB SUSPENSION CRYSTAL RAINBOW PK50', '', '4C113', '', '11365', 'ACO11365.jpg', 'TAB SUSPENSION CRYSTAL RAINBOW PK50', '', '', '7.47', '', '', '', '0000-00-00', ''), (60, 'TWINLOCK CABINETFILES F/CAP Complete Green', '', '4C103', '', '113675', 'ACO113675.jpg', 'TWINLOCK CABINETFILES F/CAP Complete Green', '', '', '31.67', '', '', '', '0000-00-00', ''), (61, 'FRAME SUSPENSION CRYSTALFILE', '', '4C115', '', '470270', 'ACO11450.jpg', 'FRAME SUSPENSION CRYSTALFILE', '', '', '10.67', '', '', '', '0000-00-00', ''), (62, 'PLANNER SASCO PERPETUAL MAGNETIC YEAR 917X610MM', '', '4N305', '', '700106', 'ACO136295.jpg', 'PLANNER SASCO PERPETUAL MAGNETIC YEAR 917X610MM', '', '', '201', '', '', '', '0000-00-00', ''), (63, 'NOTICEBOARD NOBO ENCLOSED FABRIC 2 DOOR 910X1220MM', '', '4K706', '', '14016280', 'ACO14016280.jpg', 'NOTICEBOARD NOBO ENCLOSED FABRIC 2 DOOR 910X1220MM', '', '', '684.7', '', '', '', '0000-00-00', ''), (64, 'MOUSE KENSINGTON OPTICAL VALU 3 BUTTON W/WHEEL BLACK', '', '43208', '', '1500151', 'ACO1500151.jpg', 'MOUSE KENSINGTON OPTICAL VALU 3 BUTTON W/WHEEL BLACK', '', '', '26.93', '', '', '', '0000-00-00', ''), (65, 'MOUSE KENSINGTON VALU OPTICAL WIRELESS 3 BUTTON W/WHEEL BLACK', '', '43209', '', '1500153', 'ACO1500153.jpg', 'MOUSE KENSINGTON VALU OPTICAL WIRELESS 3 BUTTON W/WHEEL BLACK', '', '', '33.39', '', '', '', '0000-00-00', ''), (66, 'NOTEBOOK COLOURHIDE POCKET 112X77MM 96PG', '', '48103', '', '1715499', 'ACO1715499.jpg', 'NOTEBOOK COLOURHIDE POCKET 112X77MM 96PG', '', '', '1.84', '', '', '', '0000-00-00', ''), (67, 'NOTEBOOK COLOURHIDE REPORTER 200X127MM 200 PG', '', '48103', '', '1715799', 'ACO1715799.jpg', 'NOTEBOOK COLOURHIDE REPORTER 200X127MM 200 PG', '', '', '2.5', '', '', '', '0000-00-00', ''), (68, 'NOTEBOOK A4 COLOURHIDE 5 SUBJECT 250PG', '', '48AA4', '', '1715899', 'ACO1715899.jpg', 'NOTEBOOK A4 COLOURHIDE 5 SUBJECT 250PG', '', '', '5.16', '', '', '', '0000-00-00', ''), (69, 'NOTEBOOK A4 COLOURHIDE 3 SUBJECT 300PG', '', '48AA4', '', '1716099', 'ACO1716099.jpg', 'NOTEBOOK A4 COLOURHIDE 3 SUBJECT 300PG', '', '', '5.51', '', '', '', '0000-00-00', ''), (70, 'NOTEBOOK COLOURHIDE A4 297X210MM 120 PG', '', '48103', '', 'MEL100426', 'ACO1716199.jpg', 'NOTEBOOK COLOURHIDE A4 297X210MM 120 PG', '', '', '2.75', '', '', '', '0000-00-00', ''), (71, 'NOTEBOOK COLOURHIDE CHUNKY 140X110MM 400PG', '', '48103', '', '1716599', 'ACO1716599.jpg', 'NOTEBOOK COLOURHIDE CHUNKY 140X110MM 400PG', '', '', '2', '', '', '', '0000-00-00', ''), (72, 'NOTEBOOK COLOURHIDE EXTRA POCKETS PERF A4 120PGE', '', '48103', '', '1716999', 'ACO1716999.jpg', 'NOTEBOOK COLOURHIDE EXTRA POCKETS PERF A4 120PGE', '', '', '2.59', '', '', '', '0000-00-00', ''), (73, 'NOTEBOOK A4 COLOURHIDE 120PG WITH CLEAR CASE', '', '48103', '', '1717199', 'ACO1717199.jpg', 'NOTEBOOK A4 COLOURHIDE 120PG WITH CLEAR CASE', '', '', '3.15', '', '', '', '0000-00-00', ''), (74, 'NOTEBOOK LECTURE MARBIG ACCOHIDE 297X233MM 250PG', '', '48A02', '', '17180', 'ACO17180.jpg', 'NOTEBOOK LECTURE MARBIG ACCOHIDE 297X233MM 250PG', '', '', '3.96', '', '', '', '0000-00-00', ''), (75, 'NOTEBOOK ACCOHIDE LECTURE A4 297X233MM 120PG', '', '48112', '', '17181', 'ACO17181.jpg', 'NOTEBOOK ACCOHIDE LECTURE A4 297X233MM 120PG', '', '', '2.41', '', '', '', '0000-00-00', ''), (76, 'NOTEBOOK ACCOHIDE REPORTER 200X127MM 300PG', '', '48112', '', '17182', 'ACO17182.jpg', 'NOTEBOOK ACCOHIDE REPORTER 200X127MM 300PG', '', '', '1.97', '', '', '', '0000-00-00', ''), (77, 'NOTEBOOK ACCOHIDE REPORTER 200X127MM 200PG', '', '48112', '', '11181100', 'ACO17183.jpg', 'NOTEBOOK ACCOHIDE REPORTER 200X127MM 200PG', '', '', '1.16', '', '', '', '0000-00-00', ''), (78, 'NOTEBOOK ACCOHIDE REPORTER 200X127MM 100PG', '', '48112', '', '11181101', 'ACO17184.jpg', 'NOTEBOOK ACCOHIDE REPORTER 200X127MM 100PG', '', '', '0.71', '', '', '', '0000-00-00', ''), (79, 'NOTEBOOK ACCOHIDE POCKET 112X77MM 96PG', '', '48112', '', '11181102', 'ACO17185.jpg', 'NOTEBOOK ACCOHIDE POCKET 112X77MM 96PG', '', '', '0.37', '', '', '', '0000-00-00', ''), (80, 'NOTEBOOK ACCOHIDE A5 210X148MM 200PG', '', '48112', '', '17186', 'ACO17186A.jpg', 'NOTEBOOK ACCOHIDE A5 210X148MM 200PG', '', '', '2.38', '', '', '', '0000-00-00', ''), (81, 'NOTEBOOK ACCOHIDE 17187A A4 297X233MM 120PG', '', '48112', '', '17187', 'ACO17187A.jpg', 'NOTEBOOK ACCOHIDE 17187A A4 297X233MM 120PG', '', '', '1.95', '', '', '', '0000-00-00', ''), (82, 'MARBIG ACCOHIDE NOTE BK A4 BLK 120P', '', '48112', '', '84655', 'ACO17187A.jpg', 'MARBIG ACCOHIDE NOTE BK A4 BLK 120P', '', '', '3.97', '', '', '', '0000-00-00', ''), (83, 'NOTEBOOK ACCOHIDE A4 297X233MM 240PG', '', '48112', '', '17188', 'ACO17188.jpg', 'NOTEBOOK ACCOHIDE A4 297X233MM 240PG', '', '', '3.95', '', '', '', '0000-00-00', ''), (84, 'NOTEBOOK ACCOHIDE CHUNKY 102X140MM 400PG', '', '48112', '', '17190', 'ACO17190A.jpg', 'NOTEBOOK ACCOHIDE CHUNKY 102X140MM 400PG', '', '', '1.85', '', '', '', '0000-00-00', ''), (85, 'NOTEBOOK TWIN WIRE A4 BLUE 80 PG', '', '48109', '', '1801001', 'ACO1801001.jpg', 'NOTEBOOK TWIN WIRE A4 BLUE 80 PG', '', '', '5.1', '', '', '', '0000-00-00', ''), (86, 'NOTEBOOK TWIN WIRE A4 RED 80 PG', '', '48109', '', '1801003', 'ACO1801003.jpg', 'NOTEBOOK TWIN WIRE A4 RED 80 PG', '', '', '5.1', '', '', '', '0000-00-00', ''), (87, 'NOTEBOOK BRIGHTS TWIN WIRE A4 GREEN 80PG', '', '48108', '', '235363', 'ACO1801504.jpg', 'NOTEBOOK BRIGHTS TWIN WIRE A4 GREEN 80PG', '', '', '4.96', '', '', '', '0000-00-00', ''), (88, 'NOTEBOOK BRIGHTS TWIN WIRE A4 PINK 80PG', '', '48108', '', '235364', 'ACO1801509.jpg', 'NOTEBOOK BRIGHTS TWIN WIRE A4 PINK 80PG', '', '', '4.96', '', '', '', '0000-00-00', ''), (89, 'NOTEBOOK BRIGHTS TWIN WIRE A4 PURPLE 80PG', '', '48108', '', '235365', 'ACO1801519.jpg', 'NOTEBOOK BRIGHTS TWIN WIRE A4 PURPLE 80PG', '', '', '4.96', '', '', '', '0000-00-00', ''), (90, 'NOTEBOOK TWIN WIRE A5 BLUE 80 PG', '', '48109', '', '1802001', 'ACO1802001.jpg', 'NOTEBOOK TWIN WIRE A5 BLUE 80 PG', '', '', '3.17', '', '', '', '0000-00-00', ''), (91, 'NOTEBOOK TWIN WIRE A5 RED 80 PG', '', '48109', '', '1802003', 'ACO1802003.jpg', 'NOTEBOOK TWIN WIRE A5 RED 80 PG', '', '', '2.86', '', '', '', '0000-00-00', ''), (92, 'NOTEBOOK BRIGHTS TWIN WIRE A5 GREEN 80PG', '', '48108', '', '235366', 'ACO1802504.jpg', 'NOTEBOOK BRIGHTS TWIN WIRE A5 GREEN 80PG', '', '', '2.99', '', '', '', '0000-00-00', ''), (93, 'NOTEBOOK BRIGHTS TWIN WIRE A5 PINK 80PG', '', '48108', '', '235367', 'ACO1802509.jpg', 'NOTEBOOK BRIGHTS TWIN WIRE A5 PINK 80PG', '', '', '2.99', '', '', '', '0000-00-00', ''), (94, 'NOTEBOOK BRIGHTS TWIN WIRE A5 PURPLE 80PG', '', '48108', '', '235368', 'ACO1802519.jpg', 'NOTEBOOK BRIGHTS TWIN WIRE A5 PURPLE 80PG', '', '', '2.99', '', '', '', '0000-00-00', ''), (95, 'NOTEBOOK TWIN WIRE A6 BLUE 80 PG', '', '48109', '', '1803001', 'ACO1803001.jpg', 'NOTEBOOK TWIN WIRE A6 BLUE 80 PG', '', '', '2.21', '', '', '', '0000-00-00', ''), (96, 'NOTEBOOK TWIN WIRE A6 RED 80 PG', '', '48109', '', '1803003', 'ACO1803003.jpg', 'NOTEBOOK TWIN WIRE A6 RED 80 PG', '', '', '1.78', '', '', '', '0000-00-00', ''), (97, 'NOTEBOOK TWIN WIRE A4 160PG WITH CALCULATOR', '', '48110', '', '18040', 'ACO18040.jpg', 'NOTEBOOK TWIN WIRE A4 160PG WITH CALCULATOR', '', '', '6.75', '', '', '', '0000-00-00', ''), (98, 'NOTEBOOK MARBIG SPIRAL POCKET 112X77MM 96PG', '', '48101', '', '18053', 'ACO18053.jpg', 'NOTEBOOK MARBIG SPIRAL POCKET 112X77MM 96PG', '', '', '0.29', '', '', '', '0000-00-00', ''), (99, 'NOTEBOOK MARBIG SPIRAL A5 200X127MM 200PG', '', '48101', '', '18057', 'ACO18057.jpg', 'NOTEBOOK MARBIG SPIRAL A5 200X127MM 200PG', '', '', '0.96', '', '', '', '0000-00-00', ''), (100, 'NOTEBOOK MARBIG SPIRAL A4 297X210MM 120PG', '', '48101', '', '18061', 'ACO18061.jpg', 'NOTEBOOK MARBIG SPIRAL A4 297X210MM 120PG', '', '', '1.5', '', '', '', '0000-00-00', ''), (101, 'PAD MARBIG NOTES 38X50MM YELLOW', '', '47101', '', '1810205', 'ACO1810205.jpg', 'PAD MARBIG NOTES 38X50MM YELLOW', '', '', '3.85', '', '', '', '0000-00-00', ''), (102, 'PAD MARBIG NOTES 75X75MM YELLOW', '', '47101', '', '1810305', 'ACO1810305.jpg', 'PAD MARBIG NOTES 75X75MM YELLOW', '', '', '6.77', '', '', '', '0000-00-00', ''), (103, 'PAD MARBIG NOTES 75X125MM YELLOW', '', '47101', '', '1810505', 'ACO1810505.jpg', 'PAD MARBIG NOTES 75X125MM YELLOW', '', '', '13.98', '', '', '', '0000-00-00', ''), (104, 'PADS PAGEMARKER MARBIG TRANSPARENT ASSTD COLOURS', '', '47202', '', '1811405', 'ACO1811405.jpg', 'PADS PAGEMARKER MARBIG TRANSPARENT ASSTD COLOURS', '', '', '6.83', '', '', '', '0000-00-00', ''), (105, 'NOTEBOOK PROFESSIONAL SERIES WITH VIEW TABS A4 200PG', '', '48111', '', '305007', 'ACO18920.jpg', 'NOTEBOOK PROFESSIONAL SERIES WITH VIEW TABS A4 200PG', '', '', '11.99', '', '', '', '0000-00-00', ''), (106, 'FOLIO MARBIG PROFESSIONAL SERIES WITH NOTEPAD BLACK', '', '49402', '', '305005', 'ACO18930.jpg', 'FOLIO MARBIG PROFESSIONAL SERIES WITH NOTEPAD BLACK', '', '', '9.08', '', '', '', '0000-00-00', ''), (107, 'PAD FLIPCHART BOONE 50 SHEETS', '', '4K501', '', '250298', 'ACO19010.jpg', 'PAD FLIPCHART BOONE 50 SHEETS', '', '', '11.64', '', '', '', '0000-00-00', ''), (108, 'PROJECTOR OVERHEAD NOBO 221CT DUAL LAMP 250W 240V', '', '4KB02', '', '1901668', 'ACO1901668.jpg', 'PROJECTOR OVERHEAD NOBO 221CT DUAL LAMP 250W 240V', '', '', '234.85', '', '', '', '0000-00-00', ''), (109, 'PROJECTOR OVERHEAD NOBO 423CT 400W 240V', '', '4KB03', '', '1901674', 'ACO1901674.jpg', 'PROJECTOR OVERHEAD NOBO 423CT 400W 240V', '', '', '416.02', '', '', '', '0000-00-00', ''), (110, 'NOBO LEAFLET STAND', '', '4O303', '', '193000', 'ACO193000.jpg', 'NOBO LEAFLET STAND', '', '', '145', '', '', '', '0000-00-00', ''), (111, 'STAND BANNER NOBO X BANNER CUSTOMISED', '', '4LA03', '', '195000', 'ACO195000.jpg', 'STAND BANNER NOBO X BANNER CUSTOMISED', '', '', '139.04', '', '', '', '0000-00-00', ''), (112, 'CABLE TIES KENSINGTON PK50', '', '43C09', '', '95074', 'ACO200013.jpg', 'CABLE TIES KENSINGTON PK50', '', '', '7.06', '', '', '', '0000-00-00', ''), (113, 'MOUSE PAD KENSINGTON SUPER THIN BLUE', '', '43401', '', '200014', 'ACO200014.jpg', 'MOUSE PAD KENSINGTON SUPER THIN BLUE', '', '', '6.36', '', '', '', '0000-00-00', ''), (114, 'MONITOR STATION STAND KENSINGTON', '', '43915', '', '200025', 'ACO200025.jpg', 'MONITOR STATION STAND KENSINGTON', '', '', '75.12', '', '', '', '0000-00-00', ''), (115, 'COPYHOLDER A4 KENSINGTON CURVE SWIVEL ARM', '', '43A06', '', '200118', 'ACO200118.jpg', 'COPYHOLDER A4 KENSINGTON CURVE SWIVEL ARM', '', '', '46.73', '', '', '', '0000-00-00', ''), (116, 'COPYHOLDER A4 KENSINGTON CURVE', '', '43A06', '', '200119', 'ACO200119.jpg', 'COPYHOLDER A4 KENSINGTON CURVE', '', '', '19.99', '', '', '', '0000-00-00', ''), (117, 'FILE FLAT A4 DELUXE BLUE (CLEAR FRONT)', '', '4CG04', '', '445280', 'ACO2002001.jpg', 'FILE FLAT A4 DELUXE BLUE (CLEAR FRONT)', '', '', '1.34', '', '', '', '0000-00-00', ''), (118, 'FILE FLAT A4 DELUXE BLACK (CLEAR FRONT)', '', '4CG04', '', '445286', 'ACO2002002.jpg', 'FILE FLAT A4 DELUXE BLACK (CLEAR FRONT)', '', '', '1.34', '', '', '', '0000-00-00', ''), (119, 'FILE FLAT A4 DELUXE RED (CLEAR FRONT)', '', '4CG04', '', '445281', 'ACO2002003.jpg', 'FILE FLAT A4 DELUXE RED (CLEAR FRONT)', '', '', '1.34', '', '', '', '0000-00-00', ''), (120, 'FILE FLAT A4 DELUXE GREEN (CLEAR FRONT)', '', '4CG04', '', '445284', 'ACO2002004.jpg', 'FILE FLAT A4 DELUXE GREEN (CLEAR FRONT)', '', '', '1.34', '', '', '', '0000-00-00', ''), (121, 'FILE FLAT A4 DELUXE YELLOW (CLEAR FRONT)', '', '4CG04', '', '445282', 'ACO2002005.jpg', 'FILE FLAT A4 DELUXE YELLOW (CLEAR FRONT)', '', '', '1.34', '', '', '', '0000-00-00', ''), (122, 'FILE FLAT A4 DELUXE GREY (CLEAR FRONT)', '', '4CG04', '', '445279', 'ACO2002011.jpg', 'FILE FLAT A4 DELUXE GREY (CLEAR FRONT)', '', '', '1.34', '', '', '', '0000-00-00', ''), (123, 'MAILER CD KENSINGTON SLIMLINE COLOURED PK10', '', '43122', '', '92038', 'ACO20021.jpg', 'MAILER CD KENSINGTON SLIMLINE COLOURED PK10', '', '', '10.74', '', '', '', '0000-00-00', ''), (124, 'MAILER CD KENSINGTON SINGLE COLOURED HOLDS COVER BOOKLETS', '', '43122', '', '92039', 'ACO20024', 'MAILER CD KENSINGTON SINGLE COLOURED HOLDS COVER BOOKLETS', '', '', '25.53', '', '', '', '0000-00-00', ''); -- -------------------------------------------------------- -- -- Table structure for table `wcp_promotion` -- CREATE TABLE IF NOT EXISTS `wcp_promotion` ( `pro_id` int(11) NOT NULL auto_increment, `pro_desc` longtext NOT NULL, `pro_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`pro_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `wcp_promotion` -- INSERT INTO `wcp_promotion` (`pro_id`, `pro_desc`, `pro_date`) VALUES (1, '
\r\n

', '2008-07-31'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_settings` -- CREATE TABLE IF NOT EXISTS `wcp_settings` ( `slno` int(11) NOT NULL auto_increment, `cname` varchar(255) NOT NULL default '', `cvalue` varchar(255) NOT NULL default '', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `wcp_settings` -- INSERT INTO `wcp_settings` (`slno`, `cname`, `cvalue`) VALUES (1, 'count', '14'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_shop_cart` -- CREATE TABLE IF NOT EXISTS `wcp_shop_cart` ( `slno` bigint(20) NOT NULL auto_increment, `cartid` varchar(200) NOT NULL default '', `userid` text NOT NULL, `prd_no` varchar(255) NOT NULL default '', `prd_name` varchar(255) NOT NULL default '', `brand_name` varchar(255) NOT NULL default '', `cat_name` varchar(255) NOT NULL default '', `item_name` varchar(255) NOT NULL default '', `prd_price` varchar(255) NOT NULL default '', `prd_color` varchar(255) default NULL, `prd_size` varchar(255) default NULL, `quantity` varchar(255) NOT NULL default '', `per_ship` varchar(255) NOT NULL default '', `ship` varchar(255) NOT NULL default '', `per_int_ship` varchar(255) NOT NULL default '', `int_ship` varchar(255) NOT NULL default '', `total` varchar(255) NOT NULL default '', `add_date` date NOT NULL default '0000-00-00', `add_time` time NOT NULL default '00:00:00', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ; -- -- Dumping data for table `wcp_shop_cart` -- INSERT INTO `wcp_shop_cart` (`slno`, `cartid`, `userid`, `prd_no`, `prd_name`, `brand_name`, `cat_name`, `item_name`, `prd_price`, `prd_color`, `prd_size`, `quantity`, `per_ship`, `ship`, `per_int_ship`, `int_ship`, `total`, `add_date`, `add_time`) VALUES (37, '', '5458f76ce397fcb2267fee698917887e', 'CAN-423456', 'CRYSTALFILE TOPFILES F/CAP', '', 'SUSPENSION FILING', '', '135.49', '', '', '1', '1', '1', '2', '2', '135.49', '2008-07-28', '14:54:46'), (35, '', '89ea0b71b5048b7326a9a2ab6971bda1', 'CAN-423456', 'CRYSTALFILE TOPFILES F/CAP', '', 'SUSPENSION FILING', '', '135.49', 'red', 'BX', '1', '1', '1', '2', '2', '135.49', '2008-07-15', '17:43:33'), (36, '', '1e74ea51aee105b64a702ccc88dbae3f', 'CAN-423456', 'CRYSTALFILE TOPFILES F/CAP', '', 'SUSPENSION FILING', '', '135.49', '', '', '1', '1', '1', '2', '2', '135.49', '2008-07-16', '10:21:44'), (38, '', 'a69553e5fd5c12f42c9e7a665729dab8', 'CAN-423456', 'CRYSTALFILE TOPFILES F/CAP', '', 'SUSPENSION FILING', '', '135.49', '', '', '1', '1', '1', '2', '2', '135.49', '2008-07-30', '11:25:01'), (39, 'f0ae5ab7395e001533874d8715857ed3', 'test', 'CDS-353485', 'CRYSTALFILE SUSP FILE FRAMES', '', 'SUSPENSION FILING', '', '10.67', '', '', '1', '', '', '0', '0', '10.67', '2008-08-01', '01:29:33'), (40, '08b633c8b5a9c8f7ae2bee6dc93649ab', '', '1500151', '', '', '43208', '', '26.93', '', '', '1', '', '', '0', '0', '26.93', '2008-08-08', '12:36:17'), (41, '08b633c8b5a9c8f7ae2bee6dc93649ab', '', '1500151', 'MOUSE KENSINGTON OPTICAL VALU 3 BUTTON W/WHEEL BLACK', '', '43208', '', '26.93', '', '', '1', '', '', '0', '0', '26.93', '2008-08-08', '12:37:47'), (42, 'd2deb52a55d6a0040073936321de831f', '', '1001003', 'FILE FLAT A4 STANDARD RED (CLEAR FRONT)', '', '4CG05', '', '0.58', '', '', '1', '', '', '0', '0', '0.58', '2008-09-25', '00:03:25'), (43, '5ddb0c0bb3670c0cb823ea7f7f4058a4', '', '11000', 'FOLDER PRESENTATION A4 WHITE GLOSS PK5', '', '4CH01', '', '6.34', '', '', '1', '', '', '0', '0', '6.34', '2008-09-25', '00:32:41'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_topsearch` -- CREATE TABLE IF NOT EXISTS `wcp_topsearch` ( `search_id` int(11) NOT NULL auto_increment, `searchuser_id` varchar(255) NOT NULL default '', `keyword` varchar(255) NOT NULL default '', `search_date` date NOT NULL default '0000-00-00', `userid` varchar(255) NOT NULL default '', PRIMARY KEY (`search_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ; -- -- Dumping data for table `wcp_topsearch` -- INSERT INTO `wcp_topsearch` (`search_id`, `searchuser_id`, `keyword`, `search_date`, `userid`) VALUES (1, 'test', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-10', ''), (2, 'test', 'CRYSTALFILE EXTRA PORTA FOLDER', '2008-07-10', ''), (3, 'test', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-10', ''), (4, 'test', 'CRYSTALFILE EXTRA PORTA FOLDER', '2008-07-10', ''), (5, 'test', 'CRYSTALFILE EXTRA PORTA FOLDER', '2008-07-10', ''), (6, 'p', 'CRYSTALFILE EXTRA PORTA FOLDER', '2008-07-10', ''), (7, 'p', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-10', ''), (8, 'd', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-11', '1'), (9, 'd', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-11', '1'), (10, 'd', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-11', '1'), (11, 'd', 'CRYSTALFILE TOPFILES F/CAP', '2008-07-11', '1'), (12, 'd', 'prd', '2008-07-11', '1'), (13, 'd', 'prd', '2008-07-11', '1'), (14, 'd', 'prd', '2008-07-11', '1'), (15, 'd', 'prd', '2008-07-11', '1'), (16, 'd', 'prd', '2008-07-11', '1'), (17, 'd', 'prd', '2008-07-11', '1'), (18, 'd', 'prd', '2008-07-11', '1'), (19, 'd', 'watch', '2008-07-11', '1'), (20, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (21, 'p', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', ''), (22, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (23, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (24, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (25, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (26, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (27, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (28, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (29, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (30, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (31, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', ''), (32, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', ''), (33, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', ''), (34, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', ''), (35, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (36, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (37, 'd', 'CRYSTALFILE SUSP FILE FRAMES', '2008-07-11', '1'), (38, '', 'suspension filing', '2008-07-28', ''), (39, 'test', 'CRYSTALFILE EXTRA PORTA FOLDER', '2008-07-30', ''); -- -------------------------------------------------------- -- -- Table structure for table `wcp_users` -- CREATE TABLE IF NOT EXISTS `wcp_users` ( `slno` bigint(20) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `first_name` varchar(255) NOT NULL default '', `middle_initial` varchar(255) NOT NULL default '', `last_name` varchar(255) NOT NULL default '', `address1` tinytext NOT NULL, `address2` tinytext NOT NULL, `city` varchar(255) NOT NULL default '', `state` varchar(255) NOT NULL default '', `country` varchar(255) NOT NULL default '', `postcode` varchar(255) NOT NULL default '', `phone` varchar(255) NOT NULL default '', `mobile` varchar(255) NOT NULL default '', `fax` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `dob` date NOT NULL default '0000-00-00', `gender` varchar(255) NOT NULL default '', `userid` varchar(255) NOT NULL default '', `pass` varchar(255) NOT NULL default '', `comments` text NOT NULL, `hearabout` text NOT NULL, `type` varchar(255) default NULL, `add_date` varchar(15) default NULL, `add_ip` varchar(255) NOT NULL default '', `upd_date` varchar(15) default NULL, `upd_ip` varchar(255) NOT NULL default '', `log_date` varchar(15) default NULL, `log_ip` varchar(255) NOT NULL default '', `account` varchar(255) NOT NULL default '', PRIMARY KEY (`slno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `wcp_users` -- INSERT INTO `wcp_users` (`slno`, `title`, `first_name`, `middle_initial`, `last_name`, `address1`, `address2`, `city`, `state`, `country`, `postcode`, `phone`, `mobile`, `fax`, `email`, `dob`, `gender`, `userid`, `pass`, `comments`, `hearabout`, `type`, `add_date`, `add_ip`, `upd_date`, `upd_ip`, `log_date`, `log_ip`, `account`) VALUES (1, '', 'Sam', 'Paul', 'Varghese', 'fghfgh', 'gfhfgh', 'gfhfgh', 'ghfgh', 'gfhfgh', '23456', 'fghfgh', '', 'fghfgh', 'fghfgh@dfsd', '0000-00-00', '', 'test', 'test', '', '', NULL, NULL, '', NULL, '', NULL, '', 'Contracts'), (2, '', 'Paul', '', 'Varghese', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', 'p', 'p', '', '', NULL, NULL, '', NULL, '', NULL, '', 'Contracts'); -- -------------------------------------------------------- -- -- Table structure for table `wcp_users1` -- CREATE TABLE IF NOT EXISTS `wcp_users1` ( `slno1` bigint(20) NOT NULL auto_increment, `user` varchar(255) NOT NULL default '', `title1` varchar(255) NOT NULL default '', `first_name1` varchar(255) NOT NULL default '', `middle_initial1` varchar(255) NOT NULL default '', `last_name1` varchar(255) NOT NULL default '', `address11` tinytext NOT NULL, `address21` tinytext NOT NULL, `city1` varchar(255) NOT NULL default '', `state1` varchar(255) NOT NULL default '', `country1` varchar(255) NOT NULL default '', `postcode1` varchar(255) NOT NULL default '', `phone1` varchar(255) NOT NULL default '', `mobile1` varchar(255) NOT NULL default '', `fax1` varchar(255) NOT NULL default '', `email1` varchar(255) NOT NULL default '', `dob1` date NOT NULL default '0000-00-00', `gender1` varchar(255) NOT NULL default '', `userid1` varchar(255) NOT NULL default '', `pass1` varchar(255) NOT NULL default '', `comments1` text NOT NULL, `hearabout1` text NOT NULL, `type1` varchar(255) default NULL, `add_date1` varchar(15) default NULL, `add_ip1` varchar(255) NOT NULL default '', `upd_date1` varchar(15) default NULL, `upd_ip1` varchar(255) NOT NULL default '', `log_date1` varchar(15) default NULL, `log_ip1` varchar(255) NOT NULL default '', `account1` varchar(255) NOT NULL default '', PRIMARY KEY (`slno1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `wcp_users1` -- INSERT INTO `wcp_users1` (`slno1`, `user`, `title1`, `first_name1`, `middle_initial1`, `last_name1`, `address11`, `address21`, `city1`, `state1`, `country1`, `postcode1`, `phone1`, `mobile1`, `fax1`, `email1`, `dob1`, `gender1`, `userid1`, `pass1`, `comments1`, `hearabout1`, `type1`, `add_date1`, `add_ip1`, `upd_date1`, `upd_ip1`, `log_date1`, `log_ip1`, `account1`) VALUES (1, '1', '', 'xcvxcvx', '', 'xcvxcv', 'cvxcv', 'xcvxc', 'vxcv', 'xcvxcv', 'xcvx', 'xcvxcv', 'fdgdfg', '', 'gdfgdfg', 'cvxcvxc@df.fg', '0000-00-00', '', 'd', 'd', '', '', NULL, NULL, '', NULL, '', NULL, '', ''), (3, '2', '', 'dd', '', 'dd', 'dd', 'dd', 'dd', 'dd', 'ddd', 'dddd', '6565', '', '65656', 'dddd@sdf.gh', '0000-00-00', '', 'h', 'h', '', '', NULL, NULL, '', NULL, '', NULL, '', ''), (4, '2', '', 'terterter', '', 'terter', 'tert', 'ertert', 'ert', 'ertert', 'erte', 'tertert', '5345345', '', '534535', 'rtert@er.ghfg', '0000-00-00', '', 'w', 'w', '', '', NULL, NULL, '', NULL, '', NULL, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `wcp_warehouse` -- CREATE TABLE IF NOT EXISTS `wcp_warehouse` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `address` tinytext NOT NULL, `email` varchar(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `wcp_warehouse` -- INSERT INTO `wcp_warehouse` (`id`, `name`, `address`, `email`) VALUES (1, 'QLD', 'QLD', 'warehouse@qld.com'), (2, 'NSW', '', ''), (4, 'NSA', '', '');