kowdermeister/iScaffold — Issue #1: Setup error on MsSql
Author: biohazardxxx
Created: 2012-01-23 09:14:08+00:00
State: open

Hi,

when trying to setup iScaffold with MSSQL I get an error when creating sf_config table.

The error massage says Wrong syntax in the near of 'sf_config'.

Falsche Syntax in der Nähe von 'sf_config'.

CREATE TABLE IF NOT EXISTS sf_config ( sf_id INT(5) UNSIGNED AUTO_INCREMENT PRIMARY KEY, sf_table VARCHAR(64) DEFAULT '' NOT NULL, sf_field VARCHAR(64) DEFAULT '' NOT NULL, sf_type VARCHAR(16) DEFAULT 'default' NULL, sf_related VARCHAR(100) DEFAULT '' NULL, sf_label VARCHAR(64) DEFAULT '' NULL, sf_desc TINYTEXT NULL, sf_order INT(3) NULL, sf_hidden INT(1) DEFAULT '0' NULL )

Filename: C:\www\iScaffold\system\database\DB_driver.php

Line Number: 330

My Environemnt:
Windows 2008 R2
PHP Version 5.2.17
Apache 2.2
DB: MSSQL 2005 express

Best regards
-Alex