Channels
#exposed
Title
# exposed
s
SrSouza
07/26/2019, 8:21 PMHi guys, I'm using DAO and I have a Table in other database, how I can reference a column in this table that is in other database with Exposed?
I was think, using the Table name with the database as prefix would work? like this
object MyTableInOtherDatabase : Table("Database.my_table")This dont work :S
Table name that I use in exposed Table: server_global.jogadores
createStatements output
Copy code
CREATE TABLE IF NOT EXISTS server_global.jogadores (id INT AUTO_INCREMENT PRIMARY KEY, uuid BINARY(16) NOT NULL, nickname VARCHAR(25) NOT NULL, nickname_lowercase VARCHAR(25) NOT NULL, register_date DATETIME(6) NOT NULL)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_uuid_unique UNIQUE (uuid)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_nickname_unique UNIQUE (nickname)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_nickname_lowercase_unique UNIQUE (nickname_lowercase)The creates but the other commands I think that dont work, can you help me @tapac?
Exception:
t
tapac
07/27/2019, 8:05 PMYou want to make joins between different schemas?
s
SrSouza
07/28/2019, 5:26 PMExacly