Attachment #6662 for bug #31860

View | Details | Raw Unified | Return to bug 31860
Collapse All | Expand All




  sieve int(10) NOT NULL default '1',
  smtpauth int(10) NOT NULL default '1',
  UNIQUE KEY username (username)
) engine=MariaDB;
# --------------------------------------------------------

#

  SID varchar(255) NOT NULL default '',
  home varchar(255) NOT NULL default '',
  PRIMARY KEY  (username)
) engine=MariaDB;
# --------------------------------------------------------

#

  `maxdisplay` int(4) NOT NULL default '15',
  `warnlevel` int(3) NOT NULL default '90',
  PRIMARY KEY  (username)
) engine=MariaDB;
# --------------------------------------------------------

#

  username varchar(50) NOT NULL default '',
  status int(11) NOT NULL default '1',
  PRIMARY KEY  (alias)
) engine=MariaDB;
# --------------------------------------------------------

#

  folders varchar(255) NOT NULL default '',
  PRIMARY KEY  (domain_name),
  UNIQUE KEY prefix (prefix)
) engine=MariaDB;
# --------------------------------------------------------

#

CREATE TABLE domainadmin (
  domain_name varchar(255) NOT NULL default '',
  adminuser varchar(255) NOT NULL default ''
) engine=MariaDB;
# --------------------------------------------------------

#

  search_id varchar(255) NOT NULL default '',
  search_sql text NOT NULL,
  perpage int(11) NOT NULL default '0',
  timestamp timestamp,
  PRIMARY KEY (search_id),
  KEY search_id (search_id)
) engine=MariaDB;
# --------------------------------------------------------

#

  username varchar(50) NOT NULL default '',
  status int(11) NOT NULL default '1',
  KEY alias (alias)
) engine=MariaDB;

CREATE TABLE log (
  id int(11) NOT NULL auto_increment,

  time datetime NOT NULL default '2000-00-00 00:00:00',
  pid varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) engine=MariaDB;

INSERT INTO adminuser (username, password) VALUES ('admin', ENCRYPT('test'));
INSERT INTO domainadmin (domain_name,adminuser) VALUES ('*','admin');

Return to bug 31860

Lines 24-30 Link Here

(-)/usr/share/doc/web-cyradm-0.5.5e1/scripts/create_mysql.sql (-11 / +11 lines)
24	sieve int(10) NOT NULL default '1',	24	sieve int(10) NOT NULL default '1',
25	smtpauth int(10) NOT NULL default '1',	25	smtpauth int(10) NOT NULL default '1',
26	UNIQUE KEY username (username)	26	UNIQUE KEY username (username)
27	) TYPE=MyISAM;	27	) engine=MariaDB;
28	# --------------------------------------------------------	28	# --------------------------------------------------------
29		29
30	#	30	#
Lines 38-44 Link Here
38	SID varchar(255) NOT NULL default '',	38	SID varchar(255) NOT NULL default '',
39	home varchar(255) NOT NULL default '',	39	home varchar(255) NOT NULL default '',
40	PRIMARY KEY (username)	40	PRIMARY KEY (username)
41	) TYPE=MyISAM;	41	) engine=MariaDB;
42	# --------------------------------------------------------	42	# --------------------------------------------------------
43		43
44	#	44	#
Lines 51-57 Link Here
51	`maxdisplay` int(4) NOT NULL default '15',	51	`maxdisplay` int(4) NOT NULL default '15',
52	`warnlevel` int(3) NOT NULL default '90',	52	`warnlevel` int(3) NOT NULL default '90',
53	PRIMARY KEY (username)	53	PRIMARY KEY (username)
54	) TYPE=MyISAM;	54	) engine=MariaDB;
55	# --------------------------------------------------------	55	# --------------------------------------------------------
56		56
57	#	57	#
Lines 64-70 Link Here
64	username varchar(50) NOT NULL default '',	64	username varchar(50) NOT NULL default '',
65	status int(11) NOT NULL default '1',	65	status int(11) NOT NULL default '1',
66	PRIMARY KEY (alias)	66	PRIMARY KEY (alias)
67	) TYPE=MyISAM;	67	) engine=MariaDB;
68	# --------------------------------------------------------	68	# --------------------------------------------------------
69		69
70	#	70	#
Lines 83-89 Link Here
83	folders varchar(255) NOT NULL default '',	83	folders varchar(255) NOT NULL default '',
84	PRIMARY KEY (domain_name),	84	PRIMARY KEY (domain_name),
85	UNIQUE KEY prefix (prefix)	85	UNIQUE KEY prefix (prefix)
86	) TYPE=MyISAM;	86	) engine=MariaDB;
87	# --------------------------------------------------------	87	# --------------------------------------------------------
88		88
89	#	89	#
Lines 93-99 Link Here
93	CREATE TABLE domainadmin (	93	CREATE TABLE domainadmin (
94	domain_name varchar(255) NOT NULL default '',	94	domain_name varchar(255) NOT NULL default '',
95	adminuser varchar(255) NOT NULL default ''	95	adminuser varchar(255) NOT NULL default ''
96	) TYPE=MyISAM;	96	) engine=MariaDB;
97	# --------------------------------------------------------	97	# --------------------------------------------------------
98		98
99	#	99	#
Lines 104-113 Link Here
104	search_id varchar(255) NOT NULL default '',	104	search_id varchar(255) NOT NULL default '',
105	search_sql text NOT NULL,	105	search_sql text NOT NULL,
106	perpage int(11) NOT NULL default '0',	106	perpage int(11) NOT NULL default '0',
107	timestamp timestamp(14) NOT NULL,	107	timestamp timestamp,
108	PRIMARY KEY (search_id),	108	PRIMARY KEY (search_id),
109	KEY search_id (search_id)	109	KEY search_id (search_id)
110	) TYPE=MyISAM;	110	) engine=MariaDB;
111	# --------------------------------------------------------	111	# --------------------------------------------------------
112		112
113	#	113	#
Lines 120-126 Link Here
120	username varchar(50) NOT NULL default '',	120	username varchar(50) NOT NULL default '',
121	status int(11) NOT NULL default '1',	121	status int(11) NOT NULL default '1',
122	KEY alias (alias)	122	KEY alias (alias)
123	) TYPE=MyISAM;	123	) engine=MariaDB;
124		124
125	CREATE TABLE log (	125	CREATE TABLE log (
126	id int(11) NOT NULL auto_increment,	126	id int(11) NOT NULL auto_increment,
Lines 130-136 Link Here
130	time datetime NOT NULL default '2000-00-00 00:00:00',	130	time datetime NOT NULL default '2000-00-00 00:00:00',
131	pid varchar(255) NOT NULL default '',	131	pid varchar(255) NOT NULL default '',
132	PRIMARY KEY (id)	132	PRIMARY KEY (id)
133	) TYPE=MyISAM;	133	) engine=MariaDB;
134		134
135	INSERT INTO adminuser (username, password) VALUES ('admin', ENCRYPT('test'));	135	INSERT INTO adminuser (username, password) VALUES ('admin', ENCRYPT('test'));
136	INSERT INTO domainadmin (domain_name,adminuser) VALUES ('*','admin');	136	INSERT INTO domainadmin (domain_name,adminuser) VALUES ('*','admin');