https://wiki.swganh.org/index.php?action=history&feed=atom&title=Character_xp_%28Database_Table%29 2026-05-05T07:28:17Z Revision history for this page on the wiki MediaWiki 1.26.4 https://wiki.swganh.org/index.php?title=Character_xp_(Database_Table)&diff=17863&oldid=prev 2007-09-30T18:13:07Z

<p>New page: {{PageHeader|Database Table|character_xp}} {| border=&quot;0&quot; width=&quot;90%&quot; cellpadding=6 |- |valign=top| ==Table Structure== {| align=&quot;center&quot; |- || {| class = &quot;wikitable&quot; |- align=&quot;center&quot; s...</p> <p><b>New page</b></p><div>{{PageHeader|Database Table|character_xp}}<br /> <br /> {| border=&quot;0&quot; width=&quot;90%&quot; cellpadding=6<br /> |-<br /> |valign=top|<br /> <br /> ==Table Structure==<br /> {| align=&quot;center&quot;<br /> |-<br /> ||<br /> {| class = &quot;wikitable&quot;<br /> |- align=&quot;center&quot; style=&quot;background-color:#ffffcc;&quot;<br /> ||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''<br /> |- align=&quot;center&quot; <br /> |align=&quot;center&quot;|id||int(10)||align=&quot;center&quot;|[[Image:Symbol OK.png|10px]]||align=&quot;center&quot;|[[Image:Symbol OK.png|10px]]|| ||[[Image:Symbol OK.png|10px]]|| ||ID<br /> |- align=&quot;center&quot; style=&quot;background-color:#F1F1F1;&quot;<br /> ||war||char(64)||align=&quot;center&quot;| ||align=&quot;center&quot;| || || || ||War Name<br /> |-<br /> |}<br /> |}<br /> <br /> |valign=top|<br /> <br /> == Related Tags ==<br /> {|align=&quot;center&quot;<br /> |-<br /> ||{{D100%}}<br /> |-<br /> ||{{Database}}<br /> |-<br /> ||{{DatabaseTable}}<br /> |-<br /> |}<br /> |}<br /> <br /> ==Table Create Script==<br /> &lt;pre&gt;<br /> CREATE TABLE `biography_wars` (<br /> `id` int(10) unsigned NOT NULL auto_increment,<br /> `war` char(64) NOT NULL,<br /> PRIMARY KEY (`id`)<br /> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;<br /> &lt;/pre&gt;<br /> <br /> ==Table Describe==<br /> &lt;pre&gt;<br /> mysql&gt; desc character_xp;<br /> +--------------+---------------------+------+-----+---------+-------+<br /> | Field | Type | Null | Key | Default | Extra |<br /> +--------------+---------------------+------+-----+---------+-------+<br /> | character_id | bigint(20) unsigned | NO | PRI | 0 | |<br /> | xp_id | int(11) unsigned | NO | PRI | 49 | |<br /> | value | int(10) | NO | | 0 | |<br /> +--------------+---------------------+------+-----+---------+-------+<br /> 3 rows in set (0.00 sec)<br /> <br /> &lt;/pre&gt;</div>

Snow