370
369
show create table branch;
371
370
Table Create Table
372
371
branch CREATE TABLE `branch` (
373
`branch_id` int NOT NULL DEFAULT '0',
374
`project_id` int NOT NULL DEFAULT '0',
372
`branch_id` INT NOT NULL DEFAULT '0',
373
`project_id` INT NOT NULL DEFAULT '0',
375
374
PRIMARY KEY (`branch_id`)
375
) ENGINE=InnoDB COLLATE = utf8_general_ci
377
376
show create table container;
378
377
Table Create Table
379
378
container CREATE TABLE `container` (
380
`container_id` int NOT NULL AUTO_INCREMENT,
382
`parent_container` int DEFAULT NULL,
379
`container_id` INT NOT NULL AUTO_INCREMENT,
380
`context` TEXT COLLATE utf8_general_ci,
381
`parent_container` INT DEFAULT NULL,
383
382
PRIMARY KEY (`container_id`)
383
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=312
385
384
show create table document;
386
385
Table Create Table
387
386
document CREATE TABLE `document` (
388
`document_id` int NOT NULL AUTO_INCREMENT,
387
`document_id` INT NOT NULL AUTO_INCREMENT,
388
`doctext` TEXT COLLATE utf8_general_ci,
390
389
PRIMARY KEY (`document_id`)
390
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=623
392
391
show create table genstats_attributes;
393
392
Table Create Table
394
393
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,
394
`genstats_attributes_id` INT NOT NULL DEFAULT '0',
395
`predicates` TEXT COLLATE utf8_general_ci NOT NULL,
396
`attributes` TEXT COLLATE utf8_general_ci NOT NULL,
398
397
PRIMARY KEY (`genstats_attributes_id`)
398
) ENGINE=InnoDB COLLATE = utf8_general_ci
400
399
show create table htmlcode;
401
400
Table Create Table
402
401
htmlcode CREATE TABLE `htmlcode` (
403
`htmlcode_id` int NOT NULL AUTO_INCREMENT,
402
`htmlcode_id` INT NOT NULL AUTO_INCREMENT,
403
`code` TEXT COLLATE utf8_general_ci,
405
404
PRIMARY KEY (`htmlcode_id`)
405
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=516
407
406
show create table htmlpage;
408
407
Table Create Table
409
408
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',
409
`htmlpage_id` INT NOT NULL AUTO_INCREMENT,
410
`pagetype_nodetype` INT DEFAULT NULL,
411
`displaytype` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
412
`page` TEXT COLLATE utf8_general_ci,
413
`parent_container` INT DEFAULT NULL,
414
`ownedby_theme` INT NOT NULL DEFAULT '0',
415
`permissionneeded` VARCHAR(1) COLLATE utf8_general_ci NOT NULL DEFAULT 'r',
416
`MIMEtype` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT 'text/html',
418
417
PRIMARY KEY (`htmlpage_id`)
418
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=564
420
419
show create table image;
421
420
Table Create Table
422
421
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,
422
`image_id` INT NOT NULL AUTO_INCREMENT,
423
`src` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
424
`alt` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
425
`thumbsrc` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
426
`description` TEXT COLLATE utf8_general_ci,
428
427
PRIMARY KEY (`image_id`)
428
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=138
430
429
show create table javascript;
431
430
Table Create Table
432
431
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',
432
`javascript_id` INT NOT NULL DEFAULT '0',
433
`code` TEXT COLLATE utf8_general_ci NOT NULL,
434
`comment` TEXT COLLATE utf8_general_ci NOT NULL,
435
`dynamic` INT NOT NULL DEFAULT '0',
437
436
PRIMARY KEY (`javascript_id`)
437
) ENGINE=InnoDB COLLATE = utf8_general_ci
439
438
show create table knowledge_item;
440
439
Table Create Table
441
440
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',
441
`knowledge_item_id` INT NOT NULL DEFAULT '0',
442
`item` TEXT COLLATE utf8_general_ci NOT NULL,
443
`question` INT NOT NULL DEFAULT '0',
445
444
PRIMARY KEY (`knowledge_item_id`)
445
) ENGINE=InnoDB COLLATE = utf8_general_ci
447
446
show create table links;
448
447
Table Create Table
449
448
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',
449
`from_node` INT NOT NULL DEFAULT '0',
450
`to_node` INT NOT NULL DEFAULT '0',
451
`linktype` INT NOT NULL DEFAULT '0',
452
`hits` INT DEFAULT '0',
453
`food` INT DEFAULT '0',
455
454
PRIMARY KEY (`from_node`,`to_node`,`linktype`)
455
) ENGINE=InnoDB COLLATE = utf8_general_ci
457
456
show create table mail;
458
457
Table Create Table
459
458
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',
459
`mail_id` INT NOT NULL DEFAULT '0',
460
`from_address` VARCHAR(80) COLLATE utf8_general_ci NOT NULL DEFAULT '',
461
`attachment_file` INT NOT NULL DEFAULT '0',
463
462
PRIMARY KEY (`mail_id`)
463
) ENGINE=InnoDB COLLATE = utf8_general_ci
465
464
show create table node;
466
465
Table Create Table
467
466
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',
467
`node_id` INT NOT NULL AUTO_INCREMENT,
468
`type_nodetype` INT NOT NULL DEFAULT '0',
469
`title` VARCHAR(240) COLLATE utf8_general_ci NOT NULL DEFAULT '',
470
`author_user` INT NOT NULL DEFAULT '0',
471
`createtime` DATETIME NOT NULL,
472
`modified` DATETIME NOT NULL,
473
`hits` INT DEFAULT '0',
474
`loc_location` INT DEFAULT '0',
475
`reputation` INT NOT NULL DEFAULT '0',
476
`lockedby_user` INT NOT NULL DEFAULT '0',
477
`locktime` DATETIME NOT NULL,
478
`authoraccess` VARCHAR(4) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiii',
479
`groupaccess` VARCHAR(5) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiiii',
480
`otheraccess` VARCHAR(5) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiiii',
481
`guestaccess` VARCHAR(5) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiiii',
482
`dynamicauthor_permission` INT NOT NULL DEFAULT '-1',
483
`dynamicgroup_permission` INT NOT NULL DEFAULT '-1',
484
`dynamicother_permission` INT NOT NULL DEFAULT '-1',
485
`dynamicguest_permission` INT NOT NULL DEFAULT '-1',
486
`group_usergroup` INT NOT NULL DEFAULT '-1',
488
487
PRIMARY KEY (`node_id`),
489
KEY `title` (`title`(191),`type_nodetype`),
488
KEY `title` (`title`,`type_nodetype`),
490
489
KEY `author` (`author_user`),
491
490
KEY `type` (`type_nodetype`)
491
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=641
493
492
show create table nodegroup;
494
493
Table Create Table
495
494
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,
495
`nodegroup_id` INT NOT NULL AUTO_INCREMENT,
496
`rank` INT NOT NULL DEFAULT '0',
497
`node_id` INT NOT NULL DEFAULT '0',
498
`orderby` INT DEFAULT NULL,
500
499
PRIMARY KEY (`nodegroup_id`,`rank`)
500
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=624
502
501
show create table nodelet;
503
502
Table Create Table
504
503
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',
504
`nodelet_id` INT NOT NULL AUTO_INCREMENT,
505
`nltext` TEXT COLLATE utf8_general_ci,
506
`nlcode` TEXT COLLATE utf8_general_ci,
507
`nlgoto` INT DEFAULT NULL,
508
`parent_container` INT DEFAULT NULL,
509
`lastupdate` INT NOT NULL DEFAULT '0',
510
`updateinterval` INT NOT NULL DEFAULT '0',
511
`mini_nodelet` INT NOT NULL DEFAULT '0',
513
512
PRIMARY KEY (`nodelet_id`)
513
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=495
515
514
show create table nodemethod;
516
515
Table Create Table
517
516
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,
517
`nodemethod_id` INT NOT NULL DEFAULT '0',
518
`supports_nodetype` INT NOT NULL DEFAULT '0',
519
`code` TEXT COLLATE utf8_general_ci NOT NULL,
521
520
PRIMARY KEY (`nodemethod_id`)
521
) ENGINE=InnoDB COLLATE = utf8_general_ci
523
522
show create table nodetype;
524
523
Table Create Table
525
524
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',
525
`nodetype_id` INT NOT NULL AUTO_INCREMENT,
526
`restrict_nodetype` INT DEFAULT '0',
527
`extends_nodetype` INT DEFAULT '0',
528
`restrictdupes` INT DEFAULT '0',
529
`sqltable` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
530
`grouptable` VARCHAR(40) COLLATE utf8_general_ci DEFAULT '',
531
`defaultauthoraccess` VARCHAR(4) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiii',
532
`defaultgroupaccess` VARCHAR(5) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiiii',
533
`defaultotheraccess` VARCHAR(5) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiiii',
534
`defaultguestaccess` VARCHAR(5) COLLATE utf8_general_ci NOT NULL DEFAULT 'iiiii',
535
`defaultgroup_usergroup` INT NOT NULL DEFAULT '-1',
536
`defaultauthor_permission` INT NOT NULL DEFAULT '-1',
537
`defaultgroup_permission` INT NOT NULL DEFAULT '-1',
538
`defaultother_permission` INT NOT NULL DEFAULT '-1',
539
`defaultguest_permission` INT NOT NULL DEFAULT '-1',
540
`maxrevisions` INT NOT NULL DEFAULT '-1',
541
`canworkspace` INT NOT NULL DEFAULT '-1',
543
542
PRIMARY KEY (`nodetype_id`)
543
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=561
545
544
show create table project;
546
545
Table Create Table
547
546
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,
547
`project_id` INT NOT NULL DEFAULT '0',
548
`description` TEXT COLLATE utf8_general_ci NOT NULL,
549
`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
550
`short_description` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
551
`url_cvs` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
552
`url_faq` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
553
`long_description` TEXT COLLATE utf8_general_ci NOT NULL,
555
554
PRIMARY KEY (`project_id`)
555
) ENGINE=InnoDB COLLATE = utf8_general_ci
557
556
show create table project_document;
558
557
Table Create Table
559
558
project_document CREATE TABLE `project_document` (
560
`project_document_id` int NOT NULL DEFAULT '0',
561
`project_id` int NOT NULL DEFAULT '0',
559
`project_document_id` INT NOT NULL DEFAULT '0',
560
`project_id` INT NOT NULL DEFAULT '0',
562
561
PRIMARY KEY (`project_document_id`)
562
) ENGINE=InnoDB COLLATE = utf8_general_ci
564
563
show create table question;
565
564
Table Create Table
566
565
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,
566
`question_id` INT NOT NULL DEFAULT '0',
567
`faq_id` INT NOT NULL DEFAULT '0',
568
`project_id` INT NOT NULL DEFAULT '0',
569
`rank` INT NOT NULL DEFAULT '0',
570
`orderby` INT NOT NULL DEFAULT '0',
571
`description` TEXT COLLATE utf8_general_ci NOT NULL,
573
572
PRIMARY KEY (`question_id`,`rank`)
573
) ENGINE=InnoDB COLLATE = utf8_general_ci
575
574
show create table redirects;
576
575
Table Create Table
577
576
redirects CREATE TABLE `redirects` (
578
`redirects_id` int NOT NULL DEFAULT '0',
577
`redirects_id` INT NOT NULL DEFAULT '0',
578
`url` TEXT COLLATE utf8_general_ci NOT NULL,
580
579
PRIMARY KEY (`redirects_id`)
580
) ENGINE=InnoDB COLLATE = utf8_general_ci
582
581
show create table releases;
583
582
Table Create Table
584
583
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,
584
`releases_id` INT NOT NULL DEFAULT '0',
585
`branch_id` INT NOT NULL DEFAULT '0',
586
`description` TEXT COLLATE utf8_general_ci,
587
`url_targz` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
588
`url_osx` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
589
`url_rpm` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
590
`project_id` INT NOT NULL DEFAULT '0',
591
`version` VARCHAR(30) COLLATE utf8_general_ci NOT NULL DEFAULT 'latest',
592
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
593
`url_source_rpm` VARCHAR(250) COLLATE utf8_general_ci NOT NULL,
595
594
PRIMARY KEY (`releases_id`)
595
) ENGINE=InnoDB COLLATE = utf8_general_ci
597
596
show create table revision;
598
597
Table Create Table
599
598
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,
599
`node_id` INT NOT NULL DEFAULT '0',
600
`inside_workspace` INT NOT NULL DEFAULT '0',
601
`revision_id` INT NOT NULL DEFAULT '0',
602
`xml` TEXT COLLATE utf8_general_ci NOT NULL,
603
`tstamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
605
604
PRIMARY KEY (`node_id`,`inside_workspace`,`revision_id`)
605
) ENGINE=InnoDB COLLATE = utf8_general_ci
607
606
show create table setting;
608
607
Table Create Table
609
608
setting CREATE TABLE `setting` (
610
`setting_id` int NOT NULL AUTO_INCREMENT,
611
`vars` text NOT NULL,
609
`setting_id` INT NOT NULL AUTO_INCREMENT,
610
`vars` TEXT COLLATE utf8_general_ci NOT NULL,
612
611
PRIMARY KEY (`setting_id`)
612
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=623
614
613
show create table symlink;
615
614
Table Create Table
616
615
symlink CREATE TABLE `symlink` (
617
`symlink_id` int NOT NULL DEFAULT '0',
618
`symlink_node` int NOT NULL DEFAULT '0',
616
`symlink_id` INT NOT NULL DEFAULT '0',
617
`symlink_node` INT NOT NULL DEFAULT '0',
619
618
PRIMARY KEY (`symlink_id`)
619
) ENGINE=InnoDB COLLATE = utf8_general_ci
621
620
show create table themesetting;
622
621
Table Create Table
623
622
themesetting CREATE TABLE `themesetting` (
624
`themesetting_id` int NOT NULL DEFAULT '0',
625
`parent_theme` int NOT NULL DEFAULT '0',
623
`themesetting_id` INT NOT NULL DEFAULT '0',
624
`parent_theme` INT NOT NULL DEFAULT '0',
626
625
PRIMARY KEY (`themesetting_id`)
626
) ENGINE=InnoDB COLLATE = utf8_general_ci
628
627
show create table typeversion;
629
628
Table Create Table
630
629
typeversion CREATE TABLE `typeversion` (
631
`typeversion_id` int NOT NULL DEFAULT '0',
632
`version` int NOT NULL DEFAULT '0',
630
`typeversion_id` INT NOT NULL DEFAULT '0',
631
`version` INT NOT NULL DEFAULT '0',
633
632
PRIMARY KEY (`typeversion_id`)
633
) ENGINE=InnoDB COLLATE = utf8_general_ci
635
634
show create table user;
636
635
Table Create Table
637
636
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',
637
`user_id` INT NOT NULL AUTO_INCREMENT,
638
`nick` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
639
`passwd` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
640
`realname` VARCHAR(40) COLLATE utf8_general_ci DEFAULT NULL,
641
`email` VARCHAR(40) COLLATE utf8_general_ci DEFAULT NULL,
642
`lasttime` DATETIME DEFAULT NULL,
643
`karma` INT DEFAULT '0',
644
`inside_workspace` INT NOT NULL DEFAULT '0',
646
645
PRIMARY KEY (`user_id`)
646
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=623
648
647
show create table version;
649
648
Table Create Table
650
649
version CREATE TABLE `version` (
651
`version_id` int NOT NULL DEFAULT '0',
652
`version` int NOT NULL DEFAULT '1',
650
`version_id` INT NOT NULL DEFAULT '0',
651
`version` INT NOT NULL DEFAULT '1',
653
652
PRIMARY KEY (`version_id`)
653
) ENGINE=InnoDB COLLATE = utf8_general_ci
655
654
show create table weblog;
656
655
Table Create Table
657
656
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,
657
`tstamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
658
`linkedby_user` INT NOT NULL DEFAULT '0',
659
`removedby_user` INT NOT NULL DEFAULT '0',
660
`linkedtime` DATETIME NOT NULL,
661
`weblog_id` INT NOT NULL DEFAULT '0',
662
`to_node` INT NOT NULL DEFAULT '0',
663
`entry_id` INT NOT NULL AUTO_INCREMENT,
665
664
PRIMARY KEY (`entry_id`),
666
665
KEY `tstamp` (`tstamp`)
666
) ENGINE=InnoDB COLLATE = utf8_general_ci
668
667
show create table workspace;
669
668
Table Create Table
670
669
workspace CREATE TABLE `workspace` (
671
`workspace_id` int NOT NULL DEFAULT '0',
670
`workspace_id` INT NOT NULL DEFAULT '0',
672
671
PRIMARY KEY (`workspace_id`)
672
) ENGINE=InnoDB COLLATE = utf8_general_ci
674
673
show columns from branch;
675
674
Field Type Null Default Default_is_NULL On_Update
676
branch_id INTEGER FALSE 0 FALSE
677
project_id INTEGER FALSE 0 FALSE
675
branch_id INTEGER NO 0 NO
676
project_id INTEGER NO 0 NO
678
677
show columns from container;
679
678
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
679
container_id INTEGER NO NO
681
parent_container INTEGER YES YES
683
682
show columns from document;
684
683
Field Type Null Default Default_is_NULL On_Update
685
document_id INTEGER FALSE FALSE
686
doctext BLOB TRUE TRUE
684
document_id INTEGER NO NO
687
686
show columns from genstats_attributes;
688
687
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
688
genstats_attributes_id INTEGER NO 0 NO
689
predicates TEXT NO NO
690
attributes TEXT NO NO
692
691
show columns from htmlcode;
693
692
Field Type Null Default Default_is_NULL On_Update
694
htmlcode_id INTEGER FALSE FALSE
693
htmlcode_id INTEGER NO NO
696
695
show columns from htmlpage;
697
696
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
697
htmlpage_id INTEGER NO NO
698
pagetype_nodetype INTEGER YES YES
699
displaytype VARCHAR YES YES
701
parent_container INTEGER YES YES
702
ownedby_theme INTEGER NO 0 NO
703
permissionneeded VARCHAR NO r NO
704
MIMEtype VARCHAR NO text/html NO
706
705
show columns from image;
707
706
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
707
image_id INTEGER NO NO
710
thumbsrc VARCHAR YES YES
711
description TEXT YES YES
713
712
show columns from javascript;
714
713
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
714
javascript_id INTEGER NO 0 NO
717
dynamic INTEGER NO 0 NO
719
718
show columns from knowledge_item;
720
719
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
720
knowledge_item_id INTEGER NO 0 NO
722
question INTEGER NO 0 NO
724
723
show columns from links;
725
724
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
725
from_node INTEGER NO 0 NO
726
to_node INTEGER NO 0 NO
727
linktype INTEGER NO 0 NO
728
hits INTEGER YES 0 NO
729
food INTEGER YES 0 NO
731
730
show columns from mail;
732
731
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
732
mail_id INTEGER NO 0 NO
733
from_address VARCHAR NO NO
734
attachment_file INTEGER NO 0 NO
736
735
show columns from node;
737
736
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
737
node_id INTEGER NO NO
738
type_nodetype INTEGER NO 0 NO
740
author_user INTEGER NO 0 NO
741
createtime DATETIME NO NO
742
modified DATETIME NO NO
743
hits INTEGER YES 0 NO
744
loc_location INTEGER YES 0 NO
745
reputation INTEGER NO 0 NO
746
lockedby_user INTEGER NO 0 NO
747
locktime DATETIME NO NO
748
authoraccess VARCHAR NO iiii NO
749
groupaccess VARCHAR NO iiiii NO
750
otheraccess VARCHAR NO iiiii NO
751
guestaccess VARCHAR NO iiiii NO
752
dynamicauthor_permission INTEGER NO -1 NO
753
dynamicgroup_permission INTEGER NO -1 NO
754
dynamicother_permission INTEGER NO -1 NO
755
dynamicguest_permission INTEGER NO -1 NO
756
group_usergroup INTEGER NO -1 NO
758
757
show columns from nodegroup;
759
758
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
759
nodegroup_id INTEGER NO NO
761
node_id INTEGER NO 0 NO
762
orderby INTEGER YES YES
764
763
show columns from nodelet;
765
764
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
765
nodelet_id INTEGER NO NO
768
nlgoto INTEGER YES YES
769
parent_container INTEGER YES YES
770
lastupdate INTEGER NO 0 NO
771
updateinterval INTEGER NO 0 NO
772
mini_nodelet INTEGER NO 0 NO
774
773
show columns from nodemethod;
775
774
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
775
nodemethod_id INTEGER NO 0 NO
776
supports_nodetype INTEGER NO 0 NO
779
778
show columns from nodetype;
780
779
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
780
nodetype_id INTEGER NO NO
781
restrict_nodetype INTEGER YES 0 NO
782
extends_nodetype INTEGER YES 0 NO
783
restrictdupes INTEGER YES 0 NO
784
sqltable VARCHAR YES YES
785
grouptable VARCHAR YES NO
786
defaultauthoraccess VARCHAR NO iiii NO
787
defaultgroupaccess VARCHAR NO iiiii NO
788
defaultotheraccess VARCHAR NO iiiii NO
789
defaultguestaccess VARCHAR NO iiiii NO
790
defaultgroup_usergroup INTEGER NO -1 NO
791
defaultauthor_permission INTEGER NO -1 NO
792
defaultgroup_permission INTEGER NO -1 NO
793
defaultother_permission INTEGER NO -1 NO
794
defaultguest_permission INTEGER NO -1 NO
795
maxrevisions INTEGER NO -1 NO
796
canworkspace INTEGER NO -1 NO
798
797
show columns from project;
799
798
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()
799
project_id INTEGER NO 0 NO
800
description TEXT NO NO
801
last_update TIMESTAMP NO CURRENT_TIMESTAMP NO CURRENT_TIMESTAMP
802
short_description VARCHAR NO NO
803
url_cvs VARCHAR NO NO
804
url_faq VARCHAR NO NO
805
long_description TEXT NO NO
807
806
show columns from project_document;
808
807
Field Type Null Default Default_is_NULL On_Update
809
project_document_id INTEGER FALSE 0 FALSE
810
project_id INTEGER FALSE 0 FALSE
808
project_document_id INTEGER NO 0 NO
809
project_id INTEGER NO 0 NO
811
810
show columns from question;
812
811
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
812
question_id INTEGER NO 0 NO
813
faq_id INTEGER NO 0 NO
814
project_id INTEGER NO 0 NO
816
orderby INTEGER NO 0 NO
817
description TEXT NO NO
819
818
show columns from redirects;
820
819
Field Type Null Default Default_is_NULL On_Update
821
redirects_id INTEGER FALSE 0 FALSE
822
url BLOB FALSE 0 FALSE
820
redirects_id INTEGER NO 0 NO
823
822
show columns from releases;
824
823
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()
824
releases_id INTEGER NO 0 NO
825
branch_id INTEGER NO 0 NO
826
description TEXT YES YES
827
url_targz VARCHAR NO NO
828
url_osx VARCHAR NO NO
829
url_rpm VARCHAR NO NO
830
project_id INTEGER NO 0 NO
831
version VARCHAR NO latest NO
832
created TIMESTAMP NO CURRENT_TIMESTAMP NO CURRENT_TIMESTAMP
833
url_source_rpm VARCHAR NO NO
835
834
show columns from revision;
836
835
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()
836
node_id INTEGER NO 0 NO
837
inside_workspace INTEGER NO 0 NO
838
revision_id INTEGER NO 0 NO
840
tstamp TIMESTAMP NO CURRENT_TIMESTAMP NO CURRENT_TIMESTAMP
842
841
show columns from setting;
843
842
Field Type Null Default Default_is_NULL On_Update
844
setting_id INTEGER FALSE FALSE
845
vars BLOB FALSE FALSE
843
setting_id INTEGER NO NO
846
845
show columns from symlink;
847
846
Field Type Null Default Default_is_NULL On_Update
848
symlink_id INTEGER FALSE 0 FALSE
849
symlink_node INTEGER FALSE 0 FALSE
847
symlink_id INTEGER NO 0 NO
848
symlink_node INTEGER NO 0 NO
850
849
show columns from themesetting;
851
850
Field Type Null Default Default_is_NULL On_Update
852
themesetting_id INTEGER FALSE 0 FALSE
853
parent_theme INTEGER FALSE 0 FALSE
851
themesetting_id INTEGER NO 0 NO
852
parent_theme INTEGER NO 0 NO
854
853
show columns from typeversion;
855
854
Field Type Null Default Default_is_NULL On_Update
856
typeversion_id INTEGER FALSE 0 FALSE
857
version INTEGER FALSE 0 FALSE
855
typeversion_id INTEGER NO 0 NO
856
version INTEGER NO 0 NO
858
857
show columns from user;
859
858
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
859
user_id INTEGER NO NO
861
passwd VARCHAR YES YES
862
realname VARCHAR YES YES
863
email VARCHAR YES YES
864
lasttime DATETIME YES YES
865
karma INTEGER YES 0 NO
866
inside_workspace INTEGER NO 0 NO
868
867
show columns from version;
869
868
Field Type Null Default Default_is_NULL On_Update
870
version_id INTEGER FALSE 0 FALSE
871
version INTEGER FALSE 1 FALSE
869
version_id INTEGER NO 0 NO
870
version INTEGER NO 1 NO
872
871
show columns from weblog;
873
872
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()
873
tstamp TIMESTAMP NO CURRENT_TIMESTAMP NO CURRENT_TIMESTAMP
874
linkedby_user INTEGER NO 0 NO
875
removedby_user INTEGER NO 0 NO
876
linkedtime DATETIME NO NO
877
weblog_id INTEGER NO 0 NO
878
to_node INTEGER NO 0 NO
879
entry_id INTEGER NO NO
881
880
show columns from workspace;
882
881
Field Type Null Default Default_is_NULL On_Update
883
workspace_id INTEGER FALSE 0 FALSE
882
workspace_id INTEGER NO 0 NO
884
883
show indexes from branch;
885
884
Table Unique Key_name Seq_in_index Column_name
886
branch TRUE PRIMARY 1 branch_id
885
branch YES PRIMARY 1 branch_id
887
886
show indexes from container;
888
887
Table Unique Key_name Seq_in_index Column_name
889
container TRUE PRIMARY 1 container_id
888
container YES PRIMARY 1 container_id
890
889
show indexes from document;
891
890
Table Unique Key_name Seq_in_index Column_name
892
document TRUE PRIMARY 1 document_id
891
document YES PRIMARY 1 document_id
893
892
show indexes from genstats_attributes;
894
893
Table Unique Key_name Seq_in_index Column_name
895
genstats_attributes TRUE PRIMARY 1 genstats_attributes_id
894
genstats_attributes YES PRIMARY 1 genstats_attributes_id
896
895
show indexes from htmlcode;
897
896
Table Unique Key_name Seq_in_index Column_name
898
htmlcode TRUE PRIMARY 1 htmlcode_id
897
htmlcode YES PRIMARY 1 htmlcode_id
899
898
show indexes from htmlpage;
900
899
Table Unique Key_name Seq_in_index Column_name
901
htmlpage TRUE PRIMARY 1 htmlpage_id
900
htmlpage YES PRIMARY 1 htmlpage_id
902
901
show indexes from image;
903
902
Table Unique Key_name Seq_in_index Column_name
904
image TRUE PRIMARY 1 image_id
903
image YES PRIMARY 1 image_id
905
904
show indexes from javascript;
906
905
Table Unique Key_name Seq_in_index Column_name
907
javascript TRUE PRIMARY 1 javascript_id
906
javascript YES PRIMARY 1 javascript_id
908
907
show indexes from knowledge_item;
909
908
Table Unique Key_name Seq_in_index Column_name
910
knowledge_item TRUE PRIMARY 1 knowledge_item_id
909
knowledge_item YES PRIMARY 1 knowledge_item_id
911
910
show indexes from links;
912
911
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
912
links YES PRIMARY 1 from_node
913
links YES PRIMARY 2 to_node
914
links YES PRIMARY 3 linktype
916
915
show indexes from mail;
917
916
Table Unique Key_name Seq_in_index Column_name
918
mail TRUE PRIMARY 1 mail_id
917
mail YES PRIMARY 1 mail_id
919
918
show indexes from node;
920
919
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
920
node YES PRIMARY 1 node_id
921
node NO title 1 title
922
node NO title 2 type_nodetype
923
node NO author 1 author_user
924
node NO type 1 type_nodetype
926
925
show indexes from nodegroup;
927
926
Table Unique Key_name Seq_in_index Column_name
928
nodegroup TRUE PRIMARY 1 nodegroup_id
929
nodegroup TRUE PRIMARY 2 rank
927
nodegroup YES PRIMARY 1 nodegroup_id
928
nodegroup YES PRIMARY 2 rank
930
929
show indexes from nodelet;
931
930
Table Unique Key_name Seq_in_index Column_name
932
nodelet TRUE PRIMARY 1 nodelet_id
931
nodelet YES PRIMARY 1 nodelet_id
933
932
show indexes from nodemethod;
934
933
Table Unique Key_name Seq_in_index Column_name
935
nodemethod TRUE PRIMARY 1 nodemethod_id
934
nodemethod YES PRIMARY 1 nodemethod_id
936
935
show indexes from nodetype;
937
936
Table Unique Key_name Seq_in_index Column_name
938
nodetype TRUE PRIMARY 1 nodetype_id
937
nodetype YES PRIMARY 1 nodetype_id
939
938
show indexes from project;
940
939
Table Unique Key_name Seq_in_index Column_name
941
project TRUE PRIMARY 1 project_id
940
project YES PRIMARY 1 project_id
942
941
show indexes from project_document;
943
942
Table Unique Key_name Seq_in_index Column_name
944
project_document TRUE PRIMARY 1 project_document_id
943
project_document YES PRIMARY 1 project_document_id
945
944
show indexes from question;
946
945
Table Unique Key_name Seq_in_index Column_name
947
question TRUE PRIMARY 1 question_id
948
question TRUE PRIMARY 2 rank
946
question YES PRIMARY 1 question_id
947
question YES PRIMARY 2 rank
949
948
show indexes from redirects;
950
949
Table Unique Key_name Seq_in_index Column_name
951
redirects TRUE PRIMARY 1 redirects_id
950
redirects YES PRIMARY 1 redirects_id
952
951
show indexes from releases;
953
952
Table Unique Key_name Seq_in_index Column_name
954
releases TRUE PRIMARY 1 releases_id
953
releases YES PRIMARY 1 releases_id
955
954
show indexes from revision;
956
955
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
956
revision YES PRIMARY 1 node_id
957
revision YES PRIMARY 2 inside_workspace
958
revision YES PRIMARY 3 revision_id
960
959
show indexes from setting;
961
960
Table Unique Key_name Seq_in_index Column_name
962
setting TRUE PRIMARY 1 setting_id
961
setting YES PRIMARY 1 setting_id
963
962
show indexes from symlink;
964
963
Table Unique Key_name Seq_in_index Column_name
965
symlink TRUE PRIMARY 1 symlink_id
964
symlink YES PRIMARY 1 symlink_id
966
965
show indexes from themesetting;
967
966
Table Unique Key_name Seq_in_index Column_name
968
themesetting TRUE PRIMARY 1 themesetting_id
967
themesetting YES PRIMARY 1 themesetting_id
969
968
show indexes from typeversion;
970
969
Table Unique Key_name Seq_in_index Column_name
971
typeversion TRUE PRIMARY 1 typeversion_id
970
typeversion YES PRIMARY 1 typeversion_id
972
971
show indexes from user;
973
972
Table Unique Key_name Seq_in_index Column_name
974
user TRUE PRIMARY 1 user_id
973
user YES PRIMARY 1 user_id
975
974
show indexes from version;
976
975
Table Unique Key_name Seq_in_index Column_name
977
version TRUE PRIMARY 1 version_id
976
version YES PRIMARY 1 version_id
978
977
show indexes from weblog;
979
978
Table Unique Key_name Seq_in_index Column_name
980
weblog TRUE PRIMARY 1 entry_id
981
weblog FALSE tstamp 1 tstamp
979
weblog YES PRIMARY 1 entry_id
980
weblog NO tstamp 1 tstamp
982
981
show indexes from workspace;
983
982
Table Unique Key_name Seq_in_index Column_name
984
workspace TRUE PRIMARY 1 workspace_id
983
workspace YES PRIMARY 1 workspace_id
985
984
drop schema everything;