hi,
i am making my first product for vB, so i need to have some additional fields in the user table.
PHP Code:
ALTER TABLE `". TABLE_PREFIX ."user` ADD `canusesms` ENUM( 'yes', 'no', '1pd' ) NOT NULL DEFAULT 'no' ,
ADD `firstname` TEXT NOT NULL ,
ADD `lastname` TEXT NOT NULL ,
ADD `street` TEXT NOT NULL ,
ADD `zip` TEXT NOT NULL ,
ADD `city` TEXT NOT NULL ,
ADD `state` TEXT NOT NULL ,
ADD `country` TEXT NOT NULL ,
ADD `credits` VARCHAR( 255 ) NOT NULL DEFAULT '0',
ADD `mobile` VARCHAR( 25 ) NOT NULL ,
ADD `is_validated` char(1) default '0',
ADD `validation_code` text,
ADD `sentsms` varchar(255) default '0',
ADD `successfull_charges` varchar(255) default '0',
ADD `used_credits` varchar(255) NOT NULL default '0',
ADD `status` char(1) default '1',
ADD `signup_date` int(11) default '0',
ADD `last_login_ip` varchar(255) default NULL,
ADD `last_sms_ip` varchar(255) default NULL,
ADD `signup_ip` varchar(255) default NULL ;
is this a good solution to change the default users table structure or should i find another way to store these.....?
11-12-2006, 10:05 PM
ALTERing vb_user table structure?!
Hybrid Mode
