---- Table "gal_imgs" --
DROP TABLE IF EXISTS `gal_imgs`;
CREATE TABLE `gal_imgs` (
	`IdGalImg` int(11) NOT NULL,
	`IdGalEntrada` int(11) NOT NULL,
	`NomeImg` varchar(15) NOT NULL,
	`l` smallint(6) NOT NULL default '0',
	`a` smallint(6) NOT NULL COMMENT '0',
	`Ord` int(11) NOT NULL default '0',
	`DataUltAct` datetime NOT NULL,
	`DataIns` datetime NOT NULL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci;
INSERT INTO `gal_imgs` (`IdGalImg`,`IdGalEntrada`,`NomeImg`,`l`,`a`,`Ord`,`DataUltAct`,`DataIns`) VALUES
	(5,4,'8396.jpg',464,320,5,'2007-04-27 02:55:57','2007-04-27 02:55:57'),
	(6,4,'8397.jpg',464,320,6,'2007-04-27 02:56:17','2007-04-27 02:56:17'),
	(7,5,'8398.jpg',464,320,7,'2007-04-27 02:56:45','2007-04-27 02:56:45'),
	(8,5,'8399.jpg',464,320,8,'2007-04-27 02:57:02','2007-04-27 02:57:02'),
	(9,5,'8400.jpg',464,320,9,'2007-04-27 02:57:24','2007-04-27 02:57:24'),
	(10,5,'8401.jpg',464,320,10,'2007-04-27 02:57:54','2007-04-27 02:57:54'),
	(11,6,'8402.jpg',464,320,11,'2007-04-27 02:58:51','2007-04-27 02:58:51'),
	(12,6,'8403.jpg',464,320,12,'2007-04-27 02:59:16','2007-04-27 02:59:16'),
	(13,7,'8404.jpg',464,320,13,'2007-04-27 02:59:54','2007-04-27 02:59:54'),
	(14,7,'8405.jpg',464,320,14,'2007-04-27 03:00:13','2007-04-27 03:00:13'),
	(15,7,'8406.jpg',464,320,15,'2007-04-27 03:00:39','2007-04-27 03:00:39'),
	(16,8,'8407.jpg',464,320,16,'2007-04-27 03:01:32','2007-04-27 03:01:32'),
	(17,8,'8408.jpg',464,320,17,'2007-04-27 03:02:02','2007-04-27 03:02:02'),
	(18,9,'8409.jpg',464,320,18,'2007-04-27 03:02:46','2007-04-27 03:02:46'),
	(19,11,'8410.jpg',464,320,19,'2007-04-27 04:49:59','2007-04-27 04:49:59'),
	(20,11,'8411.jpg',464,320,20,'2007-04-27 04:50:14','2007-04-27 04:50:14'),
	(21,11,'8412.jpg',464,320,21,'2007-04-27 04:50:38','2007-04-27 04:50:38'),
	(22,11,'8413.jpg',464,320,22,'2007-04-27 04:51:02','2007-04-27 04:51:02'),
	(23,11,'8414.jpg',464,320,23,'2007-04-27 04:51:23','2007-04-27 04:51:23'),
	(24,11,'8415.jpg',464,320,24,'2007-04-27 04:51:40','2007-04-27 04:51:40'),
	(25,11,'8416.jpg',464,320,25,'2007-04-27 04:52:00','2007-04-27 04:52:00'),
	(26,11,'8417.jpg',464,320,26,'2007-04-27 04:52:26','2007-04-27 04:52:26'),
	(27,11,'8418.jpg',464,320,27,'2007-04-27 04:52:43','2007-04-27 04:52:43'),
	(28,11,'8419.jpg',464,320,28,'2007-05-02 10:21:26','2007-04-27 04:52:56'),
	(29,14,'8420.jpg',464,320,29,'2007-04-27 04:59:46','2007-04-27 04:59:46'),
	(30,14,'8421.jpg',464,320,30,'2007-04-27 04:59:57','2007-04-27 04:59:57'),
	(31,12,'8422.jpg',464,320,31,'2007-04-27 05:01:05','2007-04-27 05:00:25'),
	(32,12,'8423.jpg',464,320,32,'2007-04-27 05:00:58','2007-04-27 05:00:39'),
	(33,13,'8424.jpg',464,320,33,'2007-04-27 05:01:22','2007-04-27 05:01:22'),
	(34,13,'8425.jpg',464,320,34,'2007-04-27 05:01:43','2007-04-27 05:01:43'),
	(35,16,'8426.jpg',464,320,35,'2007-04-27 05:02:48','2007-04-27 05:02:48'),
	(36,16,'8427.jpg',464,320,36,'2007-04-27 05:03:26','2007-04-27 05:03:26'),
	(37,17,'8428.jpg',464,320,37,'2007-04-27 05:04:06','2007-04-27 05:04:06'),
	(38,17,'8429.jpg',464,320,38,'2007-04-27 05:04:26','2007-04-27 05:04:26'),
	(39,15,'8430.jpg',464,320,39,'2007-04-27 05:05:10','2007-04-27 05:05:01'),
	(40,18,'8431.jpg',464,320,40,'2007-04-27 05:05:40','2007-04-27 05:05:40'),
	(41,18,'8432.jpg',464,320,41,'2007-04-27 05:05:55','2007-04-27 05:05:55'),
	(42,19,'8439.png',464,320,42,'2007-05-03 12:10:15','2007-05-03 12:10:15');

---- Table "gal_imgs_descrs" --
DROP TABLE IF EXISTS `gal_imgs_descrs`;
CREATE TABLE `gal_imgs_descrs` (
	`IdLing` char(2) NOT NULL,
	`IdGalImg` int(11) NOT NULL,
	`Tit` varchar(50) default NULL,
	`Descr` mediumtext NOT NULL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci;

INSERT INTO `gal_imgs_descrs` (`IdLing`,`IdGalImg`,`Tit`,`Descr`) VALUES
	('pt',5,'Flor 1',''),
	('pt',6,'Flor 2',''),
	('pt',7,'Nuvem 1',''),
	('pt',8,'Nuvem 2',''),
	('pt',9,'Nuvem 3',''),
	('pt',10,'Nuvem 4',''),
	('pt',11,'Carvalho',''),
	('pt',12,'Alto fogo','A porte do sítio onde nasci...'),
	('pt',13,'A posar para a foto...',''),
	('pt',14,'Envergonhada',''),
	('pt',15,'A tocar na folhinha',''),
	('pt',16,'Sr. Fernando','Parece um doutor...'),
	('pt',17,'Grande Plano',''),
	('pt',18,'Ok, podes seguir :-)',''),
	('pt',19,'Nico 1',''),
	('pt',20,'Nico 2',''),
	('pt',21,'Nico 3',''),
	('pt',22,'Nico 4',''),
	('pt',23,'Nico 5',''),
	('pt',24,'Nico 6',''),
	('pt',25,'Nico 7',''),
	('pt',26,'Nico 8',''),
	('pt',27,'Nico 9',''),
	('pt',28,'Nico 10',''),
	('pt',29,'Avó do Monte 1',''),
	('pt',30,'Avó do Monte 2',''),
	('pt',31,'Avó do Rio 1',''),
	('pt',32,'Avó do Rio 2',''),
	('pt',33,'Avô do Rio 1',''),
	('pt',34,'Avó do Rio 2','Ah fadista!!'),
	('pt',35,'Um',''),
	('pt',36,'Dois',''),
	('pt',37,'Eu 1','Uma carinha que só uma mãe pode gostar...'),
	('pt',38,'Eu 2','Não comento.'),
	('pt',39,'O maior...',''),
	('pt',40,'A família é pequena',''),
	('pt',41,'Encher chouriços...',''),
	('pt',42,'Imagens primárias','');

---- Table "gal_entradas" --
DROP TABLE IF EXISTS `gal_entradas`;
CREATE TABLE `gal_entradas` (
	`IdGalEntrada` int(11) NOT NULL,
	`IdGalCat` int(11) NOT NULL,
	`DataUltAct` datetime NOT NULL,
	`DataIns` datetime NOT NULL,
	`Ord` int(11) NOT NULL default '0'
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci;

INSERT INTO `gal_entradas` (`IdGalEntrada`,`IdGalCat`,`DataUltAct`,`DataIns`,`Ord`) VALUES
	(4,3,'2007-04-27 02:56:17','2007-04-27 02:55:19',4),
	(5,3,'2007-04-27 02:57:54','2007-04-27 02:56:26',5),
	(6,3,'2007-04-27 02:59:16','2007-04-27 02:58:22',6),
	(7,4,'2007-04-27 03:00:39','2007-04-27 02:59:33',7),
	(8,4,'2007-04-27 03:02:02','2007-04-27 03:00:50',8),
	(9,4,'2007-04-27 03:02:46','2007-04-27 03:02:24',9),
	(10,5,'2007-05-02 12:39:13','2007-04-27 04:49:33',10),
	(11,5,'2007-05-02 10:21:26','2007-04-27 04:49:40',11),
	(12,4,'2007-04-27 05:01:05','2007-04-27 04:57:13',12),
	(13,4,'2007-04-27 05:01:43','2007-04-27 04:57:18',13),
	(14,4,'2007-04-27 04:59:57','2007-04-27 04:57:24',14),
	(15,4,'2007-04-27 05:05:10','2007-04-27 04:57:56',15),
	(16,4,'2007-04-27 05:03:26','2007-04-27 05:02:32',16),
	(17,4,'2007-04-27 05:04:26','2007-04-27 05:03:36',17),
	(18,4,'2007-04-27 05:05:55','2007-04-27 05:05:23',18),
	(19,6,'2007-05-03 12:10:15','2007-05-03 11:46:40',19);

---- Table "gal_entradas_descrs" --
DROP TABLE IF EXISTS `gal_entradas_descrs`;
CREATE TABLE `gal_entradas_descrs` (
	`IdLing` char(2) NOT NULL,
	`IdGalEntrada` int(11) NOT NULL,
	`Tit` varchar(50) NOT NULL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci;

---- View "vw_gal_cats_imgs_1" --
CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `vw_gal_cats_imgs_1` AS select `gal_entradas`.`IdGalCat` AS `IdGalCat`,`gal_imgs`.`NomeImg` AS `NomeImg`,`gal_imgs`.`l` AS `l`,`gal_imgs`.`a` AS `a`,`gal_imgs`.`Ord` AS `Ord` from (`gal_imgs` join `gal_entradas` on((`gal_imgs`.`IdGalEntrada` = `gal_entradas`.`IdGalEntrada`))) order by `gal_entradas`.`IdGalCat`,`gal_imgs`.`Ord` desc;
---- View "vw_gal_cats_imgs_2" --
CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `vw_gal_cats_imgs_2` AS select `vw_gal_cats_imgs_1`.`IdGalCat` AS `IdGalCat`,`vw_gal_cats_imgs_1`.`NomeImg` AS `NomeImg`,`vw_gal_cats_imgs_1`.`l` AS `l`,`vw_gal_cats_imgs_1`.`a` AS `a` from `vw_gal_cats_imgs_1` group by `vw_gal_cats_imgs_1`.`IdGalCat`;

---- PROCEDURE "test1" --
-- This one works the way I'd expect.
DROP PROCEDURE IF EXISTS `test1`
CREATE PROCEDURE `test1`()
	BEGIN

	select T.`IdGalCat` AS `IdGalCat`,T.`NomeImg`,T.`l` AS `l`,T.`a` AS `a`
		from (select * from vw_gal_cats_imgs_1) T
		group by T.`IdGalCat`;

	END

---- PROCEDURE "test2" --
-- This one doesn't.
DROP PROCEDURE IF EXISTS `test2`
CREATE PROCEDURE `test2`()
	BEGIN

	select T.`IdGalCat` AS `IdGalCat`,T.`NomeImg`,T.`l` AS `l`,T.`a` AS `a`
		from vw_gal_cats_imgs_1 T
		group by T.`IdGalCat`;

	END