attach 'testc-0.db' AS dbNm1;

BEGIN TRANSACTION;
CREATE TABLE main.Comptes AS SELECT * FROM dbNm1.Comptes;

CREATE TABLE Tmv (
Nucop char(8) NOT NULL,
Datmvq Integer  NOT NULL,
Nuor Integer PRIMARY KEY NOT NULL,
Datmv char(8) NOT NULL,
Piece varchar(6),
Libel varchar(40),
Cjal char(1) NOT NULL,
Dc char(1) NOT NULL,
Mont float(10.2)  NOT NULL,
Let char(1),
Ori char(4));

CREATE TABLE main.Param AS SELECT * FROM dbNm1.Param;
CREATE TABLE main.Ttaux AS SELECT * FROM dbNm1.Ttaux;
CREATE TABLE main.Tjnal AS SELECT * FROM dbNm1.Tjnal;

COMMIT;
