USE larkoatest

DECLARE @DepartmentID nvarchar(50), @EndUserTypeID nvarchar(50)
SELECT @EndUserTypeID = NEWID()
INSERT INTO DataDictionary (ID, DataValue1, DataValue2, DataValue3, DataValue4, DataValue5, SystemPreset, DataType, DefaultValue)
VALUES (NEWID(), '普通用户', '普通用戶', 'Regular user', '普通のユーザー', '', 1, 1, 1)
INSERT INTO DataDictionary (ID, DataValue1, DataValue2, DataValue3, DataValue4, DataValue5, SystemPreset, DataType, DefaultValue)
VALUES (@EndUserTypeID, '系统管理员', '系統管理員', 'System administrator', 'システム管理者', '', 1, 1, 0)
INSERT INTO DataDictionary (ID, DataValue1, DataValue2, DataValue3, DataValue4, DataValue5, SystemPreset, DataType, DefaultValue)
VALUES (NEWID(), '总经理', '總經理', 'General manager', 'ゼネラルマネージャー', '', 1, 1, 0)
SELECT @DepartmentID = NEWID()
INSERT INTO Department (DepartmentID, ParentID, DepartmentName)
VALUES (@DepartmentID, '00000000-0000-0000-0000-000000000000', 'Root')

DECLARE @AddressID nvarchar(50), @ContactInformationID nvarchar(50)
SELECT @AddressID = NEWID()
SELECT @ContactInformationID = NEWID()
INSERT INTO Address (AddressID) VALUES (@AddressID)
INSERT INTO ContactInformation (ContactInformationID) VALUES (@ContactInformationID)
INSERT INTO EndUser (EndUserID, EndUserCode, EndUserTypeID, Gender, AddressID, ContactInformationID, Password, DepartmentID, SystemPreset)
VALUES (NEWID(), 'admin', @EndUserTypeID, 1, @AddressID, @ContactInformationID, '202CB962AC59075B964B07152D234B70', @DepartmentID, 1)

INSERT INTO FormGroup (FormGroupID, FormGroupName, SystemPreset)
VALUES (NEWID(), 'Ungrouped', 1)
