summaryrefslogtreecommitdiff
path: root/sql/hc/updateMissionStateTable.sql
diff options
context:
space:
mode:
authorchenjinsong <[email protected]>2018-09-27 16:21:05 +0800
committerchenjinsong <[email protected]>2018-09-27 16:21:05 +0800
commitdc91c4c9871c13a5237eb3fdaf9dd8ef5b1ab61b (patch)
treec5e227244ec676e8d56d3b17b858b98310035089 /sql/hc/updateMissionStateTable.sql
initial commit
Diffstat (limited to 'sql/hc/updateMissionStateTable.sql')
-rw-r--r--sql/hc/updateMissionStateTable.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/hc/updateMissionStateTable.sql b/sql/hc/updateMissionStateTable.sql
new file mode 100644
index 0000000..a4b4a4e
--- /dev/null
+++ b/sql/hc/updateMissionStateTable.sql
@@ -0,0 +1,4 @@
+update mission_state_table set look_user_id =null;
+
+alter table mission_state_table modify (Look_user_id varchar(100));
+ comment on column mission_state_table.Look_user_id is '查看人ID'; \ No newline at end of file