-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdump.sql
More file actions
145 lines (124 loc) · 41.6 KB
/
dump.sql
File metadata and controls
145 lines (124 loc) · 41.6 KB
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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
-- MySQL dump 10.13 Distrib 8.0.19, for osx10.15 (x86_64)
--
-- Host: chemicalequationbalancerdatabase.cz5vjghh05gt.us-west-1.rds.amazonaws.com Database: ChemicalEquationBalancerDatabase
-- ------------------------------------------------------
-- Server version 5.7.26-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;
--
-- GTID state at the beginning of the backup
--
SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '';
--
-- Current Database: `ChemicalEquationBalancerDatabase`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ChemicalEquationBalancerDatabase` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `ChemicalEquationBalancerDatabase`;
--
-- Table structure for table `ChemicalEquationRegions`
--
DROP TABLE IF EXISTS `ChemicalEquationRegions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ChemicalEquationRegions` (
`id` char(36) NOT NULL,
`imageProcessorRequestInfoId` char(36) DEFAULT NULL,
`originX` double DEFAULT NULL,
`originY` double DEFAULT NULL,
`width` double DEFAULT NULL,
`height` double DEFAULT NULL,
`tags` varchar(255) DEFAULT NULL,
`regionClass` varchar(69) DEFAULT NULL,
`parentImageWidth` double DEFAULT '1080',
`parentImageHeight` double DEFAULT '1920',
`viewportWidth` int(11) DEFAULT '450',
`viewportHeight` int(11) DEFAULT '700',
`s3ImageUrl` varchar(255) DEFAULT NULL,
`equationStr` varchar(255) DEFAULT '',
PRIMARY KEY (`id`),
KEY `imageProcessorRequestInfoIndex` (`imageProcessorRequestInfoId`),
CONSTRAINT `ChemicalEquationRegions_ibfk_1` FOREIGN KEY (`imageProcessorRequestInfoId`) REFERENCES `ImageProcessorRequestInfo` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ChemicalEquationRegions`
--
LOCK TABLES `ChemicalEquationRegions` WRITE;
/*!40000 ALTER TABLE `ChemicalEquationRegions` DISABLE KEYS */;
INSERT INTO `ChemicalEquationRegions` VALUES ('017462452016533625','025a7296-155b-4c61-835f-753bf89f20da',137,507,135,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_017462452016533625.png','Ag2SO4(s)=2Ag^+(aq)+SO4^2-(aq)'),('02077097590151966','6c823ca8-1781-46a0-8392-bbcb1ff0710d',88,539,60,11,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_02077097590151966.png','I2(g)=2I(g)'),('02576284775050308','3de765dc-8717-49f9-8e56-70971623ea71',124.44451764705897,447.63567058823594,100.61703529411771,11.468800000000046,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_02576284775050308.png',''),('04364084542862012','656a7625-d729-4d5f-bd4b-bb294ac26ee7',293,303,40,376,'COMPUTER_SCREEN,LOW_LIGHT,DIR_BLUR','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/656a7625-d729-4d5f-bd4b-bb294ac26ee7_04364084542862012.png','C2H4(g)+Cl(2)(g)=C2H4Cl2(g)'),('04928925442499732','6c823ca8-1781-46a0-8392-bbcb1ff0710d',127,208,124,19,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_04928925442499732.png','CO(g)+Cl2(g)=COCl2(g)'),('08378775416744189','07327e3e-0e40-40e4-aa11-e98ac637bc6b',54,149,338,50,'COMPUTER_SCREEN','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/07327e3e-0e40-40e4-aa11-e98ac637bc6b_08378775416744189.png',NULL),('08783079890080092','e1a2b6d3-de4e-45f1-8525-af9bb774d565',299.49238578680206,134.13705583756345,48.73096446700511,324.2385786802031,'HAND_WRITTEN,OBFUSCATED','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e1a2b6d3-de4e-45f1-8525-af9bb774d565_08783079890080092.png','N2+3H2=2NH3'),('10028436683251729','998ac045-fbde-4010-9669-470aeed9a05a',156,247,113,12,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_10028436683251729.png',NULL),('11221235708800847','025a7296-155b-4c61-835f-753bf89f20da',137,181,135,11,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_11221235708800847.png','Fe^3+(aq)+SCN^-(aq)=FeSCN^2+(aq)'),('1389154466479433','025a7296-155b-4c61-835f-753bf89f20da',121,460,100,9,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_1389154466479433.png','2H2S(g)=2H2(g)+S2(g)'),('1442415823579679','e3b26e00-57b3-4c01-b66d-3a708f214fc8',226,99,50,532,'HAND_WRITTEN,DIR_BLUR,OFF_FOCUS','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e3b26e00-57b3-4c01-b66d-3a708f214fc8_1442415823579679.png','(NH4)2CO3+AlCl3=Al2(CO3)2+NH4Cl'),('15386715432883202','37af7995-efff-431b-97e8-19acd4a518b8',127,102,71,8,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_15386715432883202.png',NULL),('16237398495344035','3de765dc-8717-49f9-8e56-70971623ea71',105.16922352941191,386.91849411764775,116.42277647058829,10.45684705882356,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_16237398495344035.png',''),('17077487277193348','998ac045-fbde-4010-9669-470aeed9a05a',127,86,114.00000000000001,8,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_17077487277193348.png',NULL),('18973729224600777','4033281b-9e15-4a17-901c-fd2195eda638',94,286,251.00000000000003,16,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/4033281b-9e15-4a17-901c-fd2195eda638_18973729224600777.png',NULL),('23686903770403445','21a7d051-fdc1-4356-a956-0c3452275bc4',137,294,144,13,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_23686903770403445.png','NiO(s)+CO(g)=Ni(s)+CO2(g)'),('24031895174828144','37af7995-efff-431b-97e8-19acd4a518b8',127,187,100,9,'','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_24031895174828144.png',NULL),('24660113393854521','40488d10-4900-4a04-9bd3-108e12c80c15',93.78784617411766,260.48396864000006,155.61361287529414,14.61098134588239,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/40488d10-4900-4a04-9bd3-108e12c80c15_24660113393854521.png',''),('2595594480506922','6c823ca8-1781-46a0-8392-bbcb1ff0710d',86,559,104,12,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_2595594480506922.png','I2(g)+Cl2(g)=2ICl(g)'),('26105772806618655','3de765dc-8717-49f9-8e56-70971623ea71',105.55472941176481,314.732517647059,122.20536470588243,11.806117647058823,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_26105772806618655.png',''),('2712889227372882','25f6c58a-1927-4d62-a34d-33f79cbb5c55',179.71758664955073,108,57.50962772785623,476.00000000000006,'COMPUTER_SCREEN','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/25f6c58a-1927-4d62-a34d-33f79cbb5c55_2712889227372882.png','CH4+2O2=CO2+2H2O'),('2818088986607524','7ec3e153-434a-490e-805d-547a2f7ee27f',206.09137055837567,107,48.73096446700511,439,'HAND_WRITTEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/7ec3e153-434a-490e-805d-547a2f7ee27f_2818088986607524.png','HSO4+H2O=H^++SO4^2-'),('30648152039066645','44865daf-b63a-42f1-af79-cc85503c4819',190,68,46,492,'HAND_WRITTEN,HAS_COEFFICIENTS','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/44865daf-b63a-42f1-af79-cc85503c4819_30648152039066645.png','3(NH4)2CO3+2AlCl3=Al2(CO3)2+6NH4Cl'),('32371494933607203','9b20a369-d2c3-485a-91a4-4d801d9e3fb5',232,133,42,473,'HAND_WRITTEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/9b20a369-d2c3-485a-91a4-4d801d9e3fb5_32371494933607203.png','NH4Cl+NaOH=NH3+H2O+NaCl'),('337015762576107','4e21c8a3-719f-4829-9617-ebd0f353321f',238.5786802030457,134,43.654822335025386,362,'DIR_BLUR,LOW_RES,LOW_LIGHT,OFF_FOCUS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/4e21c8a3-719f-4829-9617-ebd0f353321f_337015762576107.png','N2(g)+3H2(g)=2NH3(g)'),('3529406827200391','e4a71a94-dbf3-46b4-8fea-1e8a9cb38dad',201,98.00000000000001,47,368,'HAND_WRITTEN','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e4a71a94-dbf3-46b4-8fea-1e8a9cb38dad_3529406827200391.png','Fe2O3+C=FeO+CO2'),('36513874187842155','025a7296-155b-4c61-835f-753bf89f20da',153,234,106,9,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_36513874187842155.png','SO2Cl2(g)=SO2(g)+Cl2(g)'),('37172992932187743','37af7995-efff-431b-97e8-19acd4a518b8',122.00000000000001,152,116,9,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_37172992932187743.png',NULL),('37176886595323577','6c823ca8-1781-46a0-8392-bbcb1ff0710d',116,436,141,16,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_37176886595323577.png','C(s)+H2O(g)=CO(g)+H2(g)'),('38231343461086875','ae0e8887-ab03-48fc-a14d-17c11d639aba',88.34317176470593,183.67626117647075,148.9594729411765,14.841976470588241,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,NULL,''),('38397219956184137','21a7d051-fdc1-4356-a956-0c3452275bc4',100,359.99999999999994,144,11,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_38397219956184137.png','CO(g)+H2O(g)=CO2(g)+H2(g)'),('3840659700950786','317af6a0-b19b-40f4-b73a-2a742ce2350a',359.5332027478136,0.8432835820895102,49.65928214748806,411.00000000000006,'COMPUTER_SCREEN','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/317af6a0-b19b-40f4-b73a-2a742ce2350a_3840659700950786.png','P4O10+H2O=H3PO4'),('4004691706068635','3de765dc-8717-49f9-8e56-70971623ea71',103.2416941176472,512.7379764705889,87.38376470588238,11.806117647058745,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_4004691706068635.png',''),('4093585154899735','3de765dc-8717-49f9-8e56-70971623ea71',94.37505882352954,434.142964705883,111.79670588235301,11.806117647058901,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_4093585154899735.png',''),('4147811001789219','4033281b-9e15-4a17-901c-fd2195eda638',142,364,146,16,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/4033281b-9e15-4a17-901c-fd2195eda638_4147811001789219.png','C(S)+2H2(g)=CH4(g)'),('42853741634201303','37af7995-efff-431b-97e8-19acd4a518b8',149,285,104,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_42853741634201303.png',NULL),('4297473933754956','21a7d051-fdc1-4356-a956-0c3452275bc4',128,465,121,11.462445019011035,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_4297473933754956.png','SO2Cl2(g)=SO2(g)+Cl2(g)'),('4425281834546655','37af7995-efff-431b-97e8-19acd4a518b8',127,68,128,8,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_4425281834546655.png',NULL),('45735398583265696','37af7995-efff-431b-97e8-19acd4a518b8',126.00000000000001,109,94,9,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_45735398583265696.png',NULL),('4643451652906351','37af7995-efff-431b-97e8-19acd4a518b8',157,420,84,14,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_4643451652906351.png',NULL),('49354763129260626','998ac045-fbde-4010-9669-470aeed9a05a',121.03214915040071,95.22621083015753,121.94774858836708,8.95091090632054,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_49354763129260626.png',NULL),('5071024885783084','3de765dc-8717-49f9-8e56-70971623ea71',139.09374117647076,355.885270588236,114.88075294117651,11.131482352941113,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_5071024885783084.png',''),('5126266365223255','3de765dc-8717-49f9-8e56-70971623ea71',106.00327058823545,395.7305882352948,126.76840000000004,11.089647058823493,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_5126266365223255.png',''),('513163532819275','37af7995-efff-431b-97e8-19acd4a518b8',126.00000000000001,86,88,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_513163532819275.png',NULL),('5237218479542755','3de765dc-8717-49f9-8e56-70971623ea71',105.55472941176481,306.2995764705884,118.350305882353,11.468799999999968,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_5237218479542755.png',''),('5252124853102413','21a7d051-fdc1-4356-a956-0c3452275bc4',141,176,97,17,'HAS_COEFFICIENTS,COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_5252124853102413.png','N2O4(g)=2NO2(g)'),('5636408659048584','11457106-c0a5-4971-8118-02321c22f139',228.00000000000003,139,34,359.00000000000006,'HAND_WRITTEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/11457106-c0a5-4971-8118-02321c22f139_5636408659048584.png','NH3+HCl=NH4+Cl^-'),('5960975025316854','21a7d051-fdc1-4356-a956-0c3452275bc4',86,413,208,12.668307224334196,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_5960975025316854.png','HC2H3O2(aq)+H2O(l)=H3O^+(aq)+C2H3O2^-(aq)'),('5988838317155186','998ac045-fbde-4010-9669-470aeed9a05a',126.00000000000001,158,104,9,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_5988838317155186.png',NULL),('6009334484853244','bd4a93ec-74dd-4096-89b0-70a9d8fb52f2',-1,237,35,230,'COMPUTER_SCREEN,DIR_BLUR,LOW_LIGHT','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/bd4a93ec-74dd-4096-89b0-70a9d8fb52f2_6009334484853244.png','H2(g)+I2(g)=2HI(g)'),('6209668902618103','37af7995-efff-431b-97e8-19acd4a518b8',152,329,98,11,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_6209668902618103.png',NULL),('6308127068692728','998ac045-fbde-4010-9669-470aeed9a05a',127,133,101,11,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_6308127068692728.png',NULL),('634119713183098','40488d10-4900-4a04-9bd3-108e12c80c15',91.12238951888959,422.27988391838386,161.29795717650023,16.06027073610846,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/40488d10-4900-4a04-9bd3-108e12c80c15_634119713183098.png',''),('6509102708116336','998ac045-fbde-4010-9669-470aeed9a05a',138,218,85,12,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_6509102708116336.png',NULL),('6549933404652323','3de765dc-8717-49f9-8e56-70971623ea71',124.44451764705897,480.5241411764713,140.32414117647065,13.830023529411717,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_6549933404652323.png',''),('6565994745837624','4033281b-9e15-4a17-901c-fd2195eda638',138,220,150,15,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/4033281b-9e15-4a17-901c-fd2195eda638_6565994745837624.png','C(S)+CO2(g)=2CO(g)'),('661155196252933','37af7995-efff-431b-97e8-19acd4a518b8',118.00000000000001,515,114.00000000000001,13,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_661155196252933.png',NULL),('6630653515493262','40488d10-4900-4a04-9bd3-108e12c80c15',131.724978739181,438.09681721909675,115.41146935904759,15.816933300712776,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/40488d10-4900-4a04-9bd3-108e12c80c15_6630653515493262.png',''),('6823073138286952','3de765dc-8717-49f9-8e56-70971623ea71',106.71124705882363,324.1774117647061,128.37345882352943,11.806117647058784,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_6823073138286952.png',''),('6853896124018091','e1a2b6d3-de4e-45f1-8525-af9bb774d565',231.47208121827413,81.72588832487311,46.7005076142132,517.0050761421321,'HAND_WRITTEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e1a2b6d3-de4e-45f1-8525-af9bb774d565_6853896124018091.png','Fe(NO3)3+KSCN=FeSCNKNO3'),('7012563029051989','998ac045-fbde-4010-9669-470aeed9a05a',127,102,141,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_7012563029051989.png',NULL),('7021884868612641','998ac045-fbde-4010-9669-470aeed9a05a',128,112,109,8,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_7021884868612641.png',NULL),('7040374491556418','40488d10-4900-4a04-9bd3-108e12c80c15',126.44108014201984,328.59497129108445,167.7259387756273,16.30360817150403,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/40488d10-4900-4a04-9bd3-108e12c80c15_7040374491556418.png',''),('7101876014722656','ae0e8887-ab03-48fc-a14d-17c11d639aba',100.98776470588238,275.1568070588238,200.4630588235295,17.270663529411763,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,NULL,''),('7286512610238076','6c823ca8-1781-46a0-8392-bbcb1ff0710d',87,550,117,9,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_7286512610238076.png','2H2S(g)=2H2(g)+S2(g)'),('7353533414265249','37af7995-efff-431b-97e8-19acd4a518b8',150,230,105,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_7353533414265249.png',NULL),('760883342314212','dd527d8a-65a8-436d-8191-f41f592ab79a',219,152,28,414,'HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/dd527d8a-65a8-436d-8191-f41f592ab79a_760883342314212.png','C2H2(g)+2H2(g)=C2H6(g)'),('763762102202322','92a4e829-6c23-45bc-805e-e657766a1a97',132,109,42,414,'','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/92a4e829-6c23-45bc-805e-e657766a1a97_763762102202322.png','OH-(aq)+HCl(aq)=H2O(l)+Cl-(aq)'),('7677976230438502','79e15ccc-3f64-4341-8b60-b4985d00fb3c',274,118,50,337,'','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/79e15ccc-3f64-4341-8b60-b4985d00fb3c_7677976230438502.png','H2SO4(aq)+H2O(l)=HSO4^-(aq)+H3O^+(aq)'),('7729591169910404','e0abbd43-4434-4c0b-94a1-e784bd8222c7',221.99488491048592,298,29.667519181585682,214,'HAS_COEFFICIENTS','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e0abbd43-4434-4c0b-94a1-e784bd8222c7_7729591169910404.png','N2O5=1/2O2+2NO2'),('8015367912323909','ae0e8887-ab03-48fc-a14d-17c11d639aba',106.84745411764709,80.32213411764708,202.9302964705884,16.461101176470578,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,NULL,''),('8076302595035628','bd4a93ec-74dd-4096-89b0-70a9d8fb52f2',236.99999999999997,209.00000000000003,38,262,'COMPUTER_SCREEN,DIR_BLUR,LOW_LIGHT','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/bd4a93ec-74dd-4096-89b0-70a9d8fb52f2_8076302595035628.png','C2H4(g)+I2(g)=C2H4I2(g)'),('8113096628006542','37af7995-efff-431b-97e8-19acd4a518b8',125,142,139,9,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_8113096628006542.png',NULL),('8158539747053363','37af7995-efff-431b-97e8-19acd4a518b8',125,120,94,6,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_8158539747053363.png',NULL),('8469759237445125','998ac045-fbde-4010-9669-470aeed9a05a',160,413,93,9,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a_8469759237445125.png',NULL),('8504508587692189','40488d10-4900-4a04-9bd3-108e12c80c15',136.41184376470594,156.06553694117648,158.64338070588246,13.384764235294142,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/40488d10-4900-4a04-9bd3-108e12c80c15_8504508587692189.png',''),('8515910854885961','025a7296-155b-4c61-835f-753bf89f20da',148,330,118.00000000000001,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_8515910854885961.png','CO(g)+2H2(g)=CH3OH(g)'),('8765986074006121','025a7296-155b-4c61-835f-753bf89f20da',148,398.00000000000006,113,10,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_8765986074006121.png','NH4HS(s)=NH3+H2S(g)'),('8770942924523134','025a7296-155b-4c61-835f-753bf89f20da',158,279,93,8,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_8770942924523134.png','H2(g)+I2(g)=2HI(g)'),('8841742249135772','025a7296-155b-4c61-835f-753bf89f20da',129,70,103,9,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_8841742249135772.png','SO2Cl2(g)=SO2(g)+Cl2(g)'),('9065182142901409','3de765dc-8717-49f9-8e56-70971623ea71',136.00969411764717,273.57976470588255,121.04884705882355,14.504658823529388,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_9065182142901409.png',''),('9076811947470561','025a7296-155b-4c61-835f-753bf89f20da',120,553,85,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da_9076811947470561.png','2NO2(g)=N2O4(g)'),('9170433108358217','3de765dc-8717-49f9-8e56-70971623ea71',93.98955294117661,524.5440941176477,92.90691764705886,12.818070588235386,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_9170433108358217.png',''),('9199908221015943','cdb0bcde-6024-4a7c-8aaa-811bba314132',234.51776649746196,210,40.482233502538044,264,'COMPUTER_SCREEN,DIR_BLUR','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/cdb0bcde-6024-4a7c-8aaa-811bba314132_9199908221015943.png','CO2(g)+C(s)=2CO(g)'),('92493984050045','74a49b49-a914-4d5a-977d-596e6953f8f7',76,179,265,50,'COMPUTER_SCREEN,HAND_WRITTEN,LOW_RES,DIR_BLUR','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/74a49b49-a914-4d5a-977d-596e6953f8f7_92493984050045.png','C3H8+O2=H2O+CO2'),('9286325616869662','252d2745-f582-41fa-9727-587989a6012c',208,101,52,518,'HAND_WRITTEN','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/252d2745-f582-41fa-9727-587989a6012c_9286325616869662.png','Ba(NO3)2+2Na3PO4=Ba3(PO4)2+NaNO3'),('9317414207615431','21a7d051-fdc1-4356-a956-0c3452275bc4',120,563,145,11,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_9317414207615431.png','CO(g)+H2O(g)=CO2(g)+H2(g)'),('933886845186775','6c823ca8-1781-46a0-8392-bbcb1ff0710d',118.00000000000001,355,132,14,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_933886845186775.png','2KClO3(s)=2KCl(s)+3O2(g)'),('9353702133473416','3695c083-f221-408a-9aec-c645be824e87',183,148,72,415,'HAND_WRITTEN,HIGH_LIGHT','CHEM_EQUATION_NO_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3695c083-f221-408a-9aec-c645be824e87_9353702133473416.png','Fe2O3+C=FeO+CO2'),('9491260134699576','21a7d051-fdc1-4356-a956-0c3452275bc4',102,515,109,10,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4_9491260134699576.png','Br(g)+Cl2(g)=2BrCl(g)'),('9625719397845038','37af7995-efff-431b-97e8-19acd4a518b8',122.00000000000001,166,152,9,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_9625719397845038.png',NULL),('9653699709940504','6c823ca8-1781-46a0-8392-bbcb1ff0710d',122.00000000000001,282,135,14,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d_9653699709940504.png','2BrNO(g)=2NO+Br2(g)'),('9684295861916454','3de765dc-8717-49f9-8e56-70971623ea71',105.81051764705896,405.6814588235302,125.41912941176476,11.258305882352882,'COMPUTER_SCREEN','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71_9684295861916454.png',''),('976989683460661','37af7995-efff-431b-97e8-19acd4a518b8',122.00000000000001,159,145,8,'COMPUTER_SCREEN,HAS_COEFFICIENTS','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8_976989683460661.png',NULL),('986599328944511','92a4e829-6c23-45bc-805e-e657766a1a97',196,110,55,413,'','CHEM_EQUATION_EQU',1080,1920,450,700,'https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/92a4e829-6c23-45bc-805e-e657766a1a97_986599328944511.png','Mg(OH)2(s)=Mg^2+(aq)+2OH^-');
/*!40000 ALTER TABLE `ChemicalEquationRegions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ImageProcessorRequestInfo`
--
DROP TABLE IF EXISTS `ImageProcessorRequestInfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ImageProcessorRequestInfo` (
`id` char(36) NOT NULL,
`s3ImageUrl` char(120) DEFAULT NULL,
`gcpRequestStartTimeMs` bigint(20) DEFAULT NULL,
`gcpRequestEndTimeMs` bigint(20) DEFAULT NULL,
`userInputtedChemicalEquationString` varchar(255) DEFAULT NULL,
`verifiedChemicalEquationString` varchar(255) DEFAULT NULL,
`gcpIdentifiedChemicalEquationString` varchar(255) DEFAULT NULL,
`onDeviceImageProcessStartTime` mediumtext,
`onDeviceImageProcessEndTime` mediumtext,
`onDeviceImageProcessDeviceName` varchar(255) DEFAULT NULL,
`labelingStatus` varchar(45) DEFAULT 'INCOMPLETE',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ImageProcessorRequestInfo`
--
LOCK TABLES `ImageProcessorRequestInfo` WRITE;
/*!40000 ALTER TABLE `ImageProcessorRequestInfo` DISABLE KEYS */;
INSERT INTO `ImageProcessorRequestInfo` VALUES ('025a7296-155b-4c61-835f-753bf89f20da','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/025a7296-155b-4c61-835f-753bf89f20da.png',1582606167042,1582606169037,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('07327e3e-0e40-40e4-aa11-e98ac637bc6b','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/07327e3e-0e40-40e4-aa11-e98ac637bc6b.png',1579800486108,1579800494918,'C4H10+O2->CO2+H2O','C4H10+O2->CO2+H2O',NULL,NULL,NULL,NULL,'LABELED'),('0b7c91da-66b7-474a-9cee-c9a3b60e7081','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/0b7c91da-66b7-474a-9cee-c9a3b60e7081.png',1582683697853,1582683698949,'',NULL,NULL,NULL,NULL,NULL,'IN_PROGRESS'),('11457106-c0a5-4971-8118-02321c22f139','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/11457106-c0a5-4971-8118-02321c22f139.png',1582159796394,1582159797630,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('21a7d051-fdc1-4356-a956-0c3452275bc4','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/21a7d051-fdc1-4356-a956-0c3452275bc4.png',1582606132223,1582606134024,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('252d2745-f582-41fa-9727-587989a6012c','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/252d2745-f582-41fa-9727-587989a6012c.png',1580257006392,1580257007748,'Ba(NO3)2+Na3PO4->Ba3(PO4)2+NaNO3','Ba(NO3)2+Na3PO4->Ba3(PO4)2+NaNO3',NULL,NULL,NULL,NULL,'LABELED'),('25f6c58a-1927-4d62-a34d-33f79cbb5c55','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/25f6c58a-1927-4d62-a34d-33f79cbb5c55.png',1579800352441,1579800359467,'CH4+2O2->CO2+2H2O','CH4+2O2->CO2+2H2O',NULL,NULL,NULL,NULL,'LABELED'),('317af6a0-b19b-40f4-b73a-2a742ce2350a','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/317af6a0-b19b-40f4-b73a-2a742ce2350a.png',1579800330393,1579800336879,'P4O10+H2O->H3PO4','P4O10+H2O->H3PO4',NULL,NULL,NULL,NULL,'LABELED'),('3695c083-f221-408a-9aec-c645be824e87','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3695c083-f221-408a-9aec-c645be824e87.png',1580189968434,1580189969888,'Fe2O3+C->FeO+CO2','Fe2O3+C->FeO+CO2',NULL,NULL,NULL,NULL,'LABELED'),('37af7995-efff-431b-97e8-19acd4a518b8','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/37af7995-efff-431b-97e8-19acd4a518b8.png',1582606183459,1582606185626,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('3de765dc-8717-49f9-8e56-70971623ea71','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/3de765dc-8717-49f9-8e56-70971623ea71.png',1582606225979,1582606227215,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('4033281b-9e15-4a17-901c-fd2195eda638','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/4033281b-9e15-4a17-901c-fd2195eda638.png',1582606120702,1582606122666,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('40488d10-4900-4a04-9bd3-108e12c80c15','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/40488d10-4900-4a04-9bd3-108e12c80c15.png',1582606406354,1582606409390,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('427dbb99-df72-4d26-9625-1bf186323264','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/427dbb99-df72-4d26-9625-1bf186323264.png',1582606018103,1582606019196,'',NULL,NULL,NULL,NULL,NULL,'INCOMPLETE'),('44865daf-b63a-42f1-af79-cc85503c4819','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/44865daf-b63a-42f1-af79-cc85503c4819.png',1581616689336,1581616690610,'(NH4)CO2+2AlCl3->Al2(CO3)2+6NH4Cl','(NH4)CO2+2AlCl3->Al2(CO3)2+6NH4Cl',NULL,NULL,NULL,NULL,'LABELED'),('4e21c8a3-719f-4829-9617-ebd0f353321f','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/4e21c8a3-719f-4829-9617-ebd0f353321f.png',1581616738510,1581616739478,'N2+3H2<->2NH3','N2+3H2<->2NH3',NULL,NULL,NULL,NULL,'LABELED'),('656a7625-d729-4d5f-bd4b-bb294ac26ee7','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/656a7625-d729-4d5f-bd4b-bb294ac26ee7.png',1582605990848,1582605992226,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('6c823ca8-1781-46a0-8392-bbcb1ff0710d','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/6c823ca8-1781-46a0-8392-bbcb1ff0710d.png',1582606153871,1582606155760,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('74a49b49-a914-4d5a-977d-596e6953f8f7','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/74a49b49-a914-4d5a-977d-596e6953f8f7.png',1579800472088,1579800480075,'C3H8+O2->H2O+CO2','C3H8+O2->H2O+CO2',NULL,NULL,NULL,NULL,'LABELED'),('79e15ccc-3f64-4341-8b60-b4985d00fb3c','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/79e15ccc-3f64-4341-8b60-b4985d00fb3c.png',1582159825084,1582159827103,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('7ec3e153-434a-490e-805d-547a2f7ee27f','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/7ec3e153-434a-490e-805d-547a2f7ee27f.png',1582159611568,1582159613468,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('92a4e829-6c23-45bc-805e-e657766a1a97','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/92a4e829-6c23-45bc-805e-e657766a1a97.png',1581616753220,1581616754034,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('998ac045-fbde-4010-9669-470aeed9a05a','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/998ac045-fbde-4010-9669-470aeed9a05a.png',1582606194951,1582606196398,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('9b20a369-d2c3-485a-91a4-4d801d9e3fb5','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/9b20a369-d2c3-485a-91a4-4d801d9e3fb5.png',1582159762625,1582159763750,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('ae0e8887-ab03-48fc-a14d-17c11d639aba','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/ae0e8887-ab03-48fc-a14d-17c11d639aba.png',1582606388657,1582606390053,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('bd4a93ec-74dd-4096-89b0-70a9d8fb52f2','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/bd4a93ec-74dd-4096-89b0-70a9d8fb52f2.png',1582605981326,1582605982318,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('cdb0bcde-6024-4a7c-8aaa-811bba314132','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/cdb0bcde-6024-4a7c-8aaa-811bba314132.png',1582605965329,1582605967454,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('d0a396fd-8538-410d-b5a2-bee99db5800f','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/d0a396fd-8538-410d-b5a2-bee99db5800f.png',1582606010320,1582606011591,'',NULL,NULL,NULL,NULL,NULL,'IN_PROGRESS'),('d0b9abf0-e341-4e5b-ab3a-ca5386ae6580','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/d0b9abf0-e341-4e5b-ab3a-ca5386ae6580.png',1582606425214,1582606426442,'',NULL,NULL,NULL,NULL,NULL,'INCOMPLETE'),('dd527d8a-65a8-436d-8191-f41f592ab79a','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/dd527d8a-65a8-436d-8191-f41f592ab79a.png',1581616784752,1581616785978,'C2H2+2H2->C2H6','C2H2+2H2->C2H6',NULL,NULL,NULL,NULL,'LABELED'),('e0abbd43-4434-4c0b-94a1-e784bd8222c7','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e0abbd43-4434-4c0b-94a1-e784bd8222c7.png',1581616820226,1581616821350,'N2O5+1/2O2+2NO2','N2O5+1/2O2+2NO2',NULL,NULL,NULL,NULL,'LABELED'),('e1a2b6d3-de4e-45f1-8525-af9bb774d565','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e1a2b6d3-de4e-45f1-8525-af9bb774d565.png',1581616729039,1581616730166,'',NULL,NULL,NULL,NULL,NULL,'LABELED'),('e31f9864-1c49-4840-86f1-4f4ba63fb773','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e31f9864-1c49-4840-86f1-4f4ba63fb773.png',1582606440062,1582606441302,'',NULL,NULL,NULL,NULL,NULL,'INCOMPLETE'),('e3b26e00-57b3-4c01-b66d-3a708f214fc8','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e3b26e00-57b3-4c01-b66d-3a708f214fc8.png',1580257037234,1580257038295,'(NH4)2CO3+AlCl3->Al2(CO3)2+NH4Cl','(NH4)2CO3+AlCl3->Al2(CO3)2+NH4Cl',NULL,NULL,NULL,NULL,'LABELED'),('e4a71a94-dbf3-46b4-8fea-1e8a9cb38dad','https://s3.us-west-1.amazonaws.com/chemical-equation-balancer-image-bucket/e4a71a94-dbf3-46b4-8fea-1e8a9cb38dad.png',1581616671046,1581616672682,'Fe2O3+C->FeO+CO2','Fe2O3+C->FeO+CO2',NULL,NULL,NULL,NULL,'LABELED');
/*!40000 ALTER TABLE `ImageProcessorRequestInfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Users`
--
DROP TABLE IF EXISTS `Users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Users` (
`id` varchar(255) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`role` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Users`
--
LOCK TABLES `Users` WRITE;
/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
INSERT INTO `Users` VALUES ('860342e6-4e8c-4195-916e-4382043191a5','admin','$2a$10$8SkvXAgoUCJg4I8JlsBPqOrjMk.dvLYRXkvIx6rQ6BSg7n64SGOBW','USER');
/*!40000 ALTER TABLE `Users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'ChemicalEquationBalancerDatabase'
--
SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2020-06-06 16:35:29