687
688
show columns from genstats_attributes;
688
689
Field Type Null Default Default_is_NULL On_Update
689
690
genstats_attributes_id INTEGER FALSE 0 FALSE
690
predicates BLOB FALSE 0 FALSE
691
attributes BLOB FALSE 0 FALSE
691
predicates BLOB FALSE FALSE
692
attributes BLOB FALSE FALSE
692
693
show columns from htmlcode;
693
694
Field Type Null Default Default_is_NULL On_Update
694
695
htmlcode_id INTEGER FALSE FALSE
713
714
show columns from javascript;
714
715
Field Type Null Default Default_is_NULL On_Update
715
716
javascript_id INTEGER FALSE 0 FALSE
716
code BLOB FALSE 0 FALSE
717
comment BLOB FALSE 0 FALSE
717
code BLOB FALSE FALSE
718
comment BLOB FALSE FALSE
718
719
dynamic INTEGER FALSE 0 FALSE
719
720
show columns from knowledge_item;
720
721
Field Type Null Default Default_is_NULL On_Update
721
722
knowledge_item_id INTEGER FALSE 0 FALSE
722
item BLOB FALSE 0 FALSE
723
item BLOB FALSE FALSE
723
724
question INTEGER FALSE 0 FALSE
724
725
show columns from links;
725
726
Field Type Null Default Default_is_NULL On_Update
731
732
show columns from mail;
732
733
Field Type Null Default Default_is_NULL On_Update
733
734
mail_id INTEGER FALSE 0 FALSE
734
from_address VARCHAR FALSE 0 FALSE
735
from_address VARCHAR FALSE FALSE
735
736
attachment_file INTEGER FALSE 0 FALSE
736
737
show columns from node;
737
738
Field Type Null Default Default_is_NULL On_Update
738
739
node_id INTEGER FALSE FALSE
739
740
type_nodetype INTEGER FALSE 0 FALSE
740
title VARCHAR FALSE 0 FALSE
741
title VARCHAR FALSE FALSE
741
742
author_user INTEGER FALSE 0 FALSE
742
createtime DATETIME FALSE 0 FALSE
743
modified DATETIME FALSE 0 FALSE
743
createtime DATETIME FALSE FALSE
744
modified DATETIME FALSE FALSE
744
745
hits INTEGER TRUE 0 FALSE
745
746
loc_location INTEGER TRUE 0 FALSE
746
747
reputation INTEGER FALSE 0 FALSE
747
748
lockedby_user INTEGER FALSE 0 FALSE
748
locktime DATETIME FALSE 0 FALSE
749
locktime DATETIME FALSE FALSE
749
750
authoraccess VARCHAR FALSE iiii FALSE
750
751
groupaccess VARCHAR FALSE iiiii FALSE
751
752
otheraccess VARCHAR FALSE iiiii FALSE
760
761
nodegroup_id INTEGER FALSE FALSE
761
762
rank INTEGER FALSE 0 FALSE
762
763
node_id INTEGER FALSE 0 FALSE
763
orderby INTEGER TRUE 0 TRUE
764
orderby INTEGER TRUE TRUE
764
765
show columns from nodelet;
765
766
Field Type Null Default Default_is_NULL On_Update
766
767
nodelet_id INTEGER FALSE FALSE
775
776
Field Type Null Default Default_is_NULL On_Update
776
777
nodemethod_id INTEGER FALSE 0 FALSE
777
778
supports_nodetype INTEGER FALSE 0 FALSE
778
code BLOB FALSE 0 FALSE
779
code BLOB FALSE FALSE
779
780
show columns from nodetype;
780
781
Field Type Null Default Default_is_NULL On_Update
781
782
nodetype_id INTEGER FALSE FALSE
782
783
restrict_nodetype INTEGER TRUE 0 FALSE
783
784
extends_nodetype INTEGER TRUE 0 FALSE
784
785
restrictdupes INTEGER TRUE 0 FALSE
785
sqltable VARCHAR TRUE 0 TRUE
786
grouptable VARCHAR TRUE 0 FALSE
786
sqltable VARCHAR TRUE TRUE
787
grouptable VARCHAR TRUE FALSE
787
788
defaultauthoraccess VARCHAR FALSE iiii FALSE
788
789
defaultgroupaccess VARCHAR FALSE iiiii FALSE
789
790
defaultotheraccess VARCHAR FALSE iiiii FALSE
798
799
show columns from project;
799
800
Field Type Null Default Default_is_NULL On_Update
800
801
project_id INTEGER FALSE 0 FALSE
801
description BLOB FALSE 0 FALSE
802
description BLOB FALSE FALSE
802
803
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()
804
short_description VARCHAR FALSE FALSE
805
url_cvs VARCHAR FALSE FALSE
806
url_faq VARCHAR FALSE FALSE
807
long_description BLOB FALSE FALSE
807
808
show columns from project_document;
808
809
Field Type Null Default Default_is_NULL On_Update
809
810
project_document_id INTEGER FALSE 0 FALSE
815
816
project_id INTEGER FALSE 0 FALSE
816
817
rank INTEGER FALSE 0 FALSE
817
818
orderby INTEGER FALSE 0 FALSE
818
description BLOB FALSE 0 FALSE
819
description BLOB FALSE FALSE
819
820
show columns from redirects;
820
821
Field Type Null Default Default_is_NULL On_Update
821
822
redirects_id INTEGER FALSE 0 FALSE
822
url BLOB FALSE 0 FALSE
823
824
show columns from releases;
824
825
Field Type Null Default Default_is_NULL On_Update
825
826
releases_id INTEGER FALSE 0 FALSE
826
827
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
828
description BLOB TRUE TRUE
829
url_targz VARCHAR FALSE FALSE
830
url_osx VARCHAR FALSE FALSE
831
url_rpm VARCHAR FALSE FALSE
831
832
project_id INTEGER FALSE 0 FALSE
832
833
version VARCHAR FALSE latest FALSE
833
834
created TIMESTAMP FALSE NOW() FALSE NOW()
834
url_source_rpm VARCHAR FALSE NOW() FALSE NOW()
835
url_source_rpm VARCHAR FALSE FALSE
835
836
show columns from revision;
836
837
Field Type Null Default Default_is_NULL On_Update
837
838
node_id INTEGER FALSE 0 FALSE
838
839
inside_workspace INTEGER FALSE 0 FALSE
839
840
revision_id INTEGER FALSE 0 FALSE
840
xml BLOB FALSE 0 FALSE
841
842
tstamp TIMESTAMP FALSE NOW() FALSE NOW()
842
843
show columns from setting;
843
844
Field Type Null Default Default_is_NULL On_Update
872
873
show columns from weblog;
873
874
Field Type Null Default Default_is_NULL On_Update
874
875
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()
876
linkedby_user INTEGER FALSE 0 FALSE
877
removedby_user INTEGER FALSE 0 FALSE
878
linkedtime DATETIME FALSE FALSE
879
weblog_id INTEGER FALSE 0 FALSE
880
to_node INTEGER FALSE 0 FALSE
881
entry_id INTEGER FALSE FALSE
881
882
show columns from workspace;
882
883
Field Type Null Default Default_is_NULL On_Update
883
884
workspace_id INTEGER FALSE 0 FALSE