CW Cyrix's Git Repository Mirror
Browse code

Fix MySQL table creation, TYPE to ENGINE

Rainer Volkrodt authored on 2016/03/21 11:50:45
Showing 1 changed files
docs/upgrade11_step4.sql
History View file @ 0089b17
... ... 
@@ -8,13 +8,13 @@ CREATE TABLE `fanfiction_authorfields` (
8 8 
   `field_code_out` text,
9 9 
   `field_on` tinyint(1) NOT NULL default '0',
10 10 
   PRIMARY KEY  (`field_id`)
11 
-) TYPE=MyISAM;
11 
+) ENGINE=MyISAM;
12 12 
 CREATE TABLE `fanfiction_authorinfo` (
13 13 
   `uid` int(11) NOT NULL default '0',
14 14 
   `field` int(11) NOT NULL default '0',
15 15 
   `info` varchar(255) NOT NULL default ' ',
16 16 
   KEY `uid` (`uid`)
17 
-) TYPE=MyISAM;
17 
+) ENGINE=MyISAM;
18 18 
 CREATE TABLE `fanfiction_authorprefs` (
19 19 
   `uid` int(11) NOT NULL default '0',
20 20 
   `newreviews` tinyint(1) NOT NULL default '0',
... ... 
@@ -30,7 +30,7 @@ CREATE TABLE `fanfiction_authorprefs` (
30 30 
   `categories` varchar(200) NOT NULL default '0',
31 31 
   `contact` tinyint(1) NOT NULL default '0',
32 32 
    PRIMARY KEY  (`uid`)
33 
-) TYPE=MyISAM;
33 
+) ENGINE=MyISAM;
34 34 
 CREATE TABLE `fanfiction_blocks` (
35 35 
   `block_id` int(11) NOT NULL auto_increment,
36 36 
   `block_name` varchar(30) NOT NULL default '',
... ... 
@@ -40,7 +40,7 @@ CREATE TABLE `fanfiction_blocks` (
40 40 
   `block_variables` text NOT NULL,
41 41 
   PRIMARY KEY  (`block_id`),
42 42 
   KEY `block_name` (`block_name`)
43 
-) TYPE=MyISAM;
43 
+) ENGINE=MyISAM;
44 44 
 CREATE TABLE `fanfiction_chapters` (
45 45 
   `chapid` int(11) NOT NULL auto_increment,
46 46 
   `title` varchar(250) NOT NULL default '',
... ... 
@@ -61,34 +61,34 @@ CREATE TABLE `fanfiction_chapters` (
61 61 
   KEY `inorder` (`inorder`),
62 62 
   KEY `title` (`title`),
63 63 
   KEY `validated` (`validated`)
64 
-) TYPE=MyISAM;
64 
+) ENGINE=MyISAM;
65 65 
 CREATE TABLE `fanfiction_classes` (
66 66 
   `class_id` int(11) NOT NULL auto_increment,
67 67 
   `class_type` int(11) NOT NULL default '0',
68 68 
   `class_name` varchar(100) NOT NULL default '',
69 69 
   PRIMARY KEY  (`class_id`)
70 
-) TYPE=MyISAM;
70 
+) ENGINE=MyISAM;
71 71 
 CREATE TABLE `fanfiction_classtypes` (
72 72 
   `classtype_id` int(11) NOT NULL auto_increment,
73 73 
   `classtype_name` varchar(50) NOT NULL default '',
74 74 
   `classtype_title` varchar(50) NOT NULL default '',
75 75 
   PRIMARY KEY  (`classtype_id`),
76 76 
   KEY `classtype_title` (`classtype_title`)
77 
-) TYPE=MyISAM;
77 
+) ENGINE=MyISAM;
78 78 
 CREATE TABLE `fanfiction_codeblocks` (
79 79 
   `code_id` int(11) NOT NULL auto_increment,
80 80 
   `code_text` text NOT NULL,
81 81 
   `code_type` varchar(20) default NULL,
82 82 
   `code_module` varchar(60) default NULL,
83 83 
   PRIMARY KEY  (`code_id`)
84 
-) TYPE=MyISAM;
84 
+) ENGINE=MyISAM;
85 85 
 CREATE TABLE `fanfiction_favorites` (
86 86 
   `uid` int(11) NOT NULL default '0',
87 87 
   `item` int(11) NOT NULL default '0',
88 88 
   `type` char(2) NOT NULL default '',
89 89 
   `comments` text NULL,
90 90 
   KEY `uid` (`uid`)
91 
-) TYPE=MyISAM;
91 
+) ENGINE=MyISAM;
92 92 
 CREATE TABLE `fanfiction_inseries` (
93 93 
   `seriesid` int(11) NOT NULL default '0',
94 94 
   `sid` int(11) NOT NULL default '0',
... ... 
@@ -99,7 +99,7 @@ CREATE TABLE `fanfiction_inseries` (
99 99 
   KEY `sid` (`sid`),
100 100 
   KEY `inorder` (`inorder`),
101 101 
   KEY `seriesid` (`seriesid`)
102 
-) TYPE=MyISAM;
102 
+) ENGINE=MyISAM;
103 103 
 CREATE TABLE `fanfiction_log` (
104 104 
   `log_id` int(11) NOT NULL auto_increment,
105 105 
   `log_action` varchar(255) default NULL,
... ... 
@@ -108,21 +108,21 @@ CREATE TABLE `fanfiction_log` (
108 108 
   `log_timestamp` timestamp NOT NULL,
109 109 
   `log_type` varchar(2) NOT NULL,
110 110 
   PRIMARY KEY  (`log_id`)
111 
-) TYPE=MyISAM
111 
+) ENGINE=MyISAM
112 112 
 CREATE TABLE `fanfiction_messages` (
113 113 
   `message_id` int(11) NOT NULL auto_increment,
114 114 
   `message_name` varchar(50) NOT NULL default '',
115 115 
   `message_title` varchar(200) NOT NULL default '',
116 116 
   `message_text` text NULL,
117 117 
   PRIMARY KEY  (`message_id`)
118 
-) TYPE=MyISAM;
118 
+) ENGINE=MyISAM;
119 119 
 CREATE TABLE `".$tableprefix."fanfiction_modules` (
120 120 
   `id` int(11) NOT NULL auto_increment,
121 121 
   `name` varchar(100) NOT NULL default 'Test Module',
122 122 
   `version` varchar(10) NOT NULL default '1.0',
123 123 
   PRIMARY KEY  (`id`),
124 124 
   KEY `name_version` (`name`,`version`)
125 
-) TYPE=MyISAM;
125 
+) ENGINE=MyISAM;
126 126 
 CREATE TABLE `fanfiction_pagelinks` (
127 127 
   `link_id` int(11) NOT NULL auto_increment,
128 128 
   `link_name` varchar(50) NOT NULL default '',
... ... 
@@ -133,7 +133,7 @@ CREATE TABLE `fanfiction_pagelinks` (
133 133 
   PRIMARY KEY  (`link_id`),
134 134 
   KEY `link_text` (`link_text`),
135 135 
   KEY `link_name` (`link_name`)
136 
-) TYPE=MyISAM;
136 
+) ENGINE=MyISAM;
137 137 
 CREATE TABLE `fanfiction_panels` (
138 138 
   `panel_id` int(11) NOT NULL auto_increment,
139 139 
   `panel_name` varchar(50) NOT NULL default 'unknown',
... ... 
@@ -146,7 +146,7 @@ CREATE TABLE `fanfiction_panels` (
146 146 
   PRIMARY KEY  (`panel_id`),
147 147 
   KEY `panel_hidden` (`panel_hidden`),
148 148 
   KEY `panel_type` (`panel_type`)
149 
-) TYPE=MyISAM;
149 
+) ENGINE=MyISAM;
150 150 
 CREATE TABLE `fanfiction_series` (
151 151 
   `seriesid` int(11) NOT NULL auto_increment,
152 152 
   `title` varchar(200) NOT NULL default '',
... ... 
@@ -165,7 +165,7 @@ CREATE TABLE `fanfiction_series` (
165 165 
   KEY `challenges` (`challenges`),
166 166 
   KEY `characters` (`characters`),
167 167 
   KEY `classes` (`classes`)
168 
-) TYPE=MyISAM;
168 
+) ENGINE=MyISAM;
169 169
170 170 
 CREATE TABLE `fanfiction_stats` (
171 171 
   `sitekey` varchar(50) NOT NULL default '0',
... ... 
@@ -178,4 +178,4 @@ CREATE TABLE `fanfiction_stats` (
178 178 
   `members` int(11) NOT NULL default '0',
179 179 
   `reviewers` int(11) NOT NULL default '0',
180 180 
   `newestmember` int(11) NOT NULL default '0'
181 
-) TYPE=MyISAM;
181 
+) ENGINE=MyISAM;
Browse code

