SQL statement for adding LEVEL 3 CATEGORY

[angelamartin]

Hello,

What is the SQL statement for adding level 3 category.

like:

Category level1
-Cagetory level2
--Category level3


Thank you in advance,
-angela

[Sergey Ten]

Hello angela,

Category level1 --- id - 1
-Cagetory level2 --- id - 2
--Category level3 --- id - 3


INSERT INTO `v21_categories` (`id_editor`, `id_parent`, `title`, `description`, `status`, `meta_description`, `meta_keywords`, `path`, `order`, `locked`, `unique_tpl`, `level`, `num_cols`, `neighbour`, `num_links`, `num_all_links`) VALUES (0, 2, 'Category level 3', '', 'active', '', '', 'category-level-3', 2, '0', '0', 1, NULL, NULL, 0, 0);

[angelamartin]

Hello,

The next one would be how to add new listing on LEVEL 3 CATEGORY using SQL command.

Thank you,

-angela

[Sergey Ten]

Hello angela,

Can you post your goal? :)

#1 You have to add links' information to table *_links.
#2 You have to add a relation to table *_link_categories. (id_link, id_category)