BEGIN TRANSACTION;
CREATE TABLE Comptes (
Nucop char(8) primary key NOT NULL,
Matcom varchar(8) default 'UNKNOWN',
Libec varchar(40) NOT NULL,
Tydc char(1) default ' ',
Ebloc char(1) default ' ',
Repg BLOB);

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 Param (
Idparam char(4) NOT NULL,
Nuli Integer PRIMARY KEY NOT NULL,
Don1 varchar(128) NOT NULL);

CREATE TABLE Ttaux (
Idparam char(4) NOT NULL,
Nuli Integer PRIMARY KEY NOT NULL,
Don1 varchar(128) NOT NULL);

CREATE TABLE Tjnal (
Idparam char(4) NOT NULL,
Nuli Integer PRIMARY KEY NOT NULL,
Don1 varchar(128) NOT NULL);

INSERT INTO Param VALUES('BALS',NULL,'0');
INSERT INTO Param VALUES('NPIE',NULL,'200');
INSERT INTO Param VALUES('DIDA',NULL,'300');
INSERT INTO Param VALUES('NSOC',NULL,'Masoc-Test - Exercice du 1/1/2011 au 31/12/2011');
INSERT INTO Param VALUES('DEXE',NULL,'01/01/2011');
INSERT INTO Param VALUES('FEXE',NULL,'31/12/2011');
COMMIT;
