 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 
-CREATE OR REPLACE VIEW jos_beer_viewpeople AS 
+CREATE OR REPLACE VIEW #__beer_viewpeople AS 
 SELECT p.*, 
 	CONCAT_WS(' ', p.`firstname`, p.`middlename`, p.`lastname`) AS name,
 	IF(d.enabled < 1, CONCAT('[', d.title, ']'), d.title) AS department,

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

--
-- Dumping data for table `jos_beer_people`
--

INSERT INTO `jos_beer_people` (`beer_person_id`, `beer_department_id`, `beer_office_id`, `firstname`, `middlename`, `lastname`, `alias`, `position`, `birthday`, `gender`, `mobile`, `email`, `bio`, `created`, `created_by`, `modified`, `modified_by`, `enabled`) VALUES
(2, 1, 1, 'Eberhardt', '', 'Terkki', 'eberhardt_terkki', 'Employee', '1964-06-02', 1, '147258369', 'info@down.show', '', '0000-00-00 00:00:00', 62, '1970-01-01 01:00:00', 0, 1),
(3, 1, 2, 'Bamford', '', 'Parto', 'bamford_parto', 'Employee', '1959-11-30', 1, '147258369', 'info@down.show', '', '2009-07-05 23:32:13', 62, '1970-01-01 01:00:00', 0, 1),
(4, 1, 3, 'Chirstian', '', 'Koblick', 'chirstian_koblick', 'Employee', '1954-05-01', 1, '147258369', 'info@down.show', '', '2009-07-05 23:32:18', 62, '1970-01-01 01:00:00', 0, 1),



CREATE TABLE IF NOT EXISTS `#__beer_departments` (
  `beer_department_id` SERIAL,
  `title` varchar(250) NOT NULL,
  `alias` varchar(255) NOT NULL,
