gistfile1.txt

MariaDB [merit_scratch]> CREATE TABLE `MERIT_BADGE` (
    ->   `BadgeID` INT(11) UNSIGNED AUTO_INCREMENT,
    ->   `BadgeName` VARCHAR(256) NOT NULL,
    ->   `AlternateGroupID` INT(11) UNSIGNED,
    ->   PRIMARY KEY (`BadgeID`));
Query OK, 0 rows affected (0.01 sec)

MariaDB [merit_scratch]> CREATE TABLE `ALTERNATE_GROUPS` (
    ->   `AlternateGroupID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    ->   PRIMARY KEY (`AlternateGroupID`));
Query OK, 0 rows affected (0.00 sec)

MariaDB [merit_scratch]> INSERT INTO `ALTERNATE_GROUPS` VALUES (NULL);Query OK, 1 row affected (0.00 sec)

MariaDB [merit_scratch]> INSERT INTO `ALTERNATE_GROUPS` VALUES (NULL);
Query OK, 1 row affected (0.00 sec)

MariaDB [merit_scratch]> SELECT * FROM `ALTERNATE_GROUPS`;
+------------------+
| AlternateGroupID |
+------------------+
|                1 |
|                2 |
+------------------+
2 rows in set (0.00 sec)

MariaDB [merit_scratch]> INSERT INTO `MERIT_BADGE` (`BadgeName`, `AlternateGroupID`) VALUES ("Hiking", 1);
Query OK, 1 row affected (0.00 sec)

MariaDB [merit_scratch]> INSERT INTO `MERIT_BADGE` (`BadgeName`, `AlternateGroupID`) VALUES ("Cycling", 1);
Query OK, 1 row affected (0.01 sec)

MariaDB [merit_scratch]> INSERT INTO `MERIT_BADGE` (`BadgeName`, `AlternateGroupID`) VALUES ("Swimming", 1);
Query OK, 1 row affected (0.00 sec)

MariaDB [merit_scratch]> INSERT INTO `MERIT_BADGE` (`BadgeName`, `AlternateGroupID`) VALUES ("Underwater Origami", 2);
Query OK, 1 row affected (0.00 sec)

MariaDB [merit_scratch]> INSERT INTO `MERIT_BADGE` (`BadgeName`, `AlternateGroupID`) VALUES ("Full-Contact Basket Weaving", 2);
Query OK, 1 row affected (0.00 sec)

MariaDB [merit_scratch]> SELECT * FROM MERIT_BADGE;
+---------+-----------------------------+------------------+
| BadgeID | BadgeName                   | AlternateGroupID |
+---------+-----------------------------+------------------+
|       1 | Hiking                      |                1 |
|       2 | Cycling                     |                1 |
|       3 | Swimming                    |                1 |
|       4 | Underwater Origami          |                2 |
|       5 | Full-Contact Basket Weaving |                2 |
+---------+-----------------------------+------------------+
5 rows in set (0.00 sec)