NEED HELP WITH SQL PROBLEM. I wrote the code below and the error im getting.

Question:Create a table Money_xxxx with the following fields and constraints. mid: int primary key auto_increment, code varchar(50) unique, cid: int, type: char(1), amount: float, mydatetime: datetime, note: varchar(255) All fields cannot have NULL values, except note. mid is the primary key, and the value should be auto increment by the DBMS. cid is a foreign key references to the id field in CPS3740.Customers table. code should be unique. sid is a foreign key references to the id field in CPS3740.Sources table

Here is my code:

CREATE TABLE Money_xxxx (

mid AUTO_INCREMENT NOT NULL,

code varchar(50) NOT NULL unique,

cid int NOT NULL,

type char(1) NOT NULL,

amount float NOT NULL,

mydatetime datetime NOT NULL,

note varchar(255),

PRIMARY KEY (mid),

FOREIGN KEY (cid) REFERENCES Customers(id),

FOREIGN KEY (cid) REFERENCES Sources(id)

);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL,

code varchar(50) NOT NULL unique,

cid int NOT NULL,

typ' at line 2