Difference between revisions of "VbzCart/tables/cat title x topic"
Jump to navigation
Jump to search
m (moved VbzCart/tables/brs titles x topics to VbzCart/tables/cat title x topic: for consistency) |
(also used by...) |
||
| (One intermediate revision by the same 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 23:26, 28 September 2011
About
- used by:
- REDIRECT Template:l/vc/query, qryTitleTopic_Titles
- history:
- 2011-09-28 renamed from brs_titles_x_topics to cat_title_x_topic
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>