- Timestamp:
- May 27, 2009, 9:05:21 PM (16 years ago)
- Location:
- trunk
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Readme.txt
r202 r221 19 19 finance/doklady - účetní doklady 20 20 aktuality/uploads - přílohy aktualit 21 galerie - fotogalerie obrázků 21 22 22 23 … … 31 32 32 33 Nutno nainstalovat balík htmldoc. Na Fedoře pomocí yum install htmldoc. 34 -
trunk/aktuality/news.php
r196 r221 21 21 $DbResult = $Database->select('NewsCategory', '*', 'Id='.$Category); 22 22 $Row = $DbResult->fetch_array(); 23 $Output = '<table c ellspacing="0" cellpadding="0" border="0" width="100%" style="font-size: small; padding-bottom: 5px;"><tr>';23 $Output = '<table class="NewsBaseTable"><tr>'; 24 24 $Output .= '<td>'.$Row['Caption'].'</td><td align="right">'; 25 25 $Output .= '<a href="aktuality/index.php?category='.$Category.'">Zobrazit všechny aktuality</a> '; … … 35 35 if($DbResult->num_rows > 0) 36 36 { 37 $Output .= '<table c ellspacing="0" width="100%" class="NewsTable">';37 $Output .= '<table class="NewsTable">'; 38 38 while($Row = $DbResult->fetch_array()) 39 39 { 40 40 if($Row['Name'] == '') $Author = $Row['Author']; 41 41 else $Author = $Row['Name']; 42 $Output .= '<tr><td onclick="window.location=\'aktuality/index.php?action=view&id='.$Row['Id'].'\'" onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table c ellspacing="0" cellpadding="0" style="padding: 0px; margin: 0px; font-size: small; color: red;" width="100%"><tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['Title'].'</strong></td><td align="right" style="font-size: '.$FontSize.'pt">'.$Author.' ('.HumanDate($Row['Date']).')</td></tr></table>';42 $Output .= '<tr><td onclick="window.location=\'aktuality/index.php?action=view&id='.$Row['Id'].'\'" onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table class="NewsItemFrame"><tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['Title'].'</strong></td><td align="right" style="font-size: '.$FontSize.'pt">'.$Author.' ('.HumanDate($Row['Date']).')</td></tr></table>'; 43 43 $Output .= '<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['Content']; 44 44 … … 58 58 $Output .= '</table>'; 59 59 } 60 $Output .= '</td></tr></table>' ."\n\n";60 $Output .= '</td></tr></table>'; 61 61 return($Output); 62 62 } … … 86 86 function Show() 87 87 { 88 $Output = '<div class="PanelTitle"><span class="MenuItem">Aktuálně</span>< div class="MenuItem2"><a href="?Action=CustomizeNews">Upravit</a></div></div>';88 $Output = '<div class="PanelTitle"><span class="MenuItem">Aktuálně</span><span class="MenuItem2"><a href="?Action=CustomizeNews">Upravit</a></span></div>'; 89 89 90 90 $UploadedFilesFolder = 'aktuality/uploads/'; -
trunk/finance/tarify.php
r204 r221 35 35 $Finance = &$this->System->Modules['Finance']; 36 36 $Output = 'Počet členů s internetovým připojením: <strong>'.$Finance->InternetUsers.'</strong><br /><br />'; 37 /* 37 38 $Output .= '<table><tr><td valign="top">'; 38 39 39 $Finance->LoadMonthParameters(0); 40 40 $Output .= '<strong>Stav pro aktuální měsíc:</strong><br />'; … … 43 43 $Output .= '<br /></td></tr><tr><td valign="top">'; 44 44 45 $Output .= '</td></tr></table>'; 46 */ 45 47 $Finance->LoadMonthParameters(1); 46 $Output .= '<strong> Stav pro další měsíc:</strong><br />';48 $Output .= '<strong>Tabulka tarifů:</strong><br />'; 47 49 $Output .= $this->TariffTable(); 48 49 $Output .= '</td></tr></table>';50 50 51 51 $Output .= '<br /><strong>Doplňující informace:</strong><br />'; … … 54 54 Skutečná rychlost může mírně kolísat kolem těchto hodnot, jelikož řízení toku není dokonalé.<br /> 55 55 Agregační pomněr je poměr mezi minimální garantovanou rychlostí a maximální dosažitelnou rychlostí. Ukazuje, jak moc je linka sdílena a jak hodně může rychlost kolísat. Při posuzování kvality linky je toto také důležitý ukazatel.<br /> 56 Cenové jednotky vystihují jakým podílem se poplatek za tarif podílí na celkové placené sumě.<br />57 56 Počet podílníků znamená počet uživatelů platících daný tarif.<br /> 58 Údaj celkem cenových jednotek je součin počtu podílníků a cenových jednotek. Vystihuje podíl všech uživatelů v daném tarifu na celkové placené sumě.<br /> 59 Cena udává rozpočtenou celkovou cenu na jednotlivé tarify podle cenových jednotek.<br /> 57 Cena udává stanovenou cenu pro jednotlivé tarify. Je uplatněn motivační princip, že při dvojnásobné rychlosti cena stoupá o 1,5 násobek. V ceně je zahrnut pevný základ 50 Kč za údržbu sítě.<br /> 60 58 Sloupec vybráno dává informaci, kolik se v kterém tarifu vybralo peněz na placení společné linky.<br /><br />'; 61 $Output .= 'Tabulka Stav pro aktuální měsíc se aktualizuje první den v měsíci při odečtení peněz z účtů dle tabulky na příští měsíc.<br />';62 59 63 $Output .= '<br /> Změnu tarifu na další měsíc oznamujte prozatím na email robie@centrum.cz<br />';60 $Output .= '<br />Tarif na další období si lze nastavit po přihlášení do systému pomocí nastavení domácnosti přes pravé užifatelské menu.<br />'; 64 61 $Output .= '<a href="http://centrala.zdechov.net/forum/viewtopic.php?t=50">Diskuse</a><br />'; 65 62 return($Output); -
trunk/sql/full.sql
r181 r221 1 1 -- phpMyAdmin SQL Dump 2 -- version 3.1. 32 -- version 3.1.5 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Úterý 24. března 2009, 22:517 -- Verze MySQL: 5.0. 516 -- Vygenerováno: Středa 27. května 2009, 20:30 7 -- Verze MySQL: 5.0.77 8 8 -- Verze PHP: 5.2.6 9 9 … … 11 11 12 12 -- 13 -- Databáze: ` is`13 -- Databáze: `centrala` 14 14 -- 15 15 … … 22 22 CREATE TABLE IF NOT EXISTS `ChatHistory` ( 23 23 `Id` int(11) NOT NULL auto_increment, 24 `Nick` varchar(64) NOT NULL default '',25 `Text` text NOT NULL,24 `Nick` varchar(64) collate utf8_czech_ci NOT NULL, 25 `Text` text collate utf8_czech_ci NOT NULL, 26 26 `Time` datetime NOT NULL default '0000-00-00 00:00:00', 27 27 `Color` int(11) NOT NULL default '0', 28 `RoomName` varchar(32) NOT NULL default '',28 `RoomName` varchar(32) collate utf8_czech_ci NOT NULL, 29 29 `RoomType` int(11) NOT NULL default '0', 30 `Host` varchar(255) NOT NULL default '',31 PRIMARY KEY (`Id`) 32 ) ENGINE=MyISAM DEFAULT CHARSET= latin2AUTO_INCREMENT=528576 ;30 `Host` varchar(255) collate utf8_czech_ci NOT NULL, 31 PRIMARY KEY (`Id`) 32 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=528576 ; 33 33 34 34 -- -------------------------------------------------------- … … 40 40 CREATE TABLE IF NOT EXISTS `DocumentLine` ( 41 41 `Id` int(11) NOT NULL auto_increment, 42 `Name` varchar(255) c haracter set utf8 collate utf8_czech_ci NOT NULL,43 `Shortcut` varchar(16) c haracter set utf8 collate utf8_czech_ci NOT NULL,42 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 43 `Shortcut` varchar(16) collate utf8_czech_ci NOT NULL, 44 44 `NextNumber` int(11) NOT NULL, 45 45 PRIMARY KEY (`Id`), 46 46 UNIQUE KEY `Shortcut` (`Shortcut`) 47 ) ENGINE=MyISAM DEFAULT CHARSET= latin1 AUTO_INCREMENT=7;48 49 -- -------------------------------------------------------- 50 51 -- 52 -- Struktura tabulky ` FinanceAdvances_old`53 -- 54 55 CREATE TABLE IF NOT EXISTS ` FinanceAdvances_old` (56 `Id` int(11) NOT NULL auto_increment, 57 ` Direction` enum('In','Out') collate utf8_czech_ci NOT NULL default 'In',58 `Subject` int(11) NOT NULL default '0',59 ` Value` float NOT NULL default '0',60 ` TimeCreation` datetime NOT NULL default '0000-00-00 00:00:00',61 ` TimePass` datetime NOT NULL default '0000-00-00 00:00:00',62 ` CashFlowId` int(11) NOT NULL default '0',63 PRIMARY KEY (`Id`) 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 1466;47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; 48 49 -- -------------------------------------------------------- 50 51 -- 52 -- Struktura tabulky `EmailQueue` 53 -- 54 55 CREATE TABLE IF NOT EXISTS `EmailQueue` ( 56 `Id` int(11) NOT NULL auto_increment, 57 `Time` datetime NOT NULL, 58 `Subject` varchar(255) collate utf8_czech_ci NOT NULL, 59 `Content` text collate utf8_czech_ci NOT NULL, 60 `Address` varchar(255) collate utf8_czech_ci NOT NULL, 61 `Headers` varchar(255) collate utf8_czech_ci NOT NULL, 62 `Archive` int(11) NOT NULL default '0', 63 PRIMARY KEY (`Id`) 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=79 ; 65 65 66 66 -- -------------------------------------------------------- … … 81 81 82 82 -- 83 -- Struktura tabulky `FinanceBillingPeriod` 84 -- 85 86 CREATE TABLE IF NOT EXISTS `FinanceBillingPeriod` ( 87 `Id` int(11) NOT NULL auto_increment, 88 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 89 `MonthCount` int(11) NOT NULL, 90 PRIMARY KEY (`Id`) 91 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 92 93 -- -------------------------------------------------------- 94 95 -- 83 96 -- Struktura tabulky `FinanceBills` 84 97 -- … … 91 104 `TimeCreate` datetime NOT NULL default '0000-00-00 00:00:00', 92 105 `TimeDue` datetime NOT NULL default '0000-00-00 00:00:00', 93 `BillCode` varchar(32) collate latin2_czech_cs NOT NULL, 94 `Type` enum('invoice','income') collate latin2_czech_cs NOT NULL, 95 PRIMARY KEY (`Id`) 96 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1707 ; 106 `BillCode` varchar(32) collate utf8_czech_ci NOT NULL, 107 `Type` enum('invoice','income') collate utf8_czech_ci NOT NULL, 108 `Cash` int(11) NOT NULL default '0', 109 PRIMARY KEY (`Id`) 110 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3159 ; 97 111 98 112 -- -------------------------------------------------------- … … 105 119 `Id` int(11) NOT NULL auto_increment, 106 120 `Bill` int(11) NOT NULL default '0', 107 `Description` varchar(255) collate latin2_czech_csNOT NULL,121 `Description` varchar(255) collate utf8_czech_ci NOT NULL, 108 122 `Price` float NOT NULL default '0', 109 123 `Quantity` float NOT NULL default '1', 110 124 PRIMARY KEY (`Id`) 111 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=13248 ; 112 113 -- -------------------------------------------------------- 114 115 -- 116 -- Struktura tabulky `FinanceCashFlow_old` 117 -- 118 119 CREATE TABLE IF NOT EXISTS `FinanceCashFlow_old` ( 120 `Id` int(11) NOT NULL auto_increment, 121 `BillCode` varchar(16) collate utf8_czech_ci NOT NULL, 122 `Subject` int(11) NOT NULL default '0', 123 `Text` varchar(255) collate utf8_czech_ci NOT NULL default '', 124 `Time` datetime NOT NULL default '0000-00-00 00:00:00', 125 `Taxable` tinyint(1) NOT NULL default '0', 126 `Cash` tinyint(1) NOT NULL default '0', 127 `Value` float NOT NULL default '0', 128 `Bill` int(11) NOT NULL default '0', 129 PRIMARY KEY (`Id`) 130 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=434 ; 125 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14700 ; 131 126 132 127 -- -------------------------------------------------------- … … 147 142 `Text` varchar(255) collate utf8_czech_ci NOT NULL default '', 148 143 PRIMARY KEY (`Id`) 149 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 4183;144 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5667 ; 150 145 151 146 -- -------------------------------------------------------- … … 175 170 `Value` float NOT NULL, 176 171 `BillCode` varchar(32) collate utf8_czech_ci NOT NULL, 177 `Taxable` tinyint(1) NOT NULL ,172 `Taxable` tinyint(1) NOT NULL default '1', 178 173 `Bill` int(11) NOT NULL, 179 174 `Text` varchar(255) collate utf8_czech_ci NOT NULL, 180 175 `Network` int(11) NOT NULL default '1', 181 176 PRIMARY KEY (`Id`) 182 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=42 05;177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4248 ; 183 178 184 179 -- -------------------------------------------------------- … … 198 193 PRIMARY KEY (`Id`) 199 194 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 195 196 -- -------------------------------------------------------- 197 198 -- 199 -- Struktura tabulky `FinanceTariff` 200 -- 201 202 CREATE TABLE IF NOT EXISTS `FinanceTariff` ( 203 `Id` int(11) NOT NULL auto_increment, 204 `Tariff` int(11) NOT NULL default '0', 205 `Period` int(11) NOT NULL default '0', 206 `Name` varchar(32) collate utf8_czech_ci NOT NULL, 207 `Group` int(11) NOT NULL default '0', 208 `SpeedMin` int(11) NOT NULL default '0', 209 `SpeedMax` int(11) NOT NULL default '0', 210 `UploadAsymmetry` int(11) NOT NULL default '1', 211 `Price` int(11) NOT NULL default '0', 212 `MemberCount` int(11) NOT NULL default '0', 213 PRIMARY KEY (`Id`) 214 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=155 ; 200 215 201 216 -- -------------------------------------------------------- … … 215 230 `BaseTariffPrice` int(11) NOT NULL default '0', 216 231 `TopTariffPrice` int(11) NOT NULL default '0' 217 ) ENGINE=MyISAM DEFAULT CHARSET= latin1;232 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 218 233 219 234 -- -------------------------------------------------------- … … 225 240 CREATE TABLE IF NOT EXISTS `finance_groups` ( 226 241 `Id` int(11) NOT NULL auto_increment, 227 `Description` varchar(128) c haracter set utf8 collate utf8_czech_ci NOT NULL default '',228 PRIMARY KEY (`Id`) 229 ) ENGINE=MyISAM DEFAULT CHARSET= latin2 COLLATE=latin2_czech_csAUTO_INCREMENT=4 ;242 `Description` varchar(128) collate utf8_czech_ci NOT NULL default '', 243 PRIMARY KEY (`Id`) 244 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 230 245 231 246 -- -------------------------------------------------------- … … 249 264 `investment` int(11) NOT NULL, 250 265 PRIMARY KEY (`id`) 251 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ; 252 253 -- -------------------------------------------------------- 254 255 -- 256 -- Struktura tabulky `finance_operations_old` 257 -- 258 259 CREATE TABLE IF NOT EXISTS `finance_operations_old` ( 266 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=96 ; 267 268 -- -------------------------------------------------------- 269 270 -- 271 -- Struktura tabulky `History` 272 -- 273 274 CREATE TABLE IF NOT EXISTS `History` ( 275 `Id` int(11) NOT NULL auto_increment, 276 `Date` date NOT NULL, 277 `Text` text collate utf8_czech_ci NOT NULL, 278 PRIMARY KEY (`Id`) 279 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=21 ; 280 281 -- -------------------------------------------------------- 282 283 -- 284 -- Struktura tabulky `hosts_old` 285 -- 286 287 CREATE TABLE IF NOT EXISTS `hosts_old` ( 260 288 `id` int(11) NOT NULL auto_increment, 261 `user` int(11) NOT NULL default '0', 262 `money` int(11) NOT NULL default '0', 263 `type` int(11) NOT NULL default '0', 264 `date` date NOT NULL default '0000-00-00', 265 `comment` varchar(255) collate latin2_czech_cs NOT NULL default '', 266 `bill_id` int(11) NOT NULL default '0', 267 `group` int(11) NOT NULL default '1', 268 `cash` int(11) NOT NULL default '0', 269 `BillCode` varchar(16) collate latin2_czech_cs NOT NULL, 270 `Network` int(11) NOT NULL default '1', 271 `Taxable` int(11) NOT NULL default '1', 272 `Invoice` int(11) NOT NULL, 273 `Source` int(11) NOT NULL, 274 `Destination` int(11) NOT NULL, 275 PRIMARY KEY (`id`) 276 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=4158 ; 277 278 -- -------------------------------------------------------- 279 280 -- 281 -- Struktura tabulky `finance_tariffs` 282 -- 283 284 CREATE TABLE IF NOT EXISTS `finance_tariffs` ( 285 `id` int(11) NOT NULL default '0', 286 `period` int(11) NOT NULL default '0', 287 `name` varchar(32) collate latin2_czech_cs NOT NULL default '', 288 `speed_factor` float NOT NULL default '0', 289 `price_units` float NOT NULL default '0', 290 `group_id` int(11) NOT NULL default '0', 291 `min_speed` int(11) NOT NULL default '0', 292 `max_speed` int(11) NOT NULL default '0', 293 `price` int(11) NOT NULL default '0' 294 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs; 295 296 -- -------------------------------------------------------- 297 298 -- 299 -- Struktura tabulky `hosts` 300 -- 301 302 CREATE TABLE IF NOT EXISTS `hosts` ( 303 `id` int(11) NOT NULL auto_increment, 304 `name` varchar(24) character set latin2 collate latin2_czech_cs NOT NULL default '', 305 `IP` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '', 306 `external_ip` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '', 307 `czfree_ip` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '', 308 `MAC` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '', 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, 309 294 `block` int(11) NOT NULL default '0', 310 295 `online` int(11) NOT NULL default '0', … … 315 300 `channel` int(11) NOT NULL default '0', 316 301 `link_type` int(11) NOT NULL default '0', 317 `pptp_password` varchar(8) character set latin2 collate latin2_czech_cs NOT NULL default '0', 318 `show_online` int(11) NOT NULL default '1', 302 `pptp_password` varchar(8) collate utf8_czech_ci NOT NULL default '0', 319 303 `vpn` int(11) NOT NULL default '0', 320 304 `type` int(11) NOT NULL default '0', 321 305 `used` int(11) NOT NULL default '1', 322 306 PRIMARY KEY (`id`) 323 ) ENGINE=MyISAM DEFAULT CHARSET= latin1 AUTO_INCREMENT=348;307 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ; 324 308 325 309 -- -------------------------------------------------------- … … 336 320 `last` int(11) NOT NULL default '0', 337 321 PRIMARY KEY (`host`) 338 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs; 339 340 -- -------------------------------------------------------- 341 342 -- 343 -- Struktura tabulky `known_hosts` 344 -- 345 346 CREATE TABLE IF NOT EXISTS `known_hosts` ( 347 `IP` varchar(16) NOT NULL default '', 348 `hostname` varchar(16) NOT NULL default '', 349 `interface` varchar(8) NOT NULL default '', 350 `time` datetime NOT NULL default '0000-00-00 00:00:00', 351 `MAC` varchar(64) NOT NULL default '', 352 `traffic_total_up` bigint(11) NOT NULL default '0', 353 `traffic_total_down` bigint(11) NOT NULL default '0', 354 `traffic_avg_up` int(11) NOT NULL default '0', 355 `traffic_avg_down` int(11) NOT NULL default '0', 356 `port` int(11) NOT NULL default '0', 357 `protocol` varchar(8) NOT NULL default '', 358 PRIMARY KEY (`IP`) 359 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 360 361 -- -------------------------------------------------------- 362 363 -- 364 -- Struktura tabulky `known_hosts_ports` 365 -- 366 367 CREATE TABLE IF NOT EXISTS `known_hosts_ports` ( 368 `host` varchar(16) NOT NULL default '', 369 `port` int(11) NOT NULL default '0', 370 `down` int(11) NOT NULL default '0', 371 `up` int(11) NOT NULL default '0', 372 `total_down` int(11) NOT NULL default '0', 373 `total_up` int(11) NOT NULL default '0' 374 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 322 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 375 323 376 324 -- -------------------------------------------------------- … … 382 330 CREATE TABLE IF NOT EXISTS `link_types` ( 383 331 `id` int(11) NOT NULL auto_increment, 384 `caption` varchar(64) NOT NULL default '',332 `caption` varchar(64) collate utf8_czech_ci NOT NULL, 385 333 `teoretical_speed` float NOT NULL default '0', 386 334 `real_speed` float NOT NULL default '0', 387 `color` varchar(16) NOT NULL default '',335 `color` varchar(16) collate utf8_czech_ci NOT NULL, 388 336 PRIMARY KEY (`id`) 389 ) ENGINE=MyISAM DEFAULT CHARSET= latin1AUTO_INCREMENT=6 ;337 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 390 338 391 339 -- -------------------------------------------------------- … … 445 393 `InternetTariffNextMonth` int(11) NOT NULL, 446 394 `GPS` int(11) NOT NULL, 447 `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') collate utf8_czech_ci NOT NULL default 'monthly',395 `BillingPeriod` int(11) NOT NULL default '2', 448 396 `NetworkSegment` int(11) NOT NULL, 397 `BillingPeriodNext` int(11) NOT NULL default '2', 398 `BillingPeriodLastDate` date NOT NULL, 399 `Hire` float NOT NULL default '0', 449 400 PRIMARY KEY (`Id`) 450 401 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ; … … 471 422 472 423 -- 424 -- Struktura tabulky `NetworkConfiguration` 425 -- 426 427 CREATE TABLE IF NOT EXISTS `NetworkConfiguration` ( 428 `Id` int(11) NOT NULL auto_increment, 429 `Caption` varchar(255) collate utf8_czech_ci NOT NULL, 430 `Execute` varchar(255) collate utf8_czech_ci NOT NULL, 431 `Changed` int(11) NOT NULL default '0', 432 `LastTime` datetime NOT NULL default '0000-00-00 00:00:00', 433 `ExecutionTime` int(11) NOT NULL, 434 `Enabled` int(11) NOT NULL default '1', 435 `Period` int(11) NOT NULL default '60', 436 `Log` text collate utf8_czech_ci NOT NULL, 437 PRIMARY KEY (`Id`) 438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ; 439 440 -- -------------------------------------------------------- 441 442 -- 443 -- Struktura tabulky `NetworkDevice` 444 -- 445 446 CREATE TABLE IF NOT EXISTS `NetworkDevice` ( 447 `Id` int(11) NOT NULL auto_increment, 448 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 449 `Member` int(11) NOT NULL, 450 `Type` int(11) NOT NULL, 451 `PositionLatitude` double NOT NULL default '0', 452 `PositionLongitude` double NOT NULL default '0', 453 `Used` int(11) NOT NULL default '1', 454 `Online` int(11) NOT NULL default '0', 455 `LastOnline` datetime NOT NULL, 456 PRIMARY KEY (`Id`), 457 KEY `Member` (`Member`) 458 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ; 459 460 -- -------------------------------------------------------- 461 462 -- 473 463 -- Struktura tabulky `NetworkDeviceHistory` 474 464 -- … … 486 476 487 477 -- 478 -- Struktura tabulky `NetworkDeviceType` 479 -- 480 481 CREATE TABLE IF NOT EXISTS `NetworkDeviceType` ( 482 `Id` int(11) NOT NULL auto_increment, 483 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 484 `ShowOnline` int(11) NOT NULL default '0', 485 `IconName` varchar(255) collate utf8_czech_ci NOT NULL, 486 PRIMARY KEY (`Id`) 487 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ; 488 489 -- -------------------------------------------------------- 490 491 -- 492 -- Struktura tabulky `NetworkDomainAlias` 493 -- 494 495 CREATE TABLE IF NOT EXISTS `NetworkDomainAlias` ( 496 `Id` int(11) NOT NULL auto_increment, 497 `Name` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 498 `Target` varchar(255) collate utf8_czech_ci NOT NULL, 499 PRIMARY KEY (`Id`) 500 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=20 ; 501 502 -- -------------------------------------------------------- 503 504 -- 505 -- Struktura tabulky `NetworkInterface` 506 -- 507 508 CREATE TABLE IF NOT EXISTS `NetworkInterface` ( 509 `Id` int(11) NOT NULL auto_increment, 510 `Name` varchar(16) collate utf8_czech_ci NOT NULL, 511 `Type` int(11) NOT NULL, 512 `MAC` varchar(17) collate utf8_czech_ci NOT NULL, 513 `LocalIP` varchar(16) collate utf8_czech_ci NOT NULL, 514 `ExternalIP` varchar(16) collate utf8_czech_ci NOT NULL, 515 `CZFreeIP` varchar(16) collate utf8_czech_ci NOT NULL, 516 `Device` int(11) NOT NULL, 517 `Online` int(11) NOT NULL default '0', 518 `LastOnline` datetime NOT NULL, 519 PRIMARY KEY (`Id`), 520 KEY `Device` (`Device`) 521 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=352 ; 522 523 -- -------------------------------------------------------- 524 525 -- 526 -- Struktura tabulky `NetworkInterfaceType` 527 -- 528 529 CREATE TABLE IF NOT EXISTS `NetworkInterfaceType` ( 530 `Id` int(11) NOT NULL auto_increment, 531 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 532 `MaxSpeed` int(11) NOT NULL, 533 `FullDuplex` int(11) NOT NULL default '1', 534 `Color` varchar(6) collate utf8_czech_ci NOT NULL, 535 PRIMARY KEY (`Id`) 536 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; 537 538 -- -------------------------------------------------------- 539 540 -- 541 -- Struktura tabulky `NetworkLink` 542 -- 543 544 CREATE TABLE IF NOT EXISTS `NetworkLink` ( 545 `Id` int(11) NOT NULL auto_increment, 546 `Type` int(11) NOT NULL, 547 `Interface1` int(11) NOT NULL, 548 `Interface2` int(11) NOT NULL, 549 PRIMARY KEY (`Id`) 550 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ; 551 552 -- -------------------------------------------------------- 553 554 -- 488 555 -- Struktura tabulky `NetworkSubnet` 489 556 -- … … 491 558 CREATE TABLE IF NOT EXISTS `NetworkSubnet` ( 492 559 `Id` int(11) NOT NULL auto_increment, 560 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 493 561 `AddressRange` varchar(255) collate utf8_czech_ci NOT NULL, 494 562 `Mask` int(11) NOT NULL, … … 499 567 `Domain` varchar(255) collate utf8_czech_ci NOT NULL, 500 568 `NTP` varchar(255) collate utf8_czech_ci NOT NULL, 501 PRIMARY KEY (`Id`) 502 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; 569 `Member` int(11) NOT NULL default '0', 570 `ExtAddressRange` varchar(255) collate utf8_czech_ci NOT NULL, 571 `ExtMask` int(11) NOT NULL default '32', 572 PRIMARY KEY (`Id`) 573 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ; 503 574 504 575 -- -------------------------------------------------------- … … 510 581 CREATE TABLE IF NOT EXISTS `network_devices` ( 511 582 `id` int(11) NOT NULL auto_increment, 512 `name` varchar(128) NOT NULL default '',583 `name` varchar(128) collate utf8_czech_ci NOT NULL, 513 584 `price` int(11) NOT NULL default '0', 514 585 `count` int(11) NOT NULL default '1', … … 518 589 `consumption` int(11) NOT NULL default '0', 519 590 `user` int(11) NOT NULL default '0', 520 `info` text NOT NULL,591 `info` text collate utf8_czech_ci NOT NULL, 521 592 `channel` int(11) NOT NULL default '0', 522 `device_id` varchar(255) NOT NULL default '',523 `shop` varchar(64) NOT NULL default '',593 `device_id` varchar(255) collate utf8_czech_ci NOT NULL, 594 `shop` varchar(64) collate utf8_czech_ci NOT NULL, 524 595 `deprecated_price` int(11) NOT NULL default '0', 525 596 `TimeEnlistment` datetime NOT NULL default '0000-00-00 00:00:00', … … 527 598 `StockCard` int(11) NOT NULL, 528 599 PRIMARY KEY (`id`) 529 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=160 ; 530 531 -- -------------------------------------------------------- 532 533 -- 534 -- Struktura tabulky `network_dns_alias` 535 -- 536 537 CREATE TABLE IF NOT EXISTS `network_dns_alias` ( 538 `name` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '', 539 `target` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '' 540 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 600 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=160 ; 541 601 542 602 -- -------------------------------------------------------- … … 548 608 CREATE TABLE IF NOT EXISTS `network_segments` ( 549 609 `id` int(11) NOT NULL auto_increment, 550 `name` varchar(128) NOT NULL default '',610 `name` varchar(128) collate utf8_czech_ci NOT NULL, 551 611 `price` int(11) NOT NULL default '0', 552 612 `parent` int(11) NOT NULL default '0', … … 555 615 `users_overheads` int(11) NOT NULL default '0', 556 616 PRIMARY KEY (`id`) 557 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=33 ; 558 559 -- -------------------------------------------------------- 560 561 -- 562 -- Struktura tabulky `network_udp_forwarder` 563 -- 564 565 CREATE TABLE IF NOT EXISTS `network_udp_forwarder` ( 566 `port` int(11) NOT NULL default '0', 567 `game` varchar(255) character set latin2 NOT NULL default '' 568 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 569 570 -- -------------------------------------------------------- 571 572 -- 573 -- Struktura tabulky `news` 574 -- 575 576 CREATE TABLE IF NOT EXISTS `news` ( 577 `id` int(11) NOT NULL auto_increment, 578 `title` varchar(255) collate utf8_czech_ci NOT NULL default '', 579 `content` text collate utf8_czech_ci NOT NULL, 580 `date` datetime NOT NULL default '0000-00-00 00:00:00', 581 `target_date` datetime NOT NULL default '0000-00-00 00:00:00', 582 `author` varchar(32) collate utf8_czech_ci NOT NULL default '', 583 `ip` varchar(16) collate utf8_czech_ci NOT NULL default '', 584 `category` int(11) NOT NULL default '0', 585 `enclosure` varchar(255) collate utf8_czech_ci NOT NULL default '', 617 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=33 ; 618 619 -- -------------------------------------------------------- 620 621 -- 622 -- Struktura tabulky `News` 623 -- 624 625 CREATE TABLE IF NOT EXISTS `News` ( 626 `Id` int(11) NOT NULL auto_increment, 627 `Title` varchar(255) collate utf8_czech_ci NOT NULL, 628 `Content` text collate utf8_czech_ci NOT NULL, 629 `Date` datetime NOT NULL default '0000-00-00 00:00:00', 630 `TargetDate` datetime NOT NULL default '0000-00-00 00:00:00', 631 `Author` varchar(32) collate utf8_czech_ci NOT NULL, 632 `IP` varchar(16) collate utf8_czech_ci NOT NULL, 633 `Category` int(11) NOT NULL default '0', 634 `Enclosure` varchar(255) collate utf8_czech_ci NOT NULL, 586 635 `User` int(11) NOT NULL default '0', 587 PRIMARY KEY (` id`),588 KEY `category` (` category`),589 KEY `date` (` date`)590 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=308 55 ;591 592 -- -------------------------------------------------------- 593 594 -- 595 -- Struktura tabulky ` news_category`596 -- 597 598 CREATE TABLE IF NOT EXISTS ` news_category` (599 ` id` int(11) NOT NULL auto_increment,600 ` caption` varchar(255) NOT NULL default '',601 ` permission` int(11) NOT NULL default '0',602 PRIMARY KEY (` id`)603 ) ENGINE=MyISAM DEFAULT CHARSET= latin2AUTO_INCREMENT=13 ;636 PRIMARY KEY (`Id`), 637 KEY `category` (`Category`), 638 KEY `date` (`Date`) 639 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30865 ; 640 641 -- -------------------------------------------------------- 642 643 -- 644 -- Struktura tabulky `NewsCategory` 645 -- 646 647 CREATE TABLE IF NOT EXISTS `NewsCategory` ( 648 `Id` int(11) NOT NULL auto_increment, 649 `Caption` varchar(255) collate utf8_czech_ci NOT NULL, 650 `Permission` int(11) NOT NULL default '0', 651 PRIMARY KEY (`Id`) 652 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ; 604 653 605 654 -- -------------------------------------------------------- … … 640 689 `ItemId` int(11) NOT NULL default '0', 641 690 PRIMARY KEY (`Id`) 642 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 7;691 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=38 ; 643 692 644 693 -- -------------------------------------------------------- … … 653 702 `Type` enum('Group','Operation') collate utf8_czech_ci NOT NULL default 'Group' 654 703 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 655 656 -- --------------------------------------------------------657 658 --659 -- Struktura tabulky `services_restart`660 --661 662 CREATE TABLE IF NOT EXISTS `services_restart` (663 `id` int(11) NOT NULL auto_increment,664 `caption` varchar(255) character set latin2 NOT NULL default '',665 `generator` varchar(255) character set latin2 NOT NULL default '',666 `restarter` varchar(255) character set latin2 NOT NULL default '',667 `changed` int(11) NOT NULL default '0',668 `last_time` datetime NOT NULL default '0000-00-00 00:00:00',669 PRIMARY KEY (`id`)670 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;671 704 672 705 -- -------------------------------------------------------- … … 682 715 KEY `host_id` (`host_id`), 683 716 KEY `time` (`time`) 684 ) ENGINE=MyISAM DEFAULT CHARSET= latin1;717 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 685 718 686 719 -- -------------------------------------------------------- … … 692 725 CREATE TABLE IF NOT EXISTS `StockCard` ( 693 726 `Id` int(11) NOT NULL auto_increment, 694 `Name` varchar(255) NOT NULL,727 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 695 728 `SellPrice` float NOT NULL, 696 729 `Consumption` int(11) NOT NULL COMMENT 'In Watts', 697 730 PRIMARY KEY (`Id`) 698 ) ENGINE=MyISAM DEFAULT CHARSET= latin1AUTO_INCREMENT=1 ;731 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 699 732 700 733 -- -------------------------------------------------------- … … 710 743 `AddressTown` varchar(64) collate utf8_czech_ci NOT NULL default '', 711 744 `AddressPSC` int(11) NOT NULL default '0', 712 `IC` int(11) NOT NULL default '0',745 `IC` varchar(32) collate utf8_czech_ci NOT NULL, 713 746 `DIC` varchar(32) collate utf8_czech_ci NOT NULL default '', 714 747 `MapPositionX` float NOT NULL default '0', 715 748 `MapPositionY` float NOT NULL default '0', 716 749 `WWW` varchar(255) collate utf8_czech_ci NOT NULL, 717 PRIMARY KEY (`Id`) 718 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=106 ; 750 `Note` varchar(255) collate utf8_czech_ci NOT NULL, 751 PRIMARY KEY (`Id`) 752 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=112 ; 719 753 720 754 -- -------------------------------------------------------- … … 749 783 750 784 -- 751 -- Struktura tabulky `sunrisechat_history`752 --753 754 CREATE TABLE IF NOT EXISTS `sunrisechat_history` (755 `id` int(11) NOT NULL auto_increment,756 `nick` varchar(64) NOT NULL default '',757 `text` text NOT NULL,758 `time` datetime NOT NULL default '0000-00-00 00:00:00',759 `color` int(11) NOT NULL default '0',760 `roomname` varchar(32) NOT NULL default '',761 `roomtype` int(11) NOT NULL default '0',762 PRIMARY KEY (`id`)763 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=528523 ;764 765 -- --------------------------------------------------------766 767 --768 -- Struktura tabulky `sunrisechat_onlinelist`769 --770 771 CREATE TABLE IF NOT EXISTS `sunrisechat_onlinelist` (772 `id` int(11) NOT NULL auto_increment,773 `sender_ip` varchar(16) character set latin2 NOT NULL default '',774 `sender_id` int(11) NOT NULL default '0',775 `nick` varchar(64) character set latin2 NOT NULL default '',776 `color` int(11) NOT NULL default '0',777 `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',778 `status` varchar(16) character set latin2 NOT NULL default '',779 `operating_system` varchar(32) character set latin2 NOT NULL default '',780 `sequence` int(11) NOT NULL default '0',781 `info` varchar(255) character set latin2 NOT NULL default '',782 PRIMARY KEY (`id`)783 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78758 ;784 785 -- --------------------------------------------------------786 787 --788 -- Struktura tabulky `test`789 --790 791 CREATE TABLE IF NOT EXISTS `test` (792 `text` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL793 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;794 795 -- --------------------------------------------------------796 797 --798 785 -- Struktura tabulky `tkr` 799 786 -- … … 801 788 CREATE TABLE IF NOT EXISTS `tkr` ( 802 789 `id` int(11) NOT NULL auto_increment, 803 `name` varchar(16) NOT NULL default '',790 `name` varchar(16) collate utf8_czech_ci NOT NULL, 804 791 `freq` int(11) NOT NULL default '0', 805 `norm` varchar(8) NOT NULL default '',806 `www` varchar(255) NOT NULL default '',807 `lang` varchar(32) NOT NULL default '',808 `shortname` varchar(16) NOT NULL default '',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, 809 796 PRIMARY KEY (`id`) 810 ) ENGINE=MyISAM DEFAULT CHARSET= latin2AUTO_INCREMENT=25 ;797 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25 ; 811 798 812 799 -- -------------------------------------------------------- … … 818 805 CREATE TABLE IF NOT EXISTS `User` ( 819 806 `Id` int(11) NOT NULL auto_increment, 820 `Name` varchar(64) collate utf8_czech_ci NOT NULL default '', 821 `FirstName` varchar(128) collate utf8_czech_ci NOT NULL default '', 822 `SecondName` varchar(128) collate utf8_czech_ci NOT NULL default '', 823 `Nick` varchar(128) collate utf8_czech_ci NOT NULL default '', 807 `Login` varchar(64) collate utf8_czech_ci NOT NULL, 808 `Name` varchar(128) collate utf8_czech_ci NOT NULL, 824 809 `Password` varchar(255) collate utf8_czech_ci NOT NULL, 825 810 `Email` varchar(128) collate utf8_czech_ci NOT NULL default '', … … 833 818 `InitPassword` varchar(255) collate utf8_czech_ci NOT NULL, 834 819 PRIMARY KEY (`Id`), 835 UNIQUE KEY `Name` (`Name`) 836 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=104 ; 820 UNIQUE KEY `Name` (`Login`), 821 UNIQUE KEY `Nick` (`Name`) 822 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=107 ; 837 823 838 824 -- -------------------------------------------------------- … … 853 839 PRIMARY KEY (`Id`), 854 840 KEY `User` (`User`) 855 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 299;841 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3571 ; 856 842 857 843 -- -------------------------------------------------------- … … 890 876 `inet_tarif_next` int(11) NOT NULL default '2', 891 877 `monthly_inet` int(11) NOT NULL default '0', 892 `subject_name` varchar(128) c haracter set utf8 collate utf8_czech_ci NOT NULL default '',893 `street` varchar(255) c haracter set utf8 collate utf8_czech_ci NOT NULL default '',894 `town` varchar(64) c haracter set utf8 collate utf8_czech_ci NOT NULL default '',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 '', 895 881 `psc` int(11) NOT NULL default '0', 896 882 `ico` int(11) NOT NULL default '0', 897 `dic` varchar(32) NOT NULL default '',898 `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') NOT NULL default 'monthly',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', 899 885 PRIMARY KEY (`id`), 900 886 UNIQUE KEY `nick` (`nick`) 901 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ; 902 903 -- -------------------------------------------------------- 904 905 -- 906 -- Struktura tabulky `users_online` 907 -- 908 909 CREATE TABLE IF NOT EXISTS `users_online` ( 910 `id` int(11) NOT NULL auto_increment, 911 `user` int(11) NOT NULL default '0', 912 `time` int(11) NOT NULL default '0', 913 `session` varchar(128) character set latin2 NOT NULL default '', 914 `ip` varchar(64) character set latin2 NOT NULL default '', 915 PRIMARY KEY (`id`) 916 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=282 ; 917 918 -- -------------------------------------------------------- 919 920 -- 921 -- Struktura tabulky `users_roles` 922 -- 923 924 CREATE TABLE IF NOT EXISTS `users_roles` ( 925 `Id` int(11) NOT NULL auto_increment, 926 `Description` varchar(128) collate utf8_czech_ci NOT NULL default '', 927 PRIMARY KEY (`Id`) 928 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ; 929 930 -- -------------------------------------------------------- 931 932 -- 933 -- Struktura tabulky `wlan_db` 934 -- 935 936 CREATE TABLE IF NOT EXISTS `wlan_db` ( 937 `id` int(11) NOT NULL auto_increment, 938 `name` varchar(255) NOT NULL default '', 939 `value` float NOT NULL default '0', 940 PRIMARY KEY (`id`) 941 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=12 ; 942 943 -- -------------------------------------------------------- 944 945 -- 946 -- Struktura tabulky `wlan_links` 947 -- 948 949 CREATE TABLE IF NOT EXISTS `wlan_links` ( 950 `id` int(11) NOT NULL auto_increment, 951 `point1` int(11) NOT NULL default '0', 952 `point2` int(11) NOT NULL default '0', 953 `distance` int(11) NOT NULL default '0', 954 PRIMARY KEY (`id`) 955 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; 956 957 -- -------------------------------------------------------- 958 959 -- 960 -- Struktura tabulky `wlan_list` 961 -- 962 963 CREATE TABLE IF NOT EXISTS `wlan_list` ( 964 `id` int(11) NOT NULL auto_increment, 965 `name` varchar(255) character set latin2 NOT NULL default '', 966 `device` int(11) NOT NULL default '0', 967 `antena` int(11) NOT NULL default '0', 968 `cable` int(11) NOT NULL default '0', 969 `cable_length` int(11) NOT NULL default '0', 970 `connector1` int(11) NOT NULL default '0', 971 `connector2` int(11) NOT NULL default '0', 972 `total` int(11) NOT NULL default '0', 973 `comment` int(11) NOT NULL default '0', 974 `total_passive` int(11) NOT NULL default '0', 975 PRIMARY KEY (`id`) 976 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; 887 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ; -
trunk/style.css
r211 r221 66 66 width: 100%; 67 67 font-weight: normal; 68 display: block; 68 69 } 69 70 … … 109 110 .NewsTable 110 111 { 112 margin: 2px 0px 2px 0px; 111 113 padding: 2px 2px 2px 2px; 112 114 font-size: small; … … 115 117 border-width: 1px; 116 118 background-color: #FFF0F0; 119 width: 100%; 120 border-collapse: collapse; 121 } 122 123 .NewsTable td 124 { 125 padding: 2px 2px 2px 2px; 126 margin: 0px 0px 0px 0px; 127 } 128 129 .NewsTable th 130 { 131 padding: 2px 2px 2px 2px; 132 margin: 0px 0px 0px 0px; 117 133 } 118 134 119 135 .NewsTableItem 120 136 { 137 margin: 2px 2px 2px 2px; 121 138 display: none; 122 139 border-width: 1px; … … 127 144 } 128 145 146 #NewsColumn 147 { 148 width: 50%; 149 } 150 151 .NewsBaseTable 152 { 153 width: 100%; 154 border-width: 0px; 155 font-size: small; 156 padding-bottom: 5px; 157 margin-bottom: 5px; 158 border-collapse: collapse; 159 } 160 161 .NewsBaseTable td 162 { 163 padding: 2px 2px 2px 2px; 164 margin: 2px 2px 2px 2px; 165 } 166 167 .NewsItemFrame 168 { 169 border-collapse: collapse; 170 padding: 0px; 171 margin: 2px 2px 2px 2px; 172 font-size: small; 173 color: red; 174 width: 100%; 175 } 176 129 177 .RSSIcon 130 178 { … … 132 180 border-width: 0px; 133 181 } 134 135 #NewsColumn136 {137 width: 50%;138 }139 140 182 div.HalfWidth 141 183 {
Note:
See TracChangeset
for help on using the changeset viewer.