Edit C:\Windows\Microsoft.NET\Framework\v4.0.30319\SQL\es\SqlPersistenceService_Schema.sql
??-�-� �C�o�p�y�r�i�g�h�t� �(�c�)� �M�i�c�r�o�s�o�f�t� �C�o�r�p�o�r�a�t�i�o�n�.� � �A�l�l� �r�i�g�h�t�s� �r�e�s�e�r�v�e�d�.� � � � �S�E�T� �N�O�C�O�U�N�T� �O�N� � � � �-�-� � �-�-� �R�O�L�E� �s�t�a�t�e�_�p�e�r�s�i�s�t�e�n�c�e�_�u�s�e�r�s� � �-�-� � �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�'�E�r�r�o�r� �a�l� �a�g�r�e�g�a�r� �e�l� �r�o�l� �'�'�'�'�s�t�a�t�e�_�p�e�r�s�i�s�t�e�n�c�e�_�u�s�e�r�s�'�'�'�'�'� � � � �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�'�s�t�a�t�e�_�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�'�s�t�a�t�e�_�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� � � � � � �-�-� � �-�-� �T�A�B�L�E� �I�n�s�t�a�n�c�e�S�t�a�t�e� � �-�-� � �i�f� �e�x�i�s�t�s� �(�s�e�l�e�c�t� �*� �f�r�o�m� �d�b�o�.�s�y�s�o�b�j�e�c�t�s� �w�h�e�r�e� �i�d� �=� �o�b�j�e�c�t�_�i�d�(�N�'�[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�S�t�a�t�e�]�'�)� �a�n�d� �O�B�J�E�C�T�P�R�O�P�E�R�T�Y�(�i�d�,� �N�'�I�s�U�s�e�r�T�a�b�l�e�'�)� �=� �1�)� � �d�r�o�p� �t�a�b�l�e� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�S�t�a�t�e�]� � �G�O� � �C�R�E�A�T�E� �T�A�B�L�E� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�S�t�a�t�e�]� �(� � � �[�u�i�d�I�n�s�t�a�n�c�e�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� �,� � � �[�s�t�a�t�e�]� �[�i�m�a�g�e�]� �N�U�L�L� �,� � � �[�s�t�a�t�u�s�]� �[�i�n�t�]� �N�U�L�L� �,� � � �[�u�n�l�o�c�k�e�d�]� �[�i�n�t�]� �N�U�L�L� �,� � � �[�b�l�o�c�k�e�d�]� �[�i�n�t�]� �N�U�L�L� �,� � � �[�i�n�f�o�]� �[�n�t�e�x�t�]� �C�O�L�L�A�T�E� �S�Q�L�_�L�a�t�i�n�1�_�G�e�n�e�r�a�l�_�C�P�1�_�C�I�_�A�S� �N�U�L�L�,� � � �[�m�o�d�i�f�i�e�d�]� �[�d�a�t�e�t�i�m�e�]� �N�O�T� �N�U�L�L�,� � � �[�o�w�n�e�r�I�D�]� �[�u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�]� �N�U�L�L� �,� � � �[�o�w�n�e�d�U�n�t�i�l�]� �[�d�a�t�e�t�i�m�e�]� �N�U�L�L�,� � � �[�n�e�x�t�T�i�m�e�r�]� �[�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�X�_�I�n�s�t�a�n�c�e�S�t�a�t�e�]� �O�N� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�S�t�a�t�e�]�(�[�u�i�d�I�n�s�t�a�n�c�e�I�D�]�)� �O�N� �[�P�R�I�M�A�R�Y�]� � �-�-� �C�R�E�A�T�E� � �N�O�N�C�L�U�S�T�E�R�E�D� � �I�N�D�E�X� �[�I�X�_�I�n�s�t�a�n�c�e�S�t�a�t�e�_�O�w�n�e�r�s�h�i�p�]� �O�N� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�S�t�a�t�e�]�(�[�o�w�n�e�r�I�D�]�,�[�o�w�n�e�d�U�n�t�i�l�]�)� � �G�O� � � � � � �-�-� � �-�-� �T�A�B�L�E� �C�o�m�p�l�e�t�e�d�S�c�o�p�e� � �-�-� � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �[�d�b�o�]�.�[�s�y�s�o�b�j�e�c�t�s�]� �W�H�E�R�E� �i�d� �=� �o�b�j�e�c�t�_�i�d�(�N�'�[�d�b�o�]�.�[�C�o�m�p�l�e�t�e�d�S�c�o�p�e�]�'�)� �A�N�D� �O�B�J�E�C�T�P�R�O�P�E�R�T�Y�(�i�d�,� �N�'�I�s�U�s�e�r�T�a�b�l�e�'�)� �=� �1�)� � �D�R�O�P� �T�A�B�L�E� �[�d�b�o�]�.�[�C�o�m�p�l�e�t�e�d�S�c�o�p�e�]� � �G�O� � �C�R�E�A�T�E� �T�A�B�L�E� �[�d�b�o�]�.�[�C�o�m�p�l�e�t�e�d�S�c�o�p�e�]� �(� � � �[�u�i�d�I�n�s�t�a�n�c�e�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�,� � � �[�c�o�m�p�l�e�t�e�d�S�c�o�p�e�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�,� � � �[�s�t�a�t�e�]� �[�i�m�a�g�e�]� �N�O�T� �N�U�L�L�,� � � �[�m�o�d�i�f�i�e�d�]� �[�d�a�t�e�t�i�m�e�]� �N�O�T� �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� � �N�O�N�C�L�U�S�T�E�R�E�D� � �I�N�D�E�X� �[�I�X�_�C�o�m�p�l�e�t�e�d�S�c�o�p�e�]� �O�N� �[�d�b�o�]�.�[�C�o�m�p�l�e�t�e�d�S�c�o�p�e�]�(�[�c�o�m�p�l�e�t�e�d�S�c�o�p�e�I�D�]�)� �O�N� �[�P�R�I�M�A�R�Y�]� � �G�O� � �C�R�E�A�T�E� � �N�O�N�C�L�U�S�T�E�R�E�D� � �I�N�D�E�X� �[�I�X�_�C�o�m�p�l�e�t�e�d�S�c�o�p�e�_�I�n�s�t�a�n�c�e�I�D�]� �O�N� �[�d�b�o�]�.�[�C�o�m�p�l�e�t�e�d�S�c�o�p�e�]�(� �[�u�i�d�I�n�s�t�a�n�c�e�I�D�]� �)� � �G�O� � � � � � �D�B�C�C� �T�R�A�C�E�O�N� �(�1�2�0�4�)� � �
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de