CREATE TABLE contents           (id integer primary key autoincrement, title text, body text, extended text, excerpt text, type_id integer, rank integer, link_id integer, basename text, user_id integer, created_on datetime, modified_on datetime);
CREATE TABLE content_history    (id integer primary key autoincrement, content_id integer, title text, body text, extended text, excerpt text, type_id integer, rank integer, link_id integer, basename text, user_id integer, created_on datetime, modified_on datetime);
CREATE TABLE types              (id integer primary key autoincrement, title text, short_desc text, long_desc text);
CREATE TABLE contents_authors   (content_id integer, author_id integer);
CREATE TABLE authors            (id integer primary key autoincrement, name text, byline text, short_desc text, long_desc text, is_employee boolean);
CREATE TABLE contents_keywords  (content_id integer, keyword_id integer);
CREATE TABLE keywords           (id integer primary key autoincrement, title text, short_desc text, long_desc text);
CREATE TABLE contents_topics    (content_id integer, topic_id integer);
CREATE TABLE topics             (id integer primary key autoincrement, title text, short_desc text, long_desc text);
CREATE TABLE contents_sections  (content_id integer, section_id integer);
CREATE TABLE sections           (id integer primary key autoincrement, title text, short_desc text, long_desc text);
CREATE TABLE contents_status    (content_id integer, status_id integer);
CREATE TABLE status             (id integer primary key autoincrement, title text, short_desc text, long_desc text);
CREATE TABLE contents_dates     (content_id integer, date_id integer);
CREATE TABLE dates              (id integer primary key autoincrement, pub_date datetime, end_date datetime);
CREATE TABLE tracker            (content_id integer, user_id integer, created_on datetime, modified_on datetime, is_done boolean);
INSERT INTO "types" VALUES(1, 'article', 'an article for the site', 'could be a magazine article, or for a landing page');
INSERT INTO "types" VALUES(5, 'help', 'help for the site', 'could be a page, or just a little blurb');
INSERT INTO "types" VALUES(1, 'article', 'an article for the site', 'could be a magazine article, or for a landing page');
INSERT INTO "types" VALUES(5, 'help', 'help for the site', 'could be a page, or just a little blurb');
INSERT INTO "sections" VALUES(1, 'Junior Education', 'this content is for Junior Education Magazine', '');
INSERT INTO "sections" VALUES(2, 'Book Fairs', 'this content is for Book Fairs', '');
INSERT INTO "sections" VALUES(3, 'Book Clubs', 'this content is for Book Clubs', '');
INSERT INTO "topics" VALUES(1, 'assemblies', 'this is about assembly ideas', '');
INSERT INTO "topics" VALUES(2, 'literacy', 'this is about literacy', '');

