Catalog

 view release on metacpan or  search on metacpan

doc/catalog.texinfo  view on Meta::CPAN

  info set ('root'),
  #
  # Full name of the category
  #
  name varchar(255) not null,
  #
  # Total number of records in this category and bellow
  #
  count int default 0,
  #
  # External identifier to synchronize with alien catalogs
  #
  externalid varchar(32) not null default '',
)
@end example

@node catalog_category2category_<name>, catalog_entry2category_<name>, catalog_category_<name>, Catalog tables
@section catalog_category2category_<name>

@cindex catalog_category2category_<name> table
@cindex table catalog_category2category_<name>

doc/catalog.texinfo  view on Meta::CPAN

  info set ('hidden', 'symlink'),
  #
  # Rowid of father
  #
  up int not null,
  #
  # Rowid of child
  #
  down int not null,
  #
  # External identifier to synchronize with alien catalogs
  #
  externalid varchar(32) not null default '',
)
@end example

@node catalog_entry2category_<name>, catalog_path_<name>, catalog_category2category_<name>, Catalog tables
@section catalog_entry2category_<name>

@cindex catalog_entry2category_<name> table
@cindex table catalog_entry2category_<name>

doc/catalog.texinfo  view on Meta::CPAN

  info set ('hidden'),
  #
  # Rowid of the record from cataloged table
  #
  row int not null,
  #
  # Rowid of the category
  #
  category int not null,
  #
  # External identifier to synchronize with alien catalogs
  #
  externalid varchar(32) not null default '',
)
@end example

@node catalog_path_<name>, catalog_alpha_<name>, catalog_entry2category_<name>, Catalog tables
@section catalog_path_<name>

@cindex catalog_path_<name> table
@cindex table catalog_path_<name>

lib/Catalog/mysql/schema.pm  view on Meta::CPAN

  info set ('hidden'),
  #
  # Rowid of the record from catalogued table
  #
  row int not null,
  #
  # Rowid of the category
  #
  category int not null,
  #
  # External identifier to synchronize with alien catalogs
  #
  externalid varchar(32) not null default '',

  index catalog_entry2category_NAME2 (created),
  index catalog_entry2category_NAME3 (modified),
  unique catalog_entry2category_NAME4 (row,category),
  index catalog_entry2category_NAME5 (category),
  index catalog_entry2category_NAME6 (externalid)
)
",

lib/Catalog/mysql/schema.pm  view on Meta::CPAN

  info set ('root', 'displaygrandchild'),
  #
  # Full name of the category
  #
  name varchar(255) not null,
  #
  # Total number of records in this category and bellow
  #
  count int default 0,
  #
  # External identifier to synchronize with alien catalogs
  #
  externalid varchar(32) not null default '',

  unique catalog_category_NAME1 (rowid),
  index catalog_category_NAME2 (created),
  index catalog_category_NAME3 (modified),
  index catalog_category_NAME4 (name(122)),
  index catalog_category_NAME5 (externalid)
)
",

lib/Catalog/mysql/schema.pm  view on Meta::CPAN

  info set ('hidden', 'symlink'),
  #
  # Rowid of father
  #
  up int not null,
  #
  # Rowid of child
  #
  down int not null,
  #
  # External identifier to synchronize with alien catalogs
  #
  externalid varchar(32) not null default '',

  unique catalog_category2category_NAME1 (rowid),
  index catalog_category2category_NAME2 (created),
  index catalog_category2category_NAME3 (modified),
  unique catalog_category2category_NAME4 (up,down),
  index catalog_category2category_NAME5 (down),
  index catalog_category2category_NAME6 (externalid)
)