SET FOREIGN_KEY_CHECKS=0; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; INSERT INTO `account` (`id`, `registration_date`, `username`, `password`, `notes`, `last_login`, `login_count`, `online`, `onetime_password`, `valid_password`, `type_id`, `status_id`, `person_id`) VALUES (1, '2008-06-10 19:36:18', 'joeshmoe', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', '', '2011-11-12 23:12:15', 171, 0, 0, 1, 1, 1, 1), (2, '2011-11-12 23:25:56', 'Harold', '2939094f35a3badf2a890768ba034fa5eb16e95e', NULL, '2011-11-12 23:25:57', 0, 1, 0, 1, 1, 1, 3), (3, '2011-11-12 23:29:33', 'Mary', '61bb8d29b5be7db307cb29005bff087ebe300454', NULL, '2011-11-12 23:30:42', 1, 1, 0, 1, 1, 1, 4); INSERT INTO `address` (`id`, `title`, `person_id`, `street_1`, `street_2`, `suburb`, `city`, `county`, `zone_id`, `country_id`, `postal_code`, `is_current`, `type_id`, `creation_date`, `last_modification`) VALUES (1, 'My primary address', 1, '113 Any Street', 'Apt. 3', 'Bronx', 'New York', '', 43, 223, '12345', 1, 1, '2008-05-31 18:20:52', '0000-00-00 00:00:00'), (2, 'Office', 1, '431 Office Street', '', '', 'Commerce City', 'Laredo', 13, 223, '09889', 1, 3, '2008-07-14 09:09:36', '0000-00-00 00:00:00'), (3, '', 2, '234 Pine Street', 'Apt 1', '', 'Boulder', 'Boulder', 13, 223, '80302', 1, 5, '2008-09-26 10:55:35', '0000-00-00 00:00:00'), (4, NULL, 3, 'My street 101', 'Apt 3', 'Somerville', 'Boston', '', 32, 223, '03293', 1, 1, '2011-11-12 23:25:56', '0000-00-00 00:00:00'), (5, NULL, 4, '23 Penny Lane', '#67', '', 'Los Angeles', '', 12, 223, '98765', 1, 1, '2011-11-12 23:29:33', '0000-00-00 00:00:00'); INSERT INTO `content_block` (`id`, `name`, `cssclass`, `title`, `description`, `show_title`, `show_description`, `collapsable`, `sort_order`, `parent_content_block_id`, `location_id`) VALUES (1, 'About Quinta', 'aboutUs', 'About Quinta CMS', 'A little about Quinta ..', 1, 0, 1, 2, NULL, 4), (2, 'HomeNews', 'homenews', 'Recent News', 'Latest Quinta CMS development news', 1, 1, 0, 3, NULL, 4), (4, 'TopLeft', '', 'A Test Block', '', 1, 0, 0, 0, NULL, 3), (5, 'LeftMenuBlock', '', '', '', 0, 0, 0, 0, NULL, 5), (7, 'LoginBox', 'Login', 'Member Login', '', 0, 0, 0, 0, NULL, 1), (8, 'TopMenuBlock', 'MainMenu', '', '', 0, 0, 0, 0, NULL, 4), (9, 'CreateAccountBlock', '', '', '', 0, 0, 0, 1, NULL, 4), (10, 'MemberHomeMenuBlock', 'MemberHomeMenu', '', '', 0, 0, 0, 0, 5, 5), (12, 'AccountManagerBlock', '', '', '', 0, 0, 0, 1, NULL, 4), (15, 'ShoppingCartBox', 'CartBox', '', '', 0, 0, 1, 1, NULL, 5), (16, 'ProductDisplayBlock', 'ProductDisplay', '', '', 0, 0, 0, 1, NULL, 4), (17, 'ShoppingCartView', '', '', '', 0, 0, 0, 1, NULL, 4), (18, 'CheckOutBlock', 'CheckOut', '', '', 0, 0, 0, 1, NULL, 4), (19, 'PayPalExpressReturn', 'OrderConfirmation', '', '', 0, 0, 0, 1, NULL, 4), (20, 'LostPasswordBlock', 'LostPassword', 'Password / Username Retrieval', 'Here you can reset your username or password', 1, 1, 0, 1, NULL, 4), (21, 'FooterInfo', '', '', '', 0, 0, 0, 0, NULL, 2), (22, 'Help Section', '', 'Quinta CMS Help', 'This is an example content block description ..', 1, 1, 0, 1, NULL, 4); INSERT INTO `content_block_page_assn` (`content_block_id`, `page_id`) VALUES (1, 1), (2, 1), (4, 1), (5, 1), (5, 2), (5, 5), (5, 6), (5, 7), (5, 9), (5, 10), (7, 1), (7, 2), (7, 5), (7, 6), (7, 7), (7, 8), (7, 9), (7, 10), (8, 1), (8, 2), (8, 4), (8, 5), (8, 6), (8, 7), (8, 8), (8, 9), (8, 10), (9, 4), (10, 8), (12, 5), (15, 1), (15, 2), (15, 5), (15, 6), (15, 7), (15, 8), (16, 8), (17, 9), (18, 10), (20, 12), (21, 1), (21, 2), (21, 4), (21, 5), (21, 6), (21, 7), (21, 8), (21, 9), (21, 10), (21, 11), (21, 12), (22, 7); INSERT INTO `content_item` (`id`, `name`, `cssclass`, `title`, `description`, `text`, `sort_order`, `show_title`, `show_description`, `show_creator`, `show_creation_date`, `show_last_modification`, `creator_id`, `copyright_notice`, `creation_date`, `last_modification`, `type_id`, `status_id`) VALUES (1, 'About Quinta', 'about_quinta_content', 'Welcome to Quinta CMS!', 'An extensible Qcodo powered e-commerce CMS platform', '
Quinta CMS is a development platform for building and maintaining websites powered by the QCodo web development framework. It is intended as an aid for QCodo developers to take care of many of the "boilerplate" tasks involved in setting up a website. Quinta is designed to be simple to use, easy to extend and very flexible. Out of the box it provides:
\n\n
\n
Quinta is intended to be styled using CSS and modified to suit individual needs.
\nAs of this release (Version 0.3), Quinta is in a very early stage - this release is functional but under development, there is much to be done.
\nWARNING: At the risk of repeating myself, this is a very early version! I am not a security expert and both Quinta and QCodo have yet to be audited for security!! I have done what I can but there is No Guarantee - USE AT YOUR OWN RISK!!
\nNOTE: You can log in above as "joeshmoe" with the password "password" and use the account management tools. You can also visit the Administration interface (currently "The Dashboard" ..) by replacing index.php with admin/ in your browser. Also, you can see the documentation for more details about Quinta under doc/ (like admin/) to learn more about the API and architecture.
\nNote ALSO - currently the admin interface is not integrated with the CMS and there is no login or access control
\nYou are free to modify content in the Admin UI, add Pages, Content Items, Menus etc .. The database will be cleared and set back to the default periodically so do not worry about breaking anything - in fact, please do and file a bug report!
\nEnjoy!
', 0, 1, 1, 0, 0, 0, 1, '', '2008-09-25 18:57:46', '0000-00-00 00:00:00', 2, 1), (2, 'Quinta gets demo site', '', 'Quinta CMS now live', 'Quinta CMS demo site now available to the Public', '\nYay! Now you can see Quinta in action! \n
\nYes, this is still an early version but thanks to Riccardo (who has generously provided hosting) you can play around with a "real" example site. Experiment, have fun with it.\n
\nEnjoy!\n
\n', 1, 1, 1, 1, 1, 0, 1, '', '2008-09-26 14:53:22', '0000-00-00 00:00:00', 2, 1), (3, 'Sed ut perspiciatis unde omnis', '', 'Sed ut perspiciatis', 'Sed ut perspiciatis unde omnisiste natus error', 'Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quinta architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?', 2, 1, 1, 1, 1, 0, 1, '', '2008-09-27 03:22:08', '0000-00-00 00:00:00', 1, 1), (4, 'Pollform', 'poll', 'Rate the new site', 'a poll ...', 'How do you like the new site? \nThis is a quick introduction - hopefully just enough to get you started. Ah yes - one day perhaps there will be \nextensive documentation, but as yet I have written this \nCMS almost entirely alone (a testament to QCodos power!) and time is limited .. Feel free to help out! \n
\n\n Until that wonderful day, experimentation is the key. And , of course, if you really want to know how Quinta CMS works: Read the source, Luke.\n
\n\n
\n
\n
\n