23FbxFTH

1%nid  in tabel nodeurl is niet meer een primary key!!!!
2ALTER TABLE nodeurl DROP PRIMARY KEY
3
4
5
6%revstart en revend toevoegen aan tabel nodeurl
7
8ALTER TABLE `nodeurl` ADD `revstart` INT NOT NULL AFTER `url` ,
9ADD `revend` INT NOT NULL AFTER `revstart` 
10
11
12
13
14%Tabel om nodes te importeren:
15
16CREATE TABLE IF NOT EXISTS `modelurls` (
17  `urlid` int(11) NOT NULL AUTO_INCREMENT,
18  `modelid` int(11) NOT NULL,
19  `url` varchar(511) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
20  `isregex` tinyint(1) NOT NULL,
21  PRIMARY KEY (`urlid`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
23
24
25
26
27
28ALTER TABLE `nodeurl` ADD `isregex` BOOLEAN NOT NULL AFTER `url` 
29
30
31
32ALTER TABLE `node` ADD `description` MEDIUMTEXT NOT NULL AFTER `mid` 
33
34
35Words tabel uitbreiden:
36INSERT INTO `words` (`id`, `val`, `lang`) VALUES
37('addOrEditURLs', 'Add or edit URL''s', 'en'),
38('addOrEditURLs', 'URL''s toevoegen of editen', 'nl'),
39('addOrEditURLs', 'URL''s Hinzufügen oder bearbeiten', 'de'),
40
41('viewEditNodeDescription', 'View or edit the node description', 'en'),
42('viewEditNodeDescription', 'Knoopbeschrijving tonen of veranderen', 'nl'),
43('viewEditNodeDescription', 'Knotenbeschreibung anzeigen oder ändern', 'de'),
44
45('nodeDescription', 'Node description', 'en'),
46('nodeDescription', 'Knoopbeschrijving', 'nl'),
47('nodeDescription', 'Knotenbeschreibung', 'de'),
48
49('nodes', 'Nodes', 'en'),
50('nodes', 'Knopen', 'nl'),
51('nodes', 'Knoten', 'de'),('yes', 'yes', 'en'),
52('yes', 'ja', 'nl'),
53('yes', 'ja', 'de'),('no', 'no', 'en'),
54('no', 'nee', 'nl'),
55('no', 'nein', 'de')
56
57
58
59!!Revisies in modelurls extra kolommen revstart en revend toegevoegd!!
60
61
62voeg o2mcUID toe aan user tabel met default -1
63
64ALTER TABLE  `model` ADD  `tool` VARCHAR( 31 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT  'sitecatalyst' AFTER  `longdescription`
65
66ALTER TABLE  `analyticsvariable` ADD  `type` VARCHAR( 31 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `name`
67
68# dit is een lijst zoals:  a=b;c=d;e=f
69ALTER TABLE  `model` ADD  `tooloptions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `tool`