CREATE DATABASE IF NOT EXISTS `authpuppy` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use `authpuppy`;
-- ----------------------------
-- Table structure for job_user
-- ----------------------------

CREATE TABLE IF NOT EXISTS `portal_custom`(
  `id` int(11) not null primary key auto_increment,
  `groupname` varchar(64) DEFAULT '' ,
  `templatename` varchar(64) DEFAULT '' ,
  `title` varchar(64) DEFAULT '' ,
  `configs` varchar(2000) DEFAULT '' ,
  `state` varchar(64) DEFAULT '0' ,
  `status` varchar(64) DEFAULT '',
  `state_edit` varchar(64) DEFAULT '0',
  `state_template` varchar(64) DEFAULT '0'
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into portal_custom(groupname,templatename,title,configs,status,state_template) value('root','template','phonelogin','[{"title":"phonelogin","base":{"config":{"background":""},"type":{"logo":""},"headheight":{"headheight":{"name":"head height","type":"range","min":0,"max":100,"default":"0"}},"argue":{"argue":""},"configs":{"margin-left":{"name":"logo left","type":"range","min":0,"max":100,"default":0},"margin-top":{"name":"logo top","type":"range","min":0,"max":100,"default":0},"height":{"name":"logo height","type":"range","min":0,"max":1000,"default":"0"},"width":{"name":"logo width","type":"range","min":0,"max":1000,"default":"0"},"backgroundSize":{"default":100}},"config_b":{"height":{"name":"back height","type":"range","min":0,"max":1000,"default":"280"},"backgroundSize":{"default":100}}},"comps":[{"type":"phonelogin","config":{"text-one":"","text-two":"Mobile","text-three":"Security Code","text-four":"Connect","text-five":"get security code"},"configs":{"width":"100","color-one":"#A52A2A","color-two":"#4682B4","color-three":"#008000"}}]}]','1','1');
insert into portal_custom(groupname,templatename,title,configs,status,state_template) value('root','template','accountlogin','[{"title":"accountlogin","base":{"config":{"background":""},"type":{"logo":""},"headheight":{"headheight":{"name":"head height","type":"range","min":0,"max":100,"default":"0"}},"argue":{"argue":""},"configs":{"margin-left":{"name":"logo left","type":"range","min":0,"max":100,"default":0},"margin-top":{"name":"logo top","type":"range","min":0,"max":100,"default":0},"height":{"name":"logo height","type":"range","min":0,"max":1000,"default":"0"},"width":{"name":"logo width","type":"range","min":0,"max":1000,"default":"0"},"backgroundSize":{"default":100}},"config_b":{"height":{"name":"back height","type":"range","min":0,"max":1000,"default":"280"},"backgroundSize":{"default":100}}},"comps":[{"type":"accountlogin","config":{"text-one":"","text-two":"account","text-three":"password","text-four":"Connect"},"configs":{"width":"100","color-one":"#A52A2A","color-two":"#4682B4","color-three":"#008000"}}]}]','1','1');
insert into portal_custom(groupname,templatename,title,configs,status,state_template) value('root','template','onekey','[{"title":"onekey","base":{"config":{"background":""},"type":{"logo":""},"headheight":{"headheight":{"name":"head height","type":"range","min":0,"max":100,"default":"0"}},"argue":{"argue":""},"configs":{"margin-left":{"name":"logo left","type":"range","min":0,"max":100,"default":0},"margin-top":{"name":"logo top","type":"range","min":0,"max":100,"default":0},"height":{"name":"logo height","type":"range","min":0,"max":1000,"default":"0"},"width":{"name":"logo width","type":"range","min":0,"max":1000,"default":"0"},"backgroundSize":{"default":100}},"config_b":{"height":{"name":"back height","type":"range","min":0,"max":1000,"default":"280"},"backgroundSize":{"default":100}}},"comps":[{"type":"onekey","config":{"text-one":"","text-two":"Welcome to the free WIFI network","text-three":"Connect"},"configs":{"width":"88","color-one":"#A52A2A","color-two":"#4682B4","color-three":"#008000"}}]}]','1','1');
insert into portal_custom(groupname,templatename,title,configs,status,state_template) value('root','template','wechat','[{"title":"wechat","base":{"config":{"background":""},"type":{"logo":""},"headheight":{"headheight":{"name":"head height","type":"range","min":0,"max":100,"default":"0"}},"argue":{"argue":""},"configs":{"margin-left":{"name":"logo left","type":"range","min":0,"max":100,"default":"0"},"margin-top":{"name":"logo top","type":"range","min":0,"max":100,"default":"0"},"height":{"name":"logo height","type":"range","min":0,"max":1000,"default":"0"},"width":{"name":"logo width","type":"range","min":0,"max":1000,"default":"0"},"backgroundSize":{"default":100}},"config_b":{"height":{"name":"back height","type":"range","min":0,"max":1000,"default":"280"},"backgroundSize":{"default":100}}},"comps":[{"type":"wechat","config":{"text-one":"","text-two":"欢迎使用微信连Wi-Fi","text-three":"一键微信连Wi-Fi"},"configs":{"width":"100","color-one":"#A52A2A","color-two":"#4682B4","color-three":"#008000"}}]}]','1','1');
insert into portal_custom(groupname,templatename,title,configs,status,state_template) value('root','template','voucher','[{"title":"voucher","base":{"config":{"background":""},"type":{"logo":""},"headheight":{"headheight":{"name":"head height","type":"range","min":0,"max":100,"default":"0"}},"argue":{"argue":""},"configs":{"margin-left":{"name":"logo left","type":"range","min":0,"max":100,"default":"0"},"margin-top":{"name":"logo top","type":"range","min":0,"max":100,"default":"0"},"height":{"name":"logo height","type":"range","min":0,"max":1000,"default":"0"},"width":{"name":"logo width","type":"range","min":0,"max":1000,"default":"0"},"backgroundSize":{"default":100}},"config_b":{"height":{"name":"back height","type":"range","min":0,"max":1000,"default":"280"},"backgroundSize":{"default":100}}},"comps":[{"type":"voucher","config":{"text-one":"","text-two":"Please Input voucher","text-three":"Connect"},"configs":{"width":"100","color-one":"#A52A2A","color-two":"#000000","color-three":"#008000"}}]}]','1','1');
