def initialize(self, author=""):
        ''' Initialize the database.  This is dangerous since it removes any
        existing content.'''
        self.cur.execute("CREATE TABLE version(major, minor);")
        self.cur.execute("INSERT INTO version(major, minor) VALUES (?,?);",
                (self.appversion[0], self.appversion[1]))
        #20150314 self.cur.execute("CREATE TABLE note(noteId integer primary key autoincrement, authorId, date, modified, due, title, content, hash, privacy DEFAULT 0, in_trash DEFAULT 0);")
        self.cur.execute("CREATE TABLE note(noteId integer primary key autoincrement, authorId, date, modified, due, title, content, hash, privacy DEFAULT 0, book DEFAULT 1);")
        self.cur.execute("CREATE TABLE author(authorId integer primary key autoincrement, name, nickname);")
        self.cur.execute("CREATE TABLE alias(aliasId integer primary key autoincrement, item, alias);")
        self.cur.execute("CREATE TABLE keyword(keywordId integer primary key autoincrement, keyword);")
        self.cur.execute("CREATE TABLE notekeyword(notekeywordId integer primary key autoincrement, noteid, keywordid);")
        self.cur.execute("CREATE TABLE book(bookId integer primary key autoincrement, number, name DEFAULT '');")
        self.cur.execute("INSERT INTO book(number, name) VALUES (0, 'Trash');")
        self.cur.execute("INSERT INTO book(number, name) VALUES (1, 'Default');")
        self.con.commit()
def initialize ( self , author = "" ) : self . cur . execute ( "CREATE TABLE version(major, minor);" ) self . cur . execute ( "INSERT INTO version(major, minor) VALUES (?,?);" , ( self . appversion [ 0 ] , self . appversion [ 1 ] ) ) self . cur . execute ( "CREATE TABLE note(noteId integer primary key autoincrement, authorId, date, modified, due, title, content, hash, privacy DEFAULT 0, book DEFAULT 1);" ) self . cur . execute ( "CREATE TABLE author(authorId integer primary key autoincrement, name, nickname);" ) self . cur . execute ( "CREATE TABLE alias(aliasId integer primary key autoincrement, item, alias);" ) self . cur . execute ( "CREATE TABLE keyword(keywordId integer primary key autoincrement, keyword);" ) self . cur . execute ( "CREATE TABLE notekeyword(notekeywordId integer primary key autoincrement, noteid, keywordid);" ) self . cur . execute ( "CREATE TABLE book(bookId integer primary key autoincrement, number, name DEFAULT '');" ) self . cur . execute ( "INSERT INTO book(number, name) VALUES (0, 'Trash');" ) self . cur . execute ( "INSERT INTO book(number, name) VALUES (1, 'Default');" ) self . con . commit ( )
Initialize the database.  This is dangerous since it removes any
        existing content.