[WTB] Articles CMS that go with this DB structure

Discussion in 'Services' started by versus2, May 28, 2006.

  1. #1
    Hi,

    I have a DB with this structure:

    
    DROP TABLE IF EXISTS articles;
    CREATE TABLE articles (
      id int(10) unsigned NOT NULL auto_increment,
      categ int(3) unsigned NOT NULL default '0',
      title varchar(250) default NULL,
      author varchar(250) default NULL,
      date_pub int(20) unsigned default NULL,
      site varchar(200) default NULL,
      PRIMARY KEY (id),
      UNIQUE KEY id(id),
      KEY categ(categ)
    ) TYPE=MyISAM;
    
    #
    
    INSERT INTO articles VALUES("1", "1", "Sell More Books With an E-mail Newsletter", "Alexandria K. Brown", "1126962450", "ezinearticles.com");
    
    #
    
    DROP TABLE IF EXISTS articles_text;
    CREATE TABLE articles_text (
      id int(10) unsigned NOT NULL default '0',
      content text,
      KEY id(id)
    ) TYPE=MyISAM;
    
    
    INSERT INTO articles_text VALUES("1", "<p><i>NOTE: Because many words in this article are likely to trigger sp^m filters, we\'ve disguised them with symbols (e.g. sp^m). This will ensure a higher delivery rate if you use this article in your e-zine.</i></p>\r\n\r\n<p>If you\'re selling your... at the END of my sig file, after my contact information: \"BOOST BUSINESS by publishing your own e-mail newsletter! Learn how now — sign up for fr*ee how-to tips at http://www.ezinequeen.com.\"</li>\r\n</ol>\r\n\r\n<p>(c) 2000-2003 Alexandria K. Brown. All rights reserved.</p><p>ABOUT THE AUTHOR</p>");
    
    Code (markup):
    I need an Articles CMS that can work with it (SE friendly, Mod_Rewrite, Good admin panel)..

    Please post/pm if you have anything to offer.

    Thanks,
    E-A.
     
    versus2, May 28, 2006 IP