1
create schema everything;
2
DROP TABLE IF EXISTS `branch`;
4
Note 1051 Unknown table 'branch'
5
CREATE TABLE `branch` (
6
`branch_id` int NOT NULL default '0',
7
`project_id` int NOT NULL default '0',
8
PRIMARY KEY (`branch_id`)
10
DROP TABLE IF EXISTS `container`;
12
Note 1051 Unknown table 'container'
13
CREATE TABLE `container` (
14
`container_id` int NOT NULL auto_increment,
16
`parent_container` int default NULL,
17
PRIMARY KEY (`container_id`)
19
DROP TABLE IF EXISTS `document`;
21
Note 1051 Unknown table 'document'
22
CREATE TABLE `document` (
23
`document_id` int NOT NULL auto_increment,
25
PRIMARY KEY (`document_id`)
27
DROP TABLE IF EXISTS `genstats_attributes`;
29
Note 1051 Unknown table 'genstats_attributes'
30
CREATE TABLE `genstats_attributes` (
31
`genstats_attributes_id` int NOT NULL default '0',
32
`predicates` text NOT NULL,
33
`attributes` text NOT NULL,
34
PRIMARY KEY (`genstats_attributes_id`)
36
DROP TABLE IF EXISTS `htmlcode`;
38
Note 1051 Unknown table 'htmlcode'
39
CREATE TABLE `htmlcode` (
40
`htmlcode_id` int NOT NULL auto_increment,
42
PRIMARY KEY (`htmlcode_id`)
44
DROP TABLE IF EXISTS `htmlpage`;
46
Note 1051 Unknown table 'htmlpage'
47
CREATE TABLE `htmlpage` (
48
`htmlpage_id` int NOT NULL auto_increment,
49
`pagetype_nodetype` int default NULL,
50
`displaytype` varchar(20) default NULL,
52
`parent_container` int default NULL,
53
`ownedby_theme` int NOT NULL default '0',
54
`permissionneeded` char(1) NOT NULL default 'r',
55
`MIMEtype` varchar(255) NOT NULL default 'text/html',
56
PRIMARY KEY (`htmlpage_id`)
58
DROP TABLE IF EXISTS `image`;
60
Note 1051 Unknown table 'image'
61
CREATE TABLE `image` (
62
`image_id` int NOT NULL auto_increment,
63
`src` varchar(255) default NULL,
64
`alt` varchar(255) default NULL,
65
`thumbsrc` varchar(255) default NULL,
67
PRIMARY KEY (`image_id`)
69
DROP TABLE IF EXISTS `javascript`;
71
Note 1051 Unknown table 'javascript'
72
CREATE TABLE `javascript` (
73
`javascript_id` int NOT NULL default '0',
75
`comment` text NOT NULL,
76
`dynamic` int NOT NULL default '0',
77
PRIMARY KEY (`javascript_id`)
79
DROP TABLE IF EXISTS `knowledge_item`;
81
Note 1051 Unknown table 'knowledge_item'
82
CREATE TABLE `knowledge_item` (
83
`knowledge_item_id` int NOT NULL default '0',
85
`question` int NOT NULL default '0',
86
PRIMARY KEY (`knowledge_item_id`)
88
DROP TABLE IF EXISTS `links`;
90
Note 1051 Unknown table 'links'
91
CREATE TABLE `links` (
92
`from_node` int NOT NULL default '0',
93
`to_node` int NOT NULL default '0',
94
`linktype` int NOT NULL default '0',
95
`hits` int default '0',
96
`food` int default '0',
97
PRIMARY KEY (`from_node`,`to_node`,`linktype`)
99
DROP TABLE IF EXISTS `mail`;
101
Note 1051 Unknown table 'mail'
102
CREATE TABLE `mail` (
103
`mail_id` int NOT NULL default '0',
104
`from_address` char(80) NOT NULL default '',
105
`attachment_file` int NOT NULL default '0',
106
PRIMARY KEY (`mail_id`)
108
DROP TABLE IF EXISTS `node`;
110
Note 1051 Unknown table 'node'
111
CREATE TABLE `node` (
112
`node_id` int NOT NULL auto_increment,
113
`type_nodetype` int NOT NULL default '0',
114
`title` char(240) NOT NULL default '',
115
`author_user` int NOT NULL default '0',
116
`createtime` datetime NOT NULL,
117
`modified` datetime NOT NULL,
118
`hits` int default '0',
119
`loc_location` int default '0',
120
`reputation` int NOT NULL default '0',
121
`lockedby_user` int NOT NULL default '0',
122
`locktime` datetime NOT NULL,
123
`authoraccess` char(4) NOT NULL default 'iiii',
124
`groupaccess` char(5) NOT NULL default 'iiiii',
125
`otheraccess` char(5) NOT NULL default 'iiiii',
126
`guestaccess` char(5) NOT NULL default 'iiiii',
127
`dynamicauthor_permission` int NOT NULL default '-1',
128
`dynamicgroup_permission` int NOT NULL default '-1',
129
`dynamicother_permission` int NOT NULL default '-1',
130
`dynamicguest_permission` int NOT NULL default '-1',
131
`group_usergroup` int NOT NULL default '-1',
132
PRIMARY KEY (`node_id`),
133
KEY `title` (`title`,`type_nodetype`),
134
KEY `author` (`author_user`),
135
KEY `type` (`type_nodetype`)
136
) AUTO_INCREMENT=641;
138
Warning 1071 Specified key was too long; max key length is 767 bytes
139
DROP TABLE IF EXISTS `nodegroup`;
141
Note 1051 Unknown table 'nodegroup'
142
CREATE TABLE `nodegroup` (
143
`nodegroup_id` int NOT NULL auto_increment,
144
`rank` int NOT NULL default '0',
145
`node_id` int NOT NULL default '0',
146
`orderby` int default NULL,
147
PRIMARY KEY (`nodegroup_id`,`rank`)
148
) AUTO_INCREMENT=624;
149
DROP TABLE IF EXISTS `nodelet`;
151
Note 1051 Unknown table 'nodelet'
152
CREATE TABLE `nodelet` (
153
`nodelet_id` int NOT NULL auto_increment,
156
`nlgoto` int default NULL,
157
`parent_container` int default NULL,
158
`lastupdate` int NOT NULL default '0',
159
`updateinterval` int NOT NULL default '0',
160
`mini_nodelet` int NOT NULL default '0',
161
PRIMARY KEY (`nodelet_id`)
162
) AUTO_INCREMENT=495;
163
DROP TABLE IF EXISTS `nodemethod`;
165
Note 1051 Unknown table 'nodemethod'
166
CREATE TABLE `nodemethod` (
167
`nodemethod_id` int NOT NULL default '0',
168
`supports_nodetype` int NOT NULL default '0',
169
`code` text NOT NULL,
170
PRIMARY KEY (`nodemethod_id`)
172
DROP TABLE IF EXISTS `nodetype`;
174
Note 1051 Unknown table 'nodetype'
175
CREATE TABLE `nodetype` (
176
`nodetype_id` int NOT NULL auto_increment,
177
`restrict_nodetype` int default '0',
178
`extends_nodetype` int default '0',
179
`restrictdupes` int default '0',
180
`sqltable` char(255) default NULL,
181
`grouptable` char(40) default '',
182
`defaultauthoraccess` char(4) NOT NULL default 'iiii',
183
`defaultgroupaccess` char(5) NOT NULL default 'iiiii',
184
`defaultotheraccess` char(5) NOT NULL default 'iiiii',
185
`defaultguestaccess` char(5) NOT NULL default 'iiiii',
186
`defaultgroup_usergroup` int NOT NULL default '-1',
187
`defaultauthor_permission` int NOT NULL default '-1',
188
`defaultgroup_permission` int NOT NULL default '-1',
189
`defaultother_permission` int NOT NULL default '-1',
190
`defaultguest_permission` int NOT NULL default '-1',
191
`maxrevisions` int NOT NULL default '-1',
192
`canworkspace` int NOT NULL default '-1',
193
PRIMARY KEY (`nodetype_id`)
194
) AUTO_INCREMENT=561;
195
DROP TABLE IF EXISTS `project`;
197
Note 1051 Unknown table 'project'
198
CREATE TABLE `project` (
199
`project_id` int NOT NULL default '0',
200
`description` text NOT NULL,
201
`last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
202
`short_description` varchar(250) NOT NULL default '',
203
`url_cvs` varchar(250) NOT NULL default '',
204
`url_faq` varchar(250) NOT NULL default '',
205
`long_description` text NOT NULL,
206
PRIMARY KEY (`project_id`)
208
DROP TABLE IF EXISTS `project_document`;
210
Note 1051 Unknown table 'project_document'
211
CREATE TABLE `project_document` (
212
`project_document_id` int NOT NULL default '0',
213
`project_id` int NOT NULL default '0',
214
PRIMARY KEY (`project_document_id`)
216
DROP TABLE IF EXISTS `question`;
218
Note 1051 Unknown table 'question'
219
CREATE TABLE `question` (
220
`question_id` int NOT NULL default '0',
221
`faq_id` int NOT NULL default '0',
222
`project_id` int NOT NULL default '0',
223
`rank` int NOT NULL default '0',
224
`orderby` int NOT NULL default '0',
225
`description` text NOT NULL,
226
PRIMARY KEY (`question_id`,`rank`)
228
DROP TABLE IF EXISTS `redirects`;
230
Note 1051 Unknown table 'redirects'
231
CREATE TABLE `redirects` (
232
`redirects_id` int NOT NULL default '0',
234
PRIMARY KEY (`redirects_id`)
236
DROP TABLE IF EXISTS `releases`;
238
Note 1051 Unknown table 'releases'
239
CREATE TABLE `releases` (
240
`releases_id` int NOT NULL default '0',
241
`branch_id` int NOT NULL default '0',
243
`url_targz` varchar(250) NOT NULL default '',
244
`url_osx` varchar(250) NOT NULL default '',
245
`url_rpm` varchar(250) NOT NULL default '',
246
`project_id` int NOT NULL default '0',
247
`version` varchar(30) NOT NULL default 'latest',
248
`created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
249
`url_source_rpm` char(250) NOT NULL,
250
PRIMARY KEY (`releases_id`)
252
DROP TABLE IF EXISTS `revision`;
254
Note 1051 Unknown table 'revision'
255
CREATE TABLE `revision` (
256
`node_id` int NOT NULL default '0',
257
`inside_workspace` int NOT NULL default '0',
258
`revision_id` int NOT NULL default '0',
260
`tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
261
PRIMARY KEY (`node_id`,`inside_workspace`,`revision_id`)
263
DROP TABLE IF EXISTS `setting`;
265
Note 1051 Unknown table 'setting'
266
CREATE TABLE `setting` (
267
`setting_id` int NOT NULL auto_increment,
268
`vars` text NOT NULL,
269
PRIMARY KEY (`setting_id`)
270
) AUTO_INCREMENT=623;
271
DROP TABLE IF EXISTS `symlink`;
273
Note 1051 Unknown table 'symlink'
274
CREATE TABLE `symlink` (
275
`symlink_id` int NOT NULL default '0',
276
`symlink_node` int NOT NULL default '0',
277
PRIMARY KEY (`symlink_id`)
279
DROP TABLE IF EXISTS `themesetting`;
281
Note 1051 Unknown table 'themesetting'
282
CREATE TABLE `themesetting` (
283
`themesetting_id` int NOT NULL default '0',
284
`parent_theme` int NOT NULL default '0',
285
PRIMARY KEY (`themesetting_id`)
287
DROP TABLE IF EXISTS `typeversion`;
289
Note 1051 Unknown table 'typeversion'
290
CREATE TABLE `typeversion` (
291
`typeversion_id` int NOT NULL default '0',
292
`version` int NOT NULL default '0',
293
PRIMARY KEY (`typeversion_id`)
295
DROP TABLE IF EXISTS `user`;
297
Note 1051 Unknown table 'user'
298
CREATE TABLE `user` (
299
`user_id` int NOT NULL auto_increment,
300
`nick` varchar(20) default NULL,
301
`passwd` varchar(10) default NULL,
302
`realname` varchar(40) default NULL,
303
`email` varchar(40) default NULL,
304
`lasttime` datetime default NULL,
305
`karma` int default '0',
306
`inside_workspace` int NOT NULL default '0',
307
PRIMARY KEY (`user_id`)
308
) AUTO_INCREMENT=623;
309
DROP TABLE IF EXISTS `version`;
311
Note 1051 Unknown table 'version'
312
CREATE TABLE `version` (
313
`version_id` int NOT NULL default '0',
314
`version` int NOT NULL default '1',
315
PRIMARY KEY (`version_id`)
317
DROP TABLE IF EXISTS `weblog`;
319
Note 1051 Unknown table 'weblog'
320
CREATE TABLE `weblog` (
321
`tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
322
`linkedby_user` int NOT NULL default '0',
323
`removedby_user` int NOT NULL default '0',
324
`linkedtime` datetime NOT NULL,
325
`weblog_id` int NOT NULL default '0',
326
`to_node` int NOT NULL default '0',
327
`entry_id` int NOT NULL auto_increment,
328
PRIMARY KEY (`entry_id`),
329
KEY `tstamp` (`tstamp`)
331
DROP TABLE IF EXISTS `workspace`;
333
Note 1051 Unknown table 'workspace'
334
CREATE TABLE `workspace` (
335
`workspace_id` int NOT NULL default '0',
336
PRIMARY KEY (`workspace_id`)
370
show create table branch;
372
branch CREATE TABLE `branch` (
373
`branch_id` int NOT NULL DEFAULT '0',
374
`project_id` int NOT NULL DEFAULT '0',
375
PRIMARY KEY (`branch_id`)
377
show create table container;
379
container CREATE TABLE `container` (
380
`container_id` int NOT NULL AUTO_INCREMENT,
382
`parent_container` int DEFAULT NULL,
383
PRIMARY KEY (`container_id`)
385
show create table document;
387
document CREATE TABLE `document` (
388
`document_id` int NOT NULL AUTO_INCREMENT,
390
PRIMARY KEY (`document_id`)
392
show create table genstats_attributes;
394
genstats_attributes CREATE TABLE `genstats_attributes` (
395
`genstats_attributes_id` int NOT NULL DEFAULT '0',
396
`predicates` text NOT NULL,
397
`attributes` text NOT NULL,
398
PRIMARY KEY (`genstats_attributes_id`)
400
show create table htmlcode;
402
htmlcode CREATE TABLE `htmlcode` (
403
`htmlcode_id` int NOT NULL AUTO_INCREMENT,
405
PRIMARY KEY (`htmlcode_id`)
407
show create table htmlpage;
409
htmlpage CREATE TABLE `htmlpage` (
410
`htmlpage_id` int NOT NULL AUTO_INCREMENT,
411
`pagetype_nodetype` int DEFAULT NULL,
412
`displaytype` varchar(20) DEFAULT NULL,
414
`parent_container` int DEFAULT NULL,
415
`ownedby_theme` int NOT NULL DEFAULT '0',
416
`permissionneeded` varchar(1) NOT NULL DEFAULT 'r',
417
`MIMEtype` varchar(255) NOT NULL DEFAULT 'text/html',
418
PRIMARY KEY (`htmlpage_id`)
420
show create table image;
422
image CREATE TABLE `image` (
423
`image_id` int NOT NULL AUTO_INCREMENT,
424
`src` varchar(255) DEFAULT NULL,
425
`alt` varchar(255) DEFAULT NULL,
426
`thumbsrc` varchar(255) DEFAULT NULL,
428
PRIMARY KEY (`image_id`)
430
show create table javascript;
432
javascript CREATE TABLE `javascript` (
433
`javascript_id` int NOT NULL DEFAULT '0',
434
`code` text NOT NULL,
435
`comment` text NOT NULL,
436
`dynamic` int NOT NULL DEFAULT '0',
437
PRIMARY KEY (`javascript_id`)
439
show create table knowledge_item;
441
knowledge_item CREATE TABLE `knowledge_item` (
442
`knowledge_item_id` int NOT NULL DEFAULT '0',
443
`item` text NOT NULL,
444
`question` int NOT NULL DEFAULT '0',
445
PRIMARY KEY (`knowledge_item_id`)
447
show create table links;
449
links CREATE TABLE `links` (
450
`from_node` int NOT NULL DEFAULT '0',
451
`to_node` int NOT NULL DEFAULT '0',
452
`linktype` int NOT NULL DEFAULT '0',
453
`hits` int DEFAULT '0',
454
`food` int DEFAULT '0',
455
PRIMARY KEY (`from_node`,`to_node`,`linktype`)
457
show create table mail;
459
mail CREATE TABLE `mail` (
460
`mail_id` int NOT NULL DEFAULT '0',
461
`from_address` varchar(80) NOT NULL DEFAULT '',
462
`attachment_file` int NOT NULL DEFAULT '0',
463
PRIMARY KEY (`mail_id`)
465
show create table node;
467
node CREATE TABLE `node` (
468
`node_id` int NOT NULL AUTO_INCREMENT,
469
`type_nodetype` int NOT NULL DEFAULT '0',
470
`title` varchar(240) NOT NULL DEFAULT '',
471
`author_user` int NOT NULL DEFAULT '0',
472
`createtime` datetime NOT NULL,
473
`modified` datetime NOT NULL,
474
`hits` int DEFAULT '0',
475
`loc_location` int DEFAULT '0',
476
`reputation` int NOT NULL DEFAULT '0',
477
`lockedby_user` int NOT NULL DEFAULT '0',
478
`locktime` datetime NOT NULL,
479
`authoraccess` varchar(4) NOT NULL DEFAULT 'iiii',
480
`groupaccess` varchar(5) NOT NULL DEFAULT 'iiiii',
481
`otheraccess` varchar(5) NOT NULL DEFAULT 'iiiii',
482
`guestaccess` varchar(5) NOT NULL DEFAULT 'iiiii',
483
`dynamicauthor_permission` int NOT NULL DEFAULT '-1',
484
`dynamicgroup_permission` int NOT NULL DEFAULT '-1',
485
`dynamicother_permission` int NOT NULL DEFAULT '-1',
486
`dynamicguest_permission` int NOT NULL DEFAULT '-1',
487
`group_usergroup` int NOT NULL DEFAULT '-1',
488
PRIMARY KEY (`node_id`),
489
KEY `title` (`title`(191),`type_nodetype`),
490
KEY `author` (`author_user`),
491
KEY `type` (`type_nodetype`)
493
show create table nodegroup;
495
nodegroup CREATE TABLE `nodegroup` (
496
`nodegroup_id` int NOT NULL AUTO_INCREMENT,
497
`rank` int NOT NULL DEFAULT '0',
498
`node_id` int NOT NULL DEFAULT '0',
499
`orderby` int DEFAULT NULL,
500
PRIMARY KEY (`nodegroup_id`,`rank`)
502
show create table nodelet;
504
nodelet CREATE TABLE `nodelet` (
505
`nodelet_id` int NOT NULL AUTO_INCREMENT,
508
`nlgoto` int DEFAULT NULL,
509
`parent_container` int DEFAULT NULL,
510
`lastupdate` int NOT NULL DEFAULT '0',
511
`updateinterval` int NOT NULL DEFAULT '0',
512
`mini_nodelet` int NOT NULL DEFAULT '0',
513
PRIMARY KEY (`nodelet_id`)
515
show create table nodemethod;
517
nodemethod CREATE TABLE `nodemethod` (
518
`nodemethod_id` int NOT NULL DEFAULT '0',
519
`supports_nodetype` int NOT NULL DEFAULT '0',
520
`code` text NOT NULL,
521
PRIMARY KEY (`nodemethod_id`)
523
show create table nodetype;
525
nodetype CREATE TABLE `nodetype` (
526
`nodetype_id` int NOT NULL AUTO_INCREMENT,
527
`restrict_nodetype` int DEFAULT '0',
528
`extends_nodetype` int DEFAULT '0',
529
`restrictdupes` int DEFAULT '0',
530
`sqltable` varchar(255) DEFAULT NULL,
531
`grouptable` varchar(40) DEFAULT '',
532
`defaultauthoraccess` varchar(4) NOT NULL DEFAULT 'iiii',
533
`defaultgroupaccess` varchar(5) NOT NULL DEFAULT 'iiiii',
534
`defaultotheraccess` varchar(5) NOT NULL DEFAULT 'iiiii',
535
`defaultguestaccess` varchar(5) NOT NULL DEFAULT 'iiiii',
536
`defaultgroup_usergroup` int NOT NULL DEFAULT '-1',
537
`defaultauthor_permission` int NOT NULL DEFAULT '-1',
538
`defaultgroup_permission` int NOT NULL DEFAULT '-1',
539
`defaultother_permission` int NOT NULL DEFAULT '-1',
540
`defaultguest_permission` int NOT NULL DEFAULT '-1',
541
`maxrevisions` int NOT NULL DEFAULT '-1',
542
`canworkspace` int NOT NULL DEFAULT '-1',
543
PRIMARY KEY (`nodetype_id`)
545
show create table project;
547
project CREATE TABLE `project` (
548
`project_id` int NOT NULL DEFAULT '0',
549
`description` text NOT NULL,
550
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
551
`short_description` varchar(250) NOT NULL DEFAULT '',
552
`url_cvs` varchar(250) NOT NULL DEFAULT '',
553
`url_faq` varchar(250) NOT NULL DEFAULT '',
554
`long_description` text NOT NULL,
555
PRIMARY KEY (`project_id`)
557
show create table project_document;
559
project_document CREATE TABLE `project_document` (
560
`project_document_id` int NOT NULL DEFAULT '0',
561
`project_id` int NOT NULL DEFAULT '0',
562
PRIMARY KEY (`project_document_id`)
564
show create table question;
566
question CREATE TABLE `question` (
567
`question_id` int NOT NULL DEFAULT '0',
568
`faq_id` int NOT NULL DEFAULT '0',
569
`project_id` int NOT NULL DEFAULT '0',
570
`rank` int NOT NULL DEFAULT '0',
571
`orderby` int NOT NULL DEFAULT '0',
572
`description` text NOT NULL,
573
PRIMARY KEY (`question_id`,`rank`)
575
show create table redirects;
577
redirects CREATE TABLE `redirects` (
578
`redirects_id` int NOT NULL DEFAULT '0',
580
PRIMARY KEY (`redirects_id`)
582
show create table releases;
584
releases CREATE TABLE `releases` (
585
`releases_id` int NOT NULL DEFAULT '0',
586
`branch_id` int NOT NULL DEFAULT '0',
588
`url_targz` varchar(250) NOT NULL DEFAULT '',
589
`url_osx` varchar(250) NOT NULL DEFAULT '',
590
`url_rpm` varchar(250) NOT NULL DEFAULT '',
591
`project_id` int NOT NULL DEFAULT '0',
592
`version` varchar(30) NOT NULL DEFAULT 'latest',
593
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
594
`url_source_rpm` varchar(250) NOT NULL,
595
PRIMARY KEY (`releases_id`)
597
show create table revision;
599
revision CREATE TABLE `revision` (
600
`node_id` int NOT NULL DEFAULT '0',
601
`inside_workspace` int NOT NULL DEFAULT '0',
602
`revision_id` int NOT NULL DEFAULT '0',
604
`tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
605
PRIMARY KEY (`node_id`,`inside_workspace`,`revision_id`)
607
show create table setting;
609
setting CREATE TABLE `setting` (
610
`setting_id` int NOT NULL AUTO_INCREMENT,
611
`vars` text NOT NULL,
612
PRIMARY KEY (`setting_id`)
614
show create table symlink;
616
symlink CREATE TABLE `symlink` (
617
`symlink_id` int NOT NULL DEFAULT '0',
618
`symlink_node` int NOT NULL DEFAULT '0',
619
PRIMARY KEY (`symlink_id`)
621
show create table themesetting;
623
themesetting CREATE TABLE `themesetting` (
624
`themesetting_id` int NOT NULL DEFAULT '0',
625
`parent_theme` int NOT NULL DEFAULT '0',
626
PRIMARY KEY (`themesetting_id`)
628
show create table typeversion;
630
typeversion CREATE TABLE `typeversion` (
631
`typeversion_id` int NOT NULL DEFAULT '0',
632
`version` int NOT NULL DEFAULT '0',
633
PRIMARY KEY (`typeversion_id`)
635
show create table user;
637
user CREATE TABLE `user` (
638
`user_id` int NOT NULL AUTO_INCREMENT,
639
`nick` varchar(20) DEFAULT NULL,
640
`passwd` varchar(10) DEFAULT NULL,
641
`realname` varchar(40) DEFAULT NULL,
642
`email` varchar(40) DEFAULT NULL,
643
`lasttime` datetime DEFAULT NULL,
644
`karma` int DEFAULT '0',
645
`inside_workspace` int NOT NULL DEFAULT '0',
646
PRIMARY KEY (`user_id`)
648
show create table version;
650
version CREATE TABLE `version` (
651
`version_id` int NOT NULL DEFAULT '0',
652
`version` int NOT NULL DEFAULT '1',
653
PRIMARY KEY (`version_id`)
655
show create table weblog;
657
weblog CREATE TABLE `weblog` (
658
`tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
659
`linkedby_user` int NOT NULL DEFAULT '0',
660
`removedby_user` int NOT NULL DEFAULT '0',
661
`linkedtime` datetime NOT NULL,
662
`weblog_id` int NOT NULL DEFAULT '0',
663
`to_node` int NOT NULL DEFAULT '0',
664
`entry_id` int NOT NULL AUTO_INCREMENT,
665
PRIMARY KEY (`entry_id`),
666
KEY `tstamp` (`tstamp`)
668
show create table workspace;
670
workspace CREATE TABLE `workspace` (
671
`workspace_id` int NOT NULL DEFAULT '0',
672
PRIMARY KEY (`workspace_id`)
674
show columns from branch;
675
Field Type Null Default Default_is_NULL On_Update
676
branch_id INTEGER FALSE 0 FALSE
677
project_id INTEGER FALSE 0 FALSE
678
show columns from container;
679
Field Type Null Default Default_is_NULL On_Update
680
container_id INTEGER FALSE FALSE
681
context BLOB TRUE TRUE
682
parent_container INTEGER TRUE TRUE
683
show columns from document;
684
Field Type Null Default Default_is_NULL On_Update
685
document_id INTEGER FALSE FALSE
686
doctext BLOB TRUE TRUE
687
show columns from genstats_attributes;
688
Field Type Null Default Default_is_NULL On_Update
689
genstats_attributes_id INTEGER FALSE 0 FALSE
690
predicates BLOB FALSE 0 FALSE
691
attributes BLOB FALSE 0 FALSE
692
show columns from htmlcode;
693
Field Type Null Default Default_is_NULL On_Update
694
htmlcode_id INTEGER FALSE FALSE
696
show columns from htmlpage;
697
Field Type Null Default Default_is_NULL On_Update
698
htmlpage_id INTEGER FALSE FALSE
699
pagetype_nodetype INTEGER TRUE TRUE
700
displaytype VARCHAR TRUE TRUE
702
parent_container INTEGER TRUE TRUE
703
ownedby_theme INTEGER FALSE 0 FALSE
704
permissionneeded VARCHAR FALSE r FALSE
705
MIMEtype VARCHAR FALSE text/html FALSE
706
show columns from image;
707
Field Type Null Default Default_is_NULL On_Update
708
image_id INTEGER FALSE FALSE
709
src VARCHAR TRUE TRUE
710
alt VARCHAR TRUE TRUE
711
thumbsrc VARCHAR TRUE TRUE
712
description BLOB TRUE TRUE
713
show columns from javascript;
714
Field Type Null Default Default_is_NULL On_Update
715
javascript_id INTEGER FALSE 0 FALSE
716
code BLOB FALSE 0 FALSE
717
comment BLOB FALSE 0 FALSE
718
dynamic INTEGER FALSE 0 FALSE
719
show columns from knowledge_item;
720
Field Type Null Default Default_is_NULL On_Update
721
knowledge_item_id INTEGER FALSE 0 FALSE
722
item BLOB FALSE 0 FALSE
723
question INTEGER FALSE 0 FALSE
724
show columns from links;
725
Field Type Null Default Default_is_NULL On_Update
726
from_node INTEGER FALSE 0 FALSE
727
to_node INTEGER FALSE 0 FALSE
728
linktype INTEGER FALSE 0 FALSE
729
hits INTEGER TRUE 0 FALSE
730
food INTEGER TRUE 0 FALSE
731
show columns from mail;
732
Field Type Null Default Default_is_NULL On_Update
733
mail_id INTEGER FALSE 0 FALSE
734
from_address VARCHAR FALSE 0 FALSE
735
attachment_file INTEGER FALSE 0 FALSE
736
show columns from node;
737
Field Type Null Default Default_is_NULL On_Update
738
node_id INTEGER FALSE FALSE
739
type_nodetype INTEGER FALSE 0 FALSE
740
title VARCHAR FALSE 0 FALSE
741
author_user INTEGER FALSE 0 FALSE
742
createtime DATETIME FALSE 0 FALSE
743
modified DATETIME FALSE 0 FALSE
744
hits INTEGER TRUE 0 FALSE
745
loc_location INTEGER TRUE 0 FALSE
746
reputation INTEGER FALSE 0 FALSE
747
lockedby_user INTEGER FALSE 0 FALSE
748
locktime DATETIME FALSE 0 FALSE
749
authoraccess VARCHAR FALSE iiii FALSE
750
groupaccess VARCHAR FALSE iiiii FALSE
751
otheraccess VARCHAR FALSE iiiii FALSE
752
guestaccess VARCHAR FALSE iiiii FALSE
753
dynamicauthor_permission INTEGER FALSE -1 FALSE
754
dynamicgroup_permission INTEGER FALSE -1 FALSE
755
dynamicother_permission INTEGER FALSE -1 FALSE
756
dynamicguest_permission INTEGER FALSE -1 FALSE
757
group_usergroup INTEGER FALSE -1 FALSE
758
show columns from nodegroup;
759
Field Type Null Default Default_is_NULL On_Update
760
nodegroup_id INTEGER FALSE FALSE
761
rank INTEGER FALSE 0 FALSE
762
node_id INTEGER FALSE 0 FALSE
763
orderby INTEGER TRUE 0 TRUE
764
show columns from nodelet;
765
Field Type Null Default Default_is_NULL On_Update
766
nodelet_id INTEGER FALSE FALSE
767
nltext BLOB TRUE TRUE
768
nlcode BLOB TRUE TRUE
769
nlgoto INTEGER TRUE TRUE
770
parent_container INTEGER TRUE TRUE
771
lastupdate INTEGER FALSE 0 FALSE
772
updateinterval INTEGER FALSE 0 FALSE
773
mini_nodelet INTEGER FALSE 0 FALSE
774
show columns from nodemethod;
775
Field Type Null Default Default_is_NULL On_Update
776
nodemethod_id INTEGER FALSE 0 FALSE
777
supports_nodetype INTEGER FALSE 0 FALSE
778
code BLOB FALSE 0 FALSE
779
show columns from nodetype;
780
Field Type Null Default Default_is_NULL On_Update
781
nodetype_id INTEGER FALSE FALSE
782
restrict_nodetype INTEGER TRUE 0 FALSE
783
extends_nodetype INTEGER TRUE 0 FALSE
784
restrictdupes INTEGER TRUE 0 FALSE
785
sqltable VARCHAR TRUE 0 TRUE
786
grouptable VARCHAR TRUE 0 FALSE
787
defaultauthoraccess VARCHAR FALSE iiii FALSE
788
defaultgroupaccess VARCHAR FALSE iiiii FALSE
789
defaultotheraccess VARCHAR FALSE iiiii FALSE
790
defaultguestaccess VARCHAR FALSE iiiii FALSE
791
defaultgroup_usergroup INTEGER FALSE -1 FALSE
792
defaultauthor_permission INTEGER FALSE -1 FALSE
793
defaultgroup_permission INTEGER FALSE -1 FALSE
794
defaultother_permission INTEGER FALSE -1 FALSE
795
defaultguest_permission INTEGER FALSE -1 FALSE
796
maxrevisions INTEGER FALSE -1 FALSE
797
canworkspace INTEGER FALSE -1 FALSE
798
show columns from project;
799
Field Type Null Default Default_is_NULL On_Update
800
project_id INTEGER FALSE 0 FALSE
801
description BLOB FALSE 0 FALSE
802
last_update TIMESTAMP FALSE NOW() FALSE NOW()
803
short_description VARCHAR FALSE NOW() FALSE NOW()
804
url_cvs VARCHAR FALSE NOW() FALSE NOW()
805
url_faq VARCHAR FALSE NOW() FALSE NOW()
806
long_description BLOB FALSE NOW() FALSE NOW()
807
show columns from project_document;
808
Field Type Null Default Default_is_NULL On_Update
809
project_document_id INTEGER FALSE 0 FALSE
810
project_id INTEGER FALSE 0 FALSE
811
show columns from question;
812
Field Type Null Default Default_is_NULL On_Update
813
question_id INTEGER FALSE 0 FALSE
814
faq_id INTEGER FALSE 0 FALSE
815
project_id INTEGER FALSE 0 FALSE
816
rank INTEGER FALSE 0 FALSE
817
orderby INTEGER FALSE 0 FALSE
818
description BLOB FALSE 0 FALSE
819
show columns from redirects;
820
Field Type Null Default Default_is_NULL On_Update
821
redirects_id INTEGER FALSE 0 FALSE
822
url BLOB FALSE 0 FALSE
823
show columns from releases;
824
Field Type Null Default Default_is_NULL On_Update
825
releases_id INTEGER FALSE 0 FALSE
826
branch_id INTEGER FALSE 0 FALSE
827
description BLOB TRUE 0 TRUE
828
url_targz VARCHAR FALSE 0 FALSE
829
url_osx VARCHAR FALSE 0 FALSE
830
url_rpm VARCHAR FALSE 0 FALSE
831
project_id INTEGER FALSE 0 FALSE
832
version VARCHAR FALSE latest FALSE
833
created TIMESTAMP FALSE NOW() FALSE NOW()
834
url_source_rpm VARCHAR FALSE NOW() FALSE NOW()
835
show columns from revision;
836
Field Type Null Default Default_is_NULL On_Update
837
node_id INTEGER FALSE 0 FALSE
838
inside_workspace INTEGER FALSE 0 FALSE
839
revision_id INTEGER FALSE 0 FALSE
840
xml BLOB FALSE 0 FALSE
841
tstamp TIMESTAMP FALSE NOW() FALSE NOW()
842
show columns from setting;
843
Field Type Null Default Default_is_NULL On_Update
844
setting_id INTEGER FALSE FALSE
845
vars BLOB FALSE FALSE
846
show columns from symlink;
847
Field Type Null Default Default_is_NULL On_Update
848
symlink_id INTEGER FALSE 0 FALSE
849
symlink_node INTEGER FALSE 0 FALSE
850
show columns from themesetting;
851
Field Type Null Default Default_is_NULL On_Update
852
themesetting_id INTEGER FALSE 0 FALSE
853
parent_theme INTEGER FALSE 0 FALSE
854
show columns from typeversion;
855
Field Type Null Default Default_is_NULL On_Update
856
typeversion_id INTEGER FALSE 0 FALSE
857
version INTEGER FALSE 0 FALSE
858
show columns from user;
859
Field Type Null Default Default_is_NULL On_Update
860
user_id INTEGER FALSE FALSE
861
nick VARCHAR TRUE TRUE
862
passwd VARCHAR TRUE TRUE
863
realname VARCHAR TRUE TRUE
864
email VARCHAR TRUE TRUE
865
lasttime DATETIME TRUE TRUE
866
karma INTEGER TRUE 0 FALSE
867
inside_workspace INTEGER FALSE 0 FALSE
868
show columns from version;
869
Field Type Null Default Default_is_NULL On_Update
870
version_id INTEGER FALSE 0 FALSE
871
version INTEGER FALSE 1 FALSE
872
show columns from weblog;
873
Field Type Null Default Default_is_NULL On_Update
874
tstamp TIMESTAMP FALSE NOW() FALSE NOW()
875
linkedby_user INTEGER FALSE 0 FALSE NOW()
876
removedby_user INTEGER FALSE 0 FALSE NOW()
877
linkedtime DATETIME FALSE 0 FALSE NOW()
878
weblog_id INTEGER FALSE 0 FALSE NOW()
879
to_node INTEGER FALSE 0 FALSE NOW()
880
entry_id INTEGER FALSE 0 FALSE NOW()
881
show columns from workspace;
882
Field Type Null Default Default_is_NULL On_Update
883
workspace_id INTEGER FALSE 0 FALSE
884
show indexes from branch;
885
Table Unique Key_name Seq_in_index Column_name
886
branch TRUE PRIMARY 1 branch_id
887
show indexes from container;
888
Table Unique Key_name Seq_in_index Column_name
889
container TRUE PRIMARY 1 container_id
890
show indexes from document;
891
Table Unique Key_name Seq_in_index Column_name
892
document TRUE PRIMARY 1 document_id
893
show indexes from genstats_attributes;
894
Table Unique Key_name Seq_in_index Column_name
895
genstats_attributes TRUE PRIMARY 1 genstats_attributes_id
896
show indexes from htmlcode;
897
Table Unique Key_name Seq_in_index Column_name
898
htmlcode TRUE PRIMARY 1 htmlcode_id
899
show indexes from htmlpage;
900
Table Unique Key_name Seq_in_index Column_name
901
htmlpage TRUE PRIMARY 1 htmlpage_id
902
show indexes from image;
903
Table Unique Key_name Seq_in_index Column_name
904
image TRUE PRIMARY 1 image_id
905
show indexes from javascript;
906
Table Unique Key_name Seq_in_index Column_name
907
javascript TRUE PRIMARY 1 javascript_id
908
show indexes from knowledge_item;
909
Table Unique Key_name Seq_in_index Column_name
910
knowledge_item TRUE PRIMARY 1 knowledge_item_id
911
show indexes from links;
912
Table Unique Key_name Seq_in_index Column_name
913
links TRUE PRIMARY 1 from_node
914
links TRUE PRIMARY 2 to_node
915
links TRUE PRIMARY 3 linktype
916
show indexes from mail;
917
Table Unique Key_name Seq_in_index Column_name
918
mail TRUE PRIMARY 1 mail_id
919
show indexes from node;
920
Table Unique Key_name Seq_in_index Column_name
921
node TRUE PRIMARY 1 node_id
922
node FALSE title 1 title
923
node FALSE title 2 type_nodetype
924
node FALSE author 1 author_user
925
node FALSE type 1 type_nodetype
926
show indexes from nodegroup;
927
Table Unique Key_name Seq_in_index Column_name
928
nodegroup TRUE PRIMARY 1 nodegroup_id
929
nodegroup TRUE PRIMARY 2 rank
930
show indexes from nodelet;
931
Table Unique Key_name Seq_in_index Column_name
932
nodelet TRUE PRIMARY 1 nodelet_id
933
show indexes from nodemethod;
934
Table Unique Key_name Seq_in_index Column_name
935
nodemethod TRUE PRIMARY 1 nodemethod_id
936
show indexes from nodetype;
937
Table Unique Key_name Seq_in_index Column_name
938
nodetype TRUE PRIMARY 1 nodetype_id
939
show indexes from project;
940
Table Unique Key_name Seq_in_index Column_name
941
project TRUE PRIMARY 1 project_id
942
show indexes from project_document;
943
Table Unique Key_name Seq_in_index Column_name
944
project_document TRUE PRIMARY 1 project_document_id
945
show indexes from question;
946
Table Unique Key_name Seq_in_index Column_name
947
question TRUE PRIMARY 1 question_id
948
question TRUE PRIMARY 2 rank
949
show indexes from redirects;
950
Table Unique Key_name Seq_in_index Column_name
951
redirects TRUE PRIMARY 1 redirects_id
952
show indexes from releases;
953
Table Unique Key_name Seq_in_index Column_name
954
releases TRUE PRIMARY 1 releases_id
955
show indexes from revision;
956
Table Unique Key_name Seq_in_index Column_name
957
revision TRUE PRIMARY 1 node_id
958
revision TRUE PRIMARY 2 inside_workspace
959
revision TRUE PRIMARY 3 revision_id
960
show indexes from setting;
961
Table Unique Key_name Seq_in_index Column_name
962
setting TRUE PRIMARY 1 setting_id
963
show indexes from symlink;
964
Table Unique Key_name Seq_in_index Column_name
965
symlink TRUE PRIMARY 1 symlink_id
966
show indexes from themesetting;
967
Table Unique Key_name Seq_in_index Column_name
968
themesetting TRUE PRIMARY 1 themesetting_id
969
show indexes from typeversion;
970
Table Unique Key_name Seq_in_index Column_name
971
typeversion TRUE PRIMARY 1 typeversion_id
972
show indexes from user;
973
Table Unique Key_name Seq_in_index Column_name
974
user TRUE PRIMARY 1 user_id
975
show indexes from version;
976
Table Unique Key_name Seq_in_index Column_name
977
version TRUE PRIMARY 1 version_id
978
show indexes from weblog;
979
Table Unique Key_name Seq_in_index Column_name
980
weblog TRUE PRIMARY 1 entry_id
981
weblog FALSE tstamp 1 tstamp
982
show indexes from workspace;
983
Table Unique Key_name Seq_in_index Column_name
984
workspace TRUE PRIMARY 1 workspace_id
985
drop schema everything;