Revize 964
Přidáno uživatelem Michal Kliment před více než 13 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
// array of sql queries that upgrade database
|
||
|
$upgrade_sql[get_SVN_rev()] = array(
|
||
|
|
||
|
"INSERT INTO allowed_subnets_counts
|
||
|
SELECT NULL, m.id, 1 FROM members m
|
||
|
WHERE m.id NOT IN (SELECT member_id FROM allowed_subnets_counts)",
|
||
|
"DELETE FROM allowed_subnets_counts WHERE member_id = 1",
|
||
|
|
||
|
);
|
||
|
?>
|
||
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_962.php | ||
|---|---|---|
|
<?php
|
||
|
|
||
|
// array of sql queries that upgrade database
|
||
|
$upgrade_sql[962] = array(
|
||
|
|
||
|
"INSERT INTO allowed_subnets_counts
|
||
|
SELECT NULL, m.id, 1 FROM members m
|
||
|
WHERE m.id NOT IN (SELECT member_id FROM allowed_subnets_counts)",
|
||
|
|
||
|
);
|
||
|
?>
|
||
Také k dispozici: Unified diff
Merge z testingu do trunku: Mensi uprava SQL dotazu (vyjimka pro clena s ID 1 - sdruzeni).