SET NAMES 'UTF8';
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `dbo_tDominancia` CASCADE;
CREATE TABLE `dbo_tDominancia` (
	`IDDominancia` int,
	`Dominancia` varchar(30),
	`suly` varchar(10)
);

INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (0, null, null);
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (1, 'határozott', '9         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (2, 'biztos', '9         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (3, 'erőteljes', '8         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (4, 'öntudatos', '7         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (5, 'normál', '6         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (6, 'lágy', '4         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (7, 'alkalmazkodó', '5         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (8, 'alázatos', '3         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (9, 'számító', '2         ');
INSERT INTO `dbo_tDominancia` (`IDDominancia`, `Dominancia`, `suly`) VALUES (10, 'önállótlan', '1         ');

SET FOREIGN_KEY_CHECKS = 1;
