| Server IP : 157.230.181.24 / Your IP : 216.73.217.11 Web Server : Apache/2.4.58 (Ubuntu) System : Linux conductive 6.8.0-117-generic #117-Ubuntu SMP PREEMPT_DYNAMIC Tue May 5 19:26:24 UTC 2026 x86_64 User : ( 1000) PHP Version : 8.3.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/lib/ras/ |
Upload File : |
SQLite format 3 @ � q � � .� � k����� � � � Q
x � ����� � �usersusers CREAT�&�#tablefeedbagfeedbagCREATE TABLE feedbag
(
screenName VARCHAR(16),
groupID INTEGER,
itemID INTEGER,
classID INTEGER,
name TEXT,
attributes BLOB,
lastModified INTEGER, pdMode int DEFAULT 0,
UNIQUE (screenName, groupID, itemID)
))= indexsqlite_autoindex_users_1users��gtableusersusersCREATE TABLE users
(
identScreenName VARCHAR(16) PRIMARY KEY,
displayScreenName TEXT,
authKey TEXT,
strongMD5Pass TEXT,
weakMD5Pass TEXT,
confirmStatus BOOLEAN DEFAULT FALSE,
emailAddress VARCHAR(320) NOT NULL DEFAULT '',
regStatus INT NOT NULL DEFAULT 3,
isICQ BOOLEAN NOT NULL DEFAULT false,
aim_firstName TEXT NOT NULL DEFAULT '',
aim_lastName TEXT NOT NULL DEFAULT '',
aim_middleName TEXT NOT NULL DEFAULT '',
aim_maidenName TEXT NOT NULL DEFAULT '',
aim_country TEXT NOT NULL DEFAULT '',
aim_state TEXT NOT NULL DEFAULT '',
aim_city TEXT NOT NULL DEFAULT '',
aim_nickName TEXT NOT NULL DEFAULT '',
aim_zipCode TEXT NOT NULL DEFAULT '',
aim_address TEXT NOT NULL DEFAULT '',
aim_keyword1 INTEGER,
aim_keyword2 INTEGER,
aim_keyword3 INTEGER,
aim_keyword4 INTEGER,
aim_keyword5 INTEGER,
icq_affiliations_currentCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_curr 3G! indexsqlite_autoindex_aimKeyword_1aimKeyword�_!!� tableaimKeywordaimKeywordCREATE TABLE aimKeyword
(
id INTEGER PRIMARY KEY,
name TEXT NOT NULL UNIQUE,
parent INTEGER,
FOREIGN KEY (parent) REFERENCES aimKeywordCategory (id) ON DELETE CASCADE
)CW1 indexsqlite_autoindex_aimKeywordCategory_1aimKeywordCategory�11�KtableaimKeywordCategoryaimKeywordCategoryCREATE TABLE aimKeywordCategory
(
id INTEGER PRIMARY KEY,
name TEXT NOT NULL UNIQUE
)�V))�gtableofflineMessageofflineMessageCREATE TABLE offlineMessage
(
sender VARCHAR(16) NOT NULL,
recipient VARCHAR(16) NOT NULL,
message BLOB NOT NULL,
sent TIMESTAMP NOT NULL
)/C indexsqlite_autoindex_chatRoom_2chatRoom/C indexsqlite_autoindex_chatRoom_1chatRoom�E
�]tablechatRoomchatRoomCREATE TABLE chatRoom
(
cookie TEXT PRIMARY KEY,
exchange INTEGER,
name TEXT,
created TIMESTAMP,
creator TEXT,
UNIQUE (exchange, name)
) +E indexsqlite_autoindex_users_old_1us /
C indexsqlite_autoindex_bartItem_1bartItem c �tablebartItembartItem
CREATE TABLE bartItem
(
hash CHAR(16) PRIMARY KEY,
body BLOB
)-A indexsqlite_autoindex_profile_1profile o�5tableprofileprofileCREATE TABLE profile
(
screenName VARCHAR(16) PRIMARY KEY,
body TEXT
)-A indexsqlite_autoindex_feedbag_1feedbag ��L''�WtablebuddyListModebuddyListMode CREATE TABLE buddyListMode
(
screenName VARCHAR(16),
clientSidePDMode INTEGER DEFAULT 0,
useFeedbag BOOLEAN DEFAULT false,
PRIMARY KEY (screenName)
)9M' indexsqlite_autoindex_buddyListMode_1buddyListMode
m)/�indexversion_uniqueschema_migrationsCREATE UNIQUE INDEX version_unique ON schema_migrations (version)i//�tableschema_migrationsschema_migrationsCREATE TABLE schema_migrations (v /- [Z EE
� � !
� � !
� � M![+4-0-Chat 1Chat 12026-07-16 17:05:47.743447163 +0000 UTCconan0fthenight
� �
! 4-0-Chat 1
� &��� �U!���Z
�
�&
S �
� ~ L � � � T "
�
�
�
Y
, � � � c f��� 2 k + �conan0fthenightC Buddies B � >CFo�f�-�h��kn��L=��i��n���9U'��@;�����6�jLVƍ+yn��Z�jag�-%
+!conan0fthenightC yndamionelev jZ�� � �-'
+!conan0fthenightr dudesy7777 j`N�1&
+'conan0fthenightC ��conan0ftheday j`E 0#
+%conan0fthenightC ��shelliharsha jYE�-)
+!conan0fthenightC hdudesy7777 jag�E�2!
++conan0fthenightC V�alllipsofredred jYEU/
+#conan0fthenightC ��bearychairy jYEU,
+ conan0fthenightC �kddunn05 jYEU4
+-conan0fthenightC �@takethebreakdown jYEU+
+ conan0fthenightC L=peacful3 jYEU0
+'conan0fthenightC '�opentheharbor jYEU.
+!conan0fthenightC �+ralexa7403 jYEU2
+)conan0fthenightC ��teasememarissa jYEU1
+'conan0fthenightC �scenebarbieex jYEU0
+%conan0fthenightC �augustjacque jYEU,
+ conan0fthenightC ;�zandoodle jYEU1
+)conan0fthenightC iwoohookatieboo jYD\4
+-conan0fthenightC ��stephatthediscox jYD\,
+ conan0fthenightC jLteachanx3 jYD\1
+'conan0fthenightC �6gioiamichelle jYD\0
+'conan0fthenightC n�blondegrl2390 jYD\.
+!conan0fthenightC �ohtaylorrr jYD\
# <conan-
+ conan0fthenightr Family � j`N�3
+-conan0fthenightC f�xxxcoreblondexxx jYC8� 0#conan0fthenightC *�burnoutonme jYC82
++conan0fthenightC -�kookies4katelyn jYC83
++conan0fthenightC ��tricycleinskirt jYC81
+)conan0fthenightC 9Uleetlegirllush jYD\YC82
++conan0fthenightC Cconan0fthenight jY2�/
+%conan0fthenightC kncurraxhomieg jYC8X�W/
+%conan0fthenightC o�smarterchild jX�W,
+ conan0fthenightC magus5311 jX�W-
+!conan0fthenightC Fsoewaslike jX�W7
+
: conan0fthenightT� � � ���� � jX��2
+
0conan0fthenight,J � @D � cD jZ�)
+
$conan0fthenight
� C r ojX�@ ! conan0fthenightr Fami0(
+'conan0fthenightC Z�conan0ftheday j`P�+
+ !conan0fthenightoCo-Workers jX�@
& & ��s�Y?
/�n
�
� ���
��9% A �
IS
d�
� �
�
� & u�� [ +conan0fthenightC ��&+conan0fthenightC yn%+conan0fthenightr '+conan0fthenightC ��#+conan0fthenightC Z�(+conan0fthenightC V�!+conan0fthenightC �� +conan0fthenightC � +conan0fthenightC �@ +conan0fthenightC L= +conan0fthenightC '� +conan0fthenightC �++conan0fthenightC ��+conan0fthenightC �+conan0fthenightC �+conan0fthenightC ;�+conan0fthenightC i+conan0fthenightC ��+conan0fthenightC jL+conan0fthenightC �6+conan0fthenightC n�+conan0fthenightC �+conan0fthenightC 9U+conan0fthenightC f�+conan0fthenightC h)+conan0fthenightC -�
+conan0fthenightC kn +conan0fthenightC �� +conan0fthenightC C
+conan0fthenightC o� +conan0fthenightC +conan0fthenightC F+conan0fthenightT�+conan0fthenight,J+conan0fthenight+conan0fthenightr +conan0fthenightC + conan0fthenighto � o� n
b�Rt� �!bv�O�@��A��0�+� ��
�� 'conan0ftheday !damionelev !dudesy7777 %shelliharsha%radiofiction#bearychairy+alllipsofredred kddunn05-takethebreakdown peacful3'opentheharbor!ralexa7403)teasememarissa'scenebarbieex%augustjacque
zandoodle)woohookatieboo
teachanx3
-stephatthediscox !ohtaylorrr )leetlegirllush
'gioiamichelle 'blondegrl2390-xxxcoreblondexxx+tricycleinskirt+kookies4katelyn%curraxhomieg#burnoutonme!soewaslike magus5311
T �;
�
�
,
B
0
� �
; � �
�
~ � � ' � � �
m
� � r
�
Z
� b
G �U kddunn05H magu
�i magus5311y teac � peacful3 �K% shelliharsha �8 zandoodle �_' scenebarbieex �K' blondegrl2390
a % smarterchild
a peacful3
a % augustjacque
a -�J- xxxcoreblondexxx� )�]- stephatthediscoxC + ko�s) leetlegirllushy
# bearyc� # bearychairy �G% shelliharsha Y7) woohookatieboo Y"- stephatthediscox Y ' opentheharbor�t+ kookies4katelyn ��% augustjacque ��+ alllipsofredred�o! damionelev ��! dudesy7777 ��' gioiamichelle ��' blondegrl2390 ��# burnoutonme �� zandoodle ��! soewaslike
�c teachanx3
#*) teasememarissa
#% shelliharsha
# ma� % shelliharsha� ' scenebarbieex� '�2' opentheharbor1 '�J' blondegrl23908 ! damionelev8 �b- takethebreakdown ��) woohookatieboo ��+ tricycleinskirt ��) teasememarissa ��! soewaslike �� zandoodle
a\! soewaslike�=% shelliharsha
a�- stephatthediscox
ao' scenebarbieex
a[ kddunn05
a[' conan0ftheday
ak magus5311
a�! ralexa7403
a� peacful3�5+ kookies4katelyn
ap) leetlegirllush
a[! ohtaylorrr
ao% augustjacque
a�% curraxhomieg
a�' gioiamichelle
a�! dudesy7777
a�+ alllipsofredred
a�# burnoutonme
a�# bearychairy
ao% smarterch�})�) woohookatieboo� ) teasememarissa�}! ralexa7403 �| kddunn05�z' conan0ftheday�u! ohtaylorrr�p# bearychairy�o# burnoutonme
� %�% radiofiction�! soewaslike �{ peacful3�m! dudesy7777�l! damionelev
teacha� % smarterchild
� zandoodle�+ tricycleinskirt
�y magus5311 Q % radi�- xxxcoreblondexxx�~' scenebarbieex�v+ kookies4katelyn
@- takethebreakdown
a8- stephatthediscox
a!+ tricycleinskirt
a ) teasememarissa
a % shelliharsha
a �' scenebarbieex
a �' conan0ftheday
a �) leetlegirllush
a �' opentheharbor
a �+ kookies4katelyn
a �% augustjacque
a �% curraxhomieg
a �' gioiamichelle
a �
�
teachanx3�- takethebreakdown�- stephatthediscox�% shelliharsha�x) leetlegirllush�w' opentheharbor�t% augustjacque�s% curraxhomieg�r' gioiamichelle�q+ alllipsofredred�n' blondegrl2390
a - xxxcoreblondexxxlynegedy�
u kddunn05equey
� peacful3e3ygegue
� W'
��' blondegrl23�% radiofiction
� *- xxxcoreblond�4-
� teachanx3ildlyn !! dud��K' conan0fthedayyharrlle� �%��n' conan0ftheday� i) woohookatieboo� g+ tricycleinskirt� Q' conan0ftheday� =) woohookatieboo� (+ tricycleinskir�}% radiofictionglynsaox; |'
�4 t
�Z teachanx3; O zandoodl�0) teasememarissa; ;' scenebarbieex; '+ tricycleinskirt; ! dudesy7777ldsharcox �' sc��)+ kookies4katelyn�(% smarterchild� c% curraxhomieg P- stephatthediscox P' opentheharbor <! ohtaylorrr�- stephatthedis�[) teasememarissa + tricycleinskirtirt
g �:
j�
4
$ � W G !
H �
V � �
� �
8 � � �
� � � n �
$ � �
@ +kookies4katelyn/e� leet!ralexa7403/�� zand zandoodle/� 9�teasememarissa/� �)shelliharsha/� �*kddunn05/� �Imagus5311/� �Mpeacful3/� ��opentheharbor/� ��ohtaylorrr/� �vburnoutonme/{ J�dudesy7777/z J�blondegrl2390/y J�radiofiction/u {damionelev/Y
�+teachanx3/X
�=radiofiction/V
�Axxxcoreblondexxx/U
�+woohookatieboo/P
�gteasememarissa/N
�eshelliharsha/M
�fscenebarbieex/L
�Sconan0ftheday/I
�Skookies4katelyn/F
�)le+kookies4katelyn0� � a%augustjacque0�%curraxhomieg0�'gioiamichelle0�'blondegrl23900�!dudesy77770�!damionelev0� � tea)teasememarissa1 %shelliharsha0�'scenebarbieex0� magus53110�+kookies4katelyn0�!ohtaylorrr0�
5 za zandoodle1
peacful30�'conan0ftheday0�'opentheharbor0�#burnoutonme0�
�Uradiofiction0�
��xxxcoreblondexxx0�
�vtakethebreakdown0�
��soewaslike0�-stephatthediscox0�
��tricycleinskirt0�
��woohookatieboo0�
�vralexa74030�
��kddunn050�
�valllipsofredred0�
��damionelev0�
��teachanx30�
��smarterchild0�
��radiofiction0�
�ytakethebreakdown0�
�csoewaslike0�
�Salllipsofredred0�
�>teachanx30�
�/takethebreakdown0�
�stephatthediscox0�
�tricycleinskirt0�
��augustjacque0�
��curraxhomieg0�
��alllipsofredred0�
��teachanx30�
��takethebreakdown0�
��soewaslike0�
��stephatthediscox0�
�jtricycleinskirt0�
�Uwoohookatieboo0�
�Atakethebreakdown0j
�+ teachanx31
%smarterchild1 %radiofiction1-xxxcoreblondexxx1-takethebreakdown1-stephatthediscox1+tricycleinskirt1!soewaslike1)woohookatieboo1!ralexa74030�
kddunn050�)leetlegirllush0�+alllipsofredred0�#bearychairy0�
� !teachanx30�
� smarterchild0�2� � 9e �d 'n�U
� august+tricycleinskirt0
�n:�^�X d+alllipsofredred,�X Iconan0fth-takethebreak-takethebreakdown0
X stephatthediscox0 , d� +F �!soewaslike*F �ralexa7403)�F �xxxcoreblondexxx)�F �radiofiction)�-xxxcoreblondexxx*'F �smarterchild*&F sradiofiction*$%augustjacque, F Ncurraxhomieg, F <alllipsofredred, +alllipsofredred,�F burnoutonme,�
ja
.Z peacful3~�d
R
�)teasememariss)teasememarissa� pscenebarbieex� 'gioiamichelleV Gblondegrl2390U 'conan0ftheday� magus-takethebreakdown&�8�d _A�d �
� � Chat 1
� K:�� X 7� � {� � " �k G � �
"K ^ <
�
� �
�
�
D
j � )= indexsqlite_autoindex_users_1users��gtableusersusersCREATE TABLE users
(
identScreenName VARCHAR(16) PRIMARY KEY,
displayScreenName TEXT,
authKey TEXT,
strongMD5Pass TEXT,
weakMD5Pass TEXT,
confirmStatus BOOLEAN DEFAULT FALSE,
#+bearychairyconan0fthenight�� smarterchildconan0fthenig!%+radiofictionconan0fthenight�T Bxxxcoreblondexxxconan0fthenight�T teasememarissaconan0fth!%+shelliharshaconan0fthenight�� +scenebarbieexconan0fthenight�� oht !+ohtaylorrrconan0fthenight� gioiamichel"'+gioiamichelleconan0fthenight � �alllipsofredredconan0fthenight � �bearychairyconan0fthenight � �burnoutonmeconan0fthenight � �blondegrl2390conan0fthenight� rxxxcorebl #+burnoutonmeconan0fthenight9 ��dudesy7777conan0fthenight8 ��blondegrl2390conan0fthenight7 ��damionelevconan0fthenight6 ��teachanx3conan0fthenight5 ��smarterchildconan0fthenight4 ��radiofictionconan0fthenight3 ��xxxcoreblondexxxconan0fthenight2 ��zandoodleconan0fthenight1 ��takethebreakdownconan0fthenight0 �1soewaslikeconan0fthenight/ �5stephatthediscoxconan0fthenight. �tricycleinskirtconan0fthenight- � woohookatiebooconan0fthenight, ��teasememarissaconan0fthenight+ ��shelliharshaconan0fthenight* ��scenebarbieexconan0fthenight) ��kddunn05conan0f#)+leetlegirllushconan0fthenight z Jkookies4katelynconan0fthenight z"'+opentheharborconan0fthenight% � Aaugustjacqueconan0fthenight !+ohtaylorrrconan0fthenightA � !+ralexa7403conan0fthenightd +magus5311conan0fthenighta!%+augustjacqueconan0fthenight\!%+curraxhomiegconan0fthenight["'+gioiamichelleconan0fthenightZ$++alllipsofredredconan0fthenightY #+bearychairyconan0fthenightX #+burnoutonmeconan0fthenightW"'+blondegrl2390conan0fthenightV !+dudesy7777conan0fthenightU !+damionelevconan0fthenightT � &teachanx3conan0fthenightS � jsm +teachanx3conan0fthenightp!%+smarterchildconan0fthenighto!%+radiofictionconan0fthenightn%-+xxxcoreblondexxxconan0fthenightm +zandoodleconan0fthenightl%-+takethebreakdownconan0fthenightk$++tricycleinskirtconan0fthenightj !+soewaslikeconan0fthenighti#)+woohookatiebooconan0fthenighth#)+teasememarissaconan0fthenightg!%+shelliharshaconan0fthenightf"'+scenebarbieexconan0fthenighte +kddunn05conan0fthenightc +peacful3conan0fthenightb �t � � kddunn05conan0fthenightr
t�
teachanx3conan0fthenight}5(�t � k ralexa7403cona##"'$++kookies4katelynconan0fthenight^ !+ohtaylorrrconan0fthenight]t �n � :peacful3conan0"%"#)+leetlegirllushconan0fthenigh#)+leetlegirllushconan0fthenight`"'+opentheharborconan0fthenight_tH;�t
��
e `peacful3conan0ft%-+xx!%+radiofictionconan0fthenigh$++tricycleinskirtconan0fthenight(n I�t�tt_Dope � !+soe%$++alllipsofredredconan0fthenight� �xxxcoreblondexxxconan0fthenight� �tricycleinskirtconan0fthenight� �woohookatiebooconan0fthenight� �scen !+ralexa7403conan0fthenight� �curraxhomiegconan0fthenight� �alllipsofredredconan0fthenight� {dudesy7777conan0fthenight� [damionelevconan0fthenight� ;radiofictionconan0fthenight� tricycleinskirtconan0fthenight� �curraxhomiegconan0fthenight� �alllipsofredredconan0fthenight� �dudesy7777conan0fthenight� �damionelevconan0fthenight�$++kookies4katelynconan0fthenightO Haugustjacqueconan0fthenightN &t !+ralexa7403conan0fthenightdx+t�3��t �
� <�pK ���qM)&���yT0
� \ 5
�
�
�
�
|� �v!+ soewaslikeconan0fthenightR #+ be �~!+ dudesy7777conan0fthenightq %+ %�-+ xxxcoreblondexxxconan0fthenight�
'+ s!�,%+ shelliharshaconan0fthenight� 4'+ scenebarbieexconan0fthenight� !+ ralexa �G!+ ralexa7403conan0fthenight� % + kddunn05conan0fthenight� �a + magus5311conan0fthenight �]!+ ohtaylorrrconan0fthenight"�V'+ blondegrl2390conan0fthenight �U!+ dudesy7777conan0fthenight �T!+ damionelevconan0fthenight ' + zandoo �l + zandoodleconan0fthenight#�h)+ woohookatiebooconan0fthenight#�g)+ teasememarissaconan0fthenight!�f%+ shelliharshaconan0fthenight"�e'+ scenebarbieexconan0fthenight �d!+ ralexa7403conan0fthenight �c + kddunn05conan0fthenight �b + peacful3conan0fthenight#�`)+ leetlegirllushconan0fthenight"�_'+ opentheharborconan0fthenight$�^++ kookies4katelynconan0fthenight!�\%+ augustjacqueconan0fthenight!�[%+ curraxhomiegconan0fthenight"�Z'+ gioiamichelleconan0fthenight$�Y++ alllipsofredredconan0fthenight �X#+ bearychairyconan0fthenight �W#+ burnoutonmeconan0fthenight �U + teachanx3conan0fthenight ��%+ smarterchildconan0fthenight ��%+ radiofictionconan0fthenight �}-+ xxxcoreblondexxxconan0fthenight �U-+ takethebreakdownconan0fthenight ��-+ stephatthediscoxconan0fthenight �v++ tricycleinskirtconan0fthenight �O)+ woohookatiebooconan0fthenight �))+ teasememarissaconan0fthenight �p + teachanx3conan0fthenight!�o%+ smarterchildconan0fthenight!�n%+ radiofictionconan0fthenight%�m-+ xxxcoreblondexxxconan0fthenight%�k-+ takethebreakdownconan0fthenight$�j++ tricycleinskirtconan0fthenight �i!+ soewaslikeconan0fthenighthtght � + peacful3conan0fthenighttght+ � "!+ damionelevconan0fthenightttght 6 c!+ ralexa7403%�M-+ takethebreakdownconan0fthenight%�i-+ takethebreakdownconan0fthenightghth � �'+ gioiamiche$#$�-$!�%+ augustjacqueconan0fthe%�$-+ takethebreakdownconan0fthenig%�!�>%+ augustjacqueconan0fthenightghtghtttghtt
> g!+ ohtaylorrrconan0##�))+ woohookatiebooconan0fthenight
> '++ tricycleinskirtconan0fthenightthttghttghtt+ � + $�/++ tricycleinskirtconan0fthenight ^)+ woohookatiebooconan0fthenight 8'+ scenebarbieexconan0fthenight#�+)+ teasememarissaconan0fthenight �-+ stephatthediscoxconan0fthenight �%+ curraxhomiegconan0fthenight �-+ xxxcoreblondexxxconan0fthenight �%+ smarterchildconan0fthenight }%+ radiofictionconan0fthenight Y++ tricycleinskirtconan0fthenight 2-+ stephatthediscoxconan0fthenight%�-+ takethebreakdownconan0fth!�e%+ radiofictionconan0fthenight �++ tricycleinskirtconan0fthenight �-+ xxxcoreblondexxxconan0fthenight u++ tricycleinskirtconan0fthenight N)+ woohookatiebooconan0fthenight%�+-+ xxxcoreblondexxxconan0fthenightttghtthttghttt
� q�
@ �
� � 8u��8��<}� � > �8_!!U,,
ralexa7403ralexa740349185fc3-ba28-449c-9908-35e47116c086��Dݼw?���Q�/�r˖n��Gӎ=i����@_))U,,
teasememarissateasememarissa49dd6e7c-28a9-4272-879c-77c797140a26��ɞ���b�Y�.Q�� �N�ַ���ێ��Mc�>_''U,,
scenebarbieexscenebarbieexc746a1a2-1ceb-4530-8350-cf36472332b9]QP�ז��4�� ��D�`��>y��SUM��<_%%U,,
augustjacqueaugustjacquec70e0741-1bac-4b3b-a5c3-5ff56462f932�5��/����O��X��ns�L�1p%����6_ U,,
zandoodlezandoodlec8684ff8-f06e-4174-8560-05c5c61cd3f9�?�S�ή"����0
�/��U��/�ޅ�@_))U,,
woohookatieboowoohookatieboo17e93d2c-75c8-466a-a200-3ceb5a2cabacR��S���|Q��RZ���i��d�RZ����D_--U,,
stephatthediscoxstephatthediscox69a37f7d-a09d-410d-9318-c49c8ce08b39"x�X��sW�}؇�G ����^�r]�N�m��6_ U,,
teachanx3teachanx36f8fc63a-941a-4361-9de2-8cd5661ad2be*?��v�M��i�*�� T�^~�&���/�祆j�>
_''U,,
gioiamichellegioiamichelle46d9ed34-e9d3-49cf-9b43-358d48485c65�VU�-��x�m �~�M�g$:�vi80�I _}�> _''U,,
blondegrl2390blondegrl2390fc336322-27fa-406e-b70c-056dad13aca6��� �O��tZ��ZM/]����)�C��-5՜v�8 _!!U,,
ohtaylorrrohtaylorrr40ae5e2b-6f5c-4974-aa00-33be6142ca8f���*�L�/pc�L���ЯǨ��ڃT��s�@
_))U,,
leetlegirllushleetlegirllush2409f74c-f1ce-4888-ae3e-bd43cc7851a0,�0�K�$(���̐�S{II5��-�-�پ}�D _--U,,
xxxcoreblondexxxxxxcoreblondexxx1531b55c-c745-43b6-b9e3-2dbf4448be71L)����CN���@�*��W��=u��H7���7:�:_##U,,
burnoutonmeburnoutonme56d17eb2-d89b-4471-86c3-9fa43b1eeee8L�>��C�O��Y��vb<1ų��3�3��B_++U,,
kookies4katelynkookies4katelyn5032a738-bb81-4149-af4b-af37b8aaf64f��y=o.� /!^���r�n�d��1?����<_%%U,,
curraxhomiegcurraxhomieg26898322-dede-4271-ab13-65d26657a812�ԃB3�W� ���6�x�Q4N��Mj+�bj�6�B_++U,,
tricycleinskirttricycleinskirt342a7ebf-c680-4cc0-9a39-c2a09ddddda5 9-:�*1 [c�fb�er��3��^p%>�;_!'U,,
soewaslikeso E was like0a4806de-7fe1-44d2-a3ff-f7c6789574c0 c���{��M ۩yd�u`�Z�K��-�qe��"�6_ U,,
magus5311magus5311ddbdf1b0-27ee-4321-9975-4d512f32df86Q`�����w��݅Wm��b��_v
:qL2�<_%%U,,
smarterchildSmarterChildcb7aabc4-e5e1-4ec6-93dc-10abd79304e6w,�o
��a���}��H��|U���`ra��B_++U,,
conan0fthenightconan0fthenighteae100e6-5ff4-4923-8753-4d58095cbbd9�+����)���A���a�c���oq p
� � -v
���
�
�Q�N�?�s@��/���^
���a� 'conan0ftheday !damionelev !dudesy7777 +alllipsofredred #bearychairy %shelliharsha%radiofiction kddunn05-takethebreakdown peacful3'opentheharbor!ralexa7403)teasememarissa'scenebarbieex%augustjacque
zandoodle)woohookatieboo-stephatthediscox
teachanx3'gioiamichelle
'blondegrl2390 !ohtaylorrr )leetlegirllush
-xxxcoreblondexxx #burnoutonme+kookies4katelyn%curraxhomieg+tricycleinskirt!soewaslike
magus5311%smarterchild+ conan0fthenight
'',
icq_affiliations_currentKeyword3 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode3 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword2 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword3 TEXT NOT NULL DEFAULT '',
icq_basicInfo_address TEXT NOT NULL DEFAULT '',
icq_basicInfo_cellPhone TEXT NOT NULL DEFAULT '',
icq_basicInfo_city TEXT NOT NULL DEFAULT '',
icq_basicInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_emailAddress TEXT NOT NULL DEFAULT '',
icq_basicInfo_fax TEXT NOT NULL DEFAULT '',
icq_basicInfo_firstName TEXT NOT NULL DEFAULT '',
icq_basicInfo_gmtOffset INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_lastName TEXT NOT NULL DEFAULT '',
icq_basicInfo_nickName TEXT NOT NULL DEFAULT '',
icq_basicInfo_phone TEXT NOT NULL DEFAULT '',
icq_basicInfo_publishEmail BOOLEAN NOT NULL DEFAULT false,
icq_basicInfo_state TEXT NOT NULL DEFAULT '',
icq_basicInfo_zipCode TEXT NOT NULL DEFAULT '',
icq_interests_code1 INTEGER NOT NULL DEFAULT 0,
icq_interests_code2 INTEGER NOT NULL DEFAULT 0,
icq_interests_code3 INTEGER NOT NULL DEFAULT 0,
icq_interests_code4 INTEGER NOT NULL DEFAULT 0,
icq_interests_keyword1 TEXT NOT NULL DEFAULT '',
icq_interests_keyword2 TEXT NOT NULL DEFAULT '',
icq_interests_keyword3 TEXT NOT NULL DEFAULT '',
icq_interests_keyword4 TEXT NOT NULL DEFAULT '',
icq_moreInfo_birthDay INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthMonth INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthYear INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_gender INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_homePageAddr TEXT NOT NULL DEFAULT '',
icq_moreInfo_lang1 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang2 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang3 INTEGER NOT NULL DEFAULT 0,
icq_notes TEXT NOT NULL DEFAULT '',
icq_permissions_authRequired BOOLEAN NOT NULL DEFAULT false,
icq_workInfo_address TEXT NOT NULL DEFAULT '',
icq_workInfo_city TEXT NOT NULL DEFAULT '',
icq_workInfo_company TEXT NOT NULL DEFAULT '',
icq_workInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_department TEXT NOT NULL DEFAULT '',
icq_workInfo_fax TEXT NOT NULL DEFAULT '',
icq_workInfo_occupationCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_phone TEXT NOT NULL DEFAULT '',
icq_workInfo_position TEXT NOT NULL DEFAULT '',
icq_workInfo_state TEXT NOT NULL DEFAULT '',
icq_workInfo_webPage TEXT NOT NULL DEFAULT '',
icq_workInfo_zipCode TEXT NOT NULL DEFAULT '', tocConfig TEXT NOT NULL DEFAULT '', suspendedStatus int NOT NULL DEFAULT 0, isBot BOOLEAN NOT NULL DEFAULT false, lastWarnUpdate DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00',
FOREIGN KEY (aim_keyword1) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword2) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword3) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword4) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword5) REFERENCES aimKeyword (id)
)
� �&��
O�A
H
� S ,
� 1 �>�[tableusersusersCREATE TABLE users
(
identScreenName VARCHAR(16) PRIMARY KEY,
displayScreenName TEXT,
authKey TEXT,
strongMD5Pass TEXT,
weakMD5Pass TEXT,
confirmStatus BOOLEAN DEFAULT FALSE,
emailAddress VARCHAR(320) NOT NULL DEFAULT '',
regStatus INT NOT NULL DEFAULT 3,
isICQ BOOLEAN NOT NULL DEFAULT false,
aim_firstName TEXT NOT NULL DEFAULT '',
aim_lastName TEXT NOT NULL DEFAULT '',
aim_middleName TEXT NOT NULL DEFAULT '',
aim_maidenName TEXT NOT NULL DEFAULT '',
aim_country TEXT NOT NULL DEFAULT '',
aim_state TEXT NOT NULL DEFAULT '',
aim_city TEXT NOT NULL DEFAULT '',
aim_nickName TEXT NOT NULL DEFAULT '',
aim_zipCode TEXT NOT NULL DEFAULT '',
aim_address TEXT NOT NULL DEFAULT '',
aim_keyword1 INTEGER,
aim_keyword2 INTEGER,
aim_keyword3 INTEGER,
aim_keyword4 INTEGER,
aim_keyword5 INTEGER,
icq_affiliations_currentCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentCode3 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_currentKeyword2 TEXT NOT NULL DEFAULT '',
icq_affiliations_currentKeyword3 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode3 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeywor k�R�{tablefeedbagfeedbagCREATE TABLE feedbag
(
screenName VARCHAR(16),
groupID INTEGER,
itemID INTEGER,
classID INTEGER,
name TEXT,
attributes BLOB,
lastModified INTEGER, pdMode int DEFAULT 0, authPending BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE (screenName, groupID, itemID)
)�%�!tableprofileprofileCREATE TABLE profile
(
screenName VARCHAR(16) PRIMARY KEY,
body TEXT
, mimeType TEXT, updateTime INTEGER NOT NULL DEFAULT 0)3G! indexsqlite_autoindex_aimKeyword_1aimKeyword�_!!� tableaimKeywordaimKeywordCREATE TABLE aimKeyword
(
id INTEGER PRIMARY KEY,
name TEXT NOT NULL UNIQUE,
parent INTEGER,
FOREIGN KEY (parent) REFERENCES aimKeywordCategory (id) ON DELETE CASCADE
)CW1 indexsqlite_autoindex_aimKeywordCategory_1aimKeywordCategory�11�KtableaimKeywordCategoryaimKeywordCategoryCREATE TABLE aimKeywordCategory
(
id INTEGER PRIMARY KEY,
name TEXT NOT NULL UNIQUE
)/C indexsqlite_autoindex_chatRoom_2chatRoom/C indexsqlite_autoindex_chatRoom_1chatRoom�E
�]tablechatRoomchatRoomCREATE TABLE chatRoom
(
cookie TEXT PRIMARY KEY,
exchange INTEGER,
name TEXT,
created TIMESTAMP,
creator TEXT,
UNIQUE (exchange, name)
)/
C indexsqlite_autoindex_bartItem_1bartItem � �[tablebartItembartItem
CREATE TABLE bartItem
(
hash CHAR(16) PRIMARY KEY,
body BLOB
, type INTEGER NOT NULL DEFAULT 0)-A indexsqlite_autoindex_profile_1profile -A indexsqlite_autoindex_feedbag_1feedbagm)/�indexversion_uniqueschema_migrationsCREATE UNIQUE INDEX version_unique ON schema_migrations (version)i//�tableschema_migrationsschema_migrationsCREATE TABLE schema_migrations (version uint64,dirty bool)
, ,��
�
� � d � e �.�;tableusersusersCREATE TABLE users
(
identScreenName VARCHAR(16) PRIMARY KEY,
displayScreenName TEXT,
authKey TEXT,
strongMD5Pass TEXT,
weakMD5Pass TEXT,
confirmStatus BOOLEAN DEFAULT FALSE,
emailAddress VARCHAR(320) NOT NULL DEFAULT '',
regStatus INT NOT NULL DEFAULT 3,
isICQ BOOLEAN NOT NULL DEFAULT false,
aim_firstName TEXT NOT NULL DEFAULT '',
aim_lastName TEXT NOT NULL DEFAULT '',
aim_middleName TEXT NOT NULL DEFAULT '',
aim_maidenName TEXT NOT NULL DEFAULT '',
aim_country TEXT NOT NULL DEFAULT '',
aim_state TEXT NOT NULL DEFAULT '',
aim_city TEXT NOT NULL DEFAULT '',
aim_nickName TEXT NOT NULL DEFAULT '',
aim_zipCode TEXT NOT NULL DEFAULT '',
aim_address TEXT NOT NULL DEFAULT '',
aim_keyword1 INTEGER,
aim_keyword2 INTEGER,
aim_keyword3 INTEGER,
aim_keyword4 INTEGER,
aim_keyword5 INTEGER,
icq_affiliations_currentCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentCode3 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_currentKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_currentKeyword2 TEXT NOT NULL DEFAULT '',
icq_affiliations_currentKeyword3 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode3 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword2 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword3 TEXT NOT NULL DEFAULT '',
l G'� indexidx_webapi_tokens_screen_namewebapi_tokens CREATE INDEX idx_webapi_tokens_screen_name ON webapi_tokens(screen_name)| E'�indexidx_webapi_tokens_expires_atwebapi_tokens CREATE INDEX idx_webapi_tokens_expires_at ON webapi_tokens(expires_at)9 M' indexsqlite_autoindex_webapi_tokens_1webapi_tokens �_''�}tablewebapi_tokenswebapi_tokensCREATE TABLE webapi_tokens (
token TEXT PRIMARY KEY,
screen_name TEXT NOT NULL,
expires_at TIMESTAMP NOT NULL,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
)EY3 indexsqlite_autoindex_clientSideBuddyList_1clientSideBuddyList� 33�'tableclientSideBuddyListclientSideBuddyListCREATE TABLE clientSideBuddyList
(
me VARCHAR(16),
them VARCHAR(16),
isBuddy BOOLEAN DEFAULT false,
isPermit BOOLEAN DEFAULT false,
isDeny BOOLEAN DEFAULT false,
PRIMARY KEY (me, them)
)9M' indexsqlite_autoindex_buddyListMode_1buddyListMode
�L''�WtablebuddyListModebuddyListMode CREATE TABLE buddyListMode
(
screenName VARCHAR(16),
clientSidePDMode INTEGER DEFAULT 0,
useFeedbag BOOLEAN DEFAULT false,
PRIMARY KEY (screenName)
))= indexsqlite_autoindex_users_1users
ions_pastKeyword3 TEXT NOT NULL DEFAULT '',
icq_basicInfo_address TEXT NOT NULL DEFAULT '',
icq_basicInfo_cellPhone TEXT NOT NULL DEFAULT '',
icq_basicInfo_city TEXT NOT NULL DEFAULT '',
icq_basicInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_emailAddress TEXT NOT NULL DEFAULT '',
icq_basicInfo_fax TEXT NOT NULL DEFAULT '',
icq_basicInfo_firstName TEXT NOT NULL DEFAULT '',
icq_basicInfo_gmtOffset INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_lastName TEXT NOT NULL DEFAULT '',
icq_basicInfo_nickName TEXT NOT NULL DEFAULT '',
icq_basicInfo_phone TEXT NOT NULL DEFAULT '',
icq_basicInfo_publishEmail BOOLEAN NOT NULL DEFAULT false,
icq_basicInfo_state TEXT NOT NULL DEFAULT '',
icq_basicInfo_zipCode TEXT NOT NULL DEFAULT '',
icq_interests_code1 INTEGER NOT NULL DEFAULT 0,
icq_interests_code2 INTEGER NOT NULL DEFAULT 0,
icq_interests_code3 INTEGER NOT NULL DEFAULT 0,
icq_interests_code4 INTEGER NOT NULL DEFAULT 0,
icq_interests_keyword1 TEXT NOT NULL DEFAULT '',
icq_interests_keyword2 TEXT NOT NULL DEFAULT '',
icq_interests_keyword3 TEXT NOT NULL DEFAULT '',
icq_interests_keyword4 TEXT NOT NULL DEFAULT '',
icq_moreInfo_birthDay INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthMonth INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthYear INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_gender INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_homePageAddr TEXT NOT NULL DEFAULT '',
icq_moreInfo_lang1 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang2 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang3 INTEGER NOT NULL DEFAULT 0,
icq_notes TEXT NOT NULL DEFAULT '',
icq_workInfo_address TEXT NOT NULL DEFAULT '',
icq_workInfo_city TEXT NOT NULL DEFAULT '',
icq_workInfo_company TEXT NOT NULL DEFAULT '',
icq_workInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_department TEXT NOT NULL DEFAULT '',
icq_workInfo_fax TEXT NOT NULL DEFAULT '',
icq_workInfo_occupationCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_phone TEXT NOT NULL DEFAULT '',
icq_workInfo_position TEXT NOT NULL DEFAULT '',
icq_workInfo_state TEXT NOT NULL DEFAULT '',
icq_workInfo_webPage TEXT NOT NULL DEFAULT '',
icq_workInfo_zipCode TEXT NOT NULL DEFAULT '', tocConfig TEXT NOT NULL DEFAULT '', suspendedStatus int NOT NULL DEFAULT 0, isBot BOOLEAN NOT NULL DEFAULT false, lastWarnLevel INTEGER NOT NULL DEFAULT 0, lastWarnUpdate INTEGER NOT NULL DEFAULT 0, offlineMsgCount INTEGER NOT NULL DEFAULT 0, icq_permissions_webAware BOOLEAN NOT NULL DEFAULT false, icq_permissions_allowSpam BOOLEAN NOT NULL DEFAULT false, icq_permissions_authRequired BOOLEAN NOT NULL DEFAULT true, icq_homepageCategory_enabled BOOLEAN NOT NULL DEFAULT false, icq_homepageCategory_index INTEGER NOT NULL DEFAULT 0, icq_homepageCategory_description TEXT NOT NULL DEFAULT '', icq_basicInfo_originCity TEXT NOT NULL DEFAULT '', icq_basicInfo_originState TEXT NOT NULL DEFAULT '',
FOREIGN KEY (aim_keyword1) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword2) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword3) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword4) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword5) REFERENCES aimKeyword (id)
)
L p � K
���m�[�)�p �?�L m � � A �@7=�indexidx_feed_subs_feed_idbuddy�===�;tablebuddy_feed_subscriptionsbuddy_feed_subscriptions>CREATE TABLE buddy_feed_subscriptions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
subscriber_screen_name VARCHAR(16) NOT NULL,
feed_id INTEGER NOT NULL,
subscribed_at INTEGER NOT NULL,
last_checked_at INTEGER,
FOREIGN KEY (feed_id) REFERENCES buddy_feeds(id) ON DELETE CASCADE,
UNIQUE(subscriber_screen_name, feed_id)
)j<3-�indexidx_feed_items_guidbuddy_feed_items=CREATE INDEX idx_feed_items_guid ON buddy_feed_items(guid)q,7)�indexidx_usage_screen_nameapi_usage_logs,CREATE INDEX idx_usage_screen_name ON api_usage_logs(screen_name)g+-)�indexidx_usage_statusapi_usage_logs+CREATE INDEX idx_usage_status ON api_usage_logs(status_code)$ =-�indexia(-){indexidx_usage_dev_idapi_usage_logs(CREATE INDEX idx_usage_dev_id ON api_usage_logs(dev_id)P'++Ytablesqlite_sequencesqlite_sequence'CREATE TABLE sqlite_sequence(name,seq)�Z&))�otableapi_usage_logsapi_usage_logs&CREATE TABLE api_usage_logs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
dev_id VARCHAR(255) NOT NULL,
endpoint VARCHAR(255) NOT NULL,
method VARCHAR(10) NOT NULL,
timestamp INTEGER NOT NULL,
response_time_ms INTEGER,
status_code INTEGER,
ip_address VARCHAR(45),
user_agent TEXT,
screen_name VARCHAR(16), -- User making the request (if authenticated)
error_message TEXT, -- Store error details if request failed
request_size INTEGER, -- Size of request in bytes
response_size INTEGER -- Size of response in bytes
)�%I7�3indexidx_oscar_bridge_last_accessedoscar_bridge_sessions%CREATE INDEX idx_oscar_bridge_last_accessed ON oscar_bridge_sessions(last_accessed)�
$E7�+indexidx_oscar_bridge_screen_nameoscar_bridge_sessions$CREATE INDEX idx_oscar_bridge_screen_name ON oscar_bridge_sessions(screen_name)I#]7 indexsqlite_autoindex_oscar_bridge_sessions_1oscar_bridge_sessions#�`"77�_tableoscar_bridge_sessionsoscar_bridge_sessions"CREATE TABLE oscar_bridge_sessions (
-- WebAPI session identifier (aimsid)
web_session_id VARCHAR(64) PRIMARY KEY,
-- OSCAR authentication cookie (hex encoded)
oscar_cookie BLOB NOT NULL,
-- BOS server connection details
bos_host VARCHAR(255) NOT NULL,
bos_port INTEGER NOT NULL,
use_ssl BOOLEAN DEFAULT FALSE,
-- Screen name associated with the session
screen_name VARCHAR(97) NOT NULL,
-- Session metadata
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
last_accessed TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-- Optional: Track client info
client_name VARCHAR(255),
client_version VARCHAR(50)
)�!K+�%indexidx_web_preferences_screen_nameweb_preferences!CREATE INDEX idx_web_preferences_screen_name ON web_preferences(screen_name)= Q+ indexsqlite_autoindex_web_preferences_1web_preferences �! ++�ytableweb_preferencesweb_preferences CREATE TABLE web_preferences
(
screen_name VARCHAR(16) PRIMARY KEY,
preferences TEXT, -- JSON object of preference key-value pairs
created_at INTEGER NOT NULL,
updated_at INTEGER NOT NULL
)�s-++� tableapi_usage_statsapi_usage_stats-CREATE TABLE api_usage_stats (
id INTEGER PRIMARY KEY AUTOINCREMENT,
dev_id VARCHAR(255) NOT NULL,
endpoint VARCHAR(255) NOT NULL,
period_type VARCHAR(10) NOT NULL, -- 'hour', 'day', 'month'
period_start INTEGER NOT NULL,
request_count INTEGER DEFAULT 0,
error_count INTEGER DEFAULT 0,
total_response_time_ms INTEGER DEFAULT 0,
avg_response_time_ms INTEGER DEFAULT 0,
total_request_bytes INTEGER DEFAULT 0,
total_response_bytes INTEGER DEFAULT 0,
unique_users INTEGER DEFAULT 0,
UNIQUE(dev_id, endpoint, period_type, period_start)
) 7h*1)�indexidx_usage_endpointapi_usage_logs*CREATE INDEX idx_usage_endpoint ON api_usage_logs(endpoint)k)3)�indexidx_usage_timestampapi_usage_logs)CREATE INDEX idx_usage_timestamp ON api_usage_logs(timestamp)
M �\�w
� -
�
> � h� �2�J�-�Y" � Mliations_pastKeyword3kE9#�indexidx_vanity_urls_activevanity_urlsGCREATE INDEX idx_vanity_urls_active ON vanity_urls(is_active)fD3#�indexidx_vanity_urls_urlvanity_urlsFCREATE INDEX idx_vanity_urls_url ON vanity_urls(vanity_url)5CI# indexsqlite_autoindex_vanity_urls_2vanity_urlsD5BI# indexsqlite_autoindex_vanity_urls_1vanity_urlsC�A##�{tablevanity_urlsvanity_urlsBCREATE TABLE vanity_urls (
screen_name VARCHAR(16) PRIMARY KEY,
vanity_url VARCHAR(255) UNIQUE NOT NULL,
display_name VARCHAR(100),
bio TEXT,
location VARCHAR(100),
website VARCHAR(255),
created_at INTEGER NOT NULL,
updated_at INTEGER NOT NULL,
is_active BOOLEAN DEFAULT TRUE,
click_count INTEGER DEFAULT 0,
last_accessed INTEGER
)�@7=�indexidx_feed_subs_feed_idbuddy_feed_subscriptionsACREATE INDEX idx_feed_subs_feed_id ON buddy_feed_subscriptions(feed_id)�?==�?indexidx_feed_subs_subscriberbuddy_feed_subscriptions@CREATE INDEX idx_feed_subs_subscriber ON buddy_feed_subscriptions(subscriber_screen_name)O>c= indexsqlite_autoindex_buddy_feed_subscriptions_1buddy_feed_subscriptions?�===�;tablebuddy_feed_subscriptionsbuddy_feed_subscriptions>CREATE TABLE buddy_feed_subscriptions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
subscriber_screen_name VARCHAR(16) NOT NULL,
feed_id INTEGER NOT NULL,
subscribed_at INTEGER NOT NULL,
last_checked_at INTEGER,
FOREIGN KEY (feed_id) REFERENCES buddy_feeds(id) ON DELETE CASCADE,
UNIQUE(subscriber_screen_name, feed_id)
)j<3-�indexidx_feed_items_guidbuddy_feed_items=CREATE INDEX idx_feed_items_guid ON buddy_feed_items(guid)|;=-�indexidx_feed_items_publishedbuddy_feed_items<CREATE INDEX idx_feed_items_published ON buddy_feed_items(published_at)s:9-�
indexidx_feed_items_feed_idbuddy_feed_items;CREATE INDEX idx_feed_items_feed_id ON buddy_feed_items(feed_id)�T9--�[tablebuddy_feed_itemsbuddy_feed_items:CREATE TABLE buddy_feed_items (
id INTEGER PRIMARY KEY AUTOINCREMENT,
feed_id INTEGER NOT NULL,
title TEXT NOT NULL,
description TEXT,
link TEXT,
guid TEXT,
author VARCHAR(16), -- Screen name of the author
categories TEXT, -- JSON array of categories
published_at INTEGER NOT NULL,
created_at INTEGER NOT NULL,
FOREIGN KEY (feed_id) REFERENCES buddy_feeds(id) ON DELETE CASCADE
)k89#�indexidx_buddy_feeds_activebuddy_feeds9CREATE INDEX idx_buddy_feeds_active ON buddy_feeds(is_active)g75#�indexidx_buddy_feeds_typebuddy_feeds8CREATE INDEX idx_buddy_feeds_type ON buddy_feeds(feed_type)t6?#�indexidx_buddy_feeds_publishedbuddy_feeds7CREATE INDEX idx_buddy_feeds_published ON buddy_feeds(published_at)w5C#�indexidx_buddy_feeds_screen_namebuddy_feeds6CREATE INDEX idx_buddy_feeds_screen_name ON buddy_feeds(screen_name)� 4##�tablebuddy_feedsbuddy_feeds5CREATE TABLE buddy_feeds (
id INTEGER PRIMARY KEY AUTOINCREMENT,
screen_name VARCHAR(16) NOT NULL,
feed_type VARCHAR(50) NOT NULL, -- 'rss', 'atom', 'status', 'blog', 'social'
title TEXT,
description TEXT,
link TEXT,
published_at INTEGER NOT NULL,
created_at INTEGER NOT NULL,
updated_at INTEGER NOT NULL,
is_active BOOLEAN DEFAULT TRUE
)33G! indexsqlite_autoindex_api_quotas_1api_quotas4�r2!!�/tableapi_quotasapi_quotas3CREATE TABLE api_quotas (
dev_id VARCHAR(255) PRIMARY KEY,
daily_limit INTEGER DEFAULT 10000,
monthly_limit INTEGER DEFAULT 300000,
daily_used INTEGER DEFAULT 0,
monthly_used INTEGER DEFAULT 0,
last_reset_daily INTEGER NOT NULL,
last_reset_monthly INTEGER NOT NULL,
overage_allowed BOOLEAN DEFAULT FALSE
)j11+�indexidx_stats_endpointapi_usage_stats2CREATE INDEX idx_stats_endpoint ON api_usage_stats(endpoint)w0-+�#indexidx_stats_periodapi_usage_stats1CREATE INDEX idx_stats_period ON api_usage_stats(period_type, period_start)c/-+}indexidx_stats_dev_idapi_usage_stats0CREATE INDEX idx_stats_dev_id ON api_usage_stats(dev_id)=.Q+ indexsqlite_autoindex_api_usage_stats_1api_usage_stats.
� �,
�
� Y
�
^ � i���� �� � wO� wO?)�indexidx_web_chat_rooms_closedweb_chat_roomsQCREATE INDEX idx_web_chat_rooms_closed ON web_chat_rooms(cl�UE/� indexidx_web_chat_sessions_j�.Z77�{tableweb_chat_participantsweb_chat_participants]CREATE TABLE web_chat_participants (
room_id VARCHAR(255) NOT NULL,
screen_name VARCHAR(16) NOT NULL,
chat_sid VARCHAR(255) NOT NULL,
joined_at INTEGER NOT NULL,
typing_status VARCHAR(20) DEFAULT 'none',
typing_updated_at INTEGER,
PRIMARY KEY (room_id, screen_name),
FOREIGN KEY (room_id) REFERENCES web_chat_rooms(room_id) ON DELETE CASCADE
)�YA/� indexidx_web_chat_messages_userweb_chat_messages\CREATE INDEX idx_web_chat_messages_user ON web_chat_messages(screen_name)� XK/�%indexidx_web_chat_messages_timestampweb_chat_messagesZCREATE INDEX idx_web_chat_messages_timestamp ON web_chat_messages(timestamp)}WA/�indexidx_web_chat_messages_roomweb_chat_messagesYCREATE INDEX idx_web_chat_messages_room ON web_chat_messages(room_id)�nV//� tableweb_chat_messagesweb_chat_messagesXCREATE TABLE web_chat_messages (
id INTEGER PRIMARY KEY AUTOINCREMENT,
room_id VARCHAR(255) NOT NULL,
screen_name VARCHAR(16) NOT NULL,
message TEXT NOT NULL,
whisper_target VARCHAR(16),
timestamp INTEGER NOT NULL,
FOREIGN KEY (room_id) REFERENCES web_chat_rooms(room_id) ON DELETE CASCADE
)�UE/� indexidx_web_chat_sessions_joinedweb_chat_sessionsWCREATE INDEX idx_web_chat_sessions_joined ON web_chat_sessions(joined_at)�TA/� indexidx_web_chat_sessions_userweb_chat_sessionsVCREATE INDEX idx_web_chat_sessions_user ON web_chat_sessions(screen_name)}SA/�indexidx_web_chat_sessions_roomweb_chat_sessionsUCREATE INDEX idx_web_chat_sessions_room ON web_chat_sessions(room_id)� RE/�indexidx_web_chat_sessions_aimsidweb_chat_sessionsTCREATE INDEX idx_web_chat_sessions_aimsid ON web_chat_sessions(aimsid)AQU/ indexsqlite_autoindex_web_chat_sessions_1web_chat_sessionsS� P//�Atableweb_chat_sessionsweb_chat_sessionsRCREATE TABLE web_chat_sessions (
chat_sid VARCHAR(255) PRIMARY KEY,
aimsid VARCHAR(255) NOT NULL,
room_id VARCHAR(255) NOT NULL,
screen_name VARCHAR(16) NOT NULL,
instance_id INTEGER NOT NULL,
joined_at INTEGER NOT NULL,
left_at INTEGER,
FOREIGN KEY (room_id) REFERENCES web_chat_rooms(room_id) ON DELETE CASCADE
)wO?)�indexidx_web_chat_rooms_closedweb_chat_roomsQCREATE INDEX idx_web_chat_rooms_closed ON web_chat_rooms(closed_at)zNA)�indexidx_web_chat_rooms_createdweb_chat_roomsPCREATE INDEX idx_web_chat_rooms_created ON web_chat_rooms(created_at)�MA)�)indexidx_web_chat_rooms_creatorweb_chat_roomsOCREATE INDEX idx_web_chat_rooms_creator ON web_chat_rooms(creator_screen_name)sL;)�indexidx_web_chat_rooms_nameweb_chat_roomsNCREATE INDEX idx_web_chat_rooms_name ON web_chat_rooms(room_name);KO) indexsqlite_autoindex_web_chat_rooms_1web_chat_roomsM�J))�Gtableweb_chat_roomsweb_chat_roomsLCREATE TABLE web_chat_rooms (
room_id VARCHAR(255) PRIMARY KEY,
room_name VARCHAR(255) NOT NULL,
description TEXT,
room_type VARCHAR(50) DEFAULT 'userCreated',
category_id VARCHAR(50),
creator_screen_name VARCHAR(16) NOT NULL,
created_at INTEGER NOT NULL,
closed_at INTEGER,
max_participants INTEGER DEFAULT 100
)�I?5�#indexidx_vanity_redirects_timevanity_url_redirectsKCREATE INDEX idx_vanity_redirects_time ON vanity_url_redirects(accessed_at)�H=5� indexidx_vanity_redirects_urlvanity_url_redirectsJCREATE INDEX idx_vanity_redirects_url ON vanity_url_redirects(vanity_url)�aG55�etablevanity_url_redirectsvanity_url_redirectsICREATE TABLE vanity_url_redirects (
id INTEGER PRIMARY KEY AUTOINCREMENT,
vanity_url VARCHAR(255) NOT NULL,
accessed_at INTEGER NOT NULL,
ip_address VARCHAR(45),
user_agent TEXT,
referer TEXT,
FOREIGN KEY (vanity_url) REFERENCES vanity_urls(vanity_url) ON DELETE CASCADE
)nF;#� indexidx_vanity_urls_createdvanity_urlsHCREATE INDEX idx_vanity_urls_created ON vanity_urls(created_at)
NOT NULL DEFAULT '',
icq_affiliations_currentKeyword3 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastCode1 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode2 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastCode3 INTEGER NOT NULL DEFAULT 0,
icq_affiliations_pastKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword2 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword3 TEXT NOT NULL DEFAULT '',
icq_basicInfo_address TEXT NOT NULL DEFAULT '',
icq_basicInfo_cellPhone TEXT NOT NULL DEFAULT '',
icq_basicInfo_city TEXT NOT NULL DEFAULT '',
icq_basicInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_emailAddress TEXT NOT NULL DEFAULT '',
icq_basicInfo_fax TEXT NOT NULL DEFAULT '',
icq_basicInfo_firstName TEXT NOT NULL DEFAULT '',
icq_basicInfo_gmtOffset INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_lastName TEXT NOT NULL DEFAULT '',
icq_basicInfo_nickName TEXT NOT NULL DEFAULT '',
icq_basicInfo_phone TEXT NOT NULL DEFAULT '',
icq_basicInfo_publishEmail BOOLEAN NOT NULL DEFAULT false,
icq_basicInfo_state TEXT NOT NULL DEFAULT '',
icq_basicInfo_zipCode TEXT NOT NULL DEFAULT '',
icq_interests_code1 INTEGER NOT NULL DEFAULT 0,
icq_interests_code2 INTEGER NOT NULL DEFAULT 0,
icq_interests_code3 INTEGER NOT NULL DEFAULT 0,
icq_interests_code4 INTEGER NOT NULL DEFAULT 0,
icq_interests_keyword1 TEXT NOT NULL DEFAULT '',
icq_interests_keyword2 TEXT NOT NULL DEFAULT '',
icq_interests_keyword3 TEXT NOT NULL DEFAULT '',
icq_interests_keyword4 TEXT NOT NULL DEFAULT '',
icq_moreInfo_birthDay INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthMonth INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthYear INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_gender INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_homePageAddr TEXT NOT NULL DEFAULT '',
icq_moreInfo_lang1 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang2 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang3 INTEGER NOT NULL DEFAULT 0,
icq_notes TEXT NOT NULL DEFAULT '',
icq_permissions_authRequired BOOLEAN NOT NULL DEFAULT false,
icq_workInfo_address TEXT NOT NULL DEFAULT '',
icq_workInfo_city TEXT NOT NULL DEFAULT '',
icq_workInfo_company TEXT NOT NULL DEFAULT '',
icq_workInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_department TEXT NOT NULL DEFAULT '',
icq_workInfo_fax TEXT NOT NULL DEFAULT '',
icq_workInfo_occupationCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_phone TEXT NOT NULL DEFAULT '',
icq_workInfo_position TEXT NOT NULL DEFAULT '',
icq_workInfo_state TEXT NOT NULL DEFAULT '',
icq_workInfo_webPage TEXT NOT NULL DEFAULT '',
icq_workInfo_zipCode TEXT NOT NULL DEFAULT '', tocConfig TEXT NOT NULL DEFAULT '', suspendedStatus int NOT NULL DEFAULT 0, isBot BOOLEAN NOT NULL DEFAULT false, lastWarnLevel INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY (aim_keyword1) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword2) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword3) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword4) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword5) REFERENCES aimKeyword (id)
)
0,
icq_affiliations_pastKeyword1 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword2 TEXT NOT NULL DEFAULT '',
icq_affiliations_pastKeyword3 TEXT NOT NULL DEFAULT '',
icq_basicInfo_address TEXT NOT NULL DEFAULT '',
icq_basicInfo_cellPhone TEXT NOT NULL DEFAULT '',
icq_basicInfo_city TEXT NOT NULL DEFAULT '',
icq_basicInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_emailAddress TEXT NOT NULL DEFAULT '',
icq_basicInfo_fax TEXT NOT NULL DEFAULT '',
icq_basicInfo_firstName TEXT NOT NULL DEFAULT '',
icq_basicInfo_gmtOffset INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_lastName TEXT NOT NULL DEFAULT '',
icq_basicInfo_nickName TEXT NOT NULL DEFAULT '',
icq_basicInfo_phone TEXT NOT NULL DEFAULT '',
icq_basicInfo_publishEmail BOOLEAN NOT NULL DEFAULT false,
icq_basicInfo_state TEXT NOT NULL DEFAULT '',
icq_basicInfo_zipCode TEXT NOT NULL DEFAULT '',
icq_interests_code1 INTEGER NOT NULL DEFAULT 0,
icq_interests_code2 INTEGER NOT NULL DEFAULT 0,
icq_interests_code3 INTEGER NOT NULL DEFAULT 0,
icq_interests_code4 INTEGER NOT NULL DEFAULT 0,
icq_interests_keyword1 TEXT NOT NULL DEFAULT '',
icq_interests_keyword2 TEXT NOT NULL DEFAULT '',
icq_interests_keyword3 TEXT NOT NULL DEFAULT '',
icq_interests_keyword4 TEXT NOT NULL DEFAULT '',
icq_moreInfo_birthDay INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthMonth INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthYear INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_gender INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_homePageAddr TEXT NOT NULL DEFAULT '',
icq_moreInfo_lang1 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang2 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang3 INTEGER NOT NULL DEFAULT 0,
icq_notes TEXT NOT NULL DEFAULT '',
icq_workInfo_address TEXT NOT NULL DEFAULT '',
icq_workInfo_city TEXT NOT NULL DEFAULT '',
icq_workInfo_company TEXT NOT NULL DEFAULT '',
icq_workInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_department TEXT NOT NULL DEFAULT '',
icq_workInfo_fax TEXT NOT NULL DEFAULT '',
icq_workInfo_occupationCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_phone TEXT NOT NULL DEFAULT '',
icq_workInfo_position TEXT NOT NULL DEFAULT '',
icq_workInfo_state TEXT NOT NULL DEFAULT '',
icq_workInfo_webPage TEXT NOT NULL DEFAULT '',
icq_workInfo_zipCode TEXT NOT NULL DEFAULT '', tocConfig TEXT NOT NULL DEFAULT '', suspendedStatus int NOT NULL DEFAULT 0, isBot BOOLEAN NOT NULL DEFAULT false, lastWarnLevel INTEGER NOT NULL DEFAULT 0, lastWarnUpdate INTEGER NOT NULL DEFAULT 0, offlineMsgCount INTEGER NOT NULL DEFAULT 0, icq_permissions_webAware BOOLEAN NOT NULL DEFAULT false, icq_permissions_allowSpam BOOLEAN NOT NULL DEFAULT false, icq_permissions_authRequired BOOLEAN NOT NULL DEFAULT true, icq_homepageCategory_enabled BOOLEAN NOT NULL DEFAULT false, icq_homepageCategory_index INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY (aim_keyword1) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword2) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword3) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword4) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword5) REFERENCES aimKeyword (id)
)
� S Y�*K�Ba
�
j S
- �
1 4 4 �lf))�tablecontactPreauthcontactPreauthhCREATE TABLE contactPreauth
(
ownerScreenName VARCHAR(16) NOT NULL,
authorizedScreenName VARCHAR(16) NOT NULL,
createdAt INTEGER NOT NULL,
PRIMARY KEY (ownerScreenName, authorizedScreenName),
FOREIGN KEY (ownerScreenName) REFERENCES users (identScreenName) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (authorizedScreenName) REFERENCES users (identScreenName) ON DELETE CASCADE ON UPDATE CASCADE
)ubA%�indexidx_web_api_keys_is_activeweb_api_keyseCREATE INDEX idx_web_api_keys_is_active ON web_api_keys(is_active)oa=%� indexidx_web_api_keys_dev_keyweb_api_keysdCREATE INDEX idx_web_api_keys_dev_key ON web_api_keys(dev_key)�e^%%�
tableweb_api_keysweb_api_keysaCREATE TABLE web_api_keys
(
dev_id VARCHAR(255) PRIMARY KEY,
dev_key VARCHAR(255) UNIQUE NOT NULL,
app_name VARCHAR(255) NOT NULL,
created_at INTEGER NOT NULL,
last_used INTEGER,
is_active BOOLEAN DEFAULT 1,
rate_limit INTEGER DEFAULT 60,
allowed_origins TEXT, -- JSON array of allowed CORS origins
capabilities TEXT -- JSON array of enabled features/endpoints
)7`K% indexsqlite_autoindex_web_api_keys_2web_api_keysc7_K% indexsqlite_autoindex_web_api_keys_1web_api_keysb�]I7�/indexidx_web_chat_participants_userweb_chat_participants`CREATE INDEX idx_web_chat_participants_user ON web_chat_participants(screen_name)�
\I7�'indexidx_web_chat_participants_roomweb_chat_participants_CREATE INDEX idx_web_chat_participants_room ON web_chat_participants(room_id)��77�{tableweb_chat_participantsweb_chat_participants]CREATE TABLE web_chat_participants (
room_id VARCHAR(255) NOT NULL,
screen_name VARCHAR(16) NOT NULL,
chat_sid VARCHAR(255) NOT NULL,
joined_at INTEGER NOT NULL,
typing_status VARCHAR(20) DEFAULT 'none',
typing_updated_at INTEGER,
PRIMARY KEY (room_id, screen_name),
FOREIGN KEY (room_id) REFERENCES web_chat_rooms(room_id) ON DELETE CASCADE
)I[]7 indexsqlite_autoindex_web_chat_participants_1web_chat_participants^ ��A/� indexidx_web_chat_messages_userweb_chat_messages\CREATE INDEX idx_web_chat_messages_user ON web_chat_messages(screen_name)� XK/�%indexidx_web_chat_messages_timestampweb_chat_messagesZCREATE INDEX idx_web_chat_messages_timestamp ON web_chat_messages(timestamp)}WA/�indexidx_web_chat_messages_roomweb_chat_messagesYCREATE INDEX idx_web_chat_messages_room ON web_chat_messages(room_i� i;;�tablebuddyAddedNotificationsbuddyAddedNotificationsCREATE TABLE buddyAddedNotifications
(
granterScreenName VARCHAR(16) NOT NULL,
requesterScreenName VARCHAR(16) NOT NULL,
createdAt INTEGER NOT NULL,
PRIMARY KEY (granterScreenName, requesterScreenName),
FOREIGN KEY (granterScreenName) REFERENCES users (identScreenName) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (requesterScreenName) REFERENCES users (identScreenName) ON DELETE CASCADE ON UPDATE CASCADE
)Mja; indexsqlite_autoindex_buddyAddedNotifications_1buddyAddedNotificationsm � h[)�Gindexidx_contactPreauth_authorizedScreenNamecontactPreauthjCREATE INDEX idx_contactPreauth_authorizedScreenName ON contactPreauth (authorizedScreenName);gO) indexsqlite_autoindex_contactPreauth_1contactPreauthi~eE)�indexidx_offlineMessage_recipientofflineMessagegCREATE INDEX idx_offlineMessage_recipient ON offlineMessage (recipient)ud?)�indexidx_offlineMessage_senderofflineMessageCREATE INDEX idx_offlineMessage_sender ON offlineMessage (sender)� c))�stableofflineMessageofflineMessagefCREATE TABLE offlineMessage
(
sender VARCHAR(16) NOT NULL,
recipient VARCHAR(16) NOT NULL,
message BLOB NOT NULL,
sent TIMESTAMP NOT NULL,
FOREIGN KEY (sender) REFERENCES users (identScreenName) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (recipient) REFERENCES users (identScreenName) ON DELETE CASCADE ON UPDATE CASCADE
) icq_basicInfo_address TEXT NOT NULL DEFAULT '',
icq_basicInfo_cellPhone TEXT NOT NULL DEFAULT '',
icq_basicInfo_city TEXT NOT NULL DEFAULT '',
icq_basicInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_emailAddress TEXT NOT NULL DEFAULT '',
icq_basicInfo_fax TEXT NOT NULL DEFAULT '',
icq_basicInfo_firstName TEXT NOT NULL DEFAULT '',
icq_basicInfo_gmtOffset INTEGER NOT NULL DEFAULT 0,
icq_basicInfo_lastName TEXT NOT NULL DEFAULT '',
icq_basicInfo_nickName TEXT NOT NULL DEFAULT '',
icq_basicInfo_phone TEXT NOT NULL DEFAULT '',
icq_basicInfo_publishEmail BOOLEAN NOT NULL DEFAULT false,
icq_basicInfo_state TEXT NOT NULL DEFAULT '',
icq_basicInfo_zipCode TEXT NOT NULL DEFAULT '',
icq_interests_code1 INTEGER NOT NULL DEFAULT 0,
icq_interests_code2 INTEGER NOT NULL DEFAULT 0,
icq_interests_code3 INTEGER NOT NULL DEFAULT 0,
icq_interests_code4 INTEGER NOT NULL DEFAULT 0,
icq_interests_keyword1 TEXT NOT NULL DEFAULT '',
icq_interests_keyword2 TEXT NOT NULL DEFAULT '',
icq_interests_keyword3 TEXT NOT NULL DEFAULT '',
icq_interests_keyword4 TEXT NOT NULL DEFAULT '',
icq_moreInfo_birthDay INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthMonth INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_birthYear INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_gender INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_homePageAddr TEXT NOT NULL DEFAULT '',
icq_moreInfo_lang1 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang2 INTEGER NOT NULL DEFAULT 0,
icq_moreInfo_lang3 INTEGER NOT NULL DEFAULT 0,
icq_notes TEXT NOT NULL DEFAULT '',
icq_workInfo_address TEXT NOT NULL DEFAULT '',
icq_workInfo_city TEXT NOT NULL DEFAULT '',
icq_workInfo_company TEXT NOT NULL DEFAULT '',
icq_workInfo_countryCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_department TEXT NOT NULL DEFAULT '',
icq_workInfo_fax TEXT NOT NULL DEFAULT '',
icq_workInfo_occupationCode INTEGER NOT NULL DEFAULT 0,
icq_workInfo_phone TEXT NOT NULL DEFAULT '',
icq_workInfo_position TEXT NOT NULL DEFAULT '',
icq_workInfo_state TEXT NOT NULL DEFAULT '',
icq_workInfo_webPage TEXT NOT NULL DEFAULT '',
icq_workInfo_zipCode TEXT NOT NULL DEFAULT '', tocConfig TEXT NOT NULL DEFAULT '', suspendedStatus int NOT NULL DEFAULT 0, isBot BOOLEAN NOT NULL DEFAULT false, lastWarnLevel INTEGER NOT NULL DEFAULT 0, lastWarnUpdate INTEGER NOT NULL DEFAULT 0, offlineMsgCount INTEGER NOT NULL DEFAULT 0, icq_permissions_webAware BOOLEAN NOT NULL DEFAULT false, icq_permissions_allowSpam BOOLEAN NOT NULL DEFAULT false, icq_permissions_authRequired BOOLEAN NOT NULL DEFAULT true, icq_homepageCategory_enabled BOOLEAN NOT NULL DEFAULT false, icq_homepageCategory_index INTEGER NOT NULL DEFAULT 0, icq_homepageCategory_description TEXT NOT NULL DEFAULT '', icq_basicInfo_originCity TEXT NOT NULL DEFAULT '', icq_basicInfo_originState TEXT NOT NULL DEFAULT '', icq_basicInfo_originCountryCode INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY (aim_keyword1) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword2) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword3) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword4) REFERENCES aimKeyword (id),
FOREIGN KEY (aim_keyword5) REFERENCES aimKeyword (id)
)
, s
� �
� , ��%8dx���' �x+�9 tricycleinskirt<BODY BGCOLOR="#000040"><FONT COLOR="#0080ff" FACE="Verdana" SIZE="1"><B>Tricycleinskirt</B><BR><BR>music . tattoos . piercings . lazy af . msg me :]<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWP�]'� scenebarbieex<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>scenebarbieex</B><BR><BR>scene barbie . xoxo . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWF�V%�{ augustjacque<BODY BGCOLOR="#000040"><FONT COLOR="#ff9900" FACE="bookman" SIZE="2"><B>AugustJacque</B><BR><BR>pics . myspace . xoxo<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkVƁU � zandoodle<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>zandoodle</B><BR><BR>myspace drama . lol . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW��_)� woohookatieboo<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>woohookatieboo</B><BR><BR>katie . woo hoo . msg me lol<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWN�[
� teachanx3<BODY BGCOLOR="#fdfce8"><FONT COLOR="#b9b00b" FACE="Trebuchet MS" SIZE="1"><B>TeaChanx3</B><BR><BR>tea chan x3 . heyy . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW��i -� stephatthediscox<BODY BGCOLOR="#000040"><FONT COLOR="#800000" FACE="Arial" SIZE="1"><B>StephAtTheDiscoX</B><BR><BR>steph . panic at the disco . <3<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWP�Q !�u ohtaylorrr<BODY BGCOLOR="#000040"><FONT COLOR="#008080" FACE="Arial" SIZE="2"><B>OhTaylorrr</B><BR><BR>taylor . music . <3<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�j
)� leetlegirllush<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>leetlegirllush</B><BR><BR>leet leg girl lush . bored . msg me lol<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�O '�k gioiamichelle<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>GioiAMicheLLe</B><BR><BR>bored . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkV\'� blondegrl2390<BODY BGCOLOR="#ffffff"><FONT COLOR="#4f4f4f" FACE="Century Gothic" SIZE="2"><B>blondegrl2390</B><BR><BR>blonde . msg me :]<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkV��g-� xxxcoreblondexxx<BODY BGCOLOR="#ffffff"><FONT COLOR="#0080ff" FACE="Verdana" SIZE="1"><B>XxXcoreblondeXxX</B><BR><BR>blonde . myspace . pics . xoxo<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW��k+� kookies4katelyn<BODY BGCOLOR="#000040"><FONT COLOR="#0000ff" FACE="Trebuchet MS" SIZE="1"><B>Kookies4Katelyn</B><BR><BR>katelyn . bored . always on lol<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�q%�1 curraxhomieg<BODY BGCOLOR="#ffffff"><FONT COLOR="#400080" FACE="Myriad Condensed Web" SIZE="1"><B>curraxhomieg</B><BR><BR>myspace is life . bored . hit me up<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkVāZ#� burnoutonme<BODY BGCOLOR="#010101"><FONT COLOR="#c0c0c0" FACE="Verdana" SIZE="1"><B>Burnoutonme</B><BR><BR>burnout . music . msg me xD<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkV��q!�5 soewaslike<FONT COLOR="#208fa4" FACE="Lucida Console" SIZE="2"><B>so E was like</B><BR><BR>bored.<BR>firefox is stupid.<BR>simpsons >>> homework<BR><BR><I>pe@ce bro</I><BR><BR>im always on lol<BR>msg me<BR></FONT>text/htmljkWP�
�i magus5311<BODY BGCOLOR="#000080"><FONT COLOR="#0000ff" FACE="Trebuchet MS" SIZE="2"><B>Magus5311</B><BR><BR><I>help</I><BR><BR><B>shows w/ the crew:</B><BR>maylene / haste the day / chariot / norma jean<BR>emery / he is legend / showbread<BR><BR>malachi . andrew . lydia . amy . keefe . charles . dag<BR><BR>/b/ . explosm . american idle<BR><BR>probably on.<BR></FONT></BODY>text/htmljkW
#O
r � �
�
1Z��� �= '�G conan0ftheday<BODY BGCOLOR='#000040'><FONT COLOR='#0080ff' FACE='Verdana' SIZE='1'><B>Conan0fTheDay</B><BR><BR>caleb . web dev . shows . lydia . spencer<BR></FONT></BODY>text/htmljkW�d !� damionelev<BODY BGCOLOR="#f5f5dc"><FONT COLOR="#006400" FACE="Times New Roman" SIZE="2"><B>Damion</B><BR><BR>elevations . mentor . life advice<BR><BR><I>glory!</I><BR><BR>here if you need me.<BR></FONT></BODY>text/htmljkV��I !�e dudesy7777<BODY BGCOLOR="#000040"><FONT COLOR="#408080" FACE="Arial" SIZE="1"><B>dudesy7777</B><BR><BR>lydia . joy . church . relient k<BR><BR>see you tomorrow caleb :]</FONT></BODY>text/htmljkV��R%�s shelliharsha<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>shelliharsha</B><BR><BR>heyy . lol . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWH�T%�w radiofiction<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>radiofiction</B><BR><BR>boo . random . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW��[#� bearychairy<BODY BGCOLOR="#000040"><FONT COLOR="#fefefe" FACE="GoudyHandtooled BT" SIZE="4"><B>Bearychairy</B><BR><BR>beary . heyy . :]<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkV��\+� alllipsofredred<BODY BGCOLOR="#000040"><FONT COLOR="#400040" FACE="Arial" SIZE="1"><B>alllipsofredred</B><BR><BR>red lips . lol . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkV��O �u kddunn05<BODY BGCOLOR="#000040"><FONT COLOR="#008080" FACE="Verdana" SIZE="1"><B>kddunn05</B><BR><BR>music . myspace . heyy<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�`-� takethebreakdown<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>takethebreakdown</B><BR><BR>breakdown . hiii . msg me<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWT�L �o peacful3<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>Peacful3</B><BR><BR>peaceful . lol . heyy<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�Z'� opentheharbor<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>opentheharbor</B><BR><BR>come hang out . msg me :P<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�Q!�u ralexa7403<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>RAlexa7403</B><BR><BR>alexa . pics . myspace<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkW�Z)� teasememarissa<BODY BGCOLOR="#000040"><FONT COLOR="#ff66cc" FACE="Arial" SIZE="2"><B>TeaseMEMarissa</B><BR><BR>marissa . tease me . ;)<BR><BR><I>probably on lol</I><BR><BR>msg me :]<BR></FONT></BODY>text/htmljkWK
> ;|
�
@ �
� � 8u��8��<}� � > �8_!!U,,
ralexa7403ralexa740349185fc3-ba28-449c-9908-35e47116c086��Dݼw?���Q�/�r˖n��Gӎ=i����@_))U,,
teasememarissateasememarissa49dd6e7c-28a9-4272-879c-77c797140a26��ɞ���b�Y�.Q�� �N�ַ���ێ��Mc�>_''U,,
scenebarbieexscenebarbieexc746a1a2-1ceb-4530-8350-cf36472332b9]QP�ז��4�� ��D�`��>y��SUM��<_%%U,,
augustjacqueaugustjacquec70e0741-1bac-4b3b-a5c3-5ff56462f932�5��/����O��X��ns�L�1p%����6_ U,,
zandoodlezandoodlec8684ff8-f06e-4174-8560-05c5c61cd3f9�?�S�ή"����0
�/��U��/�ޅ�@_))U,,
woohookatieboowoohookatieboo17e93d2c-75c8-466a-a200-3ceb5a2cabacR��S���|Q��RZ���i��d�RZ����D_--U,,
stephatthediscoxstephatthediscox69a37f7d-a09d-410d-9318-c49c8ce08b39"x�X��sW�}؇�G ����^�r]�N�m��6_ U,,
teachanx3teachanx36f8fc63a-941a-4361-9de2-8cd5661ad2be*?��v�M��i�*�� T�^~�&���/�祆j�>
_''U,,
gioiamichellegioiamichelle46d9ed34-e9d3-49cf-9b43-358d48485c65�VU�-��x�m �~�M�g$:�vi80�I _}�> _''U,,
blondegrl2390blondegrl2390fc336322-27fa-406e-b70c-056dad13aca6��� �O��tZ��ZM/]����)�C��-5՜v�8 _!!U,,
ohtaylorrrohtaylorrr40ae5e2b-6f5c-4974-aa00-33be6142ca8f���*�L�/pc�L���ЯǨ��ڃT��s�@
_))U,,
leetlegirllushleetlegirllush2409f74c-f1ce-4888-ae3e-bd43cc7851a0,�0�K�$(���̐�S{II5��-�-�پ}�D _--U,,
xxxcoreblondexxxxxxcoreblondexxx1531b55c-c745-43b6-b9e3-2dbf4448be71L)����CN���@�*��W��=u��H7���7:�:_##U,,
burnoutonmeburnoutonme56d17eb2-d89b-4471-86c3-9fa43b1eeee8L�>��C�O��Y��vb<1ų��3�3��B_++U,,
kookies4katelynkookies4katelyn5032a738-bb81-4149-af4b-af37b8aaf64f��y=o.� /!^���r�n�d��1?����<_%%U,,
curraxhomiegcurraxhomieg26898322-dede-4271-ab13-65d26657a812�ԃB3�W� ���6�x�Q4N��Mj+�bj�6�B_++U,,
tricycleinskirttricycleinskirt342a7ebf-c680-4cc0-9a39-c2a09ddddda5 9-:�*1 [c�fb�er��3��^p%>�;_!'U,,
soewaslikeso E was like0a4806de-7fe1-44d2-a3ff-f7c6789574c0 c���{��M ۩yd�u`�Z�K��-�qe��"�6_ U,,
magus5311magus5311ddbdf1b0-27ee-4321-9975-4d512f32df86Q`�����w��݅Wm��b��_v
:qL2�<_%%U,,
smarterchildSmarterChildcb7aabc4-e5e1-4ec6-93dc-10abd79304e6w,�o
��a���}��H��|U���`ra��B_++U,,
conan0fthenightconan0fthenighteae100e6-5ff4-4923-8753-4d58095cbbd9�+����)���A���a�c���oq�'�
� ?�
�
K �
�
O�� �> _''U,,
conan0fthedayconan0ftheday5b090ba5-d26a-41dd-8ad0-295be3358ca5�(����h��n,�M����� E����"����8 _!!U,,
damionelevdamionelev28fc69a0-c54c-488a-9cfd-1a6f5c24f732]���6 f�I�a2�@�Ń�ܙ��1��d�(s�8 _!!U,,
dudesy7777dudesy777709e33221-3b5c-4836-9a14-91a5f9e9405aj
mJ�"��i,�H8�O�܌Cf8�M@�3#��B _++U,,
alllipsofredredalllipsofredred3bdbe03f-1d19-4f38-a67a-6cb4b6df5d54�<^�$2��n�#�
Q3�k��:��L��Ja.��: _##U,,
bearychairybearychairyb76f85d8-4887-40d1-a6f2-3883abb4c7c0 ��5�.�P�x��ǒ�#��[[���� ��<_%%U,,
shelliharshashelliharsha61662dde-cdd0-49a8-8bc8-3c800a72881d��Lb�R���Ԇ'�c�+ y�{��T���<_%%U,,
radiofictionradiofiction409528ce-40c6-4bca-825b-2cec9e046399���q $ݿ�� � .�L.���4�x�p!LО�1�4_ U,,
kddunn05kddunn05fc87ecb2-3fdd-4607-a7e2-18a360c7fc04�k��@͗�����w� L2�}���\"�6�<�D_--U,,
takethebreakdowntakethebreakdownd48a0c8b-67c6-4b8c-9acb-57f2ed353c9e4~�DHu�W �*"��Ni�G��f ��&��4_ U,,
peacful3peacful3c69912c3-5480-4b3a-9091-2c4c8622ba98 ��0����QQ^Nj}� �eW� `�� �9�#�j�>_''U,,
opentheharboropentheharborf7aa6d7a-e86d-4acd-b2c7-bc9db389198fm�t�㳍څ�ױ�ђ`KJT��`
�+9 