VbzCart/tables/cat title x topic: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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: qryTitleTopic_Topics, qryTitleTopic_Titles
- 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 />
