Shop basic information.
| Column | Type | Constraint | Description |
|---|---|---|---|
| username | TEXT | PRIMARY KEY | Username to login and also PRIMARY KEY of each db table. Unchangeable. |
| password | TEXT | NOT NULL | Password to login to administration page. |
| zip_code | TEXT | NOT NULL | Zip code. |
| tel | TEXT | NOT NULL | Telephone number. |
| fax | TEXT | FAX number. | |
| TEXT | NOT NULL | Mail address. | |
| url | TEXT | NOT NULL | Site URL. |
| salt | TEXT | NOT NULL | Salt to encrypt String. |
CREATE TABLE shop( username TEXT, password TEXT NOT NULL, zip_code TEXT NOT NULL, tel TEXT NOT NULL, fax TEXT, mail TEXT NOT NULL, url TEXT NOT NULL, PRIMARY KEY(username) );
Multilingualized name and abbreviated name of sxhop.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | INTEGER | PRIMARY KEY | Shop ID. (shop.username) |
| lang | TEXT | Language key. | |
| name | TEXT | NOT NULL | Name. |
| name_abbr | TEXT | NOT NULL | Abbreviated name. |
| signature | TEXT | Signature to attach end of mail. If NULL, nothing will be attached. |
CREATE TABLE shop_content(
shop TEXT,
lang TEXT,
name TEXT NOT NULL,
name_abbr TEXT NOT NULL,
signature TEXT,
PRIMARY KEY (shop, lang)
);