diff options
author | Mickaël Rémond <mickael.remond@process-one.net> | 2005-12-23 16:52:39 +0300 |
---|---|---|
committer | Mickaël Rémond <mickael.remond@process-one.net> | 2005-12-23 16:52:39 +0300 |
commit | 784edef4b6059f9376ab13956af81590f255bc26 (patch) | |
tree | cbe001a7755e0b990bab0052ddbc0b86a71b902a /src | |
parent | 254a8c1b60ab40bc3618e5d26440ff3f9df1f567 (diff) |
Added missing file.
SVN Revision: 480
Diffstat (limited to 'src')
-rw-r--r-- | src/odbc/mysql.sql | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql new file mode 100644 index 000000000..5390331fc --- /dev/null +++ b/src/odbc/mysql.sql @@ -0,0 +1,96 @@ +CREATE TABLE users ( + username varchar(250) PRIMARY KEY, + password text NOT NULL +); + + +CREATE TABLE last ( + username varchar(250) PRIMARY KEY, + seconds text NOT NULL, + state text +); + + +CREATE TABLE rosterusers ( + username varchar(250) NOT NULL, + jid varchar(250) NOT NULL, + nick text, + subscription character(1) NOT NULL, + ask character(1) NOT NULL, + server character(1) NOT NULL, + subscribe text, + type text +); + +CREATE UNIQUE INDEX i_rosteru_user_jid USING BTREE ON rosterusers(username, jid); +CREATE INDEX i_rosteru_username USING BTREE ON rosterusers(username); +CREATE INDEX i_rosteru_jid USING BTREE ON rosterusers(jid); + +CREATE TABLE rostergroups ( + username varchar(250) NOT NULL, + jid varchar(250) NOT NULL, + grp text NOT NULL +); + +CREATE INDEX pk_rosterg_user_jid USING BTREE ON rostergroups(username, jid); + +CREATE TABLE spool ( + username varchar(250) NOT NULL, + xml text, + seq SERIAL +); + +CREATE INDEX i_despool USING BTREE ON spool(username); + +CREATE TABLE vcard ( + username varchar(250) PRIMARY KEY, + vcard text NOT NULL +); + +CREATE TABLE vcard_search ( + username varchar(250) NOT NULL, + lusername varchar(250) PRIMARY KEY, + fn text NOT NULL, + lfn varchar(250) NOT NULL, + family text NOT NULL, + lfamily varchar(250) NOT NULL, + given text NOT NULL, + lgiven varchar(250) NOT NULL, + middle text NOT NULL, + lmiddle varchar(250) NOT NULL, + nickname text NOT NULL, + lnickname varchar(250) NOT NULL, + bday text NOT NULL, + lbday varchar(250) NOT NULL, + ctry text NOT NULL, + lctry varchar(250) NOT NULL, + locality text NOT NULL, + llocality varchar(250) NOT NULL, + email text NOT NULL, + lemail varchar(250) NOT NULL, + orgname text NOT NULL, + lorgname varchar(250) NOT NULL, + orgunit text NOT NULL, + lorgunit varchar(250) NOT NULL +); + +CREATE INDEX i_vcard_search_lfn ON vcard_search(lfn); +CREATE INDEX i_vcard_search_lfamily ON vcard_search(lfamily); +CREATE INDEX i_vcard_search_lgiven ON vcard_search(lgiven); +CREATE INDEX i_vcard_search_lmiddle ON vcard_search(lmiddle); +CREATE INDEX i_vcard_search_lnickname ON vcard_search(lnickname); +CREATE INDEX i_vcard_search_lbday ON vcard_search(lbday); +CREATE INDEX i_vcard_search_lctry ON vcard_search(lctry); +CREATE INDEX i_vcard_search_llocality ON vcard_search(llocality); +CREATE INDEX i_vcard_search_lemail ON vcard_search(lemail); +CREATE INDEX i_vcard_search_lorgname ON vcard_search(lorgname); +CREATE INDEX i_vcard_search_lorgunit ON vcard_search(lorgunit); + +-- Needs MySQL max with innodb back-end +ALTER TABLE users ENGINE = InnoDB; +ALTER TABLE rosterusers ENGINE = InnoDB; +ALTER TABLE rostergroups ENGINE = InnoDB; +ALTER TABLE last ENGINE = InnoDB; +ALTER TABLE vcard ENGINE = InnoDB; +ALTER TABLE vcard_search ENGINE = InnoDB; +ALTER TABLE spool ENGINE = InnoDB;
\ No newline at end of file |