No to mess up too much in the early stage 'm suggesting a
few additions to tbl_company. Start of existing fields are
marked with /* START OF ORIGINAL FIELDS*/. I suppose Nigel
would be a code keeper(?) reposting modified structure?

At the same time I guess it would be very useful at this
stage of the game to decide what's being played here. Some
hotels also operate as spas, some spas have little do do
with how hotels operate. And then there are private clubs
which have a lot o do with spas but nothing to do with
hotels. Big mess.

So, are we doing a hotel manegement? spa? club? property
(yet another species)?

Or are we trying to do all of them, which would be huge
task, and if developped by a commercial company. I would
estimate the cost to be at about $10 million.


CREATE TABLE tbl_company (
int_company_gen INTEGER, /*many companies operate as
joint ventures*/
char_code CHAR(6) CHARACTER SET NONE NOT NULL,
int_outletgen INTEGER,
int_dateformat CHAR(1) CHARACTER SET NONE NOT NULL,?8
may be country specific*/
int_client_id_format VARCHAR(20),
char_autoclient_id CHAR(1) CHARACTER SET NONE, /*
Y,N*/
int_default_client_language_gen INTEGER, /* implies
LANGUAGES table*/
str_path_to_company_logo VARCHAR(252),
int_future_date_limit SMALLINT,
int_modified_by_gen INTEGER,
int_modified_date INTEGER,

int_defaultclientdiscountgen INTEGER,
int_default_membertype_gen INTEGER,
int_default_clienttype CHAR(1) CHARACTER SET
NONE,
int_default_client_status CHAR(1) CHARACTER SET
NONE,
int_default_client_acctstatus CHAR(1) CHARACTER SET
NONE,
int_default_client_poschrgpriv CHAR(1) CHARACTER SET
NONE,
int_default_client_languagegen INTEGER,
int_default_client_displayaddrgen INTEGER,
int_default_client_billtoaddrgen INTEGER,
int_default_client_pospaytypegen INTEGER,


str_name VARCHAR(60) NOT NULL,/* START OF ORIGINAL
FIELDS*/
str_address_1 VARCHAR(100),
str_address_2 VARCHAR(100),
str_billaddr VARCHAR(100), /* Billing Address */
str_delivaddr VARCHAR(100), /* Delivery Address */
str_postcode VARCHAR(6),
str_city VARCHAR(50),
str_state VARCHAR(50),
str_country VARCHAR(50),
str_phone VARCHAR(12),
str_fax VARCHAR(12),
str_web VARCHAR(30),
str_email VARCHAR(30),
PRIMARY KEY(str_name)
);


--- Nigel Weeks <nweeks@...> wrote:

>
> Righto, lunch is over. Here's what I've done:
> Anyone like to add/modify/delete?
>
> Nige.
>
>
>

_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com