-- parentvalue= 'URBAN_BASEDATA_PLAN_TYPE:1'                       --تفصیلی


--مسکونی  --1
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'مسکونی', 'URBAN_BASEDATA_PLAN_LICENSED:101', 1, NULL, 101 , 101, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--اموزش تحقیقات و فناوری  --2
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'آموزش ، تحقیقات و فناوری', 'URBAN_BASEDATA_PLAN_LICENSED:102', 2, NULL, 102 , 102, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--اموزشی  --3
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'آموزشی', 'URBAN_BASEDATA_PLAN_LICENSED:103', 3, NULL, 103 , 103, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--اداری و انتظامی  --4
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'اداری و انتظامی', 'URBAN_BASEDATA_PLAN_LICENSED:104', 4, NULL, 104 , 104, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--5 --تجاری-خدماتی 

INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'تجاری-خدماتی', 'URBAN_BASEDATA_PLAN_LICENSED:105', 5, NULL, 105 , 105, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--ورزشی  --6
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'ورزشی', 'URBAN_BASEDATA_PLAN_LICENSED:106', 6, NULL, 106 , 106, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--7 --درمانی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'درمانی', 'URBAN_BASEDATA_PLAN_LICENSED:107', 7, NULL, 107 , 107, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--8-- فرهنگی-هنری
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'فرهنگی-هنری', 'URBAN_BASEDATA_PLAN_LICENSED:108', 8, NULL, 108 , 108, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--9--پارک و فضای سبز
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'پارک و فضای سبز', 'URBAN_BASEDATA_PLAN_LICENSED:109', 9, NULL, 109 , 109, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--10 -- مذهبی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'مذهبی', 'URBAN_BASEDATA_PLAN_LICENSED:110', 10, NULL, 110 , 110, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--11 --تجهیزات شهری
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'تجهیزات شهری', 'URBAN_BASEDATA_PLAN_LICENSED:111', 11, NULL, 111 , 111, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--12 --تاسیسات شهری
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'تاسیسات شهری', 'URBAN_BASEDATA_PLAN_LICENSED:112', 12, NULL, 112 , 112, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--13 --حمل و نقل و انبارداری
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'حمل و نقل و انبارداری', 'URBAN_BASEDATA_PLAN_LICENSED:113', 13, NULL, 113 , 113, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--14 --نظامی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'نظامی', 'URBAN_BASEDATA_PLAN_LICENSED:114', 14, NULL, 114 , 114, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--15 --باغات و کشاورزی

INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'باغات و کشاورزی', 'URBAN_BASEDATA_PLAN_LICENSED:115', 15, NULL, 115 , 115, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);

--16 --میراث تاریخی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'میراث تاریخی', 'URBAN_BASEDATA_PLAN_LICENSED:116', 16, NULL, 116 , 116, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--17--طبیعی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'طبیعی', 'URBAN_BASEDATA_PLAN_LICENSED:117', 17, NULL, 117 , 117, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--18--حریم
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'حریم', 'URBAN_BASEDATA_PLAN_LICENSED:118', 18, NULL, 118 , 118, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--19--تفریحی و توریستی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'تفریحی و توریستی', 'URBAN_BASEDATA_PLAN_LICENSED:119', 19, NULL, 119 , 119, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--20--صنعتی
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'صنعتی', 'URBAN_BASEDATA_PLAN_LICENSED:120', 20, NULL, 120 , 120, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--21--نامشخص
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'نامشخص', 'URBAN_BASEDATA_PLAN_LICENSED:121', 21, NULL, 121 , 121, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--22--مختلط
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'مختلط', 'URBAN_BASEDATA_PLAN_LICENSED:122', 22, NULL, 122 , 122, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);
--23--سایر کاربری ها
INSERT INTO BaseData (id, created_by, creation_timestamp, DELETED, modification_timestamp, modified_by, category, parentValue, title, VALUE, orderValue, tmpId, code, calcCode, MetaData, calcCode2, CalcCodeReport, calcCodeRevenueTemp, calcCodeRevenue, Communication_key, calcCodeDorsa, IsActive, Commission100Key, Keyword, Coefficients, KatebCalcCode, Tag, calcCodeShop, addChild)
VALUES(newid(), NULL, GETDATE(), 0, GETDATE(), NULL, 'BASEDATA_PLAN_LICENSED', 'URBAN_BASEDATA_PLAN_TYPE:1', N'سایر کاربری ها', 'URBAN_BASEDATA_PLAN_LICENSED:123', 23, NULL, 123 , 123, N'[{"Type":null,"Field":"AcceptableUse","Caption":"استفاده مجاز","Value":null},{"Type":null,"Field":"DensityArea","Caption":"تراکم","Value":"0"},{"Type":null,"Field":"SurfaceArea","Caption":"سطح اشغال","Value":"0"}]', 1, NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL);