[Comoblog-commit] comoblog/_install comoblog_db.xml,NONE,1.1 comoblog_preferences.xml,NONE,1.1

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/comoblog/comoblog/_install
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9746

Added Files:
	comoblog_db.xml comoblog_preferences.xml 
Log Message:
Rename of easymoblog install files

--- NEW FILE: comoblog_preferences.xml ---
<?xml version="1.0" standalone="yes"?>

<easymoblog_preferences>
   
   <param 
      name="CFG_VERSION"
      value="0.5.1"
      description="EasyMoblog version number"
      topic_id="0"
      encrypt="N"
      type="text"
      restrict_values=""
      accept_null="N"
      editable="N"
      display_order="0"
   />
   
   <param 
      name="CFG_ADMIN_USERNAME"
[...1293 lines suppressed...]
      restrict_values="normal|italic"
      accept_null="N"
      editable="Y"
      display_order=""
   />

   <param
      name="CFG_FOOTER_COLOR"
      value="ffffff"
      description="Text colour for Page Footer"
      topic_id="12"
      encrypt="N"
      type="color_picker"
      restrict_values=""
      accept_null="N"
      editable="Y"
      display_order=""
   />

</easymoblog_preferences>

--- NEW FILE: comoblog_db.xml ---
<?xml version="1.0" standalone="yes"?>

