se/SE/schema/Types/types.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:p5TypeParam="http://biuro.biall-net.pl/p5/schema/typeParams"
           xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
           xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
           xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
           xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
           xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
           xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
           elementFormDefault="qualified" system_cache__appinfo:document-uri="Types/types.xsd"
           targetNamespace="http://biuro.biall-net.pl/p5/schema/types"><!--<xs:import namespace="http://biuro.biall-net.pl/p5/schema/typeParams" schemaLocation=""/>
	@2018-03-23 bindera: widze, ze tego nie ma i raczej jest niepotrzebne?
	-->
   <xs:simpleType name="string" id="p___d15e99718-1_string">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:simpleType name="text" id="p___d15e99720-1_text">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:simpleType name="enumeration" id="p___d15e99722-1_enumeratio">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:simpleType name="set" id="p___d15e99724-1_set">
      <xs:annotation>
         <xs:documentation>
Example appinfo for `CRM_PRZYPADEK`.`FORM_TREAT` field defined as set('', 'R', 'W', 'X', 'C', 'S', 'O', 'V', 'E'):
<xs:appinfo>
               <p5TypeParam:param name="enumeration">
                  <p5TypeParam:enumeration value="0" label="" description="Brak"/>
                  <p5TypeParam:enumeration value="2" label="R" description="Read"/>
                  <p5TypeParam:enumeration value="4" label="W" description="Write"/>
                  <p5TypeParam:enumeration value="8" label="X" description="Execute"/>
                  <p5TypeParam:enumeration value="16" label="C" description="Create"/>
                  <p5TypeParam:enumeration value="32" label="S" description="..."/>
                  <p5TypeParam:enumeration value="64" label="O" description="..."/>
                  <p5TypeParam:enumeration value="124" label="V" description="..."/>
                  <p5TypeParam:enumeration value="256" label="E" description="Export"/>
               </p5TypeParam:param>
            </xs:appinfo>

SELECT ID, `FORM_TREAT`, CAST(`FORM_TREAT` AS UNSIGNED) FROM `CRM_PRZYPADEK`;

	IF 8 == 'X' THEN
		insert into `CRM_PRZYPADEK`(`FORM_TREAT`) values('X');
	IS EQUAL TO
		insert into `CRM_PRZYPADEK`(`FORM_TREAT`) values(8);

			</xs:documentation>
      </xs:annotation>
      <xs:restriction base="xs:integer"/>
   </xs:simpleType>
   <xs:simpleType name="integer" id="p___d15e99741-1_integer">
      <xs:restriction base="xs:integer"/>
   </xs:simpleType>
   <xs:simpleType name="decimal" id="p___d15e99743-1_decimal">
      <xs:restriction base="xs:decimal"/>
   </xs:simpleType>
   <xs:simpleType name="double" id="p___d15e99745-1_double">
      <xs:restriction base="xs:double"/>
   </xs:simpleType>
   <xs:simpleType name="float" id="p___d15e99747-1_float">
      <xs:restriction base="xs:double"/>
   </xs:simpleType>
   <xs:simpleType name="binary" id="p___d15e99749-1_binary">
      <xs:restriction base="xs:hexBinary"/>
   </xs:simpleType>
   <xs:simpleType name="hexBinary" id="p___d15e99751-1_hexBinary">
      <xs:restriction base="xs:hexBinary"/>
   </xs:simpleType>
   <xs:simpleType name="date" id="p___d15e99754-1_date">
      <xs:union memberTypes="xs:date p5Type:dateZero"/>
   </xs:simpleType>
   <xs:simpleType name="dateZero" id="p___d15e99756-1_dateZero">
      <xs:restriction base="xs:string">
         <xs:enumeration value="0000-00-00"/>
         <xs:enumeration value="CURRENT_TIMESTAMP"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="dateTime" id="p___d15e99760-1_dateTime">
      <xs:union memberTypes="xs:dateTime p5Type:dateTimeZero"/>
   </xs:simpleType>
   <xs:simpleType name="dateTimeZero" id="p___d15e99762-1_dateTimeZe">
      <xs:restriction base="xs:string">
         <xs:enumeration value="0000-00-00 00:00:00"/>
         <xs:enumeration value="CURRENT_TIMESTAMP"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="time" id="p___d15e99766-1_time">
      <xs:union memberTypes="xs:time p5Type:timeZero"/>
   </xs:simpleType>
   <xs:simpleType name="timeZero" id="p___d15e99768-1_timeZero">
      <xs:restriction base="xs:string">
         <xs:enumeration value="00:00:00"/>
         <xs:enumeration value="CURRENT_TIMESTAMP"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="year" id="p___d15e99772-1_year">
      <xs:union memberTypes="xs:gYear p5Type:yearZero"/>
   </xs:simpleType>
   <xs:simpleType name="yearZero" id="p___d15e99774-1_yearZero">
      <xs:restriction base="xs:string">
         <xs:enumeration value="0000"/>
         <xs:enumeration value="CURRENT_TIMESTAMP"/>
      </xs:restriction>
   </xs:simpleType>
   <!--
TODO: Geometry
TODO: MultiPolygon
TODO: MultiPoint
TODO: MultiLineString
TODO: GeometryCollection

	<gml:MultiPolygon>
		<gml:polygonMember>
			<gml:Polygon>
	...
-->
   <xs:simpleType name="geometry" id="p___d15e99779-1_geometry">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:simpleType name="polygon" id="p___d15e99781-1_polygon">
      <xs:restriction base="xs:string">
         <xs:pattern value="(\-?\d+\.?\d*,-?\d+\.?\d*)( (\-?\d+\.?\d*,-?\d+\.?\d*))+"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="point" id="p___d15e99785-1_point">
      <xs:restriction base="xs:string">
         <xs:pattern value="\-?\d\.?\d*,\-?\d\.?\d*"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="lineString" id="p___d15e99788-1_lineString">
      <xs:restriction base="xs:string">
         <xs:pattern value="(\-?\d+\.?\d*,\-?\d+\.?\d*)( (\-?\d+\.?\d*,\-?\d+\.?\d*))+"/>
      </xs:restriction>
   </xs:simpleType>
</xs:schema>