VbzCart/docs/tables/cat title x topic: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (moved VbzCart/tables/brs titles x topics to VbzCart/tables/cat title x topic: for consistency) |
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== | ||
* ''' | * '''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 ` | <section begin=sql /><mysql>DROP TABLE IF EXISTS `cat_title_x_topic`; | ||
CREATE TABLE ` | 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 " | `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
- used by: Template:Vbzcart/query, Template:Vbzcart/query
- history:
- 2011-09-28 renamed from brs_titles_x_topics to cat_title_x_topic
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 />