#
# Data for table `authors`
#
INSERT INTO authors (authorid, login, userpassword, authorname, authoremail, regdate, usergroup, countrycode, language, phone, fax, address, city, state, zip, website, comments, newsletter) VALUES (1, 'admin', '5ce3bd448bf3cef938337494b0d98036', 'ezContents Administrator', 'admin.email@yourdomain.com', '2002-11-07 00:00:00', 'administrator', '', '', '', '', '', '', '', '', '', '', 'N');


# --------------------------------------------------------
#
# Data for table `banners`
#
INSERT INTO banners (bannerid, bannerimage, bannerurl, banneralt, publishdate, expiredate, impressions, clicks, banneractive, bannerhtml, authorid) VALUES (1, 'banners/ezcnt_banner.gif', 'http://www.ezcontents.org/', 'Download ezContents for free!', '2002-03-01 00:00:00', '2010-05-10 00:00:00', 0, 0, 'Y', '', 1);


# --------------------------------------------------------
#
# Data for table `groups`
#
INSERT INTO groups (groupid, groupdesc, grouplink, grouporderid, menuimage1, menuimage2, menuvisible, menuorderby, menuorderdir, hovertitle, openinpage, topgroupname, loginreq, usergroups, groupname, language, menuimage3, menuimage4, authorid, subgroupcount) VALUES (1, 'Welcome', '', 1, '', '', 'Y', '1', 'A', 'Welcome to ezContents', '', '', '', '', 'Welcome', 'en', '', '', 1, 0);


# --------------------------------------------------------
#
# Data for table `contents`
#
INSERT INTO contents (contentid, groupname, title, body, publishdate, expiredate, contentactive, teaser, orderid, authorid, updatedate, subgroupname, imagealign, image, headervisible, authorvisible, updatedatevisible, headerimage, imagedetails, imagedetailsalign, leftright, contentname, language, canrate, cancomment, ratingtotal, ratingvotes, cbody, cteaser, printerfriendly) VALUES (1, 'Welcome', 'Congratulations', 'You have successfully installed ezContents CMS Version 2.0.0', '2003-03-11 00:00:00', '2005-03-11 00:00:00', '1', '', 1, 1, '2003-03-11 09:58:14', '', 'L', '', 'Y', '', '', '', '', 'L', 'L', 'Welcome', 'en', '', '', 0, 0, 'You have successfully installed ezContents CMS Version 2.0.0', '', '');
INSERT INTO contents (contentid, groupname, title, body, publishdate, expiredate, contentactive, teaser, orderid, authorid, updatedate, subgroupname, imagealign, image, headervisible, authorvisible, updatedatevisible, headerimage, imagedetails, imagedetailsalign, leftright, contentname, language, canrate, cancomment, ratingtotal, ratingvotes, cbody, cteaser, printerfriendly) VALUES (2, 'Welcome', 'Lorem ipsum dolor sit amet', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in et iusto odio dignissim iriure qui blandit.', '2003-03-11 00:00:00', '2005-03-11 00:00:00', '1', '', 1, 1, '2003-03-11 09:58:14', '', 'L', '', 'Y', '', '', '', '', 'L', 'L', 'Lipsum', 'en', '', '', 0, 0, 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in et iusto odio dignissim iriure qui blandit.', '', '');


# --------------------------------------------------------
#
# Data for table `imageformattemplates`
#
INSERT INTO imageformattemplates (imageformatname, ifalign, ifborder, ifbgcolor, authorid) VALUES ('centreborder', 'C', 2, 'White', 1);
INSERT INTO imageformattemplates (imageformatname, ifalign, ifborder, ifbgcolor, authorid) VALUES ('leftborder', 'L', 2, 'White', 1);
INSERT INTO imageformattemplates (imageformatname, ifalign, ifborder, ifbgcolor, authorid) VALUES ('rightborder', 'R', 2, 'White', 1);
INSERT INTO imageformattemplates (imageformatname, ifalign, ifborder, ifbgcolor, authorid) VALUES ('centrenoborder', 'C', 0, 'Black', 1);
INSERT INTO imageformattemplates (imageformatname, ifalign, ifborder, ifbgcolor, authorid) VALUES ('leftnoborder', 'L', 0, 'Black', 1);
INSERT INTO imageformattemplates (imageformatname, ifalign, ifborder, ifbgcolor, authorid) VALUES ('rightnoborder', 'R', 0, 'Black', 1);


