summaryrefslogtreecommitdiff
path: root/mysql.tables
blob: 12d2653c467ed7d15c41dcea9726541e7a86d555 (plain)
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149

CREATE TABLE authors (
  aid varchar(30) DEFAULT '' NOT NULL,
  name varchar(50),
  url varchar(60),
  email varchar(60),
  pwd varchar(12),
  PRIMARY KEY (aid)
);

CREATE TABLE bans (
  id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
  mask varchar(255) DEFAULT '' NOT NULL,
  type tinyint(2) DEFAULT '0' NOT NULL,
  reason text NOT NULL,
  timestamp int(11),
  UNIQUE mask (mask),
  PRIMARY KEY (id)
);

CREATE TABLE blocks (
  id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
  author varchar(30),
  title varchar(60),
  content text,
  PRIMARY KEY (id)
);

CREATE TABLE channel (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  site varchar(255) DEFAULT '' NOT NULL,
  file varchar(255) DEFAULT '' NOT NULL,
  url varchar(255) DEFAULT '' NOT NULL,
  contact varchar(255) DEFAULT '',
  timestamp int(11),
  UNIQUE site (site),
  UNIQUE file (file),
  UNIQUE url (url),
  PRIMARY KEY (id)
);

CREATE TABLE comments (
  tid int(11) DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0',
  sid int(11) DEFAULT '0',
  date datetime,
  name varchar(60) DEFAULT '' NOT NULL,
  email varchar(60),
  url varchar(60),
  host_name varchar(60),
  subject varchar(60) DEFAULT '' NOT NULL,
  comment text NOT NULL,
  score tinyint(4) DEFAULT '0' NOT NULL,
  reason tinyint(4) DEFAULT '0' NOT NULL,
  PRIMARY KEY (tid)
);

CREATE TABLE headlines (
  id int(11) DEFAULT '0' NOT NULL,
  title varchar(255) DEFAULT '' NOT NULL,
  link varchar(255) DEFAULT '' NOT NULL,
  number int(3) DEFAULT '0' NOT NULL,
  UNIQUE title (title),
  UNIQUE link (link)
);

CREATE TABLE poll (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  question varchar(150),
  answer1 varchar(100),
  answer2 varchar(100),
  answer3 varchar(100),
  answer4 varchar(100),
  answer5 varchar(100),
  answer6 varchar(100),
  votes1 tinyint(4),
  votes2 tinyint(4),
  votes3 tinyint(4),
  votes4 tinyint(4),
  votes5 tinyint(4),
  votes6 tinyint(4),
  status tinyint(4) DEFAULT '0',
  PRIMARY KEY (id)
);


CREATE TABLE refer (
  url varchar(255) DEFAULT '' NOT NULL,
  name varchar(255),
  status int(1) DEFAULT '1',
  refers int(7) DEFAULT '0',
  create_dt int(11),
  access_dt int(11),
  PRIMARY KEY (url)
);

CREATE TABLE stories (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  author int(6) DEFAULT '0' NOT NULL,
  subject varchar(255) DEFAULT '' NOT NULL,
  abstract text NOT NULL,
  updates text NOT NULL,
  article text NOT NULL,
  category varchar(128) DEFAULT '' NOT NULL,
  department varchar(128) DEFAULT '' NOT NULL,
  timestamp int(11) DEFAULT '0' NOT NULL,
  score int(11) DEFAULT '0' NOT NULL,
  votes int(11) DEFAULT '0' NOT NULL,
  status int(4) DEFAULT '1',
  PRIMARY KEY (id)
);

CREATE TABLE users (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  name varchar(60) DEFAULT '' NOT NULL,
  userid varchar(15) DEFAULT '' NOT NULL,
  passwd varchar(20) DEFAULT '' NOT NULL,
  email varchar(255) DEFAULT '' NOT NULL,
  femail varchar(60) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
  storynum tinyint(4) DEFAULT '10',
  umode varchar(10) DEFAULT '' NOT NULL,
  uorder tinyint(1) DEFAULT '0' NOT NULL,
  thold tinyint(1) DEFAULT '0' NOT NULL,
  noscore tinyint(1) DEFAULT '0' NOT NULL,
  bio tinytext NOT NULL,
  ublockon tinyint(1) DEFAULT '0' NOT NULL,
  ublock text,
  theme varchar(255) DEFAULT '' NOT NULL,
  signature varchar(255) DEFAULT '' NOT NULL,
  last_access int(10) unsigned,
  last_host varchar(255),
  access int(10) unsigned DEFAULT '0' NOT NULL,
  status tinyint(4) DEFAULT '0' NOT NULL,
  history text NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE webboard (
  topic_id int(11) DEFAULT '0' NOT NULL auto_increment,
  parent_id int(11) DEFAULT '0',
  root_id int(11) DEFAULT '0',
  subject varchar(255),
  message text,
  create_dt int(11) DEFAULT '0',
  author varchar(255),
  hostname varchar(255),
  PRIMARY KEY (topic_id)
);