PRAGMA foreign_keys=OFF;
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 Param (
Idparam char(4) NOT NULL,
Nuli Integer PRIMARY KEY NOT NULL,
Don1 varchar(128) NOT NULL);
INSERT INTO Param VALUES('BALS',1,'0');
INSERT INTO Param VALUES('NPIE',2,'100');
INSERT INTO Param VALUES('DIDA',3,'500');
INSERT INTO Param VALUES('NSOC',4,'Masoc-Test - Exercice du 1/1/2012 au 31/12/2012');
INSERT INTO Param VALUES('DEXE',5,'01/01/2012');
INSERT INTO Param VALUES('FEXE',6,'31/12/2012');
CREATE TABLE Ttaux (
Idparam char(4) NOT NULL,
Nuli Integer PRIMARY KEY NOT NULL,
Don1 varchar(128) NOT NULL);
INSERT INTO Ttaux VALUES('TAUX',1,'a 20');
INSERT INTO Ttaux VALUES('TAUX',2,'b 120');
INSERT INTO Ttaux VALUES('TAUX',3,'c 5.5');
INSERT INTO Ttaux VALUES('TAUX',4,'d 105.5');
CREATE TABLE Tjnal (
Idparam char(4) NOT NULL,
Nuli Integer PRIMARY KEY NOT NULL,
Don1 varchar(128) NOT NULL);
INSERT INTO Tjnal VALUES('JNAL',1,'z Opérations diverses');
INSERT INTO Tjnal VALUES('JNAL',2,'a Journal d''Achat');
INSERT INTO Tjnal VALUES('JNAL',3,'v Journal de Ventes');

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

COMMIT;
