AddSlugColumnInResourceModuleTable.sql
1.13 KB
USE AIADATABASEV5LIVE
ALTER TABLE ResourceModule
ADD Slug2 varchar(50);
UPDATE ResourceModule SET SLUG= 'da-view-list' WHERE ID=1
UPDATE ResourceModule SET SLUG= 'tile-view-list' WHERE ID=2
UPDATE ResourceModule SET SLUG= '3d-anatomy-list' WHERE ID=3
UPDATE ResourceModule SET SLUG= 'clinical-illustrations' WHERE ID=4
UPDATE ResourceModule SET SLUG= 'clinical-animations' WHERE ID=5
UPDATE ResourceModule SET SLUG= 'Link/encyclopedia' WHERE ID=6
UPDATE ResourceModule SET SLUG= 'curriculum-builder' WHERE ID=7
UPDATE ResourceModule SET SLUG= 'anatomy-test' WHERE ID=8
UPDATE ResourceModule SET SLUG= 'Link/IP-10' WHERE ID=9
UPDATE ResourceModule SET SLUG= 'lab-exercises' WHERE ID=10
UPDATE ResourceModule SET SLUG= 'Link/indepth-reports' WHERE ID=11
UPDATE ResourceModule SET SLUG= 'Link/complementary-and-alternate-medicine' WHERE ID=12
UPDATE ResourceModule SET SLUG= 'ADAM-images' WHERE ID=13
UPDATE ResourceModule SET SLUG= 'Link/bodyguide' WHERE ID=14
UPDATE ResourceModule SET SLUG= 'Link/health-navigator' WHERE ID=15
UPDATE ResourceModule SET SLUG= 'Link/wellness-tools' WHERE ID=16
UPDATE ResourceModule SET SLUG= 'Link/aod' WHERE ID=1017