Initial uplad w/ php7 fixes

Rainer Volkrodt authored on 2016/03/12 15:54:02
Showing 1 changed files
docs/upgrade11_step4.sql
History View file @ 00f5f21
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,181 @@
1 
+CREATE TABLE `fanfiction_authorfields` (
2 
+  `field_id` int(11) NOT NULL AUTO_INCREMENT,
3 
+  `field_type` tinyint(4) NOT NULL default '0',
4 
+  `field_name` varchar(30) NOT NULL default ' ',
5 
+  `field_title` varchar(255) NOT NULL default ' ',
6 
+  `field_options` text,
7 
+  `field_code_in` text,
8 
+  `field_code_out` text,
9 
+  `field_on` tinyint(1) NOT NULL default '0',
10 
+  PRIMARY KEY  (`field_id`)
11 
+) TYPE=MyISAM;
12 
+CREATE TABLE `fanfiction_authorinfo` (
13 
+  `uid` int(11) NOT NULL default '0',
14 
+  `field` int(11) NOT NULL default '0',
15 
+  `info` varchar(255) NOT NULL default ' ',
16 
+  KEY `uid` (`uid`)
17 
+) TYPE=MyISAM;
18 
+CREATE TABLE `fanfiction_authorprefs` (
19 
+  `uid` int(11) NOT NULL default '0',
20 
+  `newreviews` tinyint(1) NOT NULL default '0',
21 
+  `newrespond` tinyint(1) NOT NULL default '0',
22 
+  `ageconsent` tinyint(1) NOT NULL default '0',
23 
+  `alertson` tinyint(1) NOT NULL default '0',
24 
+  `tinyMCE` tinyint(1) NOT NULL default '0',
25 
+  `sortby` tinyint(1) NOT NULL default '0',
26 
+  `storyindex` tinyint(1) NOT NULL default '0',
27 
+  `validated` tinyint(1) NOT NULL default '0',
28 
+  `userskin` varchar(60) NOT NULL default 'default',
29 
+  `level` tinyint(1) NOT NULL default '0',
30 
+  `categories` varchar(200) NOT NULL default '0',
31 
+  `contact` tinyint(1) NOT NULL default '0',
32 
+   PRIMARY KEY  (`uid`)
33 
+) TYPE=MyISAM;
34 
+CREATE TABLE `fanfiction_blocks` (
35 
+  `block_id` int(11) NOT NULL auto_increment,
36 
+  `block_name` varchar(30) NOT NULL default '',
37 
+  `block_title` varchar(150) NOT NULL default '',
38 
+  `block_file` varchar(200) NOT NULL default '',
39 
+  `block_status` tinyint(1) NOT NULL default '0',
40 
+  `block_variables` text NOT NULL,
41 
+  PRIMARY KEY  (`block_id`),
42 
+  KEY `block_name` (`block_name`)
43 
+) TYPE=MyISAM;
44 
+CREATE TABLE `fanfiction_chapters` (
45 
+  `chapid` int(11) NOT NULL auto_increment,
46 
+  `title` varchar(250) NOT NULL default '',
47 
+  `inorder` int(11) NOT NULL default '0',
48 
+  `notes` text NULL,
49 
+  `storytext` text NULL,
50 
+  `endnotes` text NULL,
51 
+  `validated` char(1) NOT NULL default '0',
52 
+  `wordcount` int(11) NOT NULL default '0',
53 
+  `rating` tinyint(4) NOT NULL default '0',
54 
+  `reviews` smallint(6) NOT NULL default '0',
55 
+  `sid` int(11) NOT NULL default '0',
56 
+  `uid` int(11) NOT NULL default '0',
57 
+  `count` int(11) NOT NULL default '0',
58 
+  PRIMARY KEY  (`chapid`),
59 
+  KEY `sid` (`sid`),
60 
+  KEY `uid` (`uid`),
61 
+  KEY `inorder` (`inorder`),
62 
+  KEY `title` (`title`),
63 
+  KEY `validated` (`validated`)
64 
+) TYPE=MyISAM;
65 
+CREATE TABLE `fanfiction_classes` (
66 
+  `class_id` int(11) NOT NULL auto_increment,
67 
+  `class_type` int(11) NOT NULL default '0',
68 
+  `class_name` varchar(100) NOT NULL default '',
69 
+  PRIMARY KEY  (`class_id`)
70 
+) TYPE=MyISAM;
71 
+CREATE TABLE `fanfiction_classtypes` (
72 
+  `classtype_id` int(11) NOT NULL auto_increment,
73 
+  `classtype_name` varchar(50) NOT NULL default '',
74 
+  `classtype_title` varchar(50) NOT NULL default '',
75 
+  PRIMARY KEY  (`classtype_id`),
76 
+  KEY `classtype_title` (`classtype_title`)
77 
+) TYPE=MyISAM;
78 
+CREATE TABLE `fanfiction_codeblocks` (
79 
+  `code_id` int(11) NOT NULL auto_increment,
80 
+  `code_text` text NOT NULL,
81 
+  `code_type` varchar(20) default NULL,
82 
+  `code_module` varchar(60) default NULL,
83 
+  PRIMARY KEY  (`code_id`)
84 
+) TYPE=MyISAM;
85 
+CREATE TABLE `fanfiction_favorites` (
86 
+  `uid` int(11) NOT NULL default '0',
87 
+  `item` int(11) NOT NULL default '0',
88 
+  `type` char(2) NOT NULL default '',
89 
+  `comments` text NULL,
90 
+  KEY `uid` (`uid`)
91 
+) TYPE=MyISAM;
92 
+CREATE TABLE `fanfiction_inseries` (
93 
+  `seriesid` int(11) NOT NULL default '0',
94 
+  `sid` int(11) NOT NULL default '0',
95 
+  `subseriesid` int(11) NOT NULL default '0',
96 
+  `confirmed` int(11) NOT NULL default '0',
97 
+  `inorder` int(11) NOT NULL default '0',
98 
+  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
99 
+  KEY `sid` (`sid`),
100 
+  KEY `inorder` (`inorder`),
101 
+  KEY `seriesid` (`seriesid`)
102 
+) TYPE=MyISAM;
103 
+CREATE TABLE `fanfiction_log` (
104 
+  `log_id` int(11) NOT NULL auto_increment,
105 
+  `log_action` varchar(255) default NULL,
106 
+  `log_uid` int(11) NOT NULL,
107 
+  `log_ip` int(11) default NULL,
108 
+  `log_timestamp` timestamp NOT NULL,
109 
+  `log_type` varchar(2) NOT NULL,
110 
+  PRIMARY KEY  (`log_id`)
111 
+) TYPE=MyISAM
112 
+CREATE TABLE `fanfiction_messages` (
113 
+  `message_id` int(11) NOT NULL auto_increment,
114 
+  `message_name` varchar(50) NOT NULL default '',
115 
+  `message_title` varchar(200) NOT NULL default '',
116 
+  `message_text` text NULL,
117 
+  PRIMARY KEY  (`message_id`)
118 
+) TYPE=MyISAM;
119 
+CREATE TABLE `".$tableprefix."fanfiction_modules` (
120 
+  `id` int(11) NOT NULL auto_increment,
121 
+  `name` varchar(100) NOT NULL default 'Test Module',
122 
+  `version` varchar(10) NOT NULL default '1.0',
123 
+  PRIMARY KEY  (`id`),
124 
+  KEY `name_version` (`name`,`version`)
125 
+) TYPE=MyISAM;
126 
+CREATE TABLE `fanfiction_pagelinks` (
127 
+  `link_id` int(11) NOT NULL auto_increment,
128 
+  `link_name` varchar(50) NOT NULL default '',
129 
+  `link_text` varchar(100) NOT NULL default '',
130 
+  `link_url` varchar(250) NOT NULL default '',
131 
+  `link_target` char(1) NOT NULL default '0',
132 
+  `link_access` tinyint(4) NOT NULL default '0',
133 
+  PRIMARY KEY  (`link_id`),
134 
+  KEY `link_text` (`link_text`),
135 
+  KEY `link_name` (`link_name`)
136 
+) TYPE=MyISAM;
137 
+CREATE TABLE `fanfiction_panels` (
138 
+  `panel_id` int(11) NOT NULL auto_increment,
139 
+  `panel_name` varchar(50) NOT NULL default 'unknown',
140 
+  `panel_title` varchar(100) NOT NULL default 'Unnamed Panel',
141 
+  `panel_url` varchar(100) default NULL,
142 
+  `panel_level` tinyint(4) NOT NULL default '3',
143 
+  `panel_order` tinyint(4) NOT NULL default '0',
144 
+  `panel_hidden` tinyint(1) NOT NULL default '0',
145 
+  `panel_type` varchar(20) NOT NULL default 'A',
146 
+  PRIMARY KEY  (`panel_id`),
147 
+  KEY `panel_hidden` (`panel_hidden`),
148 
+  KEY `panel_type` (`panel_type`)
149 
+) TYPE=MyISAM;
150 
+CREATE TABLE `fanfiction_series` (
151 
+  `seriesid` int(11) NOT NULL auto_increment,
152 
+  `title` varchar(200) NOT NULL default '',
153 
+  `summary` text NOT NULL,
154 
+  `uid` int(11) NOT NULL default '0',
155 
+  `isopen` tinyint(4) NOT NULL default '0',
156 
+  `catid` varchar(200) NOT NULL default '0',
157 
+  `rating` tinyint(4) NOT NULL default '0',
158 
+  `classes` varchar(200) NOT NULL default '',
159 
+  `characters` varchar(250) NOT NULL default '',
160 
+  `reviews` smallint(6) NOT NULL default '0',
161 
+  `challenges` varchar(200) NOT NULL default '',
162 
+  PRIMARY KEY  (`seriesid`),
163 
+  KEY `owner` (`uid`),
164 
+  KEY `catid` (`catid`),
165 
+  KEY `challenges` (`challenges`),
166 
+  KEY `characters` (`characters`),
167 
+  KEY `classes` (`classes`)
168 
+) TYPE=MyISAM;
169 
+
170 
+CREATE TABLE `fanfiction_stats` (
171 
+  `sitekey` varchar(50) NOT NULL default '0',
172 
+  `stories` int(11) NOT NULL default '0',
173 
+  `chapters` int(11) NOT NULL default '0',
174 
+  `series` int(11) NOT NULL default '0',
175 
+  `reviews` int(11) NOT NULL default '0',
176 
+  `wordcount` int(11) NOT NULL default '0',
177 
+  `authors` int(11) NOT NULL default '0',
178 
+  `members` int(11) NOT NULL default '0',
179 
+  `reviewers` int(11) NOT NULL default '0',
180 
+  `newestmember` int(11) NOT NULL default '0'
181 
+) TYPE=MyISAM;