/*
-- Query: SELECT
`document_template`.`ID`,
`document_template`.`NAME`,
`document_template`.`RULES`,
`document_template`.`TEMPLATE_XSD`,
`document_template`.`DESCRIPTION`,
`document_template`.`OWNER`,
`document_template`.`PERMISSIONS`
FROM `test`.`document_template`
LIMIT 0, 1000

-- Date: 2013-05-11 21:43
*/
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (200,'ExampleApplication',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"Application_tark\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																				\n		<xs:element name=\"studentSSN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"lastName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"firstName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"email\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"courseJA101\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"courseJA102\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"courseJA103\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"school\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"gradePointAverage\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"requirementsFilled\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"scholarship\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"fee\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"cardholdersName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"cardNumber\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																												\n		<xs:element name=\"paymentAccepted\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																										</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Example1 - Application','admin','StudyCommittee<>studentSSN>>R,-,-,-<break>StudyCommittee<>lastName>>R,-,-,-<break>StudyCommittee<>firstName>>R,-,-,-<break>StudyCommittee<>email>>R,-,-,-<break>StudyCommittee<>courseJA101>>R,-,-,-<break>StudyCommittee<>courseJA102>>R,-,-,-<break>StudyCommittee<>courseJA103>>R,-,-,-<break>StudyCommittee<>school>>R,-,-,-<break>StudyCommittee<>gradePointAverage>>-,-,-,-<break>StudyCommittee<>requirementsFilled>>R,-,-,-<break>StudyCommittee<>scholarship>>R,W,-,-<break>StudyCommittee<>fee>>R,W,-,-<break>StudyCommittee<>cardholdersName>>-,-,-,-<break>StudyCommittee<>cardNumber>>-,-,-,-<break>StudyCommittee<>paymentAccepted>>-,-,-,-<break>EvaluationTeam<>studentSSN>>R,-,-,-<break>EvaluationTeam<>lastName>>-,-,-,-<break>EvaluationTeam<>firstName>>-,-,-,-<break>EvaluationTeam<>email>>-,-,-,-<break>EvaluationTeam<>courseJA101>>R,-,-,-<break>EvaluationTeam<>courseJA102>>R,-,-,-<break>EvaluationTeam<>courseJA103>>R,-,-,-<break>EvaluationTeam<>school>>R,-,-,-<break>EvaluationTeam<>gradePointAverage>>R,-,-,-<break>EvaluationTeam<>requirementsFilled>>R,W,-,-<break>EvaluationTeam<>scholarship>>-,-,-,-<break>EvaluationTeam<>fee>>-,-,-,-<break>EvaluationTeam<>cardholdersName>>-,-,-,-<break>EvaluationTeam<>cardNumber>>-,-,-,-<break>EvaluationTeam<>paymentAccepted>>-,-,-,-<break>Accountant<>studentSSN>>-,-,-,-<break>Accountant<>lastName>>-,-,-,-<break>Accountant<>firstName>>-,-,-,-<break>Accountant<>email>>-,-,-,-<break>Accountant<>courseJA101>>-,-,-,-<break>Accountant<>courseJA102>>-,-,-,-<break>Accountant<>courseJA103>>-,-,-,-<break>Accountant<>school>>-,-,-,-<break>Accountant<>gradePointAverage>>-,-,-,-<break>Accountant<>requirementsFilled>>-,-,-,-<break>Accountant<>scholarship>>R,-,-,-<break>Accountant<>fee>>R,-,-,-<break>Accountant<>cardholdersName>>R,W,-,-<break>Accountant<>cardNumber>>R,W,-,-<break>Accountant<>paymentAccepted>>R,W,-,-<break>Student<>studentSSN>>R,W,-,-<break>Student<>lastName>>R,W,-,-<break>Student<>firstName>>R,W,-,-<break>Student<>email>>R,W,-,-<break>Student<>courseJA101>>R,W,-,-<break>Student<>courseJA102>>R,W,-,-<break>Student<>courseJA103>>R,W,-,-<break>Student<>school>>R,W,-,-<break>Student<>gradePointAverage>>R,W,-,-<break>Student<>requirementsFilled>>-,-,-,-<break>Student<>scholarship>>-,-,-,-<break>Student<>fee>>-,-,-,-<break>Student<>cardholdersName>>R,W,-,-<break>Student<>cardNumber>>R,W,-,-<break>Student<>paymentAccepted>>R,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (201,'Group1',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"Application1\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																																																																																				\n		<xs:element name=\"SSN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"PersonalInformation\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"SchoolName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"RegisteredCourseNr\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"Status\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"Fee\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"Scholarship\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"GPA\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"RequirementsFilled\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																																																																																																																																																																																																																				\n		<xs:element name=\"Payment\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group1 form - Application','admin','Student<>SSN>>R,W,-,-<break>Student<>PersonalInformation>>R,W,-,-<break>Student<>SchoolName>>R,W,-,-<break>Student<>RegisteredCourseNr>>R,W,I,D<break>Student<>Status>>R,-,-,-<break>Student<>Fee>>-,-,-,-<break>Student<>Scholarship>>-,-,-,-<break>Student<>GPA>>R,W,-,-<break>Student<>RequirementsFilled>>-,-,-,-<break>Student<>Payment>>-,-,-,-<break>EvaluationTeam<>SSN>>R,-,-,-<break>EvaluationTeam<>PersonalInformation>>-,-,-,-<break>EvaluationTeam<>SchoolName>>-,-,-,-<break>EvaluationTeam<>RegisteredCourseNr>>R,-,-,-<break>EvaluationTeam<>Status>>-,-,-,-<break>EvaluationTeam<>Fee>>R,W,-,-<break>EvaluationTeam<>Scholarship>>-,-,-,-<break>EvaluationTeam<>GPA>>R,-,-,-<break>EvaluationTeam<>RequirementsFilled>>R,W,-,-<break>EvaluationTeam<>Payment>>-,-,-,-<break>Accountant<>SSN>>-,-,-,-<break>Accountant<>PersonalInformation>>R,-,-,-<break>Accountant<>SchoolName>>-,-,-,-<break>Accountant<>RegisteredCourseNr>>R,-,-,-<break>Accountant<>Status>>R,W,-,-<break>Accountant<>Fee>>R,W,-,-<break>Accountant<>Scholarship>>R,W,-,-<break>Accountant<>GPA>>-,-,-,-<break>Accountant<>RequirementsFilled>>-,-,-,-<break>Accountant<>Payment>>R,W,-,-<break>StudyCommittee<>SSN>>R,-,-,-<break>StudyCommittee<>PersonalInformation>>R,-,-,-<break>StudyCommittee<>SchoolName>>R,-,-,-<break>StudyCommittee<>RegisteredCourseNr>>R,-,-,-<break>StudyCommittee<>Status>>R,-,-,-<break>StudyCommittee<>Fee>>R,-,-,-<break>StudyCommittee<>Scholarship>>R,W,-,-<break>StudyCommittee<>GPA>>R,-,-,-<break>StudyCommittee<>RequirementsFilled>>R,-,-,-<break>StudyCommittee<>Payment>>-,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (202,'Group2',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"Application2\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																																																																																				\n		<xs:element name=\"SSN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"contactInfo\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"studyInfo\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"requirementsStatus\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"courseNumber\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"scholarshipAmount\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																												\n		<xs:element name=\"paymentInfo\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																																																																																																																																																																																																																				\n		<xs:element name=\"paymentStatus\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group2 form - Application','admin','Student<>SSN>>R,W,-,-<break>Student<>contactInfo>>R,W,-,-<break>Student<>studyInfo>>R,W,-,-<break>Student<>requirementsStatus>>R,W,-,-<break>Student<>courseNumber>>R,W,-,-<break>Student<>scholarshipAmount>>-,-,-,-<break>Student<>paymentInfo>>R,W,-,-<break>Student<>paymentStatus>>-,-,-,-<break>EvaluationTeam<>SSN>>R,-,-,-<break>EvaluationTeam<>contactInfo>>-,-,-,-<break>EvaluationTeam<>studyInfo>>R,-,-,-<break>EvaluationTeam<>requirementsStatus>>R,W,-,-<break>EvaluationTeam<>courseNumber>>R,-,-,-<break>EvaluationTeam<>scholarshipAmount>>-,-,-,-<break>EvaluationTeam<>paymentInfo>>-,-,-,-<break>EvaluationTeam<>paymentStatus>>-,-,-,-<break>Accountant<>SSN>>-,-,-,-<break>Accountant<>contactInfo>>-,-,-,-<break>Accountant<>studyInfo>>-,-,-,-<break>Accountant<>requirementsStatus>>-,-,-,-<break>Accountant<>courseNumber>>-,-,-,-<break>Accountant<>scholarshipAmount>>-,-,-,-<break>Accountant<>paymentInfo>>R,-,-,-<break>Accountant<>paymentStatus>>R,W,-,-<break>StudyCommittee<>SSN>>R,-,-,-<break>StudyCommittee<>contactInfo>>R,-,-,-<break>StudyCommittee<>studyInfo>>R,-,-,-<break>StudyCommittee<>requirementsStatus>>R,-,-,-<break>StudyCommittee<>courseNumber>>R,-,-,-<break>StudyCommittee<>scholarshipAmount>>R,W,-,-<break>StudyCommittee<>paymentInfo>>-,-,-,-<break>StudyCommittee<>paymentStatus>>-,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (203,'Group3',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"PurchaseOrder\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																															\n							<xs:element name=\"good\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"Good\" minOccurs=\"1\" maxOccurs=\"unbounded\">\n				<xs:complexType>\n				<xs:sequence>\n																													<xs:element name=\"quantity\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"itemCode\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"description\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"unitPrice\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"amount\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"delivered\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																									\n							<xs:element name=\"client\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"Person\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"name\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"address\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																									\n							<xs:element name=\"seller\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"Person\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"name\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"address\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																\n		<xs:element name=\"ShippingDate\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																																																																	\n							<xs:element name=\"paymentInfo\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"Payment\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																													<xs:element name=\"cardName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"cardNo\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"expiryDate\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																														<xs:element name=\"accepted\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group3 form - Purchase order','admin','DeliveryDepartment<>cardName>>-,-,-,-<break>DeliveryDepartment<>cardNo>>-,-,-,-<break>DeliveryDepartment<>expiryDate>>-,-,-,-<break>DeliveryDepartment<>accepted>>-,-,-,-<break>DeliveryDepartment<>quantity>>R,-,-,-<break>DeliveryDepartment<>itemCode>>R,-,-,-<break>DeliveryDepartment<>description>>R,-,-,-<break>DeliveryDepartment<>unitPrice>>R,-,-,-<break>DeliveryDepartment<>amount>>R,-,-,-<break>DeliveryDepartment<>delivered>>R,W,-,-<break>DeliveryDepartment<>Good>>R,-,-,-<break>DeliveryDepartment<>Person>>R,-,-,-<break>DeliveryDepartment<>Person>>-,-,-,-<break>DeliveryDepartment<>ShippingDate>>R,W,-,-<break>DeliveryDepartment<>Payment>>-,-,-,-<break>DeliveryDepartment<>name>>R,-,-,-<break>DeliveryDepartment<>address>>R,-,-,-<break>Client<>cardName>>R,W,-,-<break>Client<>cardNo>>R,W,-,-<break>Client<>expiryDate>>R,W,-,-<break>Client<>accepted>>R,-,-,-<break>Client<>quantity>>R,W,-,-<break>Client<>itemCode>>R,-,-,-<break>Client<>description>>R,W,-,-<break>Client<>unitPrice>>R,-,-,-<break>Client<>amount>>R,-,-,-<break>Client<>delivered>>R,-,-,-<break>Client<>Good>>R,-,I,D<break>Client<>Person>>R,-,-,-<break>Client<>Person>>R,-,-,-<break>Client<>ShippingDate>>R,-,-,-<break>Client<>Payment>>R,-,-,-<break>Client<>name>>R,W,-,-<break>Client<>address>>R,W,-,-<break>Accounting<>cardName>>R,-,-,-<break>Accounting<>cardNo>>R,-,-,-<break>Accounting<>expiryDate>>R,-,-,-<break>Accounting<>accepted>>R,W,-,-<break>Accounting<>quantity>>R,-,-,-<break>Accounting<>itemCode>>R,-,-,-<break>Accounting<>description>>R,-,-,-<break>Accounting<>unitPrice>>R,-,-,-<break>Accounting<>amount>>R,-,-,-<break>Accounting<>delivered>>R,-,-,-<break>Accounting<>Good>>R,-,-,-<break>Accounting<>Person>>R,-,-,-<break>Accounting<>Person>>R,-,-,-<break>Accounting<>ShippingDate>>R,-,-,-<break>Accounting<>Payment>>R,W,-,-<break>Accounting<>name>>R,-,-,-<break>Accounting<>address>>R,-,-,-<break>Seller<>cardName>>-,-,-,-<break>Seller<>cardNo>>-,-,-,-<break>Seller<>expiryDate>>-,-,-,-<break>Seller<>accepted>>-,-,-,-<break>Seller<>quantity>>R,W,-,-<break>Seller<>itemCode>>R,W,-,-<break>Seller<>description>>R,W,-,-<break>Seller<>unitPrice>>R,W,-,-<break>Seller<>amount>>R,W,-,-<break>Seller<>delivered>>R,-,-,-<break>Seller<>Good>>R,-,-,-<break>Seller<>Person>>R,-,-,-<break>Seller<>Person>>R,W,-,-<break>Seller<>ShippingDate>>R,-,-,-<break>Seller<>Payment>>-,-,-,-<break>Seller<>name>>R,W,-,-<break>Seller<>address>>R,W,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (204,'Group4',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"PurchaseOrder4\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																					\n							<xs:element name=\"clientData\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"ParticipantData\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"name\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"address\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																									\n							<xs:element name=\"sellerData\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"ParticipantData\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"name\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"address\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																	\n							<xs:element name=\"orderRow\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"Order\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"quantity\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"itemCode\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"description\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"unitPrice\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"amount\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"delivered\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																																																																																																																																																																																																																													\n							<xs:element name=\"paymentInfo\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"PaymentInfo\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"cardHoldersName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"cardNumber\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"date\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"paymentStatus\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n												</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group4 form - Purchase order','admin','DeliveryDepartment<>quantity>>R,-,-,-<break>DeliveryDepartment<>itemCode>>R,-,-,-<break>DeliveryDepartment<>description>>R,-,-,-<break>DeliveryDepartment<>unitPrice>>R,-,-,-<break>DeliveryDepartment<>amount>>R,-,-,-<break>DeliveryDepartment<>delivered>>R,W,-,-<break>DeliveryDepartment<>ParticipantData>>R,-,-,-<break>DeliveryDepartment<>ParticipantData>>-,-,-,-<break>DeliveryDepartment<>Order>>R,-,-,-<break>DeliveryDepartment<>PaymentInfo>>-,-,-,-<break>DeliveryDepartment<>name>>R,-,-,-<break>DeliveryDepartment<>address>>R,-,-,-<break>DeliveryDepartment<>cardHoldersName>>-,-,-,-<break>DeliveryDepartment<>cardNumber>>-,-,-,-<break>DeliveryDepartment<>date>>R,W,-,-<break>DeliveryDepartment<>paymentStatus>>-,-,-,-<break>Client<>quantity>>R,W,-,-<break>Client<>itemCode>>R,-,-,-<break>Client<>description>>R,W,-,-<break>Client<>unitPrice>>R,-,-,-<break>Client<>amount>>R,-,-,-<break>Client<>delivered>>R,-,-,-<break>Client<>ParticipantData>>R,-,-,-<break>Client<>ParticipantData>>-,-,-,-<break>Client<>Order>>R,-,I,-<break>Client<>PaymentInfo>>R,-,-,-<break>Client<>name>>R,W,-,-<break>Client<>address>>R,W,-,-<break>Client<>cardHoldersName>>R,W,-,-<break>Client<>cardNumber>>R,W,-,-<break>Client<>date>>R,W,-,-<break>Client<>paymentStatus>>R,-,-,-<break>Accounting<>quantity>>R,-,-,-<break>Accounting<>itemCode>>R,-,-,-<break>Accounting<>description>>R,-,-,-<break>Accounting<>unitPrice>>R,-,-,-<break>Accounting<>amount>>R,-,-,-<break>Accounting<>delivered>>R,-,-,-<break>Accounting<>ParticipantData>>-,-,-,-<break>Accounting<>ParticipantData>>-,-,-,-<break>Accounting<>Order>>R,-,-,-<break>Accounting<>PaymentInfo>>R,W,-,-<break>Accounting<>name>>R,-,-,-<break>Accounting<>address>>R,-,-,-<break>Accounting<>cardHoldersName>>R,-,-,-<break>Accounting<>cardNumber>>R,-,-,-<break>Accounting<>date>>R,-,-,-<break>Accounting<>paymentStatus>>R,W,-,-<break>Seller<>quantity>>R,W,-,-<break>Seller<>itemCode>>R,W,-,-<break>Seller<>description>>R,W,-,-<break>Seller<>unitPrice>>R,W,-,-<break>Seller<>amount>>R,W,-,-<break>Seller<>delivered>>R,-,-,-<break>Seller<>ParticipantData>>R,-,-,-<break>Seller<>ParticipantData>>R,-,-,-<break>Seller<>Order>>R,-,-,-<break>Seller<>PaymentInfo>>-,-,-,-<break>Seller<>name>>R,W,-,-<break>Seller<>address>>R,W,-,-<break>Seller<>cardHoldersName>>-,-,-,-<break>Seller<>cardNumber>>-,-,-,-<break>Seller<>date>>-,-,-,-<break>Seller<>paymentStatus>>-,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (205,'Group5',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"ApplicationForm5\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																												\n		<xs:element name=\"StudentSSN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"LastName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"FirstName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"email\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																			\n							<xs:element name=\"registerdCN\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"courseNumero\" minOccurs=\"1\" maxOccurs=\"unbounded\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"number\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																								\n		<xs:element name=\"fee\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"scholarship\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"CN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"cardNumero\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"FNS\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"GPA\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																																																																								\n		<xs:element name=\"reqField\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group5 form - Application','admin','StudyCommittee<>StudentSSN>>R,-,-,-<break>StudyCommittee<>LastName>>R,-,-,-<break>StudyCommittee<>FirstName>>R,-,-,-<break>StudyCommittee<>email>>R,-,-,-<break>StudyCommittee<>courseNumero>>R,-,-,-<break>StudyCommittee<>fee>>R,W,-,-<break>StudyCommittee<>scholarship>>R,W,-,-<break>StudyCommittee<>CN>>R,-,-,-<break>StudyCommittee<>cardNumero>>R,-,-,-<break>StudyCommittee<>FNS>>R,-,-,-<break>StudyCommittee<>GPA>>R,-,-,-<break>StudyCommittee<>reqField>>R,-,-,-<break>StudyCommittee<>number>>R,-,-,-<break>EvaluationTeam<>StudentSSN>>R,-,-,-<break>EvaluationTeam<>LastName>>-,-,-,-<break>EvaluationTeam<>FirstName>>-,-,-,-<break>EvaluationTeam<>email>>-,-,-,-<break>EvaluationTeam<>courseNumero>>R,-,-,-<break>EvaluationTeam<>fee>>-,-,-,-<break>EvaluationTeam<>scholarship>>-,-,-,-<break>EvaluationTeam<>CN>>-,-,-,-<break>EvaluationTeam<>cardNumero>>-,-,-,-<break>EvaluationTeam<>FNS>>-,-,-,-<break>EvaluationTeam<>GPA>>R,-,-,-<break>EvaluationTeam<>reqField>>R,W,-,-<break>EvaluationTeam<>number>>R,-,-,-<break>Student<>StudentSSN>>R,W,-,-<break>Student<>LastName>>R,W,-,-<break>Student<>FirstName>>R,W,-,-<break>Student<>email>>R,W,-,-<break>Student<>courseNumero>>R,W,I,-<break>Student<>fee>>-,-,-,-<break>Student<>scholarship>>-,-,-,-<break>Student<>CN>>R,W,-,-<break>Student<>cardNumero>>R,W,-,-<break>Student<>FNS>>R,-,-,-<break>Student<>GPA>>R,W,-,-<break>Student<>reqField>>-,-,-,-<break>Student<>number>>R,W,-,-<break>Accountant<>StudentSSN>>-,-,-,-<break>Accountant<>LastName>>-,-,-,-<break>Accountant<>FirstName>>-,-,-,-<break>Accountant<>email>>-,-,-,-<break>Accountant<>courseNumero>>-,-,-,-<break>Accountant<>fee>>R,-,-,-<break>Accountant<>scholarship>>R,-,-,-<break>Accountant<>CN>>R,-,-,-<break>Accountant<>cardNumero>>R,-,-,-<break>Accountant<>FNS>>R,W,-,-<break>Accountant<>GPA>>-,-,-,-<break>Accountant<>reqField>>-,-,-,-<break>Accountant<>number>>-,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (206,'Group6',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"PurchaseOrder6\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																												\n		<xs:element name=\"sellerName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"sellerAddress\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"clientName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"clientAddress\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																													\n							<xs:element name=\"itemList\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"ItemList\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"quantity\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"itemCode\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"unitPrice\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"amount\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"delivery\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"description\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																																																																																																																																																																																																																												\n		<xs:element name=\"paymentInfo\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group6 form - Purchase order','admin','DeliveryDepartment<>quantity>>R,-,-,-<break>DeliveryDepartment<>itemCode>>R,-,-,-<break>DeliveryDepartment<>unitPrice>>R,-,-,-<break>DeliveryDepartment<>amount>>R,-,-,-<break>DeliveryDepartment<>delivery>>R,W,-,-<break>DeliveryDepartment<>description>>R,-,-,-<break>DeliveryDepartment<>sellerName>>-,-,-,-<break>DeliveryDepartment<>sellerAddress>>-,-,-,-<break>DeliveryDepartment<>clientName>>R,-,-,-<break>DeliveryDepartment<>clientAddress>>R,-,-,-<break>DeliveryDepartment<>ItemList>>R,-,-,-<break>DeliveryDepartment<>paymentInfo>>-,-,-,-<break>Client<>quantity>>R,W,-,-<break>Client<>itemCode>>R,-,-,-<break>Client<>unitPrice>>R,-,-,-<break>Client<>amount>>R,-,-,-<break>Client<>delivery>>R,-,-,-<break>Client<>description>>R,W,-,-<break>Client<>sellerName>>R,-,-,-<break>Client<>sellerAddress>>R,-,-,-<break>Client<>clientName>>R,W,-,-<break>Client<>clientAddress>>R,W,-,-<break>Client<>ItemList>>R,-,I,-<break>Client<>paymentInfo>>R,-,-,-<break>Accounting<>quantity>>R,-,-,-<break>Accounting<>itemCode>>R,-,-,-<break>Accounting<>unitPrice>>R,-,-,-<break>Accounting<>amount>>R,-,-,-<break>Accounting<>delivery>>-,-,-,-<break>Accounting<>description>>R,-,-,-<break>Accounting<>sellerName>>-,-,-,-<break>Accounting<>sellerAddress>>-,-,-,-<break>Accounting<>clientName>>R,-,-,-<break>Accounting<>clientAddress>>-,-,-,-<break>Accounting<>ItemList>>-,-,-,-<break>Accounting<>paymentInfo>>R,W,-,-<break>Seller<>quantity>>R,W,-,-<break>Seller<>itemCode>>R,W,-,-<break>Seller<>unitPrice>>R,W,-,-<break>Seller<>amount>>R,W,-,-<break>Seller<>delivery>>R,-,-,-<break>Seller<>description>>R,W,-,-<break>Seller<>sellerName>>R,W,-,-<break>Seller<>sellerAddress>>R,W,-,-<break>Seller<>clientName>>R,-,-,-<break>Seller<>clientAddress>>R,-,-,-<break>Seller<>ItemList>>R,-,-,-<break>Seller<>paymentInfo>>-,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (207,'Group7',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"PurchaseOrder7\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																																										\n							<xs:element name=\"requested_items\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"OrderRequest\" minOccurs=\"1\" maxOccurs=\"unbounded\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"description\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"itemCode\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"quantity\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"unitPrice\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																									\n							<xs:element name=\"contact_info\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"ContactInfo\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"name\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"address\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																																																																																																	\n							<xs:element name=\"payment_status\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"PaymentStatus\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"cardHoldersName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"cardNumber\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"expiringDate\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"payment\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																	\n							<xs:element name=\"shipping_status\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"ShippingStatus\" minOccurs=\"1\" maxOccurs=\"1\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"date\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"delivered\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n												</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group7 form - Purchase order','admin','DeliveryDepartment<>name>>R,-,-,-<break>DeliveryDepartment<>address>>R,-,-,-<break>DeliveryDepartment<>description>>R,-,-,-<break>DeliveryDepartment<>itemCode>>R,-,-,-<break>DeliveryDepartment<>quantity>>R,-,-,-<break>DeliveryDepartment<>unitPrice>>R,-,-,-<break>DeliveryDepartment<>OrderRequest>>R,-,-,-<break>DeliveryDepartment<>ContactInfo>>R,-,-,-<break>DeliveryDepartment<>PaymentStatus>>-,-,-,-<break>DeliveryDepartment<>ShippingStatus>>R,-,-,-<break>DeliveryDepartment<>cardHoldersName>>-,-,-,-<break>DeliveryDepartment<>cardNumber>>-,-,-,-<break>DeliveryDepartment<>expiringDate>>-,-,-,-<break>DeliveryDepartment<>payment>>-,-,-,-<break>DeliveryDepartment<>date>>R,W,-,-<break>DeliveryDepartment<>delivered>>R,W,-,-<break>Seller<>name>>R,W,-,-<break>Seller<>address>>R,W,-,-<break>Seller<>description>>R,W,-,-<break>Seller<>itemCode>>R,W,-,-<break>Seller<>quantity>>R,W,-,-<break>Seller<>unitPrice>>R,W,-,-<break>Seller<>OrderRequest>>R,-,-,-<break>Seller<>ContactInfo>>R,-,-,-<break>Seller<>PaymentStatus>>-,-,-,-<break>Seller<>ShippingStatus>>-,-,-,-<break>Seller<>cardHoldersName>>-,-,-,-<break>Seller<>cardNumber>>-,-,-,-<break>Seller<>expiringDate>>-,-,-,-<break>Seller<>payment>>-,-,-,-<break>Seller<>date>>-,-,-,-<break>Seller<>delivered>>R,-,-,-<break>Client<>name>>R,W,-,-<break>Client<>address>>R,W,-,-<break>Client<>description>>R,W,-,-<break>Client<>itemCode>>R,-,-,-<break>Client<>quantity>>R,W,-,-<break>Client<>unitPrice>>R,-,-,-<break>Client<>OrderRequest>>R,W,I,-<break>Client<>ContactInfo>>R,W,-,-<break>Client<>PaymentStatus>>R,W,-,-<break>Client<>ShippingStatus>>-,-,-,-<break>Client<>cardHoldersName>>R,W,-,-<break>Client<>cardNumber>>R,W,-,-<break>Client<>expiringDate>>R,W,-,-<break>Client<>payment>>R,-,-,-<break>Client<>date>>R,W,-,-<break>Client<>delivered>>R,-,-,-<break>Accounting<>name>>R,-,-,-<break>Accounting<>address>>R,-,-,-<break>Accounting<>description>>R,-,-,-<break>Accounting<>itemCode>>R,-,-,-<break>Accounting<>quantity>>R,-,-,-<break>Accounting<>unitPrice>>R,-,-,-<break>Accounting<>OrderRequest>>-,-,-,-<break>Accounting<>ContactInfo>>-,-,-,-<break>Accounting<>PaymentStatus>>R,-,-,-<break>Accounting<>ShippingStatus>>-,-,-,-<break>Accounting<>cardHoldersName>>R,-,-,-<break>Accounting<>cardNumber>>R,-,-,-<break>Accounting<>expiringDate>>R,W,-,-<break>Accounting<>payment>>R,W,-,-<break>Accounting<>date>>R,-,-,-<break>Accounting<>delivered>>R,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (208,'Group8',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"DOC\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																												\n		<xs:element name=\"SSN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"lastName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"firstName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"previousYearInfo\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																															\n							<xs:element name=\"registeredCourse\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"Course\" minOccurs=\"1\" maxOccurs=\"unbounded\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"courseName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"courseNr\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																																																																																																																																																																																																																				\n		<xs:element name=\"passed\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"scholarship\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"payment\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group8 form - Application','admin','StudyCommittee<>courseName>>R,-,-,-<break>StudyCommittee<>courseNr>>R,-,-,-<break>StudyCommittee<>SSN>>R,-,-,-<break>StudyCommittee<>lastName>>R,-,-,-<break>StudyCommittee<>firstName>>R,-,-,-<break>StudyCommittee<>previousYearInfo>>R,-,-,-<break>StudyCommittee<>Course>>-,-,-,-<break>StudyCommittee<>passed>>R,-,-,-<break>StudyCommittee<>scholarship>>R,W,-,-<break>StudyCommittee<>payment>>-,-,-,-<break>EvaluationTeam<>courseName>>R,-,-,-<break>EvaluationTeam<>courseNr>>R,-,-,-<break>EvaluationTeam<>SSN>>R,-,-,-<break>EvaluationTeam<>lastName>>-,-,-,-<break>EvaluationTeam<>firstName>>-,-,-,-<break>EvaluationTeam<>previousYearInfo>>R,-,-,-<break>EvaluationTeam<>Course>>-,-,-,-<break>EvaluationTeam<>passed>>R,W,-,-<break>EvaluationTeam<>scholarship>>-,-,-,-<break>EvaluationTeam<>payment>>-,-,-,-<break>Accountant<>courseName>>-,-,-,-<break>Accountant<>courseNr>>-,-,-,-<break>Accountant<>SSN>>-,-,-,-<break>Accountant<>lastName>>-,-,-,-<break>Accountant<>firstName>>-,-,-,-<break>Accountant<>previousYearInfo>>-,-,-,-<break>Accountant<>Course>>-,-,-,-<break>Accountant<>passed>>-,-,-,-<break>Accountant<>scholarship>>R,-,-,-<break>Accountant<>payment>>R,W,-,-<break>Student<>courseName>>R,W,-,-<break>Student<>courseNr>>R,W,-,-<break>Student<>SSN>>R,W,-,-<break>Student<>lastName>>R,W,-,-<break>Student<>firstName>>R,W,-,-<break>Student<>previousYearInfo>>R,W,-,-<break>Student<>Course>>R,W,-,-<break>Student<>passed>>-,W,-,-<break>Student<>scholarship>>-,-,-,-<break>Student<>payment>>-,-,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (209,'Group9',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"Subscription\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																												\n		<xs:element name=\"SSN\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"LastName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"FirstName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"Email\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"CardholderName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"CardNumber\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"School\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"GPA\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																															\n							<xs:element name=\"RegisteredCourseNr\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"CourseNr\" minOccurs=\"1\" maxOccurs=\"unbounded\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"RegCourseNumber\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																												\n		<xs:element name=\"Fee\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"Scholarship\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																\n		<xs:element name=\"AreRequirementsFilled\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																																																																								\n		<xs:element name=\"PaymentAccepted\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n								</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Group9 form - Application','admin','StudyCommittee<>SSN>>R,-,-,-<break>StudyCommittee<>LastName>>R,-,-,-<break>StudyCommittee<>FirstName>>R,-,-,-<break>StudyCommittee<>Email>>R,-,-,-<break>StudyCommittee<>CardholderName>>R,-,-,-<break>StudyCommittee<>CardNumber>>R,-,-,-<break>StudyCommittee<>School>>R,-,-,-<break>StudyCommittee<>GPA>>R,-,-,-<break>StudyCommittee<>CourseNr>>R,-,-,-<break>StudyCommittee<>Fee>>R,-,-,-<break>StudyCommittee<>Scholarship>>R,W,-,-<break>StudyCommittee<>AreRequirementsFilled>>R,-,-,-<break>StudyCommittee<>PaymentAccepted>>R,-,-,-<break>StudyCommittee<>RegCourseNumber>>R,-,-,-<break>EvaluationTeam<>SSN>>R,-,-,-<break>EvaluationTeam<>LastName>>-,-,-,-<break>EvaluationTeam<>FirstName>>-,-,-,-<break>EvaluationTeam<>Email>>-,-,-,-<break>EvaluationTeam<>CardholderName>>-,-,-,-<break>EvaluationTeam<>CardNumber>>-,-,-,-<break>EvaluationTeam<>School>>R,-,-,-<break>EvaluationTeam<>GPA>>R,-,-,-<break>EvaluationTeam<>CourseNr>>R,-,-,-<break>EvaluationTeam<>Fee>>R,W,-,-<break>EvaluationTeam<>Scholarship>>-,-,-,-<break>EvaluationTeam<>AreRequirementsFilled>>R,W,-,-<break>EvaluationTeam<>PaymentAccepted>>-,-,-,-<break>EvaluationTeam<>RegCourseNumber>>R,-,-,-<break>Accountant<>SSN>>-,-,-,-<break>Accountant<>LastName>>-,-,-,-<break>Accountant<>FirstName>>-,-,-,-<break>Accountant<>Email>>-,-,-,-<break>Accountant<>CardholderName>>R,W,-,-<break>Accountant<>CardNumber>>R,W,-,-<break>Accountant<>School>>-,-,-,-<break>Accountant<>GPA>>-,-,-,-<break>Accountant<>CourseNr>>R,-,-,-<break>Accountant<>Fee>>R,W,-,-<break>Accountant<>Scholarship>>R,W,-,-<break>Accountant<>AreRequirementsFilled>>-,-,-,-<break>Accountant<>PaymentAccepted>>R,W,-,-<break>Accountant<>RegCourseNumber>>-,-,-,-<break>Student<>SSN>>R,W,-,-<break>Student<>LastName>>R,W,-,-<break>Student<>FirstName>>R,W,-,-<break>Student<>Email>>R,W,-,-<break>Student<>CardholderName>>R,W,-,-<break>Student<>CardNumber>>R,W,-,-<break>Student<>School>>R,W,-,-<break>Student<>GPA>>R,W,-,-<break>Student<>CourseNr>>R,W,I,D<break>Student<>Fee>>-,-,-,-<break>Student<>Scholarship>>-,-,-,-<break>Student<>AreRequirementsFilled>>-,-,-,-<break>Student<>PaymentAccepted>>-,-,-,-<break>Student<>RegCourseNumber>>R,W,-,-<break>');
INSERT INTO `document_template` (`ID`,`NAME`,`RULES`,`TEMPLATE_XSD`,`DESCRIPTION`,`OWNER`,`PERMISSIONS`) VALUES (300,'ExamplePurchaseOrder',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n<xs:element name=\"PurchaseOrderTark\">\n	<xs:complexType>\n		<xs:sequence>\n																																																																																																																																												\n		<xs:element name=\"clientNameAndAddress\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																								\n		<xs:element name=\"sellerNameAndAddress\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																											\n							<xs:element name=\"orderRows\">			\n			<xs:complexType>\n				<xs:sequence>\n				<xs:element name=\"OrderRow\" minOccurs=\"1\" maxOccurs=\"unbounded\">\n				<xs:complexType>\n				<xs:sequence>\n																								<xs:element name=\"quantity\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"itemCode\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"description\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"unitPrice\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"totalAmount\" type=\"xs:decimal\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																									<xs:element name=\"isDelivered\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n									</xs:sequence>\n				</xs:complexType>\n				</xs:element>\n				</xs:sequence>\n			</xs:complexType>\n		</xs:element>\n																																																																																																																\n		<xs:element name=\"shippingDate\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																								\n		<xs:element name=\"cardHoldersName\" type=\"xs:string\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																								\n		<xs:element name=\"cardNumber\" type=\"xs:int\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																								\n		<xs:element name=\"expirationDate\" type=\"xs:date\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																								\n		<xs:element name=\"paymentAccepted\" type=\"xs:boolean\" minOccurs=\"1\" maxOccurs=\"1\"/>\n																																																																																																																																																																																																																																																																																						</xs:sequence>\n	</xs:complexType>\n</xs:element>\n</xs:schema>','Example2 - Purchase Order','admin','DeliveryDepartment<>clientNameAndAddress>>R,-,-,-<break>DeliveryDepartment<>sellerNameAndAddress>>-,-,-,-<break>DeliveryDepartment<>OrderRow>>R,-,-,-<break>DeliveryDepartment<>shippingDate>>R,W,-,-<break>DeliveryDepartment<>cardHoldersName>>-,-,-,-<break>DeliveryDepartment<>cardNumber>>-,-,-,-<break>DeliveryDepartment<>expirationDate>>-,-,-,-<break>DeliveryDepartment<>paymentAccepted>>-,-,-,-<break>DeliveryDepartment<>quantity>>R,-,-,-<break>DeliveryDepartment<>itemCode>>R,-,-,-<break>DeliveryDepartment<>description>>R,-,-,-<break>DeliveryDepartment<>unitPrice>>R,-,-,-<break>DeliveryDepartment<>totalAmount>>R,-,-,-<break>DeliveryDepartment<>isDelivered>>R,W,-,-<break>Client<>clientNameAndAddress>>R,W,-,-<break>Client<>sellerNameAndAddress>>-,-,-,-<break>Client<>OrderRow>>R,-,I,-<break>Client<>shippingDate>>-,-,-,-<break>Client<>cardHoldersName>>R,W,-,-<break>Client<>cardNumber>>R,W,-,-<break>Client<>expirationDate>>R,W,-,-<break>Client<>paymentAccepted>>-,-,-,-<break>Client<>quantity>>R,W,-,-<break>Client<>itemCode>>R,-,-,-<break>Client<>description>>R,W,-,-<break>Client<>unitPrice>>R,-,-,-<break>Client<>totalAmount>>R,-,-,-<break>Client<>isDelivered>>R,-,-,-<break>Accounting<>clientNameAndAddress>>-,-,-,-<break>Accounting<>sellerNameAndAddress>>-,-,-,-<break>Accounting<>OrderRow>>R,-,-,-<break>Accounting<>shippingDate>>-,-,-,-<break>Accounting<>cardHoldersName>>R,-,-,-<break>Accounting<>cardNumber>>R,-,-,-<break>Accounting<>expirationDate>>R,-,-,-<break>Accounting<>paymentAccepted>>R,W,-,-<break>Accounting<>quantity>>R,-,-,-<break>Accounting<>itemCode>>R,-,-,-<break>Accounting<>description>>R,-,-,-<break>Accounting<>unitPrice>>R,-,-,-<break>Accounting<>totalAmount>>R,-,-,-<break>Accounting<>isDelivered>>R,-,-,-<break>Seller<>clientNameAndAddress>>R,-,-,-<break>Seller<>sellerNameAndAddress>>R,W,-,-<break>Seller<>OrderRow>>R,-,-,D<break>Seller<>shippingDate>>-,-,-,-<break>Seller<>cardHoldersName>>-,-,-,-<break>Seller<>cardNumber>>-,-,-,-<break>Seller<>expirationDate>>-,-,-,-<break>Seller<>paymentAccepted>>-,-,-,-<break>Seller<>quantity>>R,W,-,-<break>Seller<>itemCode>>R,W,-,-<break>Seller<>description>>R,W,-,-<break>Seller<>unitPrice>>R,W,-,-<break>Seller<>totalAmount>>R,W,-,-<break>Seller<>isDelivered>>R,-,-,-<break>ADMIN<>clientNameAndAddress>>R,-,-,-<break>ADMIN<>sellerNameAndAddress>>R,-,-,-<break>ADMIN<>OrderRow>>R,-,-,-<break>ADMIN<>shippingDate>>R,-,-,-<break>ADMIN<>cardHoldersName>>R,-,-,-<break>ADMIN<>cardNumber>>R,-,-,-<break>ADMIN<>expirationDate>>R,-,-,-<break>ADMIN<>paymentAccepted>>R,-,-,-<break>ADMIN<>quantity>>R,-,-,-<break>ADMIN<>itemCode>>R,-,-,-<break>ADMIN<>description>>R,-,-,-<break>ADMIN<>unitPrice>>R,-,-,-<break>ADMIN<>totalAmount>>R,-,-,-<break>ADMIN<>isDelivered>>R,-,-,-<break>');
