VbzCart/tables/cat pages

From HTYP, the free directory anyone can edit

Jump to: navigation, search

[edit] About

  • Purpose: This turned out to be the only non-klugey way to translate between requested URL and which page to display. It's also the data-driven equivalent of the old static-page-generation system, upon which the URL scheme is still based – so it's inherently less likely to result in URL-decoding anomalies. I think.

[edit] SQL

DROP TABLE IF EXISTS `cat_pages`;
CREATE TABLE `cat_pages` (
  `AB` VARCHAR(31) NOT NULL COMMENT "Type+ID_Row: unique identifier",
  `Path` VARCHAR(63) NOT NULL COMMENT 'URI of page',
  `ID_Row` INT NOT NULL COMMENT 'ID of row from appropriate table',
  `Type` CHAR NOT NULL COMMENT 'type of page: S=supplier, D=dept, T=title, I=image',
  PRIMARY KEY(`AB`),
  UNIQUE KEY(`Path`)
);
Retrieved from "http://htyp.org/VbzCart/tables/cat_pages"
Personal tools