Armin Ronacher avatar Armin Ronacher committed ab3d9d1 Merge

Merge pull request #655 from oliversong/master

SQLite doesn't recognize data type "string"

Comments (0)

Files changed (3)

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

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
 );

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
 );
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.