se/SE/schema/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" elementFormDefault="qualified"
	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">
		<xs:restriction base="xs:string"/>
	</xs:simpleType>
	<xs:simpleType name="text">
		<xs:restriction base="xs:string"/>
	</xs:simpleType>
	<xs:simpleType name="enumeration">
		<xs:restriction base="xs:string"/>
	</xs:simpleType>
	<xs:simpleType name="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">
		<xs:restriction base="xs:integer"/>
	</xs:simpleType>
	<xs:simpleType name="decimal">
		<xs:restriction base="xs:decimal"/>
	</xs:simpleType>
	<xs:simpleType name="double">
		<xs:restriction base="xs:double"/>
	</xs:simpleType>
	<xs:simpleType name="float">
		<xs:restriction base="xs:double"/>
	</xs:simpleType>
	<xs:simpleType name="binary">
		<xs:restriction base="xs:hexBinary"/>
	</xs:simpleType>
	<xs:simpleType name="hexBinary">
		<xs:restriction base="xs:hexBinary"/>
	</xs:simpleType>

	<xs:simpleType name="date">
		<xs:union memberTypes="xs:date p5Type:dateZero"/>
	</xs:simpleType>
	<xs:simpleType name="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">
		<xs:union memberTypes="xs:dateTime p5Type:dateTimeZero"/>
	</xs:simpleType>
	<xs:simpleType name="dateTimeZero">
		<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">
		<xs:union memberTypes="xs:time p5Type:timeZero"/>
	</xs:simpleType>
	<xs:simpleType name="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">
		<xs:union memberTypes="xs:gYear p5Type:yearZero"/>
	</xs:simpleType>
	<xs:simpleType name="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">
		<xs:restriction base="xs:string"/>
	</xs:simpleType>
	<xs:simpleType name="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">
		<xs:restriction base="xs:string">
			<xs:pattern value="\-?\d\.?\d*,\-?\d\.?\d*"/>
		</xs:restriction>
	</xs:simpleType>
	<xs:simpleType name="lineString">
		<xs:restriction base="xs:string">
			<xs:pattern value="(\-?\d+\.?\d*,\-?\d+\.?\d*)( (\-?\d+\.?\d*,\-?\d+\.?\d*))+"/>
		</xs:restriction>
	</xs:simpleType>
</xs:schema>