Created
August 12, 2014 15:47
-
-
Save MauricioTRS/e994d67957f3d5ce8d3d to your computer and use it in GitHub Desktop.
Cadastro de Operaçoes IntelliJ
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Cadastro Operacoes |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="ArtifactManager"> | |
<artifact type="exploded-war" name="Cadastro Operacoes:war exploded"> | |
<output-path>$PROJECT_DIR$/out/artifacts/Cadastro_Operacoes_war_exploded</output-path> | |
<root id="root"> | |
<element id="javaee-facet-resources" facet="Cadastro Operacoes/web/Web" /> | |
<element id="directory" name="WEB-INF"> | |
<element id="directory" name="classes"> | |
<element id="module-output" name="Cadastro Operacoes" /> | |
</element> | |
<element id="directory" name="lib"> | |
<element id="library" level="project" name="mysql-connector-java-5.1.13-bin" /> | |
<element id="library" level="application" name="Hibernate JPA" /> | |
<element id="library" level="application" name="Primefaces" /> | |
</element> | |
</element> | |
</root> | |
</artifact> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="CompilerConfiguration"> | |
<option name="DEFAULT_COMPILER" value="Javac" /> | |
<resourceExtensions /> | |
<wildcardResourcePatterns> | |
<entry name="!?*.java" /> | |
<entry name="!?*.form" /> | |
<entry name="!?*.class" /> | |
<entry name="!?*.groovy" /> | |
<entry name="!?*.scala" /> | |
<entry name="!?*.flex" /> | |
<entry name="!?*.kt" /> | |
<entry name="!?*.clj" /> | |
</wildcardResourcePatterns> | |
<annotationProcessing> | |
<profile default="true" name="Default" enabled="false"> | |
<processorPath useClasspath="true" /> | |
</profile> | |
</annotationProcessing> | |
</component> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="CopyrightManager"> | |
<settings default="" /> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<component name="dataSourceStorage"> | |
<data-source source="LOCAL" name="MySQL - cadastro@localhost" uuid="b9b8334f-f21c-48f6-87e4-fa9e0965a5c3"> | |
<database-info product="MySQL" version="5.1.32-community" jdbc-version="3.0" driver-name="MySQL-AB JDBC Driver" driver-version="mysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} )"> | |
<extra-name-characters>#@</extra-name-characters> | |
<identifier-quote-string>`</identifier-quote-string> | |
</database-info> | |
<case-sensitivity plain-identifiers="lower" quoted-identifiers="lower"/> | |
<schema name="" catalog="cadastro"/> | |
<schema name="" catalog="information_schema"/> | |
<schema name="" catalog="lojacds"/> | |
<schema name="" catalog="mysql"/> | |
<schema name="" catalog="test"/> | |
<schema name="" catalog="vpost"/> | |
<table name="CHARACTER_SETS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="CHARACTER_SET_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFAULT_COLLATE_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DESCRIPTION" sqlType="VARCHAR" precision="60" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="MAXLEN" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
</table> | |
<table name="COLLATIONS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="COLLATION_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CHARACTER_SET_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ID" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="IS_DEFAULT" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_COMPILED" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SORTLEN" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
</table> | |
<table name="COLLATION_CHARACTER_SET_APPLICABILITY" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="COLLATION_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CHARACTER_SET_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="COLUMNS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLUMN_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ORDINAL_POSITION" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="COLUMN_DEFAULT" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="IS_NULLABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DATA_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CHARACTER_MAXIMUM_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="CHARACTER_OCTET_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="NUMERIC_PRECISION" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="NUMERIC_SCALE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="CHARACTER_SET_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="true" jdbcType="12"/> | |
<column name="COLLATION_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="true" jdbcType="12"/> | |
<column name="COLUMN_TYPE" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="COLUMN_KEY" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EXTRA" sqlType="VARCHAR" precision="27" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PRIVILEGES" sqlType="VARCHAR" precision="80" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLUMN_COMMENT" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="COLUMN_PRIVILEGES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="GRANTEE" sqlType="VARCHAR" precision="81" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLUMN_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PRIVILEGE_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_GRANTABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="ENGINES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="ENGINE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SUPPORT" sqlType="VARCHAR" precision="8" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COMMENT" sqlType="VARCHAR" precision="80" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TRANSACTIONS" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="XA" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SAVEPOINTS" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="EVENTS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="EVENT_CATALOG" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EVENT_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EVENT_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFINER" sqlType="VARCHAR" precision="77" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TIME_ZONE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EVENT_BODY" sqlType="VARCHAR" precision="8" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EVENT_DEFINITION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="EVENT_TYPE" sqlType="VARCHAR" precision="9" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EXECUTE_AT" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="INTERVAL_VALUE" sqlType="VARCHAR" precision="256" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INTERVAL_FIELD" sqlType="VARCHAR" precision="18" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SQL_MODE" sqlType="VARCHAR" precision="8192" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="STARTS" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="ENDS" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="STATUS" sqlType="VARCHAR" precision="18" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ON_COMPLETION" sqlType="VARCHAR" precision="12" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CREATED" sqlType="DATETIME" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/> | |
<column name="LAST_ALTERED" sqlType="DATETIME" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/> | |
<column name="LAST_EXECUTED" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="EVENT_COMMENT" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ORIGINATOR" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="CHARACTER_SET_CLIENT" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLLATION_CONNECTION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DATABASE_COLLATION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="FILES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="FILE_ID" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="FILE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FILE_TYPE" sqlType="VARCHAR" precision="20" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLESPACE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LOGFILE_GROUP_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LOGFILE_GROUP_NUMBER" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="ENGINE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="FULLTEXT_KEYS" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DELETED_ROWS" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="UPDATE_COUNT" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="FREE_EXTENTS" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="TOTAL_EXTENTS" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="EXTENT_SIZE" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="INITIAL_SIZE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="MAXIMUM_SIZE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="AUTOEXTEND_SIZE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="CREATION_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="LAST_UPDATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="LAST_ACCESS_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="RECOVER_TIME" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="TRANSACTION_COUNTER" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="VERSION" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="ROW_FORMAT" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_ROWS" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="AVG_ROW_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="DATA_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="MAX_DATA_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="INDEX_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="DATA_FREE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="CREATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="UPDATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="CHECK_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="CHECKSUM" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="STATUS" sqlType="VARCHAR" precision="20" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EXTRA" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="GLOBAL_STATUS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="VARIABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="VARIABLE_VALUE" sqlType="VARCHAR" precision="1024" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="GLOBAL_VARIABLES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="VARIABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="VARIABLE_VALUE" sqlType="VARCHAR" precision="1024" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="KEY_COLUMN_USAGE" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="CONSTRAINT_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONSTRAINT_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CONSTRAINT_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLUMN_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ORDINAL_POSITION" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="POSITION_IN_UNIQUE_CONSTRAINT" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="REFERENCED_TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REFERENCED_TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REFERENCED_COLUMN_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="PARTITIONS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PARTITION_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SUBPARTITION_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PARTITION_ORDINAL_POSITION" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="SUBPARTITION_ORDINAL_POSITION" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="PARTITION_METHOD" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SUBPARTITION_METHOD" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PARTITION_EXPRESSION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="SUBPARTITION_EXPRESSION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="PARTITION_DESCRIPTION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="TABLE_ROWS" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="AVG_ROW_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="DATA_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="MAX_DATA_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="INDEX_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="DATA_FREE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="CREATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="UPDATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="CHECK_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="CHECKSUM" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="PARTITION_COMMENT" sqlType="VARCHAR" precision="80" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="NODEGROUP" sqlType="VARCHAR" precision="12" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLESPACE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="PLUGINS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="PLUGIN_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PLUGIN_VERSION" sqlType="VARCHAR" precision="20" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PLUGIN_STATUS" sqlType="VARCHAR" precision="10" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PLUGIN_TYPE" sqlType="VARCHAR" precision="80" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PLUGIN_TYPE_VERSION" sqlType="VARCHAR" precision="20" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PLUGIN_LIBRARY" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PLUGIN_LIBRARY_VERSION" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PLUGIN_AUTHOR" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PLUGIN_DESCRIPTION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="PLUGIN_LICENSE" sqlType="VARCHAR" precision="80" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="PROCESSLIST" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="ID" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="USER" sqlType="VARCHAR" precision="16" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="HOST" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DB" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="COMMAND" sqlType="VARCHAR" precision="16" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TIME" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="STATE" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INFO" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
</table> | |
<table name="PROFILING" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="QUERY_ID" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="SEQ" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="STATE" sqlType="VARCHAR" precision="30" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DURATION" sqlType="DECIMAL" precision="9" scale="6" nullable="false" jdbcType="3" def="MC4wMDAwMDA="/> | |
<column name="CPU_USER" sqlType="DECIMAL" precision="9" scale="6" nullable="true" jdbcType="3"/> | |
<column name="CPU_SYSTEM" sqlType="DECIMAL" precision="9" scale="6" nullable="true" jdbcType="3"/> | |
<column name="CONTEXT_VOLUNTARY" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CONTEXT_INVOLUNTARY" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="BLOCK_OPS_IN" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="BLOCK_OPS_OUT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="MESSAGES_SENT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="MESSAGES_RECEIVED" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="PAGE_FAULTS_MAJOR" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="PAGE_FAULTS_MINOR" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SWAPS" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SOURCE_FUNCTION" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SOURCE_FILE" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SOURCE_LINE" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
</table> | |
<table name="REFERENTIAL_CONSTRAINTS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="CONSTRAINT_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONSTRAINT_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CONSTRAINT_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="UNIQUE_CONSTRAINT_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="UNIQUE_CONSTRAINT_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="UNIQUE_CONSTRAINT_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="MATCH_OPTION" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="UPDATE_RULE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DELETE_RULE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="REFERENCED_TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="ROUTINES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="SPECIFIC_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ROUTINE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ROUTINE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ROUTINE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ROUTINE_TYPE" sqlType="VARCHAR" precision="9" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DTD_IDENTIFIER" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ROUTINE_BODY" sqlType="VARCHAR" precision="8" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ROUTINE_DEFINITION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="EXTERNAL_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EXTERNAL_LANGUAGE" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PARAMETER_STYLE" sqlType="VARCHAR" precision="8" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_DETERMINISTIC" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SQL_DATA_ACCESS" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SQL_PATH" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SECURITY_TYPE" sqlType="VARCHAR" precision="7" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CREATED" sqlType="DATETIME" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/> | |
<column name="LAST_ALTERED" sqlType="DATETIME" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/> | |
<column name="SQL_MODE" sqlType="VARCHAR" precision="8192" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ROUTINE_COMMENT" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFINER" sqlType="VARCHAR" precision="77" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CHARACTER_SET_CLIENT" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLLATION_CONNECTION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DATABASE_COLLATION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="SCHEMATA" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="CATALOG_NAME" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SCHEMA_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFAULT_CHARACTER_SET_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFAULT_COLLATION_NAME" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SQL_PATH" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="SCHEMA_PRIVILEGES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="GRANTEE" sqlType="VARCHAR" precision="81" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PRIVILEGE_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_GRANTABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="SESSION_STATUS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="VARIABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="VARIABLE_VALUE" sqlType="VARCHAR" precision="1024" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="SESSION_VARIABLES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="VARIABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="VARIABLE_VALUE" sqlType="VARCHAR" precision="1024" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="STATISTICS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="NON_UNIQUE" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="INDEX_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="INDEX_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SEQ_IN_INDEX" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="COLUMN_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLLATION" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CARDINALITY" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="SUB_PART" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="PACKED" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="NULLABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="INDEX_TYPE" sqlType="VARCHAR" precision="16" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COMMENT" sqlType="VARCHAR" precision="16" scale="0" nullable="true" jdbcType="12"/> | |
</table> | |
<table name="TABLES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ENGINE" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VERSION" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="ROW_FORMAT" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_ROWS" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="AVG_ROW_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="DATA_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="MAX_DATA_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="INDEX_LENGTH" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="DATA_FREE" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="AUTO_INCREMENT" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="CREATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="UPDATE_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="CHECK_TIME" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="TABLE_COLLATION" sqlType="VARCHAR" precision="32" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CHECKSUM" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="CREATE_OPTIONS" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_COMMENT" sqlType="VARCHAR" precision="80" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="TABLE_CONSTRAINTS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="CONSTRAINT_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONSTRAINT_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CONSTRAINT_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CONSTRAINT_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="TABLE_PRIVILEGES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="GRANTEE" sqlType="VARCHAR" precision="81" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="PRIVILEGE_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_GRANTABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="TRIGGERS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="TRIGGER_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TRIGGER_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TRIGGER_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EVENT_MANIPULATION" sqlType="VARCHAR" precision="6" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EVENT_OBJECT_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EVENT_OBJECT_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="EVENT_OBJECT_TABLE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ACTION_ORDER" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" def="MA=="/> | |
<column name="ACTION_CONDITION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="true" jdbcType="-1"/> | |
<column name="ACTION_STATEMENT" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="ACTION_ORIENTATION" sqlType="VARCHAR" precision="9" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ACTION_TIMING" sqlType="VARCHAR" precision="6" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ACTION_REFERENCE_OLD_TABLE" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ACTION_REFERENCE_NEW_TABLE" sqlType="VARCHAR" precision="64" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ACTION_REFERENCE_OLD_ROW" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="ACTION_REFERENCE_NEW_ROW" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CREATED" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="SQL_MODE" sqlType="VARCHAR" precision="8192" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFINER" sqlType="VARCHAR" precision="77" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CHARACTER_SET_CLIENT" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLLATION_CONNECTION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DATABASE_COLLATION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="USER_PRIVILEGES" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="GRANTEE" sqlType="VARCHAR" precision="81" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PRIVILEGE_TYPE" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_GRANTABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="VIEWS" schema="" catalog="information_schema" type="SYSTEM TABLE"> | |
<column name="TABLE_CATALOG" sqlType="VARCHAR" precision="512" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TABLE_SCHEMA" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="TABLE_NAME" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="VIEW_DEFINITION" sqlType="LONGTEXT" precision="2147483647" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="CHECK_OPTION" sqlType="VARCHAR" precision="8" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="IS_UPDATABLE" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="DEFINER" sqlType="VARCHAR" precision="77" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="SECURITY_TYPE" sqlType="VARCHAR" precision="7" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="CHARACTER_SET_CLIENT" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="COLLATION_CONNECTION" sqlType="VARCHAR" precision="32" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
</table> | |
<table name="cds" schema="" catalog="lojacds" type="TABLE"> | |
<column name="codigo" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="titulo" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="interprete" sqlType="VARCHAR" precision="150" scale="0" nullable="true" jdbcType="12"/> | |
<column name="genero" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="preco" sqlType="FLOAT" precision="12" scale="0" nullable="true" jdbcType="7"/> | |
<primary-key name="PRIMARY" columns="codigo"/> | |
</table> | |
<table name="generos" schema="" catalog="lojacds" type="TABLE"> | |
<column name="genero" sqlType="VARCHAR" precision="40" scale="0" nullable="false" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="genero"/> | |
</table> | |
<table name="usuarios" schema="" catalog="lojacds" type="TABLE"> | |
<column name="login" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="senha" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="nome" sqlType="VARCHAR" precision="129" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="login"/> | |
</table> | |
<table name="columns_priv" schema="" catalog="mysql" type="TABLE"> | |
<column name="Host" sqlType="CHAR" precision="60" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="User" sqlType="CHAR" precision="16" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Table_name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Column_name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Timestamp" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<column name="Column_priv" sqlType="SET" precision="31" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<primary-key name="PRIMARY" columns="Host,Db,User,Table_name,Column_name"/> | |
</table> | |
<table name="db" schema="" catalog="mysql" type="TABLE"> | |
<column name="Host" sqlType="CHAR" precision="60" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="User" sqlType="CHAR" precision="16" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Select_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Insert_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Update_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Delete_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Drop_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Grant_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="References_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Index_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Alter_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_tmp_table_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Lock_tables_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_view_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Show_view_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_routine_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Alter_routine_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Execute_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Event_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Trigger_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<primary-key name="PRIMARY" columns="Host,Db,User"/> | |
<index name="User" unique="false" columns="User"/> | |
</table> | |
<table name="event" schema="" catalog="mysql" type="TABLE"> | |
<column name="db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="body" sqlType="LONGBLOB" precision="2147483647" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="definer" sqlType="CHAR" precision="77" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="execute_at" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="interval_value" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="interval_field" sqlType="ENUM" precision="18" scale="0" nullable="true" jdbcType="1"/> | |
<column name="created" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<column name="modified" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/> | |
<column name="last_executed" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="starts" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="ends" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="status" sqlType="ENUM" precision="18" scale="0" nullable="false" jdbcType="1" def="J0VOQUJMRUQn"/> | |
<column name="on_completion" sqlType="ENUM" precision="8" scale="0" nullable="false" jdbcType="1" def="J0RST1An"/> | |
<column name="sql_mode" sqlType="SET UNSIGNED" precision="478" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="comment" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="originator" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="time_zone" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="J1NZU1RFTSc="/> | |
<column name="character_set_client" sqlType="CHAR" precision="32" scale="0" nullable="true" jdbcType="1"/> | |
<column name="collation_connection" sqlType="CHAR" precision="32" scale="0" nullable="true" jdbcType="1"/> | |
<column name="db_collation" sqlType="CHAR" precision="32" scale="0" nullable="true" jdbcType="1"/> | |
<column name="body_utf8" sqlType="LONGBLOB" precision="2147483647" scale="0" nullable="true" jdbcType="-4"/> | |
<primary-key name="PRIMARY" columns="db,name"/> | |
</table> | |
<table name="func" schema="" catalog="mysql" type="TABLE"> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="ret" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6" def="MA=="/> | |
<column name="dl" sqlType="CHAR" precision="128" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="type" sqlType="ENUM" precision="9" scale="0" nullable="false" jdbcType="1"/> | |
<primary-key name="PRIMARY" columns="name"/> | |
</table> | |
<table name="general_log" schema="" catalog="mysql" type="TABLE"> | |
<column name="event_time" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<column name="user_host" sqlType="MEDIUMTEXT" precision="16777215" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="thread_id" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="server_id" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="command_type" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12"/> | |
<column name="argument" sqlType="MEDIUMTEXT" precision="16777215" scale="0" nullable="false" jdbcType="-1"/> | |
</table> | |
<table name="help_category" schema="" catalog="mysql" type="TABLE"> | |
<column name="help_category_id" sqlType="SMALLINT UNSIGNED" precision="5" scale="0" nullable="false" jdbcType="5"/> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1"/> | |
<column name="parent_category_id" sqlType="SMALLINT UNSIGNED" precision="5" scale="0" nullable="true" jdbcType="5"/> | |
<column name="url" sqlType="CHAR" precision="128" scale="0" nullable="false" jdbcType="1"/> | |
<primary-key name="PRIMARY" columns="help_category_id"/> | |
<index name="name" unique="true" columns="name"/> | |
</table> | |
<table name="help_keyword" schema="" catalog="mysql" type="TABLE"> | |
<column name="help_keyword_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1"/> | |
<primary-key name="PRIMARY" columns="help_keyword_id"/> | |
<index name="name" unique="true" columns="name"/> | |
</table> | |
<table name="help_relation" schema="" catalog="mysql" type="TABLE"> | |
<column name="help_topic_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="help_keyword_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="help_keyword_id,help_topic_id"/> | |
</table> | |
<table name="help_topic" schema="" catalog="mysql" type="TABLE"> | |
<column name="help_topic_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1"/> | |
<column name="help_category_id" sqlType="SMALLINT UNSIGNED" precision="5" scale="0" nullable="false" jdbcType="5"/> | |
<column name="description" sqlType="TEXT" precision="65535" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="example" sqlType="TEXT" precision="65535" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="url" sqlType="CHAR" precision="128" scale="0" nullable="false" jdbcType="1"/> | |
<primary-key name="PRIMARY" columns="help_topic_id"/> | |
<index name="name" unique="true" columns="name"/> | |
</table> | |
<table name="host" schema="" catalog="mysql" type="TABLE"> | |
<column name="Host" sqlType="CHAR" precision="60" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Select_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Insert_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Update_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Delete_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Drop_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Grant_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="References_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Index_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Alter_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_tmp_table_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Lock_tables_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_view_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Show_view_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_routine_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Alter_routine_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Execute_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Trigger_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<primary-key name="PRIMARY" columns="Host,Db"/> | |
</table> | |
<table name="ndb_binlog_index" schema="" catalog="mysql" type="TABLE"> | |
<column name="Position" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="File" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="epoch" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="inserts" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="updates" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="deletes" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="schemaops" sqlType="BIGINT UNSIGNED" precision="20" scale="0" nullable="false" jdbcType="-5"/> | |
<primary-key name="PRIMARY" columns="epoch"/> | |
</table> | |
<table name="plugin" schema="" catalog="mysql" type="TABLE"> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="dl" sqlType="CHAR" precision="128" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<primary-key name="PRIMARY" columns="name"/> | |
</table> | |
<table name="proc" schema="" catalog="mysql" type="TABLE"> | |
<column name="db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="type" sqlType="ENUM" precision="9" scale="0" nullable="false" jdbcType="1"/> | |
<column name="specific_name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="language" sqlType="ENUM" precision="4" scale="0" nullable="false" jdbcType="1" def="J1NRTCc="/> | |
<column name="sql_data_access" sqlType="ENUM" precision="17" scale="0" nullable="false" jdbcType="1" def="J0NPTlRBSU5TX1NRTCc="/> | |
<column name="is_deterministic" sqlType="ENUM" precision="4" scale="0" nullable="false" jdbcType="1" def="J05PJw=="/> | |
<column name="security_type" sqlType="ENUM" precision="8" scale="0" nullable="false" jdbcType="1" def="J0RFRklORVIn"/> | |
<column name="param_list" sqlType="BLOB" precision="65535" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="returns" sqlType="LONGBLOB" precision="2147483647" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="body" sqlType="LONGBLOB" precision="2147483647" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="definer" sqlType="CHAR" precision="77" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="created" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<column name="modified" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/> | |
<column name="sql_mode" sqlType="SET UNSIGNED" precision="478" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="comment" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="character_set_client" sqlType="CHAR" precision="32" scale="0" nullable="true" jdbcType="1"/> | |
<column name="collation_connection" sqlType="CHAR" precision="32" scale="0" nullable="true" jdbcType="1"/> | |
<column name="db_collation" sqlType="CHAR" precision="32" scale="0" nullable="true" jdbcType="1"/> | |
<column name="body_utf8" sqlType="LONGBLOB" precision="2147483647" scale="0" nullable="true" jdbcType="-4"/> | |
<primary-key name="PRIMARY" columns="db,name,type"/> | |
</table> | |
<table name="procs_priv" schema="" catalog="mysql" type="TABLE"> | |
<column name="Host" sqlType="CHAR" precision="60" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="User" sqlType="CHAR" precision="16" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Routine_name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Routine_type" sqlType="ENUM" precision="9" scale="0" nullable="false" jdbcType="1"/> | |
<column name="Grantor" sqlType="CHAR" precision="77" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Proc_priv" sqlType="SET" precision="27" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Timestamp" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<primary-key name="PRIMARY" columns="Host,Db,User,Routine_name,Routine_type"/> | |
<index name="Grantor" unique="false" columns="Grantor"/> | |
</table> | |
<table name="servers" schema="" catalog="mysql" type="TABLE"> | |
<column name="Server_name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Host" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Username" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Password" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Port" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="Socket" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Wrapper" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Owner" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<primary-key name="PRIMARY" columns="Server_name"/> | |
</table> | |
<table name="slow_log" schema="" catalog="mysql" type="TABLE"> | |
<column name="start_time" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<column name="user_host" sqlType="MEDIUMTEXT" precision="16777215" scale="0" nullable="false" jdbcType="-1"/> | |
<column name="query_time" sqlType="TIME" precision="8" scale="0" nullable="false" jdbcType="92"/> | |
<column name="lock_time" sqlType="TIME" precision="8" scale="0" nullable="false" jdbcType="92"/> | |
<column name="rows_sent" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="rows_examined" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="db" sqlType="VARCHAR" precision="512" scale="0" nullable="false" jdbcType="12"/> | |
<column name="last_insert_id" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="insert_id" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="server_id" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="sql_text" sqlType="MEDIUMTEXT" precision="16777215" scale="0" nullable="false" jdbcType="-1"/> | |
</table> | |
<table name="tables_priv" schema="" catalog="mysql" type="TABLE"> | |
<column name="Host" sqlType="CHAR" precision="60" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Db" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="User" sqlType="CHAR" precision="16" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Table_name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Grantor" sqlType="CHAR" precision="77" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Timestamp" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/> | |
<column name="Table_priv" sqlType="SET" precision="98" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Column_priv" sqlType="SET" precision="31" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<primary-key name="PRIMARY" columns="Host,Db,User,Table_name"/> | |
<index name="Grantor" unique="false" columns="Grantor"/> | |
</table> | |
<table name="time_zone" schema="" catalog="mysql" type="TABLE"> | |
<column name="Time_zone_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="Use_leap_seconds" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<primary-key name="PRIMARY" columns="Time_zone_id"/> | |
</table> | |
<table name="time_zone_leap_second" schema="" catalog="mysql" type="TABLE"> | |
<column name="Transition_time" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="Correction" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="Transition_time"/> | |
</table> | |
<table name="time_zone_name" schema="" catalog="mysql" type="TABLE"> | |
<column name="Name" sqlType="CHAR" precision="64" scale="0" nullable="false" jdbcType="1"/> | |
<column name="Time_zone_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="Name"/> | |
</table> | |
<table name="time_zone_transition" schema="" catalog="mysql" type="TABLE"> | |
<column name="Time_zone_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="Transition_time" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="Transition_type_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="Time_zone_id,Transition_time"/> | |
</table> | |
<table name="time_zone_transition_type" schema="" catalog="mysql" type="TABLE"> | |
<column name="Time_zone_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="Transition_type_id" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="Offset" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="Is_DST" sqlType="TINYINT UNSIGNED" precision="3" scale="0" nullable="false" jdbcType="-6" def="MA=="/> | |
<column name="Abbreviation" sqlType="CHAR" precision="8" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<primary-key name="PRIMARY" columns="Time_zone_id,Transition_type_id"/> | |
</table> | |
<table name="user" schema="" catalog="mysql" type="TABLE"> | |
<column name="Host" sqlType="CHAR" precision="60" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="User" sqlType="CHAR" precision="16" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Password" sqlType="CHAR" precision="41" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="Select_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Insert_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Update_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Delete_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Drop_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Reload_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Shutdown_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Process_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="File_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Grant_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="References_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Index_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Alter_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Show_db_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Super_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_tmp_table_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Lock_tables_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Execute_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Repl_slave_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Repl_client_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_view_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Show_view_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_routine_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Alter_routine_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Create_user_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Event_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="Trigger_priv" sqlType="ENUM" precision="2" scale="0" nullable="false" jdbcType="1" def="J04n"/> | |
<column name="ssl_type" sqlType="ENUM" precision="9" scale="0" nullable="false" jdbcType="1" def="Jyc="/> | |
<column name="ssl_cipher" sqlType="BLOB" precision="65535" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="x509_issuer" sqlType="BLOB" precision="65535" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="x509_subject" sqlType="BLOB" precision="65535" scale="0" nullable="false" jdbcType="-4"/> | |
<column name="max_questions" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="max_updates" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="max_connections" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="max_user_connections" sqlType="INT UNSIGNED" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<primary-key name="PRIMARY" columns="Host,User"/> | |
</table> | |
<table name="adicionais" schema="" catalog="test" type="TABLE"> | |
<column name="sigla" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="adValorem" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="descricao" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="seguroAutomatico" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<primary-key name="PRIMARY" columns="sigla"/> | |
<exported-key name="FK_iksuah8ntjcy21i0g0wq4fnlj" table="adicionais_servicos" schema="" catalog="test" columns="adicionais_sigla"/> | |
</table> | |
<table name="adicionais_servicos" schema="" catalog="test" type="TABLE"> | |
<column name="adicionais_sigla" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="servicos_codigoFinanceiro" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<foreign-key name="FK_7qgfcxxsbyjmyh46fj1ly2dys" columns="servicos_codigoFinanceiro" ref-table="servicos" ref-schema="" ref-catalog="test" ref-columns="codigoFinanceiro" update-rule="3" delete-rule="3" deferrability="2"/> | |
<foreign-key name="FK_iksuah8ntjcy21i0g0wq4fnlj" columns="adicionais_sigla" ref-table="adicionais" ref-schema="" ref-catalog="test" ref-columns="sigla" update-rule="3" delete-rule="3" deferrability="2"/> | |
<index name="FK_7qgfcxxsbyjmyh46fj1ly2dys" unique="false" columns="servicos_codigoFinanceiro"/> | |
<index name="FK_iksuah8ntjcy21i0g0wq4fnlj" unique="false" columns="adicionais_sigla"/> | |
</table> | |
<table name="cds" schema="" catalog="test" type="TABLE"> | |
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/> | |
<column name="artista" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="preco" sqlType="FLOAT" precision="12" scale="0" nullable="true" jdbcType="7"/> | |
<column name="titulo" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="genero_id" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<primary-key name="PRIMARY" columns="id"/> | |
<foreign-key name="FK_i85mo9coyu0wcddypsfgovqeb" columns="genero_id" ref-table="generos" ref-schema="" ref-catalog="test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/> | |
<index name="FK_i85mo9coyu0wcddypsfgovqeb" unique="false" columns="genero_id"/> | |
</table> | |
<table name="generos" schema="" catalog="test" type="TABLE"> | |
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/> | |
<column name="descricao" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="id"/> | |
<exported-key name="FK_i85mo9coyu0wcddypsfgovqeb" table="cds" schema="" catalog="test" columns="genero_id"/> | |
</table> | |
<table name="grupos" schema="" catalog="test" type="TABLE"> | |
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="cubagemMaxima" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="descricao" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="incremento" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="pesoMaximo" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="id"/> | |
<exported-key name="FK_o2c3qjw8sa634ho0fwp4lhc67" table="servicos" schema="" catalog="test" columns="grupo_id"/> | |
</table> | |
<table name="servicos" schema="" catalog="test" type="TABLE"> | |
<column name="codigoFinanceiro" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="cubico" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="registrado" sqlType="BIT" precision="1" scale="0" nullable="false" jdbcType="-7"/> | |
<column name="grupo_id" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<primary-key name="PRIMARY" columns="codigoFinanceiro"/> | |
<foreign-key name="FK_o2c3qjw8sa634ho0fwp4lhc67" columns="grupo_id" ref-table="grupos" ref-schema="" ref-catalog="test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/> | |
<exported-key name="FK_7qgfcxxsbyjmyh46fj1ly2dys" table="adicionais_servicos" schema="" catalog="test" columns="servicos_codigoFinanceiro"/> | |
<index name="FK_o2c3qjw8sa634ho0fwp4lhc67" unique="false" columns="grupo_id"/> | |
</table> | |
<table name="usuarios" schema="" catalog="test" type="TABLE"> | |
<column name="login" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="nome" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="senha" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="role" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="login"/> | |
</table> | |
<table name="atend_dados" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_ATDD" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ATENDIMENTO" sqlType="VARCHAR" precision="4" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODIGO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DEPTO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="ORIGEM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CCUSTO" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SOL_NUM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SOL_MAT" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SOL_NOM" sqlType="VARCHAR" precision="60" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SOL_FON" sqlType="VARCHAR" precision="16" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SOL_EML" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_ATDD"/> | |
</table> | |
<table name="atendimento" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_ATE" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ATENDIMENTO" sqlType="VARCHAR" precision="4" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REMETENTE" sqlType="VARCHAR" precision="92" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEPREMETENTE" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODIGO" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="STATUS" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="FATURADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="NF" sqlType="VARCHAR" precision="7" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DH" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="HORA" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="HORAINI" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="COMPROVANTE" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODADM" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VENCIMENTO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="BAIXADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="CPF" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TELEFONE" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DETALHES" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OS1" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OS2" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PVP" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="FL_EXP" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_ATE"/> | |
<index name="VINCINDEX" unique="true" columns="DATA1,OPERADOR,ATENDIMENTO"/> | |
<index name="COMPRINDEX" unique="false" columns="COMPROVANTE"/> | |
<index name="PVPINDEX" unique="false" columns="PVP"/> | |
<index name="CODINDEX" unique="false" columns="CODIGO"/> | |
<index name="DATINDEX" unique="false" columns="DATA1"/> | |
<index name="OPERINDEX" unique="false" columns="OPERADOR"/> | |
<index name="ATENDINDEX" unique="false" columns="ATENDIMENTO"/> | |
</table> | |
<table name="bancos" schema="" catalog="vpost" type="TABLE"> | |
<column name="CODIGO" sqlType="VARCHAR" precision="3" scale="0" nullable="false" jdbcType="12" def="Jyc="/> | |
<column name="NOME" sqlType="VARCHAR" precision="40" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FORMULA" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="JUROS" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="DIAS" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="FISICOA" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="FISICOL" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="LOCALH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="LOCALV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="VENCTOH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="VENCTOV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="PROCESSH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="PROCESSV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CODH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CODV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="EMISSAOH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="EMISSAOV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="MOEDAH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="MOEDAV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="VALORH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="VALORV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="ESPACO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="INSTRH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DADOSH" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DADOSV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CORRECAO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CODBANCO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ESPECIE" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="AGENCIA" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONTA" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="BAIXA" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="USOBCO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ACEITE" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="MOEDA" sqlType="VARCHAR" precision="6" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODCAR" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CARTEIRA" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LOCPAG1" sqlType="VARCHAR" precision="55" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LOCPAG2" sqlType="VARCHAR" precision="55" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR1" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR2" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR3" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR4" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR5" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR6" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR7" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR8" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR9" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONVENIO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODCEDENTE" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="MODBOLETO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="TP_COBR" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="CODIGO"/> | |
<index name="CODINDEX" unique="false" columns="CODIGO"/> | |
</table> | |
<table name="boletos" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_BLT" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="BANCO" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="BOLETO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="CODBANCO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VENCIMENTO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="CLIENTEOLD" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="NOMEBANCO" sqlType="VARCHAR" precision="40" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALORB" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="VALORP" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="CANCELADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="DATAPAGTO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="CLIENTE" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ESPECIE" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="AGENCIA" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONTA" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODCEDENTE" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="BAIXA" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="USOBCO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ACEITE" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="MOEDA" sqlType="VARCHAR" precision="6" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODCAR" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CARTEIRA" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALORVAR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="NDOC" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DATADOC" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="CODIGO" sqlType="VARCHAR" precision="44" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DIGITAVEL" sqlType="VARCHAR" precision="70" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPOSAC" sqlType="VARCHAR" precision="70" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CNPJCPF" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="NOMESAC" sqlType="VARCHAR" precision="70" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ENDSAC" sqlType="VARCHAR" precision="70" scale="0" nullable="true" jdbcType="12"/> | |
<column name="BAIRROSAC" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEPSAC" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CIDADESAC" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="UFSAC" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LOCPAG1" sqlType="VARCHAR" precision="55" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LOCPAG2" sqlType="VARCHAR" precision="55" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR1" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR2" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR3" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR4" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR5" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR6" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR7" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR8" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INSTR9" sqlType="VARCHAR" precision="69" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALORA" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="CAMPO1" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CAMPO2" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CAMPO3" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FATURA" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="TP_VENC" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="VENCIMPRES" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_BLT"/> | |
<index name="CLINDEX" unique="false" columns="CLIENTE"/> | |
<index name="CODINDEX" unique="false" columns="BANCO,BOLETO"/> | |
<index name="VENCINDEX" unique="false" columns="VENCIMENTO"/> | |
<index name="FATINDEX" unique="false" columns="FATURA"/> | |
</table> | |
<table name="cetiquetas" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_CETQ" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="INICIAL" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FINAL" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_CETQ"/> | |
<index name="DATAINDEX" unique="false" columns="DATA1"/> | |
<index name="FIMINDEX" unique="false" columns="FINAL"/> | |
<index name="INICINDEX" unique="false" columns="INICIAL"/> | |
</table> | |
<table name="cfatura" schema="" catalog="vpost" type="TABLE"> | |
<column name="FATURA" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="HORA" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<column name="OPERFAT" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ST_FAT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="TP_FAT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CLIENTE" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DEPTO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="FL_FAT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="VCTO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="VLRFAT" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="DATAINI" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="DATAFIN" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="VLRPAGO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<primary-key name="PRIMARY" columns="FATURA"/> | |
<index name="CLINDEX" unique="false" columns="CLIENTE"/> | |
<index name="DATINDEX" unique="false" columns="DATA1"/> | |
<index name="TPINDEX" unique="false" columns="ST_FAT"/> | |
</table> | |
<table name="cmala" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_CML" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="MALA" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LINHA" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PESO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="CODDEST" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EXPEDIDA" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="IMP" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DESCRICAO" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="HORA" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<column name="NOTA" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEPNOTA" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_CML"/> | |
<index name="CODINDEX" unique="false" columns="DATA,MALA"/> | |
<index name="DESTINDEX" unique="false" columns="DATA,CODDEST,LINHA"/> | |
<index name="MALINDEX" unique="false" columns="MALA"/> | |
<index name="NOTINDEX" unique="false" columns="DATA,LINHA,CODDEST,MALA"/> | |
</table> | |
<table name="cobjetos" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_COBJ" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="MALA" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBJETO" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_COBJ"/> | |
<index name="MALINDEX" unique="false" columns="MALA"/> | |
<index name="OBJETOINDEX" unique="false" columns="OBJETO"/> | |
</table> | |
<table name="dados" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_SRV" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="REGISTRO" sqlType="VARCHAR" precision="45" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="IDREC" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DNOME" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DENDERECO" sqlType="VARCHAR" precision="90" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DCIDADE" sqlType="VARCHAR" precision="90" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DCOMPL" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DBAIRRO" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DUF" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DCEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DCPF" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DPASS" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DRG" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DEMISSOR" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DEMISSORUF" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RNOME" sqlType="VARCHAR" precision="92" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RENDERECO" sqlType="VARCHAR" precision="40" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RCIDADE" sqlType="VARCHAR" precision="25" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RCOMPL" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RBAIRRO" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RUF" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RCEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RCPF" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RPASS" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RRG" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REMISSOR" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REMISSORUF" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PAIS" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="MOEDA" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALORMOEDA" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="COTACAOMOEDA" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="FINALIDADE" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DSE" sqlType="VARCHAR" precision="35" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EMAIL" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONTEUDO_AR" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DNUM" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RNUM" sqlType="VARCHAR" precision="6" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS1" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS2" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS3" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="RFONE" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DFONE" sqlType="VARCHAR" precision="20" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_SRV"/> | |
<index name="REGINDEX" unique="true" columns="REGISTRO,TIPO"/> | |
<index name="DCPFINDEX" unique="false" columns="DCPF"/> | |
<index name="RCPFINDEX" unique="false" columns="RCPF"/> | |
</table> | |
<table name="diversos" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_DVS" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="GRUPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SUBGRUPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="ITEM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SUBITEM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="HORA" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DESCR" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SINAL" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_DVS"/> | |
<index name="DATINDEX" unique="false" columns="DATA1"/> | |
</table> | |
<table name="etiquetas" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_ETQ" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODIGO" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="GRM" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INICIAL" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FINAL" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="HISTORICO" sqlType="VARCHAR" precision="87" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="UNIDADE" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="BAIXADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="CANCELADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="TP_DOC" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CONTRATO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_ETQ"/> | |
<index name="REGINDEX" unique="true" columns="TIPO,INICIAL,FINAL,OPERADOR"/> | |
<index name="DATINDEX" unique="false" columns="DATA"/> | |
</table> | |
<table name="expcep" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_CEP" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="ID_ROT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CEP_INI" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP_FIN" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INTER" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="ID_CEP"/> | |
<index name="CEPINDEX" unique="true" columns="ID_ROT,CEP_INI,CEP_FIN"/> | |
<index name="ROTINDEX" unique="false" columns="ID_ROT"/> | |
</table> | |
<table name="explds" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_LDS" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="LINHA" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DEST" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_LDS"/> | |
<index name="LDSINDEX" unique="true" columns="LINHA,DEST"/> | |
</table> | |
<table name="explin" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_LIN" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="LINHA" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DSC_LINHA" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="INATIVO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="ID_LIN"/> | |
<index name="LINIDEX" unique="true" columns="LINHA"/> | |
</table> | |
<table name="expope" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_OPE" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="ID_ROT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CODOPE" sqlType="VARCHAR" precision="6" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_OPE"/> | |
<index name="OPEINDEX" unique="true" columns="ID_ROT,CODOPE"/> | |
<index name="ROTINDEX" unique="false" columns="ID_ROT"/> | |
</table> | |
<table name="exprot" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_ROT" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="ID_UNI" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6" def="MA=="/> | |
<column name="ID_DIV" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6"/> | |
<column name="N_ROT" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FL_IMP" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6"/> | |
<column name="FL_MOD" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="ID_ROT"/> | |
<index name="DIVINDEX" unique="true" columns="ID_UNI,ID_DIV"/> | |
</table> | |
<table name="expuni" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_UNI" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" def="MA=="/> | |
<column name="N_UNI" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_UNI"/> | |
</table> | |
<table name="faturado" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_FAT" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="FL_TB" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="TIPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="CLIENTE" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DEPTO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="LOTE" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FATURA" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="ST_FAT" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_FAT,FL_TB"/> | |
<index name="CLINDEX" unique="false" columns="CLIENTE"/> | |
<index name="DEPINDEX" unique="false" columns="DEPTO"/> | |
<index name="FATINDEX" unique="false" columns="FATURA"/> | |
<index name="TIPINDEX" unique="false" columns="TIPO"/> | |
</table> | |
<table name="fluxo" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/> | |
<column name="DATAL" sqlType="DATE" precision="10" scale="0" nullable="false" jdbcType="91"/> | |
<column name="DATAC" sqlType="DATE" precision="10" scale="0" nullable="false" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="CCUSTO" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="CX" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="ID_CONTA" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="TP_CONTA" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<column name="DESCR" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="false" jdbcType="8"/> | |
<primary-key name="PRIMARY" columns="ID"/> | |
</table> | |
<table name="fluxoccusto" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="CCUSTO" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="INATIVO" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="ID"/> | |
</table> | |
<table name="fluxoconta" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="TP_CX" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<column name="CAIXACONTA" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/> | |
<column name="INATIVO" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<column name="BANCO" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="AGENCIA" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID"/> | |
</table> | |
<table name="fluxosaldo" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/> | |
<column name="DATAS" sqlType="DATE" precision="10" scale="0" nullable="false" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="CX" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="false" jdbcType="8"/> | |
<column name="FECHADO" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<column name="DATAF" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<primary-key name="PRIMARY" columns="ID"/> | |
</table> | |
<table name="franquias" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_FRQ" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="MAQUINA" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DATA2" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="INICIAL" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="FINAL" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OPERACAO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="QTD" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="CLIENTE" sqlType="VARCHAR" precision="92" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODIGO" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FATURADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="NF" sqlType="VARCHAR" precision="7" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VENCIMENTO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="BAIXADO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="OBS" sqlType="VARCHAR" precision="40" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OS1" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OS2" sqlType="VARCHAR" precision="12" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONTRATO" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CODADMIN" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="NRCARTAO" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DH" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<primary-key name="PRIMARY" columns="ID_FRQ"/> | |
<index name="DATA2INDEX" unique="false" columns="DATA2"/> | |
<index name="DATINDEX" unique="false" columns="DATA1"/> | |
<index name="MAQINDEX" unique="false" columns="MAQUINA"/> | |
<index name="ECTINDEX" unique="false" columns="TIPO"/> | |
<index name="CODINDEX" unique="false" columns="CODIGO"/> | |
</table> | |
<table name="info" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_INF" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="ID_SERV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="TAB_INFO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="TAB_ITEM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DESCR" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_INF"/> | |
<index name="ID_SERVINDEX" unique="false" columns="ID_SERV"/> | |
</table> | |
<table name="lancamentos" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_LAN" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="CREDORA" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DEVEDORA" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="HISTORICO" sqlType="VARCHAR" precision="60" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REGISTRO" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FINANCEIRO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="QTD" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="DEPOSITO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="DATADEP" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="ADMINISTRATIVO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="AUX1" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_LAN"/> | |
<index name="CODINDEX" unique="false" columns="REGISTRO"/> | |
<index name="FINANCINDEX" unique="false" columns="FINANCEIRO,DATA1"/> | |
<index name="OPERINDEX" unique="false" columns="DATA1,OPERADOR"/> | |
</table> | |
<table name="mala" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_MAL" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="MALA" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="LINHA" sqlType="VARCHAR" precision="8" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PESO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="CODDEST" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EXPEDIDA" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="IMP" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DESCRICAO" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="HORA" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<column name="NOTA" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEPNOTA" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FL_EXP" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_MAL"/> | |
<index name="CODINDEX" unique="false" columns="DATA,MALA"/> | |
<index name="DESTINDEX" unique="false" columns="DATA,CODDEST,LINHA"/> | |
<index name="MALINDEX" unique="false" columns="MALA"/> | |
<index name="NOTINDEX" unique="false" columns="DATA,LINHA,CODDEST,MALA"/> | |
</table> | |
<table name="objetos" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_OBJ" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="MALA" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBJETO" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_OBJ"/> | |
<index name="MALINDEX" unique="false" columns="MALA"/> | |
<index name="OBJETOINDEX" unique="false" columns="OBJETO"/> | |
</table> | |
<table name="pagfaturas" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_PFAT" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="GRUPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SUBGRUPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="ITEM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="SUBITEM" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="DATACOMP" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="HORA" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBS" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DESCR" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SINAL" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="FATURA" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_PFAT"/> | |
<index name="FATINDEX" unique="false" columns="FATURA"/> | |
</table> | |
<table name="pc1" schema="" catalog="vpost" type="TABLE"> | |
<column name="pc1_id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/> | |
<column name="pc1_nom" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="pc1_des" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="pc1_tpc" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<column name="pc1_inativo" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="pc1_id"/> | |
</table> | |
<table name="pc2" schema="" catalog="vpost" type="TABLE"> | |
<column name="pc2_id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/> | |
<column name="pc1_id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5"/> | |
<column name="pc2_nom" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="pc2_des" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="pc2_inativo" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="pc2_id"/> | |
</table> | |
<table name="pc3" schema="" catalog="vpost" type="TABLE"> | |
<column name="pc3_id" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="pc2_id" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/> | |
<column name="pc3_nom" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<column name="pc3_inativo" sqlType="TINYINT" precision="3" scale="0" nullable="false" jdbcType="-6"/> | |
<primary-key name="PRIMARY" columns="pc3_id"/> | |
</table> | |
<table name="plano" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_PLN" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DESCRICAO" sqlType="VARCHAR" precision="52" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CONTA" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SUBCONTA" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_PLN"/> | |
<index name="CODINDEX" unique="false" columns="TIPO,CONTA,SUBCONTA"/> | |
<index name="NOMINDEX" unique="false" columns="DESCRICAO"/> | |
</table> | |
<table name="reservas" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_RSV" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="REGISTRO" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_RSV"/> | |
<index name="RESINDEX" unique="true" columns="REGISTRO,TIPO,OPERADOR"/> | |
</table> | |
<table name="saldo" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_SLD" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="SALDO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="DESCRICAO" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_SLD"/> | |
<index name="DATINDEX" unique="false" columns="DATA"/> | |
</table> | |
<table name="servicos" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_SRV" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ATENDIMENTO" sqlType="VARCHAR" precision="4" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OPERACAO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="REGISTRO" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DESTINATARIO" sqlType="VARCHAR" precision="50" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP" sqlType="VARCHAR" precision="40" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ANOTACOES" sqlType="VARCHAR" precision="90" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ADICIONAIS" sqlType="VARCHAR" precision="18" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PESO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CUBICO" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DECLARADO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="QTD" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="TIPO" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="UNITARIO" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="ORDEM" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="AUX1" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="AUX2" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="AUX3" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="AUX4" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="AUX5" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="AUX6" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ID_ROBO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="NOTA" sqlType="VARCHAR" precision="15" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ID_PNET" sqlType="VARCHAR" precision="30" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ID_SIS" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="FL_PNET" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="ID_VOLUME" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="HRA_OBJ" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<primary-key name="PRIMARY" columns="ID_SRV"/> | |
<index name="CONTAINDEX" unique="false" columns="AUX6"/> | |
<index name="OBJETINDEX" unique="false" columns="REGISTRO"/> | |
<index name="ORDINDEX" unique="false" columns="ORDEM"/> | |
<index name="DATINDEX" unique="false" columns="DATA1"/> | |
<index name="OPERINDEX" unique="false" columns="OPERACAO"/> | |
<index name="OPINDEX" unique="false" columns="OPERADOR"/> | |
<index name="ATENDINDEX" unique="false" columns="ATENDIMENTO"/> | |
<index name="VINCINDEX" unique="false" columns="DATA1,OPERADOR,ATENDIMENTO"/> | |
</table> | |
<table name="sigep" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_SIGEP" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATA1" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ATENDIMENTO" sqlType="VARCHAR" precision="4" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OPERACAO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="IDSERVICO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="INICIAL" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="FINAL" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="STATUS" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="PLP" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="DT_TRANS" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/> | |
<column name="LOG_TRANS" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_SIGEP"/> | |
<index name="ATENDINDEX" unique="false" columns="DATA1,OPERADOR,ATENDIMENTO"/> | |
</table> | |
<table name="siglas" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_SIG" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="SIGLA" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<column name="TIPO" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<primary-key name="PRIMARY" columns="ID_SIG"/> | |
</table> | |
<table name="valespostais" schema="" catalog="vpost" type="TABLE"> | |
<column name="ID_VLP" sqlType="INT" precision="10" scale="0" nullable="false" jdbcType="4" autoIncrement="true"/> | |
<column name="DATAV" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="REGISTRO" sqlType="VARCHAR" precision="13" scale="0" nullable="true" jdbcType="12"/> | |
<column name="VALOR" sqlType="DOUBLE" precision="22" scale="0" nullable="true" jdbcType="8"/> | |
<column name="PRAZO" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DEVOLVIDO" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/> | |
<column name="DATADEVOLUCAO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="OBS" sqlType="VARCHAR" precision="60" scale="0" nullable="true" jdbcType="12"/> | |
<column name="REGISTROF" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CATEGORIA" sqlType="VARCHAR" precision="1" scale="0" nullable="true" jdbcType="12"/> | |
<column name="EMISSAO" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="LIMITE" sqlType="DATE" precision="10" scale="0" nullable="true" jdbcType="91"/> | |
<column name="REMETENTE" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ORIGEM" sqlType="VARCHAR" precision="60" scale="0" nullable="true" jdbcType="12"/> | |
<column name="PESO" sqlType="VARCHAR" precision="5" scale="0" nullable="true" jdbcType="12"/> | |
<column name="DESTINATARIO" sqlType="VARCHAR" precision="100" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ENDERECO" sqlType="VARCHAR" precision="70" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CIDADE" sqlType="VARCHAR" precision="25" scale="0" nullable="true" jdbcType="12"/> | |
<column name="UF" sqlType="VARCHAR" precision="2" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CEP" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="OBSD" sqlType="VARCHAR" precision="60" scale="0" nullable="true" jdbcType="12"/> | |
<column name="ORDEM" sqlType="VARCHAR" precision="11" scale="0" nullable="true" jdbcType="12"/> | |
<column name="UPOSTAG" sqlType="VARCHAR" precision="9" scale="0" nullable="true" jdbcType="12"/> | |
<column name="HORA" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/> | |
<column name="CLIENTE" sqlType="VARCHAR" precision="10" scale="0" nullable="true" jdbcType="12"/> | |
<column name="CXPOSTAL" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="TIPODEV" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/> | |
<column name="OPERADOR" sqlType="VARCHAR" precision="3" scale="0" nullable="true" jdbcType="12"/> | |
<primary-key name="PRIMARY" columns="ID_VLP"/> | |
<index name="ORDINDEX" unique="true" columns="CATEGORIA,ORDEM"/> | |
<index name="CLINDEX" unique="false" columns="CLIENTE"/> | |
<index name="CODINDEX" unique="false" columns="REGISTRO"/> | |
<index name="CXPINDEX" unique="false" columns="CXPOSTAL"/> | |
<index name="DATINDEX" unique="false" columns="DATAV"/> | |
<index name="OBSINDEX" unique="false" columns="OBS"/> | |
<index name="LIMITINDEX" unique="false" columns="LIMITE"/> | |
</table> | |
</data-source> | |
<data-source source="LOCAL" name="default" uuid="08c0195c-cc66-4c8c-8f75-19a4ae7eee18"> | |
<database-info product="MySQL" version="5.1.32-community" jdbc-version="3.0" driver-name="MySQL-AB JDBC Driver" driver-version="mysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} )"> | |
<extra-name-characters>#@</extra-name-characters> | |
<identifier-quote-string>`</identifier-quote-string> | |
</database-info> | |
<case-sensitivity plain-identifiers="lower" quoted-identifiers="lower"/> | |
<schema name="" catalog="cadastro"/> | |
<schema name="" catalog="information_schema"/> | |
<schema name="" catalog="lojacds"/> | |
<schema name="" catalog="mysql"/> | |
<schema name="" catalog="test"/> | |
<schema name="" catalog="vpost"/> | |
</data-source> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="DataSourceManagerImpl" format="xml" hash="2142293260"> | |
<data-source source="LOCAL" name="MySQL - cadastro@localhost" uuid="b9b8334f-f21c-48f6-87e4-fa9e0965a5c3"> | |
<driver-ref>mysql</driver-ref> | |
<synchronize>true</synchronize> | |
<jdbc-driver>com.mysql.jdbc.Driver</jdbc-driver> | |
<jdbc-url>jdbc:mysql://localhost:3306/cadastro</jdbc-url> | |
<user-name>root</user-name> | |
<user-password>df9bdf98df99df9edf9fdf9c</user-password> | |
<driver-properties> | |
<property name="zeroDateTimeBehavior" value="convertToNull" /> | |
<property name="tinyInt1isBit" value="false" /> | |
</driver-properties> | |
<libraries /> | |
</data-source> | |
<data-source source="LOCAL" name="default" uuid="08c0195c-cc66-4c8c-8f75-19a4ae7eee18"> | |
<driver-ref>mysql</driver-ref> | |
<jdbc-driver>com.mysql.jdbc.Driver</jdbc-driver> | |
<jdbc-url>jdbc:mysql://localhost:3306/cadastro</jdbc-url> | |
<user-name>root</user-name> | |
<user-password>df9bdf98df99df9edf9fdf9c</user-password> | |
<table-pattern>cadastro</table-pattern> | |
<libraries> | |
<library> | |
<url>file://C:\API's\mysql-connector-java-5.1.13-bin.jar</url> | |
</library> | |
</libraries> | |
</data-source> | |
</component> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Encoding" useUTFGuessing="true" native2AsciiForPropertiesFiles="false" /> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="InspectionProjectProfileManager"> | |
<settings> | |
<option name="PROJECT_PROFILE" value="Project Default" /> | |
<option name="USE_PROJECT_PROFILE" value="true" /> | |
<version value="1.0" /> | |
</settings> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="InspectionProjectProfileManager"> | |
<profile version="1.0" is_locked="false"> | |
<option name="myName" value="Project Default" /> | |
<option name="myLocal" value="false" /> | |
<inspection_tool class="LoggerInitializedWithForeignClass" enabled="false" level="WARNING" enabled_by_default="false"> | |
<option name="loggerClassName" value="org.apache.log4j.Logger,org.slf4j.LoggerFactory,org.apache.commons.logging.LogFactory,java.util.logging.Logger" /> | |
<option name="loggerFactoryMethodName" value="getLogger,getLogger,getLog,getLogger" /> | |
</inspection_tool> | |
<inspection_tool class="SpellCheckingInspection" enabled="false" level="TYPO" enabled_by_default="false"> | |
<option name="processCode" value="true" /> | |
<option name="processLiterals" value="true" /> | |
<option name="processComments" value="true" /> | |
</inspection_tool> | |
</profile> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="libraryTable"> | |
<library name="mysql-connector-java-5.1.13-bin"> | |
<CLASSES> | |
<root url="jar://C:/API's/mysql-connector-java-5.1.13-bin.jar!/" /> | |
</CLASSES> | |
<JAVADOC /> | |
<SOURCES /> | |
</library> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="EntryPointsManager"> | |
<entry_points version="2.0" /> | |
</component> | |
<component name="IdProvider" IDEtalkID="F8D3E3ADFCAD59FFE69311DE07BFA871" /> | |
<component name="ProjectRootManager" version="2" languageLevel="JDK_1_6" assert-keyword="true" jdk-15="true" project-jdk-name="1.8" project-jdk-type="JavaSDK"> | |
<output url="file://$PROJECT_DIR$/out" /> | |
</component> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="ProjectModuleManager"> | |
<modules> | |
<module fileurl="file://$PROJECT_DIR$/Cadastro Operacoes.iml" filepath="$PROJECT_DIR$/Cadastro Operacoes.iml" /> | |
</modules> | |
</component> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="DependencyValidationManager"> | |
<state> | |
<option name="SKIP_IMPORT_STATEMENTS" value="false" /> | |
</state> | |
</component> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Palette2"> | |
<group name="Swing"> | |
<item class="com.intellij.uiDesigner.HSpacer" tooltip-text="Horizontal Spacer" icon="/com/intellij/uiDesigner/icons/hspacer.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="1" hsize-policy="6" anchor="0" fill="1" /> | |
</item> | |
<item class="com.intellij.uiDesigner.VSpacer" tooltip-text="Vertical Spacer" icon="/com/intellij/uiDesigner/icons/vspacer.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="1" anchor="0" fill="2" /> | |
</item> | |
<item class="javax.swing.JPanel" icon="/com/intellij/uiDesigner/icons/panel.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JScrollPane" icon="/com/intellij/uiDesigner/icons/scrollPane.png" removable="false" auto-create-binding="false" can-attach-label="true"> | |
<default-constraints vsize-policy="7" hsize-policy="7" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JButton" icon="/com/intellij/uiDesigner/icons/button.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="0" fill="1" /> | |
<initial-values> | |
<property name="text" value="Button" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JRadioButton" icon="/com/intellij/uiDesigner/icons/radioButton.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="RadioButton" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JCheckBox" icon="/com/intellij/uiDesigner/icons/checkBox.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="CheckBox" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JLabel" icon="/com/intellij/uiDesigner/icons/label.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="0" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="Label" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JTextField" icon="/com/intellij/uiDesigner/icons/textField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JPasswordField" icon="/com/intellij/uiDesigner/icons/passwordField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JFormattedTextField" icon="/com/intellij/uiDesigner/icons/formattedTextField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTextArea" icon="/com/intellij/uiDesigner/icons/textArea.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTextPane" icon="/com/intellij/uiDesigner/icons/textPane.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JEditorPane" icon="/com/intellij/uiDesigner/icons/editorPane.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JComboBox" icon="/com/intellij/uiDesigner/icons/comboBox.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="2" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JTable" icon="/com/intellij/uiDesigner/icons/table.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JList" icon="/com/intellij/uiDesigner/icons/list.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="2" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTree" icon="/com/intellij/uiDesigner/icons/tree.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTabbedPane" icon="/com/intellij/uiDesigner/icons/tabbedPane.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3"> | |
<preferred-size width="200" height="200" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JSplitPane" icon="/com/intellij/uiDesigner/icons/splitPane.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3"> | |
<preferred-size width="200" height="200" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JSpinner" icon="/com/intellij/uiDesigner/icons/spinner.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JSlider" icon="/com/intellij/uiDesigner/icons/slider.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JSeparator" icon="/com/intellij/uiDesigner/icons/separator.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JProgressBar" icon="/com/intellij/uiDesigner/icons/progressbar.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="0" fill="1" /> | |
</item> | |
<item class="javax.swing.JToolBar" icon="/com/intellij/uiDesigner/icons/toolbar.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="0" fill="1"> | |
<preferred-size width="-1" height="20" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JToolBar$Separator" icon="/com/intellij/uiDesigner/icons/toolbarSeparator.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="0" anchor="0" fill="1" /> | |
</item> | |
<item class="javax.swing.JScrollBar" icon="/com/intellij/uiDesigner/icons/scrollbar.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="0" anchor="0" fill="2" /> | |
</item> | |
</group> | |
</component> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="VcsDirectoryMappings"> | |
<mapping directory="" vcs="" /> | |
</component> | |
</project> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<module type="JAVA_MODULE" version="4"> | |
<component name="FacetManager"> | |
<facet type="web" name="Web"> | |
<configuration> | |
<descriptors> | |
<deploymentDescriptor name="web.xml" url="file://$MODULE_DIR$/web/WEB-INF/web.xml" /> | |
</descriptors> | |
<webroots> | |
<root url="file://$MODULE_DIR$/web" relative="/" /> | |
</webroots> | |
</configuration> | |
</facet> | |
<facet type="jpa" name="JPA"> | |
<configuration> | |
<setting name="validation-enabled" value="true" /> | |
<setting name="provider-name" value="Hibernate" /> | |
<datasource-mapping> | |
<factory-entry name="default" value="08c0195c-cc66-4c8c-8f75-19a4ae7eee18" /> | |
</datasource-mapping> | |
<deploymentDescriptor name="persistence.xml" url="file://$MODULE_DIR$/src/META-INF/persistence.xml" /> | |
</configuration> | |
</facet> | |
</component> | |
<component name="NewModuleRootManager" inherit-compiler-output="true"> | |
<exclude-output /> | |
<content url="file://$MODULE_DIR$"> | |
<sourceFolder url="file://$MODULE_DIR$/src" isTestSource="false" /> | |
</content> | |
<orderEntry type="inheritedJdk" /> | |
<orderEntry type="sourceFolder" forTests="false" /> | |
<orderEntry type="library" scope="PROVIDED" name="GlassFish 4.0.0" level="application_server_libraries" /> | |
<orderEntry type="library" scope="PROVIDED" name="GlassFish 4.0.0 - JSF" level="application_server_libraries" /> | |
<orderEntry type="library" name="Primefaces" level="application" /> | |
<orderEntry type="library" scope="PROVIDED" name="GlassFish 4.0.0 - CDI: Contexts and Dependency Injection" level="application_server_libraries" /> | |
<orderEntry type="library" name="Hibernate JPA" level="application" /> | |
<orderEntry type="library" name="mysql-connector-java-5.1.13-bin" level="project" /> | |
</component> | |
</module> | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<beans | |
xmlns="http://xmlns.jcp.org/xml/ns/javaee" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee | |
http://xmlns.jcp.org/xml/ns/javaee/beans_1_1.xsd" | |
bean-discovery-mode="all"> | |
</beans> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IntelliJ API Decompiler stub source generated from a class file | |
// Implementation of methods is not available | |
package com.cadastro.dao; | |
public class JPAUtil { | |
private static final javax.persistence.EntityManagerFactory emf; | |
public JPAUtil() { /* compiled code */ } | |
@javax.enterprise.inject.Produces | |
public static javax.persistence.EntityManager getEntityManager() { /* compiled code */ } | |
public static void close(@javax.enterprise.inject.Disposes javax.persistence.EntityManager em) { /* compiled code */ } | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IntelliJ API Decompiler stub source generated from a class file | |
// Implementation of methods is not available | |
package com.cadastro.model; | |
@javax.persistence.Entity(name = "adicionais") | |
public class Adicional implements java.io.Serializable, com.cadastro.model.EntityIdentificated, com.cadastro.model.RepresentedByImage { | |
@javax.persistence.Id | |
@javax.persistence.GeneratedValue | |
private java.lang.Long id; | |
private java.lang.String sigla; | |
private java.lang.String descricao; | |
private java.lang.Boolean percentual; | |
private java.lang.Double valor; | |
private java.lang.Byte[] imagem; | |
@javax.persistence.ManyToMany(mappedBy = "adicionais") | |
private java.util.List<com.cadastro.model.Servico> servicos; | |
public Adicional() { /* compiled code */ } | |
public java.lang.Long getId() { /* compiled code */ } | |
public void setId(java.lang.Long id) { /* compiled code */ } | |
public java.lang.String getSigla() { /* compiled code */ } | |
public void setSigla(java.lang.String sigla) { /* compiled code */ } | |
public java.lang.String getDescricao() { /* compiled code */ } | |
public void setDescricao(java.lang.String descricao) { /* compiled code */ } | |
public java.lang.Boolean getPercentual() { /* compiled code */ } | |
public void setPercentual(java.lang.Boolean percentual) { /* compiled code */ } | |
public java.lang.Double getValor() { /* compiled code */ } | |
public void setValor(java.lang.Double valor) { /* compiled code */ } | |
public java.lang.Byte[] getImagem() { /* compiled code */ } | |
public void setImagem(java.lang.Byte[] imagem) { /* compiled code */ } | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IntelliJ API Decompiler stub source generated from a class file | |
// Implementation of methods is not available | |
package com.cadastro.model; | |
public interface EntityIdentificated { | |
java.lang.Object getId(); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IntelliJ API Decompiler stub source generated from a class file | |
// Implementation of methods is not available | |
package com.cadastro.model; | |
@javax.persistence.Entity(name = "grupos") | |
public class Grupo implements java.io.Serializable, com.cadastro.model.EntityIdentificated, com.cadastro.model.RepresentedByImage { | |
@javax.persistence.Id | |
@javax.persistence.GeneratedValue | |
private java.lang.Long id; | |
private java.lang.String descricao; | |
private java.lang.Integer codigo; | |
private java.lang.Byte[] imagem; | |
@javax.persistence.OneToMany(mappedBy = "grupo") | |
private java.util.List<com.cadastro.model.Servico> servicos; | |
public Grupo() { /* compiled code */ } | |
public java.lang.Long getId() { /* compiled code */ } | |
public java.lang.Byte[] getImagem() { /* compiled code */ } | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IntelliJ API Decompiler stub source generated from a class file | |
// Implementation of methods is not available | |
package com.cadastro.model; | |
public interface RepresentedByImage { | |
java.lang.Byte[] getImagem(); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IntelliJ API Decompiler stub source generated from a class file | |
// Implementation of methods is not available | |
package com.cadastro.model; | |
@javax.persistence.Entity(name = "servicos") | |
public class Servico implements java.io.Serializable, com.cadastro.model.RepresentedByImage, com.cadastro.model.EntityIdentificated { | |
@javax.persistence.Id | |
@javax.persistence.GeneratedValue | |
private java.lang.Long id; | |
private java.lang.String descricao; | |
@javax.persistence.ManyToOne | |
private com.cadastro.model.Grupo grupo; | |
@javax.persistence.ManyToMany | |
private java.util.List<com.cadastro.model.Adicional> adicionais; | |
private java.lang.Byte[] imagem; | |
public Servico() { /* compiled code */ } | |
public java.lang.Long getId() { /* compiled code */ } | |
public void setId(java.lang.Long id) { /* compiled code */ } | |
public java.lang.String getDescricao() { /* compiled code */ } | |
public void setDescricao(java.lang.String descricao) { /* compiled code */ } | |
public com.cadastro.model.Grupo getGrupo() { /* compiled code */ } | |
public void setGrupo(com.cadastro.model.Grupo grupo) { /* compiled code */ } | |
public java.util.List<com.cadastro.model.Adicional> getAdicionais() { /* compiled code */ } | |
public void setAdicionais(java.util.List<com.cadastro.model.Adicional> adicionais) { /* compiled code */ } | |
public java.lang.Byte[] getImagem() { /* compiled code */ } | |
public void setImagem(java.lang.Byte[] imagem) { /* compiled code */ } | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"> | |
<persistence-unit name="default" transaction-type="RESOURCE_LOCAL"> | |
<provider>org.hibernate.ejb.HibernatePersistence</provider> | |
<jta-data-source></jta-data-source> | |
<properties> | |
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/cadastro"/> | |
<property name="javax.persistence.jdbc.user" value="root"/> | |
<property name="javax.persistence.jdbc.password" value="123456"/> | |
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/> | |
<property name="hibernate.hbm2ddl.auto" value="update"/> | |
<property name="hibernate.show_sql" value="true"/> | |
<property name="hibernate.format_sql" value="true"/> | |
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/> | |
</properties> | |
</persistence-unit> | |
</persistence> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version='1.0' encoding='UTF-8'?> | |
<faces-config version="2.2" xmlns="http://xmlns.jcp.org/xml/ns/javaee" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee | |
http://xmlns.jcp.org/xml/ns/javaee/web-facesconfig_2_2.xsd"> | |
</faces-config> |
View raw
(Sorry about that, but we can’t show files that are this big right now.)
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PK | |