Location: PHPKode > projects > OpenNitro > trunk/Tests/Data/DB/News/Structure.inc.php
<?php
//
// +---------------------------------------------------------------------------+
// | Daphne :: TestData :: DB                                                  |
// +---------------------------------------------------------------------------+
// | Copyright (c) 2006 Daphne Communication Management                        |
// +---------------------------------------------------------------------------+
// | This source file is copyrighted by Daphne Communication Management BV,    |
// | the Netherlands. If you would like to use this file in your projects,     |
// | please contact hide@address.com                                     |
// +---------------------------------------------------------------------------+
// | Authors: Oli Oskarsson <hide@address.com>                              |
// +---------------------------------------------------------------------------+
//
// $Id: Structure.inc.php 229 2008-04-17 09:20:31Z oli $
//
$Query = "
CREATE TABLE `News` (
  `NewsID` int(11) NOT NULL auto_increment,
  `NewsCategoryID` int(11) NOT NULL default '0',
  `VisibleFrom` datetime default NULL,
  `VisibleTill` datetime default NULL,
  `Title` varchar(150) NOT NULL default '',
  `Leader` text NOT NULL,
  `NewsText` text NOT NULL,
  `Published` tinyint(1) NOT NULL default '0',
  `CreatedByUserID` int(10) unsigned NOT NULL default '0',
  `CreatedOn` datetime NOT NULL default '0000-00-00 00:00:00',
  `EditedByUserID` int(10) unsigned default NULL,
  `EditedOn` datetime default NULL,
  PRIMARY KEY  (`NewsID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
?>
Return current item: OpenNitro