make it work with current database (db & field names changed)

diff --git a/gen/aliases.dc b/gen/aliases.dc
index af2b3318bf16f514b767dabc82df3c8cdb6eca8f..59ff603610d7058783d841dfdc6cd46f6cc2bdd4 100644 (file)
--- a/gen/aliases.dc
+++ b/gen/aliases.dc
@@ -43,10 +43,10 @@ char **argv;
     out = stdout;
     initialize_sms_error_table();
 #ifsql INGRES
-    EXEC SQL CONNECT sms;
+    EXEC SQL CONNECT moira;
 #endsql
 #ifsql INFORMIX
-    EXEC SQL DATABASE sms;
+    EXEC SQL DATABASE moira;
 #endsql
 
 
@@ -139,7 +139,7 @@ get_info()
 
     /* get locks */
     EXEC SQL SELECT modtime INTO :buf FROM list WHERE LIST_ID = 0;
-    EXEC SQL SELECT modtime INTO :buf FROM list WHERE USERS_ID = 0;
+    EXEC SQL SELECT modtime INTO :buf FROM users WHERE USERS_ID = 0;
 
     fprintf(stderr, "Loading machines\n");
     machines = create_hash(1000);
@@ -212,7 +212,7 @@ get_info()
     lists = create_hash(15001);
 
     EXEC SQL DECLARE l_cursor CURSOR FOR
-      SELECT list_id, name, maillist, desc, acl_type, acl_id
+      SELECT list_id, name, maillist, description, acl_type, acl_id
        FROM list WHERE active != 0;
     EXEC SQL OPEN l_cursor;
     while (1) {