Changeset 265 for trunk/sql/full.sql


Ignore:
Timestamp:
Dec 9, 2009, 10:02:31 AM (15 years ago)
Author:
george
Message:
  • Přidáno: Zobrazení registrovaných podsítí.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sql/full.sql

    r221 r265  
    11-- phpMyAdmin SQL Dump
    2 -- version 3.1.5
     2-- version 3.2.3
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Středa 27. května 2009, 20:30
    7 -- Verze MySQL: 5.0.77
    8 -- Verze PHP: 5.2.6
     6-- Vygenerováno: Středa 09. prosince 2009, 07:52
     7-- Verze MySQL: 5.0.84
     8-- Verze PHP: 5.2.9
    99
    1010SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
     
    4545  PRIMARY KEY  (`Id`),
    4646  UNIQUE KEY `Shortcut` (`Shortcut`)
    47 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     47) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ;
    4848
    4949-- --------------------------------------------------------
     
    5656  `Id` int(11) NOT NULL auto_increment,
    5757  `Time` datetime NOT NULL,
     58  `Address` varchar(255) collate utf8_czech_ci NOT NULL,
    5859  `Subject` varchar(255) collate utf8_czech_ci NOT NULL,
    5960  `Content` text collate utf8_czech_ci NOT NULL,
    60   `Address` varchar(255) collate utf8_czech_ci NOT NULL,
    6161  `Headers` varchar(255) collate utf8_czech_ci NOT NULL,
    6262  `Archive` int(11) NOT NULL default '0',
    6363  PRIMARY KEY  (`Id`)
    64 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=79 ;
     64) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ;
     65
     66-- --------------------------------------------------------
     67
     68--
     69-- Struktura tabulky `File`
     70--
     71
     72CREATE TABLE IF NOT EXISTS `File` (
     73  `Id` int(11) NOT NULL auto_increment,
     74  `Name` varchar(256) collate utf8_czech_ci NOT NULL,
     75  `Size` int(11) NOT NULL,
     76  PRIMARY KEY  (`Id`)
     77) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
    6578
    6679-- --------------------------------------------------------
     
    108121  `Cash` int(11) NOT NULL default '0',
    109122  PRIMARY KEY  (`Id`)
    110 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3159 ;
     123) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1941 ;
    111124
    112125-- --------------------------------------------------------
     
    123136  `Quantity` float NOT NULL default '1',
    124137  PRIMARY KEY  (`Id`)
    125 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14700 ;
     138) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13482 ;
    126139
    127140-- --------------------------------------------------------
     
    142155  `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
    143156  PRIMARY KEY  (`Id`)
    144 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5667 ;
     157) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4455 ;
    145158
    146159-- --------------------------------------------------------
     
    172185  `Taxable` tinyint(1) NOT NULL default '1',
    173186  `Bill` int(11) NOT NULL,
    174   `Text` varchar(255) collate utf8_czech_ci NOT NULL,
     187  `Text` varchar(255) collate utf8_czech_ci NOT NULL default 'Vklad',
    175188  `Network` int(11) NOT NULL default '1',
    176189  PRIMARY KEY  (`Id`)
    177 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4248 ;
     190) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4311 ;
    178191
    179192-- --------------------------------------------------------
     
    212225  `MemberCount` int(11) NOT NULL default '0',
    213226  PRIMARY KEY  (`Id`)
    214 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=155 ;
     227) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=33 ;
    215228
    216229-- --------------------------------------------------------
     
    264277  `investment` int(11) NOT NULL,
    265278  PRIMARY KEY  (`id`)
    266 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=96 ;
     279) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=78 ;
    267280
    268281-- --------------------------------------------------------
     
    282295
    283296--
    284 -- Struktura tabulky `hosts_old`
    285 --
    286 
    287 CREATE TABLE IF NOT EXISTS `hosts_old` (
    288   `id` int(11) NOT NULL auto_increment,
    289   `name` varchar(24) collate utf8_czech_ci NOT NULL,
    290   `IP` varchar(16) collate utf8_czech_ci NOT NULL,
    291   `external_ip` varchar(16) collate utf8_czech_ci NOT NULL,
    292   `czfree_ip` varchar(16) collate utf8_czech_ci NOT NULL,
    293   `MAC` varchar(32) collate utf8_czech_ci NOT NULL,
    294   `block` int(11) NOT NULL default '0',
    295   `online` int(11) NOT NULL default '0',
    296   `user` int(11) NOT NULL default '0',
    297   `last_online` datetime NOT NULL default '0000-00-00 00:00:00',
    298   `last_share_check` date NOT NULL default '0000-00-00',
    299   `parent` int(11) NOT NULL default '0',
    300   `channel` int(11) NOT NULL default '0',
    301   `link_type` int(11) NOT NULL default '0',
    302   `pptp_password` varchar(8) collate utf8_czech_ci NOT NULL default '0',
    303   `vpn` int(11) NOT NULL default '0',
    304   `type` int(11) NOT NULL default '0',
    305   `used` int(11) NOT NULL default '1',
    306   PRIMARY KEY  (`id`)
    307 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ;
     297-- Struktura tabulky `HostedProject`
     298--
     299
     300CREATE TABLE IF NOT EXISTS `HostedProject` (
     301  `Id` int(11) NOT NULL auto_increment,
     302  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     303  `Homepage` varchar(255) collate utf8_czech_ci NOT NULL,
     304  `User` int(255) NOT NULL COMMENT 'User.Id',
     305  `TimeCreate` datetime NOT NULL,
     306  `Server` int(11) default NULL COMMENT 'NetworkDevice.Id',
     307  PRIMARY KEY  (`Id`)
     308) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
    308309
    309310-- --------------------------------------------------------
     
    325326
    326327--
    327 -- Struktura tabulky `link_types`
    328 --
    329 
    330 CREATE TABLE IF NOT EXISTS `link_types` (
    331   `id` int(11) NOT NULL auto_increment,
    332   `caption` varchar(64) collate utf8_czech_ci NOT NULL,
    333   `teoretical_speed` float NOT NULL default '0',
    334   `real_speed` float NOT NULL default '0',
    335   `color` varchar(16) collate utf8_czech_ci NOT NULL,
    336   PRIMARY KEY  (`id`)
    337 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
     328-- Struktura tabulky `Hyperlink`
     329--
     330
     331CREATE TABLE IF NOT EXISTS `Hyperlink` (
     332  `Id` int(11) NOT NULL auto_increment,
     333  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     334  `URL` varchar(255) collate utf8_czech_ci NOT NULL,
     335  `Group` int(11) NOT NULL,
     336  `IconFile` varchar(255) collate utf8_czech_ci NOT NULL,
     337  `PermissionModule` varchar(255) collate utf8_czech_ci NOT NULL,
     338  `PermissionOperation` varchar(255) collate utf8_czech_ci NOT NULL,
     339  `Enable` int(11) NOT NULL default '1',
     340  PRIMARY KEY  (`Id`),
     341  KEY `Group` (`Group`),
     342  KEY `Enable` (`Enable`)
     343) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=57 ;
     344
     345-- --------------------------------------------------------
     346
     347--
     348-- Struktura tabulky `HyperlinkGroup`
     349--
     350
     351CREATE TABLE IF NOT EXISTS `HyperlinkGroup` (
     352  `Id` int(11) NOT NULL auto_increment,
     353  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     354  PRIMARY KEY  (`Id`)
     355) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
    338356
    339357-- --------------------------------------------------------
     
    399417  `Hire` float NOT NULL default '0',
    400418  PRIMARY KEY  (`Id`)
    401 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
     419) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=103 ;
    402420
    403421-- --------------------------------------------------------
     
    417435  `Cash` float NOT NULL,
    418436  PRIMARY KEY  (`Id`)
    419 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ;
     437) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=87 ;
     438
     439-- --------------------------------------------------------
     440
     441--
     442-- Struktura tabulky `NetworkAP`
     443--
     444
     445CREATE TABLE IF NOT EXISTS `NetworkAP` (
     446  `Id` int(11) NOT NULL auto_increment,
     447  `SSID` varchar(255) collate utf8_czech_ci NOT NULL,
     448  `Frequency` int(11) NOT NULL,
     449  `ChannelWidth` int(11) NOT NULL default '20',
     450  `NetworkDevice` int(11) default NULL,
     451  PRIMARY KEY  (`Id`)
     452) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=31 ;
    420453
    421454-- --------------------------------------------------------
     
    434467  `Enabled` int(11) NOT NULL default '1',
    435468  `Period` int(11) NOT NULL default '60',
    436   `Log` text collate utf8_czech_ci NOT NULL,
     469  `Log` mediumtext collate utf8_czech_ci NOT NULL,
    437470  PRIMARY KEY  (`Id`)
    438471) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
     
    456489  PRIMARY KEY  (`Id`),
    457490  KEY `Member` (`Member`)
    458 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ;
     491) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=413 ;
    459492
    460493-- --------------------------------------------------------
     
    495528CREATE TABLE IF NOT EXISTS `NetworkDomainAlias` (
    496529  `Id` int(11) NOT NULL auto_increment,
    497   `Name` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     530  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    498531  `Target` varchar(255) collate utf8_czech_ci NOT NULL,
    499532  PRIMARY KEY  (`Id`)
     
    519552  PRIMARY KEY  (`Id`),
    520553  KEY `Device` (`Device`)
    521 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=352 ;
     554) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=440 ;
     555
     556-- --------------------------------------------------------
     557
     558--
     559-- Struktura tabulky `NetworkInterfaceStat`
     560--
     561
     562CREATE TABLE IF NOT EXISTS `NetworkInterfaceStat` (
     563  `NetworkInterface` int(11) NOT NULL default '0',
     564  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
     565  `PingCount` smallint(11) NOT NULL default '0',
     566  KEY `host_id` (`NetworkInterface`),
     567  KEY `time` (`Time`)
     568) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    522569
    523570-- --------------------------------------------------------
     
    532579  `MaxSpeed` int(11) NOT NULL,
    533580  `FullDuplex` int(11) NOT NULL default '1',
    534   `Color` varchar(6) collate utf8_czech_ci NOT NULL,
     581  `Color` varchar(6) collate utf8_czech_ci NOT NULL default 'ffffff',
    535582  PRIMARY KEY  (`Id`)
    536583) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     
    548595  `Interface2` int(11) NOT NULL,
    549596  PRIMARY KEY  (`Id`)
    550 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ;
     597) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=356 ;
     598
     599-- --------------------------------------------------------
     600
     601--
     602-- Struktura tabulky `NetworkMark`
     603--
     604
     605CREATE TABLE IF NOT EXISTS `NetworkMark` (
     606  `Id` int(11) NOT NULL auto_increment,
     607  `Comment` varchar(255) collate utf8_czech_ci NOT NULL,
     608  PRIMARY KEY  (`Id`),
     609  KEY `Comment` (`Comment`)
     610) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=575 ;
    551611
    552612-- --------------------------------------------------------
     
    571631  `ExtMask` int(11) NOT NULL default '32',
    572632  PRIMARY KEY  (`Id`)
    573 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
     633) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
    574634
    575635-- --------------------------------------------------------
     
    598658  `StockCard` int(11) NOT NULL,
    599659  PRIMARY KEY  (`id`)
    600 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=160 ;
     660) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=162 ;
    601661
    602662-- --------------------------------------------------------
     
    637697  KEY `category` (`Category`),
    638698  KEY `date` (`Date`)
    639 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30865 ;
     699) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30935 ;
    640700
    641701-- --------------------------------------------------------
     
    650710  `Permission` int(11) NOT NULL default '0',
    651711  PRIMARY KEY  (`Id`)
    652 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ;
     712) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
     713
     714-- --------------------------------------------------------
     715
     716--
     717-- Struktura tabulky `Panel`
     718--
     719
     720CREATE TABLE IF NOT EXISTS `Panel` (
     721  `Id` int(11) NOT NULL auto_increment,
     722  `Module` varchar(255) collate utf8_czech_ci NOT NULL,
     723  `Parameters` varchar(255) collate utf8_czech_ci NOT NULL,
     724  `Order` int(11) NOT NULL,
     725  `PanelColumn` int(11) NOT NULL,
     726  PRIMARY KEY  (`Id`),
     727  KEY `PanelColumn` (`PanelColumn`)
     728) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
     729
     730-- --------------------------------------------------------
     731
     732--
     733-- Struktura tabulky `PanelColumn`
     734--
     735
     736CREATE TABLE IF NOT EXISTS `PanelColumn` (
     737  `Id` int(11) NOT NULL auto_increment,
     738  `Width` varchar(255) collate utf8_czech_ci NOT NULL,
     739  PRIMARY KEY  (`Id`)
     740) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
    653741
    654742-- --------------------------------------------------------
     
    689777  `ItemId` int(11) NOT NULL default '0',
    690778  PRIMARY KEY  (`Id`)
    691 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=38 ;
     779) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=40 ;
    692780
    693781-- --------------------------------------------------------
     
    701789  `GroupOrOperation` int(11) NOT NULL default '0',
    702790  `Type` enum('Group','Operation') collate utf8_czech_ci NOT NULL default 'Group'
    703 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    704 
    705 -- --------------------------------------------------------
    706 
    707 --
    708 -- Struktura tabulky `stat_hosts`
    709 --
    710 
    711 CREATE TABLE IF NOT EXISTS `stat_hosts` (
    712   `host_id` int(11) NOT NULL default '0',
    713   `time` datetime NOT NULL default '0000-00-00 00:00:00',
    714   `count` int(11) NOT NULL default '0',
    715   KEY `host_id` (`host_id`),
    716   KEY `time` (`time`)
    717791) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    718792
     
    750824  `Note` varchar(255) collate utf8_czech_ci NOT NULL,
    751825  PRIMARY KEY  (`Id`)
    752 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=112 ;
     826) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=117 ;
    753827
    754828-- --------------------------------------------------------
     
    762836  `UpdateTime` datetime NOT NULL default '0000-00-00 00:00:00',
    763837  `Notice` varchar(255) collate utf8_czech_ci NOT NULL default '',
     838  `Photo` int(11) NOT NULL,
    764839  PRIMARY KEY  (`Subject`)
    765840) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     
    768843
    769844--
    770 -- Struktura tabulky `SubjectOpenTimeInterval`
    771 --
    772 
    773 CREATE TABLE IF NOT EXISTS `SubjectOpenTimeInterval` (
    774   `Id` int(11) NOT NULL auto_increment,
    775   `Subject` int(11) NOT NULL default '0',
    776   `DayOfWeek` int(11) NOT NULL default '0',
    777   `OpenTime` datetime NOT NULL default '0000-00-00 00:00:00',
    778   `CloseTime` datetime NOT NULL default '0000-00-00 00:00:00',
    779   PRIMARY KEY  (`Id`)
    780 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=50 ;
    781 
    782 -- --------------------------------------------------------
    783 
    784 --
    785 -- Struktura tabulky `tkr`
    786 --
    787 
    788 CREATE TABLE IF NOT EXISTS `tkr` (
    789   `id` int(11) NOT NULL auto_increment,
    790   `name` varchar(16) collate utf8_czech_ci NOT NULL,
    791   `freq` int(11) NOT NULL default '0',
    792   `norm` varchar(8) collate utf8_czech_ci NOT NULL,
    793   `www` varchar(255) collate utf8_czech_ci NOT NULL,
    794   `lang` varchar(32) collate utf8_czech_ci NOT NULL,
    795   `shortname` varchar(16) collate utf8_czech_ci NOT NULL,
    796   PRIMARY KEY  (`id`)
     845-- Struktura tabulky `SubjectOpenTimeDay`
     846--
     847
     848CREATE TABLE IF NOT EXISTS `SubjectOpenTimeDay` (
     849  `Subject` int(11) NOT NULL,
     850  `Day` int(11) NOT NULL,
     851  `Open1` int(11) NOT NULL,
     852  `Close1` int(11) NOT NULL,
     853  `Open2` int(11) NOT NULL,
     854  `Close2` int(11) NOT NULL,
     855  KEY `Subject` (`Subject`)
     856) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     857
     858-- --------------------------------------------------------
     859
     860--
     861-- Struktura tabulky `Task`
     862--
     863
     864CREATE TABLE IF NOT EXISTS `Task` (
     865  `Id` int(11) NOT NULL auto_increment,
     866  `TimeCreate` datetime NOT NULL,
     867  `TimeFinished` datetime default NULL,
     868  `Description` text collate utf8_czech_ci NOT NULL,
     869  `Conclusion` text collate utf8_czech_ci NOT NULL,
     870  PRIMARY KEY  (`Id`),
     871  KEY `TimeCreate` (`TimeCreate`),
     872  KEY `TimeFinished` (`TimeFinished`)
     873) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ;
     874
     875-- --------------------------------------------------------
     876
     877--
     878-- Struktura tabulky `TKR`
     879--
     880
     881CREATE TABLE IF NOT EXISTS `TKR` (
     882  `Id` int(11) NOT NULL auto_increment,
     883  `Name` varchar(16) collate utf8_czech_ci NOT NULL,
     884  `Frequency` int(11) NOT NULL default '0',
     885  `Norm` varchar(8) collate utf8_czech_ci NOT NULL,
     886  `Homepage` varchar(255) collate utf8_czech_ci NOT NULL,
     887  `Language` varchar(32) collate utf8_czech_ci NOT NULL,
     888  `ShortName` varchar(16) collate utf8_czech_ci NOT NULL,
     889  PRIMARY KEY  (`Id`)
    797890) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25 ;
    798891
     
    820913  UNIQUE KEY `Name` (`Login`),
    821914  UNIQUE KEY `Nick` (`Name`)
    822 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=107 ;
     915) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=111 ;
    823916
    824917-- --------------------------------------------------------
     
    839932  PRIMARY KEY  (`Id`),
    840933  KEY `User` (`User`)
    841 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3571 ;
    842 
    843 -- --------------------------------------------------------
    844 
    845 --
    846 -- Struktura tabulky `users_old`
    847 --
    848 
    849 CREATE TABLE IF NOT EXISTS `users_old` (
    850   `id` int(11) NOT NULL auto_increment,
    851   `first_name` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL default '',
    852   `second_name` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL default '',
    853   `email` varchar(128) character set latin2 collate latin2_czech_cs NOT NULL default '',
    854   `phone` int(9) NOT NULL default '0',
    855   `icq` int(11) NOT NULL default '0',
    856   `password` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '',
    857   `nick` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '',
    858   `role` int(11) NOT NULL default '0',
    859   `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
    860   `family` int(11) NOT NULL default '0',
    861   `notice` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '',
    862   `PositionX` int(11) NOT NULL default '0',
    863   `PositionY` int(11) NOT NULL default '0',
    864   `network_device` int(11) NOT NULL default '0',
    865   `cash` int(11) NOT NULL default '0',
    866   `network_segment` int(11) NOT NULL default '0',
    867   `inet` int(11) NOT NULL default '0',
    868   `hw` int(11) NOT NULL default '1',
    869   `overheads` int(11) NOT NULL default '1',
    870   `monthly` int(11) NOT NULL default '0',
    871   `plus` int(11) NOT NULL default '0',
    872   `consumption` int(11) NOT NULL default '0',
    873   `inet_hw` int(11) NOT NULL default '0',
    874   `membership_date` date NOT NULL default '0000-00-00',
    875   `inet_tarif_now` int(11) NOT NULL default '2',
    876   `inet_tarif_next` int(11) NOT NULL default '2',
    877   `monthly_inet` int(11) NOT NULL default '0',
    878   `subject_name` varchar(128) collate utf8_czech_ci NOT NULL default '',
    879   `street` varchar(255) collate utf8_czech_ci NOT NULL default '',
    880   `town` varchar(64) collate utf8_czech_ci NOT NULL default '',
    881   `psc` int(11) NOT NULL default '0',
    882   `ico` int(11) NOT NULL default '0',
    883   `dic` varchar(32) character set latin1 NOT NULL default '',
    884   `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') character set latin1 NOT NULL default 'monthly',
    885   PRIMARY KEY  (`id`),
    886   UNIQUE KEY `nick` (`nick`)
    887 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ;
     934) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25044 ;
     935
     936--
     937-- Omezení pro exportované tabulky
     938--
     939
     940--
     941-- Omezení pro tabulku `Hyperlink`
     942--
     943ALTER TABLE `Hyperlink`
     944  ADD CONSTRAINT `Hyperlink_ibfk_1` FOREIGN KEY (`Group`) REFERENCES `HyperlinkGroup` (`Id`);
     945
     946--
     947-- Omezení pro tabulku `Panel`
     948--
     949ALTER TABLE `Panel`
     950  ADD CONSTRAINT `Panel_ibfk_1` FOREIGN KEY (`PanelColumn`) REFERENCES `PanelColumn` (`Id`);
Note: See TracChangeset for help on using the changeset viewer.