Difference between revisions of "VbzCart/tables/cat title x topic"
Jump to navigation
Jump to search
(New page: ==About== * '''Status''': under development; may end up not being used ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_titles_x_topics`; CREATE TABLE `brs_titles_x_topics` ( ...) |
(also used by...) |
||
(2 intermediate revisions 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>