openrat-cms

commit d1881f9d4a76cfdc08053ca05c38183f8fc022fd
parent 49a39ac7c661100eb93af921d371679e59d9bc33
Author: Jan Dankert <devnull@localhost>
Date:   Wed,  3 Oct 2012 02:53:44 +0200

INSERT-Anweisungen mit abschließendem Semikolon.

Diffstat:
doc/database/sql/create.sh
 | 
2
+-
doc/database/sql/mysql/create.sql
 | 
2
+-
doc/database/sql/oracle/create.sql
 | 
2
+-
doc/database/sql/postgresql/create.sql
 | 
2
+-
doc/database/sql/sqlite/create.sql
 | 
2
+-

5 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/doc/database/sql/create.sh b/doc/database/sql/create.sh
@@ -219,7 +219,7 @@ constraint()
 # param 3: values. Seperate multiple values with ','
 insert()
 {
-	echo "INSERT INTO ${prefix}${1}${suffix} ($2) VALUES($3)" >> $outfile
+	echo "INSERT INTO ${prefix}${1}${suffix} ($2) VALUES($3);" >> $outfile
 }
 
 
diff --git a/doc/database/sql/mysql/create.sql b/doc/database/sql/mysql/create.sql
@@ -390,4 +390,4 @@ CREATE INDEX or_idx_acl_objectid
           ON or_acl (objectid);
 CREATE INDEX or_idx_acl_is_transmit
           ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1)
+INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);
diff --git a/doc/database/sql/oracle/create.sql b/doc/database/sql/oracle/create.sql
@@ -360,4 +360,4 @@ CREATE INDEX or_idx_77
           ON or_acl (objectid);
 CREATE INDEX or_idx_78
           ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1)
+INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);
diff --git a/doc/database/sql/postgresql/create.sql b/doc/database/sql/postgresql/create.sql
@@ -390,4 +390,4 @@ CREATE INDEX or_idx_acl_objectid
           ON or_acl (objectid);
 CREATE INDEX or_idx_acl_is_transmit
           ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1)
+INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);
diff --git a/doc/database/sql/sqlite/create.sql b/doc/database/sql/sqlite/create.sql
@@ -390,4 +390,4 @@ CREATE INDEX or_idx_acl_objectid
           ON or_acl (objectid);
 CREATE INDEX or_idx_acl_is_transmit
           ON or_acl (is_transmit);
-INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1)
+INSERT INTO or_user (id,name,password,ldap_dn,fullname,tel,mail,descr,style,is_admin) VALUES(1,'admin','admin','','Administrator','','','Admin user','default',1);