nominal database structure

well, all this blogging is giving me an itchy coding finger so i am going to start with some core sql setup commands. The easiest part to start with is the nominal account table as it contains just the header files (assuming i keep it strictly normalised).

I am assuming you have a database ready and are logged in as a user of it. For now the coalition I will use is iso-8859-1 (latin1).

CREATE TABLE core_nom_accounts(id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, title VARCHAR(30) DEFAULT NULL)

There, that was fairly painless. The table structure isn't finished but it will do for now.