You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
1.0 KiB
SQL
21 lines
1.0 KiB
SQL
INSERT INTO `hrmjobgroups`
|
|
( `JOBGROUPNAME`, `JOBGROUPREMARK`, `created`, `creater`, `modified`, `modifier`, `uuid` )
|
|
VALUES
|
|
( '聚才林', '聚才林', DATE( NOW()), 1, NULL, NULL, 'd9f435c3-8d4d-4e01-9a97-d72f9c5d5fae' );
|
|
|
|
INSERT INTO `hrmjobactivities`
|
|
( `JOBACTIVITYMARK`, `JOBACTIVITYNAME`, `JOBGROUPID`, `JOBLEVELFROM`, `JOBLEVELTO`, `created`, `creater`, `modified`, `modifier`, `uuid` )
|
|
VALUES
|
|
( '默认职务', '默认职务', 14, NULL, NULL, DATE( NOW()), 1, NULL, NULL, '3a2efce3-95de-4ec2-afe1-347783817bdb' );
|
|
|
|
|
|
-- SqlServer插入语句
|
|
INSERT INTO hrmjobgroups
|
|
( JOBGROUPNAME, JOBGROUPREMARK, created, creater, modified, modifier, uuid )
|
|
VALUES
|
|
( '聚才林', '聚才林', getDate(), 1, NULL, NULL, 'd9f435c3-8d4d-4e01-9a97-d72f9c5d5fae' );
|
|
|
|
INSERT INTO hrmjobactivities
|
|
( JOBACTIVITYMARK, JOBACTIVITYNAME, JOBGROUPID, JOBLEVELFROM, JOBLEVELTO, created, creater, modified, modifier, uuid )
|
|
VALUES
|
|
( '默认职务', '默认职务', 14, NULL, NULL,getDate(), 1, NULL, NULL, '3a2efce3-95de-4ec2-afe1-347783817bdb' ); |