%{

#include "sqlscriptparser.tab.h"

%}

%option noyywrap

%%

[ ]*([Dd][Aa][Tt]|[Cc][Oo][Dd]|[Dd][Ee][Ss]|[Ii][Nn][Dd]|[Jj][Ss][Oo][Nn]|[Xx][Mm][Ll]|[Ii][Dd][Tt]|[Nn][Uu][Mm]|[Ff][Ll][Gg]|[Nn][Aa][Mm])\_[a-zA-Z0-9\_]+ { yylval.sval = strdup(yytext); return COLUMN;}

[Cc][Rr][Ee][Aa][Tt][Ee][ ]+[Tt][Aa][Bb][Ll][Ee] { yylval.sval = strdup(yytext); return CREATE_TABLE;}

[Cc][Rr][Ee][Aa][Tt][Ee][ ]+[Ii][Nn][Dd][Ee][Xx] { yylval.sval = strdup(yytext); return CREATE_INDEX;}

[Aa][Ll][Tt][Ee][Rr][ ]+[Tt][Aa][Bb][Ll][Ee] { yylval.sval = strdup(yytext); return ALTER_TABLE;}

[A-Za-z]+\_[Aa][Dd][Mm]\.[a-zA-Z\_0-9]+ { yylval.sval = strdup(yytext); return OWNER_OBJECT;}

[A-Za-z\_]+\_[Ff][Kk] { yylval.sval = strdup(yytext); return FK_NAME;}

[A-Za-z\_]+\_[Pp][Kk] { yylval.sval = strdup(yytext); return PK_NAME;}

[A-Za-z\_]+\_[Uu][Kk] { yylval.sval = strdup(yytext); return UK_NAME;}

[Ff][Oo][Rr][Ee][Ii][Gg][Nn][ ]+[Kk][Ee][Yy] { yylval.sval = strdup(yytext); return FK;}

[Pp][Rr][Ii][Mm][Aa][Rr][Yy][ ]+[Kk][Ee][Yy] { yylval.sval = strdup(yytext); return PK;}

[A-Za-z\_]+\_[Cc][Kk][0-9]* { yylval.sval = strdup(yytext); return CHECK_NAME;}

[ ]+[Cc][Hh][Ee][Cc][Kk][ ]* { yylval.sval = strdup(yytext); return CHECK;}

[Aa][Dd][Dd][ ]+[Cc][Oo][Nn][Ss][Tt][Rr][Aa][Ii][Nn][Tt] { yylval.sval = strdup(yytext); return ADD_CONSTRAINT;}

[Dd][Rr][Oo][Pp][ ]+[Cc][Oo][Nn][Ss][Tt][Rr][Aa][Ii][Nn][Tt] { yylval.sval = strdup(yytext); return DROP_CONSTRAINT;}

[Cc][Rr][Ee][Aa][Tt][Ee][ ]+[Ss][Ee][Qq][Uu][Ee][Nn][Cc][Ee] { yylval.sval = strdup(yytext); return CREATE_SEQUENCE;}

"\n" {return FIM_COMANDO;}

"(" /*ignore*/

")" {}

"/" {}

"'" {}

"-" {}

"_" {}

";" {}

"=" {}

":" {}

">" {}

"<" {}

"." {}

"*" {}

"," {}

"+" {}

"?" {}

[A-Z0-9a-záéíóúãõäëïöüçàèìòùÁÉÍÓÚÃÕÄËÏÖÜÇÀÈÌÒÙ\[\]\|]* /*ignore*/

%%