CW Cyrix's Git Repository Mirror
Browse code

deleted old updates files

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

Start Point - version 3.5.5 + fixes

Jimako authored on 2023/09/05 17:01:08
Showing 1 changed files
docs/upgrade20_step4.sql
History View file @ b1be196
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,230 @@
1 
+
2 
+-- --------------------------------------------------------
3 
+
4 
+--
5 
+-- Table structure for table `fanfiction_authorfields`
6 
+--
7 
+
8 
+CREATE TABLE `fanfiction_authorfields` (
9 
+  `field_id` int(11) NOT NULL auto_increment,
10 
+  `field_type` tinyint(4) NOT NULL default '0',
11 
+  `field_name` varchar(30) NOT NULL default ' ',
12 
+  `field_title` varchar(255) NOT NULL default ' ',
13 
+  `field_options` text,
14 
+  `field_code_in` text,
15 
+  `field_code_out` text,
16 
+  `field_on` tinyint(1) NOT NULL default '0',
17 
+  PRIMARY KEY  (`field_id`)
18 
+) ;
19 
+
20 
+-- --------------------------------------------------------
21 
+
22 
+--
23 
+-- Table structure for table `fanfiction_authorinfo`
24 
+--
25 
+
26 
+CREATE TABLE `fanfiction_authorinfo` (
27 
+  `uid` int(11) NOT NULL default '0',
28 
+  `field` int(11) NOT NULL default '0',
29 
+  `info` varchar(255) NOT NULL default ' ',
30 
+  KEY `uid` (`uid`)
31 
+);
32 
+
33 
+-- --------------------------------------------------------
34 
+
35 
+--
36 
+-- Table structure for table `fanfiction_authorprefs`
37 
+--
38 
+
39 
+CREATE TABLE `fanfiction_authorprefs` (
40 
+  `uid` int(11) NOT NULL default '0',
41 
+  `newreviews` tinyint(1) NOT NULL default '0',
42 
+  `newrespond` tinyint(1) NOT NULL default '0',
43 
+  `ageconsent` tinyint(1) NOT NULL default '0',
44 
+  `alertson` tinyint(1) NOT NULL default '0',
45 
+  `tinyMCE` tinyint(1) NOT NULL default '0',
46 
+  `sortby` tinyint(1) NOT NULL default '0',
47 
+  `storyindex` tinyint(1) NOT NULL default '0',
48 
+  `validated` tinyint(1) NOT NULL default '0',
49 
+  `userskin` varchar(60) NOT NULL default 'default',
50 
+  `level` tinyint(1) NOT NULL default '0',
51 
+  `categories` varchar(200) NOT NULL default '0',
52 
+  `contact` tinyint(1) NOT NULL default '0',
53 
+  PRIMARY KEY  (`uid`)
54 
+);
55 
+
56 
+
57 
+-- --------------------------------------------------------
58 
+
59 
+--
60 
+-- Table structure for table `fanfiction_blocks`
61 
+--
62 
+
63 
+CREATE TABLE `fanfiction_blocks` (
64 
+  `block_id` int(11) NOT NULL auto_increment,
65 
+  `block_name` varchar(30) NOT NULL default '',
66 
+  `block_title` varchar(150) NOT NULL default '',
67 
+  `block_file` varchar(200) NOT NULL default '',
68 
+  `block_status` tinyint(1) NOT NULL default '0',
69 
+  `block_variables` text NOT NULL,
70 
+  PRIMARY KEY  (`block_id`),
71 
+  KEY `block_name` (`block_name`)
72 
+);
73 
+
74 
+-- --------------------------------------------------------
75 
+
76 
+--
77 
+-- Table structure for table `fanfiction_classes`
78 
+--
79 
+
80 
+CREATE TABLE `fanfiction_classes` (
81 
+  `class_id` int(11) NOT NULL auto_increment,
82 
+  `class_type` int(11) NOT NULL default '0',
83 
+  `class_name` varchar(100) NOT NULL default '',
84 
+  PRIMARY KEY  (`class_id`)
85 
+);
86 
+
87 
+-- --------------------------------------------------------
88 
+
89 
+--
90 
+-- Table structure for table `fanfiction_classtypes`
91 
+--
92 
+
93 
+CREATE TABLE `fanfiction_classtypes` (
94 
+  `classtype_id` int(11) NOT NULL auto_increment,
95 
+  `classtype_name` varchar(50) NOT NULL default '',
96 
+  `classtype_title` varchar(50) NOT NULL default '',
97 
+  PRIMARY KEY  (`classtype_id`),
98 
+  KEY `classtype_title` (`classtype_title`)
99 
+);
100 
+
101 
+-- --------------------------------------------------------
102 
+
103 
+--
104 
+-- Table structure for table `fanfiction_codeblocks`
105 
+--
106 
+
107 
+CREATE TABLE `fanfiction_codeblocks` (
108 
+  `code_id` int(11) NOT NULL auto_increment,
109 
+  `code_text` text NOT NULL,
110 
+  `code_type` varchar(20) default NULL,
111 
+  `code_module` varchar(60) default NULL,
112 
+  PRIMARY KEY  (`code_id`)
113 
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
114 
+
115 
+-- --------------------------------------------------------
116 
+
117 
+--
118 
+-- Table structure for table `fanfiction_favorites`
119 
+--
120 
+
121 
+CREATE TABLE `fanfiction_favorites` (
122 
+  `uid` int(11) NOT NULL default '0',
123 
+  `item` int(11) NOT NULL default '0',
124 
+  `type` char(2) NOT NULL default '',
125 
+  `comments` text NOT NULL,
126 
+  KEY `uid` (`uid`)
127 
+);
128 
+
129 
+
130 
+-- --------------------------------------------------------
131 
+
132 
+--
133 
+-- Table structure for table `fanfiction_log`
134 
+--
135 
+
136 
+CREATE TABLE `fanfiction_log` (
137 
+  `log_id` int(11) NOT NULL auto_increment,
138 
+  `log_action` varchar(255) default NULL,
139 
+  `log_uid` int(11) NOT NULL,
140 
+  `log_ip` int(11) default NULL,
141 
+  `log_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
142 
+  `log_type` varchar(2) NOT NULL,
143 
+  PRIMARY KEY  (`log_id`)
144 
+);
145 
+
146 
+-- --------------------------------------------------------
147 
+
148 
+--
149 
+-- Table structure for table `fanfiction_messages`
150 
+--
151 
+
152 
+CREATE TABLE `fanfiction_messages` (
153 
+  `message_id` int(11) NOT NULL auto_increment,
154 
+  `message_name` varchar(50) NOT NULL default '',
155 
+  `message_title` varchar(200) NOT NULL default '',
156 
+  `message_text` text NOT NULL,
157 
+  PRIMARY KEY  (`message_id`)
158 
+);
159 
+
160 
+
161 
+-- --------------------------------------------------------
162 
+--
163 
+-- Table structure for table `fanfiction_modules`
164 
+--
165 
+
166 
+CREATE TABLE `fanfiction_modules` (
167 
+  `id` int(11) NOT NULL auto_increment,
168 
+  `name` varchar(100) NOT NULL default 'Test Module',
169 
+  `version` varchar(10) NOT NULL default '1.0',
170 
+  PRIMARY KEY  (`id`),
171 
+  KEY `name_version` (`name`,`version`)
172 
+);
173 
+
174 
+-- --------------------------------------------------------
175 
+
176 
+--
177 
+-- Table structure for table `fanfiction_pagelinks`
178 
+--
179 
+
180 
+CREATE TABLE `fanfiction_pagelinks` (
181 
+  `link_id` int(11) NOT NULL auto_increment,
182 
+  `link_name` varchar(50) NOT NULL default '',
183 
+  `link_text` varchar(100) NOT NULL default '',
184 
+  `link_url` varchar(250) NOT NULL default '',
185 
+  `link_target` char(1) NOT NULL default '0',
186 
+  `link_access` tinyint(4) NOT NULL default '0',
187 
+  PRIMARY KEY  (`link_id`),
188 
+  KEY `link_text` (`link_text`),
189 
+  KEY `link_name` (`link_name`)
190 
+);
191 
+
192 
+-- --------------------------------------------------------
193 
+
194 
+--
195 
+-- Table structure for table `fanfiction_panels`
196 
+--
197 
+
198 
+CREATE TABLE `fanfiction_panels` (
199 
+  `panel_id` int(11) NOT NULL auto_increment,
200 
+  `panel_name` varchar(50) NOT NULL default 'unknown',
201 
+  `panel_title` varchar(100) NOT NULL default 'Unnamed Panel',
202 
+  `panel_url` varchar(100) default NULL,
203 
+  `panel_level` tinyint(4) NOT NULL default '3',
204 
+  `panel_order` tinyint(4) NOT NULL default '0',
205 
+  `panel_hidden` tinyint(1) NOT NULL default '0',
206 
+  `panel_type` varchar(20) NOT NULL default 'A',
207 
+  PRIMARY KEY  (`panel_id`),
208 
+  KEY `panel_hidden` (`panel_hidden`),
209 
+  KEY `panel_type` (`panel_type`)
210 
+);
211 
+
212 
+-- --------------------------------------------------------
213 
+--
214 
+-- Table structure for table `fanfiction_stats`
215 
+--
216 
+
217 
+CREATE TABLE `fanfiction_stats` (
218 
+  `sitekey` varchar(50) NOT NULL default '0',
219 
+  `stories` int(11) NOT NULL default '0',
220 
+  `chapters` int(11) NOT NULL default '0',
221 
+  `series` int(11) NOT NULL default '0',
222 
+  `reviews` int(11) NOT NULL default '0',
223 
+  `wordcount` int(11) NOT NULL default '0',
224 
+  `authors` int(11) NOT NULL default '0',
225 
+  `members` int(11) NOT NULL default '0',
226 
+  `reviewers` int(11) NOT NULL default '0',
227 
+  `newestmember` int(11) NOT NULL default '0'
228 
+) ENGINE=MyISAM;
229 
+
230 
+