?? dump_postgresql.sql
字號:
\connect - postgresCREATE SEQUENCE "poll_comment_seq" start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;CREATE SEQUENCE "poll_index_seq" start 4 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;CREATE SEQUENCE "poll_templateset_seq" start 5 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;CREATE SEQUENCE "poll_data_seq" start 21 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;CREATE SEQUENCE "poll_templates_seq" start 29 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;CREATE TABLE "poll_config" ( "config_id" int2 NOT NULL, "base_gif" character varying(60) NOT NULL, "lang" character varying(20) NOT NULL, "title" character varying(60) NOT NULL, "vote_button" character varying(30) NOT NULL, "result_text" character varying(40) NOT NULL, "total_text" character varying(40) NOT NULL, "voted" character varying(40) NOT NULL, "send_com" character varying(40) NOT NULL, "img_height" int2 DEFAULT '0' NOT NULL, "img_length" int2 DEFAULT '0' NOT NULL, "table_width" character varying(6) NOT NULL, "bgcolor_tab" character varying(7) NOT NULL, "bgcolor_fr" character varying(7) NOT NULL, "font_face" character varying(70) NOT NULL, "font_color" character varying(7) NOT NULL, "type" character varying(10) DEFAULT '0' NOT NULL, "check_ip" int2 DEFAULT '0' NOT NULL, "lock_timeout" int4 DEFAULT '0' NOT NULL, "time_offset" character varying(5) DEFAULT '0' NOT NULL, "entry_pp" int2 DEFAULT '0' NOT NULL, "poll_version" character varying(5) DEFAULT '0' NOT NULL, "base_url" character varying(100) NOT NULL, "result_order" character varying(20) NOT NULL, "def_options" int2 DEFAULT '0' NOT NULL, "polls_pp" int2 DEFAULT '0' NOT NULL);CREATE TABLE "poll_index" ( "poll_id" int4 DEFAULT nextval('poll_index_seq'::text) NOT NULL, "question" character varying(100) NOT NULL, "timestamp" int4 DEFAULT '0' NOT NULL, "status" int2 DEFAULT '0' NOT NULL, "logging" int2 DEFAULT '0' NOT NULL, "exp_time" int4 DEFAULT '0' NOT NULL, "expire" int2 DEFAULT '0' NOT NULL, "comments" int2 DEFAULT '0' NOT NULL, PRIMARY KEY ("poll_id"));CREATE TABLE "poll_templates" ( "tpl_id" int4 DEFAULT nextval('poll_templates_seq'::text) NOT NULL, "tplset_id" int4 NOT NULL, "title" character varying(100) NOT NULL, "template" text NOT NULL, PRIMARY KEY ("tpl_id"));CREATE TABLE "poll_data" ( "id" int4 DEFAULT nextval('poll_data_seq'::text) NOT NULL, "poll_id" int4 NOT NULL, "option_id" int4 NOT NULL, "option_text" character varying(100) NOT NULL, "color" character varying(20) NOT NULL, "votes" int4 DEFAULT '0' NOT NULL, PRIMARY KEY ("id"));CREATE TABLE "poll_ip" ( "poll_id" int4 DEFAULT '0' NOT NULL, "ip_addr" character varying(15) DEFAULT '' NOT NULL, "timestamp" int4 DEFAULT '0' NOT NULL);CREATE TABLE "poll_comment" ( "com_id" int4 DEFAULT nextval('poll_comment_seq'::text) NOT NULL, "poll_id" int4 NOT NULL, "time" int4 NOT NULL, "host" character varying(70) NOT NULL, "browser" character varying(70) NOT NULL, "name" character varying(60) NOT NULL, "email" character varying(70) NOT NULL, "message" text NOT NULL, PRIMARY KEY ("com_id"));CREATE TABLE "poll_log" ( "poll_id" int4 DEFAULT '0' NOT NULL, "option_id" int4 DEFAULT '0' NOT NULL, "timestamp" int4 DEFAULT '0' NOT NULL, "ip_addr" character varying(15) NOT NULL, "host" character varying(70) NOT NULL, "agent" character varying(80) NOT NULL);CREATE TABLE "poll_user" ( "user_id" int2 NOT NULL, "username" character varying(30) NOT NULL, "userpass" character varying(32) NOT NULL, "session" character varying(32) NOT NULL, "last_visit" int4, PRIMARY KEY ("user_id"));CREATE TABLE "poll_templateset" ( "tplset_id" int4 DEFAULT nextval('poll_templateset_seq'::text) NOT NULL, "tplset_name" character varying(50) NOT NULL, "created" character varying(20), PRIMARY KEY ("tplset_id"));COPY "poll_config" FROM stdin;1 /pollphp/db/image english.php Advanced Poll Vote View results Total votes You have already voted! Send comment 10 42 170 #FFFFFF #666699 Verdana, Arial, Helvetica, sans-serif #000000 percent 0 2 0 5 2.0 /pollphp/db desc 10 12\.COPY "poll_index" FROM stdin;1 Which OS is your Website running on? 1018815036 1 1 1019679036 1 12 Which database engine do you prefer? 1018815086 1 0 1019679036 0 13 What is your favourite scripting language? 1018815086 1 0 1019679036 0 1\.COPY "poll_templates" FROM stdin;1 1 display_head <table width="$pollvars[table_width]" border="0" cellspacing="0" cellpadding="1" bgcolor="$pollvars[bgcolor_fr]">\ <tr align="center">\ <td><style type="text/css">\ <!--\ .input { font-family: $pollvars[font_face]; font-size: 8pt}\ -->\ </style><font face="$pollvars[font_face]" size="-1" color="#FFFFFF"><b>$pollvars[title]</b></font></td>\ </tr>\ <tr align="center">\ <td>\ <table width="100%" border="0" cellspacing="0" cellpadding="2" align="center" bgcolor="$pollvars[bgcolor_tab]">\ <tr>\ <td height="40" valign="middle"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><b>$question</b></font></td>\ </tr>\ <tr align="right" valign="top">\ <td>\ <form method="post" action="$this->form_forward">\ <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" height="190">\ <tr valign="top" align="center">\ <td>\ <table width="100%" border="0" cellspacing="0" cellpadding="1" align="center">\2 1 display_loop <tr>\ <td width="15%"><input type="radio" name="option_id" value="$data[option_id]"></td>\ <td width="85%"><font face="$pollvars[font_face]" size="1" color="$pollvars[font_color]">$data[option_text]</font></td>\</tr>\3 1 display_foot </table>\ <input type="hidden" name="action" value="vote">\ <input type="hidden" name="poll_ident" value="$poll_id">\ <input type="submit" value="$pollvars[vote_button]" class="input">\ <br><br>\ <font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><a href="$this->form_forward?action=results&poll_ident=$poll_id">$pollvars[result_text]</a><br><br><br></td>\ </tr>\</table>\</form>\ <font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font></td>\</tr>\</table>\</td>\</tr>\</table>\4 1 result_head <table width="$pollvars[table_width]" border="0" cellspacing="0" cellpadding="1" bgcolor="$pollvars[bgcolor_fr]">\<tr align="center">\<td>\<style type="text/css">\<!--\ .input { font-family: $pollvars[font_face]; font-size: 8pt}\ .links { font-family: $pollvars[font_face]; font-size: 7.5pt; color: $pollvars[font_color]}\-->\</style>\<font face="$pollvars[font_face]" size="-1" color="#FFFFFF"><b>$pollvars[title]</b></font></td>\</tr>\<tr align="center">\ <td><table width="100%" border="0" cellspacing="0" cellpadding="2" align="center" bgcolor="$pollvars[bgcolor_tab]">\ <tr valign="middle">\ <td height="40"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><b>$question</b></font></td>\ </tr>\ <tr align="right" valign="bottom">\ <td>\ <table border="0" cellspacing="0" cellpadding="1" width="100%" align="center" height="210">\ <tr valign="top">\ <td>\ <table width="100%" border="0" cellspacing="0" cellpadding="1" align="center">\ 5 1 result_loop <tr>\ <td height="22"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$option_text</font></td>\ <td nowrap height="22"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><img src="$pollvars[base_gif]/$poll_color.gif" width="$img_width" height="$pollvars[img_height]"> $vote_val</font></td>\</tr>\6 1 result_foot </table>\ <font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><br>\ $pollvars[total_text]: <font color="#CC0000">$total_votes</font><br>\ $VOTE<br><br><div align="center">\ $COMMENT </div></font>\ </td></tr>\ <tr><td height="32"> </td></tr>\ </table>\ <font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font></td>\ </tr>\ </table>\</td>\</tr>\</table>\7 1 comment <table border="0" cellspacing="0" cellpadding="1" align="center" bgcolor="#666699">\ <tr align="center">\ <td>\ <style type="text/css">\ <!--\ .button { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt}\ .textarea { font-family: "MS Sans Serif"; font-size: 9pt; width: 195px}\ .input { width: 195px}\ -->\ </style><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Send Your Comment</b></font></td>\ </tr>\ <tr>\ <td>\ <table border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#FFFFFF" width="200">\ <tr>\ <td width="149">\ <form method="post" action="$this->form_forward">\ <table border="0" cellspacing="0" cellpadding="2" bgcolor="" align="center">\ <tr>\ <td class="td1" height="40"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1">$question</font></b></td>\ </tr>\ <tr>\ <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Name:</font><br>\ <input type="text" name="name" maxlength="25" class="input" size="23">\ </td>\ </tr>\ <tr>\ <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">e-mail:</font><br>\ <input type="text" name="email" size="23" maxlength="50" class="input">\ </td>\ </tr>\ <tr>\ <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Comment(*):</font><br>\ <font face="MS Sans Serif" size="1">\ <textarea name="message" cols="19" wrap="VIRTUAL" rows="6" class="textarea"></textarea>\ </font>\ </td>\ </tr>\ <tr valign="top">\ <td>\ <input type="submit" value="Submit" class="button">\ <input type="reset" value="Reset" class="button">\ <input type="hidden" name="action" value="add">\ <input type="hidden" name="id" value="$poll_id">\ </td>\ </tr>\ </table>\ </form>\ </td>\ </tr>\ </table>\ </td>\ </tr>\</table>\8 2 display_head <table width="$pollvars[table_width]" cellspacing="0" cellpadding="0" border="0" bgcolor="#F3F3F3">\ <tr valign="top"> \ <td valign="top" align="right">\ <form method="post" action="$this->form_forward">\ <table width="100%" border="0" cellspacing="0" cellpadding="3">\ <tr bgcolor="$pollvars[bgcolor_fr]"> \ <td colspan="2" height="30"><font face="$pollvars[font_face]" color="#FFFFFF" size="1"><b>\ $question</b></font></td>\ </tr>\9 2 display_loop <tr> \ <td width="14%"><input type="radio" name="option_id" value="$data[option_id]"></td>\ <td width="86%"><font face="$pollvars[font_face]" size="1" color="$pollvars[font_color]">$data[option_text]</font></td>\</tr>\10 2 display_foot <tr align="center"> \ <td colspan="2"> \ <input type="image" border="0" src="$pollvars[base_gif]/vote.gif" width="110" height="48">\ <input type="hidden" name="action" value="vote">\ <input type="hidden" name="poll_ident" value="$poll_id">\ <br>\ <font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><a href="$this->form_forward?action=results&poll_ident=$poll_id">$pollvars[result_text]</a>\ </td>\ </tr>\ </table>\ </form>\ <font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font>\ </td>\ </tr>\</table>\11 2 result_head <table width="170" border="0" cellspacing="0" cellpadding="3" bgcolor="#F3F3F3">\ <tr> \ <td colspan="2" height="25" bgcolor="$pollvars[bgcolor_fr]"><font face="$pollvars[font_face]" color="#FFFFFF" size="1"><b>$question</b></font></td>\ </tr>\\12 2 result_loop <tr> \ <td colspan="2"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$option_text</font></td>\ </tr>\ <tr> \ <td width="52%"><img src="$pollvars[base_gif]/greenbar.gif" width="$img_width" height="7"></td>\ <td width="48%"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$vote_val</font></td>\ </tr>\13 2 result_foot <tr> \ <td colspan="2" height="40"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"> \ $pollvars[total_text]: <font color="#CC0000">$total_votes</font>\ <br>$VOTE</font><br><div align="center"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$COMMENT</font></div>\ </td>\ </tr>\ <tr align="right" valign="bottom" height="30"> \ <td colspan="2"><font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font></td>\ </tr>\</table>\14 2 comment <table border="0" cellspacing="0" cellpadding="1" align="center" bgcolor="#666699">\ <tr align="center">\ <td>\ <style type="text/css">\ <!--\ .button { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt}\ .textarea { font-family: "MS Sans Serif"; font-size: 9pt; width: 195px}\ .input { width: 195px}\ -->\ </style><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Send Your Comment</b></font></td>\ </tr>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -