Difference between revisions of "AudioFerret/v2/cut x topic"
< AudioFerret | v2
Jump to navigation
Jump to search
m (Woozle moved page AudioFerret/v2/topic x cut to AudioFerret/v2/cut x topic without leaving a redirect: alphabetic; also, the common table (cut) should go first) |
(post-move update) |
||
| Line 3: | Line 3: | ||
** '''2012-12-24''' adapted from [[VbzCart/tables/cat title x topic]] | ** '''2012-12-24''' adapted from [[VbzCart/tables/cat title x topic]] | ||
==SQL== | ==SQL== | ||
| − | <mysql>CREATE TABLE ` | + | <mysql>CREATE TABLE `cut_x_topic` ( |
`ID_Cut` INT NOT NULL COMMENT "cuts.ID", | `ID_Cut` INT NOT NULL COMMENT "cuts.ID", | ||
`ID_Topic` INT NOT NULL COMMENT "topics.ID", | `ID_Topic` INT NOT NULL COMMENT "topics.ID", | ||
PRIMARY KEY(`ID_Cut`,`ID_Topic`) | PRIMARY KEY(`ID_Cut`,`ID_Topic`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
Latest revision as of 02:53, 25 December 2012
About
- History:
- 2012-12-24 adapted from VbzCart/tables/cat title x topic
SQL
<mysql>CREATE TABLE `cut_x_topic` (
`ID_Cut` INT NOT NULL COMMENT "cuts.ID", `ID_Topic` INT NOT NULL COMMENT "topics.ID", PRIMARY KEY(`ID_Cut`,`ID_Topic`)
) ENGINE = MYISAM;</mysql>