Commits

Armin Ronacher  committed ab3d9d1 Merge

Merge pull request #655 from oliversong/master

SQLite doesn't recognize data type "string"

  • Participants
  • Parent commits e101655, cc82feb

Comments (0)

Files changed (3)

File docs/tutorial/schema.rst

     drop table if exists entries;
     create table entries (
       id integer primary key autoincrement,
-      title string not null,
-      text string not null
+      title text not null,
+      text text not null
     );
 
 This schema consists of a single table called `entries` and each row in

File examples/flaskr/schema.sql

 drop table if exists entries;
 create table entries (
   id integer primary key autoincrement,
-  title string not null,
-  text string not null
+  title text not null,
+  text text not null
 );

File examples/minitwit/schema.sql

 drop table if exists user;
 create table user (
   user_id integer primary key autoincrement,
-  username string not null,
-  email string not null,
-  pw_hash string not null
+  username text not null,
+  email text not null,
+  pw_hash text not null
 );
 
 drop table if exists follower;
 create table message (
   message_id integer primary key autoincrement,
   author_id integer not null,
-  text string not null,
+  text text not null,
   pub_date integer
 );