modules/collaborative_editor/collaborative_editor.mysql

-- @file
-- MySQL SQL file for collaborative_editor module
--
-- Creates all MySQL tables required for collaborative_editor module

-- store content duplicates to be updated by the asynchrounous calls
CREATE TABLE ce_content (
  cid int(10) NOT NULL default '0',
  rid int(20) unsigned NOT NULL default '0',
  title varchar(128) character set utf8 collate utf8_unicode_ci default NULL,
  body longtext character set utf8 collate utf8_unicode_ci,
  PRIMARY KEY  (cid),
  KEY rid (rid)
);

-- used to store pending changes
CREATE TABLE ce_pchanges (
  cid int(10) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0',
  pchange longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY cid (cid,uid)
);

-- active users
CREATE TABLE ce_users (
  uid int(10) unsigned NOT NULL default '0',
  cid int(10) unsigned NOT NULL default '0',
  checked int(10) unsigned NOT NULL default '0',
  refresh int(10) unsigned NOT NULL default '0',
  KEY uid (uid,cid)
);
1	-- @file
2	-- MySQL SQL file for collaborative_editor module
3	--
4	-- Creates all MySQL tables required for collaborative_editor module
5
6	-- store content duplicates to be updated by the asynchrounous calls
7	CREATE TABLE ce_content (
8	cid int(10) NOT NULL default '0',
9	rid int(20) unsigned NOT NULL default '0',
10	title varchar(128) character set utf8 collate utf8_unicode_ci default NULL,
11	body longtext character set utf8 collate utf8_unicode_ci,
12	PRIMARY KEY (cid),
13	KEY rid (rid)
14	);
15
16	-- used to store pending changes
17	CREATE TABLE ce_pchanges (
18	cid int(10) unsigned NOT NULL default '0',
19	pid int(10) unsigned NOT NULL auto_increment,
20	uid int(10) unsigned NOT NULL default '0',
21	pchange longtext character set utf8 collate utf8_unicode_ci NOT NULL,
22	timestamp int(11) NOT NULL default '0',
23	PRIMARY KEY (pid),
24	KEY cid (cid,uid)
25	);
26
27	-- active users
28	CREATE TABLE ce_users (
29	uid int(10) unsigned NOT NULL default '0',
30	cid int(10) unsigned NOT NULL default '0',
31	checked int(10) unsigned NOT NULL default '0',
32	refresh int(10) unsigned NOT NULL default '0',
33	KEY uid (uid,cid)
34	);