Status: Evaluating bids

Implantação de Banco de Dados

Project details:
Budget: Open
Published: 10 months ago
Deadline: 10 days
Bids: 11
Interested freelancers: 12
Description:
Tenho um arquivo (jos_content.sql) com cerca de 100 megas de artigos de um antigo site na plataforma do Joomla 1.5 . Preciso inserir toda esta base para num site em joomla 3.0.

Segue parte inicial do arquivo até o primeiro INSERT:

(76, 'Export Content', 'option=com_export_content', 0, 0, 'option=com_export_content', 'Export Content', 'com_export_content', 0, 'js/ThemeOffice/component.png', 0, '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `jos_contact_details`
--

CREATE TABLE `jos_contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) collate latin1_general_ci NOT NULL default '',
`con_position` varchar(50) collate latin1_general_ci default NULL,
`address` text collate latin1_general_ci,
`suburb` varchar(50) collate latin1_general_ci default NULL,
`state` varchar(20) collate latin1_general_ci default NULL,
`country` varchar(50) collate latin1_general_ci default NULL,
`postcode` varchar(10) collate latin1_general_ci default NULL,
`telephone` varchar(25) collate latin1_general_ci default NULL,
`fax` varchar(25) collate latin1_general_ci default NULL,
`misc` mediumtext collate latin1_general_ci,
`image` varchar(100) collate latin1_general_ci default NULL,
`imagepos` varchar(20) collate latin1_general_ci default NULL,
`email_to` varchar(100) collate latin1_general_ci default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text collate latin1_general_ci NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;

--
-- Extraindo dados da tabela `jos_contact_details`
--

INSERT INTO `jos_contact_details` (`id`, `name`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`) VALUES (5, 'Trabalhista', '', '', '', '', '', '', '', '', '', '', NULL, 'trabalhista@buenoecostanze.adv.br', 0, 1, 0, '0000-00-00 00:00:00', 5, 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nrobots=-1\nmeta_description=\nmeta_keywords=\nmeta_author=', 0, 12, 0),
(4, 'Bueno & Costanze', '', '', '', '', '', '', '', '', '', '', NULL, 'franmarta@terra.com.br', 0, 1, 0, '0000-00-00 00:00:00', 6, 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nrobots=-1\nmeta_description=\nmeta_keywords=\nmeta_author=', 0, 12, 0),
(6, 'RH', '', '', '', '', '', '', '', '', '', '', NULL, 'rh@buenoecostanze.adv.br', 0, 1, 0, '0000-00-00 00:00:00', 4, 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nrobots=-1\nmeta_description=\nmeta_keywords=\nmeta_author=', 0, 12, 0),
(7, 'Criminal', '', '', '', '', '', '', '', '', '', '', NULL, 'criminal@buenoecostanze.adv.br', 0, 1, 0, '0000-00-00 00:00:00', 3, 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nrobots=-1\nmeta_description=\nmeta_keywords=\nmeta_author=', 0, 12, 0),
(8, 'Previdenciário', '', '', '', '', '', '', '', '', '', '', NULL, 'previdenciario@buenoecostanze.adv.br', 0, 1, 0, '0000-00-00 00:00:00', 2, 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nrobots=-1\nmeta_description=\nmeta_keywords=\nmeta_author=', 0, 12, 0),
(9, 'Civel', '', '', '', '', '', '', '', '', '', '', NULL, 'civel@buenoecostanze.adv.br', 0, 1, 0, '0000-00-00 00:00:00', 1, 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nrobots=-1\nmeta_description=\nmeta_keywords=\nmeta_author=', 0, 12, 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `jos_content`
--

CREATE TABLE `jos_content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) collate latin1_general_ci NOT NULL default '',
`title_alias` varchar(100) collate latin1_general_ci NOT NULL default '',
`introtext` mediumtext collate latin1_general_ci NOT NULL,
`fulltext` mediumtext collate latin1_general_ci NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) collate latin1_general_ci NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text collate latin1_general_ci NOT NULL,
`urls` text collate latin1_general_ci NOT NULL,
`attribs` text collate latin1_general_ci NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text collate latin1_general_ci NOT NULL,
`metadesc` text collate latin1_general_ci NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) ENGINE=MyISAM AUTO_INCREMENT=25240 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=25240 ;

--
-- Extraindo dados da tabela `jos_content`
--

INSERT INTO `jos_content` VALUES (1, 'Welcome to Joomla!', 'Welcome', 'If you''ve read anything at all about Content Management Systems (CMS), you''ll probably know at least three things: CMS are the most exciting way to do business, CMS can be really, I mean really, complicated and lastly Portals are absolutely, outrageously, often unaffordably expensive.

{mosimage}Joomla! is set to change all that ... Joomla! is different from the normal models for portal software. For a start, it''s not complicated. Joomla! has been developed for the masses. It''s licensed under the GNU/GPL license, easy to install and administer and reliable. Joomla! doesn''t even require the user or administrator of the system to know HTML to operate it once it''s up and running.', '
Joomla! features:
\r\n\r\n Completely database driven site engines
\r\n News, products or services sections fully editable and manageable
\r\n Topics sections can be added to by contributing authors
\r\n Fully customisable layouts including left, center and right menu boxes
\r\n Browser upload of images to your own library for use anywhere in the site
\r\n Dynamic Forum/Poll/Voting booth for on-the-spot results
\r\n Runs on Linux, FreeBSD, MacOSX server, Solaris and AIX \r\n
\r\n
Extensive Administration:
\r\n\r\n Change order of objects including news, FAQs, articles etc.
\r\n Random Newsflash generator
\r\n Remote author submission module for News, Articles, FAQs and Links
\r\n Object hierarchy - as many sections, departments, divisions and pages as you want
\r\n Image library - store all your PNGs, PDFs, DOCs, XLSs, GIFs and JPEGs online for easy use
\r\n Automatic Path-Finder. Place a picture and let Joomla! fix the link
\r\n News feed manager. Choose from over 360 news feeds from around the world
\r\n Archive manager. Put your old articles into cold storage rather than throw them out
\r\n Email-a-friend and Print-format for every story and article
\r\n In-line Text editor similar to Word Pad
\r\n User editable look and feel
\r\n Polls/Surveys - Now put a different one on each page
\r\n Custom Page Modules. Download custom page modules to spice up your site
\r\n Template Manager. Download templates and implement them in seconds
\r\n Layout preview. See how it looks before going live
\r\n Banner manager. Make money out of your site
', -2, 1, 0, 1, '2004-06-12 11:54:06', 62, 'Web Master', '2004-06-12 12:33:27', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', 'asterisk.png|left|Joomla! Logo|1|Example Caption|bottom|center|120', '', '', 1, 0, 5865, '', '', 0, 8);

Categoria: IT & Programação
Subcategoria: Desenvolvimento web
Isso é um projeto ou uma posição de trabalho?: Um projeto
Tenho, atualmente: Não se aplica
Experiência nesse tipo de projeto: Sim (Eu já gerenciei esse tipo de projeto)
Disponibilidade requerida: Meio período
Funções necessárias: Desenvolvedor
Do you need more information about this project?

Create your own project

Are you looking for a freelancer to work on a similar project? Create your own project and you'll receive proposals from the best freelancers.

Create a similar project

Client:

Edmar F.
(Rating 4.60 out of 5)
Location: Brasil
To find out more about this client, login to Workana.
Loading...