FreenetIS

select user

add

save

device is successfully saved.

add new device

add new segment

add new interface

add new ip address

update

device is successfully updated.

basic data

location address

location details

technology

bitrate

duplex

back to detail

back to segments list

back to devices list

segment is successfully saved.

device name

segment name

interface is successfully updated.

interface is successfully saved.

ip address is successfully saved.

ip address is successfully updated.

port is successfully saved.

port is successfully updated.

interface detail

select device

select segment

map

interface name

ip addresses

ip address

subnet name

subnet network address

subnet netmask

create new interface

create new ip address

create new segment

iface name

select subnet name

select subnet

select interface

device detail

error

id is required.

devices list

back to device parameters

back to interfaces list

vlan interface name

add new port

ports

segments list

create new devices

edit device

pppoe

location details

comment

location adrress

id

user

type

login name

password

gps

mac

edit interface

interfaces list

ip address detail

edit ip address

back to interfaces list

ip addresses list

Interface type

back to interface parameters

back to ip addresses list

back to interfaces list

back to ports list

create new port

subnets list

network address

netmask

ospf area id

back to all subnets

subnet is successfully saved.

subnet is successfully updated.

add new subnet

create new subnet

edit segment

vlan interfaces

add new vlan interface

vlan name

vlan interfaces list

select vlan

back to vlan interfaces list

vlan interface is successfully saved.

vlan interface is successfully updated.

edit vlan interface

create new vlan interface

back to vlan interface parameters

vlan interface detail

add new vlan

vlans list

vlan name

vlan detail

create new vlan

edit vlan

vlan is successfully saved.

vlan is successfully updated.

back to vlans list

select port

port detail

tag_802_1q

edit port

networks

add new member

add new user

error: parameter ID is required!

show

edit

delete

edit member

change password

basic informations

members name

type

contact informations

address

member

completive informations

account informations

comment

administrate additional contacts

current credit

czk

entrance date

entrance fee

entrance fee left

debit payment rate

qos ceil

qos rate

display member

must pay regular fee

yes

no

member successfully updated.

error - cant update member.

error - cant add new member.

member successfully added.

editation of member

back to this user.

old password

new password

change password

confirm new password

change

wrong password.

error - cant change password

password successfully changed.

user

editation of user

back to this user.

error - cant update user.

user successfully updated.

back to list of members.

error - cant add new user.

user successfully added.

back to the member.

administration of additional contacts

aditional contacts successfully updated.

error - cant update aditional contacts.

delete this contact.

add new contact

save changes

type of contact

contact value

additional_contacts_infotext

delete_user

delete_member

there are no items yet.

honest member

wanna be a member

account type

bank account

double entry account

account

amount

arrival

outbound

from/to

new transfer

time

completive informations

details

transfer details

detail of transfer number

back to account transfers

origin account

destination account

date and time

bank info

variable symbol

constant symbol

specific symbol

accounts overview

add new account

start amount

master bank account

project account

account successfully added.

error - cant add new account.

member already have the double entry account.

in database can be only one master bank account.

back to the members transfers.

really delete this account

edit account

account editation

back to this account.

member have to own ONE double entry account.

account successfully updated.

error - cant update account.

acount deleted.

current credit on this account is

select the member

new transfer from account

send to member

members account

amount have to be more than 0!

select destination account.

select destination member.

the transfer successfully done.

error - cant do the transfer.

do transfer

account transfers

operating account

infrastructure account

in database can be only one operating account.

in database can be only one infrastructure account.

show transfers on this account.

suppliers account

in database can be only one suppliers account.

bank transfer fee.

unidentified transfers

back to unidentified transfers

assign transfer

assign

penalty and fee

none

fee or penalty comment

description

number of the hours

error - cant add new work.

work successfully added.

show transfer

work successfully updated.

error - cant update work.

edit the work

work successfully deleted.

error - cant delete work.

delete_work

confirm

work confirmation

show user

user identification

transfer informations

unconfirmed works

user successfully deleted.

error - cant delete user.

unidentified acccount

in database can be only one unidentified account.

fee

pay from account

my works

show all transfers on the account

list of all members

list of all users

cookies must be anabled.

-- phpMyAdmin SQL Dump

-- version 2.9.1

-- http://www.phpmyadmin.net

--

-- Počítač: localhost

-- Vygenerováno: Pátek 02. května 2008, 00:51

-- Verze MySQL: 5.0.27

-- Verze PHP: 5.2.4

--

-- Databáze: `freenetis2`

--

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

--

-- Struktura tabulky `access_mod`

--

