Sha256: 1add6b83fcc955d456f419f91c9b82e3d83fe38764c44db0b19d441bcea1c073

Contents?: true

Size: 1.49 KB

Versions: 12

Compression:

Stored size: 1.49 KB

Contents

CREATE TABLE client_info (
 client_id VARCHAR(255) default NULL,
 session VARCHAR(255) default NULL,
 token VARCHAR(255) default NULL,
 token_sent BIGINT default 0,
 reset BIGINT default 0,
 port VARCHAR(10) default NULL,
 last_sync_success VARCHAR(100) default NULL);
CREATE TABLE object_values (
 source_id BIGINT default NULL,
 attrib varchar(255) default NULL,
 object varchar(255) default NULL,
 value varchar default NULL);
CREATE TABLE changed_values (
 source_id BIGINT default NULL,
 attrib varchar(255) default NULL,
 object varchar(255) default NULL,
 value varchar default NULL,
 attrib_type varchar(255) default NULL,
 update_type varchar(255) default NULL,
 sent BIGINT default 0);
CREATE TABLE sources (
 source_id BIGINT PRIMARY KEY,
 name VARCHAR(255) default NULL,
 token BIGINT default NULL,
 sync_priority BIGINT,
 partition VARCHAR(255),
 sync_type VARCHAR(255),
 metadata varchar default NULL, 
 last_updated BIGINT default 0,
 last_inserted_size BIGINT default 0,
 last_deleted_size BIGINT default 0,
 last_sync_duration BIGINT default 0,
 last_sync_success BIGINT default 0,
 backend_refresh_time BIGINT default 0,
 source_attribs varchar default NULL,
 schema varchar default NULL,
 schema_version varchar default NULL,
 associations varchar default NULL,
 blob_attribs varchar default NULL);
CREATE INDEX by_src_id on object_values (source_id);
CREATE UNIQUE INDEX by_src_object ON object_values (object, attrib, source_id);
CREATE INDEX by_src_value ON object_values (attrib, source_id, value);

Version data entries

12 entries across 12 versions & 1 rubygems

Version Path
rhodes-2.1.0 platform/shared/db/res/db/syncdb.schema
rhodes-2.0.3 res/build-tools/db/syncdb.schema
rhodes-2.0.2 res/build-tools/db/syncdb.schema
rhodes-2.0.0 res/build-tools/db/syncdb.schema
rhodes-2.0.0.rc2 res/build-tools/db/syncdb.schema
rhodes-2.0.0.rc1 res/build-tools/db/syncdb.schema
rhodes-2.0.0.beta11 res/build-tools/db/syncdb.schema
rhodes-2.0.0.beta10 res/build-tools/db/syncdb.schema
rhodes-2.0.0.beta7 res/build-tools/db/syncdb.schema
rhodes-2.0.0.beta6 res/build-tools/db/syncdb.schema
rhodes-2.0.0.beta4 res/build-tools/db/syncdb.schema
rhodes-2.0.0.beta3 res/build-tools/db/syncdb.schema