Do a information publishing function
Last Update:2017-02-28
Source: Internet
Author: User
PHP Code:--------------------------------------------------------------------------------
CREATE TABLE ' jb_administrators ' (
' Administratorsid ' int (a) unsigned not NULL auto_increment,
' UserID ' mediumint (6) unsigned not NULL default ' 0 ',
' Administratorsgroupid ' int (a) unsigned not NULL default ' 0 ',
' administratorsname ' varchar not NULL default ',
' Password ' varchar not NULL default ',
' Email ' varchar not NULL default ',
' ipaddress ' varchar not NULL default ',
' Isadministrators ' enum (' Y ', ' n ') not NULL default ' n ',
' Orderbyid ' int (a) unsigned not NULL default ' 0 ',
' CreateDate ' bigint unsigned not NULL default ' 0 ',
PRIMARY KEY (' Administratorsid ')
) Type=myisam auto_increment=2;
#
# Export the data in the table ' Jb_administrators '
#
INSERT into ' jb_administrators ' VALUES (1, 1, 1, ' sky ', ' sky ', ', ', ', ' n ', 0, 0);
# --------------------------------------------------------
#
# The structure of the table ' Jb_administratorsoption '
#
# Date Created: July 16, 2003 15:02
# Last modified: July 16, 2003 15:23
#
CREATE TABLE ' jb_administratorsoption ' (
' Administratorsoptionid ' int (8) not NULL auto_increment,
' UserID ' mediumint (6) unsigned not NULL default ' 0 ',
' optionfieldname ' varchar not NULL default ',
' Length ' tinyint (2) unsigned not NULL default ' 40 ',
' Rows ' tinyint (2) unsigned not NULL default ' 4 ',
' Types ' varchar not NULL default ',
' IsPublic ' enum (' Y ', ' n ') not NULL default ' Y ',
' Orderbyid ' int (8) unsigned not NULL default ' 0 ',
PRIMARY KEY (' Administratorsoptionid ')
) Type=myisam auto_increment=10;
#
# Export the data in the table ' Jb_administratorsoption '
#
INSERT into ' jb_administratorsoption ' VALUES (8, 1, ' 57777 ', M, ' text ', ' y ', 8);
INSERT into ' jb_administratorsoption ' VALUES (9, 1, ' contact telephone ', 0, ' text ', ' y ', 9);
# --------------------------------------------------------
#
# The structure of the table ' Jb_administratorsoptionlist '
#
# Date Created: July 16, 2003 20:25
# Last modified: July 16, 2003 20:25
#
CREATE TABLE ' Jb_administratorsoptionlist ' (
' Administratorsoptionlistid ' int (a) unsigned not NULL auto_increment,
' UserID ' mediumint (6) unsigned not NULL default ' 0 ',
' Administratorsid ' int (a) unsigned not NULL default ' 0 ',
' Administratorsoptionid ' int (8) unsigned not NULL default ' 0 ',
' Value ' text not NULL,
' createdate ' int unsigned not NULL default ' 0 ',
PRIMARY KEY (' Administratorsoptionlistid ')
) Type=myisam auto_increment=168;
#
# Export the data in the table ' Jb_administratorsoptionlist '
#