field type miss when export table with only one field to sql,

[GoogleCodeExporter]

What steps will reproduce the problem?
1. create a table with only one text field
2. export this table to sql with create table sentence
3.

What is the expected output? What do you see instead?
expected:
CREATE TABLE "telno" ("tel"  TEXT PRIMARY KEY  NOT NULL );

But I got:
CREATE TABLE "telno" ("tel"  PRIMARY KEY  NOT NULL );

What version of the product are you using? On what target Application (e.g.
Firefox 2.0.0.14, Sunbird 0.8, etc.)? On what operating system?
Extension Version = 0.4.0
Application = firefox 3.0.1
OS = Windows XP

Please provide any additional information below.

Original issue reported on code.google.com by qq929962...@gmail.com on 6 Jan 2009 at 7:39

[GoogleCodeExporter]

I followed these steps:
1. created a table using: CREATE TABLE "telno" ("tel"  TEXT PRIMARY KEY  NOT 
NULL ); 
2. exported the table as SQL
3. Goth the following output:
DROP TABLE IF EXISTS "telno";
CREATE TABLE "telno" ("tel"  TEXT PRIMARY KEY  NOT NULL );

Everything looks OK! Please check the sqlite_master table to see the statement 
that
was used to create your table.

Original comment by mrinal.k...@gmail.com on 6 Jan 2009 at 11:13

• Changed state: Invalid

[GoogleCodeExporter]

I checked it again.
It will occur when you import from csv file and do not select column type.

Original comment by qq929962...@gmail.com on 7 Jan 2009 at 1:46

[GoogleCodeExporter]

I do not know how field type can be read from CSV. If there is a standard way 
to do
this, please let me know.
Also, after importing from CSV file, your create table statement would not have 
data
types for any field.

Original comment by mrinal.k...@gmail.com on 7 Jan 2009 at 1:02

[GoogleCodeExporter]

But it should popup an error message when user do not select field type rather 
than
still import the data with null data type.

Original comment by qq929962...@gmail.com on 8 Jan 2009 at 6:17

[GoogleCodeExporter]

I am unable to follow what is being reported here.

Original comment by mrinal.k...@gmail.com on 19 Jan 2009 at 5:23