1 CREATE TABLE `podcast_groups` (
2 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 `title` varchar(100) NOT NULL
7 alter table podcast add column `group_id` integer default null;
8 alter table podcast add column `group_member_name` varchar(20) default null;
10 ALTER TABLE podcast ADD CONSTRAINT `group_id` FOREIGN KEY (`group_id`) REFERENCES `podcast_groups` (`id`);
12 alter table toplist drop primary key;
13 alter table toplist add primary key (id);
14 alter table toplist modify column podcast_id integer null;
15 alter table toplist add column `podcast_group_id` integer default null;
16 ALTER TABLE toplist ADD CONSTRAINT `podcast_group_id` FOREIGN KEY (`podcast_group_id`) REFERENCES `podcast_groups` (`id`);
18 DROP PROCEDURE IF EXISTS update_toplist;