FreenetIS

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

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,

KEY `is_owned_by` (`owner_id`)

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

-- Vypisuji data pro tabulku `accounts`

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

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

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

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

-- Struktura tabulky `acl`

CREATE TABLE `acl` (

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

KEY `updated_date_acl` (`updated_date`)

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

-- Vypisuji data pro tabulku `acl`

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

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

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

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

-- Struktura tabulky `acl_sections`

CREATE TABLE `acl_sections` (

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

KEY `hidden_acl_sections` (`hidden`)

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

-- Vypisuji data pro tabulku `acl_sections`

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

(28);

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

-- Struktura tabulky `aco`

CREATE TABLE `aco` (

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

KEY `hidden_aco` (`hidden`)

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

-- Vypisuji data pro tabulku `aco`

(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),

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

-- Struktura tabulky `aco_map`

CREATE TABLE `aco_map` (

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

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

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

-- Vypisuji data pro tabulku `aco_map`

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

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

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

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

-- Struktura tabulky `aco_sections`

CREATE TABLE `aco_sections` (

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

KEY `hidden_aco_sections` (`hidden`)

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

-- Vypisuji data pro tabulku `aco_sections`

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

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

(29);

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

-- Struktura tabulky `aro-old`

CREATE TABLE `aro-old` (

`id` int(11) NOT NULL auto_increment,

KEY `hidden_aro` (`hidden`)

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

-- Vypisuji data pro tabulku `aro-old`

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

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

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

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

-- Struktura tabulky `aro_groups`

CREATE TABLE `aro_groups` (

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

KEY `lft_rgt_aro_groups` (`lft`,`rgt`)

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

-- Vypisuji data pro tabulku `aro_groups`

(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'),

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

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

(33);

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

-- Struktura tabulky `aro_groups_map`

CREATE TABLE `aro_groups_map` (

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

(19, 32),

(20, 32),

(21, 22),

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

-- Struktura tabulky `aro_map`

CREATE TABLE `aro_map` (

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

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

KEY `hidden_aro_sections` (`hidden`)

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

-- Vypisuji data pro tabulku `aro_sections`

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

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

(18);

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

-- Struktura tabulky `axo`

CREATE TABLE `axo` (

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

KEY `hidden_axo` (`hidden`)

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

-- Vypisuji data pro tabulku `axo`

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

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

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

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

-- Struktura tabulky `axo_groups`

CREATE TABLE `axo_groups` (

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

KEY `lft_rgt_axo_groups` (`lft`,`rgt`)

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

-- Vypisuji data pro tabulku `axo_groups`

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

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

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

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

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

(25);

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

-- Struktura tabulky `axo_groups_map`

CREATE TABLE `axo_groups_map` (

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

(19, 10),

(22, 17);

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

-- Struktura tabulky `axo_map`

CREATE TABLE `axo_map` (

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

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

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

-- Vypisuji data pro tabulku `axo_map`

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

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

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

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

-- Struktura tabulky `axo_sections`

CREATE TABLE `axo_sections` (

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

KEY `hidden_axo_sections` (`hidden`)

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

-- Vypisuji data pro tabulku `axo_sections`

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

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

(14, 'Users_Controller', 1, 'Uzivatele radnych clenu', 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`

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

(63);

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

-- Struktura tabulky `bank_fees`

CREATE TABLE `bank_fees` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `bank_fees`

(1, 39.9),

(2, 50),

(3, 70);

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

-- Struktura tabulky `contacts`

CREATE TABLE `contacts` (

`user_id` int(11) default NULL,

KEY `user_contact` (`user_id`)

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

-- Vypisuji data pro tabulku `contacts`

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

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

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

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

-- Struktura tabulky `dbdesigner4`

CREATE TABLE `dbdesigner4` (

`idmodel` int(10) unsigned NOT NULL,

PRIMARY KEY (`idmodel`,`idversion`)

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

-- Vypisuji data pro tabulku `dbdesigner4`

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

KEY `user_id` (`user_id`)

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

-- Vypisuji data pro tabulku `devices`

(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',

KEY `aro_id` (`aro_id`)

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

-- Vypisuji data pro tabulku `groups_aro_map`

(32, 1),

(22, 4),

(22, 5),

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

-- Struktura tabulky `groups_axo_map`

CREATE TABLE `groups_axo_map` (

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

KEY `axo_id` (`axo_id`)

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

-- Vypisuji data pro tabulku `groups_axo_map`

(14, 15),

(14, 16),

(14, 17),

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

-- Struktura tabulky `ifaces`

CREATE TABLE `ifaces` (

`id` int(11) NOT NULL auto_increment,

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,

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,

KEY `confirmed_by` (`confirmed_by_id`)

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

-- Vypisuji data pro tabulku `jobs`

(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),

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

-- Struktura tabulky `logging`

CREATE TABLE `logging` (

`id` int(11) NOT NULL auto_increment,

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,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `members`

(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),

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

-- Struktura tabulky `menus`

CREATE TABLE `menus` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `menus`

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

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

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

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

-- Struktura tabulky `money_transfer_bank_infos`

CREATE TABLE `money_transfer_bank_infos` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `money_transfer_bank_infos`

(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),

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

-- Struktura tabulky `money_transfers`

CREATE TABLE `money_transfers` (

`id` int(11) NOT NULL auto_increment,

KEY `to` (`destination_id`)

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

-- Vypisuji data pro tabulku `money_transfers`

(1, 1, NULL, 15, NULL, '2008-04-30 06:50:40', 'Členské+poplatky na 2008', 2960),

(2, NULL, 15, 20, 1, '2008-04-30 18:47:18', 'Bank transfer fee.', 6.9),

(3, NULL, 17, 20, 1, '2008-04-30 18:47:18', 'Bank transfer fee.', 6.9),

(674, 226, NULL, 15, NULL, '2008-02-29 06:15:11', NULL, 1440),

(675, NULL, 15, 20, 674, '2008-04-30 18:47:22', 'Bank transfer fee.', 6.9),

(676, NULL, 17, 20, 674, '2008-04-30 18:47:22', 'Bank transfer fee.', 6.9);

(677, 227, NULL, 15, NULL, '2008-02-29 06:15:10', NULL, 720),

(678, NULL, 15, 20, 677, '2008-04-30 18:47:22', 'Bank transfer fee.', 6.9),

(679, NULL, 17, 20, 677, '2008-04-30 18:47:22', 'Bank transfer fee.', 6.9),

(1341, NULL, 17, 20, 1339, '2008-04-30 18:47:25', 'Bank transfer fee.', 6.9),

(1342, 450, NULL, 15, NULL, '2008-01-29 06:12:34', 'ČLENSKÝ PŘÍSPĚVEK 1.PO.2008', 720),

(1343, NULL, 15, 20, 1342, '2008-04-30 18:47:25', 'Bank transfer fee.', 6.9);

(1344, NULL, 17, 20, 1342, '2008-04-30 18:47:25', 'Bank transfer fee.', 6.9),

(1345, 451, NULL, 15, NULL, '2008-01-29 06:12:07', NULL, 3440),

(1346, NULL, 15, 20, 1345, '2008-04-30 18:47:25', 'Bank transfer fee.', 6.9),

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

-- Struktura tabulky `phpgacl`

CREATE TABLE `phpgacl` (

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

PRIMARY KEY (`name`)

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

-- Vypisuji data pro tabulku `phpgacl`

('schema_version', '2.1'),

('version', '3.3.7');

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

-- Struktura tabulky `ports`

CREATE TABLE `ports` (

`id` int(11) NOT NULL auto_increment,

KEY `segment_port` (`segment_id`)

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

-- Vypisuji data pro tabulku `ports`

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

-- Struktura tabulky `ports_vlans`

CREATE TABLE `ports_vlans` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `ports_vlans`

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

-- Struktura tabulky `segments`

CREATE TABLE `segments` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `segments`

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

-- Struktura tabulky `subnets`

CREATE TABLE `subnets` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `subnets`

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

-- Struktura tabulky `users`

CREATE TABLE `users` (

`member_id` int(10) unsigned NOT NULL,

KEY `belogs_to_member` (`member_id`)

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

-- Vypisuji data pro tabulku `users`

(1, 1, 'Petr', NULL, 'Danek', 'Bc.', NULL, '2008-06-28', '732253134', 'kenod@kenod.net', 'admin', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea', 'member', NULL, NULL, NULL, 'all', 0, 0),

(1, 2, 'Tomas', NULL, 'Danek', NULL, NULL, '2008-10-18', '332253134', 'bob@bobovo.cz', 'bob', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea', 'user', NULL, NULL, NULL, 'all', 0, 0),

(22, 4, 'Petr', '', 'Daněk', 'Bc.', '', '1983-06-15', '732253133', 'danek@danek.cz', 'kenod', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea', 'member', NULL, NULL, 'wtf ?', 'all', 0, 0),

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

-- Struktura tabulky `vlan_ifaces`

CREATE TABLE `vlan_ifaces` (

`id` int(11) NOT NULL auto_increment,

KEY `iface_belongs_to_VLAN` (`iface_id`)

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

-- Vypisuji data pro tabulku `vlan_ifaces`

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

-- Struktura tabulky `vlans`

CREATE TABLE `vlans` (

`id` int(11) NOT NULL auto_increment,

PRIMARY KEY (`id`)

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

-- Vypisuji data pro tabulku `vlans`

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

-- Struktura tabulky `works`

CREATE TABLE `works` (

`id` int(11) NOT NULL auto_increment,

KEY `confirmed_by` (`confirmed_by_id`)

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

-- Vypisuji data pro tabulku `works`

(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', NULL, NULL, NULL);

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

-- Struktura tabulky `aro`

-- Omezení pro exportované tabulky

-- Omezení pro tabulku `accounts`

ALTER TABLE `accounts`

ADD CONSTRAINT `accounts_ibfk_1` FOREIGN KEY (`owner_id`) REFERENCES `members` (`id`);

-- Omezení pro tabulku `contacts`

ALTER TABLE `contacts`

ADD CONSTRAINT `contacts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

-- Omezení pro tabulku `money_transfers`

ALTER TABLE `money_transfers`

ADD CONSTRAINT `money_transfers_ibfk_4` FOREIGN KEY (`origin_id`) REFERENCES `accounts` (`id`),

ADD CONSTRAINT `money_transfers_ibfk_5` FOREIGN KEY (`destination_id`) REFERENCES `accounts` (`id`);

-- Omezení pro tabulku `works`

ALTER TABLE `works`

ADD CONSTRAINT `works_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),

ADD CONSTRAINT `works_ibfk_2` FOREIGN KEY (`confirmed_by_id`) REFERENCES `users` (`id`),