Techbot/JiGS — pull request #11 by justinkelly69 (2013-07-09 18:16:49+00:00)
Title: Added awards table

I added the awards table and it displays in the tab.
The following SQL sets up the new tables with some test data. Edit as needed.

DROP TABLE IF EXISTS `j17_jigs_awards`;
CREATE TABLE IF NOT EXISTS `j17_jigs_awards`(
`id` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
`iduser` INTEGER NOT NULL,
`name_id` INTEGER NOT NULL
);
DROP TABLE IF EXISTS `j17_jigs_award_names`;
CREATE TABLE IF NOT EXISTS `j17_jigs_award_names`(
`id` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
`name` TEXT NOT NULL
);
INSERT INTO `j17_jigs_award_names` (`name`) VALUES
('Bought a Factory'),
('Kicked a Hobbit'),
('Ate a Cake'),
('Danced a Jig');
INSERT INTO `j17_jigs_awards` (`iduser`, `name_id`) VALUES
(63,1),(63,2),(63,3),(128,2),(128,3),(128,4);