easychat/ext_tables.sql at develop · undkonsorten/easychat · 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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
#
# Table structure for table 'sys_reaction'
#
CREATE TABLE sys_reaction (
	easychat_configuration int(11) unsigned DEFAULT '0' NOT NULL,
);

create table tx_easychat_domain_model_session
(
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,

	messages longtext DEFAULT '' NOT NULL,
	session_id varchar(255) NOT NULL,

	tstamp int(11) unsigned DEFAULT '0' NOT NULL,
	crdate int(11) unsigned DEFAULT '0' NOT NULL,
	cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
	deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
	hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
	starttime int(11) unsigned DEFAULT '0' NOT NULL,
	endtime int(11) unsigned DEFAULT '0' NOT NULL,
	PRIMARY KEY (uid),
	KEY parent (pid),
);

CREATE TABLE tx_easychat_configuration (
		uid int(11) NOT NULL auto_increment,
		pid int(11) DEFAULT '0' NOT NULL,
		name varchar(255) DEFAULT '' NOT NULL,
		model varchar(255) DEFAULT '' NOT NULL,
		system_message longtext NOT NULL,
		url varchar(255) DEFAULT '' NOT NULL,
		api_key varchar(255) DEFAULT '' NOT NULL,
		vector_db varchar(255) DEFAULT '' NOT NULL,
		vector_db_host varchar(255) DEFAULT '' NOT NULL,
		vector_db_port varchar(255) DEFAULT '' NOT NULL,
		vector_db_name varchar(255) DEFAULT '' NOT NULL,
		vector_db_api_key varchar(255) DEFAULT '' NOT NULL,
		vector_db_embeddings_model varchar(255) DEFAULT '' NOT NULL,


		tstamp int(11) unsigned DEFAULT '0' NOT NULL,
		crdate int(11) unsigned DEFAULT '0' NOT NULL,
		cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
		deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
		hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
		starttime int(11) unsigned DEFAULT '0' NOT NULL,
		endtime int(11) unsigned DEFAULT '0' NOT NULL,

		PRIMARY KEY (uid),
		KEY parent (pid),

);