[Typo3-debian] problem with sql installation

[Michael Ott]

Hello Tokeiito!
> #
> #
> # At the end of this file the static data will be inserted and an admin user
> will be created.
> #
> # Table definitions:
> #
> #
> CREATE TABLE be_groups(
> uid int( 11 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT ,
> pid int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> tstamp int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> title varchar( 20 ) DEFAULT '' NOT NULL ,
> non_exclude_fields blob NOT NULL ,
> db_mountpoints varchar( 40 ) DEFAULT '' NOT NULL ,
> pagetypes_select tinyblob NOT NULL ,
> tables_select blob NOT NULL ,
> tables_modify blob NOT NULL ,
> crdate int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> cruser_id int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> groupMods tinyblob NOT NULL ,
> file_mountpoints varchar( 40 ) DEFAULT '' NOT NULL ,
> hidden tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
> inc_access_lists tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
> description text NOT NULL ,
> lockToDomain varchar( 50 ) DEFAULT '' NOT NULL ,
> deleted tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
> TSconfig blob NOT NULL ,
> subgroup tinyblob NOT NULL ,
> hide_in_lists tinyint( 4 ) DEFAULT '0' NOT NULL ,
> PRIMARY KEY ( uid ) ,
> KEY parent( pid )
> ) TYPE = MYISAM
> MMyySSQQLL ssaaiidd::
> #1067 - Invalid default value for 'uid'
> 
> how to fix it?
Which MySQL-Version do you use?

CU        
         
  Michael  
          
--                                                       
           Michael Ott, e-mail: michael at zolnott.de, www.zolnott.de           
I am registered as user #275453 with the Linux Counter, http://counter.li.org.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.netfielders.de/pipermail/typo3-debian/attachments/20050117/1379eaaf/attachment.pgp