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


--
-- Database: `giocv`
--

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

--
-- Table structure for table `categorias`
--

CREATE TABLE IF NOT EXISTS `categorias` (
  `codigo` int(11) NOT NULL auto_increment,
  `categoria` varchar(100) collate utf8_unicode_ci NOT NULL,
  `category` varchar(100) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`codigo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `categorias`
--

INSERT INTO `categorias` (`codigo`, `categoria`, `category`) VALUES
(1, 'Professor Catedrático', 'Cathedratic Teacher'),
(2, 'Professor Associado', 'Associeted Teacher'),
(3, 'Professor Auxiliar', 'Auxiliary Teacher'),
(4, 'Assistente', 'Assistant'),
(5, 'Assistente Estagiário', 'Trainee Assistant'),
(6, 'Aluno Doutoramento', 'PhD Student'),
(7, 'Aluno Mestrado', 'MSc Student'),
(8, 'Aluno Mestrado', 'MSc Student'),
(0, ' -- ', ' --');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `cod` int(11) NOT NULL,
  `contacto` varchar(10000) collate utf8_unicode_ci NOT NULL,
  `email` varchar(1000) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`cod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`cod`, `contacto`, `email`) VALUES
(1, 'Professor Doutor José Borges de Almeida<br /><br />\r\nDepartamento de Física, Escola de Ciências<br /><br />\r\nCampus de Gualtar 4710-057 Braga<br /><br />\r\n', 'bda@fisica.uminho.pt');

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

--
-- Table structure for table `home`
--

