crm/mysql.schema.sql at master · freesoftwarefactory/crm · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
CREATE TABLE IF NOT EXISTS `crm_contact` (
	`id` char(20) not null,
	`user_name` char(20) not null,
  	`creation_date` bigint(20) DEFAULT NULL,
  	`mod_date` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `crm_contact_rel` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
  	`creation_date` bigint(20) DEFAULT NULL,
  	`mod_date` bigint(20) DEFAULT NULL,
	`contact_id` char(20) not null,
	`target_id` char(20) not null,
	`relname` char(50),
	`meta` char(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `crm_contact_meta` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
  	`creation_date` bigint(20) DEFAULT NULL,
  	`mod_date` bigint(20) DEFAULT NULL,
	`contact_id` char(20) not null,
	`meta_name` char(50),
	`meta_value` char(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;