ops, i just dropped the accounts table!

[jnas]

What’s the best option for me to get back up and running? I, not bothered about the data as it was just the demo accounts...thankfully

Ive created a few custom fields and dont want to do a fresh install!

Thanks

j

[tluolamo]

Well the custom fields you added would be in the accounts_cstm table so if you dropped the default accounts table only, just reload that from backup or another install of sugar and you should be good to go.

[jnas]

thanks .. but i never performed a backup

you also suggested to do an install, do you mean just run through the install.php script from scratch? Will this not overwrite the existing data?

[tluolamo]

Basically you need to get hold of the create table for the accounts table so you can recreate it. If you don't have a single backup then best option is for you to do a fresh install on another computer and use the MySQL command "SHOW CREATE TABLE accounts" to get the create table script for accounts. Once you have that you can just execute it on the instance you are missing the accounts in and everything should be back to normal.

[Angel]

I pulled this script from one of my OS installs (4.5.1c). See if this helps:

CREATE TABLE `accounts` (                                       
            `id` char(36) NOT NULL,                                       
            `date_entered` datetime NOT NULL,                             
            `date_modified` datetime NOT NULL,                            
            `modified_user_id` char(36) NOT NULL,                         
            `assigned_user_id` char(36) default NULL,                     
            `created_by` char(36) default NULL,                           
            `name` varchar(150) default NULL,                             
            `parent_id` char(36) default NULL,                            
            `account_type` varchar(25) default NULL,                      
            `industry` varchar(25) default NULL,                          
            `annual_revenue` varchar(25) default NULL,                    
            `phone_fax` varchar(25) default NULL,                         
            `billing_address_street` varchar(150) default NULL,           
            `billing_address_city` varchar(100) default NULL,             
            `billing_address_state` varchar(100) default NULL,            
            `billing_address_postalcode` varchar(20) default NULL,        
            `billing_address_country` varchar(100) default NULL,          
            `description` text,                                           
            `rating` varchar(25) default NULL,                            
            `phone_office` varchar(25) default NULL,                      
            `phone_alternate` varchar(25) default NULL,                   
            `email1` varchar(100) default NULL,                           
            `email2` varchar(100) default NULL,                           
            `website` varchar(255) default NULL,                          
            `ownership` varchar(100) default NULL,                        
            `employees` varchar(10) default NULL,                         
            `sic_code` varchar(10) default NULL,                          
            `ticker_symbol` varchar(10) default NULL,                     
            `shipping_address_street` varchar(150) default NULL,          
            `shipping_address_city` varchar(100) default NULL,            
            `shipping_address_state` varchar(100) default NULL,           
            `shipping_address_postalcode` varchar(20) default NULL,       
            `shipping_address_country` varchar(100) default NULL,         
            `deleted` tinyint(1) NOT NULL default '0',                    
            `campaign_id` char(36) default NULL,                          
            PRIMARY KEY  (`id`),                                          
            KEY `idx_accnt_id_del` (`id`,`deleted`),                      
            KEY `idx_accnt_assigned_del` (`deleted`,`assigned_user_id`),  
            KEY `idx_accnt_parent_id` (`parent_id`)                       
          ) ENGINE=MyISAM DEFAULT CHARSET=utf8

[jnas]

thanks ;-)

am back on track!

J