ページ情報のDB化に取り掛かります

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76

-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
!
 
-
|
|
|
|
|
|
|
!
 
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
!
 
-
|
|
|
!
 
-
|
|
|
|
!
 
-
|
|
|
|
|
|
|
|
|
|
!

CREATE TABLE `attach` (
  `id` int(11) NOT NULL auto_increment,
  `pgid` int(11) NOT NULL default '0',
  `name` varchar(255) binary NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `mtime` int(11) NOT NULL default '0',
  `size` int(11) NOT NULL default '0',
  `mode` varchar(20) NOT NULL default '',
  `count` int(11) NOT NULL default '0',
  `age` tinyint(4) NOT NULL default '0',
  `pass` varchar(16) binary NOT NULL default '',
  `freeze` tinyint(1) NOT NULL default '0',
  `copyright` tinyint(1) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  UNIQUE KEY `id` (`id`),
  KEY `pgid` (`pgid`),
  KEY `owner` (`owner`)
) TYPE=MyISAM;
 
CREATE TABLE `count` (
  `pgid` int(11) NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  `today` varchar(10) NOT NULL default '',
  `today_count` int(11) NOT NULL default '0',
  `yesterday_count` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`pgid`)
) TYPE=MyISAM;
 
CREATE TABLE `pginfo` (
  `pgid` int(11) NOT NULL auto_increment,
  `name` varchar(255) binary NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `buildtime` int(11) NOT NULL default '0',
  `editedtime` int(11) NOT NULL default '0',
  `uid` mediumint(8) NOT NULL default '0',
  `ucd` varchar(12) NOT NULL default '',
  `username` varchar(255) NOT NULL default '',
  `freeze` tinyint(1) NOT NULL default '0',
  `aids` text NOT NULL,
  `gids` varchar(255) NOT NULL default '',
  `vaids` text NOT NULL,
  `vgids` varchar(255) NOT NULL default '',
  `lastediter_uid` mediumint(8) NOT NULL default '0',
  `lastediter_ucd` varchar(12) NOT NULL default '',
  `lastediter_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`pgid`),
  UNIQUE KEY `name` (`name`),
  KEY `uid` (`uid`)
) TYPE=MyISAM;
 
CREATE TABLE `plain` (
  `pgid` int(11) NOT NULL default '0',
  `plain` text NOT NULL,
  PRIMARY KEY  (`pgid`)
) TYPE=MyISAM;
 
CREATE TABLE `rel` (
  `pgid` int(11) NOT NULL default '0',
  `relid` int(11) NOT NULL default '0',
  KEY `pgid` (`pgid`),
  KEY `relid` (`relid`)
) TYPE=MyISAM;
 
CREATE TABLE `tb` (
  `tbid` varchar(32) NOT NULL default '',
  `pgid` int(11) NOT NULL default '0',
  `last_time` int(11) NOT NULL default '0',
  `url` text NOT NULL,
  `title` varchar(255) NOT NULL default '',
  `excerpt` text NOT NULL,
  `blog_name` varchar(255) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  KEY `tbid` (`tbid`),
  KEY `pgid` (`pgid`)
) TYPE=MyISAM;