CMS made simple 1.0.5 : /install/schemas/initial.sql source

[Sommaire] [Imprimer]
   1  INSERT INTO {DB_PREFIX}additional_htmlblob_users ( ADDITIONAL_HTMLBLOB_USERS_ID, USER_ID, HTMLBLOB_ID ) VALUES ( 6, 1, 5 );
   2  INSERT INTO {DB_PREFIX}additional_htmlblob_users ( ADDITIONAL_HTMLBLOB_USERS_ID, USER_ID, HTMLBLOB_ID ) VALUES ( 14, 1, 1 );
   3  INSERT INTO {DB_PREFIX}content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID, PARENT_ID, TEMPLATE_ID, ITEM_ORDER, HIERARCHY, DEFAULT_CONTENT, MENU_TEXT, CONTENT_ALIAS, SHOW_IN_MENU, COLLAPSED, MARKUP, ACTIVE, CACHABLE, ID_HIERARCHY, HIERARCHY_PATH, PROP_NAMES, METADATA, TITLEATTRIBUTE, TABINDEX, ACCESSKEY, LAST_MODIFIED_BY, CREATE_DATE, MODIFIED_DATE ) VALUES ( 15, 'Home', 'content', 1, -1, 17, 1, '00001', 1, 'Home', 'home', 1, 1, 'html', 1, 1, '15', 'home', 'content_en', null, 'Home Page, shortcut key=1', null, '1', 2, '2006-07-25 21:22:31', '2006-07-25 21:22:31' );
   4  INSERT INTO {DB_PREFIX}content_props ( CONTENT_ID, TYPE, PROP_NAME, PARAM1, PARAM2, PARAM3, CONTENT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 15, 'string', 'content_en', null, null, null, '<p>Congratulations! You now have a fully functional installation of CMS Made Simple and you are <em>almost</em> ready to start building your site. First thing though, you should click <a href=\"install/upgrade.php\" title=\"Check if your CMSMS system needs upgrading\">here</a> to check if your site requires a database upgrade. After you have confirmed you are up to date, then we can get cracking on the site development! </p>\r\n\r\n<p>These default pages are devoted to showing you the basics of how to get your site up with CMS Made Simple. </p>\r\n\r\n<p>To get to the Administration Panel you have to login as the administrator (with the username/password you mentioned during the installation process) on your site at http://yourwebsite.com/cmsmspath/admin. </p>\r\n\r\n<p>If you are right now on your own default install, you can probably just click <a title=\"CMSMS Demo Admin Panel\" href=\"admin/\">this link</a>. </p>\r\n\r\n<h3>Learning CMS Made Simple </h3>\r\n\r\n<p>On these example pages many of the features of the default installation of CMS Made Simple are described and demonstrated. You can learn about how to use different kinds of menus, templates, stylesheets and extensions. </p>\r\n\r\n<p>Read about how to use CMS Made Simple in the {cms_selflink ext=\"http://wiki.cmsmadesimple.org/\" title=\"CMS Made Simple Documentation\" text=\"documentation\" target=\"_blank\"}. In case you need any help the community is always at your service, in the \r\n{cms_selflink ext=\"http://forum.cmsmadesimple.org\" title=\"CMS Made Simple Forum\" text=\"forum\" target=\"_blank\"} or the {cms_selflink ext=\"http://www.cmsmadesimple.org/IRC.shtml\" title=\"Information about the CMS Made Simple IRC channel\" text=\"IRC\" target=\"_blank\"}. </p>\r\n\r\n<h3>License </h3>\r\n\r\n<p>CMS Made Simple is released under the {cms_selflink ext=\"http://www.gnu.org/licenses/licenses.html#GPL\" title=\"General Public License\" text=\"GPL\" target=\"_blank\"} license </p>', '2006-07-25 21:22:31', '2006-07-25 21:22:31' );
   5  INSERT INTO {DB_PREFIX}crossref ( CHILD_TYPE, CHILD_ID, PARENT_TYPE, PARENT_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'global_content', 1, 'template', 17, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
   6  INSERT INTO {DB_PREFIX}css ( CSS_ID, CSS_NAME, CSS_TEXT, MEDIA_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 41, 'Handheld', '/*********************************************\r\nSample stylesheet for mobile and small screen handheld devices\r\n\r\nJust a simple layout suitable for smaller screens with less \r\nstyling cabapilities and minimal css\r\n\r\nNote: If you dont want to support mobile devices you can\r\nsafely remove this stylesheet.\r\n*********************************************/\r\n/* remove all padding and margins and set width to 100%. This should be default for handheld devices but its good to set these explicitly */\r\nbody {\r\nmargin:0;\r\npadding:0;\r\nwidth:100%;\r\n}\r\n\r\n/* hide accessibility noprint and definition */\r\n.accessibility,\r\n.noprint,\r\ndfn {\r\ndisplay:none;\r\n}\r\n\r\n/* dont want to download image for header so just set bg color */\r\ndiv#header,\r\ndiv#footer {\r\nbackground-color: #385C72;  \r\ncolor: #fff;\r\ntext-align:center;\r\n}\r\n\r\n/* text colors for header and footer */\r\ndiv#header a,\r\ndiv#footer a {\r\ncolor: #fff;\r\n}\r\n\r\n/* this doesnt look as nice, but takes less space */\r\ndiv#menu_vert ul li,\r\ndiv#menu_horiz ul li {\r\ndisplay:inline;\r\n}\r\n\r\n/* small border at the bottom to have some indicator */\r\ndiv#menu_vert ul,\r\ndiv#menu_horiz ul {\r\nborder-bottom:1px solid #fff;\r\n}\r\n\r\n/* save some space */\r\ndiv.breadcrumbs {\r\ndisplay:none;\r\n}', 'handheld', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
   7  INSERT INTO {DB_PREFIX}css ( CSS_ID, CSS_NAME, CSS_TEXT, MEDIA_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 30, 'Print', '/*\r\nSections that are hidden when printing the page. We only want the content printed.\r\n*/\r\n\r\n\r\nbody {\r\ncolor: #000 !important; /* we want everything in black */\r\nbackground-color:#fff !important; /* on white background */\r\nfont-family:arial; /* arial is nice to read ;) */\r\nborder:0 !important; /* no borders thanks */\r\n}\r\n\r\n/* This affects every tag */\r\n* {\r\nborder:0 !important; /* again no borders on printouts */\r\n}\r\n\r\n/* \r\nno need for accessibility on printout. \r\nMark all your elements in content you \r\ndont want to get printed with class=\"noprint\"\r\n*/\r\n.accessibility,\r\n.noprint\r\n {\r\ndisplay:none !important; \r\n}\r\n\r\n/* \r\nremove all width constraints from content area\r\n*/\r\ndiv#content,\r\ndiv#main {\r\ndisplay:block !important;\r\nwidth:100% !important;\r\nborder:0 !important;\r\npadding:1em !important;\r\n}\r\n\r\n/* hide everything else! */\r\ndiv#header,\r\ndiv#header h1 a,\r\ndiv.breadcrumbs,\r\ndiv#search,\r\ndiv#footer,\r\ndiv#menu_vert,\r\ndiv#news,\r\ndiv.right49,\r\ndiv.left49,\r\ndiv#sidebar  {\r\n   display: none !important;\r\n}\r\n\r\nimg {\r\nfloat:none; /* this makes images couse a pagebreak if it doesnt fit on the page */\r\n}', 'print', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
   8  INSERT INTO {DB_PREFIX}css ( CSS_ID, CSS_NAME, CSS_TEXT, MEDIA_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 31, 'Accessibility and cross-browser tools', '/* accessibility */\r\n\r\n/* \r\nmenu links accesskeys \r\n*/\r\nspan.accesskey {\r\n   text-decoration:none;\r\n}\r\n\r\n/* \r\naccessibility divs are hidden by default \r\ntext, screenreaders and such will show these \r\n*/\r\n.accessibility, hr {\r\n   position: absolute;\r\n   top: -999em;\r\n   left: -999em;\r\n}\r\n\r\n/* \r\ndefinition tags are also hidden \r\nthese are also used for menu links    \r\n*/\r\ndfn {\r\n   position: absolute;\r\n   left: -1000px;\r\n   top: -1000px;\r\n   width: 0;\r\n   height: 0;\r\n   overflow: hidden;\r\n   display: inline;\r\n}\r\n/* end accessibility */\r\n\r\n\r\n/* wiki style external links */\r\n/* external links will have \"(external link)\" text added, lets hide it */\r\na.external span {\r\n  position: absolute;\r\n  left: -5000px;\r\n  width: 4000px;\r\n}\r\n\r\n/* make some room for the image */\r\na.external {\r\n/* css shorthand rules, read: first top padding 0 then right padding 12px then bottom then right */\r\n  padding: 0 12px 0 0;\r\n}\r\n/* colors for external links */\r\na.external:link {\r\n  color: #18507C;\r\n/* background image for the link to show wiki style arrow */\r\n  background: url(images/cms/external.gif) no-repeat 100% 0;\r\n}\r\na.external:visited {\r\n  color: #18507C; /* a different color can be used for visited external links */\r\n\r\n/* \r\nSet the last 0 to -100px to use that part of the external.gif image for different color for active links \r\nexternal.gif is actually 300px tall, we can use different positions of the image to simulate rollover image changes.\r\n*/\r\n  background: url(images/cms/external.gif) no-repeat 100% 0; \r\n}\r\n\r\na.external:hover {\r\n  color: #18507C;\r\n/* Set the last 0 to -200px to use that part of the external.gif image for different color on hover */\r\n  background: url(images/cms/external.gif) no-repeat 100% 0; \r\n  background-color: #C3D4DF;\r\n}\r\n/* end wiki style external links */\r\n\r\n\r\n/* clearing */\r\n/* \r\nclearfix is a hack for divs that hold floated elements. it will force the holding div to span all the way down to last floated item.\r\nWe strongly recommend against using this as it is a hack and might not render correctly but it is included here for convenience.\r\nDo not edit if you dont know what you are doing\r\n*/\r\n    .clearfix:after {\r\n        content: \".\"; \r\n        display: block; \r\n        height: 0; \r\n        clear: both; \r\n        visibility: hidden;\r\n    }\r\n    * html>body .clearfix {\r\n        display: inline-block; \r\n        width: 100%;\r\n    }\r\n    \r\n    * html .clearfix {\r\n        /* Hides from IE-mac \\*/\r\n        height: 1%;\r\n        /* End hide from IE-mac */\r\n    }\r\n\r\n/* end clearing */', 'screen', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
   9  INSERT INTO {DB_PREFIX}css ( CSS_ID, CSS_NAME, CSS_TEXT, MEDIA_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 32, 'Layout: Left sidebar + 1 column', '/*****************\r\nbrowsers interpret margin and padding a little differently, \r\nwe\'ll remove all default padding and margins and\r\nset them later on\r\n******************/\r\n* {\r\nmargin:0;\r\npadding:0;\r\n}\r\n\r\n/*\r\nSet initial font styles\r\n*/\r\nbody {\r\n   text-align: left;\r\n   font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;\r\n   font-size: 75.01%;\r\n   line-height: 1em;\r\n}\r\n\r\n/*\r\nset font size for all divs,\r\nthis overrides some body rules\r\n*/\r\ndiv {\r\n   font-size: 1em;\r\n}\r\n\r\n/*\r\nif img is inside \"a\" it would have \r\nborders, we don\'t want that\r\n*/\r\nimg {\r\n   border: 0;\r\n}\r\n\r\n/*\r\ndefault link styles\r\n*/\r\n/* set all links to have underline and bluish color */\r\na,\r\na:link \r\na:active {\r\n   text-decoration: underline;\r\n/* css validation will give a warning if color is set without background color. this will explicitly tell this element to inherit bg colour from parent element */\r\n   background-color: inherit; \r\n   color: #18507C; \r\n}\r\n\r\na:visited {\r\n   text-decoration: underline;\r\n   background-color: inherit;\r\n  color: #18507C;                /* a different color can be used for visited links */\r\n}\r\n\r\n\r\n/* remove underline on hover and change color */\r\na:hover {\r\n   text-decoration: none;\r\n   background-color: #C3D4DF;\r\n   color: #385C72;\r\n}\r\n\r\n/*****************\r\nbasic layout \r\n*****************/\r\nbody {\r\n   background-color: #ccc;\r\n   color: #333;\r\n   margin:1em;    /* gives some air for the pagewrapper */\r\n}\r\n\r\n/* center wrapper, min max width */\r\ndiv#pagewrapper {\r\n   border: 1px solid black;\r\n   margin: 0 auto;       /* this centers wrapper */\r\n   max-width: 80em;   /* IE wont understand these, so we will use javascript magick */\r\n   min-width: 60em;\r\n   background-color: #fff;;\r\n   color: black;\r\n}\r\n\r\n\r\n/*** header ***\r\nwe will hide text and replace it with a image\r\nwe need to assign a height for it so that the image wont cut off\r\n*/\r\ndiv#header {\r\n   height: 80px;    /* adjust according your image size */\r\n   background: #385C72;           \r\n}\r\n\r\ndiv#header h1 a {\r\n/* you can set your own image here */\r\n   background: #385C72 url(images/cms/logo1.gif) no-repeat 0 12px; \r\n   display: block;\r\n   height: 80px;             /* adjust according your image size */\r\n   text-indent: -999em;  /* this hides the text */\r\n   text-decoration:none; /* old firefox would have shown underline for the link, this explicitly hides it */\r\n}\r\n\r\n/* position for the search box */\r\ndiv#search {\r\n   float: right;\r\n   width: 23em;    /* enough width for the search input box */\r\n   text-align: right;\r\n   padding: 0.6em 0 0.2em 0;\r\n   margin: 0 1em;\r\n}\r\n\r\ndiv.breadcrumbs {\r\n   padding: 1em 0 1.2em 0; /* CSS short hand rule first value is top then right, bottom and left */\r\n   font-size: 90%;        /* its good to set fontsizes to be relative, this way viewer can change his/her fontsize */\r\n   margin: 0 1em;        /* css shorthand rule will be opened to be \"0 1em 0 1em\" */\r\n   border-bottom: 1px dotted #000;\r\n}\r\n\r\div.breadcrumbs span.lastitem { \r\n   font-weight:bold; \r\n}\r\n\r\nndiv#content {\r\n   margin: 1.5em auto 2em 0;   /* some air above and under menu and content */\r\n}\r\n\r\n\r\ndiv#main {\r\n   margin-left: 29%; /* this will give room for sidebar to be on the left side, make sure this space is bigger than sidebar width */\r\n   margin-right: 2%; /* and some air on the right */\r\n}\r\n\r\ndiv#sidebar {\r\n   float: left;        /* set sidebar on the left side. Change to right to float it right instead. */\r\n   width: 26%;     /* sidebar width, if you change this please also change #main margins */\r\n   display: inline;  /* FIX IE double margin bug */\r\n   margin-left: 0;\r\n}\r\n\r\ndiv#footer {\r\n   clear: both;       /* keep footer below content and menu */\r\n   color: #fff;\r\n   background-color: #385C72; /* same bg color as in header */\r\n}\r\n\r\ndiv#footer p {\r\n   font-size: 0.8em;\r\n   padding: 1.5em;       /* some air for footer */\r\n   text-align: center;  /* centered text */\r\n   margin: 0;\r\n}\r\n\r\ndiv#footer p a {\r\n   color: #fff; /* needed becouse footer link would be same color as background otherwise */\r\n}\r\n\r\n/* as we hid all hr for accessibility we create new hr with extra div element */\r\ndiv.hr {\r\n   height: 1px;\r\n   padding: 1em;\r\n   border-bottom: 1px dotted black;\r\n   margin: 1em;\r\n}\r\n\r\n/* relational links under content */\r\ndiv.left49 {\r\n  width: 49%; /* 50% for both left and right might lead to rounding error on some browser */\r\n}\r\n\r\ndiv.right49 {\r\n  float: right;\r\n  width: 49%;\r\n  text-align: right;\r\n}\r\n\r\n\r\n\r\n\r\n/********************\r\nCONTENT STYLING\r\n*********************/\r\ndiv#content {\r\n\r\n}\r\n\r\n/* HEADINGS */\r\ndiv#content h1 {\r\n   font-size: 2em; /* font size for h1 */\r\n   line-height: 1em;\r\n   margin: 0;\r\n}\r\ndiv#content h2 {\r\n    color: #294B5F; \r\n    font-size: 1.5em; \r\n    text-align: left; \r\n/* some air around the text */\r\n    padding-left: 0.5em;\r\n    padding-bottom: 1px;\r\n/* set borders around header */\r\n    border-bottom: 1px solid #e7ab0b; \r\n    border-left: 1.1em solid #e7ab0b; \r\n        line-height: 1.5em;\r\n/* and some air under the border */\r\n        margin: 0 0 0.5em 0;\r\n}\r\ndiv#content h3 {\r\n   color: #294B5F; \r\n   font-size: 1.3em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.5em 0;\r\n}\r\ndiv#content h4 {\r\n   color: #294B5F; \r\n   font-size: 1.2em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.25em 0;\r\n}\r\ndiv#content h5 {\r\n   color: #294B5F; \r\n   font-size: 1.1em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.25em 0;\r\n}\r\nh6 {\r\n   color: #294B5F; \r\n   font-size: 1em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.25em 0;\r\n}\r\n/* END HEADINGS */\r\n\r\n/* TEXT */\r\np {\r\n   font-size: 1em;\r\n   margin: 0 0 1.5em 0; /* some air around p elements */\r\n   line-height: 1.4em;\r\n   padding: 0;\r\n}\r\n\r\nblockquote {\r\n   border-left: 10px solid #ddd;\r\n   margin-left: 10px;\r\n}\r\nstrong, b {\r\n/* explicit setting for these */\r\n   font-weight: bold;\r\n}\r\nem, i {\r\n/* explicit setting for these */\r\n   font-style:italic;\r\n}\r\n\r\n/* Wrapping text in <code> tags. Makes CSS not validate */\r\ncode, pre {\r\n white-space: pre-wrap;       /* css-3 */\r\n white-space: -moz-pre-wrap;  /* Mozilla, since 1999 */\r\n white-space: -pre-wrap;      /* Opera 4-6 */\r\n white-space: -o-pre-wrap;    /* Opera 7 */\r\n word-wrap: break-word;       /* Internet Explorer 5.5+ */\r\n font-family: \"Courier New\", Courier, monospace;\r\n font-size: 1em;\r\n}\r\n\r\npre {\r\n   border: 1px solid #000;  /* black border for pre blocks */\r\n   background-color: #ddd;\r\n   margin: 0 1em 1em 1em;\r\n   padding: 0.5em;\r\n   line-height: 1.5em;\r\n   font-size: 90%;\r\n\r\n\r\n}\r\n\r\n/* Separating the divs on the template explanation page, with some bottom-border */\r\ndiv.templatecode {\r\n  margin: 0 0 2.5em;\r\n}\r\n\r\n/* END TEXT */\r\n\r\n/* LISTS */\r\n/* lists in content need some margins to look nice */\r\ndiv#main ul,\r\ndiv#main ol,\r\ndiv#main dl {\r\n   font-size: 1.0em;\r\n   line-height: 1.4em;\r\n   margin: 0 0 1.5em 0;\r\n}\r\n\r\ndiv#main ul li,\r\ndiv#main ol li {\r\n   margin: 0 0 0.25em 3em;\r\n}\r\n\r\n/* definition lists topics on bold */\r\ndiv#main dl dt {\r\n   font-weight: bold;\r\n   margin: 0 0 0 1em;\r\n}\r\ndiv#main dl dd {\r\n   margin: 0 0 1em 1em;\r\n}\r\n\r\ndiv#main dl {\r\n  margin-bottom: 2em;\r\n  padding-bottom: 1em;\r\n  border-bottom: 1px solid #c0c0c0;\r\n}\r\n\r\n\r\n/* END LISTS */', 'screen', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  10  INSERT INTO {DB_PREFIX}css ( CSS_ID, CSS_NAME, CSS_TEXT, MEDIA_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 35, 'Module: News', 'div#news {\r\n  margin: 2em 0 1em 1em;  /* margin for the entire div surrounding the news list */\r\n  border: 1px solid #000; \r\n  background: #FFE9AF; \r\n}\r\n\r\ndiv#news h2 {\r\n   line-height: 2em;\r\n   background: #fff;\r\n}\r\n\r\n.NewsSummary {\r\n    padding: 0.5em 0.5em 1em; /* padding for the news article summary */\r\n    margin: 0 0.5em 1em 0.5em; /* margin to the bottom of the news article summary */\r\n    border-bottom: 1px solid #ccc; \r\n}\r\n\r\n.NewsSummaryPostdate {\r\n  font-size: 90%;\r\n  font-weight: bold;\r\n }\r\n\r\n.NewsSummaryLink {\r\n    font-weight: bold;\r\n    padding-top: 0.2em;\r\n}\r\n\r\n.NewsSummaryCategory {\r\n  font-style: italic;\r\n  margin: 5px 0;\r\n }\r\n\r\n.NewsSummaryAuthor {\r\n  font-style: italic;\r\n  padding-bottom: 0.5em;\r\n}\r\n\r\n.NewsSummarySummary, .NewsSummaryContent {\r\n  line-height: 140%;\r\n }\r\n\r\n.NewsSummaryMorelink {\r\n  padding-top: 0.5em;\r\n}\r\n\r\n#NewsPostDetailDate {\r\n  font-size: 90%;\r\n  margin-bottom: 5px;\r\n  font-weight: bold;\r\n  }\r\n\r\n#NewsPostDetailSummary {\r\n   line-height: 150%;\r\n   }\r\n\r\n#NewsPostDetailCategory {\r\n  font-style: italic;\r\n  border-top: 1px solid #ccc;\r\n  margin-top: 0.5em;\r\n  padding: 0.2em 0;\r\n}\r\n\r\n#NewsPostDetailContent {\r\n  margin-bottom: 15px;\r\n  line-height: 150%;\r\n  }\r\n\r\n#NewsPostDetailAuthor {\r\n\r\n  padding-bottom: 1.5em;\r\n  font-style: italic;\r\n}\r\n\r\n\r\n/* to add specific style to the below divs, uncomment them. */\r\n\r\n/* \r\n#NewsPostDetailTitle {}\r\n#NewsPostDetailHorizRule {}\r\n#NewsPostDetailPrintLink {}\r\n#NewsPostDetailReturnLink {}\r\n*/', 'screen', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  11  INSERT INTO {DB_PREFIX}css ( CSS_ID, CSS_NAME, CSS_TEXT, MEDIA_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 36, 'Navigation: Simple - Vertical', '/********************\r\nMENU\r\n*********************/\r\n#menu_vert {\r\n   padding-left: 0;\r\n   margin-left: 1em;\r\n}\r\n\r\n\r\n/* third level has some padding to have it stand out */\r\ndiv#menu_vert ul ul ul {\r\n   padding-bottom: 0.5em;\r\n}\r\n\r\n/* menu li block */\r\n#menu_vert li {\r\n   list-style: none;\r\n   margin: 0;\r\n   border-bottom: 1px solid #c0c0c0;\r\n   display: block;\r\n}\r\n\r\n#menu_vert ul ul li {\r\n   border: none;\r\n}\r\n\r\n/** fix stupid ie bug with display:block; **/\r\n* html #menu_vert li a { height: 1%; } \r\n* html #menu_vert li hr { height: 1%; }\r\n/** end fix **/\r\n\r\n/* first level links */\r\ndiv#menu_vert a {\r\n   text-decoration:none; /* no underline for links */\r\n   display: block; /* IE has problems with this, fixed above */\r\n   padding: 0.8em 0.5em 0.8em 1.5em; /* some air for it */\r\n   color: #18507C; /* this will be link color for all levels */\r\n   background: url(images/cms/arrow-right.gif) no-repeat 0.5em center; \r\n   background: transparent; \r\n   min-height:1em; /* Fixes IE7 whitespace bug */ \r\n}\r\n\r\n/* next level links, more padding and smaller font */\r\ndiv#menu_vert ul ul a {\r\n   font-size: 90%;\r\n   padding: 0.5em 0.5em 0.5em 2.8em;\r\n   background-position: 1.5em center;\r\n}\r\n\r\n/* third level links, more padding */\r\ndiv#menu_vert ul ul ul a {\r\n   padding: 0.3em 0.5em 0.3em 4.3em;\r\n   background: url(images/cms/dash.gif) no-repeat 2.8em center; \r\n}\r\n\r\n/* hover state for all links */\r\ndiv#menu_vert a:hover {\r\n   background-color: #C3D4DF;\r\n}\r\ndiv#menu_vert a.activeparent:hover {\r\n   background-color: #C3D4DF;\r\n   color: #18507C;\r\n}\r\n\r\n/* \r\nactive parent, that is the first-level parent \r\nof a child page that is the current page \r\n*/\r\ndiv#menu_vert li a.activeparent {\r\n   background: url(images/cms/arrow-down.gif) no-repeat 0.4em center; \r\n   background-color: #385C72;\r\n   color: #fff;\r\n}\r\n\r\ndiv#menu_vert ul ul li a.activeparent {\r\n   background-position: 1.5em center; \r\n   background-color: transparent;\r\n   color: #18507C;\r\n}\r\n\r\n\r\n/* \r\ncurrent pages in the default Menu Manager \r\ntemplate are unclickable. This is for current page on first level \r\n*/\r\ndiv#menu_vert ul h3 {\r\n   background: url(images/cms/arrow-right-active.gif) no-repeat 0.4em center;\r\n   background-color: #385C72;\r\n   display: block; \r\n   padding: 0.8em 0.5em 0.8em 1.5em;  /* some air for it */\r\n   color: #fff;                                 /* this will be link color for all levels */\r\n   font-size: 1em;                           /* instead of the normal font size for <h3> */\r\n   margin: 0;                                  /* as <h3> normally has some margin by default */\r\n}\r\n\r\n/* \r\nnext level current pages, more padding, \r\nsmaller font and no background color or bottom border \r\n*/\r\ndiv#menu_vert ul ul h3 {\r\n   font-size: 90%;\r\n   padding: 0.3em 0.5em 0.3em 2.8em;\r\n   background-position: 1.4em center;\r\n   background-color: transparent;\r\n   border-bottom: none;\r\n   color: #000;     \r\n}\r\n\r\n/* current page on third level, more padding */\r\ndiv#menu_vert ul ul ul h3 {\r\n   padding: 0.3em 0.5em 0.3em 4.3em;\r\n   background: url(images/cms/arrow-right-active.gif) no-repeat 2.7em center; \r\n}\r\n\r\n/* section header */\r\ndiv#menu_vert li.sectionheader {\r\n   border-right: none;\r\n   font-size: 130%;\r\n   font-weight: bold;\r\n   padding: 1.5em 0 0.8em 0;\r\n   background-color: #fff;\r\n   line-height: 1em;\r\n   margin: 0;\r\n   text-align:center;\r\n}\r\n\r\n\r\n\r\n/* separator */\r\ndiv#menu_vert li.separator {\r\n   height: 1px !important;\r\n   margin-top: -1px;\r\n   margin-bottom: 0;\r\n   padding:2px 0 2px 0;\r\n   background-color: #000;\r\n   overflow:hidden !important;\r\n   line-height:1px !important;\r\n   font-size:1px; /* for ie */\r\n}\r\n\r\ndiv#menu_vert li.separator hr {\r\n   display: none; /* this is for accessibility */\r\n}', 'screen', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  12  INSERT INTO {DB_PREFIX}css_assoc ( ASSOC_TO_ID, ASSOC_CSS_ID, ASSOC_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 41, 'template', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  13  INSERT INTO {DB_PREFIX}css_assoc ( ASSOC_TO_ID, ASSOC_CSS_ID, ASSOC_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 32, 'template', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  14  INSERT INTO {DB_PREFIX}css_assoc ( ASSOC_TO_ID, ASSOC_CSS_ID, ASSOC_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 35, 'template', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  15  INSERT INTO {DB_PREFIX}css_assoc ( ASSOC_TO_ID, ASSOC_CSS_ID, ASSOC_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 30, 'template', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  16  INSERT INTO {DB_PREFIX}css_assoc ( ASSOC_TO_ID, ASSOC_CSS_ID, ASSOC_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 36, 'template', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  17  INSERT INTO {DB_PREFIX}css_assoc ( ASSOC_TO_ID, ASSOC_CSS_ID, ASSOC_TYPE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 31, 'template', '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  18  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 151, 1, 16, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  19  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 150, 1, 24, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  20  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 149, 1, 27, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  21  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 148, 1, 13, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  22  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 147, 1, 32, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  23  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 146, 1, 14, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  24  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 145, 1, 12, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  25  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 144, 1, 11, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  26  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 143, 1, 22, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  27  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 142, 1, 26, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  28  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 141, 1, 21, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  29  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 140, 1, 9, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  30  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 138, 1, 18, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  31  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 137, 1, 31, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  32  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 136, 1, 7, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  33  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 135, 1, 8, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  34  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 134, 1, 20, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  35  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 133, 1, 28, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  36  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 132, 1, 6, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  37  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 130, 1, 29, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  38  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 129, 1, 5, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  39  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 128, 1, 4, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  40  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 127, 1, 23, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  41  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 126, 1, 25, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  42  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 125, 1, 1, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  43  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 124, 1, 30, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  44  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 123, 1, 2, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  45  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 166, 2, 13, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  46  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 165, 3, 32, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  47  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 163, 3, 31, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  48  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 162, 2, 20, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  49  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 161, 2, 28, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  50  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 160, 2, 6, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  51  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 114, 3, 25, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  52  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 115, 2, 31, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  53  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 116, 3, 4, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  54  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 117, 3, 26, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  55  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 118, 3, 30, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  56  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 119, 3, 11, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  57  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 120, 3, 27, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  58  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 121, 2, 32, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  59  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 122, 3, 16, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  60  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 152, 1, 17, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  61  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 153, 1, 37, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  62  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 159, 2, 1, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  63  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 158, 2, 30, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  64  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 167, 3, 22, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  65  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 168, 1, 33, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  66  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 169, 1, 34, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  67  INSERT INTO {DB_PREFIX}group_perms ( GROUP_PERM_ID, GROUP_ID, PERMISSION_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 170, 1, 35, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  68  INSERT INTO {DB_PREFIX}groups ( GROUP_ID, GROUP_NAME, ACTIVE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'Admin', 1, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  69  INSERT INTO {DB_PREFIX}groups ( GROUP_ID, GROUP_NAME, ACTIVE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 2, 'Editor', 1, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  70  INSERT INTO {DB_PREFIX}groups ( GROUP_ID, GROUP_NAME, ACTIVE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 3, 'Designer', 1, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  71  INSERT INTO {DB_PREFIX}htmlblobs ( HTMLBLOB_ID, HTMLBLOB_NAME, HTML, OWNER, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'footer', '<p>&copy; Copyright {custom_copyright} - CMS Made Simple<br />\r\nThis site is powered by <a href=\"http://www.cmsmadesimple.org\">CMS Made Simple</a> version {cms_version}</p>', 1, '2006-07-25 21:22:32', '2006-07-25 21:22:32' );
  72  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'Add Pages', 'Add Pages', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  73  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 2, 'Add Groups', 'Add Groups', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  74  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 4, 'Add Templates', 'Add Templates', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  75  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 5, 'Add Users', 'Add Users', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  76  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 6, 'Modify Any Page', 'Modify Any Page', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  77  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 7, 'Modify Groups', 'Modify Groups', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  78  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 8, 'Modify Group Assignments', 'Modify Group Assignments', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  79  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 9, 'Modify Permissions', 'Modify Permissions for Groups', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  80  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 11, 'Modify Templates', 'Modify Templates', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  81  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 12, 'Modify Users', 'Modify Users', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  82  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 13, 'Remove Pages', 'Remove Pages', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  83  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 14, 'Remove Groups', 'Remove Groups', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  84  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 16, 'Remove Templates', 'Remove Templates', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  85  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 'Remove Users', 'Remove Users', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  86  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 18, 'Modify Modules', 'Modify Modules', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  87  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 20, 'Modify Files', 'Modify Files', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  88  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 21, 'Modify Site Preferences', 'Modify Site Preferences', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  89  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 22, 'Modify Stylesheets', 'Modify Stylesheets', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  90  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 23, 'Add Stylesheets', 'Add Stylesheets', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  91  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 24, 'Remove Stylesheets', 'Remove Stylesheets', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  92  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 25, 'Add Stylesheet Assoc', 'Add Stylesheet Associations', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  93  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 26, 'Modify Stylesheet Assoc', 'Modify Stylesheet Associations', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  94  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 27, 'Remove Stylesheet Assoc', 'Remove Stylesheet Associations', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  95  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 28, 'Modify User-defined Tags', 'Modify User-defined Tags', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  96  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 29, 'Clear Admin Log', 'Clear Admin Log', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  97  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 30, 'Add Global Content Blocks', 'Add Global Content Blocks', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  98  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 31, 'Modify Global Content Blocks', 'Modify Global Content Blocks', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
  99  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 32, 'Remove Global Content Blocks', 'Remove Global Content Blocks', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 100  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 33, 'Modify Page Structure', 'Modify Page Structure', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 101  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 34, 'Modify FCKeditorX', 'Modify FCKeditorX', '2006-01-27 20:06:58', '2006-01-27 20:06:58' );
 102  INSERT INTO {DB_PREFIX}permissions ( PERMISSION_ID, PERMISSION_NAME, PERMISSION_TEXT, CREATE_DATE, MODIFIED_DATE ) VALUES ( 35, 'Modify Events', 'Modify Events', '2006-01-27 20:06:58', '2006-01-27 20:06:58' );
 103  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'enablecustom404', '0', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 104  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'custom404', '<p>Page could not be found.</p>', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 105  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'custom404template', '-1', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 106  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'enablesitedownmessage', '0', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 107  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'sitedownmessage', '<p>Site is currently down for maintenance.</p>', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 108  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'sitedownmessagetemplate', '-1', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 109  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'useadvancedcss', '1', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 110  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'metadata', '<meta name=\"Generator\" content=\"CMS Made Simple - Copyright (C) 2004-6 Ted Kulp. All rights reserved.\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n ', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 111  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'xmlmodulerepository', null, '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 112  INSERT INTO {DB_PREFIX}siteprefs ( SITEPREF_NAME, SITEPREF_VALUE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 'logintheme', 'default', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 113  INSERT INTO {DB_PREFIX}templates ( TEMPLATE_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, STYLESHEET, ENCODING, ACTIVE, DEFAULT_TEMPLATE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 17, 'Left simple navigation + 1 column', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n<!-- Change lang=\"en\" to the language of your site -->\r\n\r\n<head>\r\n\r\n<title>{sitename} - {title}</title>\r\n<!-- The sitename is changed in Site Admin/Global settings. {title} is the name of each page -->\r\n\r\n{metadata}\r\n<!-- Don\'t remove this! Metadata is entered in Site Admin/Global settings. -->\r\n\r\n{stylesheet}\r\n<!-- This is how all the stylesheets attached to this template are linked to -->\r\n\r\n{cms_selflink dir=\"start\" rellink=1}\r\n{cms_selflink dir=\"prev\" rellink=1}\r\n{cms_selflink dir=\"next\" rellink=1}\r\n<!-- Relational links for interconnections between pages, good for accessibility and Search Engine Optmization -->\r\n\r\n\r\n{literal}\r\n<script type=\"text/JavaScript\">\r\n<!--\r\n//pass min and max -measured against window width\r\nfunction P7_MinMaxW(a,b){\r\n    var nw=\"auto\",w=document.documentElement.clientWidth;\r\n    if(w>=b){nw=b+\"px\";}if(w<=a){nw=a+\"px\";}return nw;\r\n}\r\n//-->\r\n</script>\r\n<!--[if lte IE 6]>\r\n<style type=\"text/css\">\r\n#pagewrapper {width:expression(P7_MinMaxW(720,950));}\r\n#container {height: 1%;}\r\n</style>\r\n<![endif]-->\r\n{/literal}\r\n<!-- The min and max page width for Internet Explorer is set here. For other browsers it\'s in the stylesheet \"Layout: Left sidebar + 1 column\" -->\r\n\r\n\r\n</head>\r\n\r\n<body>\r\n\r\n<div id=\"pagewrapper\">\r\n\r\n    <!-- start accessibility skip links -->\r\n    <ul class=\"accessibility\">\r\n      <li>{anchor anchor=\'menu_vert\' title=\'Skip to navigation\' accesskey=\'n\' text=\'Skip to navigation\'}</li>\r\n      <li>{anchor anchor=\'main\' title=\'Skip to content\' accesskey=\'s\' text=\'Skip to content\'}</li>\r\n    </ul>\r\n    <!-- end accessibility skip links -->\r\n\r\n\r\n    <hr class=\"accessibility\" />\r\n    <!-- Horizontal ruler that is hidden for visual browsers by CSS -->\r\n\r\n\r\n   <!-- Start Header, with logo image that links to the default start page. Logo image is changed in the stylesheet  \"For template: Left menu + 1 column\" -->\r\n   <div id=\"header\">\r\n           <h1>{cms_selflink dir=\"start\" text=\"$sitename\"}</h1>\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   <!-- End Header -->\r\n\r\n\r\n   <!-- Start Search-->\r\n   <div id=\"search\">\r\n          {search}\r\n   </div>\r\n   <!-- End Search -->\r\n\r\n\r\n   <!-- Start Breadcrumbs -->\r\n   <div class=\"breadcrumbs\">\r\n        {breadcrumbs starttext=\'You are here\' root=\'Home\' delimiter=\'&raquo;\'}\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   <!-- End Breadcrumbs -->\r\n\r\n\r\n   <!-- Start Content (Navigation and Content columns) -->\r\n   <div id=\"content\">\r\n\r\n      <!-- Start Sidebar -->\r\n      <div id=\"sidebar\">\r\n\r\n      <!-- Start Navigation -->\r\n      <div id=\"menu_vert\">\r\n         <h2 class=\"accessibility\">Navigation</h2>\r\n         {menu template=\'simple_navigation.tpl\' collapse=\'1\'}\r\n      </div>\r\n      <!-- End Navigation -->\r\n\r\n      <!-- Start News -->\r\n      <div id=\"news\">\r\n         <h2>News</h2>\r\n          {news number=\'3\' detailpage=\'news\'}\r\n      </div>\r\n      <!-- End News -->\r\n\r\n      </div>\r\n      <!-- End Sidebar -->\r\n\r\n\r\n      <!-- Start Content Area -->\r\n      <div id=\"main\">\r\n         <div style=\"float: right;\">{print showbutton=true script=true}</div>\r\n         <h2>{title}</h2>\r\n         {content} <br />\r\n\r\n         <!-- Start relational links -->\r\n     <div class=\"hr\"></div>\r\n     <div class=\"right49\">\r\n         <p>{anchor anchor=\'main\' text=\'^ Top\'}</p>\r\n     </div>\r\n         <div class=\"left49\">\r\n            <p>{cms_selflink dir=\"previous\" label=\"Previous page: \"} <br />\r\n            {cms_selflink dir=\"next\"}</p>\r\n         </div>\r\n         <!-- The label parameter doesn\'t need to be there if you\'re using English, but is here to show how it\'s used if you don\'t want the English text \"Previous page\" -->\r\n     <!-- End relational links -->\r\n\r\n      <hr class=\"accessibility\" />\r\n      </div>\r\n      <!-- End Content Area -->\r\n\r\n\r\n   </div>\r\n   <!-- End Content -->\r\n\r\n\r\n   <!-- Start Footer. Edit the footer in the Global Content Block called \"footer\" -->\r\n   <div id=\"footer\">\r\n      {global_content name=\'footer\'}\r\n   </div>   \r\n   <!-- End Footer  -->\r\n\r\n\r\n</div><!-- end pagewrapper -->\r\n</body>\r\n</html>', null, null, 1, 1, '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 114  INSERT INTO {DB_PREFIX}user_groups ( GROUP_ID, USER_ID, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 1, '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 115  INSERT INTO {DB_PREFIX}userplugins ( USERPLUGIN_ID, USERPLUGIN_NAME, CODE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'user_agent', '//Code to show the user\'s user agent information.\r\necho $_SERVER[\"HTTP_USER_AGENT\"];', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 116  INSERT INTO {DB_PREFIX}userplugins ( USERPLUGIN_ID, USERPLUGIN_NAME, CODE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 2, 'custom_copyright', '//set start to date your site was published\r\n$startCopyRight=\'2004\';\r\n\r\n// check if start year is this year\r\nif(date(\'Y\') == $startCopyRight){\r\n// it was, just print this year\r\n    echo $startCopyRight;\r\n}else{\r\n// it wasnt, print startyear and this year delimited with a dash\r\n    echo $startCopyRight.\'-\'. date(\'Y\');\r\n}', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 117  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'use_wysiwyg', '1', null );
 118  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'wysiwyg', 'FCKeditorX', null );
 119  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'default_cms_language', 'en_US', null );
 120  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'admintheme', 'default', null );
 121  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'bookmarks', 'on', null );
 122  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'recent', 'on', null );
 123  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'indent', 'on', null );
 124  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'ajax', '0', null );
 125  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'paging', '0', null );
 126  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'collapse', null, null );
 127  INSERT INTO {DB_PREFIX}userprefs ( USER_ID, PREFERENCE, VALUE, TYPE ) VALUES ( 1, 'hide_help_links', '0', null );
 128  INSERT INTO {DB_PREFIX}users ( USER_ID, USERNAME, PASSWORD, ADMIN_ACCESS, FIRST_NAME, LAST_NAME, EMAIL, ACTIVE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'admin', '6b903fbd0cb295eb1f4d589fefb435a5', 1, 'Admin', 'User', 'ted@cmsmadesimple.org', 1, '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
 129  INSERT INTO {DB_PREFIX}version ( VERSION ) VALUES ( 28 );
Code source de CMS made simple 1.0.5

/install/schemas/ -> initial.sql (source)
