Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 34

Přidáno uživatelem Tomáš Dulík před více než 16 roky(ů)

Added documentation and SQL files

Zobrazit rozdíly:

freenetis/trunk/wwwroot/doc/SQL/demo_acl.sql
-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-6
-- http://www.phpmyadmin.net
--
-- Po??ta?: localhost
-- Vygenerov?no: Pond?l? 21. ledna 2008, 19:47
-- Verze MySQL: 5.0.32
-- Verze PHP: 5.2.0-8+etch7
--
-- Datab?ze: `freenetis`
--
--
-- Vypisuji data pro tabulku `acl`
--
INSERT INTO `acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES
(10, 'user', 1, 1, '', 'V?ichni lide na svete maji pravo se registrovat jako zajemci o clenstvi', 1180619687),
(11, 'user', 1, 1, '', 'Registrovan? z?jemci i ř?dn? členov? sdru?en? maj? pr?vo měnit kontaktn? ?daje v tabulce členů', 1180620482),
(12, 'user', 1, 1, '', 'Předseda a jednatel mohou v datab?zi měnit jak?koli ?daje. Nemohou ale měnit log činnost?, tak?e v?echno, co v datab?zi provedou, bude zaznamen?no v logu.', 1180621673),
(13, 'user', 1, 1, '', 'Pr?vo prohl?et log akc? ve Freenetisu maj? pouze Spr?vn? rada a Spr?vci syst?mu Freenetis', 1180621803);
--
-- Vypisuji data pro tabulku `acl_sections`
--
INSERT INTO `acl_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(1, 'system', 1, 'System', 0),
(2, 'user', 2, 'User', 0);
--
-- Vypisuji data pro tabulku `acl_seq`
--
INSERT INTO `acl_seq` (`id`) VALUES
(13);
--
-- Vypisuji data pro tabulku `aco`
--
INSERT INTO `aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'Syst?m freenetis', 'view', 1, 'Pr?va prohl?et', 0),
(11, 'Syst?m freenetis', 'create', 2, 'Pr?vo vytvaret nove zaznamy', 0),
(12, 'Syst?m freenetis', 'edit_any', 3, 'Pr?vo editovat jak?koli zaznamy', 0),
(13, 'Syst?m freenetis', 'delete', 4, 'Pr?vo mazat jak?koli zaznamy', 0),
(14, 'Syst?m freenetis', 'edit_own', 5, 'Pr?vo editovat svoje z?znamy', 0),
(15, 'Syst?m freenetis', 'delete_own', 6, 'Pr?vo mazat svoje z?znamy', 0);
--
-- Vypisuji data pro tabulku `aco_map`
--
INSERT INTO `aco_map` (`acl_id`, `section_value`, `value`) VALUES
(10, 'Syst?m freenetis', 'create'),
(11, 'Syst?m freenetis', 'edit_own'),
(12, 'Syst?m freenetis', 'create'),
(12, 'Syst?m freenetis', 'delete'),
(12, 'Syst?m freenetis', 'edit_any'),
(12, 'Syst?m freenetis', 'view'),
(13, 'Syst?m freenetis', 'view');
--
-- Vypisuji data pro tabulku `aco_sections`
--
INSERT INTO `aco_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'Syst?m freenetis', 1, 'Syst?m freenetis', 0);
--
-- Vypisuji data pro tabulku `aco_sections_seq`
--
INSERT INTO `aco_sections_seq` (`id`) VALUES
(10);
--
-- Vypisuji data pro tabulku `aco_seq`
--
INSERT INTO `aco_seq` (`id`) VALUES
(15);
--
-- Vypisuji data pro tabulku `aro`
--
INSERT INTO `aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'clenove', 'dulik', 1, 'Tomas Dulik', 0),
(11, 'clenove', 'sedlar', 2, 'Honza Sedlar', 0),
(12, 'clenove', 'sevcik', 3, 'Roman Sevcik', 0);
--
-- Vypisuji data pro tabulku `aro_groups`
--
INSERT INTO `aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES
(10, 0, 1, 22, 'V?ichni lid? na světě', 'vsichni_lide'),
(11, 10, 2, 3, 'Registrovan? z?jemci o členstv?', 'registrovani zajemci'),
(12, 10, 4, 21, 'Ř?dn? členov? sdru?en?', 'radni_clenove'),
(13, 12, 5, 10, 'Spr?vn? rada sdru?en?', 'spravni_rada'),
(14, 13, 6, 7, 'Předseda a jednatel', 'predseda_jednatel'),
(15, 13, 8, 9, 'Hospod?ř', 'hospodar'),
(16, 12, 11, 12, 'Revizn? komise', 'revizni_komise'),
(17, 12, 13, 20, 'Technici', 'technici'),
(18, 17, 14, 15, 'Certifikovani sitovi experti', 'certifikovani_experti'),
(19, 17, 16, 17, 'Spravci Freenetisu', 'spravci_freenetisu'),
(20, 17, 18, 19, 'Spravci AP', 'spravci_ap');
--
-- Vypisuji data pro tabulku `aro_groups_id_seq`
--
INSERT INTO `aro_groups_id_seq` (`id`) VALUES
(20);
--
-- Vypisuji data pro tabulku `aro_groups_map`
--
INSERT INTO `aro_groups_map` (`acl_id`, `group_id`) VALUES
(10, 10),
(11, 11),
(11, 12),
(12, 14),
(13, 13),
(13, 19);
--
-- Vypisuji data pro tabulku `aro_map`
--
--
-- Vypisuji data pro tabulku `aro_sections`
--
INSERT INTO `aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'clenove', 1, 'Ř?dn? členov? sdru?en?', 0),
(11, 'spravni_rada', 2, 'Spr?vn? rada', 0);
--
-- Vypisuji data pro tabulku `aro_sections_seq`
--
INSERT INTO `aro_sections_seq` (`id`) VALUES
(11);
--
-- Vypisuji data pro tabulku `aro_seq`
--
INSERT INTO `aro_seq` (`id`) VALUES
(12);
--
-- Vypisuji data pro tabulku `axo`
--
--
-- Vypisuji data pro tabulku `axo_groups`
--
INSERT INTO `axo_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES
(10, 0, 1, 14, 'V?echny č?sti syst?mu', 'vsechny_casti'),
(11, 10, 2, 11, 'Datab?ze', 'db'),
(12, 15, 4, 5, 'Registrace zajemcu o clenstvi', 'registrace_zajemcu'),
(13, 15, 6, 7, 'Kontaktni udaje o clenovi a jeho uzivatelich', 'kontakty_clena'),
(14, 10, 12, 13, 'Z?znamy v logu u?ivatelsk?ch aktivit v syst?mu', 'system_logs'),
(15, 11, 3, 8, 'Datab?ze u?ivatelů', 'db_user'),
(16, 11, 9, 10, 'Datab?ze č?st? s?tě', 'db_network');
--
-- Vypisuji data pro tabulku `axo_groups_id_seq`
--
INSERT INTO `axo_groups_id_seq` (`id`) VALUES
(16);
--
-- Vypisuji data pro tabulku `axo_groups_map`
--
INSERT INTO `axo_groups_map` (`acl_id`, `group_id`) VALUES
(10, 12),
(11, 13),
(12, 11),
(13, 14);
--
-- Vypisuji data pro tabulku `axo_map`
--
--
-- Vypisuji data pro tabulku `axo_sections`
--
freenetis/trunk/wwwroot/doc/SQL/spec_0_5.sql
-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-6
-- http://www.phpmyadmin.net
--
-- Po??ta?: localhost
-- Vygenerov?no: Pond?l? 21. ledna 2008, 19:39
-- Verze MySQL: 5.0.32
-- Verze PHP: 5.2.0-8+etch7
--
-- Datab?ze: `freenetis`
--
-- --------------------------------------------------------
--
-- Struktura tabulky `access_mod`
--
CREATE TABLE `access_mod` (
`ID` int(11) NOT NULL default '0',
`ID_device` int(11) default NULL,
`ID_user_admin` int(11) default NULL,
`timestamp_start` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`timestamp_end` timestamp NOT NULL default '0000-00-00 00:00:00',
`type` varchar(254) character set latin1 default NULL,
`reason` varchar(254) character set latin1 default NULL,
`comment` varchar(254) character set latin1 default NULL,
PRIMARY KEY (`ID`),
KEY `user_access_mod` (`ID_user_admin`),
KEY `device_access_mod` (`ID_device`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `account`
--
CREATE TABLE `account` (
`ID` int(11) NOT NULL auto_increment,
`ID_owner` int(11) default NULL,
`name` varchar(100) collate utf8_czech_ci default NULL,
`type` tinyint(4) default NULL,
`start_amount` double default NULL,
`comment` varchar(254) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
KEY `is_owned_by` (`ID_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `acl`
--
CREATE TABLE `acl` (
`id` int(11) NOT NULL default '0',
`section_value` varchar(230) character set latin1 NOT NULL default 'system',
`allow` int(11) NOT NULL default '0',
`enabled` int(11) NOT NULL default '0',
`return_value` text character set latin1,
`note` text character set latin1,
`updated_date` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `enabled_acl` (`enabled`),
KEY `section_value_acl` (`section_value`),
KEY `updated_date_acl` (`updated_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `acl_sections`
--
CREATE TABLE `acl_sections` (
`id` int(11) NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `value_acl_sections` (`value`),
KEY `hidden_acl_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `acl_seq`
--
CREATE TABLE `acl_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aco`
--
CREATE TABLE `aco` (
`id` int(11) NOT NULL default '0',
`section_value` varchar(240) character set latin1 NOT NULL default '0',
`value` varchar(240) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `section_value_value_aco` (`section_value`,`value`),
KEY `hidden_aco` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aco_map`
--
CREATE TABLE `aco_map` (
`acl_id` int(11) NOT NULL default '0',
`section_value` varchar(230) character set latin1 NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aco_sections`
--
CREATE TABLE `aco_sections` (
`id` int(11) NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `value_aco_sections` (`value`),
KEY `hidden_aco_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aco_sections_seq`
--
CREATE TABLE `aco_sections_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aco_seq`
--
CREATE TABLE `aco_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro`
--
CREATE TABLE `aro` (
`id` int(11) NOT NULL default '0',
`section_value` varchar(240) character set latin1 NOT NULL default '0',
`value` varchar(240) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_groups`
--
CREATE TABLE `aro_groups` (
`id` int(11) NOT NULL default '0',
`parent_id` int(11) NOT NULL default '0',
`lft` int(11) NOT NULL default '0',
`rgt` int(11) NOT NULL default '0',
`name` varchar(255) character set latin1 NOT NULL,
`value` varchar(255) character set latin1 NOT NULL,
PRIMARY KEY (`id`,`value`),
UNIQUE KEY `value_aro_groups` (`value`),
KEY `parent_id_aro_groups` (`parent_id`),
KEY `lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_groups_id_seq`
--
CREATE TABLE `aro_groups_id_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_groups_map`
--
CREATE TABLE `aro_groups_map` (
`acl_id` int(11) NOT NULL default '0',
`group_id` int(11) NOT NULL default '0',
PRIMARY KEY (`acl_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_map`
--
CREATE TABLE `aro_map` (
`acl_id` int(11) NOT NULL default '0',
`section_value` varchar(230) character set latin1 NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_sections`
--
CREATE TABLE `aro_sections` (
`id` int(11) NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_sections_seq`
--
CREATE TABLE `aro_sections_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `aro_seq`
--
CREATE TABLE `aro_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `axo`
--
CREATE TABLE `axo` (
`id` int(11) NOT NULL default '0',
`section_value` varchar(240) character set latin1 NOT NULL default '0',
`value` varchar(240) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `section_value_value_axo` (`section_value`,`value`),
KEY `hidden_axo` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `axo_groups`
--
CREATE TABLE `axo_groups` (
`id` int(11) NOT NULL default '0',
`parent_id` int(11) NOT NULL default '0',
`lft` int(11) NOT NULL default '0',
`rgt` int(11) NOT NULL default '0',
`name` varchar(255) character set latin1 NOT NULL,
`value` varchar(255) character set latin1 NOT NULL,
PRIMARY KEY (`id`,`value`),
UNIQUE KEY `value_axo_groups` (`value`),
KEY `parent_id_axo_groups` (`parent_id`),
KEY `lft_rgt_axo_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `axo_groups_id_seq`
--
CREATE TABLE `axo_groups_id_seq` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `axo_groups_map`
--
CREATE TABLE `axo_groups_map` (
`acl_id` int(11) NOT NULL default '0',
`group_id` int(11) NOT NULL default '0',
PRIMARY KEY (`acl_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `axo_map`
--
CREATE TABLE `axo_map` (
`acl_id` int(11) NOT NULL default '0',
`section_value` varchar(230) character set latin1 NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `axo_sections`
--
CREATE TABLE `axo_sections` (
`id` int(11) NOT NULL default '0',
`value` varchar(230) character set latin1 NOT NULL,
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) character set latin1 NOT NULL,
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `value_axo_sections` (`value`),
KEY `hidden_axo_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `contact`
--
CREATE TABLE `contact` (
`ID_user` int(11) default NULL,
`ID` int(11) NOT NULL auto_increment,
`type` varchar(40) collate utf8_czech_ci default NULL,
`value` varchar(255) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
KEY `user_contact` (`ID_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `device`
--
CREATE TABLE `device` (
`ID` int(11) NOT NULL auto_increment,
`ID_user` int(11) default NULL,
`name` varchar(254) collate utf8_czech_ci default NULL,
`type` varchar(254) collate utf8_czech_ci default NULL,
`PPPoE_logging_in` tinyint(4) default NULL,
`login` varchar(254) collate utf8_czech_ci default NULL,
`password` varchar(254) collate utf8_czech_ci default NULL,
`GPS` varchar(100) collate utf8_czech_ci default NULL,
`location_address` varchar(254) collate utf8_czech_ci default NULL,
`location_details` varchar(254) collate utf8_czech_ci default NULL,
`comment` varchar(254) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
KEY `ID_user` (`ID_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `groups_aro_map`
--
CREATE TABLE `groups_aro_map` (
`group_id` int(11) NOT NULL default '0',
`aro_id` int(11) NOT NULL default '0',
PRIMARY KEY (`group_id`,`aro_id`),
KEY `aro_id` (`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `groups_axo_map`
--
CREATE TABLE `groups_axo_map` (
`group_id` int(11) NOT NULL default '0',
`axo_id` int(11) NOT NULL default '0',
PRIMARY KEY (`group_id`,`axo_id`),
KEY `axo_id` (`axo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `iface`
--
CREATE TABLE `iface` (
`ID` int(11) NOT NULL auto_increment,
`ID_device` int(11) default NULL,
`ID_segment` int(11) default NULL,
`MAC` varchar(15) collate utf8_czech_ci default NULL,
`name` varchar(254) collate utf8_czech_ci default NULL,
`comment` varchar(254) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
KEY `device_iface` (`ID_device`),
KEY `segment_iface` (`ID_segment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `ip_address`
--
CREATE TABLE `ip_address` (
`ID_iface` int(11) default NULL,
`ID_VLAN_iface` int(11) default NULL,
`ID_subnet` int(11) default NULL,
`IP_address` int(11) default NULL,
`ID` int(11) NOT NULL auto_increment,
PRIMARY KEY (`ID`),
KEY `iface_address` (`ID_iface`),
KEY `VLAN_iface_address` (`ID_VLAN_iface`),
KEY `subnet_address` (`ID_subnet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `member`
--
CREATE TABLE `member` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(100) collate utf8_czech_ci NOT NULL,
`street_number` varchar(50) collate utf8_czech_ci default NULL,
`street` varchar(250) collate utf8_czech_ci default NULL,
`town` varchar(250) collate utf8_czech_ci default NULL,
`ZIP_code` varchar(10) collate utf8_czech_ci default NULL,
`type` tinyint(4) default NULL,
`login` varchar(40) collate utf8_czech_ci default NULL,
`password` varchar(40) collate utf8_czech_ci default NULL,
`qos_ceil` varchar(20) collate utf8_czech_ci default NULL,
`qos_rate` varchar(20) collate utf8_czech_ci default NULL,
`entrance_fee` double default NULL,
`debt_payment_rate` double default NULL,
`entrance_fee_left` double default NULL,
`must_pay_regular_fee` tinyint(4) default NULL,
`current_credit` float default NULL,
`entrance_date` date default NULL,
`comment` varchar(250) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=311852249 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `menu`
--
CREATE TABLE `menu` (
`id_traverz` int(11) NOT NULL auto_increment,
`traverz_name` varchar(100) collate utf8_czech_ci default NULL,
`traverz_parent` smallint(6) default NULL,
`traverz_left` smallint(6) default NULL,
`traverz_right` smallint(6) default NULL,
`msg` int(1) default NULL,
`msg_text` varchar(255) collate utf8_czech_ci default NULL,
PRIMARY KEY (`id_traverz`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=54 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `money_transfer`
--
CREATE TABLE `money_transfer` (
`ID` int(11) NOT NULL auto_increment,
`ID_origin` int(11) default NULL,
`ID_destination` int(11) default NULL,
`ID_bank_info` int(11) default NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`text` varchar(254) collate utf8_czech_ci default NULL,
`type` varchar(254) collate utf8_czech_ci default NULL,
`amount` double default NULL,
PRIMARY KEY (`ID`),
KEY `from` (`ID_origin`),
KEY `to` (`ID_destination`),
KEY `has_bank_info` (`ID_bank_info`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `money_transfer_bank_info`
--
CREATE TABLE `money_transfer_bank_info` (
`ID` int(11) NOT NULL auto_increment,
`variable_symbol` int(11) NOT NULL,
`constant_symbol` tinyint(4) NOT NULL,
`specific_symbol` bigint(20) NOT NULL,
`name` varchar(250) NOT NULL,
`ID_fee_transfer` int(11) default NULL,
`date_time` datetime NOT NULL,
PRIMARY KEY (`ID`),
KEY `fee_transfer` (`ID_fee_transfer`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `phpgacl`
--
CREATE TABLE `phpgacl` (
`name` varchar(230) collate utf8_czech_ci NOT NULL,
`value` varchar(230) collate utf8_czech_ci NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
-- --------------------------------------------------------
--
-- Struktura tabulky `port`
--
CREATE TABLE `port` (
`ID` int(11) NOT NULL auto_increment,
`ID_device` int(11) default NULL,
`ID_segment` int(11) default NULL,
`name` varchar(254) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
KEY `device_port` (`ID_device`),
KEY `segment_port` (`ID_segment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `port_belongs_to_vlan`
--
CREATE TABLE `port_belongs_to_vlan` (
`ID_port` int(11) default NULL,
`ID_VLAN` int(11) default NULL,
`ID` int(11) NOT NULL auto_increment,
PRIMARY KEY (`ID`),
KEY `VLAN_on_port` (`ID_VLAN`),
KEY `port_belongs` (`ID_port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `segment`
--
CREATE TABLE `segment` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(254) collate utf8_czech_ci default NULL,
`technology` varchar(254) collate utf8_czech_ci default NULL,
`bitrate` int(11) default NULL,
`duplex` tinyint(4) default NULL,
`comment` varchar(254) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `subnet`
--
CREATE TABLE `subnet` (
`ID` int(11) NOT NULL auto_increment,
`ID_OSPF_area` int(11) default NULL,
`name` varchar(254) collate utf8_czech_ci default NULL,
`network_address` int(11) default NULL,
`netmask` int(11) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `user`
--
CREATE TABLE `user` (
`ID_member` int(11) default NULL,
`ID` int(11) NOT NULL auto_increment,
`name` varchar(30) collate utf8_czech_ci default NULL,
`middle_name` varchar(30) collate utf8_czech_ci default NULL,
`surname` varchar(60) collate utf8_czech_ci default NULL,
`pre_title` varchar(40) collate utf8_czech_ci default NULL,
`post_title` varchar(30) collate utf8_czech_ci default NULL,
`birthday` date default NULL,
`phone` varchar(40) collate utf8_czech_ci default NULL,
`email` varchar(60) collate utf8_czech_ci default NULL,
`login` varchar(50) collate utf8_czech_ci default NULL,
`password` varchar(50) collate utf8_czech_ci default NULL,
`web_messages_types` int(11) default NULL,
`email_messages_types` int(11) default NULL,
`comment` varchar(250) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`),
KEY `member_user` (`ID_member`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `vlan`
--
CREATE TABLE `vlan` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(254) collate utf8_czech_ci default NULL,
`tag_802_1q` int(11) default NULL,
`comment` varchar(254) collate utf8_czech_ci default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `vlan_iface`
--
CREATE TABLE `vlan_iface` (
`ID` int(11) NOT NULL auto_increment,
`ID_VLAN` int(11) default NULL,
`ID_iface` int(11) default NULL,
PRIMARY KEY (`ID`),
KEY `VLAN_on_iface` (`ID_VLAN`),
KEY `iface_belongs_to_VLAN` (`ID_iface`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabulky `work`
--
CREATE TABLE `work` (
`ID` int(11) NOT NULL auto_increment,
`ID_user` int(11) default NULL,
`description` varchar(255) collate utf8_czech_ci default NULL,
`hours` float default NULL,
`ID_confirmed_by` int(11) default NULL,
`ID_transfer` int(11) default NULL,
PRIMARY KEY (`ID`),
KEY `transfer_salary` (`ID_transfer`),
KEY `commited_by` (`ID_user`),
KEY `confirmed_by` (`ID_confirmed_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
--
-- Omezen? pro exportovan? tabulky
--
--
-- Omezen? pro tabulku `access_mod`
--
ALTER TABLE `access_mod`
ADD CONSTRAINT `device_access_mod` FOREIGN KEY (`ID_device`) REFERENCES `device` (`ID`),
ADD CONSTRAINT `user_access_mod` FOREIGN KEY (`ID_user_admin`) REFERENCES `user` (`ID`);
--
-- Omezen? pro tabulku `account`
--
ALTER TABLE `account`
ADD CONSTRAINT `is_owned_by` FOREIGN KEY (`ID_owner`) REFERENCES `member` (`ID`);
--
-- Omezen? pro tabulku `contact`
--
ALTER TABLE `contact`
ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`ID_user`) REFERENCES `user` (`ID`) ON DELETE CASCADE;
--
-- Omezen? pro tabulku `device`
--
ALTER TABLE `device`
ADD CONSTRAINT `user_device` FOREIGN KEY (`ID_user`) REFERENCES `user` (`ID`);
--
-- Omezen? pro tabulku `iface`
--
ALTER TABLE `iface`
ADD CONSTRAINT `device_iface` FOREIGN KEY (`ID_device`) REFERENCES `device` (`ID`),
ADD CONSTRAINT `segment_iface` FOREIGN KEY (`ID_segment`) REFERENCES `segment` (`ID`);
--
-- Omezen? pro tabulku `ip_address`
--
ALTER TABLE `ip_address`
ADD CONSTRAINT `iface_address` FOREIGN KEY (`ID_iface`) REFERENCES `iface` (`ID`),
ADD CONSTRAINT `subnet_address` FOREIGN KEY (`ID_subnet`) REFERENCES `subnet` (`ID`),
ADD CONSTRAINT `VLAN_iface_address` FOREIGN KEY (`ID_VLAN_iface`) REFERENCES `vlan_iface` (`ID`);
--
-- Omezen? pro tabulku `money_transfer`
--
ALTER TABLE `money_transfer`
ADD CONSTRAINT `from` FOREIGN KEY (`ID_origin`) REFERENCES `account` (`ID`),
ADD CONSTRAINT `has_bank_info` FOREIGN KEY (`ID_bank_info`) REFERENCES `money_transfer_bank_info` (`ID`),
ADD CONSTRAINT `to` FOREIGN KEY (`ID_destination`) REFERENCES `account` (`ID`);
--
-- Omezen? pro tabulku `money_transfer_bank_info`
--
ALTER TABLE `money_transfer_bank_info`
ADD CONSTRAINT `fee_transfer` FOREIGN KEY (`ID_fee_transfer`) REFERENCES `money_transfer` (`ID`);
--
-- Omezen? pro tabulku `port`
--
ALTER TABLE `port`
ADD CONSTRAINT `device_port` FOREIGN KEY (`ID_device`) REFERENCES `port` (`ID`),
ADD CONSTRAINT `segment_port` FOREIGN KEY (`ID_segment`) REFERENCES `segment` (`ID`);
--
-- Omezen? pro tabulku `port_belongs_to_vlan`
--
ALTER TABLE `port_belongs_to_vlan`
ADD CONSTRAINT `port_belongs` FOREIGN KEY (`ID_port`) REFERENCES `port` (`ID`),
ADD CONSTRAINT `VLAN_on_port` FOREIGN KEY (`ID_VLAN`) REFERENCES `vlan` (`ID`);
--
-- Omezen? pro tabulku `user`
--
ALTER TABLE `user`
ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`ID_member`) REFERENCES `member` (`ID`) ON DELETE CASCADE;
--
-- Omezen? pro tabulku `vlan_iface`
--
ALTER TABLE `vlan_iface`
ADD CONSTRAINT `iface_belongs_to_VLAN` FOREIGN KEY (`ID_iface`) REFERENCES `iface` (`ID`),
ADD CONSTRAINT `VLAN_on_iface` FOREIGN KEY (`ID_VLAN`) REFERENCES `vlan` (`ID`);
--
-- Omezen? pro tabulku `work`
--
ALTER TABLE `work`
ADD CONSTRAINT `commited_by` FOREIGN KEY (`ID_user`) REFERENCES `user` (`ID`),
ADD CONSTRAINT `confirmed_by` FOREIGN KEY (`ID_confirmed_by`) REFERENCES `user` (`ID`),
ADD CONSTRAINT `transfer_salary` FOREIGN KEY (`ID_transfer`) REFERENCES `money_transfer` (`ID`);
freenetis/trunk/wwwroot/doc/OpenSystemArchitect/FreeNetIS.SAWorkspace
<SAWorkspace Name="" Version="2.2" >
<Child Class="SAProject" Location="FreeNetIS.SAProject" />
</SAWorkspace>
freenetis/trunk/wwwroot/doc/OpenSystemArchitect/FreeNetIs.MYModel
<MYModel Align="68" DisplayFlags="5" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" DatabaseType="MySQL" BackgroundColor="#ffffff" FontBold="0" BackgroundImagePlacement="0" FontItalic="0" ModificationDate="2007-04-30T09:00:07" Author="Tomas Dulik" TextFlag="2048" CreationDate="2007-04-30T08:43:51" BackgroundType="0" FontStrikeOut="0" Name="FreeNetIS Database" BackgroundStyle="none" Version="2.2" ViewParse="1" NextOID="158" FontFamily="MS Shell Dlg" ><![CDATA[FreeNetIS database structure ER diagram]]><MYTable DescriptionSize="4096" width="131" Description="789ced913b4e0331108613d2202a8e30da0291220f1a8492cd561154498a700026bbb36b0b3f36b643b2b911f7e140d8bb12520a3a241a7f951fbffff9c7933227459632c2224b253904859216c9def09c393ab90472ad1c29b7481e129864e9a4d3ee74d180758df0e2d22b46969f69f654bb79bb2b5172d1cc565bd832120296a24ab29bb4ce525ba3ba7878245e31377b9c4e936c493637bc765cab593a09525fb06e1fbe32821d5a9ec3c192019f88bb660ce1d8105aada0d406eef607ede62bda91e996c02d38860e10d62f1b3007a5b8aafc11c1b3215a93e37624516145052872476dde21f711197e1028ad46356b6cce518c6a32a18c24e9dd2ddc2fb47731a04d858a9f3184b643405504774b9717ad2757b9381404be5ed3b6e15d823dcf5140676f8763d8b4be7442590b6f53fec408bacb18a1bdae5184eecfbbddb8fbb6491853985998722f1289442291482412f963e4e0addfbbed0d4efdac77fdf579f5df792291c8ef7c03f32ab170" x="365" TextField="2" Align="68" y="289" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="1" ScriptCreateSQLDrop="0" height="314" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="MEMBERS" Name="Members" NextOID="25" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[The basic entity. The reason for distinguishing between Users and Members is that a NGO running the FreeNetis-managed network can have non-physcial-person members (=other organizations) and these organizations can include many users (physical persons). Other example of non-physical-person member is "a family".]]><sink x="0.916667" y="0.1" OID="20" />
<sink x="0.21374" y="0.0127389" OID="23" />
<sink x="0.938931" y="0.0828025" OID="24" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="50" DataType="VARCHAR" OID="2" Code="STREET_NUMBER" Name="street_number" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="250" DataType="VARCHAR" OID="3" Code="STREET" Name="street" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="250" DataType="VARCHAR" OID="4" Code="TOWN" Name="town" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="10" DataType="VARCHAR" OID="5" Code="ZIP_CODE" Name="ZIP_code" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="6" Code="TYPE" Name="type" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="7" Code="LOGIN" Name="login" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="8" Code="PASSWORD" Name="password" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="20" DataType="VARCHAR" OID="10" Code="QOS_CEIL" Name="qos_ceil" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="20" DataType="VARCHAR" OID="16" Code="QOS_RATE" Name="qos_rate" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="11" Code="ENTRANCE_FEE" Name="entrance_fee" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="15" Code="DEBT_PAYMENT_RATE" Name="debt_payment_rate" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="17" Code="ENTRANCE_FEE_LEFT" Name="entrance_fee_left" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="13" Code="MUST_PAY_REGULAR_FEE" Name="must_pay_regular_fee" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="FLOAT" OID="14" Code="CURRENT_CREDIT" Name="current_credit" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DATE" OID="18" Code="ENTRANCE_DATE" Name="entrance_date" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="65535" DataType="VARCHAR" OID="21" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="130" x="173" TextField="2" Align="68" y="295" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="20" ScriptCreateSQLDrop="0" height="329" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="USERS" Name="Users" NextOID="24" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[The table "Users" holds **compulsory** contact information about individual users (each member can have several users).
An additional contact info can be stored in the table "Contacts"]]><sink x="0.915385" y="0.109422" OID="23" />
<sink x="0.823077" y="0.957447" OID="22" />
<sink x="0.0650888" y="0.0931174" OID="1" />
<sink x="0.829457" y="0.141304" OID="18" />
<sink x="0.899225" y="0.0108696" OID="20" />
<sink x="0.0852713" y="0.15942" OID="21" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="17" Code="ID_MEMBER" Name="ID_member" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="30" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="30" DataType="VARCHAR" OID="4" Code="MIDDLE_NAME" Name="middle_name" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="60" DataType="VARCHAR" OID="5" Code="SURNAME" Name="surname" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="6" Code="PRE_TITLE" Name="pre_title" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="30" DataType="VARCHAR" OID="7" Code="POST_TITLE" Name="post_title" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DATE" OID="8" Code="BIRTHDAY" Name="birthday" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="9" Code="PHONE" Name="phone" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="60" DataType="VARCHAR" OID="10" Code="EMAIL" Name="email" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="50" DataType="VARCHAR" OID="11" Code="LOGIN" Name="login" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="50" DataType="VARCHAR" OID="12" Code="PASSWORD" Name="password" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="15" Code="WEB_MESSAGES_TYPES" Name="web_messages_types" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="16" Code="EMAIL_MESSAGES_TYPES" Name="email_messages_types" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="65535" DataType="VARCHAR" OID="13" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="61" x="51" TextField="2" Align="68" y="292" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="36" ScriptCreateSQLDrop="0" height="88" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="CONTACTS" Name="Contacts" NextOID="7" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Additional contact fields for a given user.
Rules of thumb:
-Compulsory contact fields should be directly in the "User" table.
-Additional contact fields go into this "Contacts" table]]><sink x="0.163934" y="0.375" OID="6" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_USER" Name="ID_user" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="5" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="2" Code="TYPE" Name="type" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="255" DataType="VARCHAR" OID="3" Code="VALUE" Name="value" />
</MYTable>
<MYTable width="99" x="44" TextField="2" Align="68" y="668" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="46" ScriptCreateSQLDrop="0" height="206" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="DEVICES" Name="Devices" NextOID="18" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Table "Devices" represents devices conected to the network. Device can be a PC, router, switch, AP, client wifi box, VOIP phone, IPTV set-top-box - simply anything with active ethernet plug.]]><sink x="0.89899" y="0.160194" OID="17" />
<sink x="0.172897" y="0.545455" OID="2" />
<sink x="0.555556" y="0.896552" OID="7" />
<sink x="0.35" y="0.0574713" OID="13" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="8" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="ID_USER" Name="ID_user" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="4" Code="TYPE" Name="type" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="6" Code="PPPOE_LOGGING_IN" Name="PPPoE_logging_in" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="9" Code="LOGIN" Name="login" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="10" Code="PASSWORD" Name="password" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="100" DataType="VARCHAR" OID="14" Code="GPS" Name="GPS" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="15" Code="LOCATION_ADDRESS" Name="location_address" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="16" Code="LOCATION_DETAILS" Name="location_details" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="11" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="74" x="227" TextField="2" Align="68" y="671" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="52" ScriptCreateSQLDrop="0" height="121" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="INTERFACES" Name="Interfaces" NextOID="16" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Interface is any network interface which has its own MAC adres.
Interface is typically a network interface card in a PC or in a router.
Note: ports in switches should not be in this table! They should be in table "Ports".
An exception is managable switch - which has MAC and IP address.
Therefore, managable switches should have the port, which is connected to the segment with the switch's IP subnet, stored in the "Interfaces" table.]]><sink x="0.0540541" y="0.330579" OID="15" />
<sink x="0.842105" y="0.585366" OID="11" />
<sink x="0.477064" y="0.859756" OID="10" />
<sink x="0.864865" y="0.206612" OID="14" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="4" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="ID_DEVICE" Name="ID_device" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="8" Code="ID_SEGMENT" Name="ID_segment" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="15" DataType="VARCHAR" OID="2" Code="MAC" Name="MAC" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="9" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="12" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="73" x="406" TextField="2" Align="68" y="679" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="57" ScriptCreateSQLDrop="0" height="103" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="IP_ADDRESS" Name="IP_address" NextOID="12" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[One network interface can have multiple IP addresses. These IP addresses are recorded in this table]]><sink x="0.479452" y="0.893204" OID="8" />
<sink x="0.830508" y="0.266234" OID="7" />
<sink x="0.219178" y="0.242718" OID="10" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_INTERFACE" Name="ID_interface" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="9" Code="ID_VLAN_INTERFACE" Name="ID_VLAN_Interface" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="ID_SUBNET" Name="ID_subnet" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="IP_ADDRESS" Name="IP_address" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="11" Name="ID" />
</MYTable>
<MYTable width="69" x="233" TextField="2" Align="68" y="848" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="61" ScriptCreateSQLDrop="0" height="121" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="SEGMENTS" Name="Segments" NextOID="11" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Any (sub)network can be composed of many segments, which are interconnected by network bridges or switches. The segments are stored in this table]]><sink x="0.0833333" y="0.213836" OID="9" />
<sink x="0.407407" y="0.157233" OID="8" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="2" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="TECHNOLOGY" Name="technology" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="BITRATE" Name="bitrate" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="5" Code="DUPLEX" Name="duplex" />
<MYColumn ScriptCreateSQLCreateManual="0" OID="10" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="90" x="549" TextField="2" Align="68" y="683" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="68" ScriptCreateSQLDrop="0" height="108" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="SUBNETS" Name="Subnets" NextOID="8" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Every IP address belongs to a subnet. Subnets are described by this table.]]><sink x="0.0582524" y="0.182482" OID="6" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="7" Code="ID_OSPF_AREA" Name="ID_OSPF_area" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="NETWORK_ADDRESS" Name="network_address" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="NETMASK" Name="netmask" />
</MYTable>
<MYTable width="72" x="66" TextField="2" Align="68" y="961" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="75" ScriptCreateSQLDrop="0" height="94" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PORTS" Name="Ports" NextOID="9" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Port is any active network socket on a Device.
Port is typically a port on a switch.
Port has no MAC address - only a network interface (see table "Interface") has a MAC.
An exception is managable switch - which has a MAC and an IP address.
Therefore, managable switches should have the port, which is connected to the segment with the switch's IP subnet, stored in the "Interfaces" table.]]><sink x="0.486111" y="0.489362" OID="8" />
<sink x="0.462963" y="0.111111" OID="1" />
<sink x="0.722222" y="0.409722" OID="5" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="2" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_DEVICE" Name="ID_device" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="6" Code="ID_SEGMENT" Name="ID_segment" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="4" Code="NAME" Name="name" />
</MYTable>
<MYTable width="70" x="398" TextField="2" Align="68" y="993" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="87" ScriptCreateSQLDrop="0" height="92" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="VLANS" Name="VLANs" NextOID="9" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[VLAN is a virtual network working upon physical network segments.
VLAN is implemented in switches or routers and is present on their ports/interfaces.
On a switch or router, one VLAN can be assigned to several ports, and one port can have several VLANs.
On a router, a VLAN interface, created on one of its physical network interfaces, can have several IP addressess assigned to it.]]><sink x="0.485714" y="0.48913" OID="8" />
<sink x="0.506173" y="0.023622" OID="6" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="2" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="802_1Q_TAG" Name="802_1q_tag" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="5" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="109" x="393" TextField="2" Align="68" y="851" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="89" ScriptCreateSQLDrop="0" height="76" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACES" Name="VLAN_Interfaces" NextOID="7" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Several VLAN Interfaces can be created upon normal network Interface. Every VLAN Interface then belongs to just one VLAN (but there can be many VLAN interfaces with the same VLAN ID!).
From a router's internal point of view, a VLAN interface is the same thing as a normal network interface - it can have several IP addresses assigned (but it shares the MAC address of its physical network interface).]]><sink x="0.440367" y="0.0394737" OID="6" />
<sink x="0.293578" y="0.0263158" OID="1" />
<sink x="0.376147" y="0.921053" OID="2" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="3" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_VLAN" Name="ID_VLAN" />
<MYColumn ScriptCreateSQLCreateManual="0" OID="5" Code="ID_INTERFACE" Name="ID_Interface" />
</MYTable>
<MYTable width="110" x="611" TextField="2" Align="68" y="454" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="108" ScriptCreateSQLDrop="0" height="213" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PAYMENTS" Name="Payments" NextOID="17" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This is the table where all payments from the bank account listings are stored.]]><sink x="0.434343" y="0.0646766" OID="15" />
<sink x="0.171717" y="0.925373" OID="14" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />
<MYColumn Precision1="14" ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="4" Code="TIMESTAMP" Name="timestamp" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="5" Code="TEXT" Name="text" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="6" Code="NAME" Name="name" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="TYPE" Name="type" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="BIGINT" OID="8" Code="VARIABLE_SYMBOL" Name="variable_symbol" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="9" Code="CONSTANT_SYMBOL" Name="constant_symbol" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="10" Code="SPECIFIC_SYMBOL" Name="specific_symbol" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="11" Code="AMOUNT" Name="amount" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="12" Code="FEE" Name="fee" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="ID_PAYER" Name="ID_payer" />
<MYColumn ScriptCreateSQLCreateManual="0" OID="16" Code="UNASSIGNED_AMOUNT" Name="unassigned_amount" />
</MYTable>
<MYTable width="100" x="341" TextField="2" Align="68" y="76" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="122" ScriptCreateSQLDrop="0" height="139" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="CREDIT_MODS" Name="Credit_mods" NextOID="10" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[The current credit of each member can be modified by the management of the organization for different reasons, e.g.:
- the member can receive credit bonuses for his work for the organization
- the credit can be lowered by giving the member a penalty for an accident or purposeful act whose aftermath costs the organization some money, e.g. in the case when member damages some network equipment or tool owned by the organization]]><sink x="0.512397" y="0.870504" OID="1" />
<sink x="0.15" y="0.942446" OID="9" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="2" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_MEMBER" Name="ID_member" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_USER_ADMIN" Name="ID_user_admin" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="5" Code="AMOUNT" Name="amount" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="6" Code="TIMESTAMP" Name="timestamp" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="REASON" Name="reason" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="8" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="89" x="26" TextField="2" Align="68" y="400" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="131" ScriptCreateSQLDrop="0" height="150" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="ACCESS_MODS" Name="Access_mods" NextOID="11" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This is table records the modifications of the members' access to the network.]]><sink x="0.820225" y="0.133333" OID="10" />
<sink x="0.595506" y="0.886667" OID="9" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="1" Code="ID" Name="ID" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="ID_DEVICE" Name="ID_device" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_USER_ADMIN" Name="ID_user_admin" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="4" Code="TIMESTAMP_START" Name="timestamp_start" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="5" Code="TIMESTAMP_END" Name="timestamp_end" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="6" Code="TYPE" Name="type" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="REASON" Name="reason" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="8" Code="COMMENT" Name="comment" />
</MYTable>
<MYTable width="137" x="583" TextField="2" Align="68" y="283" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="147" ScriptCreateSQLDrop="0" height="123" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PAYMENTS_ASSIGNMENTS" Name="Payments_Assignments" NextOID="9" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Auxiliary table implementing the M:N relations "Payment assigned to multiple users".
This M:N relationship is necessary for being able to capture cases, when a member makes single bank transfer to pay for several other Members.]]><sink x="0.520408" y="0.858407" OID="2" />
<sink x="0.102041" y="0.283186" OID="1" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_MEMBER" Name="ID_Member" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_PAYMENT" Name="ID_Payment" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="5" Code="AMOUNT" Name="amount" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="20" DataType="VARCHAR" OID="6" Code="TYPE" Name="type" />
<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="COMMENT" Name="comment" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="8" Name="ID" />
</MYTable>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="31" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Users" FontItalic="0" Parent="Members" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBER_HAS_USERS" Name="Member_has_Users" BeginTruncate="1" BeginArrowFlags="1" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship describes the following facts:
Member can be a physical person, but usually Member is a legal entity, like another NGO or a family.
Therefore, member can have several users - physical persons, who are eligible to use the NGO resources.
Side note: We could have made the things more complicated by considering users, who belong to more than one member. In such a case, this would lead to M:N relation, that would have to be implemented by table "Users_Members". In such a case, the "Contacts", "Device" and other tables, that are related to User belonging to certain Member, would be related to "Users_Members" table (not just Users like currently).]]><point x="181" y="326" OID="1" SinkObjectOID="20" SinkOID="1" />
<point x="485" y="320" OID="2" SinkObjectOID="1" SinkOID="20" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="42" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Contacts" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_HAS_CONTACTS" Name="User_has_Contacts" BeginTruncate="1" BeginArrowFlags="0" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Relationship for assigning several contacts to one user.]]><point x="61" y="325" OID="1" SinkObjectOID="36" SinkOID="6" />
<point x="292" y="331" OID="2" SinkObjectOID="20" SinkOID="23" />
<TextHandle x="0.438356" y="2.14943" OID="3" />
</MYReference>
<MYReference DescriptionSize="4096" Description="789ced90bd4ec330148523c1c4c4235c654020b58dd8509a66626d19fa04ae73135bf827b59db6e99333729d8801891d55f2b75ddfe3e3735c89a0555d09644d5d690c0c0cd3b8c98f4e7211f01272e0d604346193bfe650d455316b0fb619c1875191b825c5d2cb2b966f7d584f53cbb45463b9ddc35ea052f0aebabc7ea8fa7a6703426b1d0421cda7345d09d6203478921c8133430bb40e83e44ca911043b21683aa0735a46ede0d12de02c28219ceda01a88d2c9745beec0a162415ae385ec17701802f0c1396a406e67048f08c6928a796ba64b9ac51c53a0cecf6f71ab7b85975555f494ba886563f3f85799467d40e7e1796329aa03eb3a66e4757ef305986962058fbf17533569b81a1aeac3cc38d520975e8c3e76859ec6e8b0828fc9172f2c8600db525eb3fcd12d671dcc31407a783a0e36ac19cc7f3e4f7f264f241289c4ed73ff95658fd9dd7fc7482412894422717b7c03fd48b015" TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="51" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Devices" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_IS_OWNED_BY_USER" Name="Device_is_owned_by_User" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Relationship for assigning one or more devices to one user]]><point x="61" y="780" OID="1" SinkObjectOID="46" SinkOID="2" />
<point x="281" y="342" OID="2" SinkObjectOID="20" SinkOID="18" />
<TextHandle x="0.359307" y="0.548098" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="54" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Interfaces" FontItalic="0" Parent="Devices" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_HAS_INTERFACE" Name="Device_has_interface" BeginTruncate="1" BeginArrowFlags="0" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns interfaces to a device]]><point x="231" y="711" OID="1" SinkObjectOID="52" SinkOID="15" />
<point x="133" y="701" OID="2" SinkObjectOID="46" SinkOID="17" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="58" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="IP_address" FontItalic="0" Parent="Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="INTERFACE_HAS_IP_ADDRESS" Name="Interface_has_IP_address" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to an interface.
Note:
To get a list of all IP addresses assigned to a interface, you must look also to the relationship "VLAN_interface_has_IP_addresses" !]]><point x="422" y="704" OID="1" SinkObjectOID="57" SinkOID="10" />
<point x="291" y="696" OID="2" SinkObjectOID="52" SinkOID="14" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="73" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="IP_address" FontItalic="0" Parent="Subnets" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="IP_ADDRESS_BELONGS_TO_SUBNET" Name="IP_address_belongs_to_Subnet" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to a subnet]]><point x="466" y="706" OID="1" SinkObjectOID="57" SinkOID="7" />
<point x="554" y="703" OID="2" SinkObjectOID="68" SinkOID="6" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="78" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Interfaces" FontItalic="0" Parent="Segments" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="INTERFACE_IS_CONNECTED_TO_SEGMENT" Name="Interface_is_connected_to_Segment" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns Interfaces to a segment]]><point x="262" y="776" OID="1" SinkObjectOID="52" SinkOID="10" />
<point x="261" y="868" OID="2" SinkObjectOID="61" SinkOID="8" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="82" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports" FontItalic="0" Parent="Devices" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_HAS_PORTS" Name="Device_has_Ports" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns ports to a device (switch)]]><point x="99" y="971" OID="1" SinkObjectOID="75" SinkOID="1" />
<point x="99" y="852" OID="2" SinkObjectOID="46" SinkOID="7" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="84" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports" FontItalic="0" Parent="Segments" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="PORTS_CONNECTED_TO_A_SEGMENT" Name="Ports_connected_to_a_Segment" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns ports on a switch to a network segment]]><point x="117" y="1000" OID="1" SinkObjectOID="75" SinkOID="5" />
<point x="238" y="874" OID="2" SinkObjectOID="61" SinkOID="9" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="97" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="VLANs" FontItalic="0" Parent="VLAN_Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACE_BELONG_TO_A_VLAN" Name="VLAN_Interface_belong_to_a_VLAN" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns VLAN interfaces to a VLAN.]]><point x="433" y="996" OID="1" SinkObjectOID="87" SinkOID="6" />
<point x="434" y="921" OID="2" SinkObjectOID="89" SinkOID="2" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="98" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Interfaces" FontItalic="0" Parent="VLAN_Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACE_IS_CREATED_ON_INTERFACE" Name="VLAN_Interface_is_created_on_Interface" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns VLAN interfaces to a physical network interface]]><point x="290" y="741" OID="1" SinkObjectOID="52" SinkOID="11" />
<point x="425" y="853" OID="2" SinkObjectOID="89" SinkOID="1" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="99" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="IP_address" FontItalic="0" Parent="VLAN_Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACE_HAS_IP_ADDRESSES" Name="VLAN_interface_has_IP_addresses" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to a VLAN interface.
Note:
To get a list of all IP addresses assigned to a interface, you must look also to the relationship "Interface_has_IP_addresses" !]]><point x="441" y="771" OID="1" SinkObjectOID="57" SinkOID="8" />
<point x="441" y="854" OID="2" SinkObjectOID="89" SinkOID="6" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="102" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports_belong_to_VLANs" FontItalic="0" Parent="VLANs" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="PORTS_BELONG_TO_VLANS" Name="Ports_belong_to_VLANs" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship (M:N) assigns
- one VLAN to several ports on a switch
- one port to several VLANs.]]><point x="262" y="1041" OID="1" SinkObjectOID="156" SinkOID="1" />
<point x="432" y="1038" OID="2" SinkObjectOID="87" SinkOID="8" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="111" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Payments" FontItalic="0" Parent="Payments_Assignments" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBER_HAS_PAYMENTS" Name="Member_has_Payments" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the Payments assigned to a Member.
There are cases when one Member pays for several Members by single bank transfer.]]><point x="658" y="467" OID="1" SinkObjectOID="108" SinkOID="15" />
<point x="654" y="389" OID="2" SinkObjectOID="147" SinkOID="2" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="130" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Credit_mods" FontItalic="0" Parent="Members" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBERS_CREDIT_HAS_MODIFICATIONS" Name="Members_credit_has_Modifications" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the Credit Modifications made in the Member's account.
Of course, one Modification can be made to only one Member.]]><point x="392" y="197" OID="1" SinkObjectOID="122" SinkOID="1" />
<point x="393" y="293" OID="2" SinkObjectOID="1" SinkOID="23" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="141" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Credit_mods" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_ADMIN_MADE_CREDIT_MODIFICATIONS" Name="User_Admin_made_Credit_modifications" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the Credit Modifications made by an Administrator.
One Modification can be made by only one Administrator. If another Administrator modifies the same user's credit subsequently, a new record in the Credit Modification table is created.]]><point x="356" y="207" OID="1" SinkObjectOID="122" SinkOID="9" />
<point x="289" y="298" OID="2" SinkObjectOID="20" SinkOID="20" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="142" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Access_mods" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_ADMIN_MADE_ACCESS_MODIFICATIONS" Name="User_Admin_made_Access_modifications" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings access modifications to a user (administrator)]]><point x="99" y="420" OID="1" SinkObjectOID="131" SinkOID="10" />
<point x="184" y="348" OID="2" SinkObjectOID="20" SinkOID="21" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="143" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Access_mods" FontItalic="0" Parent="Devices" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_HAS_ACCESS_MODIFICATION" Name="Device_has_Access_modification" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns access modifications to a device]]><point x="79" y="533" OID="1" SinkObjectOID="131" SinkOID="9" />
<point x="78" y="680" OID="2" SinkObjectOID="46" SinkOID="13" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="151" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Payments_Assignments" FontItalic="0" Parent="Members" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBER_HAS_ASSIGNED_PAYMENTS" Name="Member_has_Assigned_Payments" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings assigned payments to a member]]><point x="596" y="317" OID="1" SinkObjectOID="147" SinkOID="1" />
<point x="488" y="315" OID="2" SinkObjectOID="1" SinkOID="24" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="154" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Payments" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_MADE_PAYMENT" Name="User_made_Payment" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relation assigns a Payment to a User, who made the bank transfer.
Warning: the payment must be assigned to a Member in order to increase his credit!
This relation is reallly just a hint information, we could live without it.]]><point x="629" y="651" OID="1" SinkObjectOID="108" SinkOID="14" />
<point x="280" y="610" OID="2" SinkObjectOID="20" SinkOID="22" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<MYTable width="142" x="194" TextField="2" Align="68" y="997" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="156" ScriptCreateSQLDrop="0" height="90" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PORTS_BELONG_TO_VLANS" Name="Ports_belong_to_VLANs" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" >
<sink x="0.48" y="0.48" OID="1" />
<sink x="0.48" y="0.48" OID="2" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Name="ID_ports" />
<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Name="ID_VLANs" />
<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="5" Name="ID" />
</MYTable>
<MYReference TextField="3" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="2" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="157" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports_belong_to_VLANs" FontItalic="0" Parent="Ports" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" BeginTruncate="1" BeginArrowFlags="0" NextOID="4" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" >
<point x="262" y="1041" OID="1" SinkObjectOID="156" SinkOID="2" />
<point x="101" y="1007" OID="2" SinkObjectOID="75" SinkOID="8" />
<TextHandle x="0.45" y="0.5" OID="3" />
</MYReference>
<Validation>
<Rule Name="Model name missing" Value="Error" />
<Rule Name="Model comment missing" Value="Warning" />
<Rule Name="Model description missing" Value="Information" />
<Rule Name="Model database type missing" Value="Error" />
<Rule Name="Model database name missing" Value="Warning" />
<Rule Name="Model target missing" Value="Warning" />
<Rule Name="Model author missing" Value="Warning" />
<Rule Name="Reference name missing" Value="Warning" />
<Rule Name="Reference code missing" Value="Warning" />
<Rule Name="Reference comment missing" Value="Information" />
<Rule Name="Reference description missing" Value="Information" />
<Rule Name="Reference name duplicate" Value="Warning" />
<Rule Name="Reference code duplicate" Value="Warning" />
<Rule Name="Reference child table missing" Value="Error" />
<Rule Name="Reference parent table missing" Value="Error" />
<Rule Name="Rule name missing" Value="Warning" />
<Rule Name="Rule code missing" Value="Warning" />
<Rule Name="Rule comment missing" Value="Information" />
<Rule Name="Rule description missing" Value="Information" />
<Rule Name="Rule name duplicate" Value="Warning" />
<Rule Name="Rule code duplicate" Value="Warning" />
<Rule Name="Rule not used" Value="Warning" />
<Rule Name="Domain name missing" Value="Error" />
<Rule Name="Domain code missing" Value="Warning" />
<Rule Name="Domain comment missing" Value="Warning" />
<Rule Name="Domain description missing" Value="Information" />
<Rule Name="Domain name duplicate" Value="Error" />
<Rule Name="Domain code duplicate" Value="Error" />
<Rule Name="Domain type missing" Value="Error" />
<Rule Name="Domain type unknown" Value="Error" />
<Rule Name="Domain not used" Value="Warning" />
<Rule Name="Table name missing" Value="Error" />
<Rule Name="Table code missing" Value="Warning" />
<Rule Name="Table comment missing" Value="Warning" />
<Rule Name="Table description missing" Value="Information" />
<Rule Name="Table name duplicate" Value="Error" />
<Rule Name="Table code duplicate" Value="Error" />
<Rule Name="Table index missing" Value="Warning" />
<Rule Name="Table column not really a foreign key" Value="Warning" />
<Rule Name="Table primary key missing" Value="Warning" />
<Rule Name="Column name missing" Value="Error" />
<Rule Name="Column code missing" Value="Warning" />
<Rule Name="Column comment missing" Value="Warning" />
<Rule Name="Column description missing" Value="Information" />
<Rule Name="Column name duplicate" Value="Error" />
<Rule Name="Column code duplicate" Value="Error" />
<Rule Name="Column is primary key but not mandatory" Value="Error" />
<Rule Name="Column data type missing" Value="Error" />
<Rule Name="Column too large for data type" Value="Warning" />
<Rule Name="Column scale too large for data type" Value="Warning" />
<Rule Name="Column scale too small for data type" Value="Warning" />
<Rule Name="Column mandatory flag invalid for data type" Value="Warning" />
<Rule Name="Column data type unknown" Value="Error" />
<Rule Name="Column data type invalid for auto-inc. Try INTEGER." Value="Error" />
<Rule Name="Key name missing" Value="Error" />
<Rule Name="Key code missing" Value="Warning" />
<Rule Name="Key comment missing" Value="Warning" />
<Rule Name="Key description missing" Value="Information" />
<Rule Name="Key name duplicate" Value="Error" />
<Rule Name="Key code duplicate" Value="Error" />
<Rule Name="Key column missing" Value="Error" />
<Rule Name="Index name missing" Value="Error" />
<Rule Name="Index code missing" Value="Warning" />
<Rule Name="Index comment missing" Value="Warning" />
<Rule Name="Index description missing" Value="Information" />
<Rule Name="Index name duplicate" Value="Error" />
<Rule Name="Index code duplicate" Value="Error" />
<Rule Name="Index column missing" Value="Error" />
<Rule Name="Index Column name missing" Value="Error" />
<Rule Name="Index Column not in table" Value="Error" />
<Rule Name="Reference Expression child column missing" Value="Error" />
<Rule Name="Reference Expression parent column missing" Value="Error" />
</Validation>
<Grammar>
<PMDataType DescriptionSize="4096" Description="789ced903f4fc33010c523c1c4c447b80981441b5aa90241b044b70e940e5d18dde49a58d8e7e03fb4e92767c46ed4a1881d55f26fb064ddbb77efae98b2e56cfe3e9b2f8b7cca8a057b812f341d58c5a504410e6b344358360856d48415184e3582b030188d1fc069188def7b81a7df92bb581f4f264328a68ce2049851254aeed0820b2d8a6f85f20a2a615bc9c358b1c3deec5091587379548fc6d1b3c8172cdb682f2b2863d8b536f0fa380783923ba1c936a2bd859577507a63909cec6013d64004d241c5ada67d93e21f82ea9027bc16943608a556adc46d98d1b28b225fe9aa6345de382559a650add058b87ed6610503dad49cc4ae9f79039caab89ac5e342c848e19ea5f4555c8e3af076efd2369d0d1791d0866f7418c2dbde17b73c8600bd0e796970d00d7a1df431e231ae3ebd764f1cd65c09d9f5bf3f9327128944e2f439ffceb2cbececbf63241289442291383d7e00f553aaf7" Name="TINYINT" Syntax="TINYINT(n)" />
<PMDataType DescriptionSize="4096" Description="789ced90314fc330108523c1c4c44fb809b5126d68a50a04c143b60c1424b230ba899b58d8e7603b6add5fce889da843113baae46fb064ddbb77ef2ecb495e94599a93ec8dbc3b54e8246c9586b2587f14eb72b29866e91b495a068637c86ad0141b06dcc06cb17c00ab60b1bc9f43e9053dfe96dc85fa72b59a4396130c53a0c09a57d43203d6b748bae7b2975073d309eafc8c031bcd8e15c11a2a4eeac138780eb976aa173554548821f5cbe31a3413d47285a6e5dd2d6c7a0b55af35432b1cecfc1a8c012aafa246e1d024e927c7c6e7f1af01a934834ac94eb0bd9fd191ab2cdda8da912c6dad1424914c6e98363079567e050d4a3714f9619c39058a7558cdb0d382cf88c0b1127d1d964307bd195cbad6197f11019dff068739bc0ebe6c4f4308505b9f176747dd6cd4c118231ce3e6ab57f689c2964a2edcf8fb337924128944ce9fcbef24b94e2efe3b46241289442291f3e3070234a9c5" Name="BIT" Syntax="BIT" />
<PMDataType DescriptionSize="4096" Description="789ced90b14ec330108623c1c4c423dc84a8445b5aa90241f090ad12b495e8c2e826d7c4c23e073b569b3e392376a20e45eca892bfc19275e7ffbe739ab16cb97c4dc7194b57ecbd254dad82ad36b09e2f3ee68bf5ed64908e572c41b0a2242cc0702a118485e164fa088d86c9f46104eb0ac1d1ef96fb509fce66234833466108cca910396fd042e39f28be17ca292884ad256ffd8c03f661c78ac492cb937a080e999dd64e3b5940cea5eca4df9e166050f24668b295a8ef60e31ac89d31488d6c61e7d74004d2be8b5b4ddd23c53f0595dec79f16943608b956b5c4bd9f51b3ab74bcd145cbd271d528c912856a83c6c2ed8bf62b18d0a6e4240efdcc01702ac26a164f0bde9140502e5d1196a3169ced52eaaab5fe4724d4fe1a1246b0ec7271cf8304e8adf7a5e1b16fd8f741af113ee3e6cbe9e699c3962b21dbfef6a77924128944ce9fcbef24b94e2efe5b231289442291c8f9f10356aca9aa" Name="BOOL" Syntax="BOOL" />
<PMDataType DescriptionSize="4096" Description="789ced90cd4a033114850774e5ca47b82b51b033d232ade818687785560bf605d299db99607ec6fc60a74feed2a4431715f752c8b70809f7e4dc736f3123efcbe962317f5d17d98c142b32052328e7c0a4c51a750aeb06c1b05a62059aca1a8119188c8693f1235805e132e9454efe963d04c538cf47790ac58cc8d002e6b26225b568c0fa4f82ee9870022a665a4e3bdf698fbdddb1c2b1a6fca41eac87799e16d98a248e575086c05ba561f9f40a1a39b54c49d3b0f61e36ce42e9b4466979075f7e144490caaba851f2f049d00f266b9fc69f0684d208a5122dc79defd092ab22dba8aa2345d658c14922506c501bb87d517e000d4ad754b27ddff30ea8acc260064f0b3ea3f43b2db9abc268b203670e2e6dd319bf0f0ead7f068714de0ebeb8a32104a8adcf2b0747dda0d7411f23ace2e6d329fb4c614b05e35dfffa337924128944ce9fcbef24b94e2efe3b46241289442291f3e3078d8fa9aa" Name="SMALLINT" Syntax="SMALLINT(n)" />
<PMDataType DescriptionSize="4096" Description="789ced90cb4ec330104523c18a159f302b0412491fa84d042112152cba68e9023ec04da689851fc10fd1f4cb596237eaa2883daae4b3b03c9aeb3b779ccf8ac5cbf3fc7d315fbee5835991af8a27e05851cb634d77085418ac5125f0d620685a0bac401151bb8e8638bbcbb2e9300323a1bfa6bdd08adfd2a1d78ca6699a8e479304f25921fc3c988b8a96c4a006e3de71b2a5dc72a8a86e19e9c047e81d0f1d863561477def3e9e4c927cb02aa2fb252864c450297443db5b585b03a5550a85611d7cb91d104148a7225a0ad848e5ac3fa8a8dd7c776ae052219492b70cb7ceb32d2ef2c15a565d910f1ac3591171e46b541aae1fa58bac40aa9a08baeb67de0011955f45e371034a22dc6796cc567e19d181d57b97b6e9b4fb0106ad2bbd4302af7b5fdc121f02e4c6e515f14117f73ae863f8e5af3ead340f04368453d6f5d59fc90381402070fa9c7f47d16574f6df310281402010089c1e3fd5fea8e7" Name="MEDIUMINT" Syntax="MEDIUMINT(n)" />
<PMDataType DescriptionSize="4096" Description="789ced90cd4ec330108423c189138fb027041249a0a47f2244a2b75ea087be809b6c130b7b1d6c47347d728ed844452ae28e2af93b445aed787626f9a258beacf37451e4abe2194869c9446cf81e8193c51a7502eb06c1f09ab002cda8761b03f1e83e9b66b387493603abe0679a0ef28e7e3fb8f3b26c34cfe693e9683e4e205f14e4efc2922a5e328b06ac7b29d98ecb4e42c54d2b580f3ecae079d808ac9938da7bffd1789ce4e9aa8840a360962b320d6f6f61d359283bad91ace8e1c3354174359d8a1945b055da19bf71aadd75f73520954628956c05ee9c635b5ce4e946557d91a78d95a28824ca0d6a03d74fca05d6a074cd88ef879b37c0a8f2450c1e2fa064e47e6929baca57a11e3af3edd236bd71fd05b46ef40e09bc7efbe28ef910a0b62e2fc5075d3ce86088e1ab5fbd77ca3e32d832c9453f4c7f260f040281c0e973fe194597d1d97fc7080402814020707a7c0102f7a847" Name="INT" Syntax="INT(n)" />
<PMDataType DescriptionSize="4096" Description="789ced8f414b0331108517f4e4c99ff04ea2607741e8c9358742915eb448ff40ba3bed0693c99aec62d35feed16c17c18247a114f21102c33cdebc57cec4e265357f9ebf95c54c944bb16a94477c123eb0e560b0b10e5193a39c091e545870ad2ad99147d7108cdc29d31bd4cab75a0678b5a71cab5f1b4d5ba98ff6c38587e9342f8ba5c8fed70d8eb4ec9465dfa8f61eebbe43d53b47dce9804f822702dba892def2a19c91ef8ab7f17afc3d8c7584ca9a56d32e3ab6e2aa2cd6b60ea22c9ace689119326b721eb74f360676b06e2b59edc79b77905c0f453c1d2f504986e24af7f55085037a7f70699be0637f8d368e83438ed7832fede410027613f3f2e44737197518630cd56f3e7adb3d4a6ca4513a8cd39fc91389442271fe5c7e65d9757671ea18894422914824ce8f6f6b73ad2b" Name="INTEGER" Syntax="INTEGER(n)" />
<PMDataType DescriptionSize="4096" Description="789ced90bf4ec330108723c1c4c423dc846068923649938a10892ca80b74e80bb8c935b5f09f6027a2e993336237ea50604795fc0d96ec3bfffc9df3b228972fcbd7751e9445be2a9e8111d52050d16183ca87f50e41d346600d8a085bd13059cc665194cec2689e25719a2659984127e1f7713a06f4e2674468fba7591ccfd3380ed3280d1749329d4f131ff2b210d60696a2a615e95043673238d953de73a8a96e19198cd401c7f453856143d859ddbe344b123f0f5685d7b1013ecd3088202428245a0ad84a65eebf53d19847ccaa814b855049de32dc9b8b6d7193071b590f451eec3ace0a8f23dfa0d270ff248d9702a91a22e88174540afd0044d4d657e379012a22ccaf56acafadb118a0d7c794763768332683d66c6d820f6fc75cdc132b01726b7cc5e4d43719fb60d4b013de7df4b27b24b0259cb261dcfd69ee70381c8ecbe7facbf36ebdabffd670381c0e87c371797c03f176a2ed" Name="BIGINT" Syntax="BIGINT(n)" />
<PMDataType DescriptionSize="4096" Description="789ced90df4ac33014c60bfa003ec277250edb6eeb9f39b116369c329039703e40b6a6339026a54937f5c9bd341dcadc50bc94417e77c9f9ce77be7392617a7bff30989d95ada43d4c93693a40ce25d14c2cbd5232a121ea624e2b1f6545174c3129b02002738a53aeafae8308b9ac40a04c07a7de56f5a30d88c84caf5e532a10c49b671c7e5a64b29eff6de127ed699a7ce516aeda265705e11c67fb515abfad34e05cae89998915e1355520158517fa5127e80761d4eb8dcec33eb484d7f5bb17717419857177e4857d171d77937defbfd1eeb5fb18e7789a3c8eef26a31b3005559a5839a3990b419726d66a677cc6146962d1cc87d95234cb612c32b620da48f43345415e5851178db4e4e4d59cfe8dfa987dab7063cc77eacde4208e37c7732c168bc572b01cbf3bce8973f4df312c168bc562b11c1e1f6b8aa2f2" Name="FLOAT" Syntax="FLOAT(n,s)" />
<PMDataType DescriptionSize="4096" Description="789ced91cf4ec24010879be803f80873321269e91f4a4bac4d68404342804448b82e744b37d9ee36dd2da84feed12da81113ce6ab2df650f33d3f9e6d7288987b3653219459d248ee6f10018af0a444d415e31dca4bc5e536c9615de1041386b41463992846dcd92132681d5c51a57160c28e57ba47a6187688d05a00a83e958413fe8f53dc7eb863dd773fc6074ebd921480ea66bb9ae6f075ee887ea716da73b3255ad0d761b104be14cbd993df3590bc6192ca74fe3c7e9680844802895764670da0686b74a7b77a29712811a6d9c5ab0c83144495c363134a3323fd44b8a5e604f52991f9c5487f8de71bc1e7806a9daa46213161ce3544332e7b5548bb675819914c02b7898cc068b9b550bf6395602ae0fd754deddc3eae3f53d10522d1290a96e043fe33f97bef26207af314bc906497cd42bd03329eae2eb90e69f1e4ffdac50150b3da937a7b9be6f459d796c68341a8de6cf71f9661857c6c56f6b68341a8d46a3f97fbc03e290aa7c" Name="DOUBLE" Syntax="DOUBLE(n,s)" />
<PMDataType DescriptionSize="4096" Description="789ced91c14ec240108649f4017c8439198db494964289b50948354d08108184eb42b77493ed6ec36e417c728f6e291a49e4ac26fb5de630333bffffafdf0f06e3797f18c2e4257c8ca6d178e437fa813f09a67bc6d93e83846fa01a31fdc624a8518e24616b23e784496045b6c41b137a94f21d5a520c5b440b2c006d30184db3d3edb4bb4ed369796ddb69ba9df0ceb13c901c0cdbb46dd7ea389eeba9625bcd5668a85e1dac3a2016c3997eb97be65913a204e6a369f43c0a074004881caf4842705c0786d74af6f6445e4c042a65e3d884598ac1ef077969be5c95e9a19f53b4871d89657ad0a426c4f789ca3df004627529435498c7acd4924c7921d5a17591612605a81c9f86e3deec66710bbb142b01b60bd754de3fc0e2585d07845487c4217504312f54a446be51af0bc219243fa7af74b183ae88c5648524aee465e8956445f6654490375c59fdec50150b3de997d66cd7adfe5aa3d168347f8ecbf75aedaa76f1db32341a8d46a3d1fc3f3e007fd4a871" Name="DOUBLE PRECISION" Syntax="DOUBLE PRECISION(n,s)" />
<PMDataType DescriptionSize="4096" Description="789ced91d16ac23014860bdb03ec11ced5d898adda5a5b595750ec86202a53c1db68531b489362529d7bf25d2ead6e28cceb6d90ef2681ff9c9cfffc097ae16bd41d06f55e184cc2e99e71b6cf20e11be88fe7bd616405f549689cde294792b0b59973c224b0225be28d055d4af90e2d29862da20516803618cca6e575bc76c7693a2dbf6d3b4dd78b1e9c860f9283695bb6ed363cc7777d75d88d662b32955683460d108be1825ef65e78d6824102f3d174f0328afa4004881caf4842705c0386d7caf6f6cc5e4c042a6de3d882598a21e885791944d92ad34acf29dac38ec432ad3ca90a715a71d81e7802b19a94212aac636eaa49a6bc906ad0bac830930254a6cfc3717776b7b8875d8a9501db855b2a1f9f60713c5d0784548344f50308625ea848cd7ca35e178433487e4e5ff96295af018bc90a497cb097a1379215d9f72282bce3c3aa5f0a55b1d033bd5ccd76ddc35f6b341a8de6cf71fd611837c6d56fdbd068341a8d46f3fff8048c51a7f0" Name="REAL" Syntax="REAL(n,s)" />
<PMDataType DescriptionSize="4096" Description="789ced52c96e134110b5041fc027d4cd204d269028176459b2630b2c39c110c2d9e5999a712bbd8c7a71085fce91ea1edb51c201890b42ea7719cb5df5fa2d3d9a8e67f3cbc5d564393a9d8e47abf14443d01d56775443230d7aa1db93ce08ed4107b5215bc294b6b8230752dc11205c7e9c7c81cac8a0f47b58af0fdbc3212842edc06f69bf0ac281f3c632353ade74de327b01c1f1078c26a8b668b1f23cda180b84d5166ad10a0fa6493c3b94814af8ca3f6baa844209bd36d475917634b5ac7977b8d215696f7d3204275a5d005a3e329e0507ed5988d0309a8ebbe81e5e6f8207c7f22951f1a2a3a8d9f2d7eea87e53c2a289e32e8df3c9dba297e4e05e48093117667fa68da99ae84a181dff43eb7b070abf0b151458d42d4587fb260e94a2cfcea1a298579434fb743b5dce0b8842e319b306e6ec19e20042cbe6f591aaef85af7a800dc76b34678e42b3f1cd4362a8b64654e9f6630c9ce5d164727c7b7db3f8703d9fa5fe3af6d608e2b88f51eff5c6686be1504a734ff56f591925bc8f7b3eb5d760903e657898ecfe34f98e475756c46a0c5c3ddc7c5ec237ae987385f3f2ecbc9f7fb461dba088f357c1f1baae64a8a94f3455ac89eaf8c8fba6d3f348d6fdf3c7553e722e742d2af4d4377328904d77921376e2073dad567244f2c979f4717671518e4e57e341464646c65fe0e5cfc1e0d5e0c5bf9691919191919191f1ffe11738a52e15" Name="DECIMAL" Syntax="DECIMAL(p,s)" />
<PMDataType DescriptionSize="4096" Description="789cedc8cb09c0201040414bb1026d6059f093434041480fb9a9e0cdee93368437c791a8f94ae2a34ad3678f3976b7ef5cf6dfbb86e2c437350000000000e0641fc7240ad8" Name="DEC" Syntax="DEC(p,s)" />
<PMDataType DescriptionSize="4096" Description="789ced53db8a1341100de807f809f5a6c238abbbec5b0898dd2003498cc6f86ca7a766a6a12f435fb28e5feea3d53dd9eced411044843e2f03a953a7ea9cea4ce7b3f56eb5f85c5d4dcfe6b3e966b61db4d18382c658b85e5c55abf7cb727ab699c1743eeb23072a5d0bce3c3af01d8262df850a0a6ae17ac90670e20796f0e55e4562cbe4833a0807e79797e5c45ba1db0282a30f188dc03b6619f768d37c64bca3c65678304d9a7660321ce56be44291706f84f6c0745da41e4dd3bc3820e8a0f6685d91fabebd7949935b5d00b354321eb809da630d42df397bb50f1e5ccf3826296a7469574b5f7bc0fa75095513e92ed1a9f2b61857727023a4848ec5c1e6d16e24d54457c2e8f81bb3fe614096e916a3c363deb792624cd83185c0dc78918fbbf97251405c34d6483590e6a810090c5a32af4f52dcc8a0348d1a604ff11aedbc654293f1fd90147867044fd34f3150962793c9f16ebdad3eac17d77123d793b74620c57d8afab86f8c96cecca43437583fc9ca28e17decf3e97a0d0bd2a70c6f99fdef98ef88bab1229ec6c06ad87e5ac2573a31e50a17e5f9c5c8bfb361dba090f257c151bbe632d438269a4eac116bcae178e9f43c9275fff871957fe3edc7ffd424232323e30ff0fce764f262f2ec5faf91919191919191f1ffe1179bba2c45" Name="NUMERIC" Syntax="NUMERIC(p,s)" />
<PMDataType DescriptionSize="4096" Description="789ced534d8bdb30100db43fa03f616e6e21f6e6833d2c844052871248b629bb5bd85b156bec0864c9e823dbf497f7b823d9c976e9a1d04b29f8613096466fde7b23cf96f37c71bf9a5d2de7b3dd7c019c39cce0fe80607dd368e3908361aa42101692f168344a47637a12701a921b423a9ea4d37192c1f674f765035cd846b29385400b47263d5a100a924742badda6799e40a94dcddc10f6de0193523f5938691f2899b5a252e773b410690a2d7dad2c782b540528dc010d5867e8cb8236a07cbd4763b3d9d56e3ea89813473caf0d818ae15b9a40201e0233b4a51d517a15cc91b4d972de8400e07dd0631b566050180edae8dbd0db1c917fc8605d86721bcb6967343c4b7d1252c28185c61a3816a266121a2d940b024bc30a27b40a6bccb836e19a7d17b5afbb7c7509f9eae37abbd85c52b351bb6535522e5152fef961b959b5c1853d62f5c4d93284020615995717aa36396a75823dd297a2d49850647c7f8a0cc5418b2276bfc4c014bf988c8e1f6eefd69f6e577950641bf2560ae44350d845dde90dd1d2f8e34091ff9695ae8573e15c68cbb1645eba98e1b9b2f953e5984a774684d1e8eeba7da51153ae30cd26d3b6fec586a97c8d947fed2d1d5785f41cdb44e3881522a71cba49c7eb11adb74d7f1960f6c2b9565c14f48bb493390fb0bbf344f1035f8f565244f2d57ef031b9be6eaf6a8f1e3d7afc05defe1c0cde0ddefc6b193d7af4e8d1a3478fff0fcf12c9284c" Name="DATE" Syntax="DATE" />
<PMDataType DescriptionSize="4096" Description="789cedcec16a83401006e03eca7fdb4b359ad04344840403297421452f3dae716316745776765b7cfbda42fa10653efecbcce19f298f557d684fedab3c959b63555eaa037a153494ed11cca471755367ac0ac6d914ed5d83e23c3b1f740fafeca0610822cfb22cc9f235c8b2e23702c141ec5749be4d7639b6bbe265bf46a4904bf3fe86ded03caa85f0f8009f6a8c9a602cc4c72a9132a96b9ccf859445d308dc9c9f5478461703d438ba2fc2e2e2cf21456406fb2858177f9d5737c6c91222193b409b70d71e14fc3a119c878d53a73da5e5e6523d31c618638c31c61863ffd237be3d547b" Name="DATETIME" Syntax="DATETIME" />
<PMDataType DescriptionSize="4096" Description="789ced534d6fd340108d043f809f309cd28ac424a5a2a5449152a52895ea2a90f4d0e3c61ec70bf66eb41f89fccf3932b3765d4a7b07248ff6e0f5ecbc99f7666672395d5fc757abf52c5e4ede5f4e27cbe90c9c2cd13a51ee2258e70846a82d82b4d01f7f3a1b0d47633a301a5d84d307a7c1ea123908a4024711150a0327a30f67115c2b88abd5d71b388d4620540ae42a249a01b479612f0a8f16844148a5dd15a2c294a1eec9e2783e5f2ce278b51ac09fb7fa3e006d1a1764da94c20d20c51daa54aa2d6805871ca9280393cba9628e4c657c0a4714564a6be9d5f100c62703380f501f07b0f10e4451e883854a7b6628e8dd563d544a3f1eab4f74e14b65c13312a00cb9ac3374b38ca77cb9416323f86274d98a31fe5d002ac8a0f346116f619b6038105490b366057d663c8ce321115d2c2ee2f8623eef93c25928f22094e3c272b1478a224842124df6f0c2e6da1794204de1dd889f3276dbeb8647047399656890d15a5f816aebf2ba454a3bb07eb7d3c661dab0da1341495253932356929187438507d03bc78e4428d82069440c2973297e607864d1502cb942d95431b5fd116c1cc1ec99d2ac16e164be606148b8449bd06ac64b85c33066611c7546df707dbbbafab6e656dc2de7b3f515d5844684b2369808c202e9185578a749689950ef2b2acd3d88f40c957f96da3acece4a3d22caba1ba9567d075bb90fd8a21e1cf6188b4516c13dbd614d446175c824db64893741fda74937553383cc3440dededddcd4b8f59ab6e32dccd6978c20a89189a321544427d7070a7a49cc76e73e13b06db7b13888aaeeb875da50dfea013fa5521cf951247904b7da7123693a5be42375dcee04ad9ec1278b77ce7da0ed635c83f51031731a8e6651284816a472d8a317515f886df68d95a02474be7b1b144565bd694ad40a83e8060b2936a449ea69b65962838163bd11e4c276f968385cb543fb76f27e39ed75d6d9bf61af7ff67a6f7aaffe76199d75d659679d75d6d9ff67bf00a8d6bf77" Name="TIMESTAMP" Syntax="TIMESTAMP(n)" />
<PMDataType DescriptionSize="4096" Description="789cedcc410ac2301005508ff277d968bb10414b2958102a5850ea05528d6d204d249328bdbd5510779e601eb3f91fe6e76571ded7bb3c2d8bfc586c11f4a0129c7b052f6da7a00962b15eaeb3d5663a81e0207e31413d36a703ae9aee468e84f7161ed24445d016a2aab2bace9a46e0e6fc20c31c6d0c90c6b8276174f1bd27897467bf5f53f119b93813074b88a46d07a543af3c28f829119c878d43ab3c25797a2c668c31c618638c31c618fbe705781a3eff" Name="TIME" Syntax="TIME" />
<PMDataType DescriptionSize="4096" Description="789ced54db6e1a410c456a3fa09fe03e2551c30628499b94221141954821a209a994c761d70bd3cecea0b980f6cffb587b7621bde4bdadb4160f048f8f8f8f7d32b81c3e4e46778393cbe160361c4189c282d4d06b83b1d06f6772293de4c616c2c36186b908ca8374bbd451029faae447185c0e350325305f2108a5cc562c14c246a8800e8445e89e77bae00df4baa7a7c7d0a1e0669e9eef5a450255bf63103aa392779d76af73760e3287d204080e6345ef3772f4ecec9cf84ccbfbcf379049b756a274c0e3ed2850af478a3dfe22f88aa78bc8444c3827977af79e7e88e5a951a1d08e5a4bbd0494d4de82f396fe72ac930ec502ad4be090278f25be5c23eb14b4d808a9a2106b2be931815614bf5089341ade26bd5e723438990d5b9811831a19b6d4274e5a4f78c0dcdbd3697b3c86abab8be9f4623c3e48e0ba92652bb467ec95d8b03ed49a90444d2dbe702b131435c83278d3e1a78ced6581ce8b625d0f99c058e6395a64b47d4ea15efa55b5436d3cb8b05e1beb31a3f55b53c0a61ea59f74926eef3822b7db1ab760d69e13a9d0b040de5dc69d0bf1ad5aa2434bb5948ab4455cd11358378111ccafa793fbf9683aab1946551de641b1306031353663bd182f131ee3d9307730397d87ebdbfbc9dd9cf7f4301b8fe613e28456445a0b4c05df938c372d823724b44ce9264aa2e67722fd81ca3f16c679eece4a3d21d6479a197de0612937115b5407c519eb50e5093cd21bd64428676227b96f96061bd5ffb5e9a2ac6f93278d90b70f3737156e65b89dfd6849cb503082a045a69e2e54d3382bb3a5a2e7c4acad82d90702767bbbaa2ddb8737eebcb1b4b7eafafb44c5531e45ba4ae0d6785e245de71ef9501fed0db325a3fcc48c9abde73d74fb11d76275443c391d47ed222a926416134df62cea33b5b51959096a429fafc1454551bb606b8a466314dda29264c812b240b7cd125b8c33568e885edd998fffd99095ddebe8cf269af837e2e5f756eb55ebc5dfa6d144134d34d144134dfc7ff1034f41c280" Name="YEAR" Syntax="YEAR(n)" />
<PMDataType DescriptionSize="4096" Description="789ced53d16edb300cdca7f0ad0990a45d8a3e74080238c5801548d32ecd06ec9191e958a82c79929cd47f3fd27212ec1f7c6fb2c8d31d8f5eac964f3fb2ede276b55cbc2d3328f427e55343f6104b08d16b7b805862041d00cd09db005e1fca38ad31cf29879396ba1a1505888e4b894fa474a1f9b2a739956499cb79ca67b0e30a8ff640e00a7811da3b699c3f3c802ad1a38ae4038cbe9e3fd65e3b2f8797f6fde71a7ef3ad7616ee67f3fb31b379d44634f612d0333b55ee28d2e459117444d390bce4890dd1516488e974919a82f3917bd0e6a05c55f3a71cb4058581a6da06b241477d24283094f23e2ae57cde4d27b9cea9c0c6c4ab090814a1b18642e80a56cf9b6cfb073ea83d71a7c83930a19dc126db3dbf6eb275d23462b73a06a0bf8d667d64238492c541e17c35818d148da55b387922d3c747e05844064bd096525c98d894334d6585a131393481fed32a25d9d3eefb56b44a344cdb339f4b7806dde0fb89c916243da58c8a355d49667d44688c3b05685d23a294278cc45dbd144e3db635756da3bbf1f5d50ab535ad682c1a93c2138a1279eaccb3a72e18a3912792b6ce55bc446c0b6bfeac30722e21b9cfa92696e752fef4a94324abba95bb08d937b12f76601d4f4cc586a5b7972975db71d5872638e050d88cd5cc7551684916e74cdb513a71a2904ff84130ef17ed1b6467db93cb4f254fa7e09824c0e675079b5febf5843d1a034ea9a66e139fe36cf73aa61d3d737737d707a41538949b9bd9e2f66df965c0800103060c183060c08001032ef807d2de52b6" Name="CHAR" Syntax="CHAR(n)" />
<PMDataType DescriptionSize="4096" Description="789ced545d681c55148e448ca80f62b5964ae1146a934077b209094de3666192465dd86c369b4d210f626f66eeec5c3373eff6feec326f3e8882f441ad7f9007c16a4b501f448c68158ae8538b8210b404a42858504404abf1a578eeecda44c8bb0a739887b9f7dcfb9def7ee7a730553ce1d6a61f756b85a1a962a15a74a1452423cb11cd45943774084a4bc61b0e5484a613a0256111ae4135894715104941d258b4a80fed9072d0214588c850600aef0a898e011de2c2674140a582408a383db6305fce1d3b8648d46301f38866820f3a50479724bc414104306b61f2a0058c8c8d811712493c6d510686ffde6c4a26a45dcc26880827d08b4030eae49d1184ebbeaf43aa435809a99116e13e78226e12cb9171f088a239c615e58a69d6a21010155a28c323aa54ca79aa54716b4bb04293b690be25d7c0937c3b0cee10502146082d7e80d4ecbe3b5d9fa9d9434ba5ca234e61a85aece93ffdd9639fdc5b995c1f33f1d90bbf5edfb8e3fdb177c223fbcf7cbae7d97b921f2fbf77ded977f6f9fe17d6bf58fcf87874e7ca8db7f3d239f8e1976b875fbe56bbf1dbdaf4a1b73e7ae9c2ed578ebe3bd43a7960aefcf9d36f7ef0caa0d93cb5f1cce1f1abd56f4e6f5c36f36169efb5f2e6fcc4a9d79f9bdb72f3bfdcfff3037e63f3cca5b907e7ce5f7df5d0c51f4cdfeae33f5d7f6a727f6f65ed1cdff3daf7d11f13e70e4caaf6d1affbdeb86ffcc5d5d52bdffd1eff492f3e794bef6d77edcb9fb43fce56df57dfd6d6a9efc0c3369bad1d9a0f8f1c4995cae5386d8368daaca2b41c962918854a63a662b242d3438a4abc8bae90a0de44d9346c830d3be042bd343bb3507767ab98abc8c4dc2a8c388189527125f53011b6222d9e4f344df3aa599cd60fc62d5516666a75c0b38bd5e36e7d06395199161bc6f5086201d369de8c16313a3c12450952d396eaaea87633164adbe894eb1d882c804418f005efd76969586cd2ed08f44845a3c081253c6335219112692476339867a4b498ff0cba9ca03a8a35b87d690a59592c973bb89d96294c15b96d62acf086892d02c17ef3b402c1f139a168e3a5ddc4f4996a4624a1fe4308ac6ef649d42649b75d3a5d6c948d3d8a5434fa29f1c2ce5040d6446f230ff0c12eb8b21341ee6086c1c66d1e8647bb73a3d969447c39160737f1b2edec76c8225419b590bba3ee72b733a494550283e0f78451a9a2d8cb4676290a4e53d1258dec844bc03771339558d2f48da9feda0e3f68331c7db8c4e2d04993aa8369cb6696d97fc36eddeae9b9bba7f7dfa6915966996596596699fdffec2f6155e191" Name="VARCHAR" Syntax="VARCHAR(n)" />
<PMDataType DescriptionSize="4096" Description="789cedc8310ac2300005508ff2471d34582838840c050717c990a12e4208b109240dc4147b7c7b8c0eff8d4f0eca3c9e2f731f8d1483925a19bf36b892963ce3175b8045b66bcc4b46f2f3b445f9a0eb7b1cbbf70d675c4f70c156eb9aafdf8b145a1d888888888888886857fe829f1a5a" Name="TINYTEXT" Syntax="TINYTEXT" />
<PMDataType DescriptionSize="4096" Description="789ced545d681c55148e448c5405b1554b24700ab549a03bd98dd936ad9b854dbaeac26677b3d94453fce9cdcc9d9d6b66ee6cefbd93edbe89888af641ad7f988782b52d4145448c685b68459f2c0a42d012d0a260c12222588d2fc173efa64d84bcabb01ffbb073ce9def3bf73be74c6a385dc93e5449f50da753a574851e5260877e1470a833e50181801c624114804f791503a10bbb92c97b92d0d3ff686217c420d10bb64704b11515d24af595d26db7541f2ed6ce4d5e7ee3bdef9fdfb2bfebd926bc07579e3cdab95f4870451880f2288c8fe5637bf680ac519bb9cc268a85bcd7820aa604e155aad546814988830aa13f995c27053d89abc19a60a1d00fa30d648449cc22110c5871ab1fe92633e59107326598257e4425104141864251070877f0b6410d430e300e369134c6b8a45c32c56629b8447a9a2ae23e95d2d43c9c2b64ca5330431bf55038bab82a9ee46b321821203d54f034bf8ba5e97866a4922deb4353b9c2fd4d9fba0f7ff6c8992d85a18564141c3bf5db95c54d1f26dff576761ef974f373b7357e3effc1496bebb117bb5f5af872e2f43effa6999577e2c2daf6f157f33b5ebd545ef97d7e64fbdb9fbc72eac60bbbdfef9b3dd055cc7ffef4f18f5eeb8d960e2e3eb363f062e9dbc38be7a3312f77c7a5fcd2d8de836fbe505ccec47fbdf397bb9cead2912f8a77174f5e7c7dfbd99fa28eb9c72e5f796aa8b3bd307f826f3efaa3ffe7de135d43b2befb9b8eb76e1f7c796eeec20f7f047fd1b34f5cd77ec3cd5be307f41f6bb9e3ebefca0bd4b1e03eddcdd9759e27fa771aa762314eeb10d67457d15a0ed31422894e63a7023243cd214905be8b298fa0df44ea36ac91252cc84025379a1daf64464b5727131d461e37f28db982dad808c6ab86cf218a9abe2a1698f941dd5c613c5bae009e9d28edcb54b258131566d850d726c8054c99be452a0c306113df6f60694a97ba21ab0e06a1545a9d72b58e91b9d008237042deadcc68686ed21c3e9d1192faae055378467b427c191a25764dcc8e84d09cff149d6ea03b9255b9bea9a12c4ce4f34ddee6caa486d35cef314e78350a3403715d6a2b0921c7eb78611d5fdac84c87c99a4f1ad4b91789e5b53df1eba4b1ba2e2ad41b1249ad3d80a528cc53627b161442a51b49d41a730fef5d259750f7a85857198a0dea3e24060cafa0b5e622e2cd713878144cebcdae7bcc4797d10bb131eb06ef4a25b038a99d4011fc3d1e49e328ee7224564b0c3935a60bea33328d9e38515033160b6aee68fc5798a2cdcf1f3ee270a8468dca6d66655b68e1bf81eb97dbda6e6d6bffb7cb68a185165a68a18516fe7ff81b7a06e1b9" Name="TEXT" Syntax="TEXT" />
<PMDataType DescriptionSize="4096" Description="789cedc8310a83300005d01ee58fed6025a1364bc82075e8203844702a849056c128d8881edf1ea3c37fe3d3a5a9abc7b3ad6dd5599d974637c6863dc1cfe31a276c43eae110dd3ec435620cd3e717f31be2ae9492a2c059bee40d19c405be778bf3292cdfabce1b7322222222222222a2bf7000089f1c0d" Name="MEDIUMTEXT" Syntax="MEDIUMTEXT" />
<PMDataType DescriptionSize="4096" Description="789ced545d685c45148e448ca80f62fd2995c229d4a681e46e76dd3449dd2c6cd2b52eec5f371b310f6a27f7ceee1d73efcc767eb2bd6f3e8882f441ad7f9007c16a4b501fa418d12a14d1278b8210b404a42858504404abf1a578e6deb406c9bb0a7b58d8dd9939dff9e63bdf99dc74be5cab1e6e161f69e652d3f95c3ddfa4c735b8223021872ed33e1008c971169a1002cadbb8205a90cd4c66270f8c6726c7607fe6b1fb333002e921707d2289aba9540e5485a6a07da26181bac428fb8782a27289ca941b30ca3574a4d0024b01e11e54a2d26ca1029a2c0454814f14b8464a3c164448216021d3b672fa40053a5422c330349cb94433c1a143dc45aa2195a48314dd6188840197f0410d116e250c988a69747d614f11dea61633598f3ad4c9a5eaf93e45b9629a2d516811e55b78c39153923a5daa161af3b048a3ae901e60621b4f72071e2e34661e2a34ec0a01e50b8997c76bb58404bb5e9869161bf6d07ca97a38a93378e2d3473fbeb33ab53a66c253e77ebdb276cb7b63eff8c3bb4e7eb2e3d93ba21f2f9c3de3ec3cf5fce00bab5fcc7d7428b875f1eadba3d2d9f3c1972bfb5ebedcb8fadbcaccdeb73e7ce9dccd17c7df4d2d1ddd5d2b7ff6f49befbf3264d68fad3db36fe252fd9b136b17cc11bf74f7e5f2fa9183c75e7faeb65118fde59e9feff5daeb273fafdd573b73e9d5bde77f3003cb8fff74e5a9a95dfdd595d37cc76bdf077f1c3cbd7b4a75c7bf1e78e3ae891797972f7ef77bf8273dffe40dfd37ddb673f4a8fde16c0c7cf56d63957a0e3c284508d8546585ca3aa34e3a331c2b3532c2691744276e1036028d60bbe08116e8a8c5ad86c02d9fa0ded874c6b780a51d2840b35429ce360b95fa3557a2c288d332412caea42e3682f1768ce711b49dd55db330ee2dd62d55678b8d26e0d9b9faa142b3889ca84c7c73cd9be82ddb37a345881b2e09d0740a5d8354b745b58ba150da56b74efe1b91b562e379c21acf5ac36213582281a176472a1ab41c984fcc09245022aec4ae17dbb4fd3f8a2ee01428c5dadcde3486acce95cb09ae034dcccb4de7b99d6120b26d428b405a2dea6a0582e3757cd1c5a4edc4f498ea0424a2de0308ac12481423e89208bf2436490b897d33cad6ce22158dfb94b8fed631bf8ebc9f0f6d822b1c342ab730c36213b60fe96c8c2b6907c72471049a839b70015b8f490ca753a016727bd46d729596484e5925b0087e9e302a561467d9c84d8a82d35874490386ef44049e093bb1c492c6778cf54f9e90f8e9c3bff6d9c09741ed8947b617bdf86fc48d1b7d7db7f7f5ffdb347ad18b5ef4a217bde8c5ff2ffe025b25e27f" Name="LONGTEXT" Syntax="LONGTEXT" />
<PMDataType DescriptionSize="4096" Description="789cedc8b10a83301405d07eca1deba05241e81032bc4d10ebe0d2a5f008b6064c84a8b4fe7dfb191dee198f113b34dd5dda9b9852ace9adf8a8e9805be63d44bcfd364111f4e3c31e308ff1f58be589aaae71ae1e57e4b86470932675db98d6c294bd3d11111111111111d11ff902eba11af4" Name="TINYBLOB" Syntax="TINYBLOB" />
<PMDataType DescriptionSize="4096" Description="789ced545d685c45148e468ca80f6afd2991e229d4a481e46eb666d3503781dd34eac2ee66bbd90879503b7befecde31f7ce6ce727eb7df34114a40f6aaa16f2205a6d09ea8388f1a7164ad1278ba210b504a4a858b08808ada62fc533f7465b24ef2aec21ec6667e67ce7ccf77d67b2f9897c713a9f4de527b295893ce34446e08ac0841cda4cfb4020244fb0d0841050dec405d180d14ce6be0cecdcf5687a1486203d00ae4f24713595cac9a62a135d3f7ee0b516fbccdae1af4f1d3a317e6b125fde73e9daf3aff65ea032e5068c720d2d29b4c06240b807a5a830932b8126f5802af08902d74889c782089b0858c8b4ad9d1e2d418b4aec310c0d672ed14c706811779e6a4825e920457b102261c025bc5f43845b4651d03e53f841a1ed0b7b8af026b598c97ad4a249f78a72c5345ba0d020cab7f086634f496abe50ce55e7609e466d213dc0c4269ee40e3c9cab4e3e94abda1502ca1752fbf65a0d21c1aee7266b53557b68ae507e30a9d37ff093474edc5e1e5fc998f0c8f1df2eaedef85ee66d7fb077f1d496676f8b7e3efdee3167eb91e7fb5f58f97cf6e3bdc14df397df1a96cef60fbf58ee7be95cf5f285e5c91d6f7ef4e2f11bceec7e27b5b07fdb74f1d3a7df78ffe501b37660f599beb1b3956f0fae9e36fbfcc29de78a6bfbf61c78edb9e9f5dcf0af77fd72b7d75c5bfc6cfadee963670fef38f993e9597aecfcc5a7c67bbbcbcb47f996577e08fed87374dbb86aeffea6e7f53bc60e2d2d9df9fef7f0123df9e435ddd7dfbc7578bffdc759eff9eabbea0af51c78408a1016507a4bd48833eca4770dc64c0d0d71da06d18a054221a04ead0a1e68819e9aa7f1214525e6e2964f906f149df1abc0d20ee4a056284dcdd472a5ca5fbe448611a76182985c495d1482f1668ce7114d633b6916c6da62dd427966aa5a033c3b5bd99bab4d614f5426bea953975867a0b7ac6e468b10375c12a0e914ba065bdd14d52e8642695bdd3af90a226bc4c6f384359eb586c526b0400243ed8e543468383097981348a0445c89fd5d6cc3f6ff285ac729508a35b9bd690c599e2d16135c076a9897cd4f703bc74064d3841681341ad4d50a04c7ebf8a28d499b91e931d50a4844bdfb115825904846d026117e4914490b89ba19656b8f602b1af729717d07ca425b2189be82bc930f6c802b1c342aafea0c8b8d591dd22331aea42d1c93c411680e6ec23a4a8f490ca75320177273d44d729596d89cb24c6011fc7bdca898519c6523375a149cc6a44b1a307c2722f04cd88a299634be63cc7ff284c48f1ffeb4cf06be0c6a7b3cb29de8c47f23ae5befeabaa5abfbdf6ea3139de844273ad1894efcffe24fd2c0e546" Name="BLOB" Syntax="BLOB" />
... Rozdílový soubor je zkrácen, protože jeho délka přesahuje max. limit.

Také k dispozici: Unified diff