VbzCart/docs/tables/cat title x topic: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
imported>Woozle
(renamed from brs_* to cat_*)
Line 1: Line 1:
==About==
==About==
* '''Status''': under development; may end up not being used
* '''used by''': {{vbzcart/query|qryTitleTopic_Topics}}
* '''history''':
** '''2011-09-28''' renamed from '''brs_titles_x_topics''' to '''cat_title_x_topic'''
==SQL==
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_titles_x_topics`;
<section begin=sql /><mysql>DROP TABLE IF EXISTS `cat_title_x_topic`;
CREATE TABLE `brs_titles_x_topics` (
CREATE TABLE `cat_title_x_topic` (
   `ID_Title` INT NOT NULL COMMENT "cat_titles.ID",
   `ID_Title` INT NOT NULL COMMENT "cat_titles.ID",
   `ID_Topic` INT NOT NULL COMMENT "brs_topics.ID",
   `ID_Topic` INT NOT NULL COMMENT "cat_topic.ID",
   PRIMARY KEY(`ID_Title`,`ID_Topic`)
   PRIMARY KEY(`ID_Title`,`ID_Topic`)
) ENGINE = MYISAM;</mysql>
) ENGINE = MYISAM;</mysql>
<section end=sql />
<section end=sql />

Revision as of 23:15, 28 September 2011

About

SQL

<section begin=sql /><mysql>DROP TABLE IF EXISTS `cat_title_x_topic`; CREATE TABLE `cat_title_x_topic` (

 `ID_Title` INT NOT NULL COMMENT "cat_titles.ID",
 `ID_Topic` INT NOT NULL COMMENT "cat_topic.ID",
 PRIMARY KEY(`ID_Title`,`ID_Topic`)

) ENGINE = MYISAM;</mysql> <section end=sql />