Revert "用户"
This reverts commit f6824511ca617c9421633c44830c938b862e75df.
Reason for revert: <撤销>
Change-Id: Ie4ee5bc5d3fa26981f61c52408ecf2d0a8e45243
diff --git a/.idea/dataSources.local.xml b/.idea/dataSources.local.xml
deleted file mode 100644
index 06df570..0000000
--- a/.idea/dataSources.local.xml
+++ /dev/null
@@ -1,18 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<project version="4">
- <component name="dataSourceStorageLocal" created-in="IU-243.21565.193">
- <data-source name="ptProject@localhost" uuid="6689f15a-5cd0-40b0-970c-713db3e7bac2">
- <database-info product="MySQL" version="8.0.40" jdbc-version="4.2" driver-name="MySQL Connector/J" driver-version="mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)" dbms="MYSQL" exact-version="8.0.40" exact-driver-version="8.2">
- <extra-name-characters>#@</extra-name-characters>
- <identifier-quote-string>`</identifier-quote-string>
- </database-info>
- <case-sensitivity plain-identifiers="lower" quoted-identifiers="lower" />
- <user-name>root</user-name>
- <schema-mapping>
- <introspection-scope>
- <node kind="schema" qname="@" />
- </introspection-scope>
- </schema-mapping>
- </data-source>
- </component>
-</project>
\ No newline at end of file
diff --git a/.idea/dataSources.xml b/.idea/dataSources.xml
deleted file mode 100644
index 25041e4..0000000
--- a/.idea/dataSources.xml
+++ /dev/null
@@ -1,19 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<project version="4">
- <component name="DataSourceManagerImpl" format="xml" multifile-model="true">
- <data-source source="LOCAL" name="ptProject@localhost" uuid="6689f15a-5cd0-40b0-970c-713db3e7bac2">
- <driver-ref>mysql.8</driver-ref>
- <synchronize>true</synchronize>
- <imported>true</imported>
- <jdbc-driver>com.mysql.cj.jdbc.Driver</jdbc-driver>
- <jdbc-url>jdbc:mysql://localhost:3306/ptProject</jdbc-url>
- <jdbc-additional-properties>
- <property name="com.intellij.clouds.kubernetes.db.host.port" />
- <property name="com.intellij.clouds.kubernetes.db.enabled" value="false" />
- <property name="com.intellij.clouds.kubernetes.db.resource.type" value="Deployment" />
- <property name="com.intellij.clouds.kubernetes.db.container.port" />
- </jdbc-additional-properties>
- <working-dir>$ProjectFileDir$</working-dir>
- </data-source>
- </component>
-</project>
\ No newline at end of file
diff --git a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2.xml b/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2.xml
deleted file mode 100644
index a0d6068..0000000
--- a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2.xml
+++ /dev/null
@@ -1,2708 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<dataSource name="ptProject@localhost">
- <database-model serializer="dbm" dbms="MYSQL" family-id="MYSQL" format-version="4.53">
- <root id="1">
- <DefaultCasing>lower/lower</DefaultCasing>
- <DefaultEngine>InnoDB</DefaultEngine>
- <DefaultTmpEngine>InnoDB</DefaultTmpEngine>
- <Grants>|root||root|localhost|ALTER|G
-|root||root|localhost|ALTER ROUTINE|G
-|root||root|localhost|APPLICATION_PASSWORD_ADMIN|G
-|root||mysql.infoschema|localhost|AUDIT_ABORT_EXEMPT|G
-|root||mysql.session|localhost|AUDIT_ABORT_EXEMPT|G
-|root||mysql.sys|localhost|AUDIT_ABORT_EXEMPT|G
-|root||root|localhost|AUDIT_ABORT_EXEMPT|G
-|root||root|localhost|AUDIT_ADMIN|G
-|root||mysql.session|localhost|AUTHENTICATION_POLICY_ADMIN|G
-|root||root|localhost|AUTHENTICATION_POLICY_ADMIN|G
-|root||mysql.session|localhost|BACKUP_ADMIN|G
-|root||root|localhost|BACKUP_ADMIN|G
-|root||root|localhost|BINLOG_ADMIN|G
-|root||root|localhost|BINLOG_ENCRYPTION_ADMIN|G
-|root||mysql.session|localhost|CLONE_ADMIN|G
-|root||root|localhost|CLONE_ADMIN|G
-|root||mysql.session|localhost|CONNECTION_ADMIN|G
-|root||root|localhost|CONNECTION_ADMIN|G
-|root||root|localhost|CREATE|G
-|root||root|localhost|CREATE ROLE|G
-|root||root|localhost|CREATE ROUTINE|G
-|root||root|localhost|CREATE TABLESPACE|G
-|root||root|localhost|CREATE TEMPORARY TABLES|G
-|root||root|localhost|CREATE USER|G
-|root||root|localhost|CREATE VIEW|G
-|root||root|localhost|DELETE|G
-|root||root|localhost|DROP|G
-|root||root|localhost|DROP ROLE|G
-|root||root|localhost|ENCRYPTION_KEY_ADMIN|G
-|root||root|localhost|EVENT|G
-|root||root|localhost|EXECUTE|G
-|root||root|localhost|FILE|G
-|root||mysql.infoschema|localhost|FIREWALL_EXEMPT|G
-|root||mysql.session|localhost|FIREWALL_EXEMPT|G
-|root||mysql.sys|localhost|FIREWALL_EXEMPT|G
-|root||root|localhost|FIREWALL_EXEMPT|G
-|root||root|localhost|FLUSH_OPTIMIZER_COSTS|G
-|root||root|localhost|FLUSH_STATUS|G
-|root||root|localhost|FLUSH_TABLES|G
-|root||root|localhost|FLUSH_USER_RESOURCES|G
-|root||root|localhost|GROUP_REPLICATION_ADMIN|G
-|root||root|localhost|GROUP_REPLICATION_STREAM|G
-|root||root|localhost|INDEX|G
-|root||root|localhost|INNODB_REDO_LOG_ARCHIVE|G
-|root||root|localhost|INNODB_REDO_LOG_ENABLE|G
-|root||root|localhost|INSERT|G
-|root||root|localhost|LOCK TABLES|G
-|root||root|localhost|PASSWORDLESS_USER_ADMIN|G
-|root||mysql.session|localhost|PERSIST_RO_VARIABLES_ADMIN|G
-|root||root|localhost|PERSIST_RO_VARIABLES_ADMIN|G
-|root||root|localhost|PROCESS|G
-|root||root|localhost|REFERENCES|G
-|root||root|localhost|RELOAD|G
-|root||root|localhost|REPLICATION CLIENT|G
-|root||root|localhost|REPLICATION SLAVE|G
-|root||root|localhost|REPLICATION_APPLIER|G
-|root||root|localhost|REPLICATION_SLAVE_ADMIN|G
-|root||root|localhost|RESOURCE_GROUP_ADMIN|G
-|root||root|localhost|RESOURCE_GROUP_USER|G
-|root||root|localhost|ROLE_ADMIN|G
-|root||mysql.infoschema|localhost|SELECT|G
-|root||root|localhost|SELECT|G
-|root||root|localhost|SENSITIVE_VARIABLES_OBSERVER|G
-|root||root|localhost|SERVICE_CONNECTION_ADMIN|G
-|root||mysql.session|localhost|SESSION_VARIABLES_ADMIN|G
-|root||root|localhost|SESSION_VARIABLES_ADMIN|G
-|root||root|localhost|SET_USER_ID|G
-|root||root|localhost|SHOW DATABASES|G
-|root||root|localhost|SHOW VIEW|G
-|root||root|localhost|SHOW_ROUTINE|G
-|root||mysql.session|localhost|SHUTDOWN|G
-|root||root|localhost|SHUTDOWN|G
-|root||mysql.session|localhost|SUPER|G
-|root||root|localhost|SUPER|G
-|root||mysql.infoschema|localhost|SYSTEM_USER|G
-|root||mysql.session|localhost|SYSTEM_USER|G
-|root||mysql.sys|localhost|SYSTEM_USER|G
-|root||root|localhost|SYSTEM_USER|G
-|root||mysql.session|localhost|SYSTEM_VARIABLES_ADMIN|G
-|root||root|localhost|SYSTEM_VARIABLES_ADMIN|G
-|root||root|localhost|TABLE_ENCRYPTION_ADMIN|G
-|root||root|localhost|TELEMETRY_LOG_ADMIN|G
-|root||root|localhost|TRIGGER|G
-|root||root|localhost|UPDATE|G
-|root||root|localhost|XA_RECOVER_ADMIN|G
-|root||root|localhost|grant option|G
-performance_schema|schema||mysql.session|localhost|SELECT|G
-sys|schema||mysql.sys|localhost|TRIGGER|G</Grants>
- <ServerVersion>8.0.40</ServerVersion>
- </root>
- <collation id="2" parent="1" name="armscii8_general_ci">
- <Charset>armscii8</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="3" parent="1" name="armscii8_bin">
- <Charset>armscii8</Charset>
- </collation>
- <collation id="4" parent="1" name="ascii_general_ci">
- <Charset>ascii</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="5" parent="1" name="ascii_bin">
- <Charset>ascii</Charset>
- </collation>
- <collation id="6" parent="1" name="big5_chinese_ci">
- <Charset>big5</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="7" parent="1" name="big5_bin">
- <Charset>big5</Charset>
- </collation>
- <collation id="8" parent="1" name="binary">
- <Charset>binary</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="9" parent="1" name="cp1250_general_ci">
- <Charset>cp1250</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="10" parent="1" name="cp1250_czech_cs">
- <Charset>cp1250</Charset>
- </collation>
- <collation id="11" parent="1" name="cp1250_croatian_ci">
- <Charset>cp1250</Charset>
- </collation>
- <collation id="12" parent="1" name="cp1250_bin">
- <Charset>cp1250</Charset>
- </collation>
- <collation id="13" parent="1" name="cp1250_polish_ci">
- <Charset>cp1250</Charset>
- </collation>
- <collation id="14" parent="1" name="cp1251_bulgarian_ci">
- <Charset>cp1251</Charset>
- </collation>
- <collation id="15" parent="1" name="cp1251_ukrainian_ci">
- <Charset>cp1251</Charset>
- </collation>
- <collation id="16" parent="1" name="cp1251_bin">
- <Charset>cp1251</Charset>
- </collation>
- <collation id="17" parent="1" name="cp1251_general_ci">
- <Charset>cp1251</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="18" parent="1" name="cp1251_general_cs">
- <Charset>cp1251</Charset>
- </collation>
- <collation id="19" parent="1" name="cp1256_general_ci">
- <Charset>cp1256</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="20" parent="1" name="cp1256_bin">
- <Charset>cp1256</Charset>
- </collation>
- <collation id="21" parent="1" name="cp1257_lithuanian_ci">
- <Charset>cp1257</Charset>
- </collation>
- <collation id="22" parent="1" name="cp1257_bin">
- <Charset>cp1257</Charset>
- </collation>
- <collation id="23" parent="1" name="cp1257_general_ci">
- <Charset>cp1257</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="24" parent="1" name="cp850_general_ci">
- <Charset>cp850</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="25" parent="1" name="cp850_bin">
- <Charset>cp850</Charset>
- </collation>
- <collation id="26" parent="1" name="cp852_general_ci">
- <Charset>cp852</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="27" parent="1" name="cp852_bin">
- <Charset>cp852</Charset>
- </collation>
- <collation id="28" parent="1" name="cp866_general_ci">
- <Charset>cp866</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="29" parent="1" name="cp866_bin">
- <Charset>cp866</Charset>
- </collation>
- <collation id="30" parent="1" name="cp932_japanese_ci">
- <Charset>cp932</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="31" parent="1" name="cp932_bin">
- <Charset>cp932</Charset>
- </collation>
- <collation id="32" parent="1" name="dec8_swedish_ci">
- <Charset>dec8</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="33" parent="1" name="dec8_bin">
- <Charset>dec8</Charset>
- </collation>
- <collation id="34" parent="1" name="eucjpms_japanese_ci">
- <Charset>eucjpms</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="35" parent="1" name="eucjpms_bin">
- <Charset>eucjpms</Charset>
- </collation>
- <collation id="36" parent="1" name="euckr_korean_ci">
- <Charset>euckr</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="37" parent="1" name="euckr_bin">
- <Charset>euckr</Charset>
- </collation>
- <collation id="38" parent="1" name="gb18030_chinese_ci">
- <Charset>gb18030</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="39" parent="1" name="gb18030_bin">
- <Charset>gb18030</Charset>
- </collation>
- <collation id="40" parent="1" name="gb18030_unicode_520_ci">
- <Charset>gb18030</Charset>
- </collation>
- <collation id="41" parent="1" name="gb2312_chinese_ci">
- <Charset>gb2312</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="42" parent="1" name="gb2312_bin">
- <Charset>gb2312</Charset>
- </collation>
- <collation id="43" parent="1" name="gbk_chinese_ci">
- <Charset>gbk</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="44" parent="1" name="gbk_bin">
- <Charset>gbk</Charset>
- </collation>
- <collation id="45" parent="1" name="geostd8_general_ci">
- <Charset>geostd8</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="46" parent="1" name="geostd8_bin">
- <Charset>geostd8</Charset>
- </collation>
- <collation id="47" parent="1" name="greek_general_ci">
- <Charset>greek</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="48" parent="1" name="greek_bin">
- <Charset>greek</Charset>
- </collation>
- <collation id="49" parent="1" name="hebrew_general_ci">
- <Charset>hebrew</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="50" parent="1" name="hebrew_bin">
- <Charset>hebrew</Charset>
- </collation>
- <collation id="51" parent="1" name="hp8_english_ci">
- <Charset>hp8</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="52" parent="1" name="hp8_bin">
- <Charset>hp8</Charset>
- </collation>
- <collation id="53" parent="1" name="keybcs2_general_ci">
- <Charset>keybcs2</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="54" parent="1" name="keybcs2_bin">
- <Charset>keybcs2</Charset>
- </collation>
- <collation id="55" parent="1" name="koi8r_general_ci">
- <Charset>koi8r</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="56" parent="1" name="koi8r_bin">
- <Charset>koi8r</Charset>
- </collation>
- <collation id="57" parent="1" name="koi8u_general_ci">
- <Charset>koi8u</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="58" parent="1" name="koi8u_bin">
- <Charset>koi8u</Charset>
- </collation>
- <collation id="59" parent="1" name="latin1_german1_ci">
- <Charset>latin1</Charset>
- </collation>
- <collation id="60" parent="1" name="latin1_swedish_ci">
- <Charset>latin1</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="61" parent="1" name="latin1_danish_ci">
- <Charset>latin1</Charset>
- </collation>
- <collation id="62" parent="1" name="latin1_german2_ci">
- <Charset>latin1</Charset>
- </collation>
- <collation id="63" parent="1" name="latin1_bin">
- <Charset>latin1</Charset>
- </collation>
- <collation id="64" parent="1" name="latin1_general_ci">
- <Charset>latin1</Charset>
- </collation>
- <collation id="65" parent="1" name="latin1_general_cs">
- <Charset>latin1</Charset>
- </collation>
- <collation id="66" parent="1" name="latin1_spanish_ci">
- <Charset>latin1</Charset>
- </collation>
- <collation id="67" parent="1" name="latin2_czech_cs">
- <Charset>latin2</Charset>
- </collation>
- <collation id="68" parent="1" name="latin2_general_ci">
- <Charset>latin2</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="69" parent="1" name="latin2_hungarian_ci">
- <Charset>latin2</Charset>
- </collation>
- <collation id="70" parent="1" name="latin2_croatian_ci">
- <Charset>latin2</Charset>
- </collation>
- <collation id="71" parent="1" name="latin2_bin">
- <Charset>latin2</Charset>
- </collation>
- <collation id="72" parent="1" name="latin5_turkish_ci">
- <Charset>latin5</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="73" parent="1" name="latin5_bin">
- <Charset>latin5</Charset>
- </collation>
- <collation id="74" parent="1" name="latin7_estonian_cs">
- <Charset>latin7</Charset>
- </collation>
- <collation id="75" parent="1" name="latin7_general_ci">
- <Charset>latin7</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="76" parent="1" name="latin7_general_cs">
- <Charset>latin7</Charset>
- </collation>
- <collation id="77" parent="1" name="latin7_bin">
- <Charset>latin7</Charset>
- </collation>
- <collation id="78" parent="1" name="macce_general_ci">
- <Charset>macce</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="79" parent="1" name="macce_bin">
- <Charset>macce</Charset>
- </collation>
- <collation id="80" parent="1" name="macroman_general_ci">
- <Charset>macroman</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="81" parent="1" name="macroman_bin">
- <Charset>macroman</Charset>
- </collation>
- <collation id="82" parent="1" name="sjis_japanese_ci">
- <Charset>sjis</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="83" parent="1" name="sjis_bin">
- <Charset>sjis</Charset>
- </collation>
- <collation id="84" parent="1" name="swe7_swedish_ci">
- <Charset>swe7</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="85" parent="1" name="swe7_bin">
- <Charset>swe7</Charset>
- </collation>
- <collation id="86" parent="1" name="tis620_thai_ci">
- <Charset>tis620</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="87" parent="1" name="tis620_bin">
- <Charset>tis620</Charset>
- </collation>
- <collation id="88" parent="1" name="ucs2_general_ci">
- <Charset>ucs2</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="89" parent="1" name="ucs2_bin">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="90" parent="1" name="ucs2_unicode_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="91" parent="1" name="ucs2_icelandic_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="92" parent="1" name="ucs2_latvian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="93" parent="1" name="ucs2_romanian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="94" parent="1" name="ucs2_slovenian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="95" parent="1" name="ucs2_polish_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="96" parent="1" name="ucs2_estonian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="97" parent="1" name="ucs2_spanish_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="98" parent="1" name="ucs2_swedish_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="99" parent="1" name="ucs2_turkish_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="100" parent="1" name="ucs2_czech_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="101" parent="1" name="ucs2_danish_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="102" parent="1" name="ucs2_lithuanian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="103" parent="1" name="ucs2_slovak_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="104" parent="1" name="ucs2_spanish2_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="105" parent="1" name="ucs2_roman_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="106" parent="1" name="ucs2_persian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="107" parent="1" name="ucs2_esperanto_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="108" parent="1" name="ucs2_hungarian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="109" parent="1" name="ucs2_sinhala_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="110" parent="1" name="ucs2_german2_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="111" parent="1" name="ucs2_croatian_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="112" parent="1" name="ucs2_unicode_520_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="113" parent="1" name="ucs2_vietnamese_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="114" parent="1" name="ucs2_general_mysql500_ci">
- <Charset>ucs2</Charset>
- </collation>
- <collation id="115" parent="1" name="ujis_japanese_ci">
- <Charset>ujis</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="116" parent="1" name="ujis_bin">
- <Charset>ujis</Charset>
- </collation>
- <collation id="117" parent="1" name="utf16_general_ci">
- <Charset>utf16</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="118" parent="1" name="utf16_bin">
- <Charset>utf16</Charset>
- </collation>
- <collation id="119" parent="1" name="utf16_unicode_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="120" parent="1" name="utf16_icelandic_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="121" parent="1" name="utf16_latvian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="122" parent="1" name="utf16_romanian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="123" parent="1" name="utf16_slovenian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="124" parent="1" name="utf16_polish_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="125" parent="1" name="utf16_estonian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="126" parent="1" name="utf16_spanish_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="127" parent="1" name="utf16_swedish_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="128" parent="1" name="utf16_turkish_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="129" parent="1" name="utf16_czech_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="130" parent="1" name="utf16_danish_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="131" parent="1" name="utf16_lithuanian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="132" parent="1" name="utf16_slovak_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="133" parent="1" name="utf16_spanish2_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="134" parent="1" name="utf16_roman_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="135" parent="1" name="utf16_persian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="136" parent="1" name="utf16_esperanto_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="137" parent="1" name="utf16_hungarian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="138" parent="1" name="utf16_sinhala_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="139" parent="1" name="utf16_german2_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="140" parent="1" name="utf16_croatian_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="141" parent="1" name="utf16_unicode_520_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="142" parent="1" name="utf16_vietnamese_ci">
- <Charset>utf16</Charset>
- </collation>
- <collation id="143" parent="1" name="utf16le_general_ci">
- <Charset>utf16le</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="144" parent="1" name="utf16le_bin">
- <Charset>utf16le</Charset>
- </collation>
- <collation id="145" parent="1" name="utf32_general_ci">
- <Charset>utf32</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="146" parent="1" name="utf32_bin">
- <Charset>utf32</Charset>
- </collation>
- <collation id="147" parent="1" name="utf32_unicode_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="148" parent="1" name="utf32_icelandic_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="149" parent="1" name="utf32_latvian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="150" parent="1" name="utf32_romanian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="151" parent="1" name="utf32_slovenian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="152" parent="1" name="utf32_polish_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="153" parent="1" name="utf32_estonian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="154" parent="1" name="utf32_spanish_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="155" parent="1" name="utf32_swedish_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="156" parent="1" name="utf32_turkish_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="157" parent="1" name="utf32_czech_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="158" parent="1" name="utf32_danish_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="159" parent="1" name="utf32_lithuanian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="160" parent="1" name="utf32_slovak_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="161" parent="1" name="utf32_spanish2_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="162" parent="1" name="utf32_roman_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="163" parent="1" name="utf32_persian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="164" parent="1" name="utf32_esperanto_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="165" parent="1" name="utf32_hungarian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="166" parent="1" name="utf32_sinhala_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="167" parent="1" name="utf32_german2_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="168" parent="1" name="utf32_croatian_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="169" parent="1" name="utf32_unicode_520_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="170" parent="1" name="utf32_vietnamese_ci">
- <Charset>utf32</Charset>
- </collation>
- <collation id="171" parent="1" name="utf8mb3_general_ci">
- <Charset>utf8mb3</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="172" parent="1" name="utf8mb3_tolower_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="173" parent="1" name="utf8mb3_bin">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="174" parent="1" name="utf8mb3_unicode_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="175" parent="1" name="utf8mb3_icelandic_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="176" parent="1" name="utf8mb3_latvian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="177" parent="1" name="utf8mb3_romanian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="178" parent="1" name="utf8mb3_slovenian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="179" parent="1" name="utf8mb3_polish_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="180" parent="1" name="utf8mb3_estonian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="181" parent="1" name="utf8mb3_spanish_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="182" parent="1" name="utf8mb3_swedish_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="183" parent="1" name="utf8mb3_turkish_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="184" parent="1" name="utf8mb3_czech_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="185" parent="1" name="utf8mb3_danish_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="186" parent="1" name="utf8mb3_lithuanian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="187" parent="1" name="utf8mb3_slovak_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="188" parent="1" name="utf8mb3_spanish2_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="189" parent="1" name="utf8mb3_roman_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="190" parent="1" name="utf8mb3_persian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="191" parent="1" name="utf8mb3_esperanto_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="192" parent="1" name="utf8mb3_hungarian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="193" parent="1" name="utf8mb3_sinhala_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="194" parent="1" name="utf8mb3_german2_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="195" parent="1" name="utf8mb3_croatian_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="196" parent="1" name="utf8mb3_unicode_520_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="197" parent="1" name="utf8mb3_vietnamese_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="198" parent="1" name="utf8mb3_general_mysql500_ci">
- <Charset>utf8mb3</Charset>
- </collation>
- <collation id="199" parent="1" name="utf8mb4_general_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="200" parent="1" name="utf8mb4_bin">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="201" parent="1" name="utf8mb4_unicode_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="202" parent="1" name="utf8mb4_icelandic_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="203" parent="1" name="utf8mb4_latvian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="204" parent="1" name="utf8mb4_romanian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="205" parent="1" name="utf8mb4_slovenian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="206" parent="1" name="utf8mb4_polish_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="207" parent="1" name="utf8mb4_estonian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="208" parent="1" name="utf8mb4_spanish_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="209" parent="1" name="utf8mb4_swedish_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="210" parent="1" name="utf8mb4_turkish_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="211" parent="1" name="utf8mb4_czech_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="212" parent="1" name="utf8mb4_danish_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="213" parent="1" name="utf8mb4_lithuanian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="214" parent="1" name="utf8mb4_slovak_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="215" parent="1" name="utf8mb4_spanish2_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="216" parent="1" name="utf8mb4_roman_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="217" parent="1" name="utf8mb4_persian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="218" parent="1" name="utf8mb4_esperanto_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="219" parent="1" name="utf8mb4_hungarian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="220" parent="1" name="utf8mb4_sinhala_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="221" parent="1" name="utf8mb4_german2_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="222" parent="1" name="utf8mb4_croatian_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="223" parent="1" name="utf8mb4_unicode_520_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="224" parent="1" name="utf8mb4_vietnamese_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="225" parent="1" name="utf8mb4_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- <DefaultForCharset>1</DefaultForCharset>
- </collation>
- <collation id="226" parent="1" name="utf8mb4_de_pb_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="227" parent="1" name="utf8mb4_is_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="228" parent="1" name="utf8mb4_lv_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="229" parent="1" name="utf8mb4_ro_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="230" parent="1" name="utf8mb4_sl_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="231" parent="1" name="utf8mb4_pl_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="232" parent="1" name="utf8mb4_et_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="233" parent="1" name="utf8mb4_es_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="234" parent="1" name="utf8mb4_sv_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="235" parent="1" name="utf8mb4_tr_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="236" parent="1" name="utf8mb4_cs_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="237" parent="1" name="utf8mb4_da_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="238" parent="1" name="utf8mb4_lt_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="239" parent="1" name="utf8mb4_sk_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="240" parent="1" name="utf8mb4_es_trad_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="241" parent="1" name="utf8mb4_la_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="242" parent="1" name="utf8mb4_eo_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="243" parent="1" name="utf8mb4_hu_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="244" parent="1" name="utf8mb4_hr_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="245" parent="1" name="utf8mb4_vi_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="246" parent="1" name="utf8mb4_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="247" parent="1" name="utf8mb4_de_pb_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="248" parent="1" name="utf8mb4_is_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="249" parent="1" name="utf8mb4_lv_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="250" parent="1" name="utf8mb4_ro_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="251" parent="1" name="utf8mb4_sl_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="252" parent="1" name="utf8mb4_pl_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="253" parent="1" name="utf8mb4_et_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="254" parent="1" name="utf8mb4_es_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="255" parent="1" name="utf8mb4_sv_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="256" parent="1" name="utf8mb4_tr_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="257" parent="1" name="utf8mb4_cs_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="258" parent="1" name="utf8mb4_da_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="259" parent="1" name="utf8mb4_lt_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="260" parent="1" name="utf8mb4_sk_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="261" parent="1" name="utf8mb4_es_trad_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="262" parent="1" name="utf8mb4_la_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="263" parent="1" name="utf8mb4_eo_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="264" parent="1" name="utf8mb4_hu_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="265" parent="1" name="utf8mb4_hr_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="266" parent="1" name="utf8mb4_vi_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="267" parent="1" name="utf8mb4_ja_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="268" parent="1" name="utf8mb4_ja_0900_as_cs_ks">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="269" parent="1" name="utf8mb4_0900_as_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="270" parent="1" name="utf8mb4_ru_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="271" parent="1" name="utf8mb4_ru_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="272" parent="1" name="utf8mb4_zh_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="273" parent="1" name="utf8mb4_0900_bin">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="274" parent="1" name="utf8mb4_nb_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="275" parent="1" name="utf8mb4_nb_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="276" parent="1" name="utf8mb4_nn_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="277" parent="1" name="utf8mb4_nn_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="278" parent="1" name="utf8mb4_sr_latn_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="279" parent="1" name="utf8mb4_sr_latn_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="280" parent="1" name="utf8mb4_bs_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="281" parent="1" name="utf8mb4_bs_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="282" parent="1" name="utf8mb4_bg_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="283" parent="1" name="utf8mb4_bg_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="284" parent="1" name="utf8mb4_gl_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="285" parent="1" name="utf8mb4_gl_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="286" parent="1" name="utf8mb4_mn_cyrl_0900_ai_ci">
- <Charset>utf8mb4</Charset>
- </collation>
- <collation id="287" parent="1" name="utf8mb4_mn_cyrl_0900_as_cs">
- <Charset>utf8mb4</Charset>
- </collation>
- <schema id="288" parent="1" name="mysql">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="289" parent="1" name="information_schema">
- <CollationName>utf8mb3_general_ci</CollationName>
- </schema>
- <schema id="290" parent="1" name="performance_schema">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="291" parent="1" name="sys">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="292" parent="1" name="zhihui">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="293" parent="1" name="scp">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="294" parent="1" name="sp">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="295" parent="1" name="english_app">
- <CollationName>utf8mb4_0900_ai_ci</CollationName>
- </schema>
- <schema id="296" parent="1" name="ptproject">
- <Current>1</Current>
- <LastIntrospectionLocalTimestamp>2025-05-26.04:11:46</LastIntrospectionLocalTimestamp>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </schema>
- <user id="297" parent="1" name="mysql.infoschema">
- <CanLogin>0</CanLogin>
- <Host>localhost</Host>
- <Plugin>caching_sha2_password</Plugin>
- </user>
- <user id="298" parent="1" name="mysql.session">
- <CanLogin>0</CanLogin>
- <Host>localhost</Host>
- <Plugin>caching_sha2_password</Plugin>
- </user>
- <user id="299" parent="1" name="mysql.sys">
- <CanLogin>0</CanLogin>
- <Host>localhost</Host>
- <Plugin>caching_sha2_password</Plugin>
- </user>
- <user id="300" parent="1" name="root">
- <Host>localhost</Host>
- <Plugin>caching_sha2_password</Plugin>
- </user>
- <table id="301" parent="296" name="collections">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="302" parent="296" name="comment_likes">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="303" parent="296" name="comments">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="304" parent="296" name="downloads">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="305" parent="296" name="dynamic_comment">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="306" parent="296" name="dynamic_likes">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="307" parent="296" name="experience_history">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="308" parent="296" name="follow">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="309" parent="296" name="friend_relation">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="310" parent="296" name="group_comments">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="311" parent="296" name="group_interests">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="312" parent="296" name="group_members">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="313" parent="296" name="group_post">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="314" parent="296" name="level">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="315" parent="296" name="likes">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="316" parent="296" name="post">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="317" parent="296" name="promotions">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="318" parent="296" name="seed_comment_likes">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="319" parent="296" name="seed_comments">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="320" parent="296" name="seedcommentlike">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="321" parent="296" name="seeds">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="322" parent="296" name="tasks">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="323" parent="296" name="torrents">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="324" parent="296" name="user">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="325" parent="296" name="user_dynamic">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="326" parent="296" name="user_invite_code">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="327" parent="296" name="user_messages">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <table id="328" parent="296" name="user_task_status">
- <Engine>InnoDB</Engine>
- <CollationName>utf8mb4_unicode_ci</CollationName>
- </table>
- <column id="329" parent="301" name="collectionId">
- <AutoIncrement>1</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="330" parent="301" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="331" parent="301" name="postNo">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <foreign-key id="332" parent="301" name="collections_ibfk_1">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <OnUpdate>cascade</OnUpdate>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="333" parent="301" name="collections_ibfk_2">
- <ColNames>postNo</ColNames>
- <OnDelete>cascade</OnDelete>
- <OnUpdate>cascade</OnUpdate>
- <RefColNames>postNo</RefColNames>
- <RefTableName>post</RefTableName>
- </foreign-key>
- <index id="334" parent="301" name="PRIMARY">
- <ColNames>collectionId</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="335" parent="301" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="336" parent="301" name="postNo">
- <ColNames>postNo</ColNames>
- <Type>btree</Type>
- </index>
- <key id="337" parent="301" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="338" parent="302" name="comment_id">
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="339" parent="302" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="340" parent="302" name="is_liked">
- <Position>3</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <foreign-key id="341" parent="302" name="FK_Relationship_10">
- <ColNames>comment_id</ColNames>
- <RefColNames>comment_id</RefColNames>
- <RefTableName>comments</RefTableName>
- </foreign-key>
- <foreign-key id="342" parent="302" name="FK_Relationship_11">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="343" parent="302" name="PRIMARY">
- <ColNames>comment_id
-user_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="344" parent="302" name="FK_Relationship_11">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="345" parent="302" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="346" parent="303" name="comment_id">
- <AutoIncrement>15</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="347" parent="303" name="post_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="348" parent="303" name="com_comment_id">
- <Position>3</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="349" parent="303" name="user_id">
- <Position>4</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="350" parent="303" name="content">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="351" parent="303" name="is_anonymous">
- <Position>6</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <column id="352" parent="303" name="likes_count">
- <Position>7</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="353" parent="303" name="reply_count">
- <Position>8</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="354" parent="303" name="comment_time">
- <NotNull>1</NotNull>
- <Position>9</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="355" parent="303" name="fk_post_id">
- <ColNames>post_id</ColNames>
- <RefColNames>postNo</RefColNames>
- <RefTableName>post</RefTableName>
- </foreign-key>
- <foreign-key id="356" parent="303" name="FK_Relationship_6">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="357" parent="303" name="PRIMARY">
- <ColNames>comment_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="358" parent="303" name="fk_post_id">
- <ColNames>post_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="359" parent="303" name="FK_Relationship_9">
- <ColNames>com_comment_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="360" parent="303" name="fk_user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="361" parent="303" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="362" parent="304" name="download_id">
- <AutoIncrement>3</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="363" parent="304" name="torrent_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="364" parent="304" name="user_id">
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="365" parent="304" name="download_time">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="366" parent="304" name="download_size">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <foreign-key id="367" parent="304" name="FK_Relationship_5">
- <ColNames>torrent_id</ColNames>
- <RefColNames>torrent_id</RefColNames>
- <RefTableName>torrents</RefTableName>
- </foreign-key>
- <foreign-key id="368" parent="304" name="FK_Relationship_4">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="369" parent="304" name="PRIMARY">
- <ColNames>download_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="370" parent="304" name="FK_Relationship_5">
- <ColNames>torrent_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="371" parent="304" name="FK_Relationship_4">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="372" parent="304" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="373" parent="305" name="comment_id">
- <AutoIncrement>3</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="374" parent="305" name="dynamic_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="375" parent="305" name="user_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="376" parent="305" name="comment_content">
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="377" parent="305" name="comment_time">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="378" parent="305" name="is_anonymous">
- <DefaultExpression>0</DefaultExpression>
- <Position>6</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <column id="379" parent="305" name="parent_comment_id">
- <Position>7</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <foreign-key id="380" parent="305" name="dynamic_comment_ibfk_1">
- <ColNames>dynamic_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>dynamic_id</RefColNames>
- <RefTableName>user_dynamic</RefTableName>
- </foreign-key>
- <foreign-key id="381" parent="305" name="dynamic_comment_ibfk_2">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="382" parent="305" name="dynamic_comment_ibfk_3">
- <ColNames>parent_comment_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>comment_id</RefColNames>
- <RefTableName>dynamic_comment</RefTableName>
- </foreign-key>
- <index id="383" parent="305" name="PRIMARY">
- <ColNames>comment_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="384" parent="305" name="dynamic_id">
- <ColNames>dynamic_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="385" parent="305" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="386" parent="305" name="parent_comment_id">
- <ColNames>parent_comment_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="387" parent="305" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="388" parent="306" name="like_id">
- <AutoIncrement>3</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="389" parent="306" name="dynamic_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="390" parent="306" name="user_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="391" parent="306" name="like_time">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="392" parent="306" name="dynamic_likes_ibfk_1">
- <ColNames>dynamic_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>dynamic_id</RefColNames>
- <RefTableName>user_dynamic</RefTableName>
- </foreign-key>
- <foreign-key id="393" parent="306" name="dynamic_likes_ibfk_2">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="394" parent="306" name="PRIMARY">
- <ColNames>like_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="395" parent="306" name="dynamic_id">
- <ColNames>dynamic_id
-user_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="396" parent="306" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="397" parent="306" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <key id="398" parent="306" name="dynamic_id">
- <UnderlyingIndexName>dynamic_id</UnderlyingIndexName>
- </key>
- <column id="399" parent="307" name="history_id">
- <AutoIncrement>1</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="400" parent="307" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="401" parent="307" name="experience_change">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="402" parent="307" name="source">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="403" parent="307" name="update_time">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="404" parent="307" name="experience_history_ibfk_1">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="405" parent="307" name="PRIMARY">
- <ColNames>history_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="406" parent="307" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="407" parent="307" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="408" parent="308" name="record_id">
- <AutoIncrement>5</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="409" parent="308" name="follower_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="410" parent="308" name="followed_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="411" parent="308" name="follow_time">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="412" parent="308" name="follow_ibfk_1">
- <ColNames>follower_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="413" parent="308" name="follow_ibfk_2">
- <ColNames>followed_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="414" parent="308" name="PRIMARY">
- <ColNames>record_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="415" parent="308" name="follower_id">
- <ColNames>follower_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="416" parent="308" name="followed_id">
- <ColNames>followed_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="417" parent="308" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="418" parent="309" name="relation_id">
- <AutoIncrement>2</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="419" parent="309" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="420" parent="309" name="friend_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="421" parent="309" name="create_time">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="422" parent="309" name="friend_relation_ibfk_1">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="423" parent="309" name="friend_relation_ibfk_2">
- <ColNames>friend_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="424" parent="309" name="PRIMARY">
- <ColNames>relation_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="425" parent="309" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="426" parent="309" name="friend_id">
- <ColNames>friend_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="427" parent="309" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="428" parent="310" name="comment_id">
- <AutoIncrement>5</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="429" parent="310" name="group_post_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="430" parent="310" name="user_id">
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="431" parent="310" name="content">
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="432" parent="310" name="parent_comment_id">
- <Position>5</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="433" parent="310" name="time">
- <NotNull>1</NotNull>
- <Position>6</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="434" parent="310" name="group_comments_ibfk_1">
- <ColNames>group_post_id</ColNames>
- <RefColNames>group_post_id</RefColNames>
- <RefTableName>group_post</RefTableName>
- </foreign-key>
- <foreign-key id="435" parent="310" name="group_comments_ibfk_2">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="436" parent="310" name="group_comments_ibfk_3">
- <ColNames>parent_comment_id</ColNames>
- <RefColNames>comment_id</RefColNames>
- <RefTableName>group_comments</RefTableName>
- </foreign-key>
- <index id="437" parent="310" name="PRIMARY">
- <ColNames>comment_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="438" parent="310" name="group_post_id">
- <ColNames>group_post_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="439" parent="310" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="440" parent="310" name="parent_comment_id">
- <ColNames>parent_comment_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="441" parent="310" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="442" parent="311" name="group_id">
- <AutoIncrement>4</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="443" parent="311" name="group_name">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="444" parent="311" name="description">
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="445" parent="311" name="create_time">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="446" parent="311" name="user_id">
- <Position>5</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="447" parent="311" name="member_count">
- <DefaultExpression>0</DefaultExpression>
- <Position>6</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="448" parent="311" name="category">
- <Position>7</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="449" parent="311" name="cover_image">
- <Position>8</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <foreign-key id="450" parent="311" name="group_interests_ibfk_1">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="451" parent="311" name="PRIMARY">
- <ColNames>group_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="452" parent="311" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="453" parent="311" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="454" parent="312" name="relation_id">
- <AutoIncrement>4</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="455" parent="312" name="group_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="456" parent="312" name="user_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <foreign-key id="457" parent="312" name="group_members_ibfk_1">
- <ColNames>group_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>group_id</RefColNames>
- <RefTableName>group_interests</RefTableName>
- </foreign-key>
- <foreign-key id="458" parent="312" name="group_members_ibfk_2">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="459" parent="312" name="PRIMARY">
- <ColNames>relation_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="460" parent="312" name="unique_group_user">
- <ColNames>group_id
-user_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="461" parent="312" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="462" parent="312" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <key id="463" parent="312" name="unique_group_user">
- <UnderlyingIndexName>unique_group_user</UnderlyingIndexName>
- </key>
- <column id="464" parent="313" name="group_post_id">
- <AutoIncrement>5</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="465" parent="313" name="group_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="466" parent="313" name="user_id">
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="467" parent="313" name="content">
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="468" parent="313" name="title">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="469" parent="313" name="image">
- <Position>6</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="470" parent="313" name="like_count">
- <Position>7</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="471" parent="313" name="comment_count">
- <Position>8</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="472" parent="313" name="time">
- <NotNull>1</NotNull>
- <Position>9</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="473" parent="313" name="group_post_ibfk_1">
- <ColNames>group_id</ColNames>
- <RefColNames>group_id</RefColNames>
- <RefTableName>group_interests</RefTableName>
- </foreign-key>
- <foreign-key id="474" parent="313" name="group_post_ibfk_2">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="475" parent="313" name="PRIMARY">
- <ColNames>group_post_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="476" parent="313" name="group_id">
- <ColNames>group_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="477" parent="313" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="478" parent="313" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="479" parent="314" name="level_id">
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="480" parent="314" name="level_name">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="481" parent="314" name="required_experience">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="482" parent="314" name="required_share_ratio">
- <Position>4</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="483" parent="314" name="required_upload_gb">
- <Position>5</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="484" parent="314" name="required_seeding_hours">
- <Position>6</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="485" parent="314" name="permissions">
- <Position>7</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <index id="486" parent="314" name="PRIMARY">
- <ColNames>level_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <key id="487" parent="314" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="488" parent="315" name="likeId">
- <AutoIncrement>3</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="489" parent="315" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="490" parent="315" name="postNo">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <foreign-key id="491" parent="315" name="likes_ibfk_1">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <OnUpdate>cascade</OnUpdate>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="492" parent="315" name="likes_ibfk_2">
- <ColNames>postNo</ColNames>
- <OnDelete>cascade</OnDelete>
- <OnUpdate>cascade</OnUpdate>
- <RefColNames>postNo</RefColNames>
- <RefTableName>post</RefTableName>
- </foreign-key>
- <index id="493" parent="315" name="PRIMARY">
- <ColNames>likeId</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="494" parent="315" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="495" parent="315" name="postNo">
- <ColNames>postNo</ColNames>
- <Type>btree</Type>
- </index>
- <key id="496" parent="315" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="497" parent="316" name="postNo">
- <AutoIncrement>27</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="498" parent="316" name="userId">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="499" parent="316" name="postContent">
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="500" parent="316" name="imageUrl">
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="501" parent="316" name="postTime">
- <Position>5</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="502" parent="316" name="postLikeNum">
- <Position>6</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="503" parent="316" name="postCollectNum">
- <Position>7</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="504" parent="316" name="title">
- <Position>8</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="505" parent="316" name="postType">
- <Position>9</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <foreign-key id="506" parent="316" name="post_ibfk_1">
- <ColNames>userId</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="507" parent="316" name="PRIMARY">
- <ColNames>postNo</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="508" parent="316" name="userId">
- <ColNames>userId</ColNames>
- <Type>btree</Type>
- </index>
- <key id="509" parent="316" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="510" parent="317" name="promo_id">
- <AutoIncrement>3</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="511" parent="317" name="name">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="512" parent="317" name="upload_coeff">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="513" parent="317" name="download_coeff">
- <Position>4</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="514" parent="317" name="time_range">
- <Position>5</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="515" parent="317" name="criteria">
- <Position>6</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="516" parent="317" name="p_start_time">
- <NotNull>1</NotNull>
- <Position>7</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="517" parent="317" name="p_end_time">
- <NotNull>1</NotNull>
- <Position>8</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <index id="518" parent="317" name="PRIMARY">
- <ColNames>promo_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <key id="519" parent="317" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="520" parent="318" name="id">
- <AutoIncrement>1</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="521" parent="318" name="comment_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="522" parent="318" name="user_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="523" parent="318" name="is_liked">
- <DefaultExpression>1</DefaultExpression>
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <foreign-key id="524" parent="318" name="fk_comment">
- <ColNames>comment_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>comment_id</RefColNames>
- <RefTableName>seed_comments</RefTableName>
- </foreign-key>
- <foreign-key id="525" parent="318" name="fk_user">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="526" parent="318" name="PRIMARY">
- <ColNames>id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="527" parent="318" name="fk_comment">
- <ColNames>comment_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="528" parent="318" name="fk_user">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="529" parent="318" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="530" parent="319" name="comment_id">
- <AutoIncrement>1</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="531" parent="319" name="seed_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="532" parent="319" name="com_comment_id">
- <Position>3</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="533" parent="319" name="user_id">
- <Position>4</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="534" parent="319" name="content">
- <Position>5</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="535" parent="319" name="is_anonymous">
- <Position>6</Position>
- <StoredType>tinyint|0s</StoredType>
- </column>
- <column id="536" parent="319" name="likes_count">
- <DefaultExpression>0</DefaultExpression>
- <Position>7</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="537" parent="319" name="reply_count">
- <DefaultExpression>0</DefaultExpression>
- <Position>8</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="538" parent="319" name="comment_time">
- <Position>9</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="539" parent="319" name="seed_comments_ibfk_1">
- <ColNames>seed_id</ColNames>
- <RefColNames>seed_id</RefColNames>
- <RefTableName>seeds</RefTableName>
- </foreign-key>
- <foreign-key id="540" parent="319" name="seed_comments_ibfk_2">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="541" parent="319" name="PRIMARY">
- <ColNames>comment_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="542" parent="319" name="seed_id">
- <ColNames>seed_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="543" parent="319" name="com_comment_id">
- <ColNames>com_comment_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="544" parent="319" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="545" parent="319" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="546" parent="320" name="id">
- <AutoIncrement>1</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="547" parent="320" name="comment_id">
- <Position>2</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="548" parent="320" name="is_liked">
- <Position>3</Position>
- <StoredType>bit(1)|0s</StoredType>
- </column>
- <column id="549" parent="320" name="user_id">
- <Position>4</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <index id="550" parent="320" name="PRIMARY">
- <ColNames>id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <key id="551" parent="320" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="552" parent="321" name="seed_id">
- <AutoIncrement>4</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="553" parent="321" name="torrent_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="554" parent="321" name="user_id">
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="555" parent="321" name="start_time">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="556" parent="321" name="end_time">
- <Position>5</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="557" parent="321" name="duration">
- <Position>6</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <foreign-key id="558" parent="321" name="FK_Relationship_3">
- <ColNames>torrent_id</ColNames>
- <RefColNames>torrent_id</RefColNames>
- <RefTableName>torrents</RefTableName>
- </foreign-key>
- <foreign-key id="559" parent="321" name="FK_Relationship_2">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="560" parent="321" name="PRIMARY">
- <ColNames>seed_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="561" parent="321" name="FK_Relationship_3">
- <ColNames>torrent_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="562" parent="321" name="FK_Relationship_2">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="563" parent="321" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="564" parent="322" name="task_id">
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>varchar(50)|0s</StoredType>
- </column>
- <column id="565" parent="322" name="title">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="566" parent="322" name="description">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="567" parent="322" name="reward_experience">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="568" parent="322" name="reward_points">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <index id="569" parent="322" name="PRIMARY">
- <ColNames>task_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <key id="570" parent="322" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="571" parent="323" name="torrent_id">
- <AutoIncrement>3</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="572" parent="323" name="user_id">
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="573" parent="323" name="title">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="574" parent="323" name="description">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>text|0s</StoredType>
- </column>
- <column id="575" parent="323" name="tags">
- <Position>5</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="576" parent="323" name="category">
- <Position>6</Position>
- <StoredType>varchar(50)|0s</StoredType>
- </column>
- <column id="577" parent="323" name="upload_time">
- <NotNull>1</NotNull>
- <Position>7</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="578" parent="323" name="FK_Relationship_1">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="579" parent="323" name="PRIMARY">
- <ColNames>torrent_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="580" parent="323" name="FK_Relationship_1">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="581" parent="323" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="582" parent="324" name="user_id">
- <AutoIncrement>5</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="583" parent="324" name="username">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="584" parent="324" name="avatar_url">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="585" parent="324" name="email">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="586" parent="324" name="password">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="587" parent="324" name="role">
- <NotNull>1</NotNull>
- <Position>6</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="588" parent="324" name="invite_count">
- <Position>7</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="589" parent="324" name="level">
- <Position>8</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="590" parent="324" name="upload_count">
- <Position>9</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="591" parent="324" name="download_count">
- <Position>10</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="592" parent="324" name="share_rate">
- <Position>11</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="593" parent="324" name="registration_date">
- <NotNull>1</NotNull>
- <Position>12</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="594" parent="324" name="last_login_time">
- <Position>13</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="595" parent="324" name="user_points">
- <Position>14</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="596" parent="324" name="is_promo">
- <Position>15</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <column id="597" parent="324" name="current_experience">
- <DefaultExpression>0</DefaultExpression>
- <NotNull>1</NotNull>
- <Position>16</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="598" parent="324" name="current_seeding_hours">
- <DefaultExpression>0</DefaultExpression>
- <NotNull>1</NotNull>
- <Position>17</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <foreign-key id="599" parent="324" name="fk_user_level">
- <ColNames>level</ColNames>
- <OnDelete>set-null</OnDelete>
- <OnUpdate>cascade</OnUpdate>
- <RefColNames>level_id</RefColNames>
- <RefTableName>level</RefTableName>
- </foreign-key>
- <index id="600" parent="324" name="PRIMARY">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="601" parent="324" name="fk_user_level">
- <ColNames>level</ColNames>
- <Type>btree</Type>
- </index>
- <key id="602" parent="324" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="603" parent="325" name="dynamic_id">
- <AutoIncrement>5</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="604" parent="325" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="605" parent="325" name="title">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="606" parent="325" name="content">
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="607" parent="325" name="image_url">
- <Position>5</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="608" parent="325" name="time">
- <NotNull>1</NotNull>
- <Position>6</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <column id="609" parent="325" name="likes_count">
- <DefaultExpression>0</DefaultExpression>
- <Position>7</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="610" parent="325" name="comments_count">
- <DefaultExpression>0</DefaultExpression>
- <Position>8</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <foreign-key id="611" parent="325" name="user_dynamic_ibfk_1">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="612" parent="325" name="PRIMARY">
- <ColNames>dynamic_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="613" parent="325" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="614" parent="325" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="615" parent="326" name="invite_id">
- <AutoIncrement>2</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="616" parent="326" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="617" parent="326" name="invite_code">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="618" parent="326" name="is_used">
- <DefaultExpression>0</DefaultExpression>
- <Position>4</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <column id="619" parent="326" name="created_at">
- <DefaultExpression>CURRENT_TIMESTAMP</DefaultExpression>
- <Position>5</Position>
- <StoredType>timestamp|0s</StoredType>
- </column>
- <foreign-key id="620" parent="326" name="user_invite_code_ibfk_1">
- <ColNames>user_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="621" parent="326" name="PRIMARY">
- <ColNames>invite_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="622" parent="326" name="invite_code">
- <ColNames>invite_code</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="623" parent="326" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="624" parent="326" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <key id="625" parent="326" name="invite_code">
- <UnderlyingIndexName>invite_code</UnderlyingIndexName>
- </key>
- <column id="626" parent="327" name="message_id">
- <AutoIncrement>1</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="627" parent="327" name="sender_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="628" parent="327" name="receiver_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="629" parent="327" name="content">
- <Position>4</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="630" parent="327" name="time">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>datetime|0s</StoredType>
- </column>
- <foreign-key id="631" parent="327" name="user_messages_ibfk_1">
- <ColNames>sender_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="632" parent="327" name="user_messages_ibfk_2">
- <ColNames>receiver_id</ColNames>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <index id="633" parent="327" name="PRIMARY">
- <ColNames>message_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="634" parent="327" name="sender_id">
- <ColNames>sender_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="635" parent="327" name="receiver_id">
- <ColNames>receiver_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="636" parent="327" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- <column id="637" parent="328" name="status_id">
- <AutoIncrement>2</AutoIncrement>
- <NotNull>1</NotNull>
- <Position>1</Position>
- <StoredType>bigint|0s</StoredType>
- </column>
- <column id="638" parent="328" name="user_id">
- <NotNull>1</NotNull>
- <Position>2</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="639" parent="328" name="task_id">
- <NotNull>1</NotNull>
- <Position>3</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="640" parent="328" name="current_progress">
- <NotNull>1</NotNull>
- <Position>4</Position>
- <StoredType>float|0s</StoredType>
- </column>
- <column id="641" parent="328" name="current_experience">
- <NotNull>1</NotNull>
- <Position>5</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="642" parent="328" name="current_points">
- <NotNull>1</NotNull>
- <Position>6</Position>
- <StoredType>int|0s</StoredType>
- </column>
- <column id="643" parent="328" name="status">
- <NotNull>1</NotNull>
- <Position>7</Position>
- <StoredType>varchar(255)|0s</StoredType>
- </column>
- <column id="644" parent="328" name="is_reward_claimed">
- <DefaultExpression>0</DefaultExpression>
- <Position>8</Position>
- <StoredType>tinyint(1)|0s</StoredType>
- </column>
- <foreign-key id="645" parent="328" name="user_task_status_ibfk_1">
- <ColNames>user_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>user_id</RefColNames>
- <RefTableName>user</RefTableName>
- </foreign-key>
- <foreign-key id="646" parent="328" name="user_task_status_ibfk_2">
- <ColNames>task_id</ColNames>
- <OnDelete>cascade</OnDelete>
- <RefColNames>task_id</RefColNames>
- <RefTableName>tasks</RefTableName>
- </foreign-key>
- <index id="647" parent="328" name="PRIMARY">
- <ColNames>status_id</ColNames>
- <Type>btree</Type>
- <Unique>1</Unique>
- </index>
- <index id="648" parent="328" name="user_id">
- <ColNames>user_id</ColNames>
- <Type>btree</Type>
- </index>
- <index id="649" parent="328" name="task_id">
- <ColNames>task_id</ColNames>
- <Type>btree</Type>
- </index>
- <key id="650" parent="328" name="PRIMARY">
- <NameSurrogate>1</NameSurrogate>
- <Primary>1</Primary>
- <UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
- </key>
- </database-model>
-</dataSource>
\ No newline at end of file
diff --git a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/information_schema.FNRwLQ.meta b/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/information_schema.FNRwLQ.meta
deleted file mode 100644
index 1ff3db2..0000000
--- a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/information_schema.FNRwLQ.meta
+++ /dev/null
@@ -1,2 +0,0 @@
-#n:information_schema
-!<md> [null, 0, null, null, -2147483648, -2147483648]
diff --git a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/mysql.osA4Bg.meta b/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/mysql.osA4Bg.meta
deleted file mode 100644
index 86a53f1..0000000
--- a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/mysql.osA4Bg.meta
+++ /dev/null
@@ -1,2 +0,0 @@
-#n:mysql
-!<md> [null, 0, null, null, -2147483648, -2147483648]
diff --git a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/performance_schema.kIw0nw.meta b/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/performance_schema.kIw0nw.meta
deleted file mode 100644
index 9394db1..0000000
--- a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/performance_schema.kIw0nw.meta
+++ /dev/null
@@ -1,2 +0,0 @@
-#n:performance_schema
-!<md> [null, 0, null, null, -2147483648, -2147483648]
diff --git a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/ptproject.lTCJ3Q.meta b/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/ptproject.lTCJ3Q.meta
deleted file mode 100644
index 9f5c3fe..0000000
--- a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/ptproject.lTCJ3Q.meta
+++ /dev/null
@@ -1,2 +0,0 @@
-#n:ptproject
-!<md> [0, 0, null, null, -2147483648, -2147483648]
diff --git a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/sys.zb4BAA.meta b/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/sys.zb4BAA.meta
deleted file mode 100644
index 2f4470b..0000000
--- a/.idea/dataSources/6689f15a-5cd0-40b0-970c-713db3e7bac2/storage_v2/_src_/schema/sys.zb4BAA.meta
+++ /dev/null
@@ -1,2 +0,0 @@
-#n:sys
-!<md> [null, 0, null, null, -2147483648, -2147483648]
diff --git a/.idea/misc.xml b/.idea/misc.xml
index f58e1e2..82dbec8 100644
--- a/.idea/misc.xml
+++ b/.idea/misc.xml
@@ -8,10 +8,6 @@
</list>
</option>
</component>
- <component name="PWA">
- <option name="enabled" value="true" />
- <option name="wasEnabledAtLeastOnce" value="true" />
- </component>
<component name="ProjectRootManager" version="2" languageLevel="JDK_17" default="true" project-jdk-name="17" project-jdk-type="JavaSDK">
<output url="file://$PROJECT_DIR$/out" />
</component>
diff --git a/.idea/modules.xml b/.idea/modules.xml
deleted file mode 100644
index 2c23bf9..0000000
--- a/.idea/modules.xml
+++ /dev/null
@@ -1,8 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<project version="4">
- <component name="ProjectModuleManager">
- <modules>
- <module fileurl="file://$PROJECT_DIR$/echo-backend.iml" filepath="$PROJECT_DIR$/echo-backend.iml" />
- </modules>
- </component>
-</project>
\ No newline at end of file
diff --git a/.idea/sqlDataSources.xml b/.idea/sqlDataSources.xml
deleted file mode 100644
index 6e61ff0..0000000
--- a/.idea/sqlDataSources.xml
+++ /dev/null
@@ -1,11 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<project version="4">
- <component name="DdlMappings">
- <mapping uuid="5ed5163f-eda8-4f8e-8280-68ea7ccf1937" name="ptProject@localhost Mapping">
- <data-sources db="6689f15a-5cd0-40b0-970c-713db3e7bac2" ddl="9c2f634f-ddb0-4dcb-bced-271506c9e649" />
- <scope>
- <node kind="database" qname="@" />
- </scope>
- </mapping>
- </component>
-</project>
\ No newline at end of file
diff --git a/.idea/vcs.xml b/.idea/vcs.xml
index 9f66a54..94a25f7 100644
--- a/.idea/vcs.xml
+++ b/.idea/vcs.xml
@@ -2,6 +2,5 @@
<project version="4">
<component name="VcsDirectoryMappings">
<mapping directory="$PROJECT_DIR$" vcs="Git" />
- <mapping directory="$PROJECT_DIR$/ttorrent" vcs="Git" />
</component>
</project>
\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 5c215cb..ae3ef3f 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -5,44 +5,38 @@
</component>
<component name="ChangeListManager">
<list default="true" id="f008fe30-0711-42e2-bb33-17dcfdbad387" name="Changes" comment="">
- <change afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/UserInviteCode.java" afterDir="false" />
- <change afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/repository/UserInviteCodeRepository.java" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/.idea/misc.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/misc.xml" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/.idea/vcs.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/vcs.xml" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/.idea/dbnavigator.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/dbnavigator.xml" afterDir="false" />
<change beforePath="$PROJECT_DIR$/.idea/workspace.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/workspace.xml" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/create.sql" beforeDir="false" />
<change beforePath="$PROJECT_DIR$/pom.xml" beforeDir="false" afterPath="$PROJECT_DIR$/pom.xml" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/MyProjectApplication.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/MyProjectApplication.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/common/base/Result.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/common/base/Result.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/config/MyMetaObjectHandler.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/config/MyMetaObjectHandler.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/controller/InviteController.java" beforeDir="false" />
<change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/controller/UserController.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/controller/UserController.java" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/Users.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/Users.java" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/repository/UserRepository.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/repository/UserRepository.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/dto/param/InviteParam.java" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/dto/param/TorrentUploadParam.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/dto/param/TorrentUploadParam.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/EntityBase.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/EntityBase.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/InvitationEntity.java" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/User.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/entity/User.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/mapper/InvitationMapper.java" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/mapper/UserMapper.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/mapper/UserMapper.java" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/InvitationService.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/InvitationService.java" afterDir="false" />
<change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/UserService.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/UserService.java" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/serviceImpl/UserDetailsServiceImpl.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/serviceImpl/UserDetailsServiceImpl.java" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/serviceImpl/UserServiceImpl.java" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/serviceImpl/InvitationServiceImpl.java" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/serviceImpl/TorrentServiceImpl.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/com/example/myproject/service/serviceImpl/TorrentServiceImpl.java" afterDir="false" />
<change beforePath="$PROJECT_DIR$/src/main/resources/application.properties" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/resources/application.properties" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/main/resources/mapper/PromotionMapper.xml" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/resources/mapper/PromotionMapper.xml" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/src/test/java/com/example/myproject/controller/TorrentControllerTest.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/test/java/com/example/myproject/controller/TorrentControllerTest.java" afterDir="false" />
<change beforePath="$PROJECT_DIR$/src/test/java/com/example/myproject/controller/UserControllerTest.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/test/java/com/example/myproject/controller/UserControllerTest.java" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/application.properties" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/target/classes/application.properties" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/application.properties" afterDir="false" />
<change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/MyProjectApplication.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/MyProjectApplication.class" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController$EmailRequest.class" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController$VerificationRequest.class" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController$EmailRequest.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController$EmailRequest.class" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController$VerificationRequest.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController$VerificationRequest.class" afterDir="false" />
<change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/controller/UserController.class" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/service/UserService.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/service/UserService.class" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/service/serviceImpl/UserDetailsServiceImpl.class" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/service/serviceImpl/UserServiceImpl.class" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/files/files.torrent" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/mapper/FavoriteMapper.xml" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/mapper/PromotionMapper.xml" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/mapper/TorrentMapper.xml" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/mapper/UserMapper.xml" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/mapper/VerificationTokenMapper.xml" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/classes/output/valid.torrent" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/echo-backend-1.0-SNAPSHOT.jar" beforeDir="false" afterPath="$PROJECT_DIR$/target/echo-backend-1.0-SNAPSHOT.jar" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/echo-backend-1.0-SNAPSHOT.jar.original" beforeDir="false" afterPath="$PROJECT_DIR$/target/echo-backend-1.0-SNAPSHOT.jar.original" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/compile/default-compile/createdFiles.lst" beforeDir="false" afterPath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/compile/default-compile/createdFiles.lst" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/compile/default-compile/inputFiles.lst" beforeDir="false" afterPath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/compile/default-compile/inputFiles.lst" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/testCompile/default-testCompile/createdFiles.lst" beforeDir="false" afterPath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/testCompile/default-testCompile/createdFiles.lst" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/testCompile/default-testCompile/inputFiles.lst" beforeDir="false" afterPath="$PROJECT_DIR$/target/maven-status/maven-compiler-plugin/testCompile/default-testCompile/inputFiles.lst" afterDir="false" />
- <change beforePath="$PROJECT_DIR$/target/test-classes/classpath.index" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/test-classes/com/example/myproject/controller/UserControllerTest$1.class" beforeDir="false" />
- <change beforePath="$PROJECT_DIR$/target/test-classes/com/example/myproject/controller/UserControllerTest.class" beforeDir="false" />
+ <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/entity/User.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/entity/User.class" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/mapper/UserMapper.class" beforeDir="false" afterPath="$PROJECT_DIR$/target/classes/com/example/myproject/mapper/UserMapper.class" afterDir="false" />
+ <change beforePath="$PROJECT_DIR$/target/classes/com/example/myproject/utils/Result.class" beforeDir="false" />
</list>
<option name="SHOW_DIALOG" value="false" />
<option name="HIGHLIGHT_CONFLICTS" value="true" />
@@ -58,13 +52,19 @@
</component>
<component name="Git.Settings">
<option name="RECENT_GIT_ROOT_PATH" value="$PROJECT_DIR$" />
- <option name="ROOT_SYNC" value="SYNC" />
</component>
<component name="MarkdownSettingsMigration">
<option name="stateVersion" value="1" />
</component>
+ <component name="MavenImportPreferences">
+ <option name="importingSettings">
+ <MavenImportingSettings>
+ <option name="workspaceImportEnabled" value="true" />
+ </MavenImportingSettings>
+ </option>
+ </component>
<component name="ProblemsViewState">
- <option name="selectedTabId" value="ProjectErrors" />
+ <option name="selectedTabId" value="CurrentFile" />
</component>
<component name="ProjectId" id="2vZNfNTEFyHApdxmHZ7Y0rlJjKB" />
<component name="ProjectLevelVcsManager" settingsEditedManually="true" />
@@ -72,32 +72,19 @@
<option name="hideEmptyMiddlePackages" value="true" />
<option name="showLibraryContents" value="true" />
</component>
- <component name="PropertiesComponent"><![CDATA[{
- "keyToString": {
- "JUnit.UserControllerTest.executor": "Run",
- "RequestMappingsPanelOrder0": "0",
- "RequestMappingsPanelOrder1": "1",
- "RequestMappingsPanelWidth0": "75",
- "RequestMappingsPanelWidth1": "75",
- "RunOnceActivity.OpenProjectViewOnStart": "true",
- "RunOnceActivity.ShowReadmeOnStart": "true",
- "Spring Boot.MyProjectApplication.executor": "Run",
- "git-widget-placeholder": "master",
- "last_opened_file_path": "D:/PT/echo-backend/src/main/java/com/example/myproject/service",
- "node.js.selected.package.tslint": "(autodetect)",
- "应用程序.MyProjectApplication.executor": "Run"
+ <component name="PropertiesComponent">{
+ "keyToString": {
+ "RunOnceActivity.OpenProjectViewOnStart": "true",
+ "RunOnceActivity.ShowReadmeOnStart": "true",
+ "last_opened_file_path": "D:/study/学习资源/大三下/zy1"
}
-}]]></component>
+}</component>
<component name="RecentsManager">
- <key name="CopyFile.RECENT_KEYS">
- <recent name="D:\PT\echo-backend\src\main\java\com\example\myproject\service" />
- <recent name="D:\PT\echo-backend\src\main\java\com\example\myproject\controller" />
- </key>
<key name="MoveFile.RECENT_KEYS">
<recent name="D:\study\学习资源\大三下\school\echo-backend\src\main\resources\mapper" />
</key>
</component>
- <component name="RunManager" selected="JUnit.UserControllerTest">
+ <component name="RunManager" selected="应用程序.MyProjectApplication">
<configuration name="BtClient" type="Application" factoryName="Application" temporary="true" nameIsGenerated="true">
<option name="MAIN_CLASS_NAME" value="com.example.myproject.client.BtClient" />
<module name="echo-backend" />
@@ -165,31 +152,8 @@
<option name="Make" enabled="true" />
</method>
</configuration>
- <configuration name="UserControllerTest" type="JUnit" factoryName="JUnit" temporary="true" nameIsGenerated="true">
- <module name="echo-backend" />
- <extension name="coverage">
- <pattern>
- <option name="PATTERN" value="com.example.myproject.controller.*" />
- <option name="ENABLED" value="true" />
- </pattern>
- </extension>
- <option name="PACKAGE_NAME" value="com.example.myproject.controller" />
- <option name="MAIN_CLASS_NAME" value="com.example.myproject.controller.UserControllerTest" />
- <option name="TEST_OBJECT" value="class" />
- <method v="2">
- <option name="Make" enabled="true" />
- </method>
- </configuration>
- <configuration name="MyProjectApplication" type="SpringBootApplicationConfigurationType" factoryName="Spring Boot" nameIsGenerated="true">
- <module name="echo-backend" />
- <option name="SPRING_BOOT_MAIN_CLASS" value="com.example.myproject.MyProjectApplication" />
- <method v="2">
- <option name="Make" enabled="true" />
- </method>
- </configuration>
<recent_temporary>
<list>
- <item itemvalue="JUnit.UserControllerTest" />
<item itemvalue="应用程序.MyProjectApplication" />
<item itemvalue="JUnit.TorrentControllerTest" />
</list>
@@ -206,15 +170,4 @@
</task>
<servers />
</component>
- <component name="Vcs.Log.Tabs.Properties">
- <option name="TAB_STATES">
- <map>
- <entry key="MAIN">
- <value>
- <State />
- </value>
- </entry>
- </map>
- </option>
- </component>
</project>
\ No newline at end of file