QiNsjb7B

1DROP TABLE IF EXISTS wp_users;
2CREATE TABLE wp_users (
3  ID bigint(20) unsigned NOT NULL auto_increment,
4  user_login varchar(60) NOT NULL default '',
5  user_pass varchar(64) NOT NULL default '',
6  user_nicename varchar(50) NOT NULL default '',
7  user_email varchar(100) NOT NULL default '',
8  user_url varchar(100) NOT NULL default '',
9  user_registered datetime NOT NULL default '0000-00-00 00:00:00',
10  user_activation_key varchar(60) NOT NULL default '',
11  user_status int(11) NOT NULL default '0',
12  display_name varchar(250) NOT NULL default '',
13  spam tinyint(2) NOT NULL default '0',
14  deleted tinyint(2) NOT NULL default '0',
15  PRIMARY KEY  (ID),
16  KEY user_login_key (user_login),
17  KEY user_nicename (user_nicename)
18) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
19
20DROP TABLE IF EXISTS wp_usermeta;
21CREATE TABLE wp_usermeta (
22  umeta_id bigint(20) unsigned NOT NULL auto_increment,
23  user_id bigint(20) unsigned NOT NULL default '0',
24  meta_key varchar(255) default NULL,
25  meta_value longtext,
26  PRIMARY KEY  (umeta_id),
27  KEY user_id (user_id),
28  KEY meta_key (meta_key)
29) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
30
31DROP TABLE IF EXISTS wp_terms;
32CREATE TABLE wp_terms (
33 term_id bigint(20) unsigned NOT NULL auto_increment,
34 name varchar(200) NOT NULL default '',
35 slug varchar(200) NOT NULL default '',
36 term_group bigint(10) NOT NULL default 0,
37 PRIMARY KEY  (term_id),
38 KEY slug (slug),
39 KEY name (name)
40) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
41
42DROP TABLE IF EXISTS wp_term_taxonomy;
43CREATE TABLE wp_term_taxonomy (
44 term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment,
45 term_id bigint(20) unsigned NOT NULL default 0,
46 taxonomy varchar(32) NOT NULL default '',
47 description longtext NOT NULL,
48 parent bigint(20) unsigned NOT NULL default 0,
49 count bigint(20) NOT NULL default 0,
50 PRIMARY KEY  (term_taxonomy_id),
51 UNIQUE KEY term_id_taxonomy (term_id,taxonomy),
52 KEY taxonomy (taxonomy)
53) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
54
55DROP TABLE IF EXISTS wp_term_relationships;
56CREATE TABLE wp_term_relationships (
57 object_id bigint(20) unsigned NOT NULL default 0,
58 term_taxonomy_id bigint(20) unsigned NOT NULL default 0,
59 term_order int(11) NOT NULL default 0,
60 PRIMARY KEY  (object_id,term_taxonomy_id),
61 KEY term_taxonomy_id (term_taxonomy_id)
62) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
63
64DROP TABLE IF EXISTS wp_commentmeta;
65CREATE TABLE wp_commentmeta (
66  meta_id bigint(20) unsigned NOT NULL auto_increment,
67  comment_id bigint(20) unsigned NOT NULL default '0',
68  meta_key varchar(255) default NULL,
69  meta_value longtext,
70  PRIMARY KEY  (meta_id),
71  KEY comment_id (comment_id),
72  KEY meta_key (meta_key)
73) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
74
75DROP TABLE IF EXISTS wp_comments;
76CREATE TABLE wp_comments (
77  comment_ID bigint(20) unsigned NOT NULL auto_increment,
78  comment_post_ID bigint(20) unsigned NOT NULL default '0',
79  comment_author tinytext NOT NULL,
80  comment_author_email varchar(100) NOT NULL default '',
81  comment_author_url varchar(200) NOT NULL default '',
82  comment_author_IP varchar(100) NOT NULL default '',
83  comment_date datetime NOT NULL default '0000-00-00 00:00:00',
84  comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
85  comment_content text NOT NULL,
86  comment_karma int(11) NOT NULL default '0',
87  comment_approved varchar(20) NOT NULL default '1',
88  comment_agent varchar(255) NOT NULL default '',
89  comment_type varchar(20) NOT NULL default '',
90  comment_parent bigint(20) unsigned NOT NULL default '0',
91  user_id bigint(20) unsigned NOT NULL default '0',
92  PRIMARY KEY  (comment_ID),
93  KEY comment_post_ID (comment_post_ID),
94  KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
95  KEY comment_date_gmt (comment_date_gmt),
96  KEY comment_parent (comment_parent),
97  KEY comment_author_email (comment_author_email(10))
98) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
99
100DROP TABLE IF EXISTS wp_links;
101CREATE TABLE wp_links (
102  link_id bigint(20) unsigned NOT NULL auto_increment,
103  link_url varchar(255) NOT NULL default '',
104  link_name varchar(255) NOT NULL default '',
105  link_image varchar(255) NOT NULL default '',
106  link_target varchar(25) NOT NULL default '',
107  link_description varchar(255) NOT NULL default '',
108  link_visible varchar(20) NOT NULL default 'Y',
109  link_owner bigint(20) unsigned NOT NULL default '1',
110  link_rating int(11) NOT NULL default '0',
111  link_updated datetime NOT NULL default '0000-00-00 00:00:00',
112  link_rel varchar(255) NOT NULL default '',
113  link_notes mediumtext NOT NULL,
114  link_rss varchar(255) NOT NULL default '',
115  PRIMARY KEY  (link_id),
116  KEY link_visible (link_visible)
117) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
118
119DROP TABLE IF EXISTS wp_options;
120CREATE TABLE wp_options (
121  option_id bigint(20) unsigned NOT NULL auto_increment,
122  option_name varchar(64) NOT NULL default '',
123  option_value longtext NOT NULL,
124  autoload varchar(20) NOT NULL default 'yes',
125  PRIMARY KEY  (option_id),
126  UNIQUE KEY option_name (option_name)
127) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
128
129DROP TABLE IF EXISTS wp_postmeta;
130CREATE TABLE wp_postmeta (
131  meta_id bigint(20) unsigned NOT NULL auto_increment,
132  post_id bigint(20) unsigned NOT NULL default '0',
133  meta_key varchar(255) default NULL,
134  meta_value longtext,
135  PRIMARY KEY  (meta_id),
136  KEY post_id (post_id),
137  KEY meta_key (meta_key)
138) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
139
140DROP TABLE IF EXISTS wp_posts;
141CREATE TABLE wp_posts (
142  ID bigint(20) unsigned NOT NULL auto_increment,
143  post_author bigint(20) unsigned NOT NULL default '0',
144  post_date datetime NOT NULL default '0000-00-00 00:00:00',
145  post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
146  post_content longtext NOT NULL,
147  post_title text NOT NULL,
148  post_excerpt text NOT NULL,
149  post_status varchar(20) NOT NULL default 'publish',
150  comment_status varchar(20) NOT NULL default 'open',
151  ping_status varchar(20) NOT NULL default 'open',
152  post_password varchar(20) NOT NULL default '',
153  post_name varchar(200) NOT NULL default '',
154  to_ping text NOT NULL,
155  pinged text NOT NULL,
156  post_modified datetime NOT NULL default '0000-00-00 00:00:00',
157  post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
158  post_content_filtered longtext NOT NULL,
159  post_parent bigint(20) unsigned NOT NULL default '0',
160  guid varchar(255) NOT NULL default '',
161  menu_order int(11) NOT NULL default '0',
162  post_type varchar(20) NOT NULL default 'post',
163  post_mime_type varchar(100) NOT NULL default '',
164  comment_count bigint(20) NOT NULL default '0',
165  PRIMARY KEY  (ID),
166  KEY post_name (post_name),
167  KEY type_status_date (post_type,post_status,post_date,ID),
168  KEY post_parent (post_parent),
169  KEY post_author (post_author)
170) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
171
172DROP TABLE IF EXISTS wp_blogs;
173CREATE TABLE wp_blogs (
174  blog_id bigint(20) NOT NULL auto_increment,
175  site_id bigint(20) NOT NULL default '0',
176  domain varchar(200) NOT NULL default '',
177  path varchar(100) NOT NULL default '',
178  registered datetime NOT NULL default '0000-00-00 00:00:00',
179  last_updated datetime NOT NULL default '0000-00-00 00:00:00',
180  public tinyint(2) NOT NULL default '1',
181  archived tinyint(2) NOT NULL default '0',
182  mature tinyint(2) NOT NULL default '0',
183  spam tinyint(2) NOT NULL default '0',
184  deleted tinyint(2) NOT NULL default '0',
185  lang_id int(11) NOT NULL default '0',
186  PRIMARY KEY  (blog_id),
187  KEY domain (domain(50),path(5)),
188  KEY lang_id (lang_id)
189) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
190
191DROP TABLE IF EXISTS wp_blog_versions;
192CREATE TABLE wp_blog_versions (
193  blog_id bigint(20) NOT NULL default '0',
194  db_version varchar(20) NOT NULL default '',
195  last_updated datetime NOT NULL default '0000-00-00 00:00:00',
196  PRIMARY KEY  (blog_id),
197  KEY db_version (db_version)
198) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
199
200DROP TABLE IF EXISTS wp_registration_log;
201CREATE TABLE wp_registration_log (
202  ID bigint(20) NOT NULL auto_increment,
203  email varchar(255) NOT NULL default '',
204  IP varchar(30) NOT NULL default '',
205  blog_id bigint(20) NOT NULL default '0',
206  date_registered datetime NOT NULL default '0000-00-00 00:00:00',
207  PRIMARY KEY  (ID),
208  KEY IP (IP)
209) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
210
211DROP TABLE IF EXISTS wp_site;
212CREATE TABLE wp_site (
213  id bigint(20) NOT NULL auto_increment,
214  domain varchar(200) NOT NULL default '',
215  path varchar(100) NOT NULL default '',
216  PRIMARY KEY  (id),
217  KEY domain (domain,path)
218) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
219
220DROP TABLE IF EXISTS wp_sitemeta;
221CREATE TABLE wp_sitemeta (
222  meta_id bigint(20) NOT NULL auto_increment,
223  site_id bigint(20) NOT NULL default '0',
224  meta_key varchar(255) default NULL,
225  meta_value longtext,
226  PRIMARY KEY  (meta_id),
227  KEY meta_key (meta_key),
228  KEY site_id (site_id)
229) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
230
231DROP TABLE IF EXISTS wp_signups;
232CREATE TABLE wp_signups (
233  signup_id bigint(20) NOT NULL auto_increment,
234  domain varchar(200) NOT NULL default '',
235  path varchar(100) NOT NULL default '',
236  title longtext NOT NULL,
237  user_login varchar(60) NOT NULL default '',
238  user_email varchar(100) NOT NULL default '',
239  registered datetime NOT NULL default '0000-00-00 00:00:00',
240  activated datetime NOT NULL default '0000-00-00 00:00:00',
241  active tinyint(1) NOT NULL default '0',
242  activation_key varchar(50) NOT NULL default '',
243  meta longtext,
244  PRIMARY KEY  (signup_id),
245  KEY activation_key (activation_key),
246  KEY user_email (user_email),
247  KEY user_login_email (user_login,user_email),
248  KEY domain_path (domain,path)
249) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;