openrat-cms

commit 02438f24ffc170f1c28280c3e35ae2abe5fe78ba
parent 78b1882249ef10c05c175bd32c96d2c40fc9e7ba
Author: dankert <devnull@localhost>
Date:   Sat, 21 Apr 2007 14:08:57 +0200

Datei-Inhalt muss MEDIUMBLOB sein.

Diffstat:
doc/database/sql/mysql/create.sql
 | 
4
++--

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/doc/database/sql/mysql/create.sql b/doc/database/sql/mysql/create.sql
@@ -161,7 +161,7 @@ CREATE TABLE or_file (
      , objectid INT DEFAULT 0 NOT NULL
      , extension VARCHAR(10) NOT NULL
      , size INT DEFAULT 0 NOT NULL
-     , value TEXT NOT NULL
+     , value MEDIUMBLOB NOT NULL
      , PRIMARY KEY (id)
      , CONSTRAINT fk_file_01 FOREIGN KEY (objectid)
                   REFERENCES or_object (id) ON DELETE RESTRICT ON UPDATE RESTRICT
@@ -308,4 +308,4 @@ CREATE INDEX idx_acl_05 ON or_acl (is_transmit);
 
 INSERT INTO or_user
    (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin)
-   VALUES( 1,'admin','21232f297a57a5a743894a0e4a801fc3','','Administrator','','','The Admin User','default',1 )
+   VALUES( 1,'admin','admin','','Administrator','','','Admin user','default',1 )