[HELP]Provlima me to Account Manager

[Justice]

Otan kanw extract to SQL apo to account manager m bgazi to parakatw..

 

[Err] 1060 - Duplicate column name 'email'

[Msg] Finished - Unsuccessfully

[kontomania]

Otan kanw extract to SQL apo to account manager m bgazi to parakatw..

 

[Err] 1060 - Duplicate column name 'email'

[Msg] Finished - Unsuccessfully

akrivos to idio k se emena otan kanw to back up -.- opios 3ereis as m stilei to msn tou se pm PLS

[cta8ic]

Otan kanw extract to SQL apo to account manager m bgazi to parakatw..

 

[Err] 1060 - Duplicate column name 'email'

[Msg] Finished - Unsuccessfully

 

gaga... file ani3e to file name.sql sou... kai psakse to email...kai zvise to mail p exei... kanto apo8ikefsi.. kai meta kanw pali k 8ase OK

[Justice]

to sql einai auto edw...

 

ALTER TABLE `accounts` ADD `email` VARCHAR( 255 ) NULL DEFAULT NULL ;

CREATE TABLE IF NOT EXISTS `account_data` (
  account_name VARCHAR(45) NOT NULL DEFAULT '',
  var  VARCHAR(20) NOT NULL DEFAULT '',
  value VARCHAR(255) ,
  PRIMARY KEY  (account_name,var)
);

#cleaning account

ALTER TABLE `accounts` ADD `created_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;
UPDATE `accounts` SET `created_time` = NOW( );

[cta8ic]

CREATE TABLE `accounts` (  `login` varchar(45) NOT NULL default '',  `password` varchar(45) default NULL, `lastactive` decimal(20,0) default NULL,  `access_level` int(11) default NULL,  `lastIP` varchar(20) default NULL,  `lastServer` int(4) default '1',  PRIMARY KEY  (`login`) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

#cleaning account

 

ALTER TABLE `accounts` ADD `created_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;

UPDATE `accounts` SET `created_time` = NOW( );

 

 

 

 

kane auto c/p sto  asd.sql file s...