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