Revize 963
Přidáno uživatelem Michal Kliment před více než 13 roky(ů)
| freenetis/branches/testing/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/branches/testing/application/upgrade_sql/upgrade_sql_960.php | ||
|---|---|---|
|
<?php
|
||
|
|
||
|
// array of sql queries that upgrade database
|
||
|
$upgrade_sql[960] = 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
Mensi uprava SQL dotazu (vyjimka pro clena s ID 1 - sdruzeni).