projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
e183bd9
)
UpdateDatabase/MysqlLinks.php
author
Alan Knowles
<alan@roojs.com>
Thu, 16 Apr 2015 06:15:37 +0000
(14:15 +0800)
committer
Alan Knowles
<alan@roojs.com>
Thu, 16 Apr 2015 06:15:37 +0000
(14:15 +0800)
UpdateDatabase/MysqlLinks.php
patch
|
blob
|
history
diff --git
a/UpdateDatabase/MysqlLinks.php
b/UpdateDatabase/MysqlLinks.php
index
91c2738
..
e205931
100644
(file)
--- a/
UpdateDatabase/MysqlLinks.php
+++ b/
UpdateDatabase/MysqlLinks.php
@@
-192,7
+192,7
@@
class Pman_Core_UpdateDatabase_MysqlLinks {
$err = substr("Failed Delete {$target_table} refs {$source_table}:{$source_col}", 0, 64);
$trigger .="
SET mid = 0;
$err = substr("Failed Delete {$target_table} refs {$source_table}:{$source_col}", 0, 64);
$trigger .="
SET mid = 0;
- SELECT count(*) into mid FROM {$source_table} WHERE {$source_col} = OLD.{$target_col};
+ SELECT count(*) into mid FROM {$source_table} WHERE {$source_col} = OLD.{$target_col}
LIMIT 1
;
IF mid > 0 THEN
UPDATE `$err` SET x = 1;
IF mid > 0 THEN
UPDATE `$err` SET x = 1;
@@
-261,7
+261,7
@@
class Pman_Core_UpdateDatabase_MysqlLinks {
$trigger .="
SET mid = 0;
if NEW.{$source_col} > 0 THEN
$trigger .="
SET mid = 0;
if NEW.{$source_col} > 0 THEN
- SELECT {$target_col} into mid FROM {$target_table} WHERE {$target_col} = NEW.{$source_col};
+ SELECT {$target_col} into mid FROM {$target_table} WHERE {$target_col} = NEW.{$source_col}
LIMIT 1
;
IF mid < 1 THEN
UPDATE `$err` SET x = 1;
END IF;
IF mid < 1 THEN
UPDATE `$err` SET x = 1;
END IF;
@@
-335,7
+335,7
@@
class Pman_Core_UpdateDatabase_MysqlLinks {
$trigger .="
SET mid = 0;
if NEW.{$source_col} > 0 THEN
$trigger .="
SET mid = 0;
if NEW.{$source_col} > 0 THEN
- SELECT {$target_col} into mid FROM {$target_table} WHERE {$target_col} = NEW.{$source_col};
+ SELECT {$target_col} into mid FROM {$target_table} WHERE {$target_col} = NEW.{$source_col}
LIMIT 1
;
IF mid < 1 THEN
UPDATE `$err` SET x = 1;
END IF;
IF mid < 1 THEN
UPDATE `$err` SET x = 1;
END IF;