-- http://www.phpmyadmin.net
--




--
-- Database: `avaria`
--

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

--
-- Table structure for table `avarias`
--

CREATE TABLE IF NOT EXISTS `avarias` (
  `codavaria` int(4) NOT NULL AUTO_INCREMENT,
  `codutilizador` int(3) NOT NULL,
  `prioridade` varchar(20) NOT NULL,
  `bandeira` varchar(20) NOT NULL,
  `codsala` int(6) NOT NULL,
  `npc` varchar(4) NOT NULL,
  `codhard` int(3) NOT NULL,
  `outrohard` varchar(20) NOT NULL,
  `codsoft` int(3) NOT NULL,
  `outrosoft` varchar(50) NOT NULL,
  `data` varchar(10) NOT NULL,
  `hora` varchar(5) NOT NULL,
  `descricao` text NOT NULL,
  `relatorio` text NOT NULL,
  `estado` int(3) NOT NULL,
  `estado2` varchar(20) NOT NULL,
  PRIMARY KEY (`codavaria`),
  KEY `codutilizador` (`codutilizador`),
  KEY `codutilizador_2` (`codutilizador`),
  KEY `codsala` (`codsala`),
  KEY `codsala_2` (`codsala`),
  KEY `codhard` (`codhard`),
  KEY `codsoft` (`codsoft`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hardware`
--

CREATE TABLE IF NOT EXISTS `hardware` (
  `codhard` int(3) NOT NULL AUTO_INCREMENT,
  `nomehard` varchar(50) NOT NULL,
  PRIMARY KEY (`codhard`),
  UNIQUE KEY `codhard` (`codhard`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `hardware`
--

INSERT INTO `hardware` (`codhard`, `nomehard`) VALUES
(1, ' '),
(2, 'Rato'),
(3, 'Teclado'),
(4, 'CDROM-DVD'),
(5, 'Monitor'),
(6, 'Unidade de Sistema (CPU)'),
(7, 'Video Projetor'),
(8, 'Quadro interativo');

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

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `codutilizador` int(11) DEFAULT NULL,
  `nome` varchar(100) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `nivel` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`codutilizador`, `nome`, `password`, `nivel`) VALUES
(1, 'Michel', '123', 'admin'),
(2, 'mario', '123', 'assistente'),
(3, 'ANTONIO PEREIRA', 'ANTPER12', 'professor'),
(4, 'CARLOS BARROTE', 'camiraba', 'professor'),
(5, 'HELENA TEODORO', 'miguel100', 'professor'),
(6, 'ISABEL SILVA', 'MI4562', 'professor'),
(7, 'RUI PINHO', 'RUIPIN09', 'professor'),
(8, 'CLAUDIA MARTINS', 'CLAMAR09', 'professor'),
(9, 'EZEQUIEL VALE', 'EV3737', 'professor'),
(10, 'FERNANDO MOREIRA', '70024253', 'professor'),
(11, 'JORGE FIDALGO', '26678883', 'professor'),
(12, 'LUIS VAZ', 'luisvaz', 'professor'),
(13, 'MARIA FERNANDES', '030676', 'professor'),
(14, 'RITA VIOLANTE', 'RITVIO09', 'professor'),
(15, 'NUNO ESPERANÇA', 'NUNESP013', 'professor'),
(16, 'TANIA SA', 'TANSA013', 'professor'),
(17, 'FERNANDO LAGO', 'FL0011', 'professor'),
(18, 'FLORA MOURA', 'FLOMOU12', 'professor'),
(19, 'GLORIA TORRES', 'GLOTOR11', 'professor'),
(20, 'MANUEL DOMINGUES', 'MANDOM11', 'professor'),
(21, 'MARIA JESUS', '3bernardo', 'professor'),
(22, 'EDUARDA OLIVEIRA', '00186EDU', 'professor'),
(23, 'MONICA MACIEL', 'mon3mac', 'professor'),
(24, 'ROSA CASTRO', '31665904', 'professor'),
(25, 'TERESA RODRIGUES', 'TRpipa', 'professor'),
(26, 'FRANCISCO PIRES', 'FRAPIR077', 'professor'),
(27, 'FATIMA LOPES', '16954403', 'professor'),
(28, 'TERESA SOARES', 'filipa', 'professor'),
(29, 'ELISABETE BALINHA', 'beta06', 'professor'),
(30, 'MARTA GOMES', 'MARGOM088', 'professor'),
(31, 'JULIO VASCONCELOS', 'JV2713', 'professor'),
(32, 'LIMA FERREIRA', 'MANFER', 'professor'),
(33, 'ELISABETE QUINTAS', 'ELIQUI013', 'professor'),
(34, 'IVONE VIEIRA', 'IVOVIE013', 'professor'),
(35, 'PAULO SOUSA', 'PAUSA08', 'professor'),
(36, 'NATALIA PINHEIRO', 'NATPIN021', 'professor'),
(37, 'JOAO GONÇALVES', 'JOAGON11', 'professor'),
(38, 'TERESA LOURENCO', 'TERLOU013', 'professor'),
(39, 'MARIA PRAZERES', 'MARPER013', 'professor'),
(40, 'ALFREDO SILVA', '260469', 'professor'),
(41, 'DILERMANDO CARVALHO', 'DILCAR013', 'professor'),
(42, 'CLAUDIA GIRAO', 'CLAGIR12', 'professor'),
(43, 'ROSA SILVA', 'ROSREG013', 'professor'),
(44, 'JACINTO ESTEVENS', 'jasil08', 'professor'),
(45, 'JORGE SILVA', 'JORSIL09', 'professor'),
(46, 'FERNANDA COIMBRA', 'iopkliop', 'professor'),
(47, 'TERESA VIEIRA', 'teresa01', 'professor'),
(48, 'SANDRA OLIVEIRA', '140569', 'professor'),
(49, 'RUTE CRUZ', 'RUTCRU12', 'professor'),
(50, 'Francelina Gomes', 'vianaest', 'professor'),
(51, 'MANUEL MORAIS', 'MANMOR09', 'professor'),
(52, 'CELESTE FERROS', 'W84pWgLW', 'professor'),
(53, 'FATIMA BRAGA', 'F00080', 'professor'),
(54, 'HELENA SOUSA', 'MSS103', 'professor'),
(55, 'ROSA REGO', 'rcfr56', 'professor'),
(56, 'TERESA SILVA', 'TSE158', 'professor'),
(57, 'SERGIO OLIVEIRA', 'ASO785', 'professor'),
(58, 'DALILA DANTAS', '160472', 'professor'),
(59, 'ELISABETE REI', 'ELIREI09', 'professor'),
(60, 'JORGE CALEIRO', '123456jmc', 'professor'),
(61, 'MARIA JOSE NORA', 'JNF111', 'professor'),
(62, 'SALOME RIBEIRO', 'SALRIB009', 'professor'),
(63, 'ANTONIO  CARVALHO', 'AC5792', 'professor'),
(64, 'ANTONIO GONÇALVES', '405A9405', 'professor'),
(65, 'MARTA SANTOS', 'BEBSAN09', 'professor'),
(66, 'EUGENIA FELGUEIRAS', 'EF2258', 'professor'),
(67, 'IOLANDA LIMA', 'IRL719', 'professor'),
(68, 'LUCIA LIMA', '05011956', 'professor'),
(69, 'LUIS CAVALHEIRO', 'alivroeiou', 'professor'),
(70, 'CARMO CARVALHO', 'Mcarmo', 'professor'),
(71, 'VERA PEREIRA', 'VERPER12', 'professor'),
(72, 'TERESA PIMENTEL', 'teresapi', 'professor'),
(73, 'LAURINDA BARROS', 'LAUBAR013', 'professor'),
(74, 'CARLA MAIA', 'CARMAI11', 'professor'),
(75, 'LIGIA MAGALHAES', 'catmi32', 'professor'),
(76, 'CLAUDIA SANTOS', 'CLASAN12', 'professor'),
(77, 'LUIS MACEDO', '808655', 'professor'),
(78, 'FATIMA REIS', '13maio52', 'professor'),
(79, 'HELENA GIGANTE', 'MHAG45', 'professor'),
(80, 'SHEILA FERREIRA', 'MARFER12', 'professor'),
(81, 'ANA BELA AFONSO', '000444', 'professor'),
(82, 'BENJAMIM MOREIRA', 'vgp456', 'professor'),
(83, 'ILDA CORREIA', 'ilda1968', 'professor'),
(84, 'LAURO MARTINS', '37714765', 'professor'),
(85, 'CRISTINA MORAIS', 'CrisMor09', 'professor'),
(86, 'GLORIA VIANA', 'QUINTAS28', 'professor'),
(87, 'CRISTINA GOMES', 'CRIGOM013', 'professor'),
(88, 'MANUELA RUAS', 'MANRUA013', 'professor'),
(89, 'GLORIA AZEREDO', 'GLOAZE013', 'professor'),
(90, 'JOAQUIM OLIVEIRA', 'JOAOLI013', 'professor'),
(91, 'CONCEIÇAO FERREIRA', 'CONFER013', 'professor'),
(92, 'ESTELA CARVALHO', 'ESTCAR013', 'professor'),
(93, 'HUGUETE GONÇALVES', 'eliseu', 'professor');

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

--
-- Table structure for table `pcs`
--

CREATE TABLE IF NOT EXISTS `pcs` (
  `codpc` int(3) NOT NULL AUTO_INCREMENT,
  `nome` varchar(30) NOT NULL,
  PRIMARY KEY (`codpc`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `pcs`
--

INSERT INTO `pcs` (`codpc`, `nome`) VALUES
(1, 'Professor'),
(2, 'PC1'),
(3, 'PC2'),
(4, 'PC3');

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

--
-- Table structure for table `salas`
--

CREATE TABLE IF NOT EXISTS `salas` (
  `codsala` int(11) DEFAULT NULL,
  `sala` varchar(52) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salas`
--

INSERT INTO `salas` (`codsala`, `sala`) VALUES
(1, 'LAB 1.01'),
(2, 'LAB 1.02'),
(3, 'LAB 1.03'),
(4, 'LAB 1.04'),
(5, 'LAB 2.01'),
(6, 'LAB 2.02'),
(7, 'LAB 2.03'),
(8, 'LAB 2.04'),
(9, 'LAB 2.05'),
(10, 'SALA 0.01'),
(11, 'SALA 0.02'),
(12, 'SALA 0.03'),
(13, 'SALA 0.04'),
(14, 'SALA 0.05'),
(15, 'SALA 0.06'),
(16, 'SALA 0.07'),
(17, 'SALA 0.08'),
(18, 'SALA 0.09'),
(19, 'SALA 1.01'),
(20, 'SALA 1.02'),
(21, 'SALA 1.03'),
(22, 'SALA 1.05'),
(23, 'SALA 1.06'),
(24, 'SALA 1.07'),
(25, 'SALA 1.08'),
(26, 'SALA 1.09'),
(27, 'SALA 1.10'),
(28, 'SALA 1.11'),
(29, 'SALA 2.01'),
(30, 'SALA 2.02'),
(31, 'SALA 2.03'),
(32, 'SALA 2.04'),
(33, 'SALA 2.05'),
(34, 'SALA 2.06'),
(35, 'SALA 2.07'),
(36, 'SALA 2.08'),
(37, 'SALA 2.09'),
(38, 'SALA 2.10'),
(39, 'SALA 2.11'),
(40, 'SALA 2.12'),
(41, 'SALA 2.13'),
(42, 'SALA 2.14'),
(43, 'SALA 2.15'),
(44, 'SALA 2.16'),
(45, 'SALA 2.17'),
(46, 'SALA 2.18'),
(47, 'SALA 2.19'),
(48, 'SALA 2.20'),
(49, 'SALA 2.21'),
(50, 'SALA 2.22'),
(51, 'SALA 2.23'),
(52, 'SALA 2.24'),
(53, 'SALA 2.25'),
(54, 'SALA 2.26'),
(55, 'SALA 2.27'),
(56, 'SALA 2.28'),
(57, 'SALA Docentes'),
(58, 'SALA DTurma'),
(59, 'SALA Conselho'),
(60, 'SALA Psicologia'),
(61, 'DEP Físico Química'),
(62, 'DEP Biologia Geologia'),
(63, 'DEP Artes'),
(64, 'DEP Filosofia'),
(65, 'DEP Línguas'),
(66, 'DEP Matemática'),
(67, 'DEP Informática'),
(68, 'DEP Edu. Física'),
(69, 'DEP Ciências S Humanas'),
(70, 'Cursos Profissionais'),
(71, 'GAM. PROM. SUCESSO'),
(72, 'Direção'),
(73, 'Secretaria'),
(74, 'Museu'),
(75, 'Biblioteca'),
(76, 'GIAE - Loja Aluno'),
(77, 'GIAE - Bar'),
(78, 'GIAE - Refeitório'),
(79, 'GIAE - PBX'),
(80, 'GIAE - Quiosque'),
(81, 'SEC Direção'),
(82, 'SEC Expediente'),
(83, 'Auditório');

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

--
-- Table structure for table `software`
--

CREATE TABLE IF NOT EXISTS `software` (
  `codsoft` int(3) NOT NULL AUTO_INCREMENT,
  `nomesoft` varchar(50) NOT NULL,
  PRIMARY KEY (`codsoft`),
  KEY `codsoft` (`codsoft`),
  KEY `codsoft_2` (`codsoft`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `software`
--

INSERT INTO `software` (`codsoft`, `nomesoft`) VALUES
(1, ' '),
(2, 'Windows'),
(3, 'Microsoft Office'),
(4, 'Utilactas'),
(5, 'Sumários'),
(6, 'Alunos');

