With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
hi! I have to speed up one sql consult that envolve two tables.
CREATE TABLE cuentas (id INTEGER AUTO_INCREMENT PRIMARY KEY,
cuenta VARCHAR(50) NOT NULL UNIQUE,
editable TINYINT(1) NOT NULL,
lft INTEGER NOT NULL,
rgt INTEGER NOT NULL) ENGINE=InnoDB;
CREATE TABLE movimientos (id INTEGER AUTO_INCREMENT PRIMARY KEY,
asientoId INTEGER NOT NULL,
cuentaId INTEGER NOT NULL,
fecha DATE NOT NULL,
debito DECIMAL(12,2) NOT NULL,
credito DECIMAL(12,2) NOT NULL,
FOREIGN KEY(asientoId) REFERENCES asientos(id),
Sign in or Register to see more