1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
| -- phpMyAdmin SQL Dump
-- version 2.11.5
-- <a href="http://www.phpmyadmin.net" target="_blank">http://www.phpmyadmin.net</a>
--
-- Serveur: localhost
-- Généré le : Mer 12 Mars 2008 à 14:18
-- Version du serveur: 5.0.45
-- Version de PHP: 5.2.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de données: `ocsglpitools`
--
-- --------------------------------------------------------
--
-- Structure de la table `modele_conversion`
--
CREATE TABLE IF NOT EXISTS `modele_conversion` (
`modele_conversion_ID` int(11) NOT NULL auto_increment,
`modele_conversion_modele` varchar(60) NOT NULL,
`modele_conversion_types` varchar(60) NOT NULL,
PRIMARY KEY (`modele_conversion_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
INSERT INTO `modele_conversion` (`modele_conversion_ID`, `modele_conversion_modele`, `modele_conversion_types`) VALUES
(3, 'HVM domU', '5'),
(5, '6223ZD7', '4'),
(6, '6223CTO', '4'),
(7, '818349G', '1'),
(8, '6223Z7V', '4'),
(9, '622542Y', '4'),
(10, '-[6230F5G]-', '4'),
(11, 'hp workstation xw4100', '4');
-- --------------------------------------------------------
--
-- Structure de la table `types_conversion`
--
CREATE TABLE IF NOT EXISTS `types_conversion` (
`types_conversion_ID` int(11) NOT NULL auto_increment,
`types_conversion_types_exotiques` varchar(60) NOT NULL,
`types_conversion_types` varchar(60) NOT NULL,
PRIMARY KEY (`types_conversion_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Contenu de la table `types_conversion`
--
INSERT INTO `types_conversion` (`types_conversion_ID`, `types_conversion_types_exotiques`, `types_conversion_types`) VALUES
(8, 'Peripheral Chassis', '2'),
(2, 'Low Profile Desktop', '1'),
(3, 'Tower', '4'),
(4, 'Notebook', '2'),
(7, 'Work Station', '4'),
(9, 'Mini Tower', '4'),
(11, 'Unknown', '15');
-- --------------------------------------------------------
--
-- Structure de la table `type_computer`
--
CREATE TABLE IF NOT EXISTS `type_computer` (
`type_computer_ID` int(11) NOT NULL auto_increment,
`type_computer_type` varchar(60) NOT NULL,
`type_computer_comments` varchar(60) NOT NULL,
PRIMARY KEY (`type_computer_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
--
-- Contenu de la table `type_computer`
--
INSERT INTO `type_computer` (`type_computer_ID`, `type_computer_type`, `type_computer_comments`) VALUES
(1, 'Desktop', ''),
(2, 'Laptop', ''),
(3, 'Server', ''),
(4, 'Workstation', ''),
(5, 'Virtual Desktop', ''),
(6, 'Virtual Server', ''),
(7, 'Thin Client', ''),
(15, 'Other', ''); |
Partager