INSERT INTO "contents" VALUES(1, 'This is the First Post', 'This is the body of the first post updated', 'This is the extended bit

* list 1
* list 2
', 'this is the riveting excerpt', 1, '2007-03-30 02:08:23', '2007-03-30 09:11:22', NULL, NULL, NULL, NULL);
INSERT INTO "contents" VALUES(3, 'Local Hatha Yoga Classes with Helen', '<img src="http://www.stmgrts.org.uk/yoga-thumb.jpg" width="150" height="152" alt="downward dog yoga logo" class="right" />
Hatha yoga is 5,000 years old. It is non-competitive and it teaches us self-discipline and self-awareness.

Yoga helps to:

* Support the body''s systems (endocrine, immune, respiratory, circulatory etc)
* Strengthen and lengthen muscles
* Improve posture
* Focus the mind in the present, offering a relief from every day stresses and strains

h3. About Hatha Yoga

I teach "hatha yoga":http://www.stmgrts.org.uk/directory/health_aNd_beauty/200703081619. My classes include preparatory movements, postures (asanas), breathing techniques (including pranayama) and relaxation. I vary my classes each week.

I focus on alignment and breathing, in order to help release tension in the mind and body and to help student''s develop greater body intelligence. I put emphasis on the connection between body and breath, rather than advanced posture work and speed.

h3. Classes

There are two classes, Monday for all levels and Thursday mornings for beginners.  Please bring your own yoga mat. Or contact Helen to ordered a discounted mat.  Classes are held at Winchester Hall, next to the Turk''s Head Pub on Winchester Road.
', 'h4. Monday nights

* All levels welcome
* 6.30pm to 7.45pm
* {L-}7 per class, or {L-}6.50 if you pay for four or six classes in advance.

h4. Thursday mornings

* For beginners
*  9.30am to 10.45am
* {L-}7 per class, or {L-}6.50 if you pay for four or six classes in advance.


h4. Private & Corporate Classes

I also offer one-on-one, small group tuition and corporate classes.

*Details*

* Phone: 0781 371 2073
* Email: "ddogyoga@btinternet.com":ddogyoga@btinternet.com
* Website: "www.downwarddog.co.uk":http://www.downwarddog.co.uk/', '<img src="http://www.stmgrts.org.uk/yoga-thumb.jpg" width="75" height="76" alt="downward dog yoga logo" class="right" />
Hatha yoga is 5,000 years old. It is non-competitive and it teaches us self-discipline and self-awareness.', 1, '2007-04-01 15:59:39', '2007-04-02 05:33:31', NULL, NULL, NULL, NULL);
INSERT INTO "contents" VALUES(4, 'Local Hatha Yoga Classes with Helen', '<a href="http://www.stmgrts.org.uk/yoga.html" onclick="window.open(''http://www.stmgrts.org.uk/yoga.html'',''popup'',''width=327,height=332,scrollbars=no,resizable=no,toolbar=no,directories=no,location=no,menubar=no,status=no,left=0,top=0''); return false"><img src="http://www.stmgrts.org.uk/yoga-thumb.jpg" width="150" height="152" alt="downward dog yoga logo" class="right" /></a>
Hatha yoga is 5,000 years old. It is non-competitive and it teaches us self-discipline and self-awareness.

<p>Yoga helps to:</p>


<ul>
<li>Support the body''s systems (endocrine, immune, respiratory, circulatory etc)</li>
<li>Strengthen and lengthen muscles</li>
<li>Improve posture</li>
<li>Focus the mind in the present, offering a relief from every day stresses and strains</li>
</ul>



<h3>About Hatha Yoga</h3>

<p>I teach <a href="http://www.stmgrts.org.uk/directory/health_aNd_beauty/200703081619">hatha yoga</a>. My classes include preparatory movements, postures (asanas), breathing techniques (including pranayama) and relaxation. I vary my classes each week.</p>

<p>I focus on alignment and breathing, in order to help release tension in the mind and body and to help student''s develop greater body intelligence. I put emphasis on the connection between body and breath, rather than advanced posture work and speed.</p>

<h3>Classes</h3>

There are two classes, Monday for all levels and Thursday mornings for beginners.  Please bring your own yoga mat. Or contact Helen to ordered a discounted mat.  Classes are held at Winchester Hall, next to the Turk''s Head Pub on Winchester Road.
', 'h4. Monday nights

* All levels welcome
* 6.30pm to 7.45pm
* {L-}7 per class, or {L-}6.50 if you pay for four or six classes in advance.

h4. Thursday mornings

* For beginners
* 9.30am to 10.45am
* {L-}7 per class, or {L-}6.50 if you pay for four or six classes in advance.

h4. Private & Corporate Classes

I also offer one-on-one, small group tuition and corporate classes.

*Details*

* Phone: 0781 371 2073
* Email: <a href="mailto:%64%64%6F%67%79%6F%67%61%40%62%74%69%6E%74%65%72%6E%65%74%2E%63%6F%6D">ddogyoga@btinternet.com</a></li>
* Website: <a href="http://www.downwarddog.co.uk/">www.downwarddog.co.uk</a>

', 'Hatha yoga is 5,000 years old. It is non-competitive and it teaches us self-discipline and self-awareness.', 1, '2007-04-01 16:18:20', '2007-04-02 06:12:46', NULL, NULL, NULL, NULL);
INSERT INTO "contents" VALUES(5, 'The Go-Cart Challenge', '  <p><a href="#" onclick="MyWindow=window.open(''http://www.scholastic.co.uk/flash/je-go-cart-game.swf'',''more'',''toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=yes,width=1000,height=707,left=150,top=150''); return false"><img class="thinborder" src="http://www.scholastic.co.uk/magazines/images/je-go-cart-game.gif" alt="Maths game interactive poster screenshot" width="200" height="141" /></a></p>
<p><img src="http://www.scholastic.co.uk/magazines/images/arrow-black.jpg" width="7" height="11" alt="arrow" /> <a href="#" onclick="MyWindow=window.open(''http://www.scholastic.co.uk/flash/je-go-cart-game.swf'',''more'',''toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=yes,width=1000,height=707,left=150,top=150''); return false">Click to play</a> the Go-Cart Challenge on your interactive whiteboard. (swf, 1.6MB - best run with a broadband connection) </p>', '<p class="flink"><strong>Download the interactive poster:</strong></p>
<p class="flink4"><img src="http://www.scholastic.co.uk/images/arrow-black.jpg" width="7" height="11" alt="arrow" /> <a href="http://www.scholastic.co.uk/flash/je-go-cart-game.exe">For PC</a> (exe, 2.5MB)</p>
<p class="flink4"><img src="http://www.scholastic.co.uk/images/arrow-black.jpg" width="7" height="11" alt="arrow" /> <a href="http://www.scholastic.co.uk/flash/je-go-cart-game.hqx">For Mac</a> (hqx, 3.9MB)</p>
<p class="flink"><strong>Download the accompanying worksheets:</strong></p>
    <p>
        <a href="http://www.scholastic.co.uk/magazines/downloads/pcps/2007/mar/105151_je0307GoCartpcp_mip-1.pdf" target="_blank"><img src="http://www.scholastic.co.uk/magazines/images/pcps/2007/mar/105151_je0307GoCartpcp_mip-.gif" alt="worksheet" width="151" height="210" border="0" /></a>
    </p>', '', 1, '2007-04-02 10:36:31', '2007-04-02 10:42:05', 3, NULL, NULL, NULL);
