【SQL开源代码栏目提醒】:本文主要为网学会员提供gwcs_dml.sql,希望对需要gwcs_dml.sql网友有所帮助,学习一下!
INSERT INTO Unit (unitId,unitName, fatherId,unitType) VALUES (1, '单位','0','0');
INSERT INTO Users (userId, userName,Account,passWord,unitId,status) VALUES (1,'单位管理员', 'admin','7fa8282ad93047a4d6fe6111c93b308a','1','1');
INSERT INTO Role (roleId,roleName,content,unitId) VALUES (1,'全能角色', '211,212,213,214,215,216,221,222,225,223,224,226,231,232,235,236,233,234,241,244,245,246,242,243,251,111,112,113,114,115,121,122,123,124,125,311,312,313,314,412','1');