view release on metacpan or  search on metacpan

doc/catalog.texinfo  view on Meta::CPAN

  #
  # Order clause
  #
  corder varchar(128),
  #
  # Where clause
  #
  cwhere varchar(128),
  #
  # (alpha, date only) name of the field for sorting
  #
  fieldname varchar(60),
  #
  # (theme only) rowid of the root in catalog_category_<name>
  #
  root int not null,
  #
  # (theme only) full path name of the location to dump pages
  #
  dump varchar(255),
  #
  # (theme only) the location from which the dumped pages will be accessed
  #
  dumplocation varchar(255),

  unique catalog1 (rowid),
  unique catalog2 (name)
)
@end example

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

@cindex catalog_category_<name> table
@cindex table catalog_category_<name>

Describe a category (theme only).

@example
create table catalog_category_<name> (
  #
  # Table management information 
  #
  rowid int autoincrement
  created datetime not null,
  modified timestamp not null,

  #
  # State information
  #
  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>

Link two categories (theme only).

@example
create table catalog_category2category_<name> (
  #
  # Table management information 
  #
  rowid int autoincrement,
  created datetime not null,
  modified timestamp not null,

  #
  # State information
  #
  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>

Link a record from the cataloged table with a category (theme only).

@example
create table catalog_entry2category_<name> (
  #
  # Table management information 
  #
  created datetime not null,
  modified timestamp not null,

  #
  # State information
  #
  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>

Maps category id to category path (theme only).

@example
create table catalog_path_<name> (
  #
  # Full path name of the category
  #
  pathname text not null,
  #
  # MD5 key of the path name
  #
  md5 char(32) not null,
  #
  # Full path name translated to ids
  #
  path varchar(128) not null,
  #
  # Id of the last component
  #
  id int not null,

  unique catalog_path_NAME1 (md5),
  unique catalog_path_NAME2 (path),
  unique catalog_path_NAME3 (id)
)
@end example

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

@cindex catalog_alpha_<name> table
@cindex table catalog_alpha_<name>

Count information for each letter (alpha only).

@example
create table catalog_alpha_NAME (
  #
  # Table management information 
  #
  rowid int autoincrement,
  created datetime not null,
  modified timestamp not null,

  #
  # The letter
  #
  letter char(1) not null,
  #