質問編集履歴
2
テーブル名の詳細記載
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -230,7 +230,15 @@
|
|
|
230
230
|
|
|
231
231
|
```ここに言語を入力
|
|
232
232
|
|
|
233
|
-
|
|
233
|
+
mysql> SHOW CREATE TABLE incount;
|
|
234
|
+
|
|
235
|
+
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
236
|
+
|
|
237
|
+
| Table | Create Table |
|
|
238
|
+
|
|
239
|
+
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
240
|
+
|
|
241
|
+
| incount | CREATE TABLE `incount` (
|
|
234
242
|
|
|
235
243
|
`id` int(20) NOT NULL AUTO_INCREMENT,
|
|
236
244
|
|
|
@@ -248,6 +256,12 @@
|
|
|
248
256
|
|
|
249
257
|
PRIMARY KEY (`id`)
|
|
250
258
|
|
|
259
|
+
) ENGINE=InnoDB AUTO_INCREMENT=649 DEFAULT CHARSET=utf8 |
|
|
260
|
+
|
|
261
|
+
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
262
|
+
|
|
263
|
+
|
|
264
|
+
|
|
251
265
|
|
|
252
266
|
|
|
253
267
|
```
|
|
@@ -258,7 +272,15 @@
|
|
|
258
272
|
|
|
259
273
|
```ここに言語を入力
|
|
260
274
|
|
|
261
|
-
|
|
275
|
+
mysql> SHOW CREATE TABLE outcount;
|
|
276
|
+
|
|
277
|
+
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
278
|
+
|
|
279
|
+
| Table | Create Table |
|
|
280
|
+
|
|
281
|
+
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
282
|
+
|
|
283
|
+
| outcount | CREATE TABLE `outcount` (
|
|
262
284
|
|
|
263
285
|
`id` int(50) NOT NULL AUTO_INCREMENT,
|
|
264
286
|
|
|
@@ -274,6 +296,12 @@
|
|
|
274
296
|
|
|
275
297
|
PRIMARY KEY (`id`)
|
|
276
298
|
|
|
299
|
+
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 |
|
|
300
|
+
|
|
301
|
+
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
302
|
+
|
|
303
|
+
|
|
304
|
+
|
|
277
305
|
```
|
|
278
306
|
|
|
279
307
|
|
|
@@ -282,7 +310,15 @@
|
|
|
282
310
|
|
|
283
311
|
```ここに言語を入力
|
|
284
312
|
|
|
285
|
-
|
|
313
|
+
mysql> SHOW CREATE TABLE site;
|
|
314
|
+
|
|
315
|
+
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
316
|
+
|
|
317
|
+
| Table | Create Table |
|
|
318
|
+
|
|
319
|
+
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
320
|
+
|
|
321
|
+
| site | CREATE TABLE `site` (
|
|
286
322
|
|
|
287
323
|
`id` int(22) NOT NULL AUTO_INCREMENT,
|
|
288
324
|
|
|
@@ -306,6 +342,10 @@
|
|
|
306
342
|
|
|
307
343
|
PRIMARY KEY (`id`)
|
|
308
344
|
|
|
309
|
-
|
|
310
|
-
|
|
311
|
-
|
|
345
|
+
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 |
|
|
346
|
+
|
|
347
|
+
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
348
|
+
|
|
349
|
+
|
|
350
|
+
|
|
351
|
+
```
|
1
テーブル内容を記載しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -213,3 +213,99 @@
|
|
|
213
213
|
お力をお貸し頂けると嬉しいです。
|
|
214
214
|
|
|
215
215
|
どうかよろしくお願いします。
|
|
216
|
+
|
|
217
|
+
|
|
218
|
+
|
|
219
|
+
---
|
|
220
|
+
|
|
221
|
+
|
|
222
|
+
|
|
223
|
+
テーブルの構造です。
|
|
224
|
+
|
|
225
|
+
遅れてしまって申し訳ありません。
|
|
226
|
+
|
|
227
|
+
|
|
228
|
+
|
|
229
|
+
テーブル名：incount
|
|
230
|
+
|
|
231
|
+
```ここに言語を入力
|
|
232
|
+
|
|
233
|
+
incount | CREATE TABLE `incount` (
|
|
234
|
+
|
|
235
|
+
`id` int(20) NOT NULL AUTO_INCREMENT,
|
|
236
|
+
|
|
237
|
+
`datetime` datetime NOT NULL,
|
|
238
|
+
|
|
239
|
+
`ip` varchar(50) NOT NULL,
|
|
240
|
+
|
|
241
|
+
`url_file` varchar(255) NOT NULL,
|
|
242
|
+
|
|
243
|
+
`referer` varchar(255) NOT NULL,
|
|
244
|
+
|
|
245
|
+
`user_agent` varchar(255) NOT NULL,
|
|
246
|
+
|
|
247
|
+
`created` datetime NOT NULL,
|
|
248
|
+
|
|
249
|
+
PRIMARY KEY (`id`)
|
|
250
|
+
|
|
251
|
+
|
|
252
|
+
|
|
253
|
+
```
|
|
254
|
+
|
|
255
|
+
|
|
256
|
+
|
|
257
|
+
テーブル名：outcount
|
|
258
|
+
|
|
259
|
+
```ここに言語を入力
|
|
260
|
+
|
|
261
|
+
カラム名：
|
|
262
|
+
|
|
263
|
+
`id` int(50) NOT NULL AUTO_INCREMENT,
|
|
264
|
+
|
|
265
|
+
`datetime` datetime NOT NULL,
|
|
266
|
+
|
|
267
|
+
`ip` varchar(100) NOT NULL,
|
|
268
|
+
|
|
269
|
+
`out_url` varchar(255) NOT NULL,
|
|
270
|
+
|
|
271
|
+
`user_agent` varchar(255) NOT NULL,
|
|
272
|
+
|
|
273
|
+
`created` datetime NOT NULL,
|
|
274
|
+
|
|
275
|
+
PRIMARY KEY (`id`)
|
|
276
|
+
|
|
277
|
+
```
|
|
278
|
+
|
|
279
|
+
|
|
280
|
+
|
|
281
|
+
テーブル名：site
|
|
282
|
+
|
|
283
|
+
```ここに言語を入力
|
|
284
|
+
|
|
285
|
+
カラム名：
|
|
286
|
+
|
|
287
|
+
`id` int(22) NOT NULL AUTO_INCREMENT,
|
|
288
|
+
|
|
289
|
+
`name` varchar(120) NOT NULL,
|
|
290
|
+
|
|
291
|
+
`url` varchar(200) NOT NULL,
|
|
292
|
+
|
|
293
|
+
`siterss` varchar(200) NOT NULL,
|
|
294
|
+
|
|
295
|
+
`sitedomain` varchar(100) NOT NULL,
|
|
296
|
+
|
|
297
|
+
`incount` int(20) NOT NULL DEFAULT '0',
|
|
298
|
+
|
|
299
|
+
`outcount` int(20) NOT NULL DEFAULT '0',
|
|
300
|
+
|
|
301
|
+
`henkan` float NOT NULL DEFAULT '0',
|
|
302
|
+
|
|
303
|
+
`rsscount` int(10) NOT NULL DEFAULT '0',
|
|
304
|
+
|
|
305
|
+
`lastdate` datetime NOT NULL,
|
|
306
|
+
|
|
307
|
+
PRIMARY KEY (`id`)
|
|
308
|
+
|
|
309
|
+
|
|
310
|
+
|
|
311
|
+
```
|