CMS MADE SIMPLE FORGE

News Module

 

[#11606] Change News module category create_date to CMS_ADODB_DT instead of T

avatar
Created By: Deleted User (deleteduser_11200)
Date Submitted: Mon Oct 16 05:40:29 -0400 2017

Assigned To:
Version: 2.14.1
CMSMS Version: 2.2.3.1
Severity: Trivial
Resolution: None
State: Open
Summary:
Change News module category create_date to CMS_ADODB_DT instead of T
Detailed Description:
I was looking into the create_date and modified_date fields for the News
summary. I found out no date is stored only the time.

The names of the fields are a bit misleading there is no date part. 
It would be nice if this can be put on the feature request list perhaps when the
News module rewrite takes place.

Thank you.


=== code snippets ===


http://viewsvn.cmsmadesimple.org/filedetails.php?repname=newsmodule&path=%2Ftrunk%2Fmethod.install.php

$taboptarray = array('mysql' => 'TYPE=MyISAM');
$sqlarray = $dict->CreateTableSQL(CMS_DB_PREFIX."module_news", $flds,
$taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(CMS_DB_PREFIX."module_news_seq");

$flds = "
	news_category_id I KEY,
	news_category_name C(255) NOTNULL,
	parent_id I,
	hierarchy C(255),
    item_order I,
	long_name X,
	create_date T,
	modified_date T
";

=== /code snippets ===


History