· 8 years ago · Mar 03, 2018, 06:16 AM
1
2SET FOREIGN_KEY_CHECKS = 0;
3
4SET AUTOCOMMIT = 0;
5START TRANSACTION;
6
7-- --------------------------------------------------------
8
9--
10-- Table `SoftwareVersionRange`
11--
12
13DROP TABLE IF EXISTS `SoftwareVersionRange`;
14CREATE TABLE IF NOT EXISTS `SoftwareVersionRange` (
15 `svrId` int(11) NOT NULL default '0',
16 `svrName` varchar(255) default NULL,
17 `svrSoftwareDevelopmentBranch` int(11) NOT NULL default '0',
18 PRIMARY KEY (`svrId`),
19 KEY `SoftwareVersionRange_ibfk_1` (`svrSoftwareDevelopmentBranch`)
20) TYPE=MyISAM;
21
22-- --------------------------------------------------------
23
24--
25-- Table `SoftwareVersion`
26--
27
28DROP TABLE IF EXISTS `SoftwareVersion`;
29CREATE TABLE IF NOT EXISTS `SoftwareVersion` (
30 `svsId` int(11) NOT NULL default '0',
31 `svsVersionNo` varchar(255) default NULL,
32 `svsSoftwareVersionRange` int(11) NOT NULL default '0',
33 `svsCreationDate` datetime NOT NULL default '0000-00-00 00:00:00',
34 `svsVersionType` int(11) NOT NULL default '0',
35 `svsDescription` text default NULL,
36 PRIMARY KEY (`svsId`),
37 KEY `SoftwareVersion_ibfk_1` (`svsSoftwareVersionRange`)
38) TYPE=MyISAM;
39
40-- --------------------------------------------------------
41
42--
43-- Table `LicensePool`
44--
45
46ALTER TABLE `LicensePool` ADD `lcpSoftwareVersionRange` int(11) default NULL;
47ALTER TABLE `LicensePool` ADD KEY `LicensePool_ibfk_5` (`lcpSoftwareVersionRange`);
48ALTER TABLE `LicensePool` ADD CONSTRAINT `LicensePool_ibfk_5` FOREIGN KEY (`lcpSoftwareVersionRange`) REFERENCES `SoftwareVersionRange` (`svrId`);
49
50-- --------------------------------------------------------
51
52--
53-- Table `DownloadableFile`
54--
55
56ALTER TABLE `DownloadableFile` ADD `dlfSoftwareVersion` int(11) default NULL;
57ALTER TABLE `DownloadableFile` ADD KEY `DownloadableFile_ibfk_1` (`dlfSoftwareVersion`);
58ALTER TABLE `DownloadableFile` ADD CONSTRAINT `DownloadableFile_ibfk_1` FOREIGN KEY (`dlfSoftwareVersion`) REFERENCES `SoftwareVersion` (`svsId`);
59
60-- --------------------------------------------------------
61
62INSERT INTO `SoftwareVersionRange` VALUES ('1', '1.2', '1');
63
64INSERT INTO `SoftwareVersionRange` VALUES ('2', '1.2', '2');
65INSERT INTO `SoftwareVersionRange` VALUES ('3', '2.0', '2');
66INSERT INTO `SoftwareVersionRange` VALUES ('4', '2.2', '2');
67INSERT INTO `SoftwareVersionRange` VALUES ('5', '2.4', '2');
68INSERT INTO `SoftwareVersionRange` VALUES ('6', '2.6', '2');
69INSERT INTO `SoftwareVersionRange` VALUES ('7', '2.8', '2');
70INSERT INTO `SoftwareVersionRange` VALUES ('8', '2.10', '2');
71INSERT INTO `SoftwareVersionRange` VALUES ('9', '2.12', '2');
72
73INSERT INTO `SoftwareVersionRange` VALUES ('10', '2.0', '3');
74INSERT INTO `SoftwareVersionRange` VALUES ('11', '2.2', '3');
75INSERT INTO `SoftwareVersionRange` VALUES ('12', '2.4', '3');
76INSERT INTO `SoftwareVersionRange` VALUES ('13', '2.6', '3');
77INSERT INTO `SoftwareVersionRange` VALUES ('14', '2.8', '3');
78INSERT INTO `SoftwareVersionRange` VALUES ('15', '2.10', '3');
79INSERT INTO `SoftwareVersionRange` VALUES ('16', '2.12', '3');
80
81INSERT INTO `SoftwareVersionRange` VALUES ('17', '2.2', '5');
82INSERT INTO `SoftwareVersionRange` VALUES ('18', '2.4', '5');
83INSERT INTO `SoftwareVersionRange` VALUES ('19', '2.6', '5');
84INSERT INTO `SoftwareVersionRange` VALUES ('20', '2.8', '5');
85INSERT INTO `SoftwareVersionRange` VALUES ('21', '2.10', '5');
86INSERT INTO `SoftwareVersionRange` VALUES ('22', '2.12', '5');
87
88INSERT INTO `SoftwareVersionRange` VALUES ('23', '2.4', '6');
89INSERT INTO `SoftwareVersionRange` VALUES ('24', '2.6', '6');
90INSERT INTO `SoftwareVersionRange` VALUES ('25', '2.8', '6');
91INSERT INTO `SoftwareVersionRange` VALUES ('26', '2.10', '6');
92INSERT INTO `SoftwareVersionRange` VALUES ('27', '2.12', '6');
93
94INSERT INTO `SoftwareVersion` VALUES ('1', '2.10.0.4616', '15', '2007-04-10 00:00:00', '3', '<p><b>PHPEdit 2.10 Stable</b></p><p>This version includes <u>XDebug</u> support and more than 300 other enhancements compared to previous 2.8 release. All users are greatly encouraged to upgrade now.</p><ul><li>Enhanced Debugger support<ul><li>New profiler using inCacheGrind</li><li>Debug multiple session at once</li><li>Configure the debugger easily using the dedicated wizard</li><li>Fix Debugger\'s configuration issue using the diagnostic tool</li></ul></li><li>New search and replace dialog and capabilities</li></ul>');
95INSERT INTO `SoftwareVersion` VALUES ('2', '2.8.0.3997', '14', '2006-11-29 00:00:00', '3', '');
96INSERT INTO `SoftwareVersion` VALUES ('3', '2.6.1.3521', '13', '2006-09-07 00:00:00', '3', '');
97INSERT INTO `SoftwareVersion` VALUES ('4', '2.6.0.3466', '13', '2006-08-16 00:00:00', '3', '');
98INSERT INTO `SoftwareVersion` VALUES ('5', '2.4.0.233', '12', '2006-06-07 00:00:00', '3', '');
99INSERT INTO `SoftwareVersion` VALUES ('6', '2.2.0.219', '11', '2006-04-12 00:00:00', '3', '');
100INSERT INTO `SoftwareVersion` VALUES ('7', '2.0.0.200', '10', '2006-01-17 00:00:00', '3', '');
101INSERT INTO `SoftwareVersion` VALUES ('8', '1.2.5.176', '1', '2005-10-19 00:00:00', '3', '');
102
103-- --------------------------------------------------------
104
105UPDATE `LicensePool` SET lcpSoftwareVersionRange = '14' WHERE lcpDevBranch = '3';
106UPDATE `LicensePool` SET lcpSoftwareVersionRange = '7' WHERE lcpDevBranch = '2';
107UPDATE `LicensePool` SET lcpSoftwareVersionRange = '20' WHERE lcpDevBranch = '5';
108UPDATE `LicensePool` SET lcpSoftwareVersionRange = '25' WHERE lcpDevBranch = '6';
109
110-- --------------------------------------------------------
111
112SET FOREIGN_KEY_CHECKS = 1;
113
114COMMIT;