diff options
Diffstat (limited to '')
4 files changed, 81 insertions, 0 deletions
diff --git a/webmail/plugins/google_contacts/SQL/mssql.initial.sql b/webmail/plugins/google_contacts/SQL/mssql.initial.sql new file mode 100644 index 0000000..6dfb4b4 --- /dev/null +++ b/webmail/plugins/google_contacts/SQL/mssql.initial.sql @@ -0,0 +1,34 @@ +CREATE TABLE [dbo].[google_contacts] (
+ [contact_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [user_id] [int] NOT NULL ,
+ [changed] [datetime] NOT NULL ,
+ [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
+ [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
+ [email] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
+ [firstname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
+ [surname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
+ [vcard] [text] COLLATE Latin1_General_CI_AI NULL
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[google_contacts] WITH NOCHECK ADD
+ CONSTRAINT [PK_google_contacts_contact_id] PRIMARY KEY CLUSTERED
+ (
+ [contact_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[google_contacts] ADD
+ CONSTRAINT [DF_google_contacts_user_id] DEFAULT (0) FOR [user_id],
+ CONSTRAINT [DF_google_contacts_changed] DEFAULT (getdate()) FOR [changed],
+ CONSTRAINT [DF_google_contacts_del] DEFAULT ('0') FOR [del],
+ CONSTRAINT [DF_google_contacts_name] DEFAULT ('') FOR [name],
+ CONSTRAINT [DF_google_contacts_email] DEFAULT ('') FOR [email],
+ CONSTRAINT [DF_google_contacts_firstname] DEFAULT ('') FOR [firstname],
+ CONSTRAINT [DF_google_contacts_surname] DEFAULT ('') FOR [surname],
+ CONSTRAINT [CK_google_contacts_del] CHECK ([del] = '1' or [del] = '0')
+GO
+
+ CREATE INDEX [IX_google_contacts_user_id] ON [dbo].[google_contacts]([user_id]) ON [PRIMARY]
+GO
+
diff --git a/webmail/plugins/google_contacts/SQL/mysql.initial.sql b/webmail/plugins/google_contacts/SQL/mysql.initial.sql new file mode 100644 index 0000000..b57704c --- /dev/null +++ b/webmail/plugins/google_contacts/SQL/mysql.initial.sql @@ -0,0 +1,4 @@ +CREATE TABLE google_contacts LIKE contacts;
+
+ALTER TABLE `google_contacts`
+ ADD CONSTRAINT `google_contacts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
diff --git a/webmail/plugins/google_contacts/SQL/postgres.initial.sql b/webmail/plugins/google_contacts/SQL/postgres.initial.sql new file mode 100644 index 0000000..d8dee00 --- /dev/null +++ b/webmail/plugins/google_contacts/SQL/postgres.initial.sql @@ -0,0 +1,30 @@ +--
+-- Sequence "collected_contact_ids"
+-- Name: collected_contact_ids; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE collected_contact_ids
+ START WITH 1
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1;
+
+--
+-- Table "google_contacts"
+-- Name: google_contacts; Type: TABLE; Schema: public; Owner: postgres
+--
+
+CREATE TABLE google_contacts (
+ contact_id integer DEFAULT nextval('collected_contact_ids'::text) PRIMARY KEY,
+ user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+ changed timestamp with time zone DEFAULT now() NOT NULL,
+ del smallint DEFAULT 0 NOT NULL,
+ name character varying(128) DEFAULT ''::character varying NOT NULL,
+ email character varying(128) DEFAULT ''::character varying NOT NULL,
+ firstname character varying(128) DEFAULT ''::character varying NOT NULL,
+ surname character varying(128) DEFAULT ''::character varying NOT NULL,
+ vcard text
+);
+
+CREATE INDEX google_contacts_user_id_idx ON google_contacts (user_id);
diff --git a/webmail/plugins/google_contacts/SQL/sqlite.initial.sql b/webmail/plugins/google_contacts/SQL/sqlite.initial.sql new file mode 100644 index 0000000..e775a00 --- /dev/null +++ b/webmail/plugins/google_contacts/SQL/sqlite.initial.sql @@ -0,0 +1,13 @@ +CREATE TABLE google_contacts (
+ contact_id integer NOT NULL PRIMARY KEY,
+ user_id integer NOT NULL default '0',
+ changed datetime NOT NULL default '0000-00-00 00:00:00',
+ del tinyint NOT NULL default '0',
+ name varchar(128) NOT NULL default '',
+ email varchar(128) NOT NULL default '',
+ firstname varchar(128) NOT NULL default '',
+ surname varchar(128) NOT NULL default '',
+ vcard text NOT NULL default ''
+);
+
+CREATE INDEX ix_google_contacts_user_id ON google_contacts(user_id);
|