CREATE TABLE IF NOT EXISTS `home` (
  `codigo` int(11) NOT NULL,
  `descricao` mediumtext collate utf8_unicode_ci NOT NULL,
  `about` varchar(10000) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `home`
--

INSERT INTO `home` (`codigo`, `descricao`, `about`) VALUES
(1, '<!DOCTYPE html PUBLIC \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\" \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\">\r\n<html>\r\n<head>\r\n<title>Untitled document</title>\r\n</head>\r\n<body>\r\n<p style=\\"\\\\\\"><strong><span style=\\"\\\\\\">O Grupo de &Oacute;ptica e Ci&ecirc;ncias da Vis&atilde;o</span></strong> &eacute; um dos grupos de investiga&ccedil;&atilde;o do Centro de F&iacute;sica da Universidade do Minho.</p>\r\n<p style=\\"\\\\\\"><span style=\\"\\\\\\"> </span>Desenvolve investiga&ccedil;&atilde;o em &aacute;reas da &oacute;ptica aplicada &agrave; vis&atilde;o em particular, em Instrumenta&ccedil;&atilde;o Optom&eacute;trica, Colorimetria e Vis&atilde;o das Cores, Optometria Cl&iacute;nica e Contactologia. Integra actualmente 13 membros e &eacute; liderado  pelo Professor Jos&eacute; Manuel Borges de Almeida, Professor Catedr&aacute;tico doutorado em &Oacute;ptica pela  Universidade de Oxford e Fellow da American Academy of Optometry.</p>\r\n<p style=\\"\\\\\\">&nbsp;</p>\r\n<p style=\\"\\\\\\">&nbsp;</p>\r\n<p style=\\"\\\\\\">NOVIDADES:</p>\r\n<p style=\\"\\\\\\">&nbsp;</p>\r\n<p style=\\"\\\\\\">\r\n<ul>\r\n<li>KK COISA;</li>\r\n</ul>\r\n<div></div>\r\n<div></div>\r\n</p>\r\n</body>\r\n</html>', 'Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. Text in English. ');

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

--
-- Table structure for table `investigacao`
--

CREATE TABLE IF NOT EXISTS `investigacao` (
  `codInv` int(11) NOT NULL auto_increment,
  `titulo` varchar(80) collate utf8_unicode_ci NOT NULL,
  `title` varchar(100) collate utf8_unicode_ci NOT NULL,
  `descricao` varchar(10000) collate utf8_unicode_ci default NULL,
  `about` varchar(10000) collate utf8_unicode_ci NOT NULL,
  `foto` varchar(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`codInv`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

--
-- Dumping data for table `investigacao`
--

INSERT INTO `investigacao` (`codInv`, `titulo`, `title`, `descricao`, `about`, `foto`) VALUES
(0, ' --', ' --', NULL, '', 'images/labs/default.png');

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

--
-- Table structure for table `lab_mem`
--

CREATE TABLE IF NOT EXISTS `lab_mem` (
  `codInv` int(11) NOT NULL,
  `codUser` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lab_mem`
--

INSERT INTO `lab_mem` (`codInv`, `codUser`) VALUES
(0, 2);

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

--
-- Table structure for table `projectos`
--

CREATE TABLE IF NOT EXISTS `projectos` (
  `codInv` int(11) NOT NULL,
  `codPro` int(11) NOT NULL auto_increment,
  `descricao` varchar(10000) collate utf8_unicode_ci default NULL,
  `about` text collate utf8_unicode_ci NOT NULL,
  `titulo` varchar(500) collate utf8_unicode_ci NOT NULL,
  `title` varchar(500) collate utf8_unicode_ci NOT NULL,
  `financiamento` varchar(1500) collate utf8_unicode_ci default NULL,
  `financing` text collate utf8_unicode_ci NOT NULL,
  `responsavel` int(11) default NULL,
  `varea` tinyint(1) NOT NULL,
  PRIMARY KEY  (`codPro`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `projectos`
--


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

--
-- Table structure for table `pro_pub`
--

CREATE TABLE IF NOT EXISTS `pro_pub` (
  `codPro` int(11) NOT NULL,
  `codPub` int(11) NOT NULL,
  PRIMARY KEY  (`codPro`,`codPub`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pro_pub`
--

INSERT INTO `pro_pub` (`codPro`, `codPub`) VALUES
(61, 38),
(62, 38),
(63, 25),
(64, 36),
(65, 1),
(65, 36),
(66, 25),
(66, 38);

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

--
-- Table structure for table `publicacoes`
--

CREATE TABLE IF NOT EXISTS `publicacoes` (
  `codPub` int(11) NOT NULL auto_increment,
  `citacao` varchar(500) collate utf8_unicode_ci NOT NULL,
  `vprofile` tinyint(1) NOT NULL,
  `varea` tinyint(1) NOT NULL,
  `link` varchar(500) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`codPub`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=46 ;

--
-- Dumping data for table `publicacoes`
--


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

--
-- Table structure for table `slideshow`
--

CREATE TABLE IF NOT EXISTS `slideshow` (
  `codigo` int(11) NOT NULL auto_increment,
  `titulo` varchar(10000) collate utf8_unicode_ci default NULL,
  `title` mediumtext collate utf8_unicode_ci NOT NULL,
  `descricao` varchar(10000) collate utf8_unicode_ci default NULL,
  `about` mediumtext collate utf8_unicode_ci NOT NULL,
  `foto` varchar(1000) collate utf8_unicode_ci NOT NULL,
  `ordem` int(11) NOT NULL,
  PRIMARY KEY  (`codigo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=22 ;

--
-- Dumping data for table `slideshow`
--

INSERT INTO `slideshow` (`codigo`, `titulo`, `title`, `descricao`, `about`, `foto`, `ordem`) VALUES
(1, 'Slideshow', 'Title 1', 'Este é um slideshow de imagens de teste! Esta é a primeira imagem.', 'About 1', 'images/slideshow/orange-fish.jpg', 1),
(2, 'Imagem 2', 'Title 2', 'Segunda imagem do slideshow.', 'About 2', 'images/slideshow/sea-turtle.jpg', 3),
(3, 'Imagem 3. Esta imagem apenas possui título!', 'Title 3', '', 'About 3', 'images/slideshow/red-coral.jpg', 2),
(4, NULL, 'Title 4', 'Imagem quatro. Esta imagem apenas possui descrição!', 'About 4', 'images/slideshow/coral-reef.jpg', 4),
(5, 'Imagem 5', 'Title 5', 'Esta é a imagem cinco!', 'About 5', 'images/slideshow/blue-fish.jpg', 5),
(6, 'Imagem 6', 'Title 6', 'Imagem seis com uma descrição muito grande apenas para teste. Assim será possível determinar como ficará uma descrição longa.', 'About 6', 'images/slideshow/yellow-fish.jpg', 6),
(7, 'Imagem 7', 'Title 7', 'Descrição da imagem sete.', 'About 7', 'images/slideshow/squid.jpg', 7),
(8, 'Imagem 8', 'Title 8', 'Descrição da imagem oito.', 'About 8', 'images/slideshow/small-fish.jpg', 8),
(20, 'titulo adicionado', 'title add', 'sobre add', 'about add', 'images/slideshow/teste.jpg', 9);

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

--
-- Table structure for table `user_proj`
--

CREATE TABLE IF NOT EXISTS `user_proj` (
  `codUser` int(11) NOT NULL,
  `codPro` int(11) NOT NULL,
  `vprofile` tinyint(1) NOT NULL,
  PRIMARY KEY  (`codUser`,`codPro`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_proj`
--


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

--
-- Table structure for table `user_pub`
--

CREATE TABLE IF NOT EXISTS `user_pub` (
  `codUser` int(11) NOT NULL,
  `codPub` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_pub`
--

