forked from CMU-CREATE-Lab/esdr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathEnvironmental Sensor Data Repository.ids
51 lines (51 loc) · 4.47 KB
/
Environmental Sensor Data Repository.ids
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<?xml version="1.0" encoding="UTF-8"?>
<component name="dataSourceStorage">
<data-source source="LOCAL" name="MySQL - esdr@localhost" uuid="a1a93e08-2069-498b-befe-f2b24560c574">
<database-info product="MySQL" version="5.6.17" jdbc-version="4.0" driver-name="MySQL Connector Java" driver-version="mysql-connector-java-5.1.29 ( Revision: alexander.soklakov@oracle.com-20140120140810-s44574olh90i6i4l )">
<extra-name-characters>#@</extra-name-characters>
<identifier-quote-string>`</identifier-quote-string>
</database-info>
<case-sensitivity plain-identifiers="mixed" quoted-identifiers="upper"/>
<schema name="" catalog="esdr"/>
<schema name="" catalog="esdr_test"/>
<table name="Clients" schema="" catalog="esdr_test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="displayName" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="clientName" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="clientSecret" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="created" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/>
<primary-key name="PRIMARY" columns="id"/>
<exported-key name="refreshtokens_ibfk_2" table="Tokens" schema="" catalog="esdr_test" columns="clientId"/>
<index name="unique_clientName" unique="true" columns="clientName"/>
</table>
<table name="Tokens" schema="" catalog="esdr_test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="userId" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5"/>
<column name="clientId" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5"/>
<column name="accessToken" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="refreshToken" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="created" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/>
<primary-key name="PRIMARY" columns="id"/>
<foreign-key name="refreshtokens_ibfk_1" columns="userId" ref-table="Users" ref-schema="" ref-catalog="esdr_test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/>
<foreign-key name="refreshtokens_ibfk_2" columns="clientId" ref-table="Clients" ref-schema="" ref-catalog="esdr_test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/>
<index name="unique_accessToken" unique="true" columns="accessToken"/>
<index name="unique_refreshToken" unique="true" columns="refreshToken"/>
<index name="userId_clientId_index" unique="true" columns="userId,clientId"/>
</table>
<table name="Users" schema="" catalog="esdr_test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="email" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="password" sqlType="VARCHAR" precision="255" scale="0" nullable="false" jdbcType="12"/>
<column name="displayName" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="created" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA="/>
<column name="modified" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="Q1VSUkVOVF9USU1FU1RBTVA=" version="true"/>
<column name="verificationToken" sqlType="VARCHAR" precision="64" scale="0" nullable="false" jdbcType="12"/>
<column name="isVerified" sqlType="TINYINT" precision="3" scale="0" nullable="true" jdbcType="-6" def="MA=="/>
<column name="verified" sqlType="TIMESTAMP" precision="19" scale="0" nullable="false" jdbcType="93" def="JzAwMDAtMDAtMDAgMDA6MDA6MDAn"/>
<primary-key name="PRIMARY" columns="id"/>
<exported-key name="refreshtokens_ibfk_1" table="Tokens" schema="" catalog="esdr_test" columns="userId"/>
<index name="unique_email" unique="true" columns="email"/>
<index name="unique_verificationToken" unique="true" columns="verificationToken"/>
</table>
</data-source>
</component>