Evert Rol wrote:
And a slightly problematic part is sqlite, which doesn't allow you to ALTER tables (or at least not adding a column to a table); I use sqlite mainly for testing & developing, recreating it every time one of my model changes (the thing there that I found the most hassle is entering an admin login, email & pass; I cannot script that...).
It doesn't? sqlite> .schema products_product CREATE TABLE "products_product" ( "id" integer NOT NULL PRIMARY KEY, "code" varchar(32) NOT NULL UNIQUE, "product_line_id" integer NOT NULL, "name" varchar(128) NOT NULL, "charging_cycle" varchar(16) NOT NULL, "price" decimal NOT NULL, "active" bool NOT NULL, "active_from" datetime NULL, "active_to" datetime NULL );CREATE INDEX "products_product_product_line_id" ON "products_product" ("product_line_id");
sqlite> alter table products_product add column responsible_staff integer; sqlite> .schema products_product CREATE TABLE "products_product" ( "id" integer NOT NULL PRIMARY KEY, "code" varchar(32) NOT NULL UNIQUE, "product_line_id" integer NOT NULL, "name" varchar(128) NOT NULL, "charging_cycle" varchar(16) NOT NULL, "price" decimal NOT NULL, "active" bool NOT NULL, "active_from" datetime NULL, "active_to" datetime NULL , responsible_staff integer);CREATE INDEX "products_product_product_line_id" ON "products_product" ("product_line_id");
-- Darryl Ross Director AFOYI, "Information Technology Solutions" p 08 7127 1831 m 0400 206 443 f 08 8425 9607 e [EMAIL PROTECTED]
signature.asc
Description: OpenPGP digital signature