Revize 597
Přidáno uživatelem harryhk před více než 14 roky(ů)
| freenetis/trunk/kohana/media/download/10.107 | ||
|---|---|---|
|
$ORIGIN .
|
||
|
$TTL 86400 ; (1 day)
|
||
|
37.107.10.in-addr.arpa IN SOA charon.hkfree.org. pmv.root.hkfree.org. (
|
||
|
2010020100 ; serial
|
||
|
55.107.10.in-addr.arpa IN SOA charon.hkfree.org. pmv.root.hkfree.org. (
|
||
|
2010020200 ; serial
|
||
|
28800 ; refresh (8 hours)
|
||
|
7200 ; retry (2 hours)
|
||
|
604800 ; expire (1 week)
|
||
| ... | ... | |
|
)
|
||
|
NS ns.hkfree.org.
|
||
|
NS ns2.hkfree.org.
|
||
|
$ORIGIN 37.107.10.in-addr.arpa.
|
||
|
$ORIGIN 55.107.10.in-addr.arpa.
|
||
|
$TTL 86400
|
||
|
|
||
|
1 PTR kocourkov.hkfree.org.
|
||
|
95 PTR pepa2.kocourkov.hkfree.org.
|
||
|
101 PTR pepa.kocourkov.hkfree.org.
|
||
|
102 PTR pepa.kocourkov.hkfree.org.
|
||
|
129 PTR kocourkov.hkfree.org.
|
||
|
130 PTR pepa2.kocourkov.hkfree.org.
|
||
|
150 PTR karel.kocourkov.hkfree.org.
|
||
|
151 PTR karel.kocourkov.hkfree.org.
|
||
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
|
||
|
// array of sql queries that upgrade database
|
||
|
$upgrade_sql[get_SVN_rev()] = array(
|
||
|
"CREATE TABLE `freenetis`.`smokeping` (
|
||
|
`id` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT,
|
||
|
`menu` VARCHAR(45),
|
||
|
`title` VARCHAR(45),
|
||
|
`ip_address` VARCHAR(30),
|
||
|
`level` INT(1) UNSIGNED,
|
||
|
`parent` INTEGER UNSIGNED,
|
||
|
`device` BOOLEAN,
|
||
|
PRIMARY KEY (`id`)
|
||
|
)
|
||
|
ENGINE = InnoDB
|
||
|
CHARACTER SET utf8 COLLATE utf8_general_ci;"
|
||
|
"ALTER TABLE `freenetis`.`smokeping` RENAME TO `freenetis`.`smokepings`;"
|
||
|
);
|
||
|
?>
|
||
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_595.php | ||
|---|---|---|
|
<?php
|
||
|
|
||
|
// array of sql queries that upgrade database
|
||
|
$upgrade_sql[589] = array(
|
||
|
"CREATE TABLE `freenetis`.`smokeping` (
|
||
|
`id` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT,
|
||
|
`menu` VARCHAR(45),
|
||
|
`title` VARCHAR(45),
|
||
|
`ip_address` VARCHAR(30),
|
||
|
`level` INT(1) UNSIGNED,
|
||
|
`parent` INTEGER UNSIGNED,
|
||
|
`device` BOOLEAN,
|
||
|
PRIMARY KEY (`id`)
|
||
|
)
|
||
|
ENGINE = InnoDB
|
||
|
CHARACTER SET utf8 COLLATE utf8_general_ci;"
|
||
|
);
|
||
|
?>
|
||
Také k dispozici: Unified diff
oprava v databazi pro tabulku smokeping.