On Sat, 4 Aug 2018 21:40:53 -0400, Stephen Chrzanowski
<[email protected]> wrote:
> I'm making a small database for a game, and a bunch of the tables follow
> the same kind of naming convention due to normalization, like
>
> {Name_Of_Information}s
> {Name_Of_Information}ID as Integer
> {Name_Of_Information}Name as Char
>
> So for example:
>
> Resources
> ResourceID as Integer
> ResourceName as Integer
>
> (Plural name on the table name, singulars on the field names)
>
> Would there be a way within SQLite via CTE or whatever other magic there
> is, to create tables based on this structure, and setup the PK?
I guess would use good old m4 for that. Or awk.
[...]
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