<easymoblog_db>

   <table name="easymoblog_comments">
      <field name="comment_id"                  specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="comment_text"                specs="mediumtext" />
      <field name="comment_author"              specs="varchar(128) default NULL" />
      <field name="comment_author_email"        specs="varchar(128) default NULL" />
      <field name="comment_added"               specs="int(10) unsigned default NULL" />
      <field name="post_id"                     specs="int(10) unsigned NOT NULL default '0'" />
      
      <pk name="comment_id" />
   </table>

   <table name="easymoblog_images">
      <field name="img_id"                      specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="img_mime"                    specs="varchar(32) default '0'" />
      <field name="img_extension"               specs="varchar(255) NOT NULL default ''" />
      <field name="post_id"                     specs="int(10) unsigned default NULL" />
      <field name="img_display"                 specs="enum('inline','attach') default NULL" />
      <field name="img_thumb"                   specs="enum('Y','N') NOT NULL default 'N'" />
      <field name="img_width"                   specs="varchar(8) NOT NULL default ''" />
      <field name="img_height"                  specs="varchar(8) NOT NULL default ''" />
      
      <pk name="img_id" />
      
      <row>
         <field name="img_id" value="1" />
         <field name="img_mime" value="image/gif" />
         <field name="img_extension" value="gif" />
         <field name="post_id" value="" />
         <field name="img_display" value="" />
      </row>

      <row>
         <field name="img_id" value="2" />
         <field name="img_mime" value="image/gif" />
         <field name="img_extension" value="gif" />
         <field name="post_id" value="" />
         <field name="img_display" value="" />
      </row>
      
      <row>
         <field name="img_id" value="3" />
         <field name="img_mime" value="image/gif" />
         <field name="img_extension" value="gif" />
         <field name="post_id" value="" />
         <field name="img_display" value="" />
      </row>
   </table>

   <table name="easymoblog_modules">
      <field name="mod_id"                      specs="int(3) unsigned NOT NULL auto_increment" />
      <field name="mod_name"                    specs="varchar(64) NOT NULL default ''" />
      <field name="mod_description"             specs="varchar(255) default NULL" />
      <field name="mod_pos"                     specs="enum('sidebar','top','not_visible') NOT NULL default 'sidebar'" />
      <field name="mod_display_order"           specs="int(10) unsigned default NULL" />
      <field name="mod_allowed_pos"             specs="varchar(32) default NULL" />
      <field name="mod_filter_posts"            specs="enum('N','Y') NOT NULL default 'N'" />
      <field name="mod_filter_comments"         specs="enum('N','Y') NOT NULL default 'N'" />      
      <field name="mod_info"                    specs="text" />
   
      <pk name="mod_id" />
      <uk name="mod_name" />
   </table>

   <table name="easymoblog_posts">
      <field name="post_id"                     specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="post_added"                  specs="int(10) unsigned default NULL" />
      <field name="post_ctype"                  specs="enum('text/plain','text/html') NOT NULL default 'text/plain'" />
      <field name="post_images"                 specs="int(10) unsigned default '0'" />
      <field name="post_mail_from"              specs="varchar(255) default NULL" />
      <field name="post_mail_date"              specs="int(10) unsigned default NULL" />
      <field name="post_mail_subject"           specs="varchar(255) default NULL" />
      <field name="post_mail_body"              specs="text" />
      <field name="post_mail_user_agent"        specs="varchar(255) default NULL" />
      <field name="topic_id"                    specs="int(10) unsigned NOT NULL default '0'" />
      
      <pk name="post_id" />
   </table>

   <table name="easymoblog_preferences">
      <field name="pref_id"                     specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="pref_name"                   specs="varchar(64) NOT NULL default ''" />
      <field name="pref_value"                  specs="text" />
      <field name="pref_description"            specs="varchar(255) default NULL" />
      <field name="pref_topic_id"               specs="int(10) unsigned NOT NULL default '0'" />
      <field name="pref_encrypt"                specs="enum('N','Y') NOT NULL default 'N'" />
      <field name="pref_type"                   specs="varchar(32) default NULL" />
      <field name="pref_restrict_values"        specs="varchar(255) default NULL" />
      <field name="pref_accept_null"            specs="enum('Y','N') NOT NULL default 'N'" />
      <field name="pref_editable"               specs="enum('Y','N') NOT NULL default 'Y'" />
      <field name="pref_display_order"          specs="int(10) unsigned default NULL" />
      <field name="mod_name"                    specs="varchar(64) default NULL" />
      
      <pk name="pref_id" />
      <uk name="pref_name" />
   </table>

   <table name="easymoblog_preferences_topics">
      <field name="pref_topic_id"               specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="pref_topic_name"             specs="varchar(32) NOT NULL default ''" />
      <field name="pref_topic_description"      specs="varchar(255) default NULL" />
      <field name="pref_topic_display_order"    specs="int(10) unsigned default NULL" />
      <field name="pref_topic_info"             specs="text" />
      <field name="pref_topic_area"             specs="enum('','appearance','functionality') NOT NULL default ''" />
      
      <pk name="pref_topic_id" />
      <uk name="pref_topic_name" />
   
      <row>
         <field name="pref_topic_id"            value="1" />
         <field name="pref_topic_name"          value="restrictions" />
         <field name="pref_topic_description"   value="Restriction for posts" />
         <field name="pref_topic_display_order" value="1" />
         <field name="pref_topic_info"          value="&lt;p&gt;Make sure to write email addresses separated by commas, and without white spaces.&lt;/p&gt;&lt;p&gt;for example:&lt;br /&gt;&lt;span style=&quot;font: 10px Courier New,Courier,monospace&quot;&gt;yo...@ex...,you...@ex...,ano...@ex...&lt;/span&gt;&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;&lt;b&gt;If you leave the field blank, everyone will be able to post to your site!&lt;/b&gt;&lt;/p&gt;" />
         <field name="pref_topic_area"          value="functionality" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="2" />
         <field name="pref_topic_name"          value="authentication" />
         <field name="pref_topic_description"   value="Admin area authentication parameters" />
         <field name="pref_topic_display_order" value="2" />
         <field name="pref_topic_info"          value="&lt;p&gt;Keep your password secure!&lt;/p&gt;&lt;p&gt;Knowing your password, malicious users will be able to modify your site, delete posts, and even change the admin password&lt;/p&gt;" />
         <field name="pref_topic_area"          value="functionality" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="3" />
         <field name="pref_topic_name"          value="language" />
         <field name="pref_topic_description"   value="Language for you EasyMoblog site" />
         <field name="pref_topic_display_order" value="0" />
         <field name="pref_topic_info"          value="&lt;p&gt;Language will be applied to your EasyMoblog site, not to the Admin Area&lt;/p&gt;" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="4" />
         <field name="pref_topic_name"          value="POP3" />
         <field name="pref_topic_description"   value="POP3 account used for EasyMoblog posts" />
         <field name="pref_topic_display_order" value="4" />
         <field name="pref_topic_info"          value="&lt;p&gt;Every mail message sent to the mailbox you specify here will be published on your EasyMoblog site, and then deleted to the mailbox.&lt;/p&gt;&lt;p&gt;If you want to prevent other users to post to your site (including spammers), you need to specify the email addresses of people allowed to post in the &lt;a href=&quot;preferences.php?t=1&quot;&gt;restrictions&lt;/a&gt; preferences section.&lt;/p&gt;" />
         <field name="pref_topic_area"          value="functionality" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="5" />
         <field name="pref_topic_name"          value="interaction" />
         <field name="pref_topic_description"   value="Enable/disable comments and trackback, show/hide email address of posts' author" />
         <field name="pref_topic_display_order" value="5" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="functionality" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="6" />
         <field name="pref_topic_name"          value="header" />
         <field name="pref_topic_description"   value="Customize page header appearance (blog logo, blog title, fonts, colours)" />
         <field name="pref_topic_display_order" value="1" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="7" />
         <field name="pref_topic_name"          value="topbar" />
         <field name="pref_topic_description"   value="Customize topbar appearance (colours)" />
         <field name="pref_topic_display_order" value="2" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="8" />
         <field name="pref_topic_name"          value="sidebar" />
         <field name="pref_topic_description"   value="Customize sidebar appearance (width, colours)" />
         <field name="pref_topic_display_order" value="3" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="9" />
         <field name="pref_topic_name"          value="intro" />
         <field name="pref_topic_description"   value="Customize page intro (intro text, fonts and colours for home page)" />
         <field name="pref_topic_display_order" value="4" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="10" />
         <field name="pref_topic_name"          value="posts" />
         <field name="pref_topic_description"   value="Customize posts appearance (fonts, colours, attached images)" />
         <field name="pref_topic_display_order" value="5" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="11" />
         <field name="pref_topic_name"          value="comments" />
         <field name="pref_topic_description"   value="Customize comments appearance (fonts, colours)" />
         <field name="pref_topic_display_order" value="6" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="12" />
         <field name="pref_topic_name"          value="footer" />
         <field name="pref_topic_description"   value="Customize footer appearance (text and colours for page footer)" />
         <field name="pref_topic_display_order" value="7" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>

      <row>
         <field name="pref_topic_id"            value="13" />
         <field name="pref_topic_name"          value="system" />
         <field name="pref_topic_description"   value="Server configuration (advanced users!)" />
         <field name="pref_topic_display_order" value="6" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="functionality" />
      </row>
      
      <row>
         <field name="pref_topic_id"            value="14" />
         <field name="pref_topic_name"          value="page" />
         <field name="pref_topic_description"   value="" />
         <field name="pref_topic_display_order" value="0" />
         <field name="pref_topic_info"          value="" />
         <field name="pref_topic_area"          value="appearance" />
      </row>
   </table>
   
   <table name="easymoblog_topics">
      <field name="topic_id"                    specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="topic_keyword"               specs="varchar(64) default NULL" />
      <field name="topic_name"                  specs="varchar(63) default NULL" />
      <field name="topic_description"           specs="varchar(255) default NULL" />
      <field name="img_id"                      specs="int(10) unsigned default NULL" />
      
      <pk name="topic_id" />
      <uk name="topic_keyword" />
   </table>

   <table name="easymoblog_trackback_pings">
      <field name="trackback_id"                specs="int(10) unsigned NOT NULL auto_increment" />
      <field name="trackback_title"             specs="varchar(255) default NULL" />
      <field name="trackback_excerpt"           specs="varchar(255) default NULL" />
      <field name="trackback_url"               specs="varchar(255) default NULL" />
      <field name="trackback_blog_name"         specs="varchar(255) default NULL" />
      <field name="trackback_added"             specs="int(10) unsigned default NULL" />
      <field name="post_id"                     specs="int(10) unsigned default NULL" />
      
      <pk name="trackback_id" />
   </table>

</easymoblog_db>