00001
00002 #include <stdlib.h>
00003 #include <stdio.h>
00004 #include <string.h>
00005
00006 #include "01-connect.h"
00007 #include <mysql/mysql.h>
00008
00009 int main (int argc, char *argv[])
00010 {
00011 MYSQL *connection1;
00012 int result;
00013 int result1;
00014 connection1 = mysql_init(NULL);
00015
00016 if (mysql_real_connect (connection1, "localhost", "ain", "ain151", "atm", 0, NULL, 0))
00017 {
00018 printf ("Connection successful\n");
00019
00020 result = mysql_query (connection1, "create table user (user_pin INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(user_pin), name varchar(50), no_account varchar(50), balance varchar(50))");
00021
00022
00023
00024 result1 = mysql_query (connection1, "create table report (no_id int(10), user_pin int(30),transaction varchar(50),amount varchar(50),remark varchar(100),FOREIGN KEY (user_pin) REFERENCES user (user_pin))");
00025
00026 if (result==0 && result1==0)
00027 {
00028 printf ("Table created successfully.\n");
00029 }
00030 else
00031 {
00032 fprintf (stderr, "Could not create table as %d: %s\n",
00033 mysql_errno (connection1),
00034 mysql_error (connection1));
00035 mysql_close (connection1);
00036 exit(EXIT_FAILURE);
00037 }
00038
00039 mysql_close (connection1);
00040 }
00041 else
00042 {
00043 fprintf (stderr, "Connection failed\n");
00044 if (mysql_errno (connection1))
00045 {
00046 fprintf (stderr, "Connection error %d: %s\n",
00047 mysql_errno (connection1),
00048 mysql_error (connection1));
00049 }
00050 }
00051
00052 exit(EXIT_SUCCESS);
00053 return 0;
00054 }