Gecko [ 196.203.21.74 ]

Name	Size	Permission
DropSqlPersistenceProviderLogi...	2.34 KB	-rw-rw-rw-
DropSqlPersistenceProviderSche...	1.29 KB	-rw-rw-rw-
SqlPersistenceProviderLogic.sq...	13.17 KB	-rw-rw-rw-
SqlPersistenceProviderSchema.s...	2.09 KB	-rw-rw-rw-

Code Editor : SqlPersistenceProviderSchema.sql

��S�E�T� �A�N�S�I�_�N�U�L�L�S� �O�N�
�
�G�O�
�
�S�E�T� �Q�U�O�T�E�D�_�I�D�E�N�T�I�F�I�E�R� �O�N�
�
�G�O�
�
�
�
�d�e�c�l�a�r�e� �@�l�o�c�a�l�i�z�e�d�_�s�t�r�i�n�g�_�A�d�d�R�o�l�e�_�F�a�i�l�e�d� �n�v�a�r�c�h�a�r�(�2�5�6�)�
�
�s�e�t� �@�l�o�c�a�l�i�z�e�d�_�s�t�r�i�n�g�_�A�d�d�R�o�l�e�_�F�a�i�l�e�d� �=� �N�'�F�a�i�l�e�d� �a�d�d�i�n�g� �t�h�e� �'�'�p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s�'�'� �r�o�l�e�'�
�
�
�
�D�E�C�L�A�R�E� �@�r�e�t� �i�n�t�,� �@�E�r�r�o�r� �i�n�t�
�
�I�F� �N�O�T� �E�X�I�S�T�S�(� �S�E�L�E�C�T� �1� �F�R�O�M� �[�d�b�o�]�.�[�s�y�s�u�s�e�r�s�]� �W�H�E�R�E� �n�a�m�e�=�N�'�p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s�'� �a�n�d� �i�s�s�q�l�r�o�l�e�=�1� �)�
�
� �B�E�G�I�N�
�
�
�
�	�E�X�E�C� �@�r�e�t� �=� �s�p�_�a�d�d�r�o�l�e� �N�'�p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s�'�
�
�
�
�	�S�E�L�E�C�T� �@�E�r�r�o�r� �=� �@�@�E�R�R�O�R�
�
�
�
�	�I�F� �@�r�e�t� �<�>� �0� �o�r� �@�E�r�r�o�r� �<�>� �0�
�
�	�	�R�A�I�S�E�R�R�O�R�(� �@�l�o�c�a�l�i�z�e�d�_�s�t�r�i�n�g�_�A�d�d�R�o�l�e�_�F�a�i�l�e�d�,� �1�6�,� �-�1� �)�
�
� �E�N�D�
�
�G�O�
�
�
�
�I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �s�y�s�.�o�b�j�e�c�t�s� �W�H�E�R�E� �o�b�j�e�c�t�_�i�d� �=� �O�B�J�E�C�T�_�I�D�(�N�'�[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]�'�)� �A�N�D� �t�y�p�e� �i�n� �(�N�'�U�'�)�)�
�
�	�D�R�O�P� �T�A�B�L�E� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]�
�
�G�O�
�
�C�R�E�A�T�E� �T�A�B�L�E� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]�(�
�
�	�[�i�d�]� �[�u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�]� �N�O�T� �N�U�L�L�,�	�
�
�	�[�i�n�s�t�a�n�c�e�]� �[�i�m�a�g�e�]� �N�U�L�L�,�
�
�	�[�i�n�s�t�a�n�c�e�X�m�l�]� �[�x�m�l�]� �N�U�L�L�,�
�
�	�[�c�r�e�a�t�e�d�]� �[�d�a�t�e�t�i�m�e�]� �N�O�T� �N�U�L�L�,�
�
�	�[�l�a�s�t�U�p�d�a�t�e�d�]� �[�d�a�t�e�t�i�m�e�]� �N�O�T� �N�U�L�L�,�
�
�	�[�l�o�c�k�O�w�n�e�r�]� �[�u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�]� �N�U�L�L�,�
�
�	�[�l�o�c�k�E�x�p�i�r�a�t�i�o�n�]� �[�d�a�t�e�t�i�m�e�]� �N�U�L�L�
�
�)� �O�N� �[�P�R�I�M�A�R�Y�]� �T�E�X�T�I�M�A�G�E�_�O�N� �[�P�R�I�M�A�R�Y�]�
�
�G�O�
�
�C�R�E�A�T�E� �U�N�I�Q�U�E� �C�L�U�S�T�E�R�E�D� �I�N�D�E�X� �i�d�_�i�n�d�e�x�
�
�	�O�N� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �(�[�i�d�]�)�
�
�	�W�I�T�H� �I�G�N�O�R�E�_�D�U�P�_�K�E�Y�
�
�G�O�

${this.title}

Code Editor : SqlPersistenceProviderSchema.sql