projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
e6319b7
)
case on update
author
Alan Knowles
<alan@roojs.com>
Thu, 22 Jul 2021 04:57:48 +0000
(12:57 +0800)
committer
Alan Knowles
<alan@roojs.com>
Thu, 22 Jul 2021 04:57:48 +0000
(12:57 +0800)
sql/core_group.sql
patch
|
blob
|
history
diff --git
a/sql/core_group.sql
b/sql/core_group.sql
index
0c6b4c4
..
8e4cb19
100644
(file)
--- a/
sql/core_group.sql
+++ b/
sql/core_group.sql
@@
-14,6
+14,6
@@
ALTER TABLE core_group ADD COLUMN type int(11) NOT NULL DEFAULT 0;
ALTER TABLE core_group ADD COLUMN leader int(11) NOT NULL default 0;
ALTER TABLE core_group ADD COLUMN is_system int(2) NOT NULL default 0;
-U
pdate core_group set display_name = name where
display_name = '';
+U
PDATE core_group SET display_name = name WHERE
display_name = '';
ALTER TABLE core_group ADD INDEX lookup_leader (leader);
\ No newline at end of file