# -------------------------------------------------------- # Host: localhost # Server version: 5.5.19 # Server OS: Win64 # HeidiSQL version: 6.0.0.3603 # Date/time: 2012-03-12 18:43:00 # -------------------------------------------------------- # Dumping database structure for chemoventory DROP DATABASE IF EXISTS chemoventory; CREATE DATABASE IF NOT EXISTS chemoventory ; USE chemoventory; # Dumping structure for table chemoventory.chemo_analysis DROP TABLE IF EXISTS chemo_analysis; CREATE TABLE IF NOT EXISTS chemo_analysis ( analysis_id int(10) unsigned NOT NULL AUTO_INCREMENT, analysis_name varchar(25) COLLATE utf8_unicode_ci DEFAULT 'COA', chemical_id int(10) unsigned DEFAULT NULL, analysis_file varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, date_upload date DEFAULT '0000-00-00', PRIMARY KEY (analysis_id), UNIQUE KEY NewIndex (chemical_id,analysis_name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_analysis: 0 rows # Dumping structure for table chemoventory.chemo_audit DROP TABLE IF EXISTS chemo_audit; CREATE TABLE IF NOT EXISTS chemo_audit ( audit_date datetime DEFAULT NULL, ip_address varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, user_id int(11) NOT NULL DEFAULT '0', chemical_id int(11) unsigned NOT NULL DEFAULT '0', quantity float DEFAULT NULL, activity varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, KEY audit_date (audit_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_audit: 0 rows # Dumping structure for table chemoventory.chemo_buildings DROP TABLE IF EXISTS chemo_buildings; CREATE TABLE IF NOT EXISTS chemo_buildings ( building varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PRI', UNIQUE KEY FieldName (building), KEY FieldName_2 (building) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_buildings: 4 rows INSERT IGNORE INTO chemo_buildings (building) VALUES ('Calvin'), ('Lawrence'), ('Lewis'); # Dumping structure for table chemoventory.chemo_category DROP TABLE IF EXISTS chemo_category; CREATE TABLE IF NOT EXISTS chemo_category ( category varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (category), UNIQUE KEY category (category), KEY category_2 (category) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_category: 18 rows INSERT IGNORE INTO chemo_category (category) VALUES ('Bio Chemicals'), ('category2'), ('Custodial or Cleaning'), ('Drugs or Pharmacueticals'), ('Fertilizers'), ('Fuels'), ('Gases'), ('In-organic'), ('In-Organic Lab Chemicals'), ('Maintaenance Shop'), ('Office Supplies'), ('Organic'), ('Organic Lab Chemicals'), ('Paints'), ('Pesticides'), ('Photographic Materials'), ('Pool Maintainance'), ('Refrigerated Liquids'); # Dumping structure for table chemoventory.chemo_chemical DROP TABLE IF EXISTS chemo_chemical; CREATE TABLE IF NOT EXISTS chemo_chemical ( chemical_id int(11) unsigned NOT NULL AUTO_INCREMENT, cas varchar(12) COLLATE utf8_unicode_ci DEFAULT '000-00', chemical varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MUL', category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, catalog_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, lot_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, quantity float NOT NULL DEFAULT '0', units varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', container varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', container_size varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, mixture char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N', purity varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, purchase_date date DEFAULT '0000-00-00', purchase_order varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, invoice_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, shelflife date DEFAULT '2020-01-01', threshold decimal(8,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (chemical_id), KEY cas (cas), KEY chemical (chemical), KEY NewIndex (purchase_date) ) ENGINE=InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_chemical: ~65 rows (approximately) INSERT IGNORE INTO chemo_chemical (chemical_id, cas, chemical, category, manufacturer, catalog_no, lot_no, quantity, units, container, container_size, mixture, purity, purchase_date, purchase_order, invoice_number, price_paid, shelflife, threshold) VALUES (1000001, '', 'chemical', 'Organic', 'Sigma', '', '', 0, 'ml', '', '', 'N', '', '', '', '', 0.00, '1', 10.000); # Dumping structure for table chemoventory.chemo_column DROP TABLE IF EXISTS chemo_column; CREATE TABLE IF NOT EXISTS chemo_column ( column_name varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'chemical', user_id int(8) unsigned NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_column: 6 rows INSERT IGNORE INTO chemo_column (column_name, user_id) VALUES ('category', 1), ('manufacturer', 1), ('purchase_date', 1), ('category', 1), ('manufacturer', 1), ('purchase_date', 1); # Dumping structure for table chemoventory.chemo_configuration DROP TABLE IF EXISTS chemo_configuration; CREATE TABLE IF NOT EXISTS chemo_configuration ( mode varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', property char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY mode (mode), KEY mode_2 (mode) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_configuration: 3 rows INSERT IGNORE INTO chemo_configuration (mode, property) VALUES ('any_user', 'Y'), ('email_server', 'Y'), ('self_registration', 'Y'); # Dumping structure for table chemoventory.chemo_containers DROP TABLE IF EXISTS chemo_containers; CREATE TABLE IF NOT EXISTS chemo_containers ( container varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', container_desc varchar(50) COLLATE utf8_unicode_ci DEFAULT '', PRIMARY KEY (container), UNIQUE KEY container (container), KEY container_2 (container) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_containers: 49 rows INSERT IGNORE INTO chemo_containers (container, container_desc) VALUES ('Bag', ''), ('Box', ''), ('Can', ''), ('Cylinder-0.075', '1.5 x 5 inches'), ('Cylinder-0.15', '1.5 x 9 inches'), ('Cylinder-16', '7 x 34.5 inches'), ('Cylinder-16A', '7 x 34.5 inches'), ('Cylinder-1B', '12 x 33 inches'), ('Cylinder-1C', '15 x 54 inches'), ('Cylinder-1F', '15 x 45 inches'), ('Cylinder-1H', '10 x 51 inches'), ('Cylinder-1I', '8 x 48 inches'), ('Cylinder-1J', '10 x 49 inches'), ('Cylinder-1K', '15 x 52 inches'), ('Cylinder-1L', '10 x 55 inches'), ('Cylinder-1P', '9 x 51 inches'), ('Cylinder-1R', '8 x 48 inches'), ('Cylinder-1T', '24 x 83 inches'), ('Cylinder-1U', '10 x 51 inches'), ('Cylinder-1V', '10 x 48 inches'), ('Cylinder-2', '9 x 26 inches'), ('Cylinder-2B', '6 x 20 inches'), ('Cylinder-2I', '7 x 33 inches'), ('Cylinder-2P', '9 x 26 inches'), ('Cylinder-2R', '7 x 33 inches'), ('Cylinder-3', '4 x 18.5 inches'), ('Cylinder-30', '8 x 49.5 inches'), ('Cylinder-3I', '7 x 16 inches'), ('Cylinder-3P', '6 x 19 inches'), ('Cylinder-3R', '7 x 16 inches'), ('Cylinder-4', '4 x 13 inches'), ('Cylinder-44', '9 x 52.5 inches'), ('Cylinder-47A', '10 x 53.5 inches'), ('Cylinder-49', '9 x 56.5 inches'), ('Cylinder-4P', '4 x 13 inches'), ('Cylinder-6', '4 x 8 inches'), ('Cylinder-6I', '3 x 9 inches'), ('Cylinder-6P', '4 x 8 inches'), ('Cylinder-6R', '3 x 9 inches'), ('Cylinder-7', '2 x 12 inches'), ('Cylinder-8', '7 x 19.5 inches'), ('Cylinder-LB', '2 x 12 inches'), ('Cylinder-LB1', '2 x 13.5 inches'), ('Cylinder-LB2', '2 x 13.5 inches'), ('Cylinder-SSLB', '2 x 12.5 inches'), ('Drum', ''), ('Glass bottle', ''), ('Plastic bottle', ''), ('Vials', ''); # Dumping structure for table chemoventory.chemo_dailyjob DROP TABLE IF EXISTS chemo_dailyjob; CREATE TABLE IF NOT EXISTS chemo_dailyjob ( job_date date NOT NULL DEFAULT '0000-00-00', job_status char(1) COLLATE utf8_unicode_ci DEFAULT 'N', PRIMARY KEY (job_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping structure for table chemoventory.chemo_deleted DROP TABLE IF EXISTS chemo_deleted; CREATE TABLE IF NOT EXISTS chemo_deleted ( chemical_id int(11) unsigned NOT NULL DEFAULT '0', user_id tinyint(3) unsigned NOT NULL DEFAULT '0', user varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', deleted_date datetime DEFAULT NULL, ip_address varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, activity varchar(20) COLLATE utf8_unicode_ci DEFAULT 'Consumed', chemical varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, quantity float NOT NULL DEFAULT '0', units varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', lot_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, location varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', purchase_date date DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, shelflife date DEFAULT NULL, PRIMARY KEY (chemical_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping structure for table chemoventory.chemo_divisions DROP TABLE IF EXISTS chemo_divisions; CREATE TABLE IF NOT EXISTS chemo_divisions ( division varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (division), UNIQUE KEY division (division), KEY division_2 (division) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT IGNORE INTO chemo_divisions (division) VALUES ('Biochemistry'), ('Climate'), ('Fisheries'), ('Organic'), ('Physical'), ('Polym1'); # Dumping structure for table chemoventory.chemo_functions DROP TABLE IF EXISTS chemo_functions; CREATE TABLE IF NOT EXISTS chemo_functions ( functions varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (functions), UNIQUE KEY function (functions), KEY function_2 (functions) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_functions: 49 rows /* !chemo_functions DISABLE KEYS */; INSERT IGNORE INTO chemo_functions (functions) VALUES ('add_analysis'), ('add_chemicals'), ('add_msds'), ('add_nonconsumable'), ('add_users'), ('backup_database'), ('bulk_upload'), ('change_password'), ('chemical_reports'), ('delete_chemicals'), ('delete_nonconsumable'), ('edit_chemicals'), ('edit_msds'), ('edit_mydetails'), ('edit_nonconsumable'), ('edit_properties'), ('edit_userdetails'), ('export_chemicals'), ('export_mychemicals'), ('export_nonconsumable'), ('get_chemicals'), ('logout'), ('manage_building'), ('manage_category'), ('manage_container'), ('manage_division'), ('manage_locations'), ('manage_manufacturers'), ('manage_units'), ('manage_users'), ('print_barcode'), ('transfer_allchemicals'), ('transfer_chemicals'), ('transfer_nonconsumable'), ('upload_users'), ('user_reports'), ('view_allchemicals'), ('view_analysis'), ('view_audits'), ('view_chemicals'), ('view_chemicals2order'), ('view_delete_chemicals'), ('view_deleted'), ('view_expired_chemicals'), ('view_groupchemicals'), ('view_groupreports'), ('view_nonconsumable'), ('view_reports'), ('view_userchemicals'); /* !chemo_functions */; # Dumping structure for table chemoventory.chemo_iplocations DROP TABLE IF EXISTS chemo_iplocations; CREATE TABLE IF NOT EXISTS chemo_iplocations ( location varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PRI', PRIMARY KEY (location), UNIQUE KEY FieldName (location), KEY FieldName_2 (location) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_iplocations: 0 rows /* !chemo_iplocations DISABLE KEYS */; /* !chemo_iplocations */; # Dumping structure for table chemoventory.chemo_locations DROP TABLE IF EXISTS chemo_locations; CREATE TABLE IF NOT EXISTS chemo_locations ( location varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PRI', PRIMARY KEY (location), UNIQUE KEY FieldName (location), KEY FieldName_2 (location) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_locations: 18 rows /* !chemo_locations DISABLE KEYS */; INSERT IGNORE INTO chemo_locations (location) VALUES (''), ('freezer'), ('fridge'), ('IPRI'), ('LC1'), ('LS31'), ('shelf'); # Dumping structure for table chemoventory.chemo_logactivity DROP TABLE IF EXISTS chemo_logactivity; CREATE TABLE IF NOT EXISTS chemo_logactivity ( user varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', sql_date datetime DEFAULT NULL, ip varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, page varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', sql_code varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, KEY NewIndex (sql_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping structure for table chemoventory.chemo_logs DROP TABLE IF EXISTS chemo_logs; CREATE TABLE IF NOT EXISTS chemo_logs ( session varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, user varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, ip varchar(75) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', signin datetime DEFAULT NULL, signout datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping structure for table chemoventory.chemo_manual DROP TABLE IF EXISTS chemo_manual; CREATE TABLE IF NOT EXISTS chemo_manual ( manual_id int(10) unsigned NOT NULL AUTO_INCREMENT, nonconsumable_id int(10) DEFAULT NULL, item_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manual_file varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, file_size varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, date_upload datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (manual_id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_manual: ~1 rows (approximately) INSERT IGNORE INTO chemo_manual (manual_id, nonconsumable_id, item_name, manufacturer, manual_file, file_size, date_upload) VALUES (1, 9, 'beaker', 'one', '9_Chrysant_1.jpg', '857.1', '2012-02-24 22:17:06'); # Dumping structure for table chemoventory.chemo_manufacturers DROP TABLE IF EXISTS chemo_manufacturers; CREATE TABLE IF NOT EXISTS chemo_manufacturers ( manufacturer varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PRI', PRIMARY KEY (manufacturer), UNIQUE KEY FieldName (manufacturer), KEY FieldName_2 (manufacturer) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_manufacturers: 9 rows /* !chemo_manufacturers DISABLE KEYS */; INSERT IGNORE INTO chemo_manufacturers (manufacturer) VALUES (''), ('Aldrich'), ('Covance'), ('Fluka'), ('Labscan'), ('Labtek'), ('None'), ('Sigma'), ('VWR'); /* !chemo_manufacturers */; # Dumping structure for table chemoventory.chemo_mixture DROP TABLE IF EXISTS chemo_mixture; CREATE TABLE IF NOT EXISTS chemo_mixture ( chemical_id int(11) unsigned NOT NULL, component varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', percent decimal(6,3) DEFAULT '50.000', cas varchar(12) COLLATE utf8_unicode_ci DEFAULT '000-00', PRIMARY KEY (chemical_id,component) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_mixture: ~0 rows (approximately) /* !chemo_mixture DISABLE KEYS */; /* !chemo_mixture */; # Dumping structure for table chemoventory.chemo_msds DROP TABLE IF EXISTS chemo_msds; CREATE TABLE IF NOT EXISTS chemo_msds ( msds_id int(10) unsigned NOT NULL AUTO_INCREMENT, cas varchar(16) DEFAULT NULL, chemical varchar(255) NOT NULL DEFAULT '', manufacturer varchar(50) NOT NULL DEFAULT 'NA', msds_file varchar(50) NOT NULL DEFAULT '', file_size varchar(8) NOT NULL DEFAULT '0', date_upload datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (msds_id), UNIQUE KEY NewIndex (manufacturer,chemical,msds_file) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; # Dumping data for table chemoventory.chemo_msds: 0 rows /* !chemo_msds DISABLE KEYS */; /* !chemo_msds */; # Dumping structure for table chemoventory.chemo_ncaudit DROP TABLE IF EXISTS chemo_ncaudit; CREATE TABLE IF NOT EXISTS chemo_ncaudit ( audit_date datetime DEFAULT NULL, ip_address varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, user_id int(11) NOT NULL DEFAULT '0', nonconsumable_id int(11) unsigned NOT NULL DEFAULT '0', quantity float DEFAULT NULL, activity varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, KEY audit_date (audit_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_ncaudit: 2 rows /* !chemo_ncaudit DISABLE KEYS */; INSERT IGNORE INTO chemo_ncaudit (audit_date, ip_address, user_id, nonconsumable_id, quantity, activity) VALUES ('2012-02-23 23:08:09', 'localhost', 1, 9, 1, 'Duplicate'), ('2012-02-23 23:11:25', 'localhost', 1, 13, 1, 'Acquired'); /* !chemo_ncaudit */; # Dumping structure for table chemoventory.chemo_nc_category DROP TABLE IF EXISTS chemo_nc_category; CREATE TABLE IF NOT EXISTS chemo_nc_category ( category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_nc_category: 6 rows /* !chemo_nc_category DISABLE KEYS */; INSERT IGNORE INTO chemo_nc_category (category) VALUES ('Analytical Instrument'), ('Gas Tank'), ('Glassware'), ('Lab Equipment'), ('Miscellaneous'), ('Tool'); /* !chemo_nc_category */; # Dumping structure for table chemoventory.chemo_nc_deleted DROP TABLE IF EXISTS chemo_nc_deleted; CREATE TABLE IF NOT EXISTS chemo_nc_deleted ( nonconsumable_id int(11) unsigned NOT NULL DEFAULT '0', user_id int(11) unsigned NOT NULL DEFAULT '0', item_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MUL', deleted_date datetime DEFAULT NULL, ip_address varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, activity varchar(20) COLLATE utf8_unicode_ci DEFAULT 'Broken', category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, model varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, catalog_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, specification varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, quantity int(3) NOT NULL DEFAULT '1', purchase_date date DEFAULT '0000-00-00', received_date date DEFAULT '0000-00-00', purchase_order varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, invoice_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, location varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (nonconsumable_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_nc_deleted: 0 rows /* !chemo_nc_deleted DISABLE KEYS */; /* !chemo_nc_deleted */; # Dumping structure for table chemoventory.chemo_nonconsumable DROP TABLE IF EXISTS chemo_nonconsumable; CREATE TABLE IF NOT EXISTS chemo_nonconsumable ( nonconsumable_id int(11) unsigned NOT NULL AUTO_INCREMENT, user_id int(11) unsigned NOT NULL DEFAULT '0', item_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MUL', category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, model varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, catalog_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, specification varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, quantity int(3) NOT NULL DEFAULT '1', purchase_date date DEFAULT '0000-00-00', received_date date DEFAULT NULL, purchase_order varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, invoice_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, location varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', nc_image varchar(50) COLLATE utf8_unicode_ci DEFAULT 'unavailable.gif', PRIMARY KEY (nonconsumable_id) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_nonconsumable: 13 rows /* !chemo_nonconsumable DISABLE KEYS */; INSERT IGNORE INTO chemo_nonconsumable (nonconsumable_id, user_id, item_name, category, manufacturer, model, catalog_no, specification, quantity, purchase_date, received_date, purchase_order, invoice_number, price_paid, building, division, room, location, nc_image) VALUES (1, 1, 'beaker', 'Gas Tank', 'Covance', '', '', '', 1, '2012-02-23', '2012-02-23', '', '', 0.00, 'Calvin', 'Climate', '', 'LC1', '1.jpg') ; /* !chemo_nonconsumable */; # Dumping structure for table chemoventory.chemo_owner DROP TABLE IF EXISTS chemo_owner; CREATE TABLE IF NOT EXISTS chemo_owner ( chemical_id int(11) unsigned NOT NULL DEFAULT '0', user_id int(11) unsigned NOT NULL DEFAULT '0', building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, location varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', quantity_inhand float NOT NULL DEFAULT '0', received_date date DEFAULT NULL, PRIMARY KEY (chemical_id), UNIQUE KEY NewIndex2 (chemical_id), KEY NewIndex (user_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_owner: ~66 rows (approximately) /* !chemo_owner DISABLE KEYS */; INSERT IGNORE INTO chemo_owner (chemical_id, user_id, building, division, room, location, quantity_inhand, received_date) VALUES (1000001, 1, '231', 'IPRI', '2S1A', 'FC1', 500, '2012-02-29'); /* !chemo_owner */; # Dumping structure for table chemoventory.chemo_properties DROP TABLE IF EXISTS chemo_properties; CREATE TABLE IF NOT EXISTS chemo_properties ( properties_id int(11) unsigned NOT NULL AUTO_INCREMENT, chemical varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', cas varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, formula varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL, label varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL, alternativenames varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, physical_state varchar(12) COLLATE utf8_unicode_ci DEFAULT '', health tinyint(1) unsigned DEFAULT NULL, flammable tinyint(1) unsigned DEFAULT NULL, reactive tinyint(1) unsigned DEFAULT NULL, hazardous char(1) COLLATE utf8_unicode_ci DEFAULT NULL, poison char(1) COLLATE utf8_unicode_ci DEFAULT '', oxidizer char(1) COLLATE utf8_unicode_ci DEFAULT NULL, isotope char(1) COLLATE utf8_unicode_ci DEFAULT '', radio_active char(1) COLLATE utf8_unicode_ci DEFAULT '', notes longtext COLLATE utf8_unicode_ci, PRIMARY KEY (properties_id), UNIQUE KEY NewIndex2 (chemical) ) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping structure for table chemoventory.chemo_recycle DROP TABLE IF EXISTS chemo_recycle; CREATE TABLE IF NOT EXISTS chemo_recycle ( chemical_id int(11) unsigned NOT NULL DEFAULT '0', user_id int(11) unsigned NOT NULL DEFAULT '0', quantity_available varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, location_available varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_recycle: 0 rows /* !chemo_recycle DISABLE KEYS */; /* !chemo_recycle */; # Dumping structure for table chemoventory.chemo_reports DROP TABLE IF EXISTS chemo_reports; CREATE TABLE IF NOT EXISTS chemo_reports ( report_id int(10) unsigned NOT NULL AUTO_INCREMENT, rpt_namr varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, report mediumtext COLLATE utf8_unicode_ci, PRIMARY KEY (report_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_reports: 0 rows /* !chemo_reports DISABLE KEYS */; /* !chemo_reports */; # Dumping structure for table chemoventory.chemo_roles DROP TABLE IF EXISTS chemo_roles; CREATE TABLE IF NOT EXISTS chemo_roles ( roles varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', functions varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (roles,functions) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_roles: 88 rows /* !chemo_roles DISABLE KEYS */; INSERT IGNORE INTO chemo_roles (roles, functions) VALUES ('admin', 'add_admin'), ('admin', 'add_analysis'), ('admin', 'add_chemicals'), ('admin', 'add_msds'), ('admin', 'add_nonconsumable'), ('admin', 'add_units'), ('admin', 'add_users'), ('admin', 'backup_database'), ('admin', 'bulk_upload'), ('admin', 'chemical_reports'), ('admin', 'delete_chemicals'), ('admin', 'delete_nonconsumable'), ('admin', 'edit_chemicals'), ('admin', 'edit_mydetails'), ('admin', 'edit_nonconsumable'), ('admin', 'edit_properties'), ('admin', 'edit_userdetails'), ('admin', 'export_chemicals'), ('admin', 'export_mychemicals'), ('admin', 'export_nonconsumable'), ('admin', 'get_chemicals'), ('admin', 'manage_buildings'), ('admin', 'manage_category'), ('admin', 'manage_containers'), ('admin', 'manage_divisions'), ('admin', 'manage_functions'), ('admin', 'manage_groups'), ('admin', 'manage_ip'), ('admin', 'manage_locations'), ('admin', 'manage_manufacturers'), ('admin', 'manage_roles'), ('admin', 'manage_units'), ('admin', 'manage_users'), ('admin', 'print_barcode'), ('admin', 'transfer_allchemicals'), ('admin', 'transfer_chemicals'), ('admin', 'transfer_nonconsumable'), ('admin', 'upload_users'), ('admin', 'user_reports'), ('admin', 'view_admin'), ('admin', 'view_allchemicals'), ('admin', 'view_analysis'), ('admin', 'view_audits'), ('admin', 'view_chemicals'), ('admin', 'view_chemicals2order'), ('admin', 'view_delete_chemicals'), ('admin', 'view_deleted'), ('admin', 'view_expired_chemicals'), ('admin', 'view_groupchemicals'), ('admin', 'view_nonconsumable'), ('admin', 'view_reports'), ('admin', 'view_userchemicals'), ('group_leader', 'add_analysis'), ('group_leader', 'add_chemicals'), ('group_leader', 'add_msds'), ('group_leader', 'add_nonconsumable'), ('group_leader', 'add_users'), ('group_leader', 'bulk_upload'), ('group_leader', 'delete_nonconsumable'), ('group_leader', 'edit_msds'), ('group_leader', 'edit_mydetails'), ('group_leader', 'edit_nonconsumable'), ('group_leader', 'edit_userdetails'), ('group_leader', 'get_chemicals'), ('group_leader', 'transfer_chemicals'), ('group_leader', 'transfer_nonconsumable'), ('group_leader', 'view_allchemicals'), ('group_leader', 'view_analysis'), ('group_leader', 'view_chemicals'), ('group_leader', 'view_groupchemicals'), ('group_leader', 'view_nonconsumable'), ('temp', 'add_chemicals'), ('temp', 'view_allchemicals'), ('temp', 'view_chemicals'), ('user', 'add_msds'), ('user', 'add_nonconsumable'), ('user', 'delete_nonconsumable'), ('user', 'edit_mydetails'), ('user', 'edit_nonconsumable'), ('user', 'edit_userdetails'), ('user', 'export_mychemicals'), ('user', 'get_chemicals'), ('user', 'print_barcode'), ('user', 'transfer_chemicals'), ('user', 'transfer_nonconsumable'), ('user', 'view_analysis'), ('user', 'view_chemicals'), ('user', 'view_nonconsumable'); /* !chemo_roles */; # Dumping structure for table chemoventory.chemo_temp_inventory DROP TABLE IF EXISTS chemo_temp_inventory; CREATE TABLE IF NOT EXISTS chemo_temp_inventory ( temp_id int(10) unsigned NOT NULL AUTO_INCREMENT, user varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', cas varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL, chemical varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, catalog_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, lot_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, quantity varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', units varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', container varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', container_size varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, mixture char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N', purity varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, purchase_date varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', purchase_order varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, invoice_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, location varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', shelflife varchar(12) COLLATE utf8_unicode_ci DEFAULT '2010-12-01', threshold decimal(8,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (temp_id) ) ENGINE=MyISAM AUTO_INCREMENT=305 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_temp_inventory: 0 rows /* !chemo_temp_inventory DISABLE KEYS */; /* !chemo_temp_inventory */; # Dumping structure for table chemoventory.chemo_temp_nc DROP TABLE IF EXISTS chemo_temp_nc; CREATE TABLE IF NOT EXISTS chemo_temp_nc ( temp_id int(11) unsigned NOT NULL AUTO_INCREMENT, user_id int(11) unsigned NOT NULL DEFAULT '0', item_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MUL', category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, model varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, catalog_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, specification varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, purchase_date varchar(12) COLLATE utf8_unicode_ci DEFAULT '0000-00-00', received_date varchar(12) COLLATE utf8_unicode_ci DEFAULT '0000-00-00', purchase_order varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, invoice_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, location varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (temp_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_temp_nc: ~0 rows (approximately) /* !chemo_temp_nc DISABLE KEYS */; /* !chemo_temp_nc */; # Dumping structure for table chemoventory.chemo_temp_users DROP TABLE IF EXISTS chemo_temp_users; CREATE TABLE IF NOT EXISTS chemo_temp_users ( user_temp_id int(11) unsigned NOT NULL AUTO_INCREMENT, user varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', email varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', roles varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user', end_date date NOT NULL DEFAULT '0000-00-00', first_name varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', last_name varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, supervisor varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, phone varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (user_temp_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_temp_users: 0 rows /* !chemo_temp_users DISABLE KEYS */; /* !chemo_temp_users */; # Dumping structure for table chemoventory.chemo_transfers DROP TABLE IF EXISTS chemo_transfers; CREATE TABLE IF NOT EXISTS chemo_transfers ( chemical_id int(11) unsigned NOT NULL DEFAULT '0', from_user varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', to_user varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', quantity_transfered varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', notes varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, transfer_date date NOT NULL DEFAULT '0000-00-00' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_transfers: 0 rows /* !chemo_transfers DISABLE KEYS */; /* !chemo_transfers */; # Dumping structure for table chemoventory.chemo_units DROP TABLE IF EXISTS chemo_units; CREATE TABLE IF NOT EXISTS chemo_units ( unit varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', unit_desc varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY unit (unit), KEY unit_2 (unit) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_units: 10 rows /* !chemo_units DISABLE KEYS */; INSERT IGNORE INTO chemo_units (unit, unit_desc) VALUES ('gal', 'gallon'), ('gm', 'Gram'), ('kg', 'Kilo Gram'), ('L', 'Liter'), ('lb', 'Pound'), ('mg', 'Milli Gram'), ('mL', 'Milli Liter'), ('oz m', 'Mass Ounce'), ('oz', 'Liquid Ounce'), ('ton', '1000 Kg'); /* !chemo_units */; # Dumping structure for table chemoventory.chemo_user DROP TABLE IF EXISTS chemo_user; CREATE TABLE IF NOT EXISTS chemo_user ( user_id int(11) unsigned NOT NULL AUTO_INCREMENT, user varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', email varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', password varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', roles varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user', start_date date NOT NULL DEFAULT '0000-00-00', end_date date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (user_id) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_user: 2 rows /* !chemo_user DISABLE KEYS */; INSERT IGNORE INTO chemo_user (user_id, user, email, password, roles, start_date, end_date) VALUES (1, 'sysadmin', '', '5c83f48a70ca8bbb6bb92c55556cdf28', 'admin', '2012-01-01', '2030-01-01'), (2, 'user1', '', '5c83f48a70ca8bbb6bb92c55556cdf28', 'user', '2012-01-01', '2030-10-27'); /* !chemo_user */; # Dumping structure for table chemoventory.chemo_userdetails DROP TABLE IF EXISTS chemo_userdetails; CREATE TABLE IF NOT EXISTS chemo_userdetails ( user_id int(11) unsigned NOT NULL DEFAULT '0', first_name varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', last_name varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, supervisor varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, phone varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, division varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, building varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, room varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (user_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.chemo_userdetails: 2 rows /* !chemo_userdetails DISABLE KEYS */; INSERT IGNORE INTO chemo_userdetails (user_id, first_name, last_name, supervisor, phone, division, building, room) VALUES (1, '', '', 'sysadmin', '', '', '', ''), (2, '', '', 'sysadmin', '8978', 'Biochemistry', 'Calvin', 'opp'); /* !chemo_userdetails */; # Dumping structure for table chemoventory.logs DROP TABLE IF EXISTS logs; CREATE TABLE IF NOT EXISTS logs ( date date NOT NULL DEFAULT '0000-00-00', time time NOT NULL DEFAULT '00:00:00', ip varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, url varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, referer varchar(125) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.logs: ~0 rows (approximately) /* !logs DISABLE KEYS */; /* !logs */; # Dumping structure for table chemoventory.temp_bulk_chemical DROP TABLE IF EXISTS temp_bulk_chemical; CREATE TABLE IF NOT EXISTS temp_bulk_chemical ( chemical_id int(11) NOT NULL DEFAULT '0', cas varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL, chemical varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, category varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, manufacturer varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, catalog_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, lot_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, quantity float DEFAULT NULL, units varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, container varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, container_size varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, mixture char(1) COLLATE utf8_unicode_ci DEFAULT NULL, purity varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, purchase_date date DEFAULT NULL, purchase_order varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, invoice_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, price_paid decimal(8,2) DEFAULT NULL, shelflife date DEFAULT NULL, threshold decimal(8,3) DEFAULT NULL, PRIMARY KEY (chemical_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; # Dumping data for table chemoventory.temp_bulk_chemical: ~0 rows (approximately)