Labs/Joey: Difference between revisions

Labs/Joey (view source)

Revision as of 18:28, 31 January 2007

1,969 bytes added , 31 January 2007

→‎Joey!

Dougt

Confirmed users

1,031

edits

@@ Line 22: / Line 22: @@
 === Joey Pieces ===
+Joey DB:
+* Scheme: [http://svn.mozilla.org/labs/joey/trunk/servers/db/tables.sql]
+What the tables look like:
+<pre>
+mysql> show tables;
++-------------------+
+| Tables_in_joey_db |
++-------------------+
+| upload            |
+| user              |
++-------------------+
+mysql> select * from user where id=1;
++----+-------+------------------------------------------+----------------+---------------------+--------------+--------+----------+
+| id | uname | pw                                       | email          | date_joined         | ip           | level  | isbanned |
++----+-------+------------------------------------------+----------------+---------------------+--------------+--------+----------+
+|  1 | dougt | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | dougt@meer.net | 2007-01-29 11:28:42 | 00.00.00.00 | Normal | no       |
++----+-------+------------------------------------------+----------------+---------------------+--------------+--------+----------+
+mysql> select * from upload where owner=1;
++------+-------+----------+------------+----------------------------------------------+------+----------------------------------+------+----------+-----------+---------------------+--------+
+| id   | owner | name     | type       | uri                                          | uuid | title                            | size | content  | thumbnail | date_created        | shared |
++------+-------+----------+------------+----------------------------------------------+------+----------------------------------+------+----------+-----------+---------------------+--------+
+| 7466 |     1 | Untitled | text/plain | aHR0cDovL3dpa2kubW96aWxsYS5vcmcvTWFpbl9QYWdl |      | TWFpbiBQYWdlIC0gTW96aWxsYVdpa2k= |    4 | TWFpbg== |           | 2007-01-31 14:45:14 | yes    |
++------+-------+----------+------------+----------------------------------------------+------+----------------------------------+------+----------+-----------+---------------------+--------+
+</pre>
 Firefox Addon