[fdo-trac] #641: SQLite Can't create a datetime column

[FDO]

#641: SQLite Can't create a datetime column
-----------------------------+----------------------------------------------
 Reporter:  bscott           |         Owner:  traianstanev
     Type:  enhancement      |        Status:  assigned    
 Priority:  blocker          |     Milestone:  3.5.0       
Component:  SQLite Provider  |       Version:  3.5.0       
 Severity:  1                |    Resolution:              
 Keywords:                   |   External_id:              
-----------------------------+----------------------------------------------
Comment (by traianstanev):

 I checked with Romy -- supporting this would require parsing the SQL
 create table string manually to detect this.

 Really, we recommend using the metadata table -- in FDO-SQLite it's
 actually not like the FDO tables in other providers -- it is just one
 extra table, and you can still manage the database without messing with
 that table (and without using FDO). If you delete that table, the database
 will still work.

 Also, you can only add the properties whose types you want to be reported
 correctly to that table, and not all the properties. This way you get your
 type hint.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/641#comment:7>
FDO <http://fdo.osgeo.org/>
Feature Data Objects