# --------------------------------------------------------
#
# Data for table `sidebartemplates`
#
INSERT INTO sidebartemplates (sidebarname, sbalign, sbborder, sbbgcolor, sbwidth, authorid) VALUES ('sbcentre50', 'C', 2, 'White', '50%', 1);
INSERT INTO sidebartemplates (sidebarname, sbalign, sbborder, sbbgcolor, sbwidth, authorid) VALUES ('sbleft50', 'L', 2, 'White', '50%', 1);
INSERT INTO sidebartemplates (sidebarname, sbalign, sbborder, sbbgcolor, sbwidth, authorid) VALUES ('sbright50', 'R', 2, 'White', '50%', 1);
INSERT INTO sidebartemplates (sidebarname, sbalign, sbborder, sbbgcolor, sbwidth, authorid) VALUES ('sb100', 'L', 2, 'White', '100%', 1);


# --------------------------------------------------------
#
# Data for table `tags`
#
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('line', 'Y', NULL, '<HR>', 1, 'other');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('b', NULL, NULL, '<B>', 1, 'text');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/b', NULL, NULL, '</B>', 1, 'text');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/i', NULL, NULL, '</I>', 1, 'text');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('i', NULL, NULL, '<I>', 1, 'text');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('u', NULL, NULL, '<U>', 1, 'text');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/u', NULL, NULL, '</U>', 1, 'text');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('ul', NULL, NULL, '<UL>', 1, 'list');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/ul', NULL, NULL, '</UL>', 1, 'list');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/ol', NULL, NULL, '</OL>', 1, 'list');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('ol', NULL, NULL, '<OL>', 1, 'list');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('li', NULL, NULL, '<LI>', 1, 'list');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/li', NULL, NULL, '</LI>', 1, 'list');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('h2', NULL, NULL, '<H2>', 1, 'title');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/h2', NULL, NULL, '</H2>', 1, 'title');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/h3', NULL, NULL, '</H3>', 1, 'title');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('h3', NULL, NULL, '<H3>', 1, 'title');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('h4', NULL, NULL, '<H4>', 1, 'title');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/h4', NULL, NULL, '</H4>', 1, 'title');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/table', 'Y', 'Y', '</TABLE>', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('row', 'Y', 'Y', '<TR>', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/row', 'Y', 'Y', '</TR>', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_lt', 'Y', 'Y', '<TD ALIGN="LEFT" VALIGN="TOP">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_ct', 'Y', 'Y', '<TD ALIGN="CENTER" VALIGN="TOP">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_rt', 'Y', 'Y', '<TD ALIGN="RIGHT" VALIGN="TOP">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_lc', 'Y', 'Y', '<TD ALIGN="LEFT" VALIGN="CENTER">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_cc', 'Y', 'Y', '<TD ALIGN="CENTER" VALIGN="CENTER">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_rc', 'Y', 'Y', '<TD ALIGN="RIGHT" VALIGN="CENTER">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_lb', 'Y', 'Y', '<TD ALIGN="LEFT" VALIGN="BOTTOM">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_cb', 'Y', 'Y', '<TD ALIGN="CENTER" VALIGN="BOTTOM">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('cell_rb', 'Y', 'Y', '<TD ALIGN="RIGHT" VALIGN="BOTTOM">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('/cell', 'Y', 'Y', '</TD>', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('dot', 'Y', 'Y', '&#149;', 1, 'other');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('table', 'Y', 'Y', '<TABLE BORDER="1" WIDTH="100%">', 1, 'table');
INSERT INTO tags (tag, canedit, candelete, translation, authorid, cat) VALUES ('top', 'Y', 'Y', '<A HREF="#TOP">Top of page</A>', 1, 'other');
