diff options
Diffstat (limited to 'sql/sqlite/schema.sql')
-rw-r--r-- | sql/sqlite/schema.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/sql/sqlite/schema.sql b/sql/sqlite/schema.sql index a0daf61..eeab2f9 100644 --- a/sql/sqlite/schema.sql +++ b/sql/sqlite/schema.sql @@ -4,6 +4,11 @@ create table if not exists epube_pagination ( total_pages integer not null, pagination text not null); +create table if not exists epube_users ( + id integer not null primary key autoincrement, + username varchar(100) not null, + pass varchar(200) not null); + create table if not exists epube_books ( id integer not null primary key autoincrement, bookid integer not null, @@ -12,11 +17,6 @@ create table if not exists epube_books ( lastcfi varchar(200) not null, lastread integer not null); -create table if not exists epube_users ( - id integer not null primary key autoincrement, - user varchar(100) not null, - pass varchar(200) not null); - create table if not exists epube_favorites( id integer not null primary key autoincrement, bookid integer not null, |