CREATE TABLE `access_mod` (

`id` int(11) NOT NULL default '0',

`device_id` int(11) default NULL,

`user_admin_id` int(11) default NULL,

`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` (`user_admin_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `access_mod`

--

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

--

-- Struktura tabulky `accounts`

--

CREATE TABLE `accounts` (

`id` int(11) NOT NULL auto_increment,

`owner_id` int(11) default NULL,

`name` varchar(100) collate utf8_czech_ci default NULL,

`type` enum('bank','analytic','master','project','operating','infrastructure','suppliers','unidentified') collate utf8_czech_ci default NULL,

`start_amount` double default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`id`),

KEY `is_owned_by` (`owner_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=22 ;

--

-- Vypisuji data pro tabulku `accounts`

--

INSERT INTO `accounts` (`id`, `owner_id`, `name`, `type`, `start_amount`, `comment`) VALUES

(1, 28, 'asd', 'analytic', 500, NULL),

(2, 25, 'Jiri svetlik', 'analytic', 0, 'jeho hlavni ucet'),

(3, 22, 'petuv', 'analytic', 500, NULL),

(4, 1, 'Petr Danek', 'analytic', 0, 'nejaky comment'),

(5, 24, 'umasdad', 'analytic', 0, NULL),

(6, 26, 'sadasd', 'analytic', 0, NULL),

(7, 27, 'asdasd dsds', 'analytic', 0, NULL),

(8, 1, '3123651654321/0800', 'bank', NULL, 'Jeden z jeho bankovních účtů.'),

(9, 1, 'Projekt na záchranu žab', 'project', 1540, 'No, tak to je na ten projekt o kterem jsme se bavili. Snad ta částka bude stačit. edituje to vubec ?'),

(10, 1, 'nějaký další projekt', 'project', NULL, '...'),

(14, 25, 'nejaky projekt', 'project', 0, NULL),

(15, 1, 'Master ucet', 'master', 0, 'Hlavni ucet sdruzeni, nic sem neposilat!'),

(16, 1, 'Infrastruktura', 'infrastructure', 0, NULL),

(17, 1, 'Operating account', 'operating', 0, NULL),

(18, 1, 'Dodavatelé', 'suppliers', 0, 'vsichni kterym neco platime'),

(19, 29, 'Petrik Danku', 'analytic', NULL, NULL),

(20, 1, 'Neidentifikovane platby', 'unidentified', 0, 'Vsechny bankovni poplatky a vse co odchazi mimo tak poslat sem.'),

(21, 30, 'Tom Bobu', 'analytic', NULL, NULL);

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

--

-- Struktura tabulky `acl`

--

CREATE TABLE `acl` (

`id` int(11) NOT NULL default '0',

`section_value` varchar(230) collate utf8_czech_ci NOT NULL default 'system',

`allow` int(11) NOT NULL default '0',

`enabled` int(11) NOT NULL default '0',

`return_value` text collate utf8_czech_ci,

`note` text collate utf8_czech_ci,

`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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `acl`

--

INSERT INTO `acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES

(19, 'user', 1, 1, '', '', 1209664479),

(20, 'user', 1, 1, '', '', 1209664544),

(21, 'user', 1, 1, '', '', 1209655542),

(22, 'user', 1, 1, '', '', 1209673546),

(24, 'user', 1, 1, '', '', 1209657851),

(25, 'user', 1, 1, '', '', 1209652620),

(26, 'user', 1, 1, '', '', 1209678005),

(27, 'user', 1, 1, '', '', 1209680042),

(28, 'user', 1, 1, '', '', 1209678074);

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

--

-- Struktura tabulky `acl_sections`

--

CREATE TABLE `acl_sections` (

`id` int(11) NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(230) collate utf8_czech_ci NOT NULL,

`hidden` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `value_acl_sections` (`value`),

KEY `hidden_acl_sections` (`hidden`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- 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);

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

--

-- Struktura tabulky `acl_seq`

--

CREATE TABLE `acl_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `acl_seq`

--

INSERT INTO `acl_seq` (`id`) VALUES

(28);

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

--

-- Struktura tabulky `aco`

--

CREATE TABLE `aco` (

`id` int(11) NOT NULL default '0',

`section_value` varchar(240) collate utf8_czech_ci NOT NULL default '0',

`value` varchar(240) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(255) collate utf8_czech_ci 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aco`

--

INSERT INTO `aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(14, 'freenetis', 'view_all', 1, 'Prohlizeni vsech zaznamu', 0),

(15, 'freenetis', 'edit_all', 1, 'Editace vsech zaznamu', 0),

(16, 'freenetis', 'new_all', 1, 'Vytvareni novych zaznamu', 0),

(17, 'freenetis', 'view_own', 2, 'Prohlizeni vlastnich zaznamu', 0),

(18, 'freenetis', 'edit_own', 2, 'Editace vlastnich zaznamu', 0),

(19, 'freenetis', 'new_own', 2, 'Vytvareni novych vlastnich', 0),

(20, 'freenetis', 'delete_all', 1, 'Mazani vsech zaznamu', 0),

(21, 'freenetis', 'delete_own', 2, 'Mazani vlastnich zaznamu', 0),

(22, 'menu', 'my_users', 1, 'My users', 0),

(23, 'menu', 'my_transfers', 1, 'My transfers', 0),

(24, 'menu', 'my_devices', 1, 'My devices', 0),

(25, 'menu', 'unidentified_transfers', 2, 'Unidentified transfers', 0),

(26, 'menu', 'unconfirmed_works', 2, 'Unconfirmed works', 0),

(27, 'menu', 'accounts', 2, 'Accounts (master, operating...)', 0),

(28, 'menu', 'users_members', 3, 'Users and members', 0),

(29, 'menu', 'network', 4, 'Network menu', 0);

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

--

-- Struktura tabulky `aco_map`

--

CREATE TABLE `aco_map` (

`acl_id` int(11) NOT NULL default '0',

`section_value` varchar(230) collate utf8_czech_ci NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

PRIMARY KEY (`acl_id`,`section_value`,`value`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aco_map`

--

INSERT INTO `aco_map` (`acl_id`, `section_value`, `value`) VALUES

(19, 'freenetis', 'delete_all'),

(19, 'freenetis', 'delete_own'),

(19, 'freenetis', 'edit_all'),

(19, 'freenetis', 'edit_own'),

(19, 'freenetis', 'new_all'),

(19, 'freenetis', 'new_own'),

(19, 'freenetis', 'view_all'),

(19, 'freenetis', 'view_own'),

(20, 'freenetis', 'delete_all'),

(20, 'freenetis', 'delete_own'),

(20, 'freenetis', 'edit_all'),

(20, 'freenetis', 'edit_own'),

(20, 'freenetis', 'new_all'),

(20, 'freenetis', 'new_own'),

(20, 'freenetis', 'view_all'),

(20, 'freenetis', 'view_own'),

(21, 'freenetis', 'delete_own'),

(21, 'freenetis', 'edit_own'),

(21, 'freenetis', 'new_own'),

(21, 'freenetis', 'view_own'),

(22, 'freenetis', 'delete_own'),

(22, 'freenetis', 'edit_own'),

(22, 'freenetis', 'new_own'),

(22, 'freenetis', 'view_own'),

(24, 'freenetis', 'delete_own'),

(24, 'freenetis', 'edit_own'),

(24, 'freenetis', 'new_own'),

(24, 'freenetis', 'view_own'),

(25, 'freenetis', 'delete_own'),

(25, 'freenetis', 'edit_own'),

(25, 'freenetis', 'new_own'),

(25, 'freenetis', 'view_own'),

(26, 'menu', 'accounts'),

(26, 'menu', 'my_devices'),

(26, 'menu', 'my_transfers'),

(26, 'menu', 'my_users'),

(26, 'menu', 'network'),

(26, 'menu', 'unconfirmed_works'),

(26, 'menu', 'unidentified_transfers'),

(26, 'menu', 'users_members'),

(27, 'menu', 'my_devices'),

(27, 'menu', 'my_transfers'),

(27, 'menu', 'my_users'),

(27, 'menu', 'network'),

(28, 'menu', 'my_devices');

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

--

-- Struktura tabulky `aco_sections`

--

CREATE TABLE `aco_sections` (

`id` int(11) NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(230) collate utf8_czech_ci NOT NULL,

`hidden` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `value_aco_sections` (`value`),

KEY `hidden_aco_sections` (`hidden`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aco_sections`

--

INSERT INTO `aco_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES

(14, 'freenetis', 1, 'system Freenetis', 0),

(15, 'menu', 1, 'Polozky menu', 0);

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

--

-- Struktura tabulky `aco_sections_seq`

--

CREATE TABLE `aco_sections_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aco_sections_seq`

--

INSERT INTO `aco_sections_seq` (`id`) VALUES

(15);

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

--

-- Struktura tabulky `aco_seq`

--

CREATE TABLE `aco_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aco_seq`

--

INSERT INTO `aco_seq` (`id`) VALUES

(29);

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

--

-- Struktura tabulky `aro-old`

--

CREATE TABLE `aro-old` (

`id` int(11) NOT NULL auto_increment,

`section_value` varchar(240) collate utf8_czech_ci NOT NULL default '0',

`value` varchar(240) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(255) collate utf8_czech_ci 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=22 ;

--

-- Vypisuji data pro tabulku `aro-old`

--

INSERT INTO `aro-old` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(1, 'all', 'admin', 1, 'Petr Danek', 0),

(4, 'all', 'kenod', 1, 'Petr Kenod', 0),

(5, 'all', 'user', 1, 'userovoprijmeni userovojmeno', 0),

(6, 'all', 'jirka', 1, 'Jirka Jirik', 0),

(19, 'all', 'login', 0, 'neco nevim', 0),

(20, 'all', 'novy', 0, 'aaa asd', 0),

(21, 'all', 'kenudek', 0, 'Danku Petricek', 0);

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

--

-- 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) collate utf8_czech_ci NOT NULL,

`value` varchar(255) collate utf8_czech_ci 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_groups`

--

INSERT INTO `aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES

(21, 0, 1, 26, 'Vsichni lide na svete', 'all'),

(22, 21, 2, 21, 'Radni clenove sdruzeni', 'radni_clenove'),

(23, 21, 22, 23, 'Registrovani zajemci o clenstvi', 'registrovani_zajemci'),

(24, 22, 3, 4, 'Revizni komise', 'revizni_komise'),

(25, 22, 5, 10, 'Spravni rada', 'spravni_rada'),

(26, 22, 11, 18, 'Technici', 'technici'),

(27, 25, 6, 7, 'Hospodar', 'hospodar'),

(28, 25, 8, 9, 'Predseda jednatel', 'predseda_jednatel'),

(29, 26, 12, 13, 'Certifikovani sitovi experti', 'certifikovani_experti'),

(30, 26, 14, 15, 'Spravci AP', 'spravci_ap'),

(31, 26, 16, 17, 'Spravci freenetisu', 'spravci_freenetisu'),

(32, 22, 19, 20, 'Administratori systemu', 'admins'),

(33, 21, 24, 25, 'Uzivatele clenu', 'uzivatele');

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

--

-- Struktura tabulky `aro_groups_id_seq`

--

CREATE TABLE `aro_groups_id_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_groups_id_seq`

--

INSERT INTO `aro_groups_id_seq` (`id`) VALUES

(33);

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

--

-- 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_groups_map`

--

INSERT INTO `aro_groups_map` (`acl_id`, `group_id`) VALUES

(19, 32),

(20, 32),

(21, 22),

(22, 22),

(24, 33),

(25, 33),

(26, 32),

(27, 22),

(27, 23),

(28, 33);

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

--

-- Struktura tabulky `aro_map`

--

CREATE TABLE `aro_map` (

`acl_id` int(11) NOT NULL default '0',

`section_value` varchar(230) collate utf8_czech_ci NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

PRIMARY KEY (`acl_id`,`section_value`,`value`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_map`

--

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

--

-- Struktura tabulky `aro_sections`

--

CREATE TABLE `aro_sections` (

`id` int(11) NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(230) collate utf8_czech_ci NOT NULL,

`hidden` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `value_aro_sections` (`value`),

KEY `hidden_aro_sections` (`hidden`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_sections`

--

INSERT INTO `aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES

(12, 'all', 1, 'All users of slFree', 0);

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

--

-- Struktura tabulky `aro_sections_seq`

--

CREATE TABLE `aro_sections_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_sections_seq`

--

INSERT INTO `aro_sections_seq` (`id`) VALUES

(12);

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

--

-- Struktura tabulky `aro_seq`

--

CREATE TABLE `aro_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `aro_seq`

--

INSERT INTO `aro_seq` (`id`) VALUES

(18);

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

--

-- Struktura tabulky `axo`

--

CREATE TABLE `axo` (

`id` int(11) NOT NULL default '0',

`section_value` varchar(240) collate utf8_czech_ci NOT NULL default '0',

`value` varchar(240) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(255) collate utf8_czech_ci 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo`

--

INSERT INTO `axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(15, 'Registration_Controller', 'name', 1, 'Jmeno', 0),

(16, 'Registration_Controller', 'surname', 1, 'Prijmeni', 0),

(17, 'Registration_Controller', 'street', 1, 'Ulice', 0),

(20, 'Members_Controller', 'view_comment', 0, 'Vidi komentar', 0),

(21, 'Members_Controller', 'view_entrance_date', 0, 'Vidi vstupni datum', 0),

(22, 'Members_Controller', 'view_qos_ceil', 0, 'Vidi qos ceil', 0),

(23, 'Members_Controller', 'view_qos_rate', 0, 'Vidi qos rate', 0),

(25, 'Members_Controller', 'edit_username', 1, 'Edituje login', 0),

(26, 'Members_Controller', 'edit_name', 1, 'Edituje jmeno', 0),

(27, 'Members_Controller', 'edit_surname', 1, 'Edituje prijmeni', 0),

(28, 'Members_Controller', 'edit_type', 1, 'Edituje typ', 0),

(29, 'Members_Controller', 'edit_membersname', 1, 'Edituje clenske jmeno', 0),

(30, 'Members_Controller', 'edit_phone', 1, 'Edituje telefon', 0),

(31, 'Members_Controller', 'edit_email', 1, 'Edituje email', 0),

(32, 'Members_Controller', 'edit_address', 1, 'Edituje adresu', 0),

(33, 'Members_Controller', 'edit_currentcredit', 1, 'Edituje vysi kreditu', 0),

(34, 'Members_Controller', 'edit_en_fee', 1, 'Edituje vysi vstupniho poplatku', 0),

(35, 'Members_Controller', 'edit_en_fee_left', 1, 'Edituje zbyvajici vysi vstup poplatku', 0),

(36, 'Members_Controller', 'edit_debit', 1, 'Edituje vysi splatky', 0),

(37, 'Members_Controller', 'edit_qos_ceil', 1, 'Edituje QOS ceil', 0),

(38, 'Members_Controller', 'edit_qos_rate', 1, 'Edituje QOS rate', 0),

(39, 'Members_Controller', 'edit_entrance_date', 1, 'Edituje vstupni datum', 0),

(40, 'Members_Controller', 'edit_comment', 1, 'Edituje komentar', 0),

(41, 'Members_Controller', 'edit_must_pay', 1, 'Edituje zda musi platit poplatky', 0),

(42, 'Users_Controller', 'edit_username', 1, 'Editovat login', 0),

(43, 'Users_Controller', 'edit_phone', 1, 'Editovat telefon', 0),

(44, 'Users_Controller', 'edit_email', 1, 'Editovat email', 0),

(45, 'Users_Controller', 'edit_comment', 1, 'Editovat komentar', 0),

(46, 'Users_Controller', 'add_work', 2, 'Muze pridavat prace', 0),

(47, 'Users_Controller', 'view_works', 0, 'Vidi prace', 0),

(48, 'Users_Controller', 'view_qos_ceil', 0, 'Vidi QOS ceil', 0),

(49, 'Users_Controller', 'view_qos_rate', 0, 'Vidi QOS rate', 0),

(50, 'Users_Controller', 'view_comment', 0, 'Vidi komentar', 0),

(51, 'Users_Controller', 'add_comment', 3, 'Pridava i komentar', 0),

(52, 'Users_Controller', 'edit_work', 2, 'Muze editovat praci', 0),

(53, 'Users_Controller', 'delete_work', 2, 'Smazat praci', 0),

(54, 'Works_Controller', 'work_confirm', 1, 'Potvrzovat prace a platit za ne', 0),

(55, 'Accounts_Controller', 'view_transfers', 1, 'Vidi sve transakce', 0),

(56, 'Members_Controller', 'add_must_pay', 2, 'Pri vytvareni nastavovat zda musi platit', 0),

(57, 'Members_Controller', 'add_current_credit', 2, 'Pri vytvareni nastavovat kredit uzivatele', 0),

(58, 'Accounts_Controller', 'view_all_transfers', 1, 'Vidi vsechny transakce', 0),

(59, 'Accounts_Controller', 'add_accounts', 2, 'Muze pridavat ucty', 0),

(60, 'Accounts_Controller', 'view_accounts', 2, 'Vidi vsechny sve ucty', 0),

(61, 'Accounts_Controller', 'edit_accounts', 3, 'Editovat ucty', 0),

(62, 'Accounts_Controller', 'delete_accounts', 4, 'Mazat ucty', 0),

(63, 'Accounts_Controller', 'assign_transfers', 5, 'Muze prirazovat neidentifikovane transakce', 0);

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

--

-- 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) collate utf8_czech_ci NOT NULL,

`value` varchar(255) collate utf8_czech_ci 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_groups`

--

INSERT INTO `axo_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES

(10, 0, 1, 28, 'all', 'All'),

(13, 10, 2, 11, 'Sprava clenu', 'sprava_clenu'),

(14, 15, 4, 5, 'Registrace noveho clena', 'registration_new_self'),

(15, 13, 3, 6, 'Pridani noveho clena', 'add_new'),

(16, 10, 12, 19, 'sprava uzivatelu', 'sprava_uzivatelu'),

(17, 16, 13, 14, 'Pridani noveho uzivatele', 'pridani_uzivatele'),

(18, 13, 7, 8, 'Prohlizeni detailu', 'prohlizeni_detailu_clena'),

(19, 13, 9, 10, 'Editace clena', 'member_edit'),

(20, 16, 15, 16, 'Editace uzivatele', 'user_edit'),

(21, 16, 17, 18, 'Prohlizeni detailu', 'user_show'),

(22, 10, 20, 21, 'Sprava praci', 'works'),

(23, 10, 22, 27, 'Sprava uctu a transakci', 'accounts_transfers'),

(24, 23, 23, 24, 'Sprava uctu', 'accounts'),

(25, 23, 25, 26, 'Sprava transakci', 'transfers');

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

--

-- Struktura tabulky `axo_groups_id_seq`

--

CREATE TABLE `axo_groups_id_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_groups_id_seq`

--

INSERT INTO `axo_groups_id_seq` (`id`) VALUES

(25);

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

--

-- 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_groups_map`

--

INSERT INTO `axo_groups_map` (`acl_id`, `group_id`) VALUES

(19, 10),

(22, 17);

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

--

-- Struktura tabulky `axo_map`

--

CREATE TABLE `axo_map` (

`acl_id` int(11) NOT NULL default '0',

`section_value` varchar(230) collate utf8_czech_ci NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

PRIMARY KEY (`acl_id`,`section_value`,`value`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_map`

--

INSERT INTO `axo_map` (`acl_id`, `section_value`, `value`) VALUES

(22, 'Accounts_Controller', 'view_accounts'),

(22, 'Accounts_Controller', 'view_transfers'),

(22, 'Members_Controller', 'edit_address'),

(22, 'Members_Controller', 'edit_email'),

(22, 'Members_Controller', 'edit_name'),

(22, 'Members_Controller', 'edit_phone'),

(22, 'Members_Controller', 'edit_surname'),

(22, 'Members_Controller', 'edit_username'),

(22, 'Members_Controller', 'view_entrance_date'),

(22, 'Members_Controller', 'view_qos_ceil'),

(22, 'Users_Controller', 'add_comment'),

(22, 'Users_Controller', 'add_work'),

(22, 'Users_Controller', 'edit_email'),

(22, 'Users_Controller', 'edit_phone'),

(22, 'Users_Controller', 'edit_username'),

(22, 'Users_Controller', 'view_qos_ceil'),

(22, 'Users_Controller', 'view_qos_rate'),

(22, 'Users_Controller', 'view_works'),

(24, 'Users_Controller', 'edit_email'),

(24, 'Users_Controller', 'edit_phone'),

(24, 'Users_Controller', 'edit_username'),

(24, 'Users_Controller', 'view_works');

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

--

-- Struktura tabulky `axo_sections`

--

CREATE TABLE `axo_sections` (

`id` int(11) NOT NULL default '0',

`value` varchar(230) collate utf8_czech_ci NOT NULL,

`order_value` int(11) NOT NULL default '0',

`name` varchar(230) collate utf8_czech_ci NOT NULL,

`hidden` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `value_axo_sections` (`value`),

KEY `hidden_axo_sections` (`hidden`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_sections`

--

INSERT INTO `axo_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES

(10, 'Registration_Controller', 1, 'registrace noveho clena', 0),

(13, 'Members_Controller', 1, 'Radni clenove', 0),

(14, 'Users_Controller', 1, 'Uzivatele radnych clenu', 0),

(15, 'Works_Controller', 1, 'Prace uzivatelu', 0),

(16, 'Accounts_Controller', 1, 'Ucetni a transakcni veci', 0);

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

--

-- Struktura tabulky `axo_sections_seq`

--

CREATE TABLE `axo_sections_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_sections_seq`

--

INSERT INTO `axo_sections_seq` (`id`) VALUES

(16);

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

--

-- Struktura tabulky `axo_seq`

--

CREATE TABLE `axo_seq` (

`id` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `axo_seq`

--

INSERT INTO `axo_seq` (`id`) VALUES

(63);

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

--

-- Struktura tabulky `bank_fees`

--

CREATE TABLE `bank_fees` (

`id` int(11) NOT NULL auto_increment,

`fee` float NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;

--

-- Vypisuji data pro tabulku `bank_fees`

--

INSERT INTO `bank_fees` (`id`, `fee`) VALUES

(1, 39.9),

(2, 50),

(3, 70);

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

--

-- Struktura tabulky `contacts`

--

CREATE TABLE `contacts` (

`user_id` 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` (`user_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=56 ;

--

-- Vypisuji data pro tabulku `contacts`

--

INSERT INTO `contacts` (`user_id`, `id`, `type`, `value`) VALUES

(NULL, 17, 'aaa', 'ddd'),

(NULL, 18, 'ffff', 'ssss'),

(NULL, 20, 'aaa', 'ddd'),

(NULL, 21, 'ffff', 'ssss'),

(13, 43, 'mobil2', 'nemam'),

(4, 47, 'icq', '104677383'),

(4, 48, 'skype', 'kenod1st'),

(4, 49, 'msn', 'kenod@kenod.net'),

(1, 52, 'icq', '124547845'),

(1, 53, 'msn', 'bubakov'),

(12, 54, 'msn', 'tedka'),

(6, 55, 'jura', 'jurkov');

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

--

-- Struktura tabulky `dbdesigner4`

--

CREATE TABLE `dbdesigner4` (

`idmodel` int(10) unsigned NOT NULL,

`idversion` int(10) unsigned NOT NULL,

`name` varchar(45) collate utf8_czech_ci default NULL,

`version` varchar(20) collate utf8_czech_ci default NULL,

`username` varchar(45) collate utf8_czech_ci default NULL,

`createdate` datetime default NULL,

`iscurrent` int(1) unsigned default NULL,

`ischeckedout` int(1) unsigned default NULL,

`info` varchar(255) collate utf8_czech_ci default NULL,

`model` mediumtext collate utf8_czech_ci,

PRIMARY KEY (`idmodel`,`idversion`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `dbdesigner4`

--

INSERT INTO `dbdesigner4` (`idmodel`, `idversion`, `name`, `version`, `username`, `createdate`, `iscurrent`, `ischeckedout`, `info`, `model`) VALUES

(1, 1, 'Noname1', '1.0.0.0', 'root', '2008-04-09 01:56:21', 1, 0, '', '<?xml version="1.0" standalone="yes" ?>\r\n<DBMODEL Version="4.0">\r\n<SETTINGS>\r\n<GLOBALSETTINGS ModelName="Noname1" IDModel="1" IDVersion="1" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="1" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" />\r\n<DATATYPEGROUPS>\r\n<DATATYPEGROUP Name="Numeric Types" Icon="1" />\r\n<DATATYPEGROUP Name="Date and Time Types" Icon="2" />\r\n<DATATYPEGROUP Name="String Types" Icon="3" />\r\n<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />\r\n<DATATYPEGROUP Name="User defined Types" Icon="5" />\r\n<DATATYPEGROUP Name="Geographic Types" Icon="6" />\r\n</DATATYPEGROUPS>\r\n<DATATYPES>\r\n<DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="UNSIGNED" Default="1" />\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="UNSIGNED" Default="1" />\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="UNSIGNED" Default="1" />\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="UNSIGNED" Default="0" />\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="UNSIGNED" Default="1" />\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="UNSIGNED" Default="0" />\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="precision" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n<PARAM Name="decimals" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n<PARAM Name="decimals" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n<PARAM Name="decimals" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n<PARAM Name="decimals" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n<PARAM Name="decimals" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n<PARAM Name="decimals" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="ZEROFILL" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \\a1000-01-01\\a to \\a9999-12-31\\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \\a1000-01-01 00:00:00\\a to \\a9999-12-31 23:59:59\\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \\a1970-01-01 00:00:00\\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n</DATATYPE>\r\n<DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \\a-838:59:59\\a to \\a838:59:59\\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n</DATATYPE>\r\n<DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="BINARY" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="length" />\r\n</PARAMS>\r\n<OPTIONS>\r\n<OPTION Name="BINARY" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="values" />\r\n</PARAMS>\r\n</DATATYPE>\r\n<DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<PARAMS>\r\n<PARAM Name="values" />\r\n</PARAMS>\r\n</DATATYPE>\r\n<DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<OPTIONS>\r\n<OPTION Name="BINARY" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<OPTIONS>\r\n<OPTION Name="BINARY" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n<OPTIONS>\r\n<OPTION Name="BINARY" Default="0" />\r\n</OPTIONS>\r\n</DATATYPE>\r\n<DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n<DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >\r\n</DATATYPE>\r\n</DATATYPES>\r\n<COMMON_DATATYPES>\r\n<COMMON_DATATYPE ID="5" />\r\n<COMMON_DATATYPE ID="8" />\r\n<COMMON_DATATYPE ID="20" />\r\n<COMMON_DATATYPE ID="15" />\r\n<COMMON_DATATYPE ID="22" />\r\n<COMMON_DATATYPE ID="28" />\r\n<COMMON_DATATYPE ID="26" />\r\n<COMMON_DATATYPE ID="33" />\r\n<COMMON_DATATYPE ID="34" />\r\n<COMMON_DATATYPE ID="35" />\r\n</COMMON_DATATYPES>\r\n<TABLEPREFIXES>\r\n<TABLEPREFIX Name="Default (no prefix)" />\r\n</TABLEPREFIXES>\r\n<REGIONCOLORS>\r\n<REGIONCOLOR Color="Red=#FFEEEC" />\r\n<REGIONCOLOR Color="Yellow=#FEFDED" />\r\n<REGIONCOLOR Color="Green=#EAFFE5" />\r\n<REGIONCOLOR Color="Cyan=#ECFDFF" />\r\n<REGIONCOLOR Color="Blue=#F0F1FE" />\r\n<REGIONCOLOR Color="Magenta=#FFEBFA" />\r\n</REGIONCOLORS>\r\n<POSITIONMARKERS>\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />\r\n</POSITIONMARKERS>\r\n</SETTINGS>\r\n<METADATA>\r\n<REGIONS>\r\n</REGIONS>\r\n<TABLES>\r\n<TABLE ID="1000" Tablename="Table_01" PrevTableName="" XPos="100" YPos="100" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\\n" TableOptions="DelayKeyTblUpdates=0\\nPackKeys=0\\nRowChecksum=0\\nRowFormat=0\\nUseRaid=0\\nRaidType=0\\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >\r\n<COLUMNS>\r\n</COLUMNS>\r\n</TABLE>\r\n</TABLES>\r\n<RELATIONS>\r\n</RELATIONS>\r\n<NOTES>\r\n</NOTES>\r\n<IMAGES>\r\n</IMAGES>\r\n</METADATA>\r\n<PLUGINDATA>\r\n<PLUGINDATARECORDS>\r\n</PLUGINDATARECORDS>\r\n</PLUGINDATA>\r\n<QUERYDATA>\r\n<QUERYRECORDS>\r\n</QUERYRECORDS>\r\n</QUERYDATA>\r\n<LINKEDMODELS>\r\n</LINKEDMODELS>\r\n</DBMODEL>\r\n');

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

--

-- Struktura tabulky `devices`

--

CREATE TABLE `devices` (

`id` int(11) NOT NULL auto_increment,

`user_id` 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,

`engineer_id` int(11) default NULL,

PRIMARY KEY (`id`),

KEY `user_id` (`user_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;

--

-- Vypisuji data pro tabulku `devices`

--

INSERT INTO `devices` (`id`, `user_id`, `name`, `type`, `PPPoE_logging_in`, `login`, `password`, `GPS`, `location_address`, `location_details`, `comment`, `engineer_id`) VALUES

(1, 4, 'router', 'router', 1, 'kenod', 'heslo', 'nema to gps', 'u tabuli 116', NULL, NULL, NULL);

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

--

-- 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `groups_aro_map`

--

INSERT INTO `groups_aro_map` (`group_id`, `aro_id`) VALUES

(32, 1),

(22, 4),

(22, 5),

(22, 6),

(33, 19),

(33, 20),

(22, 21),

(33, 22),

(22, 23);

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

--

-- 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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Vypisuji data pro tabulku `groups_axo_map`

--

INSERT INTO `groups_axo_map` (`group_id`, `axo_id`) VALUES

(14, 15),

(14, 16),

(14, 17),

(18, 20),

(18, 21),

(18, 22),

(18, 23),

(19, 25),

(19, 26),

(19, 27),

(19, 28),

(19, 29),

(19, 30),

(19, 31),

(19, 32),

(19, 33),

(19, 34),

(19, 35),

(19, 36),

(19, 37),

(19, 38),

(19, 39),

(19, 40),

(19, 41),

(20, 42),

(20, 43),

(20, 44),

(20, 45),

(21, 46),

(21, 47),

(21, 48),

(21, 49),

(21, 50),

(17, 51),

(21, 52),

(21, 53),

(22, 54),

(25, 55),

(15, 56),

(15, 57),

(25, 58),

(24, 59),

(24, 60),

(24, 61),

(24, 62),

(25, 63);

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

--

-- Struktura tabulky `ifaces`

--

CREATE TABLE `ifaces` (

`id` int(11) NOT NULL auto_increment,

`device_id` int(11) default NULL,

`segment_id` 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` (`device_id`),

KEY `segment_iface` (`segment_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Vypisuji data pro tabulku `ifaces`

--

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

--

-- Struktura tabulky `ip_addresses`

--

CREATE TABLE `ip_addresses` (

`iface_id` int(11) default NULL,

`VLAN_iface_id` int(11) default NULL,

`subnet_id` int(11) default NULL,

`IP_address` int(11) default NULL,

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`),

KEY `iface_address` (`iface_id`),

KEY `subnet_address` (`subnet_id`),

KEY `VLAN_iface_address` (`VLAN_iface_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Vypisuji data pro tabulku `ip_addresses`

--

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

--

-- Struktura tabulky `jobs`

--

CREATE TABLE `jobs` (

`id` int(11) NOT NULL auto_increment,

`user_id` int(11) NOT NULL,

`description` varchar(255) collate utf8_czech_ci default NULL,

`hours` float default NULL,

`confirmed_by_id` int(11) default NULL,

`transfer_id` int(11) default NULL,

PRIMARY KEY (`id`),

KEY `commited_by` (`user_id`),

KEY `transfer_salary` (`transfer_id`),

KEY `confirmed_by` (`confirmed_by_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;

--

-- Vypisuji data pro tabulku `jobs`

--

INSERT INTO `jobs` (`id`, `user_id`, `description`, `hours`, `confirmed_by_id`, `transfer_id`) VALUES

(1, 1, 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tatio', 10, 1, 11282),

(2, 2, 'No, tak skoro nic jsem nedelal, ale to je snad jedno, ne?', 5, 1, 11),

(5, 2, 'novinka', 10, 1, 11283),

(6, 1, 'No, tak celý den jsem vytahoval zaby z potoka.', 24, NULL, NULL),

(7, 12, 'Uklidila jsem doma.', 7, NULL, NULL);

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

--

-- Struktura tabulky `logging`

--

CREATE TABLE `logging` (

`id` int(11) NOT NULL auto_increment,

`ip_address` varchar(15) collate utf8_czech_ci NOT NULL,

`prefix` varchar(30) collate utf8_czech_ci NOT NULL,

`unix` varchar(9) collate utf8_czech_ci default NULL,

`mikrotik` varchar(45) collate utf8_czech_ci default NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `prefix` (`prefix`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;

--

-- Vypisuji data pro tabulku `logging`

--

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

--

-- Struktura tabulky `members`

--

CREATE TABLE `members` (

`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,

`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 '1',

`current_credit` float default NULL,

`entrance_date` date default NULL,

`comment` varchar(250) collate utf8_czech_ci default NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=31 ;

--

-- Vypisuji data pro tabulku `members`

--

INSERT INTO `members` (`id`, `name`, `street_number`, `street`, `town`, `ZIP_code`, `type`, `qos_ceil`, `qos_rate`, `entrance_fee`, `debt_payment_rate`, `entrance_fee_left`, `must_pay_regular_fee`, `current_credit`, `entrance_date`, `comment`) VALUES

(1, 'namemember', 'a', 'a', 'aaa', '78587', NULL, '1478', NULL, NULL, NULL, NULL, 0, 16875.3, '1970-01-01', NULL),

(22, 'Petr Daněk', '116a', 'U tabulía', 'Dolní Bečvaa', '76001', NULL, '15452', '21241', 100, 0, 200, 1, 2730.1, '2000-05-05', NULL),

(24, 'userovojmeno', '111', 'userova ulice', 'userovvo město', '75655', NULL, '51515154', NULL, NULL, NULL, NULL, 0, 4350.4, '2008-04-09', NULL),

(25, 'Jiří Světlík', '2861', 'Slovenská', 'Zlín', '76001', NULL, '2048', '1048', 2000, 0, 0, 1, 12320.9, '2008-04-15', NULL),

(26, 'asd', 'asd', 'asd', 'asd', 'asdasd', NULL, NULL, NULL, NULL, NULL, NULL, 1, 2860, '2008-04-20', NULL),

(27, 'asd', 'asd', 'asd', 'asd', 'asdasd', NULL, NULL, NULL, NULL, NULL, NULL, 1, 510, '2008-04-20', NULL),

(28, 'asd', 'asd', 'asd', 'asd', 'asdasd', NULL, NULL, NULL, NULL, NULL, NULL, 1, 500, '2008-04-20', NULL),

(29, 'Petrik Danku', '147', 'DOma', 'Domov', '78945', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2008-04-29', NULL),

(30, 'Tom Bobu', '147', 'U reky', 'Roznov', '87521', NULL, '147', '148', 2000, NULL, 2000, 1, 710, '2008-05-01', NULL);

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

--

-- Struktura tabulky `menus`

--

CREATE TABLE `menus` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(50) collate utf8_czech_ci default NULL,

`url` varchar(100) collate utf8_czech_ci default NULL,

`master_id` int(11) NOT NULL,

`sorting` int(11) default NULL,

`active` tinyint(1) NOT NULL default '1',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=34 ;

--

-- Vypisuji data pro tabulku `menus`

--

INSERT INTO `menus` (`id`, `name`, `url`, `master_id`, `sorting`, `active`) VALUES

(1, 'Members', 'members', 0, NULL, 1),

(2, 'Users', 'users', 0, NULL, 1),

(3, 'Přidat člena', 'pridat-clena', 1, NULL, 1),

(4, 'Seznam členů', 'seznam-clenu', 1, NULL, 1),

(5, 'pokus', 'pokus', 3, NULL, 1),

(6, 'Devices', 'devices', 0, NULL, 1),

(7, 'Devices list', 'devices/show_all', 6, NULL, 1),

(8, 'Add new device', 'devices/add', 6, NULL, 1),

(9, 'Interfaces', 'ifaces', 0, NULL, 1),

(10, 'Interfaces list', 'ifaces/show_all', 9, NULL, 1),

(11, 'Add new interface', 'ifaces/add', 9, NULL, 1),

(12, 'Ports', 'ports', 0, NULL, 1),

(13, 'Ports list', 'ports/show_all', 12, NULL, 1),

(14, 'Add new port', 'ports/add', 12, NULL, 1),

(15, 'VLAN interfaces', 'vlan_ifaces', 0, NULL, 1),

(16, 'VLAN interfaces list', 'vlan_ifaces/show_all', 15, NULL, 1),

(17, 'Add new VLAN interface', 'vlan_ifaces/add', 15, NULL, 1),

(18, 'VLANs', 'vlans', 0, NULL, 1),

(19, 'VLANs list', 'vlans/show_all', 18, NULL, 1),

(20, 'Add new VLAN', 'vlans/add', 18, NULL, 1),

(21, 'IP addresses', 'ip_addresses', 0, NULL, 1),

(22, 'IP addresses list', 'ip_addresses/show_all', 21, NULL, 1),

(23, 'Add new IP address', 'ip_addresses/add', 21, NULL, 1),

(24, 'Subnets', 'subnets', 0, NULL, 1),

(25, 'Subnets list', 'subnets/show_all', 24, NULL, 1),

(26, 'Add new subnet', 'subnets/add', 24, NULL, 1),

(27, 'Segments', 'segments', 0, NULL, 1),

(28, 'Segments list', 'segments/show_all', 27, NULL, 1),

(29, 'Add new segment', 'segments/add', 27, NULL, 1),

(30, 'Unidentified transfers', 'accounts/unidentified_transfers/', 0, NULL, 1),

(31, 'parse bank account', 'accounts/parse_ebank_account', 0, NULL, 1),

(32, 'works', 'works', 0, NULL, 1),

(33, 'logout', 'login/logout', 0, 5, 1);

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

--

-- Struktura tabulky `money_transfer_bank_infos`

--

CREATE TABLE `money_transfer_bank_infos` (

`id` int(11) NOT NULL auto_increment,

`variable_symbol` bigint(20) default NULL,

`constant_symbol` bigint(20) default NULL,

`specific_symbol` bigint(20) default NULL,

`name` varchar(250) collate utf8_czech_ci NOT NULL,

`date_time` datetime NOT NULL,

`identified` tinyint(1) default '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=534 ;

--

-- Vypisuji data pro tabulku `money_transfer_bank_infos`

--

INSERT INTO `money_transfer_bank_infos` (`id`, `variable_symbol`, `constant_symbol`, `specific_symbol`, `name`, `date_time`, `identified`) VALUES

(1, 732227901, 0, NULL, 'CINCAR STEFAN ING.', '2008-04-30 06:50:40', 1),

(2, 777330136, 0, NULL, 'Plášek Roman', '2008-04-30 06:50:05', 1),

(3, 604440594, 0, NULL, 'DULIK JIRI', '2008-04-30 06:05:32', 1),

(4, 774914572, 0, NULL, 'JAKŮBKOVÁ MARCELA', '2008-04-30 04:52:11', 1),

(5, 732355905, 558, NULL, ' ', '2008-04-29 10:25:55', 1),

(6, 775342243, 508, NULL, 'ZALEK JOSEF', '2008-04-29 06:46:24', 0),

(7, 605128219, 558, NULL, 'Hrabinová Ludmila', '2008-04-29 06:46:24', 0),

(8, 604916598, 308, NULL, 'OREL SLAVICIN', '2008-04-29 05:48:54', 0),

(9, 774678627, 558, NULL, 'DROSCAK PETR', '2008-04-29 05:47:48', 0),

(10, 737342177, 308, NULL, 'GAZDÍK JIŘÍ', '2008-04-29 04:34:06', 0),

(11, 732541320, 508, NULL, 'Jaroslav Kolarik', '2008-04-29 04:14:06', 0),

(12, 604331066, 558, NULL, 'JURENCAKOVA JANA', '2008-04-28 11:03:12', 0),

(13, 732210781, 225, NULL, 'BRUNIK DANIEL', '2008-04-28 11:01:17', 0),

(14, 775329696, 558, 12006, 'CHARVAT RUDOLF', '2008-04-28 10:58:02', 0),

(15, 608621793, 558, NULL, 'PINDAK VACLAV', '2008-04-28 10:58:01', 0),

(16, 739409761, 508, NULL, 'MAJERIKOVÁ MIR.', '2008-04-28 07:14:50', 0),

(17, 604332688, 0, NULL, 'KOLOUCH STANISLAV', '2008-04-25 10:25:41', 1),

(18, 604479764, 0, NULL, 'BEHUNCIK ALOIS', '2008-04-25 10:22:38', 0),

(19, 603969688, 308, NULL, 'VILIMEK JIRI', '2008-04-25 09:19:03', 0),

(20, 736417922, 558, NULL, 'KOTRABOVA MAGDALENA', '2008-04-25 09:13:44', 0),

(21, 604142584, 558, NULL, 'OLEJNIK JOSEF', '2008-04-24 06:02:51', 0),

(22, 776327235, 558, NULL, 'STREJCEK LEO', '2008-04-24 06:02:35', 0),

(23, 605247917, 0, NULL, ' ', '2008-04-23 15:18:15', 0),

(24, 732278797, 558, NULL, 'PROCHÁZKA MARTIN', '2008-04-22 08:55:53', 0),

(25, 604556716, 0, NULL, 'MILICKA STANISLAV', '2008-04-22 08:35:26', 0),

(26, 774341125, 558, NULL, 'SAHAJOVA LUDMILA', '2008-04-22 08:35:25', 0),

(27, 731234871, 308, NULL, 'Matulová Helena', '2008-04-22 08:34:55', 0),

(28, 775105789, 558, NULL, 'Hofmanová Monika', '2008-04-22 08:25:08', 0),

(29, 723152688, 558, NULL, 'BRONISEVSKA MARIA', '2008-04-22 06:06:14', 0),

(30, 603239001, 0, NULL, 'BEŇO KAMIL', '2008-04-22 05:46:58', 0),

(31, 731886025, 308, NULL, 'Struhař Josef', '2008-04-21 10:52:29', 0),

(32, 604926658, 308, NULL, 'KUCERA JAN', '2008-04-21 07:33:03', 0),

(33, 731482964, 558, NULL, 'VECERA ZDENEK', '2008-04-21 05:45:57', 0),

(34, 733529935, 558, NULL, 'LYSACKOVA JANA', '2008-04-21 05:40:35', 0),

(35, 732180381, 225, NULL, 'HEINZOVA DANUSE', '2008-04-21 05:36:35', 0),