BEGIN TRANSACTION;

/* Create a table called NAMES */
CREATE TABLE CHARACTER(Id integer PRIMARY KEY, Name text, int Age);

/* Create few records in this table */
INSERT INTO CHARACTER VALUES(1,'Tom', 42);
INSERT INTO CHARACTER VALUES(2,'Lucy', 65);
INSERT INTO CHARACTER VALUES(3,'Frank', 5);
INSERT INTO CHARACTER VALUES(4,'Jane', 20);
INSERT INTO CHARACTER VALUES(5,'Robert', 37);

CREATE TABLE NAMES_SEXE(Id integer PRIMARY KEY, int Sexe);

/* Create few records in this table */
INSERT INTO NAMES_SEXE VALUES(1, 0);
INSERT INTO NAMES_SEXE VALUES(2, 1);
INSERT INTO NAMES_SEXE VALUES(3, 0);
INSERT INTO NAMES_SEXE VALUES(4, 1);
INSERT INTO NAMES_SEXE VALUES(5, 0);
COMMIT;