From 943de432e121bfe89388c1c22514180ede74429c Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sun, 13 Jul 2008 10:12:20 +0000
Subject: [PATCH] MDL-15071 fixes of the SQLite layer by Andrei Bautu

---
 lib/ddl/sqlite_sql_generator.php        |  2 +-
 lib/dml/sqlite3_pdo_moodle_database.php | 15 +++++++++++----
 2 files changed, 12 insertions(+), 5 deletions(-)

diff --git a/lib/ddl/sqlite_sql_generator.php b/lib/ddl/sqlite_sql_generator.php
index 3896dfddac..3f8c7fce48 100644
--- a/lib/ddl/sqlite_sql_generator.php
+++ b/lib/ddl/sqlite_sql_generator.php
@@ -49,7 +49,7 @@ class sqlite_sql_generator extends sql_generator {
 
     public $sequence_only = true; //To avoid to output the rest of the field specs, leaving only the name and the sequence_name publiciable
     public $sequence_extra_code = false; //Does the generator need to add extra code to generate the sequence fields
-    public $sequence_name = 'INTEGER PRIMARY KEY AUTOINCREMENT'; //Particular name for inline sequences in this generator
+    public $sequence_name = 'INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL'; //Particular name for inline sequences in this generator
     public $unsigned_allowed = false;    // To define in the generator must handle unsigned information
 
     public $enum_extra_code = false; //Does the generator need to add extra code to generate code for the enums in the table
diff --git a/lib/dml/sqlite3_pdo_moodle_database.php b/lib/dml/sqlite3_pdo_moodle_database.php
index 5798fefb43..b461a1d4c4 100644
--- a/lib/dml/sqlite3_pdo_moodle_database.php
+++ b/lib/dml/sqlite3_pdo_moodle_database.php
@@ -110,7 +110,7 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
      */
     public function get_tables() {
         $tables = array();
-        $sql = 'SELECT name FROM sqlite_master WHERE type="table"';
+        $sql = 'SELECT name FROM sqlite_master WHERE type="table" ORDER BY name';
         if($this->debug) {
             $this->debug_query($sql);
         }
@@ -132,13 +132,14 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
      */
     public function get_indexes($table) {
         $indexes = array();
-        $sql = 'SELECT * FROM sqlite_master WHERE type="index" AND tbl_name="'. $this->prefix . $table . '"';
+        $sql = 'PRAGMA index_list('. $this->prefix . $table . ')';
         if($this->debug) {
             $this->debug_query($sql);
         }
         $rsindexes = $this->pdb->query($sql);
         foreach($rsindexes as $index) {
-            $index = strtolower($index['name']);
+            $unique = (boolean)$index['unique'];
+            $index = $index['name'];
             $sql = 'PRAGMA index_info("' . $index . '")';
             if($this->debug) {
                 $this->debug_query($sql);
@@ -149,6 +150,7 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
                 $columns[] = strtolower($row['name']);
             }
             $index = strtolower($index);
+            $indexes[$index]['unique'] = $unique;
             $indexes[$index]['columns'] = $columns;
         }
         return $indexes;
@@ -188,6 +190,9 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
                 'primary_key' => (boolean)$row['pk'],
                 'has_default' => !is_null($row['dflt_value']),
                 'default_value' => $row['dflt_value'],
+                'auto_increment' => false,
+                'binary' => false,
+                //'unsigned' => false,
             );
             $type = explode('(', $row['type']);
             $columninfo['type'] = strtolower($type[0]);
@@ -204,6 +209,7 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
                 case 'int': // int integer
                     if($columninfo['primary_key'] && preg_match('/' . $columninfo['name'] . '\W*integer\W*primary\W*key\W*autoincrement/im', $createsql)) {
                         $columninfo['meta_type'] = 'R';
+                        $columninfo['auto_increment'] = true;
                     } else {
                         $columninfo['meta_type'] = 'I';
                     }
@@ -225,11 +231,13 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
                 case 'blo': // blob
                 case 'non': // none
                     $columninfo['meta_type'] = 'B';
+                    $columninfo['binary'] = true;
                     break;
                 case 'boo': // boolean
                 case 'bit': // bit
                 case 'log': // logical
                     $columninfo['meta_type'] = 'L';
+                    $columninfo['max_length'] = 1;
                     break;
                 case 'tim': // timestamp
                     $columninfo['meta_type'] = 'T';
@@ -238,7 +246,6 @@ class sqlite3_pdo_moodle_database extends pdo_moodle_database {
                     $columninfo['meta_type'] = 'D';
                     break;
             }
-
             $columns[$columninfo['name']] = new database_column_info($columninfo);
         }
 
-- 
2.39.5