INSERT INTO `search_index` VALUES('through', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('through', 18, 2, 1191913156);
INSERT INTO `search_index` VALUES('through', 19, 4, 1192599904);
INSERT INTO `search_index` VALUES('through', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('through', 35, 5, 1193373158);
INSERT INTO `search_index` VALUES('through', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('through', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('through', 47, 7, 1193288711);
INSERT INTO `search_index` VALUES('through', 58, 5, 1191625690);
INSERT INTO `search_index` VALUES('through', 76, 2, 1192331428);
INSERT INTO `search_index` VALUES('through', 78, 1, 1193523912);
INSERT INTO `search_index` VALUES('throughout', 10, 2, 1191288244);
INSERT INTO `search_index` VALUES('throughout', 19, 4, 1192599904);
INSERT INTO `search_index` VALUES('throughout', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('throughout', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('throughout', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('throughout', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('throughout', 50, 1, 1192842738);
INSERT INTO `search_index` VALUES('thus', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('thus', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('thus', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('thus', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('thus', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('tied', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('tier', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('ties', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('ties', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('time', 5, 2, 1190923888);
INSERT INTO `search_index` VALUES('time', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('time', 7, 2, 1190927060);
INSERT INTO `search_index` VALUES('time', 10, 6, 1191288244);
INSERT INTO `search_index` VALUES('time', 17, 3, 1193455700);
INSERT INTO `search_index` VALUES('time', 19, 17, 1192599904);
INSERT INTO `search_index` VALUES('time', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('time', 28, 5, 1193295727);
INSERT INTO `search_index` VALUES('time', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('time', 35, 3, 1193373158);
INSERT INTO `search_index` VALUES('time', 37, 2, 1193110752);
INSERT INTO `search_index` VALUES('time', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('time', 44, 3, 1192773711);
INSERT INTO `search_index` VALUES('time', 47, 10, 1193288711);
INSERT INTO `search_index` VALUES('time', 76, 3, 1192331428);
INSERT INTO `search_index` VALUES('times', 17, 2, 1193455700);
INSERT INTO `search_index` VALUES('times', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('times', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('tithes', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('toc', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('toc', 11, 1, 1191436125);
INSERT INTO `search_index` VALUES('toc', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('toc', 61, 1, 1191721102);
INSERT INTO `search_index` VALUES('toc', 65, 1, 1192166922);
INSERT INTO `search_index` VALUES('together', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('together', 14, 1, 1192407740);
INSERT INTO `search_index` VALUES('together', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('token', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('too', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('too', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('took', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('took', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('took', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('took', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('tool', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('tool', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('tool', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('top', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('top', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('topic', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('topic', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('topic', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('topic', 14, 1, 1192407740);
INSERT INTO `search_index` VALUES('topic', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('topic', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('tordesillas', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('toward', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('toward', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('toward', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('toward', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('toward', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('tower', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('trace', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('trade', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('trade', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('trade', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('trading', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('trajectory', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('transcontinental', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('transgressions', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('transit', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('transit', 47, 10, 1193288711);
INSERT INTO `search_index` VALUES('transiting', 47, 2, 1193288711);
INSERT INTO `search_index` VALUES('transition', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('transits', 19, 3, 1192599904);
INSERT INTO `search_index` VALUES('transits', 26, 3, 1192162069);
INSERT INTO `search_index` VALUES('transits', 47, 4, 1193288711);
INSERT INTO `search_index` VALUES('translations', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('transportation', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('travel', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('treasury', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('treasury', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('treaty', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('tree', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('trent', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('trine', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('trine', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('triple', 5, 2, 1190923888);
INSERT INTO `search_index` VALUES('triple', 7, 2, 1190927060);
INSERT INTO `search_index` VALUES('triple', 10, 2, 1191288244);
INSERT INTO `search_index` VALUES('triple', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('triumph', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('true', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('true', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('true', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('truncated', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('truth', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('tudors', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('tudors', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('tuned', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('turkish', 37, 3, 1193110752);
INSERT INTO `search_index` VALUES('turks', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('turks', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('turmoil', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('turn', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('turn', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('turn', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('turned', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('turned', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('turned', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('turned', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('turned', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('turned', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('turning', 4, 1, 1190921420);
INSERT INTO `search_index` VALUES('turning', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('turning', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('turning', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('turning', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('turns', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('turns', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('two', 17, 6, 1193455700);
INSERT INTO `search_index` VALUES('two', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('two', 19, 2, 1192599904);
INSERT INTO `search_index` VALUES('two', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('two', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('two', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('twofold', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('type', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('types', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('types', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('typically', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('ubiquitous', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('ultimate', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('ultimate', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('ultimately', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('ultimately', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('under', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('under', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('under', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('under', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('under', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('under', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('underlay', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('underlying', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('undermine', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('undermining', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('understand', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('understanding', 19, 2, 1192599904);
INSERT INTO `search_index` VALUES('understanding', 47, 2, 1193288711);
INSERT INTO `search_index` VALUES('undertaken', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('underwent', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('undiscovered', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('undisputed', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('unforeseen', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('unification', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('uniformly', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('unifying', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('unifying', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('unique', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('unique', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('unit', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('unit', 50, 1, 1192842738);
INSERT INTO `search_index` VALUES('unit', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('unite', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('unite', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('unite', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('united', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('uniter', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('unites', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('unites', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('uniting', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('universally', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('universe', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('unknowingly', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('unpopular', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('unprepared', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('unread', 65, 1, 1192166922);
INSERT INTO `search_index` VALUES('unread', 69, 1, 1192164182);
INSERT INTO `search_index` VALUES('until', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('until', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('untold', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('upper', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('upper', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('uprising', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('uprisings', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('uranus', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('uranus', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('uranus', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('uranus', 10, 8, 1191288244);
INSERT INTO `search_index` VALUES('uranus', 18, 11, 1191913156);
INSERT INTO `search_index` VALUES('uranus', 19, 4, 1192599904);
INSERT INTO `search_index` VALUES('uranus', 26, 4, 1192162069);
INSERT INTO `search_index` VALUES('uranus', 31, 1, 1191436125);
INSERT INTO `search_index` VALUES('uranus', 35, 8, 1193373158);
INSERT INTO `search_index` VALUES('uranus', 41, 1, 1191436125);
INSERT INTO `search_index` VALUES('uranus', 43, 3, 1191806864);
INSERT INTO `search_index` VALUES('uranus', 47, 22, 1193288711);
INSERT INTO `search_index` VALUES('uranus', 50, 3, 1192842738);
INSERT INTO `search_index` VALUES('uranus', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('use', 17, 2, 1193455700);
INSERT INTO `search_index` VALUES('use', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('use', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('use', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('used', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('used', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('used', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('used', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('used', 65, 1, 1192166922);
INSERT INTO `search_index` VALUES('useful', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('using', 15, 2, 1192409593);
INSERT INTO `search_index` VALUES('using', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('using', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('using', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('usurious', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('usurp', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('utility', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('vacuum', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('valuable', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('valuable', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('value', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('variability', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('variability', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('varies', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('variety', 14, 1, 1192407740);
INSERT INTO `search_index` VALUES('variety', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('variety', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('various', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('various', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('various', 50, 1, 1192842738);
INSERT INTO `search_index` VALUES('various', 78, 1, 1193523912);
INSERT INTO `search_index` VALUES('varying', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('vendors', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('venetian', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('ventured', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('ventures', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('ventures', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('verified', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('vernacular', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('versa', 78, 1, 1193523912);
INSERT INTO `search_index` VALUES('version', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('version', 61, 1, 1191721102);
INSERT INTO `search_index` VALUES('versioning', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('versus', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('very', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('vessels', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('via', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('vice', 78, 1, 1193523912);
INSERT INTO `search_index` VALUES('victory', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('view', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('viewed', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('views', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('viii', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('viiis', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('virtually', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('visible', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('visigoth', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('vision', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('voice', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('voltaire', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('vulnerability', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('waged', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('waiting', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('wales', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('wane', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('wanted', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('wanted', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('war', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('war', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('war', 19, 5, 1192599904);
INSERT INTO `search_index` VALUES('war', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('war', 35, 8, 1193373158);
INSERT INTO `search_index` VALUES('war', 43, 2, 1191806864);
INSERT INTO `search_index` VALUES('war', 44, 3, 1192773711);
INSERT INTO `search_index` VALUES('wars', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('wars', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('wars', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('was', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('was', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('was', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('was', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('was', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('was', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('was', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('was', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('was', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('was', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('watershed', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('watershed', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('watershed', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('watt', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('wave', 10, 10, 1191288244);
INSERT INTO `search_index` VALUES('wave', 16, 2, 1192409969);
INSERT INTO `search_index` VALUES('wave', 17, 4, 1193455700);
INSERT INTO `search_index` VALUES('wave', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('wave', 19, 3, 1192599904);
INSERT INTO `search_index` VALUES('wave', 30, 1, 1191436125);
INSERT INTO `search_index` VALUES('wave', 34, 4, 1193222100);
INSERT INTO `search_index` VALUES('wave', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('wave', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('wave', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('wave', 50, 1, 1192842738);
INSERT INTO `search_index` VALUES('wave', 58, 4, 1191625690);
INSERT INTO `search_index` VALUES('wave', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('waves', 10, 14, 1191288244);
INSERT INTO `search_index` VALUES('waves', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('waves', 18, 8, 1191913156);
INSERT INTO `search_index` VALUES('waves', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('waves', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('waves', 28, 2, 1193295727);
INSERT INTO `search_index` VALUES('waves', 31, 1, 1191436125);
INSERT INTO `search_index` VALUES('waves', 32, 1, 1191436125);
INSERT INTO `search_index` VALUES('waves', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('waves', 41, 1, 1191436125);
INSERT INTO `search_index` VALUES('waves', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('waves', 51, 1, 1191436125);
INSERT INTO `search_index` VALUES('waves', 63, 2, 1192143927);
INSERT INTO `search_index` VALUES('waves', 77, 1, 1192409672);
INSERT INTO `search_index` VALUES('way', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('way', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('way', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('way', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('ways', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('ways', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('ways', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('ways', 14, 1, 1192407740);
INSERT INTO `search_index` VALUES('ways', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('ways', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('ways', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('ways', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('weakened', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('weaknesses', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('wealth', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('wealth', 34, 3, 1193222100);
INSERT INTO `search_index` VALUES('wealth', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('wealth', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('wealthy', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('weather', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('web', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('websites', 65, 1, 1192166922);
INSERT INTO `search_index` VALUES('websites', 70, 1, 1192164182);
INSERT INTO `search_index` VALUES('websites', 72, 1, 1192169925);
INSERT INTO `search_index` VALUES('websites', 73, 1, 1192169776);
INSERT INTO `search_index` VALUES('wedding', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('weight', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('welcome', 4, 2, 1190921420);
INSERT INTO `search_index` VALUES('welcomes', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('well', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('well', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('well', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('well', 47, 4, 1193288711);
INSERT INTO `search_index` VALUES('went', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('went', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('went', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('went', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('went', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('went', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('were', 19, 2, 1192599904);
INSERT INTO `search_index` VALUES('were', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('were', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('west', 37, 3, 1193110752);
INSERT INTO `search_index` VALUES('west', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('western', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('western', 37, 4, 1193110752);
INSERT INTO `search_index` VALUES('western', 44, 4, 1192773711);
INSERT INTO `search_index` VALUES('westphalia', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('what', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('what', 6, 2, 1191885263);
INSERT INTO `search_index` VALUES('what', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('what', 10, 4, 1191288244);
INSERT INTO `search_index` VALUES('what', 12, 1, 1192386602);
INSERT INTO `search_index` VALUES('what', 17, 3, 1193455700);
INSERT INTO `search_index` VALUES('what', 18, 2, 1191913156);
INSERT INTO `search_index` VALUES('what', 19, 3, 1192599904);
INSERT INTO `search_index` VALUES('what', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('what', 28, 2, 1193295727);
INSERT INTO `search_index` VALUES('what', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('what', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('what', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('what', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('what', 63, 2, 1192143927);
INSERT INTO `search_index` VALUES('when', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('when', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('when', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('when', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('when', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('when', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('when', 47, 4, 1193288711);
INSERT INTO `search_index` VALUES('whenever', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('where', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('where', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('where', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('wherein', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('wherein', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('whether', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('whether', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('which', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('which', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('which', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('which', 14, 1, 1192407740);
INSERT INTO `search_index` VALUES('which', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('which', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('which', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('which', 35, 4, 1193373158);
INSERT INTO `search_index` VALUES('which', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('which', 47, 2, 1193288711);
INSERT INTO `search_index` VALUES('which', 78, 1, 1193523912);
INSERT INTO `search_index` VALUES('while', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('while', 18, 2, 1191913156);
INSERT INTO `search_index` VALUES('while', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('while', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('while', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('while', 47, 2, 1193288711);
INSERT INTO `search_index` VALUES('while', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('while', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('while', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('while', 78, 1, 1193523912);
INSERT INTO `search_index` VALUES('who', 6, 1, 1191885263);
INSERT INTO `search_index` VALUES('who', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('who', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('who', 44, 3, 1192773711);
INSERT INTO `search_index` VALUES('who', 47, 2, 1193288711);
INSERT INTO `search_index` VALUES('whole', 17, 2, 1193455700);
INSERT INTO `search_index` VALUES('whole', 50, 1, 1192842738);
INSERT INTO `search_index` VALUES('whose', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('whose', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('why', 10, 2, 1191288244);
INSERT INTO `search_index` VALUES('why', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('why', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('why', 34, 4, 1193222100);
INSERT INTO `search_index` VALUES('why', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('why', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('whys', 75, 1, 1192244327);
INSERT INTO `search_index` VALUES('wide', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('wider', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('widespread', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('wiki', 8, 1, 1190927305);
INSERT INTO `search_index` VALUES('wild', 18, 1, 1191913156);
INSERT INTO `search_index` VALUES('will', 5, 2, 1190923888);
INSERT INTO `search_index` VALUES('will', 6, 2, 1191885263);
INSERT INTO `search_index` VALUES('will', 7, 2, 1190927060);
INSERT INTO `search_index` VALUES('will', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('will', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('will', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('will', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('will', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('will', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('will', 65, 3, 1192166922);
INSERT INTO `search_index` VALUES('will', 78, 3, 1193523912);
INSERT INTO `search_index` VALUES('winners', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('winter', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('wisdom', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('with', 10, 4, 1191288244);
INSERT INTO `search_index` VALUES('with', 17, 9, 1193455700);
INSERT INTO `search_index` VALUES('with', 18, 5, 1191913156);
INSERT INTO `search_index` VALUES('with', 19, 9, 1192599904);
INSERT INTO `search_index` VALUES('with', 28, 3, 1193295727);
INSERT INTO `search_index` VALUES('with', 34, 4, 1193222100);
INSERT INTO `search_index` VALUES('with', 35, 6, 1193373158);
INSERT INTO `search_index` VALUES('with', 37, 7, 1193110752);
INSERT INTO `search_index` VALUES('with', 43, 1, 1191806864);
INSERT INTO `search_index` VALUES('with', 44, 14, 1192773711);
INSERT INTO `search_index` VALUES('with', 47, 10, 1193288711);
INSERT INTO `search_index` VALUES('with', 58, 1, 1191625690);
INSERT INTO `search_index` VALUES('with', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('with', 76, 6, 1192331428);
INSERT INTO `search_index` VALUES('within', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('within', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('within', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('within', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('within', 63, 2, 1192143927);
INSERT INTO `search_index` VALUES('without', 17, 1, 1193455700);
INSERT INTO `search_index` VALUES('without', 19, 2, 1192599904);
INSERT INTO `search_index` VALUES('without', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('women', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('word', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('word', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('work', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('work', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('work', 10, 2, 1191288244);
INSERT INTO `search_index` VALUES('work', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('work', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('work', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('work', 44, 5, 1192773711);
INSERT INTO `search_index` VALUES('work', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('work', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('works', 10, 3, 1191288244);
INSERT INTO `search_index` VALUES('works', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('works', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('works', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('works', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('world', 5, 2, 1190923888);
INSERT INTO `search_index` VALUES('world', 7, 2, 1190927060);
INSERT INTO `search_index` VALUES('world', 10, 1, 1191288244);
INSERT INTO `search_index` VALUES('world', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('world', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('world', 19, 2, 1192599904);
INSERT INTO `search_index` VALUES('world', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('world', 34, 3, 1193222100);
INSERT INTO `search_index` VALUES('world', 35, 2, 1193373158);
INSERT INTO `search_index` VALUES('world', 46, 1, 1191436125);
INSERT INTO `search_index` VALUES('world', 47, 4, 1193288711);
INSERT INTO `search_index` VALUES('world', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('worlds', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('worship', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('worshiped', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('worth', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('would', 10, 2, 1191288244);
INSERT INTO `search_index` VALUES('would', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('would', 35, 4, 1193373158);
INSERT INTO `search_index` VALUES('would', 44, 4, 1192773711);
INSERT INTO `search_index` VALUES('would', 76, 3, 1192331428);
INSERT INTO `search_index` VALUES('write', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('writing', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('written', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('written', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('written', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('written', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('wrong', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('wrongly', 34, 1, 1193222100);
INSERT INTO `search_index` VALUES('xiv', 43, 2, 1191806864);
INSERT INTO `search_index` VALUES('xivth', 19, 2, 1192599904);
INSERT INTO `search_index` VALUES('xivth', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('xivth', 44, 1, 1192773711);
INSERT INTO `search_index` VALUES('xixth', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('xviith', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('xvith', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('xvth', 37, 1, 1193110752);
INSERT INTO `search_index` VALUES('xvth', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('xxth', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('year', 5, 3, 1190923888);
INSERT INTO `search_index` VALUES('year', 6, 4, 1191885263);
INSERT INTO `search_index` VALUES('year', 7, 2, 1190927060);
INSERT INTO `search_index` VALUES('year', 10, 3, 1191288244);
INSERT INTO `search_index` VALUES('year', 12, 3, 1192386602);
INSERT INTO `search_index` VALUES('year', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('year', 18, 3, 1191913156);
INSERT INTO `search_index` VALUES('year', 19, 1, 1192599904);
INSERT INTO `search_index` VALUES('year', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('year', 28, 2, 1193295727);
INSERT INTO `search_index` VALUES('year', 47, 3, 1193288711);
INSERT INTO `search_index` VALUES('year', 63, 1, 1192143927);
INSERT INTO `search_index` VALUES('year', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('years', 10, 7, 1191288244);
INSERT INTO `search_index` VALUES('years', 13, 1, 1192402368);
INSERT INTO `search_index` VALUES('years', 19, 6, 1192599904);
INSERT INTO `search_index` VALUES('years', 26, 1, 1192162069);
INSERT INTO `search_index` VALUES('years', 28, 1, 1193295727);
INSERT INTO `search_index` VALUES('years', 34, 2, 1193222100);
INSERT INTO `search_index` VALUES('years', 35, 4, 1193373158);
INSERT INTO `search_index` VALUES('years', 43, 2, 1191806864);
INSERT INTO `search_index` VALUES('years', 44, 2, 1192773711);
INSERT INTO `search_index` VALUES('years', 47, 6, 1193288711);
INSERT INTO `search_index` VALUES('years', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('yes', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('yet', 5, 1, 1190923888);
INSERT INTO `search_index` VALUES('yet', 7, 1, 1190927060);
INSERT INTO `search_index` VALUES('yet', 35, 1, 1193373158);
INSERT INTO `search_index` VALUES('yet', 47, 1, 1193288711);
INSERT INTO `search_index` VALUES('yet', 65, 1, 1192166922);
INSERT INTO `search_index` VALUES('yet', 76, 1, 1192331428);
INSERT INTO `search_index` VALUES('your', 10, 1, 1191288244);

-- --------------------------------------------------------

--
-- Table structure for table `search_stats`
--

CREATE TABLE `search_stats` (
  `term` varchar(50) NOT NULL,
  `hits` int(11) default NULL,
  PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `search_stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `search_syllable`
--

CREATE TABLE `search_syllable` (
  `syllable` varchar(80) NOT NULL,
  `last_used` int(11) NOT NULL,
  `last_updated` int(11) NOT NULL,
  PRIMARY KEY  (`syllable`),
  KEY `tiki_searchsyl_last_used_idx` (`last_used`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `search_syllable`
--


-- --------------------------------------------------------

--
-- Table structure for table `search_words`
--

CREATE TABLE `search_words` (
  `syllable` varchar(80) NOT NULL,
  `searchword` varchar(80) NOT NULL,
  PRIMARY KEY  (`syllable`,`searchword`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `search_words`
--


-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `expiry` bigint(20) unsigned NOT NULL,
  `sesskey` varchar(32) NOT NULL,
  `expireref` varchar(64) default NULL,
  `session_data` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--


-- --------------------------------------------------------

--
-- Table structure for table `shoutbox`
--

CREATE TABLE `shoutbox` (
  `shout_id` int(11) NOT NULL auto_increment,
  `shout_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `shout_message` varchar(255) NOT NULL,
  `shout_time` bigint(20) NOT NULL,
  `shout_sum` varchar(32) default NULL,
  `shout_ip` varchar(16) default NULL,
  PRIMARY KEY  (`shout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `shoutbox`
--


-- --------------------------------------------------------

--
-- Table structure for table `stars`
--

CREATE TABLE `stars` (
  `content_id` int(11) NOT NULL,
  `update_count` int(11) default NULL,
  `rating` int(11) default NULL,
  KEY `stars_ref` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stars`
--


-- --------------------------------------------------------

--
-- Table structure for table `stars_history`
--

CREATE TABLE `stars_history` (
  `content_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `rating_time` bigint(20) NOT NULL default '0',
  KEY `stars_history_content_ref` (`content_id`),
  KEY `stars_history_user_ref` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stars_history`
--


-- --------------------------------------------------------

--
-- Table structure for table `stats_pageviews`
--

CREATE TABLE `stats_pageviews` (
  `stats_day` bigint(20) NOT NULL,
  `pageviews` bigint(20) default NULL,
  PRIMARY KEY  (`stats_day`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stats_pageviews`
--

INSERT INTO `stats_pageviews` VALUES(1190872800, 76);
INSERT INTO `stats_pageviews` VALUES(1190959200, 63);
INSERT INTO `stats_pageviews` VALUES(1191045600, 30);
INSERT INTO `stats_pageviews` VALUES(1191132000, 40);
INSERT INTO `stats_pageviews` VALUES(1191218400, 15);
INSERT INTO `stats_pageviews` VALUES(1191391200, 8);
INSERT INTO `stats_pageviews` VALUES(1191477600, 2);
INSERT INTO `stats_pageviews` VALUES(1191564000, 14);
INSERT INTO `stats_pageviews` VALUES(1191650400, 49);
INSERT INTO `stats_pageviews` VALUES(1191736800, 42);
INSERT INTO `stats_pageviews` VALUES(1191823200, 91);
INSERT INTO `stats_pageviews` VALUES(1191909600, 11);
INSERT INTO `stats_pageviews` VALUES(1191996000, 37);
INSERT INTO `stats_pageviews` VALUES(1192082400, 87);
INSERT INTO `stats_pageviews` VALUES(1192168800, 52);
INSERT INTO `stats_pageviews` VALUES(1192255200, 46);
INSERT INTO `stats_pageviews` VALUES(1192341600, 63);
INSERT INTO `stats_pageviews` VALUES(1192428000, 31);
INSERT INTO `stats_pageviews` VALUES(1192514400, 43);
INSERT INTO `stats_pageviews` VALUES(1192600800, 4);
INSERT INTO `stats_pageviews` VALUES(1192687200, 73);
INSERT INTO `stats_pageviews` VALUES(1192773600, 33);
INSERT INTO `stats_pageviews` VALUES(1192860000, 162);
INSERT INTO `stats_pageviews` VALUES(1192946400, 46);
INSERT INTO `stats_pageviews` VALUES(1193032800, 37);
INSERT INTO `stats_pageviews` VALUES(1193119200, 4);
INSERT INTO `stats_pageviews` VALUES(1193205600, 65);
INSERT INTO `stats_pageviews` VALUES(1193292000, 72);
INSERT INTO `stats_pageviews` VALUES(1193378400, 28);
INSERT INTO `stats_pageviews` VALUES(1193464800, 10);
INSERT INTO `stats_pageviews` VALUES(1193551200, 4);
INSERT INTO `stats_pageviews` VALUES(1203922800, 2);
INSERT INTO `stats_pageviews` VALUES(1204095600, 15);

-- --------------------------------------------------------

--
-- Table structure for table `stats_referers`
--

CREATE TABLE `stats_referers` (
  `referer` varchar(50) NOT NULL,
  `hits` bigint(20) default NULL,
  `last` bigint(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stats_referers`
--

INSERT INTO `stats_referers` VALUES('www.whois.sc', 3, 1192986093);

-- --------------------------------------------------------

--
-- Table structure for table `stencils`
--

CREATE TABLE `stencils` (
  `stencil_id` int(11) NOT NULL auto_increment,
  `content_id` int(11) NOT NULL,
  `description` varchar(160) default NULL,
  PRIMARY KEY  (`stencil_id`),
  KEY `stencils_stencil_id_idx` (`stencil_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `stencils`
--


-- --------------------------------------------------------

--
-- Table structure for table `stickies`
--

CREATE TABLE `stickies` (
  `sticky_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `notated_content_id` int(11) NOT NULL,
  PRIMARY KEY  (`sticky_id`),
  KEY `tiki_stickies_content_id_idx` (`content_id`),
  KEY `tiki_notated_content_id_idx` (`notated_content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stickies`
--


-- --------------------------------------------------------

--
-- Table structure for table `stickies_sticky_id_seq`
--

CREATE TABLE `stickies_sticky_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stickies_sticky_id_seq`
--

INSERT INTO `stickies_sticky_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `tag_id` int(11) NOT NULL,
  `tag` varchar(64) NOT NULL,
  PRIMARY KEY  (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags`
--


-- --------------------------------------------------------

--
-- Table structure for table `tags_content_map`
--

CREATE TABLE `tags_content_map` (
  `tag_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `tagger_id` int(11) NOT NULL,
  `tagged_on` bigint(20) NOT NULL,
  KEY `tags_content_map_tag_ref` (`tag_id`),
  KEY `tags_content_map_content_ref` (`content_id`),
  KEY `tags_content_map_tagger_id_ref` (`tagger_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags_content_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `tags_tag_id_seq`
--

CREATE TABLE `tags_tag_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags_tag_id_seq`
--

INSERT INTO `tags_tag_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `themes_custom_modules`
--

CREATE TABLE `themes_custom_modules` (
  `name` varchar(40) NOT NULL default '',
  `title` varchar(200) default NULL,
  `data` text,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `themes_custom_modules`
--


-- --------------------------------------------------------

--
-- Table structure for table `themes_layouts`
--

CREATE TABLE `themes_layouts` (
  `module_id` int(11) NOT NULL,
  `title` varchar(255) default NULL,
  `layout` varchar(160) NOT NULL default 'kernel',
  `layout_area` varchar(1) NOT NULL,
  `module_rows` int(11) default NULL,
  `module_rsrc` varchar(250) NOT NULL,
  `params` varchar(255) default NULL,
  `cache_time` bigint(20) default NULL,
  `groups` varchar(255) default NULL,
  `pos` int(11) NOT NULL default '1',
  PRIMARY KEY  (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `themes_layouts`
--

INSERT INTO `themes_layouts` VALUES(1, NULL, 'kernel', 't', NULL, 'bitpackage:kernel/mod_site_title.tpl', NULL, NULL, NULL, 5);
INSERT INTO `themes_layouts` VALUES(2, NULL, 'kernel', 't', NULL, 'bitpackage:kernel/mod_top_menu.tpl', NULL, NULL, NULL, 10);
INSERT INTO `themes_layouts` VALUES(3, NULL, 'kernel', 'l', NULL, 'bitpackage:kernel/mod_package_menu.tpl', NULL, NULL, NULL, 5);
INSERT INTO `themes_layouts` VALUES(4, 'bitweaver', 'kernel', 'r', NULL, 'bitpackage:kernel/mod_bitweaver_info.tpl', NULL, NULL, NULL, 5);
INSERT INTO `themes_layouts` VALUES(5, 'Server Statistics', 'kernel', 'r', NULL, 'bitpackage:kernel/mod_server_stats.tpl', NULL, NULL, 'Admin', 10);
INSERT INTO `themes_layouts` VALUES(6, 'Powered by', 'kernel', 'r', NULL, 'bitpackage:kernel/mod_powered_by.tpl', NULL, NULL, NULL, 15);
INSERT INTO `themes_layouts` VALUES(7, NULL, 'kernel', 'b', NULL, 'bitpackage:kernel/mod_bottom_bar.tpl', NULL, NULL, NULL, 5);
INSERT INTO `themes_layouts` VALUES(8, 'Search', 'kernel', 'l', NULL, 'bitpackage:search/mod_package_search.tpl', NULL, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `themes_layouts_module_id_seq`
--

CREATE TABLE `themes_layouts_module_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `themes_layouts_module_id_seq`
--

INSERT INTO `themes_layouts_module_id_seq` VALUES(8);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_actionlog`
--

CREATE TABLE `tiki_actionlog` (
  `page_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `last_modified` bigint(20) default NULL,
  `title` varchar(160) default NULL,
  `ip` varchar(15) default NULL,
  `comment` varchar(200) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_actionlog`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_articles`
--

CREATE TABLE `tiki_articles` (
  `article_id` int(11) NOT NULL auto_increment,
  `content_id` int(11) NOT NULL,
  `description` text,
  `author_name` varchar(250) default NULL,
  `topic_id` int(11) default NULL,
  `image_attachment_id` int(11) default NULL,
  `publish_date` int(11) default NULL,
  `expire_date` int(11) default NULL,
  `article_type_id` int(11) default NULL,
  `rating` double default NULL,
  `status_id` int(11) default NULL,
  PRIMARY KEY  (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_articles`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_article_status`
--

CREATE TABLE `tiki_article_status` (
  `status_id` int(11) NOT NULL,
  `status_name` varchar(64) default NULL,
  PRIMARY KEY  (`status_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_article_status`
--

INSERT INTO `tiki_article_status` VALUES(0, 'Denied');
INSERT INTO `tiki_article_status` VALUES(100, 'Draft');
INSERT INTO `tiki_article_status` VALUES(200, 'Pending Approval');
INSERT INTO `tiki_article_status` VALUES(300, 'Approved');
INSERT INTO `tiki_article_status` VALUES(400, 'Retired');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_article_topics`
--

CREATE TABLE `tiki_article_topics` (
  `topic_id` int(11) NOT NULL auto_increment,
  `topic_name` varchar(40) default NULL,
  `has_topic_image` varchar(1) default NULL,
  `active` varchar(1) default NULL,
  `created` bigint(20) default NULL,
  PRIMARY KEY  (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_article_topics`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_article_types`
--

CREATE TABLE `tiki_article_types` (
  `article_type_id` int(11) NOT NULL auto_increment,
  `type_name` varchar(50) default NULL,
  `use_ratings` varchar(1) default NULL,
  `show_pre_publ` varchar(1) default NULL,
  `show_post_expire` varchar(1) default 'y',
  `heading_only` varchar(1) default NULL,
  `allow_comments` varchar(1) default 'n',
  `show_image` varchar(1) default 'y',
  `show_avatar` varchar(1) default NULL,
  `show_author` varchar(1) default 'y',
  `show_pubdate` varchar(1) default 'y',
  `show_expdate` varchar(1) default NULL,
  `show_reads` varchar(1) default 'y',
  `show_size` varchar(1) default 'y',
  `creator_edit` varchar(1) default NULL,
  `comment_can_rate_article` varchar(1) default NULL,
  PRIMARY KEY  (`article_type_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tiki_article_types`
--

INSERT INTO `tiki_article_types` VALUES(1, 'Article', NULL, NULL, 'y', NULL, 'n', 'y', NULL, 'y', 'y', NULL, 'y', 'y', NULL, NULL);
INSERT INTO `tiki_article_types` VALUES(2, 'Review', 'y', NULL, 'y', NULL, 'n', 'y', NULL, 'y', 'y', NULL, 'y', 'y', NULL, NULL);
INSERT INTO `tiki_article_types` VALUES(3, 'Event', NULL, NULL, 'n', NULL, 'n', 'y', NULL, 'y', 'y', NULL, 'y', 'y', NULL, NULL);
INSERT INTO `tiki_article_types` VALUES(4, 'Classified', NULL, NULL, 'n', 'y', 'n', 'y', NULL, 'y', 'y', NULL, 'y', 'y', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_attachments`
--

CREATE TABLE `tiki_attachments` (
  `attachment_id` int(11) NOT NULL,
  `attachment_plugin_guid` varchar(16) NOT NULL,
  `content_id` int(11) NOT NULL,
  `foreign_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `pos` int(11) default NULL,
  `hits` int(11) default NULL,
  `error_code` int(11) default NULL,
  `caption` varchar(250) default NULL,
  PRIMARY KEY  (`attachment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_attachments`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_attachments_id_seq`
--

CREATE TABLE `tiki_attachments_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_attachments_id_seq`
--

INSERT INTO `tiki_attachments_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_banning`
--

CREATE TABLE `tiki_banning` (
  `ban_id` int(11) NOT NULL auto_increment,
  `mode` varchar(4) default NULL,
  `title` varchar(200) default NULL,
  `ip1` varchar(3) default NULL,
  `ip2` varchar(3) default NULL,
  `ip3` varchar(3) default NULL,
  `ip4` varchar(3) default NULL,
  `user` varchar(40) default NULL,
  `date_from` datetime NOT NULL,
  `date_to` datetime NOT NULL,
  `use_dates` varchar(1) default NULL,
  `created` bigint(20) default NULL,
  `message` text,
  PRIMARY KEY  (`ban_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_banning`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_banning_sections`
--

CREATE TABLE `tiki_banning_sections` (
  `ban_id` int(11) NOT NULL,
  `section` varchar(100) NOT NULL,
  PRIMARY KEY  (`ban_id`,`section`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_banning_sections`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_blobs`
--

CREATE TABLE `tiki_blobs` (
  `blob_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `blob_size` bigint(20) NOT NULL,
  `blob_name` varchar(250) NOT NULL,
  `blob_data_type` varchar(100) NOT NULL,
  `blob_data` longblob,
  PRIMARY KEY  (`blob_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blobs`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_blogs`
--

CREATE TABLE `tiki_blogs` (
  `blog_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `created` bigint(20) NOT NULL,
  `last_modified` bigint(20) NOT NULL,
  `title` varchar(200) default NULL,
  `description` text,
  `public` varchar(1) default NULL,
  `posts` int(11) default NULL,
  `max_posts` int(11) default NULL,
  `hits` int(11) default NULL,
  `activity` decimal(10,0) default NULL,
  `heading` text,
  `use_find` varchar(1) default NULL,
  `use_title` varchar(1) default NULL,
  `add_date` varchar(1) default NULL,
  `add_poster` varchar(1) default NULL,
  `allow_comments` varchar(1) default NULL,
  PRIMARY KEY  (`blog_id`),
  KEY `tiki_blogs_title_idx` (`title`),
  KEY `tiki_blogs_hits_idx` (`hits`),
  KEY `tiki_blogs_user_id_idx` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_blogs`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_blog_activity`
--

CREATE TABLE `tiki_blog_activity` (
  `blog_id` int(11) NOT NULL,
  `day` bigint(20) NOT NULL,
  `posts` int(11) default NULL,
  PRIMARY KEY  (`blog_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blog_activity`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_blog_posts`
--

CREATE TABLE `tiki_blog_posts` (
  `post_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `blog_id` int(11) NOT NULL,
  `trackbacks_to` text,
  `trackbacks_from` text,
  PRIMARY KEY  (`post_id`),
  KEY `tiki_blog_posts_blog_id_idx` (`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blog_posts`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_blog_posts_post_id_seq`
--

CREATE TABLE `tiki_blog_posts_post_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blog_posts_post_id_seq`
--

INSERT INTO `tiki_blog_posts_post_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_comments`
--

CREATE TABLE `tiki_comments` (
  `comment_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  PRIMARY KEY  (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_comments`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_comments_comment_id_seq`
--

CREATE TABLE `tiki_comments_comment_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_comments_comment_id_seq`
--

INSERT INTO `tiki_comments_comment_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_content`
--

CREATE TABLE `tiki_content` (
  `content_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `modifier_user_id` int(11) NOT NULL,
  `created` bigint(20) NOT NULL,
  `last_modified` bigint(20) NOT NULL,
  `content_type_guid` varchar(16) NOT NULL,
  `format_guid` varchar(16) NOT NULL,
  `hits` int(11) NOT NULL default '0',
  `language` varchar(4) default NULL,
  `title` varchar(160) default NULL,
  `ip` varchar(39) default NULL,
  `data` text,
  PRIMARY KEY  (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_content_id_seq`
--

CREATE TABLE `tiki_content_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content_id_seq`
--

INSERT INTO `tiki_content_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_content_security_map`
--

CREATE TABLE `tiki_content_security_map` (
  `security_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  PRIMARY KEY  (`security_id`,`content_id`),
  UNIQUE KEY `tiki_consec_content_idx` (`content_id`),
  KEY `tiki_consec_security_idx` (`security_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content_security_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_content_templates`
--

CREATE TABLE `tiki_content_templates` (
  `template_id` int(11) NOT NULL auto_increment,
  `content` text,
  `name` varchar(200) default NULL,
  `created` bigint(20) default NULL,
  PRIMARY KEY  (`template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_content_templates`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_content_templates_sections`
--

CREATE TABLE `tiki_content_templates_sections` (
  `template_id` int(11) NOT NULL,
  `section` varchar(160) NOT NULL,
  PRIMARY KEY  (`template_id`,`section`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content_templates_sections`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_content_types`
--

CREATE TABLE `tiki_content_types` (
  `content_type_guid` varchar(16) NOT NULL,
  `content_description` varchar(250) NOT NULL,
  `maintainer_url` varchar(250) default NULL,
  `handler_class` varchar(128) default NULL,
  `handler_package` varchar(128) default NULL,
  `handler_file` varchar(128) default NULL,
  PRIMARY KEY  (`content_type_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content_types`
--

INSERT INTO `tiki_content_types` VALUES('bituser', 'User Information', 'http://www.bitweaver.org', 'BitUser', 'users', 'BitUser.php');
INSERT INTO `tiki_content_types` VALUES('bitpage', 'Wiki Page', 'http://www.bitweaver.org', 'BitPage', 'wiki', 'BitPage.php');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_cookies`
--

CREATE TABLE `tiki_cookies` (
  `cookie_id` int(11) NOT NULL auto_increment,
  `cookie` varchar(255) default NULL,
  PRIMARY KEY  (`cookie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_cookies`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_copyrights`
--

CREATE TABLE `tiki_copyrights` (
  `copyright_id` int(11) NOT NULL auto_increment,
  `page_id` int(11) NOT NULL,
  `title` varchar(200) default NULL,
  `year` bigint(20) default NULL,
  `authors` varchar(200) default NULL,
  `copyright_order` bigint(20) default NULL,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`copyright_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_copyrights`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_dsn`
--

CREATE TABLE `tiki_dsn` (
  `dsn_id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `dsn` varchar(255) default NULL,
  PRIMARY KEY  (`dsn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_dsn`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_dynamic_variables`
--

CREATE TABLE `tiki_dynamic_variables` (
  `name` varchar(40) NOT NULL,
  `data` text,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_dynamic_variables`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_extwiki`
--

CREATE TABLE `tiki_extwiki` (
  `extwiki_id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `extwiki` varchar(255) default NULL,
  PRIMARY KEY  (`extwiki_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_extwiki`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_files`
--

CREATE TABLE `tiki_files` (
  `file_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `storage_path` varchar(250) default NULL,
  `size` int(11) default NULL,
  `mime_type` varchar(64) default NULL,
  PRIMARY KEY  (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_files`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_files_file_id_seq`
--

CREATE TABLE `tiki_files_file_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_files_file_id_seq`
--

INSERT INTO `tiki_files_file_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_fisheye_gallery`
--

CREATE TABLE `tiki_fisheye_gallery` (
  `gallery_id` int(11) NOT NULL,
  `content_id` int(11) default NULL,
  `rows_per_page` int(11) default NULL,
  `cols_per_page` int(11) default NULL,
  `thumbnail_size` varchar(32) default NULL,
  `preview_content_id` int(11) default NULL,
  PRIMARY KEY  (`gallery_id`),
  UNIQUE KEY `tiki_fisheye_gallery_content_idx` (`content_id`),
  KEY `tiki_fisheye_gallery_id_idx` (`gallery_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_fisheye_gallery`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_fisheye_gallery_id_seq`
--

CREATE TABLE `tiki_fisheye_gallery_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_fisheye_gallery_id_seq`
--

INSERT INTO `tiki_fisheye_gallery_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_fisheye_gallery_image_map`
--

CREATE TABLE `tiki_fisheye_gallery_image_map` (
  `gallery_content_id` int(11) NOT NULL,
  `item_content_id` int(11) NOT NULL,
  `position` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_fisheye_gallery_image_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_fisheye_image`
--

CREATE TABLE `tiki_fisheye_image` (
  `image_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `photo_date` bigint(20) default NULL,
  `width` int(11) default NULL,
  `height` int(11) default NULL,
  PRIMARY KEY  (`image_id`),
  UNIQUE KEY `tiki_fisheye_image_content_idx` (`content_id`),
  KEY `tiki_fisheye_image_id_idx` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_fisheye_image`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_history`
--

CREATE TABLE `tiki_history` (
  `page_id` int(11) NOT NULL,
  `version` int(11) NOT NULL,
  `last_modified` bigint(20) NOT NULL,
  `format_guid` varchar(16) NOT NULL,
  `description` varchar(200) default NULL,
  `user_id` varchar(40) default NULL,
  `ip` varchar(15) default NULL,
  `comment` varchar(200) default NULL,
  `data` text,
  PRIMARY KEY  (`page_id`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_history`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_hotwords`
--

CREATE TABLE `tiki_hotwords` (
  `word` varchar(40) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`word`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_hotwords`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_i18n_languages`
--

CREATE TABLE `tiki_i18n_languages` (
  `lang_code` varchar(32) NOT NULL,
  `native_name` varchar(255) default NULL,
  `english_name` varchar(255) default NULL,
  `is_disabled` varchar(1) default NULL,
  PRIMARY KEY  (`lang_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_i18n_languages`
--

INSERT INTO `tiki_i18n_languages` VALUES('ar', 'ﺎﻠﻋﺮﺒﻳﺓ', 'Arabic', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('cs', 'Český', 'Czech', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('da', 'Dansk', 'Danish', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('de', 'Deutsch', 'German', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('en', 'English', 'English', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('en-uk', 'British English', 'British English', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('es', 'Español', 'Spanish', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('el', 'Greek', 'Greek', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('fr', 'Français', 'French', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('hr', 'Hrvatski', 'Croatian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('hu', 'Magyar', 'Hungarian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('it', 'Italiano', 'Italian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('ja', '日本語', 'Japanese', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('ko', '한국ë§?', 'Korean', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('nl', 'Nederlands', 'Dutch', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('no', 'Norwegian', 'Norwegian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('pl', 'Polish', 'Polish', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('pt', 'Português', 'Portuguese', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('pt-br', 'Português Brasileiro', 'Brazilian Portuguese', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('ru', 'Russian', 'Russian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('sb', 'Pijin Solomon', 'Pijin Solomon', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('sk', 'Slovenský', 'Slovak', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('sr', 'СрпÑ?ки', 'Serbian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('sr-latn', 'Srpski', 'Serbian Latin', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('sv', 'Svenska', 'Swedish', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('tw', '中文(ç¹?体字)', 'Traditional Chinese', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('tr', 'Türkçe', 'Turkish', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('tv', 'Tuvaluan', 'Tuvaluan', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('uk', 'УкраїнÑ?ька', 'Ukrainian', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('zh-cn', 'Chinese', 'Chinese', NULL);
INSERT INTO `tiki_i18n_languages` VALUES('ca', 'Catalan', 'Catalan', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_i18n_masters`
--

CREATE TABLE `tiki_i18n_masters` (
  `source_hash` varchar(32) NOT NULL,
  `package` varchar(100) default NULL,
  `created` bigint(20) NOT NULL,
  `source` text,
  PRIMARY KEY  (`source_hash`),
  KEY `tiki_i18n_masters_pkg_idx` (`package`),
  KEY `tiki_i18n_masters_created_idx` (`created`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_i18n_masters`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_i18n_strings`
--

CREATE TABLE `tiki_i18n_strings` (
  `source_hash` varchar(32) NOT NULL,
  `lang_code` varchar(32) NOT NULL,
  `last_modified` bigint(20) NOT NULL,
  `tran` text,
  PRIMARY KEY  (`source_hash`,`lang_code`),
  KEY `tiki_i18n_strings_lang_idx` (`source_hash`),
  KEY `tiki_i18n_strings_modif_idx` (`last_modified`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_i18n_strings`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_i18n_version_map`
--

CREATE TABLE `tiki_i18n_version_map` (
  `source_hash` varchar(32) NOT NULL,
  `version` varchar(32) NOT NULL,
  PRIMARY KEY  (`source_hash`,`version`),
  KEY `tiki_i18n_version_src_idx` (`source_hash`),
  KEY `tiki_i18n_version_ver_idx` (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_i18n_version_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_layouts`
--

CREATE TABLE `tiki_layouts` (
  `user_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `layout` varchar(160) NOT NULL default 'home',
  `layout_position` varchar(1) NOT NULL,
  `module_rows` int(11) NOT NULL,
  `params` varchar(255) default NULL,
  `ord` int(11) NOT NULL default '1',
  KEY `tiki_layouts_user_id_idx` (`user_id`),
  KEY `tiki_layouts_layout_idx` (`layout`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_layouts`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_layouts_modules`
--

CREATE TABLE `tiki_layouts_modules` (
  `module_id` int(11) NOT NULL,
  `availability` varchar(1) default NULL,
  `title` varchar(255) default NULL,
  `cache_time` bigint(20) default NULL,
  `module_rows` int(11) default NULL,
  `params` varchar(255) default NULL,
  `groups` text,
  PRIMARY KEY  (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_layouts_modules`
--

INSERT INTO `tiki_layouts_modules` VALUES(1, NULL, 'bitweaver', NULL, NULL, NULL, NULL);
INSERT INTO `tiki_layouts_modules` VALUES(2, NULL, 'Server Statistics', NULL, NULL, NULL, 'Admin');
INSERT INTO `tiki_layouts_modules` VALUES(3, NULL, 'Powered by', NULL, NULL, NULL, NULL);
INSERT INTO `tiki_layouts_modules` VALUES(4, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tiki_layouts_modules` VALUES(5, NULL, 'Search', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_links`
--

CREATE TABLE `tiki_links` (
  `from_content_id` int(11) NOT NULL,
  `to_content_id` int(11) NOT NULL,
  PRIMARY KEY  (`from_content_id`,`to_content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_links`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_link_cache`
--

CREATE TABLE `tiki_link_cache` (
  `cache_id` int(11) NOT NULL auto_increment,
  `url` varchar(250) default NULL,
  `data` longblob,
  `refresh` bigint(20) default NULL,
  PRIMARY KEY  (`cache_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_link_cache`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_mail_errors`
--

CREATE TABLE `tiki_mail_errors` (
  `url_code` varchar(32) NOT NULL,
  `email` varchar(160) default NULL,
  `user_id` int(11) default NULL,
  `content_id` int(11) default NULL,
  `error_date` bigint(20) default NULL,
  `error_message` text,
  PRIMARY KEY  (`url_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_mail_errors`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_mail_events`
--

CREATE TABLE `tiki_mail_events` (
  `event` varchar(200) default NULL,
  `object` varchar(200) default NULL,
  `email` varchar(200) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_mail_events`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_mail_mailings`
--

CREATE TABLE `tiki_mail_mailings` (
  `content_id` int(11) NOT NULL,
  `queue_date` bigint(20) default NULL,
  `send_date` bigint(20) default NULL,
  `emails_sent` bigint(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_mail_mailings`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_mail_subscriptions`
--

CREATE TABLE `tiki_mail_subscriptions` (
  `email` varchar(160) default NULL,
  `user_id` int(11) default NULL,
  `nl_content_id` int(11) default NULL,
  `sub_code` varchar(36) default NULL,
  `is_valid` varchar(1) default NULL,
  `subscribed_date` bigint(20) default NULL,
  `response_content_id` int(11) default NULL,
  `unsubscribe_all` varchar(1) default NULL,
  `unsubscribe_date` bigint(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_mail_subscriptions`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_menus`
--

CREATE TABLE `tiki_menus` (
  `menu_id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `description` text,
  `type` varchar(1) default NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_menus`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_menu_options`
--

CREATE TABLE `tiki_menu_options` (
  `option_id` int(11) NOT NULL auto_increment,
  `menu_id` int(11) default NULL,
  `type` varchar(1) default NULL,
  `name` varchar(200) default NULL,
  `url` varchar(255) default NULL,
  `position` int(11) default NULL,
  `section` varchar(255) default NULL,
  `perm` varchar(255) default NULL,
  `groupname` varchar(255) default NULL,
  PRIMARY KEY  (`option_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tiki_menu_options`
--

INSERT INTO `tiki_menu_options` VALUES(1, 42, 'o', 'My files', 'usersuserfiles.php', 95, 'feature_userfiles', 'bit_p_userfiles', 'Registered');
INSERT INTO `tiki_menu_options` VALUES(2, 42, 's', 'Blogs', 'list_blogs.php', 450, 'feature_blogs', 'bit_p_read_blog', '');
INSERT INTO `tiki_menu_options` VALUES(3, 42, 'o', 'List blogs', 'list_blogs.php', 455, 'feature_blogs', 'bit_p_read_blog', '');
INSERT INTO `tiki_menu_options` VALUES(4, 42, 'o', 'Rankings', 'rankings.php', 460, 'feature_blogs,feature_blog_rankings', 'bit_p_read_blog', '');
INSERT INTO `tiki_menu_options` VALUES(5, 42, 'o', 'Create/Edit blog', 'edit.php', 465, 'feature_blogs', 'bit_p_read_blog,bit_p_create_blogs', '');
INSERT INTO `tiki_menu_options` VALUES(6, 42, 'o', 'Post', 'post.php', 470, 'feature_blogs', 'bit_p_read_blog,bit_p_blog_post', '');
INSERT INTO `tiki_menu_options` VALUES(7, 42, 'o', 'Admin posts', 'index.php', 475, 'feature_blogs', 'bit_p_read_blog,bit_p_blog_admin', '');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_module_map`
--

CREATE TABLE `tiki_module_map` (
  `module_id` int(11) NOT NULL auto_increment,
  `module_rsrc` varchar(250) NOT NULL,
  PRIMARY KEY  (`module_id`),
  KEY `tiki_module_map_rsrc_idx` (`module_rsrc`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tiki_module_map`
--

INSERT INTO `tiki_module_map` VALUES(1, 'bitpackage:kernel/mod_bitweaver_info.tpl');
INSERT INTO `tiki_module_map` VALUES(4, 'bitpackage:kernel/mod_package_menu.tpl');
INSERT INTO `tiki_module_map` VALUES(3, 'bitpackage:kernel/mod_powered_by.tpl');
INSERT INTO `tiki_module_map` VALUES(2, 'bitpackage:kernel/mod_server_stats.tpl');
INSERT INTO `tiki_module_map` VALUES(5, 'bitpackage:search/mod_package_search.tpl');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_multisites`
--

CREATE TABLE `tiki_multisites` (
  `multisite_id` int(11) NOT NULL auto_increment,
  `server_name` varchar(100) NOT NULL,
  `description` varchar(180) default NULL,
  PRIMARY KEY  (`multisite_id`,`server_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_multisites`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_multisite_preferences`
--

CREATE TABLE `tiki_multisite_preferences` (
  `multisite_id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `value` varchar(250) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_multisite_preferences`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_newsletters`
--

CREATE TABLE `tiki_newsletters` (
  `nl_id` int(11) NOT NULL auto_increment,
  `content_id` int(11) NOT NULL,
  `last_sent` bigint(20) default NULL,
  `allow_user_sub` varchar(1) default 'y',
  `allow_any_sub` varchar(1) default NULL,
  `unsub_msg` varchar(1) default 'y',
  `validate_addr` varchar(1) default 'y',
  `frequency` bigint(20) default NULL,
  PRIMARY KEY  (`nl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_newsletters`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_newsletters_editions`
--

CREATE TABLE `tiki_newsletters_editions` (
  `edition_id` int(11) NOT NULL auto_increment,
  `nl_content_id` int(11) NOT NULL,
  `is_draft` varchar(1) default NULL,
  `reply_to` varchar(160) default NULL,
  `content_id` int(11) NOT NULL,
  PRIMARY KEY  (`edition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_newsletters_editions`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_nexus_menus`
--

CREATE TABLE `tiki_nexus_menus` (
  `menu_id` int(11) NOT NULL auto_increment,
  `plugin_guid` varchar(16) NOT NULL,
  `title` varchar(128) default NULL,
  `description` varchar(255) default NULL,
  `type` varchar(16) default NULL,
  `editable` int(11) default '0',
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_nexus_menus`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_nexus_menu_items`
--

CREATE TABLE `tiki_nexus_menu_items` (
  `item_id` int(11) NOT NULL auto_increment,
  `menu_id` int(11) default '0',
  `parent_id` int(11) default NULL,
  `ext_menu` int(11) default NULL,
  `pos` int(11) default NULL,
  `title` varchar(128) default NULL,
  `hint` varchar(255) default NULL,
  `rsrc` varchar(255) default NULL,
  `rsrc_type` varchar(16) default NULL,
  `perm` varchar(128) default NULL,
  PRIMARY KEY  (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_nexus_menu_items`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_nexus_plugins`
--

CREATE TABLE `tiki_nexus_plugins` (
  `plugin_guid` varchar(16) NOT NULL,
  `plugin_type` varchar(16) NOT NULL,
  `is_active` varchar(1) NOT NULL default 'y',
  `plugin_description` varchar(250) default NULL,
  `maintainer_url` varchar(250) default NULL,
  PRIMARY KEY  (`plugin_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_nexus_plugins`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_pages`
--

CREATE TABLE `tiki_pages` (
  `page_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `version` int(11) NOT NULL,
  `page_size` int(11) default '0',
  `description` varchar(200) default NULL,
  `comment` varchar(200) default NULL,
  `flag` varchar(1) default NULL,
  `points` int(11) default NULL,
  `votes` int(11) default NULL,
  `cache` text,
  `wiki_cache` bigint(20) default NULL,
  `cache_timestamp` bigint(20) default NULL,
  `page_rank` decimal(10,0) default NULL,
  PRIMARY KEY  (`page_id`),
  KEY `tiki_pages_content_idx` (`content_id`),
  KEY `tiki_pages_page_rank_idx` (`page_rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_pages`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_pages_page_id_seq`
--

CREATE TABLE `tiki_pages_page_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_pages_page_id_seq`
--

INSERT INTO `tiki_pages_page_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_pageviews`
--

CREATE TABLE `tiki_pageviews` (
  `day` bigint(20) NOT NULL,
  `pageviews` bigint(20) default NULL,
  PRIMARY KEY  (`day`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_pageviews`
--

INSERT INTO `tiki_pageviews` VALUES(1204527600, 12);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_page_footnotes`
--

CREATE TABLE `tiki_page_footnotes` (
  `user_id` varchar(40) NOT NULL,
  `page_id` int(11) NOT NULL,
  `data` text,
  PRIMARY KEY  (`user_id`),
  KEY `tiki_page_footnotes_page_idx` (`page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_page_footnotes`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_plugins`
--

CREATE TABLE `tiki_plugins` (
  `plugin_guid` varchar(16) NOT NULL,
  `plugin_type` varchar(16) NOT NULL,
  `is_active` varchar(1) NOT NULL default 'y',
  `plugin_description` varchar(250) default NULL,
  `maintainer_url` varchar(250) default NULL,
  PRIMARY KEY  (`plugin_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_plugins`
--

INSERT INTO `tiki_plugins` VALUES('adsense', 'data', 'n', 'This plugin adds Adsense Code to page.', NULL);
INSERT INTO `tiki_plugins` VALUES('bitfile', 'storage', 'y', 'Upload File To Server', NULL);
INSERT INTO `tiki_plugins` VALUES('bithtml', 'format', 'y', 'HTML Syntax Format Parser', NULL);
INSERT INTO `tiki_plugins` VALUES('comment', 'data', 'y', 'This plugin allows Comments (Text that will not be displayed) to be added to a page.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataaddtabs', 'data', 'y', 'Will join the contents from several sources in a Tabbed Interface.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataagentinfo', 'data', 'y', 'This plugin will display the viewer''s IP address, the Browser they are using, or the info about the site''s Server software.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataarticle', 'data', 'n', 'This plugin will display the data from a single field in the specified Article.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataarticles', 'data', 'y', 'This plugin will display several Articles.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataattachment', 'data', 'y', 'Display attachment in content', NULL);
INSERT INTO `tiki_plugins` VALUES('dataavatar', 'data', 'n', 'This plugin will display a User''s Avatar as a Link to a page.', NULL);
INSERT INTO `tiki_plugins` VALUES('databacklinks', 'data', 'n', 'This plugin will list all Wiki pages which contains a link to the specified page.', NULL);
INSERT INTO `tiki_plugins` VALUES('datablog', 'data', 'y', 'This plugin will display several posts from a blog.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataclock', 'data', 'n', 'This plugin allows you to insert flexible date/time strings into your pages.', NULL);
INSERT INTO `tiki_plugins` VALUES('datacode', 'data', 'y', 'Displays the Source Code Snippet between {Code} blocks.', NULL);
INSERT INTO `tiki_plugins` VALUES('datacopyright', 'data', 'x', 'This plugin is used to insert CopyRight notices.', NULL);
INSERT INTO `tiki_plugins` VALUES('datacountdown', 'data', 'y', 'Displays a Count-Down until a date:time is reached - then - negative numbers indicate how long it has been since that date. The Count-Down is displayed in the format of (X days, X hours, X minutes and X seconds).', NULL);
INSERT INTO `tiki_plugins` VALUES('datadiv', 'data', 'y', 'This plugin allows you to easily create a div with a number of optional CSS parameters.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataexample', 'data', 'n', 'This Plugin is an Example that does nothing. It functions as a template for the creation of new plugins.', NULL);
INSERT INTO `tiki_plugins` VALUES('datafreemind', 'data', 'y', 'Displays a Freemind mindmap', NULL);
INSERT INTO `tiki_plugins` VALUES('datagauge', 'data', 'y', 'This plugin displays a graphical GAUGE.', NULL);
INSERT INTO `tiki_plugins` VALUES('datainclude', 'data', 'y', 'This plugin is used to include the contents of one Wiki page in another Wiki page.', NULL);
INSERT INTO `tiki_plugins` VALUES('datalang', 'data', 'n', 'This plugin will attempt to translate the text between the {LANG} blocks to the current language. If the translation fails - nothing is displayed.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataledgertable', 'data', 'n', 'This Plugin creates a ledger-like table with even/odd row colors, optional top- or left-placed headers, and support for row/column spans.', NULL);
INSERT INTO `tiki_plugins` VALUES('datamaketoc', 'data', 'y', 'Will create a table of contents of the WikiPage based on the headings below.', NULL);
INSERT INTO `tiki_plugins` VALUES('datamapquest', 'data', 'y', 'Creates an Icon link to MapQuest and/or a link to a Specific Map based on an Address.', NULL);
INSERT INTO `tiki_plugins` VALUES('datamodule', 'data', 'n', 'Display a module block in content', NULL);
INSERT INTO `tiki_plugins` VALUES('datamqdir', 'data', 'y', 'Creates an Icon link to MapQuest with a form to get Directions from MapQuest based on a Destination Address.', NULL);
INSERT INTO `tiki_plugins` VALUES('dataobject', 'data', 'y', 'This plugin displays a Flash, Tcl or Java applet/object.', NULL);
INSERT INTO `tiki_plugins` VALUES('datapluginhelp', 'data', 'n', 'This plugin will display the plugin''s Help.', NULL);
INSERT INTO `tiki_plugins` VALUES('datapoll', 'data', 'y', 'This plugin will display the selected Poll and allow users with permission to vote.', NULL);
INSERT INTO `tiki_plugins` VALUES('datarss', 'data', 'y', 'Display RSS Feeds', NULL);
INSERT INTO `tiki_plugins` VALUES('datasf', 'data', 'y', 'Creates a link to SourceForge. Can link to the Bugs / RFEs / Patches / Support Index pages or individual items on those pages.', NULL);
INSERT INTO `tiki_plugins` VALUES('datasort', 'data', 'n', 'This plugin sorts operates on lines of text - not the text in the lines. Every line between the ~np~{SORT}~/np~ blocks -  including the lines the blocks are on - is sorted.', NULL);
INSERT INTO `tiki_plugins` VALUES('datasplit', 'data', 'n', 'This plugin is used to split a page in two or more columns using __-~045~-__ as a seperator.', NULL);
INSERT INTO `tiki_plugins` VALUES('datatitlesearch', 'data', 'n', 'This plugin search the titles of all pages in this wiki.', NULL);
INSERT INTO `tiki_plugins` VALUES('datatoc', 'data', 'y', 'Display a Table Of Contents for Structures', NULL);
INSERT INTO `tiki_plugins` VALUES('datatranslated', 'data', 'n', 'This plugin is used to create a link to a page that contains a translation. The link can be shown as an Icon for the country or as an abreviation for the language.', NULL);
INSERT INTO `tiki_plugins` VALUES('datausercount', 'data', 'n', 'Will show the number of users. If a Group Name can be included to filter the Groups.', NULL);
INSERT INTO `tiki_plugins` VALUES('datauserlink', 'data', 'n', 'Will show a link to the userpage', NULL);
INSERT INTO `tiki_plugins` VALUES('datauserlist', 'data', 'n', 'This plugin will displays an alphabetically sorted list of registered users. A Group Name can be included to filter Groups to be listed.', NULL);
INSERT INTO `tiki_plugins` VALUES('datawikigraph', 'data', 'n', 'Inserts a graph for visual navigation. The graph shows the page and every page that can be reached from that page.', NULL);
INSERT INTO `tiki_plugins` VALUES('datawikilist', 'data', 'n', 'Displays an alphabetically sorted list of WikiPages', NULL);
INSERT INTO `tiki_plugins` VALUES('dropdown', 'data', 'y', 'This plugin creates a expandable box of text.. All text should be entered between the {DD} blocks.', NULL);
INSERT INTO `tiki_plugins` VALUES('lulu', 'storage', 'n', 'Lulu Content ID', NULL);
INSERT INTO `tiki_plugins` VALUES('markdown', 'format', 'n', 'This parser allows you to use plain text, which is then converted to HTML. For the full syntax, please view <a href="http://daringfireball.net/projects/markdown/syntax">Markdown Syntax</a>', NULL);
INSERT INTO `tiki_plugins` VALUES('pbase', 'storage', 'n', 'PBase Image ID', NULL);
INSERT INTO `tiki_plugins` VALUES('pearwiki', 'format', 'n', 'Pear Wiki Syntax Format Parser. Requires Text_Wiki Pear extension. If you are running linux you can try running: su -c ''pear install Text_Wiki''. More info <a href="http://wiki.ciaweb.net/yawiki/index.php?area=Text_Wiki&amp;page=SamplePage">here</a>', NULL);
INSERT INTO `tiki_plugins` VALUES('pearwiki_tiki', 'format', 'n', 'Pear Wiki Parser for TikiWiki Syntax. Requires Text_Wiki Pear extension. More info <a href="http://wiki.ciaweb.net/yawiki/index.php?area=Text_Wiki&amp;page=SamplePage">here</a>', NULL);
INSERT INTO `tiki_plugins` VALUES('spytext', 'data', 'y', 'Allows text to be stored that is only visible to a List of Spys or to a Spy Agency (Group). To anyone else (except an Admin) the text is not be visible.', NULL);
INSERT INTO `tiki_plugins` VALUES('tikiwiki', 'format', 'y', 'TikiWiki Syntax Format Parser', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_preferences`
--

CREATE TABLE `tiki_preferences` (
  `name` varchar(40) NOT NULL,
  `package` varchar(100) default NULL,
  `value` varchar(250) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_preferences`
--

INSERT INTO `tiki_preferences` VALUES('package_users', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('package_liberty', 'liberty', 'y');
INSERT INTO `tiki_preferences` VALUES('package_articles', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('package_blogs', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('package_fisheye', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('package_gatekeeper', 'gatekeeper', 'y');
INSERT INTO `tiki_preferences` VALUES('package_kernel', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('package_languages', 'languages', 'y');
INSERT INTO `tiki_preferences` VALUES('package_pdf', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_nexus', 'nexus', 'y');
INSERT INTO `tiki_preferences` VALUES('package_pigeonholes', 'pigeonholes', 'y');
INSERT INTO `tiki_preferences` VALUES('package_quicktags', 'quicktags', 'y');
INSERT INTO `tiki_preferences` VALUES('package_quota', 'quota', 'y');
INSERT INTO `tiki_preferences` VALUES('package_rss', 'rss', 'y');
INSERT INTO `tiki_preferences` VALUES('package_search', 'search', 'y');
INSERT INTO `tiki_preferences` VALUES('package_shoutbox', 'shoutbox', 'y');
INSERT INTO `tiki_preferences` VALUES('package_stats', 'stats', 'y');
INSERT INTO `tiki_preferences` VALUES('package_stickies', 'stickies', 'y');
INSERT INTO `tiki_preferences` VALUES('package_themes', 'themes', 'y');
INSERT INTO `tiki_preferences` VALUES('package_wiki', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('bitIndex', '', 'wiki');
INSERT INTO `tiki_preferences` VALUES('package_phpbb', '', 'y');
INSERT INTO `tiki_preferences` VALUES('webserverauth', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('auth_create_user_auth', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('auth_create_gBitDbUser', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_adminpass', 'users', '');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_adminuser', 'users', '');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_basedn', 'users', '');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_groupattr', 'users', 'cn');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_groupdn', 'users', '');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_groupoc', 'users', 'groupOfUniqueNames');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_host', 'users', 'localhost');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_memberattr', 'users', 'uniqueMember');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_memberisdn', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_port', 'users', '389');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_scope', 'users', 'sub');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_userattr', 'users', 'uid');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_userdn', 'users', '');
INSERT INTO `tiki_preferences` VALUES('auth_ldap_useroc', 'users', 'inetOrgPerson');
INSERT INTO `tiki_preferences` VALUES('auth_method', 'users', 'tiki');
INSERT INTO `tiki_preferences` VALUES('auth_skip_admin', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('allowRegister', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_userfiles', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('forgotPass', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('eponymousGroups', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('modallgroups', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('pass_chr_num', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('pass_due', 'users', '999');
INSERT INTO `tiki_preferences` VALUES('registerPasscode', 'users', '');
INSERT INTO `tiki_preferences` VALUES('rememberme', 'users', 'disabled');
INSERT INTO `tiki_preferences` VALUES('remembertime', 'users', '7200');
INSERT INTO `tiki_preferences` VALUES('rnd_num_reg', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('userfiles_quota', 'users', '30');
INSERT INTO `tiki_preferences` VALUES('uf_use_db', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('uf_use_dir', 'users', '');
INSERT INTO `tiki_preferences` VALUES('useRegisterPasscode', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('validateUsers', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('validateEmail', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('min_pass_length', 'users', '4');
INSERT INTO `tiki_preferences` VALUES('feature_clear_passwords', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_custom_home', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_user_bookmarks', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_tasks', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_usermenu', 'users', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_userPreferences', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('display_name', 'users', 'real_name');
INSERT INTO `tiki_preferences` VALUES('change_language', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('case_sensitive_login', 'users', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_user_watches', 'common', 'n');
INSERT INTO `tiki_preferences` VALUES('cacheimages', 'liberty', 'n');
INSERT INTO `tiki_preferences` VALUES('cachepages', 'liberty', 'n');
INSERT INTO `tiki_preferences` VALUES('default_format', 'liberty', 'tikiwiki');
INSERT INTO `tiki_preferences` VALUES('liberty_auto_display_attachment_thumbs', 'liberty', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_author', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_date', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_img', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_reads', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_size', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_title', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_topic', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_type', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('art_list_expire', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('max_articles', 'articles', '10');
INSERT INTO `tiki_preferences` VALUES('feature_cms_rankings', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_article_submissions', 'articles', 'y');
INSERT INTO `tiki_preferences` VALUES('article_description_length', 'articles', '500');
INSERT INTO `tiki_preferences` VALUES('article_date_threshold', 'articles', 'week');
INSERT INTO `tiki_preferences` VALUES('rss_articles', 'rss', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_activity', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_created', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_description', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_lastmodif', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_order', 'blogs', 'created_desc');
INSERT INTO `tiki_preferences` VALUES('blog_list_posts', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_title', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_list_user', 'blogs', 'n');
INSERT INTO `tiki_preferences` VALUES('blog_list_visits', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('blog_spellcheck', 'blogs', 'n');
INSERT INTO `tiki_preferences` VALUES('blog_categ', 'blogs', 'n');
INSERT INTO `tiki_preferences` VALUES('blog_parent_categ', 'blogs', '0');
INSERT INTO `tiki_preferences` VALUES('feature_blogposts_comments', 'blogs', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_blog_rankings', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_blogs', 'blogs', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_list_title', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_list_created', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_list_user', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_list_hits', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_list_thumbnail', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_list_thumbnail_size', 'fisheye', 'small');
INSERT INTO `tiki_preferences` VALUES('fisheye_gallery_list_title', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_gallery_list_description', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_gallery_list_image_titles', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_gallery_default_rows_per_page', 'fisheye', '5');
INSERT INTO `tiki_preferences` VALUES('fisheye_gallery_default_cols_per_page', 'fisheye', '3');
INSERT INTO `tiki_preferences` VALUES('fisheye_gallery_default_thumbnail_size', 'fisheye', 'small');
INSERT INTO `tiki_preferences` VALUES('fisheye_image_list_title', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_image_list_description', 'fisheye', 'y');
INSERT INTO `tiki_preferences` VALUES('fisheye_image_default_thumbnail_size', 'fisheye', 'medium');
INSERT INTO `tiki_preferences` VALUES('fisheye_menu_text', 'fisheye', 'Image Galleries');
INSERT INTO `tiki_preferences` VALUES('gatekeeper_default_ordering', 'gatekeeper', 'title_desc');
INSERT INTO `tiki_preferences` VALUES('gatekeeper_list_content_id', 'gatekeeper', 'y');
INSERT INTO `tiki_preferences` VALUES('gatekeeper_list_title', 'gatekeeper', 'y');
INSERT INTO `tiki_preferences` VALUES('gatekeeper_list_description', 'gatekeeper', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_help', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wikihelp', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_helpnotes', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('short_date_format', 'kernel', '%d %b %Y');
INSERT INTO `tiki_preferences` VALUES('short_time_format', 'kernel', '%H:%M %Z');
INSERT INTO `tiki_preferences` VALUES('siteTitle', '', 'mundaneastrology.net');
INSERT INTO `tiki_preferences` VALUES('centralized_upload_dir', 'kernel', 'storage');
INSERT INTO `tiki_preferences` VALUES('tmpDir', 'kernel', 'temp');
INSERT INTO `tiki_preferences` VALUES('use_proxy', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('proxy_host', 'kernel', '');
INSERT INTO `tiki_preferences` VALUES('proxy_port', 'kernel', '');
INSERT INTO `tiki_preferences` VALUES('user_assigned_modules', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('http_domain', 'kernel', '');
INSERT INTO `tiki_preferences` VALUES('http_port', 'kernel', '80');
INSERT INTO `tiki_preferences` VALUES('http_prefix', 'kernel', '/');
INSERT INTO `tiki_preferences` VALUES('https_domain', 'kernel', '');
INSERT INTO `tiki_preferences` VALUES('https_login', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('https_login_required', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('https_port', 'kernel', '443');
INSERT INTO `tiki_preferences` VALUES('https_prefix', 'kernel', '/');
INSERT INTO `tiki_preferences` VALUES('feature_bot_bar', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_top_bar', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_banning', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_contact', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_jstabs', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('contact_user', 'kernel', 'admin');
INSERT INTO `tiki_preferences` VALUES('count_admin_pvs', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('direct_pagination', 'kernel', 'n');
INSERT INTO `tiki_preferences` VALUES('display_timezone', 'kernel', 'UTC');
INSERT INTO `tiki_preferences` VALUES('long_date_format', 'kernel', '%A %d of %B, %Y');
INSERT INTO `tiki_preferences` VALUES('long_time_format', 'kernel', '%H:%M:%S %Z');
INSERT INTO `tiki_preferences` VALUES('feature_left_column', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_right_column', 'kernel', 'y');
INSERT INTO `tiki_preferences` VALUES('maxRecords', 'kernel', '10');
INSERT INTO `tiki_preferences` VALUES('language', 'kernel', 'en');
INSERT INTO `tiki_preferences` VALUES('sender_email', 'kernel', '');
INSERT INTO `tiki_preferences` VALUES('urlIndex', 'kernel', '');
INSERT INTO `tiki_preferences` VALUES('feature_bidi', 'Themes', 'n');
INSERT INTO `tiki_preferences` VALUES('slide_style', 'Themes', 'native');
INSERT INTO `tiki_preferences` VALUES('style', 'Themes', 'native');
INSERT INTO `tiki_preferences` VALUES('feature_theme_control', 'Themes', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_top_bar_dropdown', 'Themes', 'y');
INSERT INTO `tiki_preferences` VALUES('calendar_week_offset', 'calendar', '7');
INSERT INTO `tiki_preferences` VALUES('calendar_hour_fraction', 'calendar', '1');
INSERT INTO `tiki_preferences` VALUES('calendar_user_prefs', 'calendar', 'y');
INSERT INTO `tiki_preferences` VALUES('calendar_day_start', 'calendar', '0');
INSERT INTO `tiki_preferences` VALUES('calendar_day_end', 'calendar', '24');
INSERT INTO `tiki_preferences` VALUES('feature_babelfish', 'languages', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_babelfish_logo', 'languages', 'n');
INSERT INTO `tiki_preferences` VALUES('record_untranslated', 'languages', 'y');
INSERT INTO `tiki_preferences` VALUES('display_pigeonhole_members', 'pigeonholes', 'y');
INSERT INTO `tiki_preferences` VALUES('quota_default_ordering', 'quota', 'title_desc');
INSERT INTO `tiki_preferences` VALUES('quota_list_content_id', 'quota', 'y');
INSERT INTO `tiki_preferences` VALUES('quota_list_title', 'quota', 'y');
INSERT INTO `tiki_preferences` VALUES('quota_list_description', 'quota', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_search_stats', 'search', 'n');
INSERT INTO `tiki_preferences` VALUES('search_min_wordlength', 'search', '3');
INSERT INTO `tiki_preferences` VALUES('search_max_syllwords', 'search', '100');
INSERT INTO `tiki_preferences` VALUES('search_lru_purge_rate', 'search', '5');
INSERT INTO `tiki_preferences` VALUES('search_lru_length', 'search', '100');
INSERT INTO `tiki_preferences` VALUES('search_syll_age', 'search', '48');
INSERT INTO `tiki_preferences` VALUES('shoutbox_autolink', 'shoutbox', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_referer_stats', '', 'y');
INSERT INTO `tiki_preferences` VALUES('anonCanEdit', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_autolinks', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_backlinks', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_dump', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_history', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_lastChanges', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_likePages', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_allow_dup_wiki_page_names', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_listPages', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_page_title', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_ranking', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_sandbox', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_warn_on_edit', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_attachments', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_books', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_comments', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_description', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_discuss', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_footnotes', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_icache', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_monosp', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_multiprint', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_notepad', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_generate_pdf', 'wiki', '');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_pictures', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_plurals', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_rankings', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_tables', 'wiki', 'new');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_templates', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_undo', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wiki_usrlock', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('feature_wikiwords', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('keep_versions', 'wiki', '1');
INSERT INTO `tiki_preferences` VALUES('maxVersions', 'wiki', '0');
INSERT INTO `tiki_preferences` VALUES('w_use_db', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('w_use_dir', 'wiki', '');
INSERT INTO `tiki_preferences` VALUES('warn_on_edit_time', 'wiki', '2');
INSERT INTO `tiki_preferences` VALUES('wiki_bot_bar', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('wiki_cache', 'wiki', '0');
INSERT INTO `tiki_preferences` VALUES('wiki_creator_admin', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('wiki_feature_copyrights', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('wiki_forum', 'wiki', '');
INSERT INTO `tiki_preferences` VALUES('wiki_forum_id', 'wiki', '');
INSERT INTO `tiki_preferences` VALUES('wiki_left_column', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_backlinks', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_comment', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_creator', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_hits', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_lastmodif', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_lastver', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_links', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_name', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_size', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_status', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_user', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_list_versions', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_page_regex', 'wiki', 'strict');
INSERT INTO `tiki_preferences` VALUES('wiki_right_column', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wiki_spellcheck', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('wiki_top_bar', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('wiki_uses_slides', 'wiki', 'n');
INSERT INTO `tiki_preferences` VALUES('wikibook_show_path', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wikibook_show_navigation', 'wiki', 'y');
INSERT INTO `tiki_preferences` VALUES('wikiHomePage', 'wiki', 'Welcome');
INSERT INTO `tiki_preferences` VALUES('wikiLicensePage', 'wiki', '');
INSERT INTO `tiki_preferences` VALUES('wikiSubmitNotice', 'wiki', '');
INSERT INTO `tiki_preferences` VALUES('cookie_path', '', '/compendium/bitweaver1/');
INSERT INTO `tiki_preferences` VALUES('bitdomain', '', '/');
INSERT INTO `tiki_preferences` VALUES('package_calendar', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_chatterbox', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_galaxia', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_gallery2', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_hotwords', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_install', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_messu', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_multisites', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_smileys', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_storage', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_temp', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_tinymce', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_util', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_xmlrpc', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_essential', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_fame&infamy', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_images', '', 'n');
INSERT INTO `tiki_preferences` VALUES('package_timelines', '', 'n');
INSERT INTO `tiki_preferences` VALUES('site_slogan', '', 'History Politics Astrology 4500bc-2384 ');
INSERT INTO `tiki_preferences` VALUES('bitlanguage', '', 'en');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_programmed_content`
--

CREATE TABLE `tiki_programmed_content` (
  `p_id` int(11) NOT NULL auto_increment,
  `content_id` int(11) NOT NULL,
  `publish_date` bigint(20) NOT NULL,
  `data` text,
  PRIMARY KEY  (`p_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_programmed_content`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_quicktags`
--

CREATE TABLE `tiki_quicktags` (
  `tag_id` int(11) NOT NULL auto_increment,
  `format_guid` varchar(16) NOT NULL,
  `tagpos` int(11) default NULL,
  `taglabel` varchar(255) default NULL,
  `taginsert` varchar(255) default NULL,
  `tagicon` varchar(255) default NULL,
  PRIMARY KEY  (`tag_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=156 ;

--
-- Dumping data for table `tiki_quicktags`
--

INSERT INTO `tiki_quicktags` VALUES(1, 'markdown', 5, 'bold', '__text__', 'bold');
INSERT INTO `tiki_quicktags` VALUES(2, 'markdown', 10, 'italic', '_text_', 'italic');
INSERT INTO `tiki_quicktags` VALUES(3, 'markdown', 30, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(4, 'markdown', 35, 'bullet list', '* text', 'list_bullet');
INSERT INTO `tiki_quicktags` VALUES(5, 'markdown', 40, 'enumerated list', '1. text', 'list_enum');
INSERT INTO `tiki_quicktags` VALUES(6, 'markdown', 55, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(7, 'markdown', 60, 'large heading', '# text', 'h1');
INSERT INTO `tiki_quicktags` VALUES(8, 'markdown', 65, 'medium heading', '## text', 'h2');
INSERT INTO `tiki_quicktags` VALUES(9, 'markdown', 70, 'small heading', '### text', 'h3');
INSERT INTO `tiki_quicktags` VALUES(10, 'markdown', 75, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(11, 'markdown', 90, 'horizontal line', '---', 'hr');
INSERT INTO `tiki_quicktags` VALUES(12, 'markdown', 105, 'newline', '', '');
INSERT INTO `tiki_quicktags` VALUES(13, 'markdown', 110, 'image', '{img src= width= height= align= desc= link= }', 'image');
INSERT INTO `tiki_quicktags` VALUES(14, 'markdown', 115, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(15, 'markdown', 120, 'table', 'use html table', 'table');
INSERT INTO `tiki_quicktags` VALUES(16, 'markdown', 130, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(17, 'markdown', 135, 'wiki link', '((text))', 'wiki_link');
INSERT INTO `tiki_quicktags` VALUES(18, 'markdown', 140, 'external link', '[text](http://example.com)', 'ext_link');
INSERT INTO `tiki_quicktags` VALUES(19, 'markdown', 145, 'rss feed', '{rss id= }', 'rss');
INSERT INTO `tiki_quicktags` VALUES(20, 'markdown', 150, 'tagline', '{cookie}', 'tagline');
INSERT INTO `tiki_quicktags` VALUES(21, 'markdown', 155, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(22, 'markdown', 170, 'table of contents (links to headings in page)', '{maketoc}', 'maketoc');
INSERT INTO `tiki_quicktags` VALUES(23, 'markdown', 175, 'table of contents (if part of a book)', '{toc}', 'toc');
INSERT INTO `tiki_quicktags` VALUES(24, 'pearwiki_tiki', 5, 'bold', '__text__', 'bold');
INSERT INTO `tiki_quicktags` VALUES(25, 'pearwiki_tiki', 10, 'italic', '''''text''''', 'italic');
INSERT INTO `tiki_quicktags` VALUES(26, 'pearwiki_tiki', 15, 'underline', '===text===', 'underline');
INSERT INTO `tiki_quicktags` VALUES(27, 'pearwiki_tiki', 20, 'colored text', '~~red:text~~', 'colored_text');
INSERT INTO `tiki_quicktags` VALUES(28, 'pearwiki_tiki', 25, 'colored background', '++yellow:text++', 'colored_background');
INSERT INTO `tiki_quicktags` VALUES(29, 'pearwiki_tiki', 30, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(30, 'pearwiki_tiki', 35, 'bullet list', '*text', 'list_bullet');
INSERT INTO `tiki_quicktags` VALUES(31, 'pearwiki_tiki', 40, 'enumerated list', '#text', 'list_enum');
INSERT INTO `tiki_quicktags` VALUES(32, 'pearwiki_tiki', 45, 'indent list without bullet or number', '+text', 'list_indent');
INSERT INTO `tiki_quicktags` VALUES(33, 'pearwiki_tiki', 50, 'term and definition list', ';term:definition', 'list_def');
INSERT INTO `tiki_quicktags` VALUES(34, 'pearwiki_tiki', 55, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(35, 'pearwiki_tiki', 60, 'large heading', '!text', 'h1');
INSERT INTO `tiki_quicktags` VALUES(36, 'pearwiki_tiki', 65, 'medium heading', '!!text', 'h2');
INSERT INTO `tiki_quicktags` VALUES(37, 'pearwiki_tiki', 70, 'small heading', '!!!text', 'h3');
INSERT INTO `tiki_quicktags` VALUES(38, 'pearwiki_tiki', 75, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(39, 'pearwiki_tiki', 80, 'title bar', '-=text=-', 'title_bar');
INSERT INTO `tiki_quicktags` VALUES(40, 'pearwiki_tiki', 85, 'box', '^text^', 'box');
INSERT INTO `tiki_quicktags` VALUES(41, 'pearwiki_tiki', 90, 'horizontal line', '---', 'hr');
INSERT INTO `tiki_quicktags` VALUES(42, 'pearwiki_tiki', 95, 'create a new page in a multi-page post', '...page...', 'new_page');
INSERT INTO `tiki_quicktags` VALUES(43, 'pearwiki_tiki', 100, 'center text', '::text::', 'align_center');
INSERT INTO `tiki_quicktags` VALUES(44, 'pearwiki_tiki', 105, 'newline', '', '');
INSERT INTO `tiki_quicktags` VALUES(45, 'pearwiki_tiki', 110, 'image', '{img src= width= height= align= desc= link= }', 'image');
INSERT INTO `tiki_quicktags` VALUES(46, 'pearwiki_tiki', 115, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(47, 'pearwiki_tiki', 120, 'table', '||r1c1|r1c2||r2c1|r2c2||', 'table');
INSERT INTO `tiki_quicktags` VALUES(48, 'pearwiki_tiki', 125, 'table new', '||r1c1|r1c2\nr2c1|r2c2||', 'new_table');
INSERT INTO `tiki_quicktags` VALUES(49, 'pearwiki_tiki', 130, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(50, 'pearwiki_tiki', 135, 'wiki link', '((text))', 'wiki_link');
INSERT INTO `tiki_quicktags` VALUES(51, 'pearwiki_tiki', 140, 'external link', '[http://example.com|text]', 'ext_link');
INSERT INTO `tiki_quicktags` VALUES(52, 'pearwiki_tiki', 145, 'rss feed', '{rss id= }', 'rss');
INSERT INTO `tiki_quicktags` VALUES(53, 'pearwiki_tiki', 150, 'tagline', '{cookie}', 'tagline');
INSERT INTO `tiki_quicktags` VALUES(54, 'pearwiki_tiki', 155, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(55, 'pearwiki_tiki', 160, 'dynamic variable', '%text%', 'dyn_vars');
INSERT INTO `tiki_quicktags` VALUES(56, 'pearwiki_tiki', 165, 'dynamic content', '{content id= }', 'dyn_content');
INSERT INTO `tiki_quicktags` VALUES(57, 'pearwiki_tiki', 170, 'table of contents (links to headings in page)', '{maketoc}', 'maketoc');
INSERT INTO `tiki_quicktags` VALUES(58, 'pearwiki_tiki', 175, 'table of contents (if part of a book)', '{toc}', 'toc');
INSERT INTO `tiki_quicktags` VALUES(59, 'tikiwiki', 5, 'bold', '__text__', 'bold');
INSERT INTO `tiki_quicktags` VALUES(60, 'tikiwiki', 10, 'italic', '''''text''''', 'italic');
INSERT INTO `tiki_quicktags` VALUES(61, 'tikiwiki', 15, 'underline', '===text===', 'underline');
INSERT INTO `tiki_quicktags` VALUES(62, 'tikiwiki', 20, 'colored text', '~~red:text~~', 'colored_text');
INSERT INTO `tiki_quicktags` VALUES(63, 'tikiwiki', 25, 'colored background', '++yellow:text++', 'colored_background');
INSERT INTO `tiki_quicktags` VALUES(64, 'tikiwiki', 30, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(65, 'tikiwiki', 35, 'bullet list', '*text', 'list_bullet');
INSERT INTO `tiki_quicktags` VALUES(66, 'tikiwiki', 40, 'enumerated list', '#text', 'list_enum');
INSERT INTO `tiki_quicktags` VALUES(67, 'tikiwiki', 45, 'indent list without bullet or number', '+text', 'list_indent');
INSERT INTO `tiki_quicktags` VALUES(68, 'tikiwiki', 50, 'term and definition list', ';term:definition', 'list_def');
INSERT INTO `tiki_quicktags` VALUES(69, 'tikiwiki', 55, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(70, 'tikiwiki', 60, 'large heading', '!text', 'h1');
INSERT INTO `tiki_quicktags` VALUES(71, 'tikiwiki', 65, 'medium heading', '!!text', 'h2');
INSERT INTO `tiki_quicktags` VALUES(72, 'tikiwiki', 70, 'small heading', '!!!text', 'h3');
INSERT INTO `tiki_quicktags` VALUES(73, 'tikiwiki', 75, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(74, 'tikiwiki', 80, 'title bar', '-=text=-', 'title_bar');
INSERT INTO `tiki_quicktags` VALUES(75, 'tikiwiki', 85, 'box', '^text^', 'box');
INSERT INTO `tiki_quicktags` VALUES(76, 'tikiwiki', 90, 'horizontal line', '---', 'hr');
INSERT INTO `tiki_quicktags` VALUES(77, 'tikiwiki', 95, 'create a new page in a multi-page post', '...page...', 'new_page');
INSERT INTO `tiki_quicktags` VALUES(78, 'tikiwiki', 100, 'center text', '::text::', 'align_center');
INSERT INTO `tiki_quicktags` VALUES(79, 'tikiwiki', 105, 'newline', '', '');
INSERT INTO `tiki_quicktags` VALUES(80, 'tikiwiki', 110, 'image', '{img src= width= height= align= desc= link= }', 'image');
INSERT INTO `tiki_quicktags` VALUES(81, 'tikiwiki', 115, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(82, 'tikiwiki', 120, 'table', '||r1c1|r1c2||r2c1|r2c2||', 'table');
INSERT INTO `tiki_quicktags` VALUES(83, 'tikiwiki', 125, 'table new', '||r1c1|r1c2\nr2c1|r2c2||', 'new_table');
INSERT INTO `tiki_quicktags` VALUES(84, 'tikiwiki', 130, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(85, 'tikiwiki', 135, 'wiki link', '((text))', 'wiki_link');
INSERT INTO `tiki_quicktags` VALUES(86, 'tikiwiki', 140, 'external link', '[http://example.com|text]', 'ext_link');
INSERT INTO `tiki_quicktags` VALUES(87, 'tikiwiki', 145, 'rss feed', '{rss id= }', 'rss');
INSERT INTO `tiki_quicktags` VALUES(88, 'tikiwiki', 150, 'tagline', '{cookie}', 'tagline');
INSERT INTO `tiki_quicktags` VALUES(89, 'tikiwiki', 155, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(90, 'tikiwiki', 160, 'dynamic variable', '%text%', 'dyn_vars');
INSERT INTO `tiki_quicktags` VALUES(91, 'tikiwiki', 165, 'dynamic content', '{content id= }', 'dyn_content');
INSERT INTO `tiki_quicktags` VALUES(92, 'tikiwiki', 170, 'table of contents (links to headings in page)', '{maketoc}', 'maketoc');
INSERT INTO `tiki_quicktags` VALUES(93, 'tikiwiki', 175, 'table of contents (if part of a book)', '{toc}', 'toc');
INSERT INTO `tiki_quicktags` VALUES(94, 'pearwiki', 5, 'bold', '**text**', 'bold');
INSERT INTO `tiki_quicktags` VALUES(95, 'pearwiki', 10, 'italic', '//text//', 'italic');
INSERT INTO `tiki_quicktags` VALUES(96, 'pearwiki', 30, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(97, 'pearwiki', 35, 'bullet list', '* text', 'list_bullet');
INSERT INTO `tiki_quicktags` VALUES(98, 'pearwiki', 40, 'enumerated list', '# text', 'list_enum');
INSERT INTO `tiki_quicktags` VALUES(99, 'pearwiki', 45, 'indent list without bullet or number', '+ text', 'list_indent');
INSERT INTO `tiki_quicktags` VALUES(100, 'pearwiki', 50, 'term and definition list', ': term : definition', 'list_def');
INSERT INTO `tiki_quicktags` VALUES(101, 'pearwiki', 55, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(102, 'pearwiki', 60, 'large heading', '+ text', 'h1');
INSERT INTO `tiki_quicktags` VALUES(103, 'pearwiki', 65, 'medium heading', '++ text', 'h2');
INSERT INTO `tiki_quicktags` VALUES(104, 'pearwiki', 70, 'small heading', '+++ text', 'h3');
INSERT INTO `tiki_quicktags` VALUES(105, 'pearwiki', 75, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(106, 'pearwiki', 90, 'horizontal line', '----', 'hr');
INSERT INTO `tiki_quicktags` VALUES(107, 'pearwiki', 95, 'create a new page in a multi-page post', '...page...', 'new_page');
INSERT INTO `tiki_quicktags` VALUES(108, 'pearwiki', 105, 'newline', '', '');
INSERT INTO `tiki_quicktags` VALUES(109, 'pearwiki', 110, 'image', '[http://example.com/image.gif text]', 'image');
INSERT INTO `tiki_quicktags` VALUES(110, 'pearwiki', 115, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(111, 'pearwiki', 125, 'table', '||r1c1||r1c2||\n||r2c1||r2c2||', 'table');
INSERT INTO `tiki_quicktags` VALUES(112, 'pearwiki', 130, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(113, 'pearwiki', 140, 'external link', '[http://example.com text]', 'ext_link');
INSERT INTO `tiki_quicktags` VALUES(114, 'pearwiki', 145, 'rss feed', '{rss id= }', 'rss');
INSERT INTO `tiki_quicktags` VALUES(115, 'pearwiki', 150, 'tagline', '{cookie}', 'tagline');
INSERT INTO `tiki_quicktags` VALUES(116, 'pearwiki', 155, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(117, 'pearwiki', 160, 'dynamic variable', '%text%', 'dyn_vars');
INSERT INTO `tiki_quicktags` VALUES(118, 'pearwiki', 165, 'dynamic content', '{content id= }', 'dyn_content');
INSERT INTO `tiki_quicktags` VALUES(119, 'pearwiki', 170, 'table of contents (links to headings in page)', '{maketoc}', 'maketoc');
INSERT INTO `tiki_quicktags` VALUES(120, 'pearwiki', 175, 'table of contents (if part of a book)', '{toc}', 'toc');
INSERT INTO `tiki_quicktags` VALUES(121, 'bithtml', 5, 'bold', '<strong>text</strong>', 'bold');
INSERT INTO `tiki_quicktags` VALUES(122, 'bithtml', 10, 'italic', '<em>text</em>', 'italic');
INSERT INTO `tiki_quicktags` VALUES(123, 'bithtml', 15, 'underline', '<u>text</u>', 'underline');
INSERT INTO `tiki_quicktags` VALUES(124, 'bithtml', 20, 'colored text', '<span style="color:red">text</span>', 'colored_text');
INSERT INTO `tiki_quicktags` VALUES(125, 'bithtml', 25, 'colored background', '<span style="background:yellow">text</span>', 'colored_background');
INSERT INTO `tiki_quicktags` VALUES(126, 'bithtml', 30, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(127, 'bithtml', 35, 'bullet list', '<ul>\n<li>text</li>\n</ul>', 'list_bullet');
INSERT INTO `tiki_quicktags` VALUES(128, 'bithtml', 40, 'enumerated list', '<ol>\n<li>text</li>\n</ol>', 'list_enum');
INSERT INTO `tiki_quicktags` VALUES(129, 'bithtml', 45, 'indent list without bullet or number', '+text', 'list_indent');
INSERT INTO `tiki_quicktags` VALUES(130, 'bithtml', 50, 'term and definition list', '<dl>\n<dt>text</dt>\n<dd></dd>\n</dl>', 'list_def');
INSERT INTO `tiki_quicktags` VALUES(131, 'bithtml', 55, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(132, 'bithtml', 60, 'large heading', '<h1>text</h1>', 'h1');
INSERT INTO `tiki_quicktags` VALUES(133, 'bithtml', 65, 'medium heading', '<h2>text</h2>', 'h2');
INSERT INTO `tiki_quicktags` VALUES(134, 'bithtml', 70, 'small heading', '<h3>text</h3>', 'h3');
INSERT INTO `tiki_quicktags` VALUES(135, 'bithtml', 75, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(136, 'bithtml', 80, 'title bar', '<div class="bitbar">text</div>', 'title_bar');
INSERT INTO `tiki_quicktags` VALUES(137, 'bithtml', 85, 'box', '<div class="bitbox">text</div>', 'box');
INSERT INTO `tiki_quicktags` VALUES(138, 'bithtml', 90, 'horizontal line', '<hr />', 'hr');
INSERT INTO `tiki_quicktags` VALUES(139, 'bithtml', 93, 'new line', '<br />', 'new_line');
INSERT INTO `tiki_quicktags` VALUES(140, 'bithtml', 95, 'create a new page in a multi-page post', '...page...', 'new_page');
INSERT INTO `tiki_quicktags` VALUES(141, 'bithtml', 100, 'center text', '<div style="text-align:center;">text</div>', 'align_center');
INSERT INTO `tiki_quicktags` VALUES(142, 'bithtml', 105, 'newline', '', '');
INSERT INTO `tiki_quicktags` VALUES(143, 'bithtml', 110, 'image', '<img src= width= height= align= desc= >', 'image');
INSERT INTO `tiki_quicktags` VALUES(144, 'bithtml', 115, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(145, 'bithtml', 125, 'table', '<table class="bittable">\n<tr>\n<td>text</td>\n</tr>\n</table>', 'table');
INSERT INTO `tiki_quicktags` VALUES(146, 'bithtml', 130, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(147, 'bithtml', 135, 'wiki link', '((text))', 'wiki_link');
INSERT INTO `tiki_quicktags` VALUES(148, 'bithtml', 140, 'external link', '<a href="http://example.com">text</a>', 'ext_link');
INSERT INTO `tiki_quicktags` VALUES(149, 'bithtml', 145, 'rss feed', '{rss id= }', 'rss');
INSERT INTO `tiki_quicktags` VALUES(150, 'bithtml', 150, 'tagline', '{cookie}', 'tagline');
INSERT INTO `tiki_quicktags` VALUES(151, 'bithtml', 155, 'spacer', '', 'spacer');
INSERT INTO `tiki_quicktags` VALUES(152, 'bithtml', 160, 'dynamic variable', '%text%', 'dyn_vars');
INSERT INTO `tiki_quicktags` VALUES(153, 'bithtml', 165, 'dynamic content', '{content id= }', 'dyn_content');
INSERT INTO `tiki_quicktags` VALUES(154, 'bithtml', 170, 'table of contents (links to headings in page)', '{maketoc}', 'maketoc');
INSERT INTO `tiki_quicktags` VALUES(155, 'bithtml', 175, 'table of contents (if part of a book)', '{toc}', 'toc');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_quotas`
--

CREATE TABLE `tiki_quotas` (
  `quota_id` int(11) NOT NULL,
  `disk_usage` bigint(20) default NULL,
  `monthly_transfer` bigint(20) default NULL,
  `title` varchar(160) NOT NULL,
  `description` text,
  PRIMARY KEY  (`quota_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quotas`
--

INSERT INTO `tiki_quotas` VALUES(1, 2000000, 20000000, 'Free Trial', 'A little space to try out site features');
INSERT INTO `tiki_quotas` VALUES(2, 10000000, 100000000, 'Site Supporters', 'Extra space for site supporters.');

-- --------------------------------------------------------

--
-- Table structure for table `tiki_quotas_group_map`
--

CREATE TABLE `tiki_quotas_group_map` (
  `quota_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`quota_id`,`group_id`),
  UNIQUE KEY `tiki_quotas_group_idx` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quotas_group_map`
--

INSERT INTO `tiki_quotas_group_map` VALUES(1, 3);
INSERT INTO `tiki_quotas_group_map` VALUES(2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_quota_id_seq`
--

CREATE TABLE `tiki_quota_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quota_id_seq`
--

INSERT INTO `tiki_quota_id_seq` VALUES(2);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_received_pages`
--

CREATE TABLE `tiki_received_pages` (
  `received_page_id` int(11) NOT NULL auto_increment,
  `title` varchar(160) NOT NULL,
  `data` text,
  `description` varchar(200) default NULL,
  `comment` varchar(200) default NULL,
  `received_from_site` varchar(200) default NULL,
  `received_from_user` varchar(200) default NULL,
  `received_date` bigint(20) default NULL,
  PRIMARY KEY  (`received_page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_received_pages`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_referer_stats`
--

CREATE TABLE `tiki_referer_stats` (
  `referer` varchar(50) NOT NULL,
  `hits` bigint(20) default NULL,
  `last` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_referer_stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_rss_feeds`
--

CREATE TABLE `tiki_rss_feeds` (
  `name` varchar(30) NOT NULL,
  `rss_ver` varchar(1) NOT NULL default '1',
  `refresh` int(11) default '300',
  `last_updated` bigint(20) default NULL,
  `cache` longblob
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_rss_feeds`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_rss_modules`
--

CREATE TABLE `tiki_rss_modules` (
  `rss_id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  `description` text,
  `url` varchar(255) NOT NULL,
  `refresh` int(11) default NULL,
  `last_updated` bigint(20) default NULL,
  `show_title` varchar(1) default 'n',
  `show_pub_date` varchar(1) default 'n',
  `content` text,
  PRIMARY KEY  (`rss_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_rss_modules`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_searchindex`
--

CREATE TABLE `tiki_searchindex` (
  `searchword` varchar(80) NOT NULL,
  `location` varchar(80) NOT NULL,
  `content_id` int(11) NOT NULL,
  `count` int(11) NOT NULL default '1',
  `last_update` int(11) NOT NULL,
  PRIMARY KEY  (`searchword`,`location`,`content_id`),
  KEY `tiki_searchidx_last_update_idx` (`last_update`),
  KEY `tiki_searchidx_word_idx` (`searchword`),
  KEY `tiki_searchidx_con_idx` (`content_id`),
  KEY `tiki_searchidx_loc_idx` (`location`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_searchindex`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_searchsyllable`
--

CREATE TABLE `tiki_searchsyllable` (
  `syllable` varchar(80) NOT NULL,
  `last_used` int(11) NOT NULL,
  `last_updated` int(11) NOT NULL,
  PRIMARY KEY  (`syllable`),
  KEY `tiki_searchsyl_last_used_idx` (`last_used`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_searchsyllable`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_searchwords`
--

CREATE TABLE `tiki_searchwords` (
  `syllable` varchar(80) NOT NULL,
  `searchword` varchar(80) NOT NULL,
  PRIMARY KEY  (`syllable`,`searchword`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_searchwords`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_search_stats`
--

CREATE TABLE `tiki_search_stats` (
  `term` varchar(50) NOT NULL,
  `hits` int(11) default NULL,
  PRIMARY KEY  (`term`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_search_stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_security`
--

CREATE TABLE `tiki_security` (
  `security_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `security_description` varchar(160) NOT NULL,
  `is_private` varchar(1) default NULL,
  `is_hidden` varchar(1) default NULL,
  `access_question` varchar(250) default NULL,
  `access_answer` varchar(128) default NULL,
  PRIMARY KEY  (`security_id`),
  KEY `tiki_security_user_idx` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_security`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_security_id_seq`
--

CREATE TABLE `tiki_security_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_security_id_seq`
--

INSERT INTO `tiki_security_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_semaphores`
--

CREATE TABLE `tiki_semaphores` (
  `sem_name` varchar(250) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` bigint(20) default NULL,
  PRIMARY KEY  (`sem_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_semaphores`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_sessions`
--

CREATE TABLE `tiki_sessions` (
  `session_id` varchar(32) NOT NULL,
  `user_id` int(11) default NULL,
  `timestamp` bigint(20) default NULL,
  PRIMARY KEY  (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_sessions`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_shoutbox`
--

CREATE TABLE `tiki_shoutbox` (
  `shout_id` int(11) NOT NULL auto_increment,
  `shout_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `shout_message` varchar(255) NOT NULL,
  `shout_time` bigint(20) NOT NULL,
  `shout_sum` varchar(32) default NULL,
  PRIMARY KEY  (`shout_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_shoutbox`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_stickies`
--

CREATE TABLE `tiki_stickies` (
  `sticky_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `notated_content_id` int(11) NOT NULL,
  PRIMARY KEY  (`sticky_id`),
  KEY `tiki_stickies_content_id_idx` (`content_id`),
  KEY `tiki_notated_content_id_idx` (`notated_content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_stickies`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_stickies_sticky_id_seq`
--

CREATE TABLE `tiki_stickies_sticky_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_stickies_sticky_id_seq`
--

INSERT INTO `tiki_stickies_sticky_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_structures`
--

CREATE TABLE `tiki_structures` (
  `structure_id` int(11) NOT NULL auto_increment,
  `root_structure_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `level` tinyint(4) NOT NULL default '1',
  `pos` int(11) default NULL,
  `page_alias` varchar(240) default NULL,
  `parent_id` int(11) default NULL,
  PRIMARY KEY  (`structure_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_structures`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_structures_id_seq`
--

CREATE TABLE `tiki_structures_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_structures_id_seq`
--

INSERT INTO `tiki_structures_id_seq` VALUES(3);

-- --------------------------------------------------------

--
-- Table structure for table `tiki_tags`
--

CREATE TABLE `tiki_tags` (
  `page_id` int(11) NOT NULL,
  `tag_name` varchar(80) NOT NULL,
  `title` varchar(160) default NULL,
  `user_id` int(11) NOT NULL,
  `hits` int(11) default NULL,
  `description` varchar(200) default NULL,
  `data` text,
  `last_modified` bigint(20) default NULL,
  `comment` varchar(200) default NULL,
  `version` int(11) NOT NULL,
  `ip` varchar(15) default NULL,
  `flag` varchar(1) default NULL,
  PRIMARY KEY  (`page_id`,`tag_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_tags`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_theme_control_categs`
--

CREATE TABLE `tiki_theme_control_categs` (
  `category_id` int(11) NOT NULL,
  `theme` varchar(250) NOT NULL,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_theme_control_categs`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_theme_control_objects`
--

CREATE TABLE `tiki_theme_control_objects` (
  `obj_id` varchar(250) NOT NULL,
  `type` varchar(250) NOT NULL,
  `name` varchar(250) NOT NULL,
  `theme` varchar(250) NOT NULL,
  PRIMARY KEY  (`obj_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_theme_control_objects`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_thumbnail_queue`
--

CREATE TABLE `tiki_thumbnail_queue` (
  `content_id` int(11) NOT NULL,
  `queue_date` bigint(20) NOT NULL,
  `begin_date` bigint(20) default NULL,
  `end_date` bigint(20) default NULL,
  `resize_original` int(11) default NULL,
  PRIMARY KEY  (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_thumbnail_queue`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_userfiles`
--

CREATE TABLE `tiki_userfiles` (
  `file_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `name` varchar(200) default NULL,
  `filename` varchar(200) default NULL,
  `filetype` varchar(200) default NULL,
  `filesize` varchar(200) default NULL,
  `data` longblob,
  `hits` int(11) default NULL,
  `is_file` varchar(1) default NULL,
  `path` varchar(255) default NULL,
  `created` bigint(20) default NULL,
  PRIMARY KEY  (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_userfiles`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_userpoints`
--

CREATE TABLE `tiki_userpoints` (
  `user_id` int(11) default NULL,
  `points` decimal(10,0) default NULL,
  `voted` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_userpoints`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_bookmarks_folders`
--

CREATE TABLE `tiki_user_bookmarks_folders` (
  `folder_id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(30) default NULL,
  PRIMARY KEY  (`folder_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_user_bookmarks_folders`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_bookmarks_urls`
--

CREATE TABLE `tiki_user_bookmarks_urls` (
  `url_id` int(11) NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  `url` varchar(250) default NULL,
  `data` text,
  `last_updated` bigint(20) default NULL,
  `folder_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY  (`url_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_user_bookmarks_urls`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_menus`
--

CREATE TABLE `tiki_user_menus` (
  `menu_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `url` varchar(250) default NULL,
  `name` varchar(40) default NULL,
  `position` int(11) default NULL,
  `mode` varchar(1) default NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_user_menus`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_modules`
--

CREATE TABLE `tiki_user_modules` (
  `name` varchar(200) NOT NULL,
  `title` varchar(40) default NULL,
  `data` text,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_user_modules`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_postings`
--

CREATE TABLE `tiki_user_postings` (
  `user_id` int(11) NOT NULL,
  `posts` bigint(20) default NULL,
  `last` bigint(20) default NULL,
  `first` bigint(20) default NULL,
  `level` int(11) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_user_postings`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_preferences`
--

CREATE TABLE `tiki_user_preferences` (
  `user_id` int(11) NOT NULL,
  `pref_name` varchar(40) NOT NULL,
  `value` varchar(250) default NULL,
  PRIMARY KEY  (`user_id`,`pref_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_user_preferences`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_tasks`
--

CREATE TABLE `tiki_user_tasks` (
  `task_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `title` varchar(250) default NULL,
  `description` text,
  `date` bigint(20) default NULL,
  `status` varchar(1) default NULL,
  `priority` int(11) default NULL,
  `completed` bigint(20) default NULL,
  `percentage` int(11) default NULL,
  PRIMARY KEY  (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tiki_user_tasks`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_votings`
--

CREATE TABLE `tiki_user_votings` (
  `user_id` int(11) NOT NULL,
  `id` varchar(160) NOT NULL,
  PRIMARY KEY  (`user_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_user_votings`
--


-- --------------------------------------------------------

--
-- Table structure for table `tiki_user_watches`
--

CREATE TABLE `tiki_user_watches` (
  `user_id` int(11) NOT NULL,
  `event` varchar(40) NOT NULL,
  `object` varchar(120) NOT NULL,
  `hash` varchar(32) default NULL,
  `title` varchar(250) default NULL,
  `type` varchar(200) default NULL,
  `url` varchar(250) default NULL,
  `email` varchar(200) default NULL,
  PRIMARY KEY  (`user_id`,`event`,`object`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_user_watches`
--


-- --------------------------------------------------------

--
-- Table structure for table `treasury_gallery`
--

CREATE TABLE `treasury_gallery` (
  `content_id` int(11) NOT NULL,
  `structure_id` int(11) NOT NULL,
  `is_private` varchar(1) default 'n',
  UNIQUE KEY `treasury_gallery_content_idx` (`content_id`),
  UNIQUE KEY `treasury_gallery_structure_idx` (`structure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `treasury_gallery`
--


-- --------------------------------------------------------

--
-- Table structure for table `treasury_id_seq`
--

CREATE TABLE `treasury_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `treasury_id_seq`
--

INSERT INTO `treasury_id_seq` VALUES(0);

-- --------------------------------------------------------

--
-- Table structure for table `treasury_item`
--

CREATE TABLE `treasury_item` (
  `content_id` int(11) NOT NULL,
  `plugin_guid` varchar(16) NOT NULL,
  UNIQUE KEY `treasury_item_content_idx` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `treasury_item`
--


-- --------------------------------------------------------

--
-- Table structure for table `treasury_map`
--

CREATE TABLE `treasury_map` (
  `gallery_content_id` int(11) NOT NULL,
  `item_content_id` int(11) NOT NULL,
  `item_position` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `treasury_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_cnxn`
--

CREATE TABLE `users_cnxn` (
  `user_id` int(11) default NULL,
  `cookie` varchar(64) default NULL,
  `ip` varchar(16) default NULL,
  `last_get` bigint(20) default NULL,
  `connect_time` bigint(20) default NULL,
  `get_count` bigint(20) default NULL,
  `user_agent` varchar(128) default NULL,
  `current_view` text,
  `assume_user_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_cnxn`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_favorites_map`
--

CREATE TABLE `users_favorites_map` (
  `favorite_content_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `map_position` int(11) default NULL,
  PRIMARY KEY  (`favorite_content_id`,`user_id`),
  KEY `users_fav_user_ref` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_favorites_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_grouppermissions`
--

CREATE TABLE `users_grouppermissions` (
  `group_id` int(11) NOT NULL,
  `perm_name` varchar(30) NOT NULL,
  `value` varchar(1) default '',
  PRIMARY KEY  (`group_id`,`perm_name`),
  KEY `users_groupperm_group_idx` (`group_id`),
  KEY `users_groupperm_perm_idx` (`perm_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_grouppermissions`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_groups`
--

CREATE TABLE `users_groups` (
  `group_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `group_name` varchar(30) default NULL,
  `is_default` varchar(1) default NULL,
  `group_desc` varchar(255) default NULL,
  `group_home` varchar(255) default NULL,
  `is_public` varchar(1) default NULL,
  `after_registration_page` varchar(255) default NULL,
  PRIMARY KEY  (`group_id`),
  UNIQUE KEY `users_groups_user_name_idx` (`user_id`,`group_name`),
  KEY `users_groups_user_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_groups`
--

INSERT INTO `users_groups` VALUES(-1, 1, 'Anonymous', NULL, 'Public users not logged', NULL, NULL, NULL);
INSERT INTO `users_groups` VALUES(1, 1, 'Administrators', NULL, 'Site operators', NULL, NULL, NULL);
INSERT INTO `users_groups` VALUES(2, 1, 'Editors', NULL, 'Site  Editors', NULL, NULL, NULL);
INSERT INTO `users_groups` VALUES(3, 1, 'Registered', 'y', 'Users logged into the system', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users_groups_id_seq`
--

CREATE TABLE `users_groups_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_groups_id_seq`
--

INSERT INTO `users_groups_id_seq` VALUES(3);

-- --------------------------------------------------------

--
-- Table structure for table `users_groups_inclusion`
--

CREATE TABLE `users_groups_inclusion` (
  `group_id` int(11) NOT NULL,
  `include_group_id` int(11) NOT NULL,
  PRIMARY KEY  (`group_id`,`include_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_groups_inclusion`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_groups_map`
--

CREATE TABLE `users_groups_map` (
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`user_id`,`group_id`),
  KEY `users_groups_map_user_idx` (`user_id`),
  KEY `users_groups_map_group_idx` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_groups_map`
--

INSERT INTO `users_groups_map` VALUES(-1, -1);
INSERT INTO `users_groups_map` VALUES(1, 1);
INSERT INTO `users_groups_map` VALUES(1, 3);
INSERT INTO `users_groups_map` VALUES(2, 1);
INSERT INTO `users_groups_map` VALUES(2, 3);

-- --------------------------------------------------------

--
-- Table structure for table `users_group_permissions`
--

CREATE TABLE `users_group_permissions` (
  `group_id` int(11) NOT NULL,
  `perm_name` varchar(30) NOT NULL,
  `perm_value` varchar(1) default '',
  PRIMARY KEY  (`group_id`,`perm_name`),
  KEY `users_groupperm_group_idx` (`group_id`),
  KEY `users_groupperm_perm_idx` (`perm_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_group_permissions`
--

INSERT INTO `users_group_permissions` VALUES(-1, 'p_articles_read', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_articles_submit', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_blogs_view', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_calendar_view', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_fisheye_view', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_gatekeeper_read', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_liberty_list_content', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_liberty_print', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_liberty_read_comments', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_pigeonholes_view', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_quota_read', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_shoutbox_post', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_shoutbox_view', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_smileys_use', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_stats_view', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_users_view_icons_and_tools', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_users_view_user_homepage', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_wiki_view_history', '');
INSERT INTO `users_group_permissions` VALUES(-1, 'p_wiki_view_page', '');
INSERT INTO `users_group_permissions` VALUES(1, 'p_access_closed_site', '');
INSERT INTO `users_group_permissions` VALUES(1, 'p_admin', '');
INSERT INTO `users_group_permissions` VALUES(1, 'p_languages_create', '');
INSERT INTO `users_group_permissions` VALUES(1, 'p_languages_delete', '');
INSERT INTO `users_group_permissions` VALUES(1, 'p_languages_edit_master', '');
INSERT INTO `users_group_permissions` VALUES(1, 'p_users_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_approve_submission', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_auto_approve', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_edit', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_edit_submission', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_remove', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_remove_submission', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_articles_send', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_blogs_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_blogs_create_is_public', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_blog_posts_read_expired', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_blog_posts_read_future', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_calendar_view_changes', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_fisheye_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_fisheye_change_thumb_size', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_fisheye_create_public_gal', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_fisheye_upload_nonimages', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_gatekeeper_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_gatekeeper_edit', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_languages_edit', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_languages_import', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_admin_comments', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_assign_content_perms', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_edit_all_status', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_edit_comments', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_edit_content_owner', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_edit_html_style', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_liberty_view_all_status', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_newsletters_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_newsletters_create', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_newsletters_create_editions', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_newsletters_subscribe_email', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_nexus_create_menus', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_pigeonholes_edit', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_quota_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_quota_edit', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_quota_unlimited', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_shoutbox_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_stats_view_referer', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_stickies_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_users_assign_group_perms', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_users_create_personal_groups', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_users_group_subgroups', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_admin', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_admin_book', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_edit_dynvar', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_lock_page', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_remove_page', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_rename_page', '');
INSERT INTO `users_group_permissions` VALUES(2, 'p_wiki_rollback', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_articles_read_history', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_articles_sendme', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_blogs_create', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_blogs_post', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_blogs_send_post', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_fisheye_create', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_fisheye_edit', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_fisheye_upload', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_gatekeeper_create', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_attach_attachments', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_delete_attachment', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_detach_attachment', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_edit_content_status', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_enter_html', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_post_comments', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_liberty_vote_comments', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_messages_send', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_newsletters_subscribe', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_nexus_insert_item', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_pdf_generation', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_pigeonholes_insert_member', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_quota_create', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_stickies_edit', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_users_assign_group_members', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_users_bypass_captcha', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_users_edit_user_homepage', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_users_view_user_list', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_wiki_edit_book', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_wiki_edit_copyright', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_wiki_edit_page', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_wiki_list_pages', '');
INSERT INTO `users_group_permissions` VALUES(3, 'p_wiki_save_minor', '');

-- --------------------------------------------------------

--
-- Table structure for table `users_objectpermissions`
--

CREATE TABLE `users_objectpermissions` (
  `group_id` int(11) NOT NULL,
  `perm_name` varchar(30) NOT NULL,
  `object_type` varchar(20) NOT NULL,
  `object_id` int(11) NOT NULL,
  PRIMARY KEY  (`group_id`,`perm_name`,`object_type`,`object_id`),
  KEY `users_objectperm_group_idx` (`group_id`),
  KEY `users_objectperm_perm_idx` (`perm_name`),
  KEY `users_objectperm_object_idx` (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_objectpermissions`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_permissions`
--

CREATE TABLE `users_permissions` (
  `perm_name` varchar(30) NOT NULL,
  `perm_desc` varchar(250) default NULL,
  `perm_level` varchar(80) default NULL,
  `package` varchar(100) default NULL,
  PRIMARY KEY  (`perm_name`),
  UNIQUE KEY `users_permissions_name_idx` (`perm_name`),
  KEY `users_permissions_perm_idx` (`perm_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_permissions`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_quota_units`
--

CREATE TABLE `users_quota_units` (
  `user_id` int(11) NOT NULL,
  `units` int(11) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_quota_units`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_semaphores`
--

CREATE TABLE `users_semaphores` (
  `sem_name` varchar(250) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` bigint(20) default NULL,
  PRIMARY KEY  (`sem_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_semaphores`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_users`
--

CREATE TABLE `users_users` (
  `user_id` int(11) NOT NULL,
  `content_id` int(11) default NULL,
  `email` varchar(200) default NULL,
  `login` varchar(40) default NULL,
  `real_name` varchar(64) default NULL,
  `user_password` varchar(32) default NULL,
  `provpass` varchar(32) default NULL,
  `default_group_id` int(11) default NULL,
  `last_login` bigint(20) default NULL,
  `current_login` bigint(20) default NULL,
  `registration_date` bigint(20) NOT NULL,
  `challenge` varchar(32) default NULL,
  `pass_due` bigint(20) default NULL,
  `hash` varchar(32) default NULL,
  `created` bigint(20) default NULL,
  `avatar_attachment_id` int(11) default NULL,
  `portrait_attachment_id` int(11) default NULL,
  `logo_attachment_id` int(11) default NULL,
  `provpass_expires` bigint(20) default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `users_users_email_idx` (`email`),
  UNIQUE KEY `users_users_login_idx` (`login`),
  KEY `users_users_avatar_atment_idx` (`avatar_attachment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_users`
--

INSERT INTO `users_users` VALUES(-1, 1, 'guest@localhost', 'guest', 'Guest', NULL, NULL, NULL, NULL, NULL, 1190921328, NULL, 1190921328, '082f87419eda751cab720e6de868860b', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `users_users` VALUES(1, 2, 'root@localhost', 'root', 'root', NULL, NULL, NULL, NULL, NULL, 1190921328, NULL, 1190921328, 'a6f07e12fde68e0d3a86ff0bc48a14da', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `users_users` VALUES(2, 3, 'deek@mundaneastrology.net', 'deek', 'Tony Dickey', NULL, NULL, NULL, 1204105601, 1204105601, 1190921328, NULL, 1190921328, '4980defb0e3e3ad29e3afc8d8c83a8ee', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users_users_user_id_seq`
--

CREATE TABLE `users_users_user_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_users_user_id_seq`
--

INSERT INTO `users_users_user_id_seq` VALUES(2);

-- --------------------------------------------------------

--
-- Table structure for table `users_watches`
--

CREATE TABLE `users_watches` (
  `user_id` int(11) NOT NULL,
  `event` varchar(40) NOT NULL,
  `object` varchar(120) NOT NULL,
  `hash` varchar(32) default NULL,
  `title` varchar(250) default NULL,
  `watch_type` varchar(200) default NULL,
  `url` varchar(250) default NULL,
  `email` varchar(200) default NULL,
  PRIMARY KEY  (`user_id`,`event`,`object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_watches`
--


-- --------------------------------------------------------

--
-- Table structure for table `wiki_ext`
--

CREATE TABLE `wiki_ext` (
  `extwiki_id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `extwiki` varchar(255) default NULL,
  PRIMARY KEY  (`extwiki_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `wiki_ext`
--


-- --------------------------------------------------------

--
-- Table structure for table `wiki_footnotes`
--

CREATE TABLE `wiki_footnotes` (
  `user_id` varchar(40) NOT NULL,
  `page_id` int(11) NOT NULL,
  `data` text,
  PRIMARY KEY  (`user_id`),
  KEY `tiki_page_footnotes_page_idx` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wiki_footnotes`
--


-- --------------------------------------------------------

--
-- Table structure for table `wiki_pages`
--

CREATE TABLE `wiki_pages` (
  `page_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `wiki_page_size` int(11) default '0',
  `edit_comment` varchar(200) default NULL,
  `flag` varchar(1) default NULL,
  PRIMARY KEY  (`page_id`),
  KEY `tiki_pages_content_idx` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wiki_pages`
--

INSERT INTO `wiki_pages` VALUES(1, 4, 61, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(3, 6, 1114, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(4, 7, 1352, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(5, 8, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(6, 9, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(7, 10, 6517, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(8, 11, 5, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(9, 12, 372, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(10, 13, 162, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(11, 14, 295, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(12, 15, 80, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(13, 16, 151, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(14, 17, 2114, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(15, 18, 5278, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(16, 19, 8938, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(17, 20, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(18, 21, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(19, 22, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(20, 23, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(21, 24, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(22, 25, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(23, 26, 1535, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(24, 27, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(25, 28, 3193, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(26, 29, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(27, 30, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(28, 31, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(29, 32, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(30, 33, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(31, 34, 7160, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(32, 35, 6434, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(33, 36, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(34, 37, 2380, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(35, 38, 177, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(36, 39, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(37, 40, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(38, 41, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(39, 42, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(40, 43, 1795, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(41, 44, 7329, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(42, 45, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(43, 46, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(44, 47, 7233, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(45, 48, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(46, 49, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(47, 50, 728, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(48, 51, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(49, 52, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(50, 53, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(51, 54, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(52, 55, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(53, 56, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(54, 57, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(55, 58, 976, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(56, 59, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(57, 60, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(58, 61, 5, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(59, 62, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(60, 63, 1297, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(61, 64, 135, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(62, 65, 479, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(63, 66, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(64, 67, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(65, 68, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(66, 69, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(67, 70, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(68, 71, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(69, 72, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(70, 73, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(71, 74, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(72, 75, 0, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(73, 76, 2743, NULL, NULL);
INSERT INTO `wiki_pages` VALUES(74, 78, 460, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `wiki_pages_page_id_seq`
--

CREATE TABLE `wiki_pages_page_id_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wiki_pages_page_id_seq`
--

INSERT INTO `wiki_pages_page_id_seq` VALUES(74);

-- --------------------------------------------------------

--
-- Table structure for table `wiki_received_pages`
--

CREATE TABLE `wiki_received_pages` (
  `received_page_id` int(11) NOT NULL auto_increment,
  `title` varchar(160) NOT NULL,
  `data` text,
  `description` varchar(200) default NULL,
  `comment` varchar(200) default NULL,
  `received_from_site` varchar(200) default NULL,
  `received_from_user` varchar(200) default NULL,
  `received_date` bigint(20) default NULL,
  PRIMARY KEY  (`received_page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `wiki_received_pages`
--


-- --------------------------------------------------------

--
-- Table structure for table `wiki_tags`
--

CREATE TABLE `wiki_tags` (
  `page_id` int(11) NOT NULL,
  `tag_name` varchar(80) NOT NULL,
  `title` varchar(160) default NULL,
  `user_id` int(11) NOT NULL,
  `hits` int(11) default NULL,
  `description` varchar(200) default NULL,
  `data` text,
  `last_modified` bigint(20) default NULL,
  `comment` varchar(200) default NULL,
  `version` int(11) NOT NULL,
  `ip` varchar(15) default NULL,
  `flag` varchar(1) default NULL,
  PRIMARY KEY  (`page_id`,`tag_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wiki_tags`
--


--
-- Constraints for dumped tables
--

--
-- Constraints for table `boards`
--
ALTER TABLE `boards`
  ADD CONSTRAINT `boards_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `boards_map`
--
ALTER TABLE `boards_map`
  ADD CONSTRAINT `boards_topics_boards_ref` FOREIGN KEY (`board_content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `boards_topics_related_ref` FOREIGN KEY (`topic_content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `boards_posts`
--
ALTER TABLE `boards_posts`
  ADD CONSTRAINT `boards_posts_comment_ref` FOREIGN KEY (`comment_id`) REFERENCES `liberty_comments` (`comment_id`);

--
-- Constraints for table `boards_topics`
--
ALTER TABLE `boards_topics`
  ADD CONSTRAINT `boards_topics_parent_ref` FOREIGN KEY (`parent_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `events`
--
ALTER TABLE `events`
  ADD CONSTRAINT `events_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `events_location_ref` FOREIGN KEY (`location_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `events_type_ref` FOREIGN KEY (`type_id`) REFERENCES `events_types` (`type_id`);

--
-- Constraints for table `events_invites`
--
ALTER TABLE `events_invites`
  ADD CONSTRAINT `events_users_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `events_users_event_content_ref` FOREIGN KEY (`event_content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `events_on`
--
ALTER TABLE `events_on`
  ADD CONSTRAINT `events_on_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `mail_clickthrough`
--
ALTER TABLE `mail_clickthrough`
  ADD CONSTRAINT `mail_clickthrough_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `mail_clickthrough_user_ref` FOREIGN KEY (`user_id`) REFERENCES `users_users` (`user_id`);

--
-- Constraints for table `mail_errors`
--
ALTER TABLE `mail_errors`
  ADD CONSTRAINT `mail_err_user_ref` FOREIGN KEY (`user_id`) REFERENCES `users_users` (`user_id`);

--
-- Constraints for table `mail_mailings`
--
ALTER TABLE `mail_mailings`
  ADD CONSTRAINT `mail_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `mail_queue`
--
ALTER TABLE `mail_queue`
  ADD CONSTRAINT `mailq_content_ref` FOREIGN KEY (`nl_content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `mailq_user_ref` FOREIGN KEY (`user_id`) REFERENCES `users_users` (`user_id`);

--
-- Constraints for table `mail_subscriptions`
--
ALTER TABLE `mail_subscriptions`
  ADD CONSTRAINT `mail_unsub_con_ref` FOREIGN KEY (`response_content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `mail_unsub_ref` FOREIGN KEY (`user_id`) REFERENCES `users_users` (`user_id`);

--
-- Constraints for table `messages_system_map`
--
ALTER TABLE `messages_system_map`
  ADD CONSTRAINT `messages_system_message_ref` FOREIGN KEY (`msg_id`) REFERENCES `messages` (`msg_id`);

--
-- Constraints for table `newsletters`
--
ALTER TABLE `newsletters`
  ADD CONSTRAINT `nl_con_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `newsletters_editions`
--
ALTER TABLE `newsletters_editions`
  ADD CONSTRAINT `nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `nl_ed_nl_con_ref` FOREIGN KEY (`nl_content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `recommends`
--
ALTER TABLE `recommends`
  ADD CONSTRAINT `recommends_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `recommends_user_ref` FOREIGN KEY (`user_id`) REFERENCES `users_users` (`user_id`);

--
-- Constraints for table `recommends_sum`
--
ALTER TABLE `recommends_sum`
  ADD CONSTRAINT `recommends_sum_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `stars`
--
ALTER TABLE `stars`
  ADD CONSTRAINT `stars_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);

--
-- Constraints for table `stars_history`
--
ALTER TABLE `stars_history`
  ADD CONSTRAINT `stars_history_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `stars_history_user_ref` FOREIGN KEY (`user_id`) REFERENCES `users_users` (`user_id`);

--
-- Constraints for table `tags_content_map`
--
ALTER TABLE `tags_content_map`
  ADD CONSTRAINT `tags_content_map_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `tags_content_map_tagger_id_ref` FOREIGN KEY (`tagger_id`) REFERENCES `users_users` (`user_id`),
  ADD CONSTRAINT `tags_content_map_tag_ref` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`);

--
-- Constraints for table `treasury_gallery`
--
ALTER TABLE `treasury_gallery`
  ADD CONSTRAINT `treasury_gallery_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`),
  ADD CONSTRAINT `treasury_gallery_structure_ref` FOREIGN KEY (`structure_id`) REFERENCES `liberty_structures` (`structure_id`);

--
-- Constraints for table `treasury_item`
--
ALTER TABLE `treasury_item`
  ADD CONSTRAINT `treasury_item_content_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content` (`content_id`);
