Results 1 to 3 of 3

Thread: Database Alter

  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Default Database Alter

    I saw the INDEXU demo and I want know if it's possible use the alter table function for different db tables like users table or category table.
    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Atlanta GA
    Posts
    3,395

    Default

    Quote Originally Posted by roccotocco
    I saw the INDEXU demo and I want know if it's possible use the alter table function for different db tables like users table or category table.
    Thanks
    yes and no. you can only use the alter table function to add new fields to the idx_link table.

    but you can use the "QUERY" box to run a SQL command for any table. such as adding a field to the idx_category table


    .
    Last edited by esm; 04-14-2006 at 05:59 PM.
    esm
    "The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."

    .

  3. #3
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    3,732

    Default

    I'm not quite sure with your question, but you can have custom fields for links data (idx_link table) and use it no code modification.

    You can not do the sameway for other tables such as user and category. Altering these tables will require code modification.

Similar Threads

  1. date field on alter
    By inspireme in forum v5.x
    Replies: 0
    Last Post: 01-17-2005, 09:32 AM
  2. v4 database prefix
    By persut in forum v3.2
    Replies: 1
    Last Post: 04-29-2004, 11:50 AM
  3. Replies: 5
    Last Post: 08-16-2003, 03:20 PM
  4. upgrade database V2/V3.1
    By yvon in forum v5.x
    Replies: 2
    Last Post: 05-17-2003, 03:11 PM
  5. enum option for alter tables
    By kaelin in forum v3.2
    Replies: 0
    Last Post: 03-05-2003, 09:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •