Need help in creating table in Mysql

blackpearl · 09-05-2008, 08:24 PM

I'm trying a template making engine called Template blocks, where the setup should create some tables in the database. But for some reason the tables are not created. I contacted support and they said i could manually create those tables. Now i know nothing about Mysql. Can somebody tell me the process and the commands I should give to create them? The tables are described in the file attached.

victor_rambo · 09-05-2008, 08:46 PM

1. Go to cPanel and create the database with name 'template_blocks'. If database is created proceed, to next step.
2. Go to phpMyAdmin and select the database that you just created.
3. Click on the 'SQL' tab.(refer to below figure)

4. Paste the below lines into the above shown textarea and hit 'go':
Note: I am not sure how it would work because variable 'TABLE_PREFIX' is not declared. To solve this issue, use the 'Find and replace function'. Replace '{{TABLE_PREFIX}}' with prefix of your choice or leave it blank.

Also I am doubtful about the last character in this code. Looks like some character encoding related problem to me. Please check that again.

Quote:

-- --------------------------------------------------------
--
-- Table structure for table `blocks`
--
CREATE TABLE IF NOT EXISTS `{{TABLE_PREFIX}}blocks` ( `id` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL, `type` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `blocks`
--
INSERT INTO `{{TABLE_PREFIX}}blocks` (`id`, `title`, `type`) VALUES (1, 'header', 'HTML'), (2, 'topbar', 'PHP'), (3, 'sidebar', 'HTML'), (4, 'footer', 'HTML'), (5, 'styles', 'CSS'), (6, 'additional head', 'HTML');
-- --------------------------------------------------------
--
-- Table structure for table `sections`
--
CREATE TABLE IF NOT EXISTS `{{TABLE_PREFIX}}sections` ( `id` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL, `slug` varchar(50) NOT NULL, `template` varchar(10) NOT NULL, `content` longtext NOT NULL, `position` varchar(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `sections`
--
INSERT INTO `{{TABLE_PREFIX}}sections` (`id`, `title`, `slug`, `template`, `content`, `position`) VALUES (1, 'Home page', 'index', '1', '<h2>A Sample Title</h2>\n\nWelcome to your new website. This is some sample content entered just to jump-start in creating your website. Sorry if it looks too plain for your taste but the intention is to make it as easier to customize as possible.\n\nYou will find some basic styles in the styles block that you can alter to your liking and there are also some other blocks there that create the tempalte you are viewing.\n\n<a href="$Template_dir/admin.php">Login now to your administration and start editing</a>\n\nMore dummy text follows...\n\nNulla mattis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Ut sem orci, egestas sed, pellentesque at, tempus ut, dolor. Aenean molestie feugiat tortor. Praesent in augue nec odio adipiscing consequat. Suspendisse ut nibh id mi venenatis vulputate. Nullam felis leo, faucibus eget, ullamcorper eu, porttitor et, felis. Aenean aliquam, arcu eu placerat elementum, ante sapien tempus quam, vitae feugiat est magna sed risus. Aenean elit nisl, rhoncus a, varius fermentum, congue nec, dui. Vestibulum lacus velit, auctor non, porttitor cursus, euismod non, ligula. Nullam dolor neque, scelerisque vitae, aliquam eget, porta quis, libero. Praesent diam quam, tempor non, ornare id, iaculis a, nisl.\n\nProin ultricies ullamcorper nisl. Sed consequat rutrum turpis. Ut consectetuer orci scelerisque urna volutpat elementum. Aliquam interdum erat. Suspendisse tristique tempor ligula. Sed lobortis est sit amet massa. Nulla facilisi. Cras feugiat luctus sapien. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut elit pede, sollicitudin dignissim, fringilla a, facilisis ut, felis. Pellentesque nec velit. Donec lacus nulla, egestas ut, condimentum quis, volutpat non, dui. Praesent varius. In hac habitasse platea dictumst. Curabitur vitae odio. Maecenas risus. Maecenas vitae elit. Curabitur vitae leo eget justo convallis dapibus. In pede. ', '0(0)'), (2, 'About Us', 'about', '1', 'Sample text for the "about us" page', '0(1)'), (3, 'Contact', 'contact', '1', 'contact form...', '0(2)');
-- --------------------------------------------------------
--
-- Table structure for table `templates`
--
CREATE TABLE IF NOT EXISTS `{{TABLE_PREFIX}}templates` ( `id` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL, `type` varchar(200) NOT NULL, `blocks` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `templates`
--
INSERT INTO `{{TABLE_PREFIX}}templates` (`id`, `title`, `type`, `blocks`) VALUES (1, 'Main', 'XHTML 1.0 Transitional', '5|6#1|2|3|X|4');