+CREATE TABLE GEARS (
+ GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
+ GEAR VARCHAR(80) NOT NULL,
+ DESCRIPTION VARCHAR(160),
+ PRICE FLOAT
+ URL VARCHAR(80),
+);
+
+CREATE TABLE PERSONS_GEARS (
+ GEAR_ID INT NOT NULL,
+ PERSON_ID INT NOT NULL,
+ INDEX ( GEAR_ID ),
+ INDEX ( PERSON_ID )
+);
+
+CREATE TABLE CREWS_GEARS (
+ GEAR_ID INT NOT NULL,
+ CREW_ID INT NOT NULL,
+ INDEX ( GEAR_ID ),
+ INDEX ( CREW_ID )
+);
+