INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 2, 'Bedrooms', 'number', 1); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 2, 'Bathrooms', 'number', 2); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 2, 'Kitchens', 'number', 3); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 2, 'Lounge', 'number', 4); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 2, 'Dining Room', 'number', 5); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 1, 'Erf Size', 'number', 1); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 1, 'Floor Size', 'number', 2); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 1, 'Levies', 'number', 3); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 1, 'Rates and Taxes', 'number', 4); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 1, 'Pets Allowed', 'text', 5); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Garages', 'number', 1); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Parking', 'number', 2); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Secure Parking', 'yesno', 3); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Garden', 'yesno', 4); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Pool', 'yesno', 5); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Braai', 'yesno', 6); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 3, 'Scullery', 'text', 6); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 4, 'Style', 'text', 1); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 4, 'Facing', 'text', 2); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 4, 'Roof', 'text', 3); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 4, 'Wall', 'text', 4); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 4, 'Window', 'text', 5); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 5, 'Security', 'text', 1); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 5, 'Temperature Control', 'text', 2); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 5, 'Nearby Public Transport', 'text', 3); INSERT INTO public."UserDefinedFields" ("Created", "Modified", "GroupId", "FieldName", "FieldType", "Rank") VALUES(NOW(), NOW(), 5, 'Internet Access', 'text', 4);