| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | ALTER TABLE sys_dept ADD dept_category nvarchar(100) DEFAULT NULL |
|---|
| | | EXEC sp_addextendedproperty |
|---|
| | | 'MS_Description', N'é¨é¨ç±»å«ç¼ç ', |
|---|
| | | 'SCHEMA', N'dbo', |
|---|
| | | 'TABLE', N'sys_dept', |
|---|
| | | 'COLUMN', N'dept_category' |
|---|
| | | GO |
|---|
| | | ALTER TABLE sys_post ADD dept_id bigint NOT NULL |
|---|
| | | GO |
|---|
| | | ALTER TABLE sys_post ADD post_category nvarchar(100) DEFAULT NULL |
|---|
| | | GO |
|---|
| | | EXEC sp_addextendedproperty |
|---|
| | | 'MS_Description', N'é¨é¨id', |
|---|
| | | 'SCHEMA', N'dbo', |
|---|
| | | 'TABLE', N'sys_post', |
|---|
| | | 'COLUMN', N'dept_id' |
|---|
| | | GO |
|---|
| | | EXEC sp_addextendedproperty |
|---|
| | | 'MS_Description', N'å²ä½ç±»å«ç¼ç ', |
|---|
| | | 'SCHEMA', N'dbo', |
|---|
| | | 'TABLE', N'sys_post', |
|---|
| | | 'COLUMN', N'post_category' |
|---|
| | | GO |
|---|
| | | UPDATE sys_post SET dept_id = 100 |
|---|
| | | GO |
|---|
| | | UPDATE sys_post SET dept_id = 103 where post_id = 1 |
|---|
| | | GO |
|---|
| | | UPDATE sys_menu SET path = N'snailjob', component = N'monitor/snailjob/index', perms = N'monitor:snailjob:list', remark = N'SnailJobæ§å¶å°èå' WHERE menu_id = 120 |
|---|
| | | GO |
|---|
