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
m (Woozle moved page VbzCart/VbzCart/tables/cat title x topic to VbzCart/docs/tables/cat title x topic without leaving a redirect: part 3/5)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
==About==
==About==
* '''Status''': under development; may end up not being used
* '''used by''': {{vbzcart/query|qryTitleTopic_Topics}}, {{vbzcart/query|qryTitleTopic_Titles}}
* '''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 />

Latest revision as of 01:56, 25 February 2024

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 />