VbzCart/docs/tables/cat pages: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (extracted from "tables" page) |
imported>Woozle (where the data comes from) |
||
| Line 1: | Line 1: | ||
==About== | ==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. | * '''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. | ||
* '''Built by''': {{vbzcart|proc|Upd_CatPages}} | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>DROP TABLE IF EXISTS `cat_pages`; | <section begin=sql /><mysql>DROP TABLE IF EXISTS `cat_pages`; | ||
Revision as of 17:38, 20 March 2011
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.
- Built by: Template:Vbzcart
SQL
<section begin=sql /><mysql>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`)
);</mysql> <section end=sql />