Skip to content

Instantly share code, notes, and snippets.

@spacetime

spacetime/KStars UserDB

Created November 16, 2012 19:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save spacetime/4090232 to your computer and use it in GitHub Desktop.
Save spacetime/4090232 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
KStars UserDB
<?xml version="1.0" encoding="utf-8" ?>
<!-- SQL XML created by WWW SQL Designer, http://code.google.com/p/wwwsqldesigner/ -->
<!-- Active URL: file:///home/spacetime/Downloads/wwwsqldesigner-2.6/index.html -->
<sql>
<datatypes db="sqlite">
<group label="Affinity">
<type label="Text" default="" length="1" sql="TEXT" quote="'" color="rgb(255,200,200)"/>
<type label="Numeric" default="0" length="0" sql="NUMERIC" quote="" color="rgb(238,238,170)"/>
<type label="Integer" default="0" length="0" sql="INTEGER" quote="" color="rgb(238,238,170)"/>
<type label="Real" default="0" length="0" sql="REAL" quote="" color="rgb(238,238,170)"/>
<type label="None" default="" length="0" sql="NONE" quote="" color="rgb(200,255,200)"/>
</group>
</datatypes><table x="741" y="81" name="user">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="Name" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="Surname" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="Contact" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1306" y="406" name="telescope">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="Vendor" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Aperture" null="0" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<row name="Model" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Driver" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Type" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Focal Length" null="1" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1301" y="150" name="flags">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="RA" null="0" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<row name="Dec" null="0" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<row name="Icon" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="Label" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="Color" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Epoch" null="1" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="649" y="235" name="lens">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="Vendor" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="Model" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Factor" null="0" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="481" y="415" name="eyepiece">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="Vendor" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Model" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="FocalLength" null="0" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<row name="ApparentFOV" null="0" autoincrement="0">
<datatype>REAL</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1338" y="671" name="filter">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="Vendor" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Model" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Type" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Color" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1490" y="228" name="wishlist">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="Date" null="0" autoincrement="0">
<datatype>NUMERIC</datatype>
<default>NULL</default></row>
<row name="Type" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="UIUD" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="780" y="711" name="fov">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="name" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="color" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="sizeX" null="1" autoincrement="0">
<datatype>NUMERIC</datatype>
<default>NULL</default></row>
<row name="sizeY" null="1" autoincrement="0">
<datatype>NUMERIC</datatype>
<default>NULL</default></row>
<row name="shape" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1036" y="380" name="logentry">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="content" null="0" autoincrement="0">
<datatype>TEXT</datatype>
<default>'NULL'</default></row>
<row name="UIUD" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="DateTime" null="0" autoincrement="0">
<datatype>NUMERIC</datatype>
<default>NULL</default></row>
<row name="User" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="user" row="id" />
</row>
<row name="Location" null="1" autoincrement="0">
<datatype>TEXT</datatype>
<default>NULL</default></row>
<row name="Telescope" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="telescope" row="id" />
</row>
<row name="Filter" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="filter" row="id" />
</row>
<row name="lens" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="lens" row="id" />
</row>
<row name="Eyepiece" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="eyepiece" row="id" />
</row>
<row name="FOV" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="fov" row="id" />
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1033" y="106" name="colorscheme">
<row name="id" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
</sql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment