pC9Xx49v

1DROP TABLE IF EXISTS systems;
2CREATE TABLE systems (
3  id                    INT             NOT NULL auto_increment,
4  name                  VARCHAR(50)     NOT NULL,
5  PRIMARY KEY (id)
6);
7
8DROP TABLE IF EXISTS components;
9CREATE TABLE components (
10  id                    INT             NOT NULL auto_increment,
11  name                  VARCHAR(50)     NOT NULL,
12  system_id             INT             NOT NULL,
13  CONSTRAINT fk_components_system FOREIGN KEY (system_id) REFERENCES systems(id),
14  PRIMARY KEY (id)
15);