Cyg8tN7C

1--
2-- Tabellenstruktur für Tabelle `jos_joomleague_position`
3--
4
5CREATE TABLE IF NOT EXISTS `jos_joomleague_position` (
6  `id` int(11) NOT NULL auto_increment,
7  `name` varchar(75) NOT NULL default '',
8  `alias` varchar(75) NOT NULL default '',
9  `parent_id` int(11) NOT NULL default '0',
10  `persontype` tinyint(4) NOT NULL default '1',
11  `sports_type_id` tinyint(4) NOT NULL default '1',
12  `published` tinyint(1) NOT NULL default '0',
13  `ordering` smallint(6) NOT NULL default '0',
14  `checked_out` int(11) NOT NULL default '0',
15  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
16  `modified` datetime default NULL,
17  `modified_by` int(11) default NULL,
18  PRIMARY KEY  (`id`),
19  UNIQUE KEY `name` (`name`,`parent_id`,`persontype`,`sports_type_id`),
20  KEY `parent_id` (`parent_id`),
21  KEY `sports_type_id` (`sports_type_id`)
22) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
23
24--
25-- Daten für Tabelle `jos_joomleague_position`
26--
27
28INSERT INTO `jos_joomleague_position` (`id`, `name`, `alias`, `parent_id`, `persontype`, `sports_type_id`, `published`, `ordering`, `checked_out`, `checked_out_time`, `modified`, `modified_by`) VALUES
29(1, 'JL_F_PLAYERS', 'jlfplayers', 0, 1, 1, 1, 1, 0, '0000-00-00 00:00:00', NULL, NULL),
30(2, 'JL_P_GOALKEEPER', 'jlpgoalkeeper', 1, 1, 1, 1, 2, 0, '0000-00-00 00:00:00', NULL, NULL),
31(3, 'JL_P_DEFENDER', 'jlpdefender', 1, 1, 1, 1, 3, 0, '0000-00-00 00:00:00', NULL, NULL),
32(4, 'JL_P_MIDFIELDER', 'jlpmidfielder', 1, 1, 1, 1, 4, 0, '0000-00-00 00:00:00', NULL, NULL),
33(5, 'JL_P_FORWARD', 'jlpforward', 1, 1, 1, 1, 5, 0, '0000-00-00 00:00:00', NULL, NULL),
34(6, 'JL_F_TEAM_STAFF', 'jlfteamstaff', 0, 2, 1, 1, 6, 0, '0000-00-00 00:00:00', NULL, NULL),
35(7, 'JL_F_COACHES', 'jlfcoaches', 0, 2, 1, 1, 7, 0, '0000-00-00 00:00:00', NULL, NULL),
36(8, 'JL_F_COACH', 'jlfcoach', 7, 2, 1, 1, 8, 0, '0000-00-00 00:00:00', NULL, NULL),
37(9, 'JL_F_HEAD_COACH', 'jlfheadcoach', 7, 2, 1, 1, 9, 0, '0000-00-00 00:00:00', NULL, NULL),
38(10, 'JL_F_MAINTAINER_TEAM', 'jlfmaintainerteam', 0, 2, 1, 1, 10, 0, '0000-00-00 00:00:00', NULL, NULL),
39(11, 'JL_F_MAINTAINER', 'jlfmaintainer', 10, 2, 1, 1, 11, 0, '0000-00-00 00:00:00', NULL, NULL),
40(12, 'JL_F_MEDICAL_STAFF', 'jlfmedicalstaff', 0, 2, 1, 1, 12, 0, '0000-00-00 00:00:00', NULL, NULL),
41(13, 'JL_F_REFEREES', 'jlfreferees', 0, 3, 1, 1, 13, 0, '0000-00-00 00:00:00', NULL, NULL),
42(14, 'JL_F_CENTER_REFEREE', 'jlfcenterreferee', 13, 3, 1, 1, 14, 0, '0000-00-00 00:00:00', NULL, NULL),
43(15, 'JL_F_LINESMAN', 'jlflinesman', 13, 3, 1, 1, 15, 0, '0000-00-00 00:00:00', NULL, NULL),
44(16, 'JL_F_FOURTH_OFFICIAL', 'jlffourthofficial', 13, 3, 1, 1, 16, 0, '0000-00-00 00:00:00', NULL, NULL),
45(17, 'JL_F_FIFTH_OFFICIAL', 'jlffifthofficial', 13, 3, 1, 1, 17, 0, '0000-00-00 00:00:00', NULL, NULL),
46(18, 'JL_F_CLUB_STAFF', 'jlfclubstaff', 0, 4, 1, 1, 18, 0, '0000-00-00 00:00:00', NULL, NULL),
47(19, 'JL_F_CLUB_MANAGER', 'jlfclubmanager', 18, 4, 1, 1, 19, 0, '0000-00-00 00:00:00', NULL, NULL),
48(20, 'JL_F_CLUB_YOUTH_MANAGER', 'jlfclubyouthmanager', 18, 4, 1, 1, 20, 0, '0000-00-00 00:00:00', NULL, NULL),