--- a/.hgignore	Fri Nov 16 18:12:05 2012 +0100
+++ b/.hgignore	Tue Jun 17 10:25:33 2014 +0200
@@ -26,4 +26,8 @@
 syntax: regexp
 ^web/hdalab/\.htaccess$
 syntax: regexp
-^\.settings$
\ No newline at end of file
+^\.settings$
+syntax: regexp
+^run$
+syntax: regexp
+^src/hdabo/config\.py$
\ No newline at end of file

--- a/.settings/org.eclipse.core.resources.prefs	Fri Nov 16 18:12:05 2012 +0100
+++ b/.settings/org.eclipse.core.resources.prefs	Tue Jun 17 10:25:33 2014 +0200
@@ -1,48 +1,48 @@
 eclipse.preferences.version=1
 encoding//data/villes.csv=ISO-8859-1
-encoding//web/hdabo/forms.py=utf-8
-encoding//web/hdabo/management/commands/clean_tags.py=utf-8
-encoding//web/hdabo/management/commands/diff_csv.py=utf-8
-encoding//web/hdabo/management/commands/import_csv.py=utf-8
-encoding//web/hdabo/management/commands/import_tag_popularity.py=utf-8
-encoding//web/hdabo/management/commands/query_wikipedia.py=utf-8
-encoding//web/hdabo/management/utils.py=utf-8
-encoding//web/hdabo/migrations/0001_initial.py=utf-8
-encoding//web/hdabo/migrations/0002_backport_hdabo_sf.py=utf-8
-encoding//web/hdabo/migrations/0003_update_redirection.py=utf-8
-encoding//web/hdabo/migrations/0005_auto__chg_field_datasheet_organisation.py=utf-8
-encoding//web/hdabo/models.py=utf-8
-encoding//web/hdabo/search/french_whoosh_backend.py=utf-8
-encoding//web/hdabo/tests/models.py=utf-8
-encoding//web/hdabo/utils.py=utf-8
-encoding//web/hdabo/views.py=utf-8
-encoding//web/hdabo/wp_utils.py=utf-8
-encoding//web/hdalab/__init__.py=utf-8
+encoding//src/hdabo/forms.py=utf-8
+encoding//src/hdabo/management/commands/clean_tags.py=utf-8
+encoding//src/hdabo/management/commands/diff_csv.py=utf-8
+encoding//src/hdabo/management/commands/import_csv.py=utf-8
+encoding//src/hdabo/management/commands/import_tag_popularity.py=utf-8
+encoding//src/hdabo/management/commands/query_wikipedia.py=utf-8
+encoding//src/hdabo/management/utils.py=utf-8
+encoding//src/hdabo/migrations/0001_initial.py=utf-8
+encoding//src/hdabo/migrations/0002_backport_hdabo_sf.py=utf-8
+encoding//src/hdabo/migrations/0003_update_redirection.py=utf-8
+encoding//src/hdabo/migrations/0005_auto__chg_field_datasheet_organisation.py=utf-8
+encoding//src/hdabo/models.py=utf-8
+encoding//src/hdabo/search/french_whoosh_backend.py=utf-8
+encoding//src/hdabo/tests/models.py=utf-8
+encoding//src/hdabo/utils.py=utf-8
+encoding//src/hdabo/views.py=utf-8
+encoding//src/hdabo/wp_utils.py=utf-8
+encoding//src/hdalab/__init__.py=utf-8
+encoding//src/hdalab/manage.py=utf-8
+encoding//src/hdalab/management/commands/export_tags_csv.py=utf-8
+encoding//src/hdalab/management/commands/export_wpcategory_csv.py=utf-8
+encoding//src/hdalab/management/commands/fill_tag_years.py=utf-8
+encoding//src/hdalab/management/commands/geojson_transform.py=utf-8
+encoding//src/hdalab/management/commands/import_hda_insee_csv.py=utf-8
+encoding//src/hdalab/management/commands/import_hdabo_db.py=utf-8
+encoding//src/hdalab/management/commands/import_insee_csv.py=utf-8
+encoding//src/hdalab/management/commands/query_category_inclusion.py=utf-8
+encoding//src/hdalab/management/commands/query_dbpedia.py=utf-8
+encoding//src/hdalab/management/commands/query_geo_inclusion.py=utf-8
+encoding//src/hdalab/management/commands/query_wikipedia_category.py=utf-8
+encoding//src/hdalab/management/utils.py=utf-8
+encoding//src/hdalab/migrations/0001_initial.py=utf-8
+encoding//src/hdalab/migrations/0002_dataviz.py=utf-8
+encoding//src/hdalab/migrations/0003_hdasession.py=utf-8
+encoding//src/hdalab/migrations/0005_rename_end_year.py=utf-8
+encoding//src/hdalab/migrations/0006_dbpedia_fields_one_to_one.py=utf-8
+encoding//src/hdalab/migrations/0007_geographic_inclusion.py=utf-8
+encoding//src/hdalab/migrations/0008_datasheet_insee.py=utf-8
+encoding//src/hdalab/models/dataviz.py=utf-8
+encoding//src/hdalab/settings.py=utf-8
+encoding//src/hdalab/urls.py=utf-8
+encoding//src/hdalab/utils.py=utf-8
+encoding//src/hdalab/views/ajax.py=utf-8
+encoding//src/hdalab/views/pages.py=utf-8
 encoding//web/hdalab/config.py=utf-8
-encoding//web/hdalab/manage.py=utf-8
-encoding//web/hdalab/management/commands/export_tags_csv.py=utf-8
-encoding//web/hdalab/management/commands/export_wpcategory_csv.py=utf-8
 encoding//web/hdalab/management/commands/fill_country_codes.py=utf-8
-encoding//web/hdalab/management/commands/fill_tag_years.py=utf-8
-encoding//web/hdalab/management/commands/geojson_transform.py=utf-8
-encoding//web/hdalab/management/commands/import_hda_insee_csv.py=utf-8
-encoding//web/hdalab/management/commands/import_hdabo_db.py=utf-8
-encoding//web/hdalab/management/commands/import_insee_csv.py=utf-8
-encoding//web/hdalab/management/commands/query_category_inclusion.py=utf-8
-encoding//web/hdalab/management/commands/query_dbpedia.py=utf-8
-encoding//web/hdalab/management/commands/query_geo_inclusion.py=utf-8
-encoding//web/hdalab/management/commands/query_wikipedia_category.py=utf-8
-encoding//web/hdalab/management/utils.py=utf-8
-encoding//web/hdalab/migrations/0001_initial.py=utf-8
-encoding//web/hdalab/migrations/0002_dataviz.py=utf-8
-encoding//web/hdalab/migrations/0003_hdasession.py=utf-8
-encoding//web/hdalab/migrations/0005_rename_end_year.py=utf-8
-encoding//web/hdalab/migrations/0006_dbpedia_fields_one_to_one.py=utf-8
-encoding//web/hdalab/migrations/0007_geographic_inclusion.py=utf-8
-encoding//web/hdalab/migrations/0008_datasheet_insee.py=utf-8
-encoding//web/hdalab/models/dataviz.py=utf-8
-encoding//web/hdalab/settings.py=utf-8
-encoding//web/hdalab/urls.py=utf-8
-encoding//web/hdalab/utils.py=utf-8
-encoding//web/hdalab/views/ajax.py=utf-8
-encoding//web/hdalab/views/pages.py=utf-8

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/.htaccess.mod_python.tmpl	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,11 @@
+SetHandler python-program
+PythonHandler ldt.core.handlers.modpython
+SetEnv DJANGO_SETTINGS_MODULE ldtplatform.settings
+PythonInterpreter platform
+PythonOption django.root /~wakimd/platform/ldtplatform
+PythonOption virtualenv.activate_path /iridata/users/wakimd/Env/Efculture/bin/activate_this.py
+PythonDebug on
+PythonPath "['/iridata/users/wakimd/Env/Efculture/lib/python2.6/sites-packages'] + sys.path"
+Header set Pragma "no-cache"
+Header set Cache-Control "no-cache"
+Header set Expires "-1"

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/.htaccess.mod_wsgi.tmpl	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,20 @@
+
+SetEnv DJANGO_SETTINGS_MODULE hdabo.settings
+SetEnv PROJECT_PATH /Users/ymh/dev/workspace/hdabo/web
+SetEnv PYTHON_PATH /Users/ymh/dev/workspace/hdabo/virtualenv/web/env/hdabo/lib/python2.6/site-packages:/Applications/Dev/eclipse/plugins/org.python.pydev.debug_2.2.0.2011062419/pysrc/
+SetEnv PYDEV_DEBUG False
+
+Options ExecCGI FollowSymLinks
+SetHandler wsgi-script
+
+#if defined in global definition
+#defined with WSGIDaemonProcess 
+#WSGIProcessGroup platform
+
+RewriteEngine On
+RewriteCond %{REQUEST_FILENAME} !-f
+RewriteRule ^(.*)$ /~ymh/hdabo/hdabo/modwsgi.wsgi/$1 [QSA,PT,L]
+
+Header set Pragma "no-cache"
+Header set Cache-Control "no-cache"
+Header set Expires "-1"

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/__init__.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,16 @@
+VERSION = (2, 13, 0, "final", 0)
+
+
+def get_version():
+    version = '%s.%s' % (VERSION[0], VERSION[1])
+    if VERSION[2]:
+        version = '%s.%s' % (version, VERSION[2])
+    if VERSION[3:] == ('alpha', 0):
+        version = '%s pre-alpha' % version
+    else:
+        if VERSION[3] != 'final':
+            version = '%s %s %s' % (version, VERSION[3], VERSION[4])
+    return version
+
+
+__version__ = get_version()

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/admin.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,16 @@
+from django.contrib import admin
+from hdabo.models import (Author, Datasheet, DocumentFormat, Domain, Organisation, 
+    Tag, TagCategory, TaggedSheet, TimePeriod)
+
+
+admin.site.register(Author)
+admin.site.register(Datasheet)
+admin.site.register(DocumentFormat)
+admin.site.register(Domain)
+admin.site.register(Organisation)
+admin.site.register(Tag)
+admin.site.register(TagCategory)
+admin.site.register(TaggedSheet)
+admin.site.register(TimePeriod)
+
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/config.py.tmpl	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,47 @@
+import os
+
+BASE_DIR = os.path.dirname(os.path.abspath(__file__)).rstrip("/")+"/"
+BASE_URL = '/~ymh/hdabo/'
+WEB_URL = 'http://localhost'
+
+# Absolute filesystem path to the directory that will hold user-uploaded files.
+# Example: "/home/media/media.lawrence.com/media/"
+MEDIA_ROOT = os.path.abspath(BASE_DIR + "../static/media/")
+
+# URL that handles the media served from MEDIA_ROOT. Make sure to use a
+# trailing slash.
+# Examples: "http://media.lawrence.com/media/", "http://example.com/media/"
+MEDIA_URL = BASE_URL + "static/media/"
+
+# Absolute path to the directory static files should be collected to.
+# Don't put anything in this directory yourself; store your static files
+# in apps' "static/" subdirectories and in STATICFILES_DIRS.
+# Example: "/home/media/media.lawrence.com/static/"
+STATIC_ROOT = os.path.abspath(BASE_DIR + "../static/site/")
+
+# URL prefix for static files.
+# Example: "http://media.lawrence.com/static/"
+STATIC_URL = BASE_URL + "static/site/"
+
+# Additional locations of static files
+STATICFILES_DIRS = (
+    # Put strings here, like "/home/html/static" or "C:/www/django/static".
+    # Always use forward slashes, even on Windows.
+    # Don't forget to use absolute paths, not relative paths.
+)
+
+
+DATABASES = {
+    'default': {
+        'ENGINE': 'django.db.backends.postgresql_psycopg2', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
+        'NAME': 'hdabo',                      # Or path to database file if using sqlite3.
+        'USER': 'iri',                      # Not used with sqlite3.
+        'PASSWORD': 'iri',                  # Not used with sqlite3.
+        'HOST': 'localhost',                      # Set to empty string for localhost. Not used with sqlite3.
+        'PORT': '5432',                      # Set to empty string for default. Not used with sqlite3.
+    }
+}
+
+HAYSTACK_SEARCH_ENGINE = 'whoosh'
+HAYSTACK_WHOOSH_PATH = os.path.abspath(BASE_DIR + "../index/").rstrip("/")+"/"
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/context_processors.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,5 @@
+import hdabo
+
+def version(request):
+    return { 'VERSION': hdabo.get_version() }
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/django_wsgi.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,9 @@
+import os
+
+import django.core.handlers.wsgi
+
+application = django.core.handlers.wsgi.WSGIHandler()
+
+if os.environ.get('PYDEV_DEBUG', "False").lower() in ["true", "1", "t"]:
+    import pydevd #@UnresolvedImport
+    pydevd.settrace(suspend=False)

Binary file src/hdabo/fixtures/datasheet_10.yaml.bz2 has changed

Binary file src/hdabo/fixtures/datasheet_347.yaml.bz2 has changed

Binary file src/hdabo/fixtures/datasheet_all.yaml.bz2 has changed

Binary file src/hdabo/fixtures/initial_data.yaml.bz2 has changed

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/forms.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,14 @@
+# -*- coding: utf-8 -*-
+from django import forms
+from django.db.models.query import QuerySet
+
+
+class SortedMultipleChoiceField(forms.ModelMultipleChoiceField):
+    def clean(self, value):
+        queryset = super(SortedMultipleChoiceField, self).clean(value)
+        if value is None or not isinstance(queryset, QuerySet):
+            return queryset
+        object_list = dict((
+            (unicode(key), value)
+            for key, value in queryset.in_bulk(value).iteritems()))
+        return [object_list[unicode(pk)] for pk in value]

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/commands/clean_tags.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,56 @@
+# -*- coding: utf-8 -*-
+'''
+Created on Jun 20, 2012
+
+@author: ymh
+'''
+from django.core.management.base import NoArgsCommand
+from django.core.management.color import no_style
+from django.db import transaction,connection
+from django.db.models import Count
+from hdabo.models import Tag
+from hdabo.utils import show_progress
+from optparse import make_option
+import math
+import sys
+
+
+class Command(NoArgsCommand):
+    '''
+    remove orphan tags and merge duplicates (the key is the dbpedia uri) 
+    '''
+
+
+    def handle_noargs(self, **options):
+        '''
+        do the work
+        '''
+
+        # merge duplicate tags
+        cursor = connection.cursor()
+        cursor.execute("select label, dbpedia_uri from hdabo_tag group by label,dbpedia_uri having count(label) > 1")
+        
+        for label,_ in cursor:
+            qs = Tag.objects.filter(label=label).annotate(num_ds=Count('datasheet')).order_by('-num_ds')
+            ref_tag = None
+            for t in qs:
+                print("label : %d : %s, num_ds: %d"%(t.id,t.label, t.num_ds))
+                if ref_tag is None:
+                    ref_tag = t
+                else:
+                    for ts in t.taggedsheet_set.all():
+                        pass
+                        print("changing tag %d to %d" %(ts.tag.id, ref_tag.id) )
+                        ts.tag = ref_tag
+                        ts.save()
+        
+        # remove ophans tags
+        
+        orphans_tags = Tag.objects.annotate(num_ds=Count('datasheet')).filter(num_ds=0)
+        
+        print("nb Orphans : %d" % orphans_tags.count())
+                
+        #delete
+        orphans_tags.delete()
+
+        
\ No newline at end of file

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/commands/diff_csv.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,147 @@
+# -*- coding: utf-8 -*-
+'''
+Created on May 25, 2011
+
+@author: ymh
+'''
+#Auteur,Chemin,Comment,Controle,Datcre,Datmaj,Desc,Domaine,Format,ID,Insee,Org,Org_Home,OrgID,Periode1,Periode2,Periode3,Satut,Sousdom,Tag,Theme2,Theme3,Titre,Url,Vignette,Ville
+#"Auteur","Chemin","Comment","Controle","Datcre","Datmaj","Desc","Domaine","Format","ID","Insee","Org","Org_Home","OrgID","Periode1","Periode2","Periode3","Satut","Sousdom","Tag","Theme2","Theme3","Titre","Url","Vignette","Ville",
+
+from django.core.management.base import BaseCommand, CommandError
+from django.db import transaction
+from hdabo.models import Datasheet
+from optparse import make_option
+import csv
+import math
+import sys
+
+class Command(BaseCommand):
+    '''
+    Command to diff datasheets content from csv content 
+    '''
+    args = '<path_to_csv_file path_to_csv_file ...>'
+    options = '[--do-delete] [--encoding] [--delimiter] [--dialect]'
+    help = """Import of a csv file for hdabo
+Options:
+    --do-delete : ignore existing datasheets
+    --encoding : files encoding. default to latin-1
+    --delimiter : scv delimiter
+    --dialect : csv dialect
+    --fieldnames : csv columns
+    """
+    
+    option_list = BaseCommand.option_list + (
+        make_option('--encoding',
+            action='store',
+            type='string',
+            dest='encoding',
+            default="latin-1",
+            help='fix the file encoding. default to latin-1'),
+        make_option('--delimiter',
+            action='store',
+            type='string',
+            dest='delimiter',
+            default=";",
+            help='csv file delimiter'),
+        make_option('--dialect',
+            action='store',
+            type='string',
+            dest='dialect',
+            default="excel",
+            help='csv dialect'),
+        make_option('--fieldnames',
+            action='store',
+            type='string',
+            dest='fieldnames',
+            default=None,
+            help='fields list (comma separated)'),
+        make_option('--do-delete',
+            action='store_true',
+            dest='do_delete',
+            default=False,
+            help='delete datasheets'),
+        
+        )
+    
+    def show_progress(self, current_line, total_line, width):
+
+        percent = (float(current_line) / float(total_line)) * 100.0
+
+        marks = math.floor(width * (percent / 100.0))
+        spaces = math.floor(width - marks)
+    
+        loader = '[' + ('=' * int(marks)) + (' ' * int(spaces)) + ']'
+    
+        sys.stdout.write("%s %d%% %d/%d\r" % (loader, percent, current_line - 1, total_line - 1)) #takes the header into account
+        if percent >= 100:
+            sys.stdout.write("\n")
+        sys.stdout.flush()
+
+            
+
+    def handle(self, *args, **options):
+        
+        if len(args) == 0:
+            raise CommandError("Gives at lat one csv file to import")
+        
+        self.encoding = options.get('encoding', "latin-1")
+        self.do_delete = options.get('do_delete', False)
+        fieldnames = options.get('fieldnames', None)
+
+        for csv_path in args:
+            print "Processing %s " % (csv_path)
+            with open(csv_path, 'rU') as csv_file:
+                
+                # get the number of lines if necessary
+                for i, l in enumerate(csv_file): #@UnusedVariable
+                    pass                        
+                total_line = i + 1
+                if fieldnames:
+                    total_line = total_line + 1
+                csv_file.seek(0)
+                
+                delimiter = options.get('delimiter', ";")
+                if delimiter == "TAB" or delimiter == "\\t":
+                    delimiter = '\t'
+    
+                dr_kwargs = {'delimiter':delimiter}
+                if  fieldnames is not None:
+                    dr_kwargs['fieldnames'] = [f.strip() for f in fieldnames.split(",")]
+                dialect = options.get('dialect', "excel")
+                if dialect is not None:
+                    dr_kwargs['dialect'] = dialect
+                   
+                reader = csv.DictReader(csv_file, **dr_kwargs)
+                
+                ids = []
+    
+                for row in reader:
+                    line_num = reader.line_num if fieldnames is None else reader.line_num + 1
+                    self.show_progress(line_num, total_line, 60)
+                    def safe_decode(val, encoding):
+                        if val:
+                            return val.decode(encoding)
+                        else:
+                            return val
+                                                
+                    row = dict([(safe_decode(key, self.encoding), safe_decode(value, self.encoding)) for key, value in row.items()])
+                    
+                    ids.append(row['ID'])
+                
+                qs = Datasheet.objects.exclude(hda_id__in = ids).order_by("hda_id")
+                
+                qs_count = qs.count()
+                
+                if qs_count == 0:
+                    print("No datasheet to delete : exit")
+                    return
+                    
+                print("The following datasheets are in the database and not in the csv file")
+                for i,ds in enumerate(qs):
+                    print("%*d- %4s : %s" % (len(str(qs_count+1)), i+1, ds.hda_id, ds.title.strip() if ds.title is not None else ""))
+                    
+                
+                if self.do_delete:
+                    print("deleting datasheets")
+                    qs.delete()
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/commands/import_csv.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,267 @@
+# -*- coding: utf-8 -*-
+'''
+Created on May 25, 2011
+
+@author: ymh
+'''
+#Auteur,Chemin,Comment,Controle,Datcre,Datmaj,Desc,Domaine,Format,ID,Insee,Org,Org_Home,OrgID,Periode1,Periode2,Periode3,Satut,Sousdom,Tag,Theme2,Theme3,Titre,Url,Vignette,Ville
+#"Auteur","Chemin","Comment","Controle","Datcre","Datmaj","Desc","Domaine","Format","ID","Insee","Org","Org_Home","OrgID","Periode1","Periode2","Periode3","Satut","Sousdom","Tag","Theme2","Theme3","Titre","Url","Vignette","Ville",
+
+from django.core.management.base import BaseCommand, CommandError
+from django.db import transaction
+from hdabo.models import (Author, Datasheet, DocumentFormat, Domain, Organisation,
+    Tag, TaggedSheet, TimePeriod, Location)
+from hdabo.wp_utils import normalize_tag
+from optparse import make_option
+import csv
+import datetime
+import math
+import sys
+
+class Command(BaseCommand):
+    '''
+    Command to import csvfile
+    '''
+    args = '<path_to_csv_file path_to_csv_file ...>'
+    options = '[--ignore-existing] [--lines] [--encoding]'
+    help = """Import of a csv file for hdabo
+Options:
+    --ignore-existing : ignore existing datasheets
+    --lines : max number of lines to load (for each file). 0 means all.
+    --encoding : files encoding. default to latin-1"""
+    
+    option_list = BaseCommand.option_list + (
+        make_option('--encoding',
+            action='store',
+            type='string',
+            dest='encoding',
+            default="latin-1",
+            help='fix the file encoding. default to latin-1'),
+        make_option('--delimiter',
+            action='store',
+            type='string',
+            dest='delimiter',
+            default=";",
+            help='csv file delimiter'),
+        make_option('--dialect',
+            action='store',
+            type='string',
+            dest='dialect',
+            default="excel",
+            help='csv dialect'),
+        make_option('--fieldnames',
+            action='store',
+            type='string',
+            dest='fieldnames',
+            default=None,
+            help='fields list (comma separated)'),
+        make_option('--lines',
+            action='store',
+            type='int',
+            dest='lines',
+            default=0,
+            help='Number of lines to read. 0 means all.'),
+        make_option('--ignore-existing',
+            action='store_true',
+            dest='ignore_existing',
+            default=False,
+            help='force insertion'),
+        
+        )
+    
+    def show_progress(self, current_line, total_line, width):
+
+        percent = (float(current_line) / float(total_line)) * 100.0
+
+        marks = math.floor(width * (percent / 100.0))
+        spaces = math.floor(width - marks)
+    
+        loader = '[' + ('=' * int(marks)) + (' ' * int(spaces)) + ']'
+    
+        sys.stdout.write("%s %d%% %d/%d\r" % (loader, percent, current_line - 1, total_line - 1)) #takes the header into account
+        if percent >= 100:
+            sys.stdout.write("\n")
+        sys.stdout.flush()
+
+    
+    def create_domain_period(self, row_value, klass, school_period):
+        res_list = []
+        if not row_value:
+            return res_list
+        for label_str in [dstr.strip() for dstr in row_value.split('\x0b')]:
+            if label_str:
+                res_obj, created = klass.objects.get_or_create(label=label_str, school_period=school_period, defaults={"label":label_str, "school_period":school_period}) #@UnusedVariable
+                res_list.append(res_obj)
+        return res_list
+    
+    def create_datasheet(self, row):
+        
+        if self.ignore_existing and Datasheet.objects.filter(hda_id=row[u"ID"]).count() > 0:
+            return
+        
+        author_str = row[u'Auteur']
+        if author_str:
+            author_array = author_str.split(" ")
+            if len(author_array) == 0:
+                firstname = ""
+                lastname = ""
+            elif len(author_array) == 1:
+                firstname = ""
+                lastname = author_array[0]
+            elif len(author_array) == 2:
+                firstname = author_array[0]
+                lastname = author_array[1]
+                
+            author, created = Author.objects.get_or_create(hda_id=author_str, defaults={"firstname":firstname, "lastname":lastname}) #@UnusedVariable
+        else:
+            author = None
+        
+        org_str = row[u"Org"]    
+        if org_str:
+            url_str = row[u'Org_Home']
+            if url_str is not None:
+                url_str = url_str.strip()
+            org, created = Organisation.objects.get_or_create(hda_id=org_str, defaults={"name":org_str, "website" : url_str}) #@UnusedVariable
+        else:
+            org = None
+            
+        town_str = row[u"Ville"]
+        if town_str:
+            insee_str = row[u'Insee'].strip() if row[u'Insee'] else row[u'Insee']
+            if len(insee_str) > 5:
+                insee_str = "" 
+            loc, created = Location.objects.get_or_create(insee=insee_str, defaults={"name": town_str, "insee": insee_str}) #@UnusedVariable
+        else:
+            loc = None
+            
+        format_str = row[u"Format"]
+        if format_str:
+            format, created = DocumentFormat.objects.get_or_create(label=format_str, defaults={"label": format_str}) #@UnusedVariable
+        else:
+            format = None
+        
+        domains = self.create_domain_period(row[u"Domaine"], Domain, Domain.DOMAIN_PERIOD_DICT[u'Global'])
+                                        
+        primary_periods = self.create_domain_period(row[u"Periode1"], TimePeriod, TimePeriod.TIME_PERIOD_DICT[u'Primaire'])
+        college_periods = self.create_domain_period(row[u"Periode2"], TimePeriod, TimePeriod.TIME_PERIOD_DICT[u'Collège'])
+        highschool_periods = self.create_domain_period(row[u"Periode3"], TimePeriod, TimePeriod.TIME_PERIOD_DICT[u'Lycée'])
+                    
+        primary_themes = self.create_domain_period(row[u"Sousdom"], Domain, Domain.DOMAIN_PERIOD_DICT[u'Primaire'])
+        college_themes = self.create_domain_period(row[u"Theme2"], Domain, Domain.DOMAIN_PERIOD_DICT[u'Collège'])
+        highschool_themes = self.create_domain_period(row[u"Theme3"], Domain, Domain.DOMAIN_PERIOD_DICT[u'Lycée'])
+        
+        url = row[u"Url"]
+        if url is not None:
+            url = url.strip()
+        
+        datasheet = Datasheet.objects.create(
+            hda_id=row[u"ID"],
+            author=author,
+            organisation=org,
+            title=row[u"Titre"],
+            description=row[u"Desc"],
+            url=url,
+            town=loc,
+            format=format,
+            original_creation_date=datetime.datetime.strptime(row[u"Datcre"], "%d/%m/%Y").date(),
+            original_modification_date=datetime.datetime.strptime(row[u"Datmaj"], "%d/%m/%Y").date(),
+            validated=False                                          
+        )
+        
+        datasheet.save()
+        
+        datasheet.set_domains(domains)
+        datasheet.set_primary_periods(primary_periods)
+        datasheet.set_college_periods(college_periods)
+        datasheet.set_highschool_periods(highschool_periods)
+        datasheet.set_primary_themes(primary_themes)
+        datasheet.set_college_themes(college_themes)
+        datasheet.set_highschool_themes(highschool_themes)
+
+        
+        if row[u'Tag']:
+            for i, tag in enumerate([t.strip() for t in row[u'Tag'].split(u";")]):
+                if len(tag) == 0:
+                    continue
+                tag_label = normalize_tag(tag)
+                tag_obj = None
+                for t in Tag.objects.filter(label__iexact=tag_label):
+                    if tag_obj is None or t.url_status != Tag.TAG_URL_STATUS_DICT['null_result']:
+                        tag_obj = t
+                        if tag_obj.url_status != Tag.TAG_URL_STATUS_DICT['null_result']:
+                            break
+ 
+                if tag_obj is None:
+                    tag_obj = Tag(label=tag_label, original_label=tag)
+                    tag_obj.save()
+
+                tagged_ds = TaggedSheet(datasheet=datasheet, tag=tag_obj, original_order=i + 1, order=i + 1)
+                tagged_ds.save()
+        
+
+    def handle(self, *args, **options):
+        
+        if len(args) == 0:
+            raise CommandError("Gives at lat one csv file to import")
+        
+        self.encoding = options.get('encoding', "latin-1")
+        lines = options.get('lines', 0)
+        self.ignore_existing = options.get('ignore_existing', False)
+        fieldnames = options.get('fieldnames', None)
+
+        transaction.commit_unless_managed()
+        transaction.enter_transaction_management()
+        transaction.managed(True)
+
+        try:
+            for csv_path in args:
+                try:
+                    print "Processing %s " % (csv_path)
+                    with open(csv_path, 'rU') as csv_file:
+                        
+                        # get the number of lines if necessary
+                        if not lines:
+                            for i, l in enumerate(csv_file): #@UnusedVariable
+                                pass                        
+                            total_line = i + 1
+                            if fieldnames:
+                                total_line = total_line + 1
+                            csv_file.seek(0)
+                        else:
+                            total_line = lines + 1
+                        
+                        delimiter = options.get('delimiter', ";")
+                        if delimiter == "TAB" or delimiter == "\\t":
+                            delimiter = '\t'
+
+                        dr_kwargs = {'delimiter':delimiter}
+                        if  fieldnames is not None:
+                            dr_kwargs['fieldnames'] = [f.strip() for f in fieldnames.split(",")]
+                        dialect = options.get('dialect', "excel")
+                        if dialect is not None:
+                            dr_kwargs['dialect'] = dialect
+                           
+                        reader = csv.DictReader(csv_file, **dr_kwargs)
+        
+                        for j, row in enumerate(reader):
+                            if lines and j >= lines:
+                                break
+                            line_num = reader.line_num if fieldnames is None else reader.line_num + 1
+                            self.show_progress(line_num, total_line, 60)
+                            def safe_decode(val, encoding):
+                                if val:
+                                    return val.decode(encoding)
+                                else:
+                                    return val
+                                                        
+                            row = dict([(safe_decode(key, self.encoding), safe_decode(value, self.encoding)) for key, value in row.items()])
+                            self.create_datasheet(row)
+                            
+                            transaction.commit()
+                except Exception:
+                    transaction.rollback()
+                    raise 
+                finally:
+                    print('')
+        finally:
+            transaction.leave_transaction_management()

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/commands/import_tag_popularity.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,150 @@
+# -*- coding: utf-8 -*-
+'''
+Created on Jun 17, 2011
+
+@author: ymh
+
+command to import tag popularity
+
+'''
+
+from django.core.management.base import BaseCommand, CommandError
+from hdabo.models import Tag
+from hdabo.utils import normalize
+from optparse import make_option
+import csv
+import math
+import sys
+
+
+class Command(BaseCommand):
+    '''
+    Command to import csvfile
+    '''
+    args = '<path_to_csv_file path_to_csv_file ...>'
+    options = '[--ignore-existing] [--lines] [--encoding]'
+    help = """Import of a tag popularity file for hdabo
+Options:
+    --ignore-existing : ignore existing datasheets
+    --lines : max number of lines to load (for each file). 0 means all.
+    --encoding : files encoding. default to latin-1"""
+    
+    option_list = BaseCommand.option_list + (
+        make_option('--encoding',
+            action='store',
+            type='string',
+            dest='encoding',
+            default="latin-1",
+            help='fix the file encoding. default to latin-1'),
+        make_option('--delimiter',
+            action='store',
+            type='string',
+            dest='delimiter',
+            default=";",
+            help='csv file delimiter'),
+        make_option('--dialect',
+            action='store',
+            type='string',
+            dest='dialect',
+            default="excel",
+            help='csv dialect'),
+        make_option('--fieldnames',
+            action='store',
+            type='string',
+            dest='fieldnames',
+            default="label,popularity",
+            help='fields list (comma separated)'),
+        make_option('--lines',
+            action='store',
+            type='int',
+            dest='lines',
+            default=0,
+            help='Number of lines to read. 0 means all.'),
+        make_option('--preserve',
+            action='store_true',
+            dest='preserve',
+            default=False,
+            help='preserve'),
+                                             
+        
+        )
+    
+    def show_progress(self, current_line, total_line, width):
+
+        percent = (float(current_line) / float(total_line)) * 100.0
+
+        marks = math.floor(width * (percent / 100.0))
+        spaces = math.floor(width - marks)
+    
+        loader = '[' + ('=' * int(marks)) + (' ' * int(spaces)) + ']'
+    
+        sys.stdout.write("%s %d%% %d/%d\r" % (loader, percent, current_line - 1, total_line - 1)) #takes the header into account
+        if percent >= 100:
+            sys.stdout.write("\n")
+        sys.stdout.flush()
+
+    def handle(self, *args, **options):
+        
+        if len(args) == 0:
+            raise CommandError("Give one csv file to import")
+        elif len(args) > 1:
+            raise CommandError("Only one file can be imported")
+        
+        self.encoding = options.get('encoding', "latin-1")
+        lines = options.get('lines', 0)
+        fieldnames = options.get('fieldnames', "label,popularity")
+
+        csv_path = args[0]
+        
+        print("Processing %s " % (csv_path))
+        
+        with open(csv_path, 'rU') as csv_file:
+            # get the number of lines if necessary
+            if not lines:
+                for i, l in enumerate(csv_file): #@UnusedVariable
+                    pass                        
+                total_line = i + 1
+                if fieldnames:
+                    total_line = total_line + 1
+                csv_file.seek(0)
+            else:
+                total_line = lines + 1
+
+            delimiter = options.get('delimiter', ";")
+            if delimiter == "TAB" or delimiter == "\\t":
+                delimiter = '\t'
+            dr_kwargs = {'delimiter':delimiter}
+            if  fieldnames is not None:
+                dr_kwargs['fieldnames'] = [f.strip() for f in fieldnames.split(",")]
+            dialect = options.get('dialect', "excel")
+            if dialect is not None:
+                dr_kwargs['dialect'] = dialect
+               
+            if not options.get('preserve',False):
+                Tag.objects.update(popularity=0)
+                
+            reader = csv.DictReader(csv_file, **dr_kwargs)
+
+            for j, row in enumerate(reader):
+                if lines and j >= lines:
+                    break
+                line_num = reader.line_num if fieldnames is None else reader.line_num + 1
+                self.show_progress(line_num, total_line, 60)
+                def safe_decode(val, encoding):
+                    if val:
+                        return val.decode(encoding)
+                    else:
+                        return val
+                                            
+                row = dict([(safe_decode(key, self.encoding), safe_decode(value, self.encoding)) for key, value in row.items()])
+                
+                label = normalize(row['label'].strip())
+                popularity_str = row['popularity']
+                
+                if not label or not popularity_str:
+                    continue
+                
+                
+                for tag in Tag.objects.filter(normalized_label=label):
+                    tag.popularity = tag.popularity + int(row['popularity'])
+                    tag.save()

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/commands/order_tags.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,81 @@
+'''
+Created on Jun 7, 2011
+
+@author: ymh
+'''
+
+from django.core.management.base import NoArgsCommand
+from django.core.management.color import no_style
+from django.db import transaction
+from hdabo.models import Datasheet
+from hdabo.wp_utils import reorder_datasheet_tags
+from hdabo.utils import show_progress
+from optparse import make_option
+import math
+import sys
+
+
+class Command(NoArgsCommand):
+    '''
+    Command to calculate the order of tags based on indexation
+    recalculate all tags. Will ask for confirmation
+    '''
+
+    args = ''
+    options = '-f : force '
+    help = "calculate the order of tags based on indexation recalculate all tags. Will ask for confirmation"
+    
+    option_list = NoArgsCommand.option_list + (
+        make_option('-f', '--force',
+            action='store_true',
+            dest='force',
+            default=False,
+            help='force reordering of all datasheets'),
+        make_option('--noinput',
+            action='store_true',
+            dest='no_input',
+            default=False,
+            help='no input'),
+        )
+
+
+    def handle_noargs(self, **options):
+        
+        self.style = no_style()
+        
+        interactive = options.get('interactive', True) and not options.get('no_input', False)
+        force = options.get('force', True)
+        
+        if interactive:
+            confirm = raw_input("""You have requested to recalculate the index order of all the tags.
+This will process all the tags in %s datasheets. Are you sure you want to do this ?
+    Type 'yes' to continue, or 'no' to cancel: """ % ("all" if force else "not validated"))
+        else:
+            confirm = 'yes'
+            
+        if confirm != "yes":
+            print "Tag reordering cancelled"
+            return
+
+        if force:
+            queryset = Datasheet.objects.all()
+        else:
+            queryset = Datasheet.objects.filter(validated=False, manual_order=False)
+        total = queryset.count()
+        
+        transaction.commit_unless_managed()
+        transaction.enter_transaction_management()
+        transaction.managed(True)
+
+        try:
+            for i, ds in enumerate(queryset):
+                show_progress(i + 1, total, ds.title, 60)
+                reorder_datasheet_tags(ds)
+                transaction.commit()
+        except:
+            transaction.rollback()
+            raise
+        finally:
+            transaction.leave_transaction_management()
+            
+        

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/commands/query_wikipedia.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,146 @@
+# -*- coding: utf-8 -*-
+'''
+Created on Jun 7, 2011
+
+@author: ymh
+'''
+
+from django.conf import settings
+from django.core.management.base import NoArgsCommand
+from django.core.management.color import no_style
+from hdabo.models import Tag
+from hdabo.wp_utils import process_tag
+from optparse import make_option
+from wikitools import wiki
+import math
+import sys
+
+
+
+class Command(NoArgsCommand):
+    '''
+    query and update wikipedia for tag title.
+    '''
+    options = ''
+    help = """query and update wikipedia for tag title."""
+    
+    option_list = NoArgsCommand.option_list + (
+        make_option('--force',
+            action='store_true',
+            dest='force',
+            default=False,
+            help='force all tags to be updated, not only those not yet processed'),
+        make_option('--random',
+            action='store_true',
+            dest='random',
+            default=False,
+            help='randomize query on tags'),
+        make_option('--site',
+            action='store',
+            type='string',
+            dest='site_url',
+            default="http://fr.wikipedia.org/w/api.php",
+            help='the url for the wikipedia site'),
+        make_option('--limit',
+            action='store',
+            type='int',
+            dest='limit',
+            default= -1,
+            help='number of tag to process'),
+        make_option('--start',
+            action='store',
+            type='int',
+            dest='start',
+            default=0,
+            help='number of tag to ignore'),
+        )
+    
+    def __is_homonymie(self, page_dict):
+        for cat in page_dict.get(u"categories", []):
+            if u'Catégorie:Homonymie' in cat.get(u"title", u"") or u'Category:Disambiguation pages' in cat.get(u"title", u""):
+                return True
+        return False
+        
+    def show_progress(self, current_line, total_line, label, width):
+
+        percent = (float(current_line) / float(total_line)) * 100.0
+
+        marks = math.floor(width * (percent / 100.0))
+        spaces = math.floor(width - marks)
+    
+        loader = u'[' + (u'=' * int(marks)) + (u' ' * int(spaces)) + u']'
+        
+        sys.stdout.write(u"%s %d%% %d/%d - %r\r" % (loader, percent, current_line - 1, total_line - 1, label[:50].rjust(50))) #takes the header into account
+        if percent >= 100:
+            sys.stdout.write("\n")
+        sys.stdout.flush()
+        
+    def handle_noargs(self, **options):
+        
+        self.style = no_style()
+        
+        interactive = options.get('interactive', True)
+        
+        verbosity = int(options.get('verbosity', '1'))
+        
+        force = options.get('force', False)
+        
+        limit = options.get("limit", -1)
+        start = options.get("start", 0)
+        
+        site_url = options.get('site_url', settings.WIKIPEDIA_API_URL)
+        
+        random = options.get('random', False)
+        
+        if verbosity > 2:
+            print "option passed : " + repr(options)
+
+        if force and interactive:
+            confirm = raw_input("""You have requested to query and replace the wikipedia information for all datasheets.
+Are you sure you want to do this ?
+    Type 'yes' to continue, or 'no' to cancel: """)
+        else:
+            confirm = 'yes'
+            
+        if confirm != "yes":
+            print "wikipedia query cancelled"
+            return
+
+        if force:
+            queryset = Tag.objects.all()
+        else:
+            queryset = Tag.objects.filter(url_status=None)                    
+        
+        if random:
+            queryset = queryset.order_by("?")
+        else:
+            queryset = queryset.order_by("label")
+        
+        if limit >= 0:
+            queryset = queryset[start:limit]
+        else:
+            queryset = queryset[start:]
+            
+        
+        if verbosity > 2 :
+            print "Tag Query is %s" % (queryset.query)
+        
+        site = wiki.Wiki(site_url) #@UndefinedVariable
+        
+        
+        count = queryset.count()
+        if verbosity > 1:
+            print "Processing %d tags" % (count)
+        
+        
+        
+        for i, tag in enumerate(queryset):
+            
+            if verbosity > 1:
+                print "processing tag %s (%d/%d)" % (tag.label, i + 1, count)
+            else:
+                self.show_progress(i + 1, count, tag.label, 60)                            
+            
+            process_tag(site, tag, verbosity)
+            
+            

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/management/utils.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,39 @@
+# -*- coding: utf-8 -*-
+'''
+Created on Feb 2, 2012
+
+@author: ymh
+'''
+
+import cStringIO
+import csv
+import codecs
+
+class UnicodeWriter:
+    """
+    A CSV writer which will write rows to CSV file "f",
+    which is encoded in the given encoding.
+    """
+
+    def __init__(self, f, dialect=csv.excel, encoding="utf-8", **kwds):
+        # Redirect output to a queue
+        self.queue = cStringIO.StringIO()
+        self.writer = csv.writer(self.queue, dialect=dialect, **kwds)
+        self.stream = f
+        self.encoder = codecs.getincrementalencoder(encoding)()
+
+    def writerow(self, row):
+        self.writer.writerow([unicode(s).encode("utf-8") for s in row])
+        # Fetch UTF-8 output from the queue ...
+        data = self.queue.getvalue()
+        data = data.decode("utf-8")
+        # ... and reencode it into the target encoding
+        data = self.encoder.encode(data)
+        # write to the target stream
+        self.stream.write(data)
+        # empty queue
+        self.queue.truncate(0)
+
+    def writerows(self, rows):
+        for row in rows:
+            self.writerow(row)

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hdabo/migrations/0001_initial.py	Tue Jun 17 10:25:33 2014 +0200
@@ -0,0 +1,436 @@
+#@PydevCodeAnalysisIgnore
+# encoding: utf-8
+import datetime
+from south.db import db
+from south.v2 import SchemaMigration
+from django.db import models
+
+class Migration(SchemaMigration):
+
+    def forwards(self, orm):
+        
+        # Adding model 'Organisation'
+        db.create_table('hdabo_organisation', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('hda_id', self.gf('django.db.models.fields.CharField')(unique=True, max_length=512)),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=512)),
+            ('location', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),
+            ('website', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),
+        ))
+        db.send_create_signal('hdabo', ['Organisation'])
+
+        # Adding model 'Author'
+        db.create_table('hdabo_author', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('hda_id', self.gf('django.db.models.fields.CharField')(unique=True, max_length=512)),
+            ('lastname', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),
+            ('firstname', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),
+        ))
+        db.send_create_signal('hdabo', ['Author'])
+
+        # Adding model 'TimePeriod'
+        db.create_table('hdabo_timeperiod', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('label', self.gf('django.db.models.fields.CharField')(max_length=512)),
+            ('school_period', self.gf('django.db.models.fields.IntegerField')()),
+        ))
+        db.send_create_signal('hdabo', ['TimePeriod'])
+
+        # Adding unique constraint on 'TimePeriod', fields ['label', 'school_period']
+        db.create_unique('hdabo_timeperiod', ['label', 'school_period'])
+
+        # Adding model 'Domain'
+        db.create_table('hdabo_domain', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('label', self.gf('django.db.models.fields.CharField')(max_length=512)),
+            ('school_period', self.gf('django.db.models.fields.IntegerField')()),
+        ))
+        db.send_create_signal('hdabo', ['Domain'])
+
+        # Adding unique constraint on 'Domain', fields ['label', 'school_period']
+        db.create_unique('hdabo_domain', ['label', 'school_period'])
+
+        # Adding model 'DocumentFormat'
+        db.create_table('hdabo_documentformat', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('label', self.gf('django.db.models.fields.CharField')(unique=True, max_length=512)),
+        ))
+        db.send_create_signal('hdabo', ['DocumentFormat'])
+
+        # Adding model 'TagCategory'
+        db.create_table('hdabo_tagcategory', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('label', self.gf('django.db.models.fields.CharField')(unique=True, max_length=512)),
+        ))
+        db.send_create_signal('hdabo', ['TagCategory'])
+
+        # Adding model 'Tag'
+        db.create_table('hdabo_tag', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('label', self.gf('django.db.models.fields.CharField')(max_length=1024, db_index=True)),
+            ('normalized_label', self.gf('django.db.models.fields.CharField')(max_length=1024, db_index=True)),
+            ('original_label', self.gf('django.db.models.fields.CharField')(max_length=1024)),
+            ('alias', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),
+            ('category', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.TagCategory'], null=True, blank=True)),
+            ('wikipedia_url', self.gf('django.db.models.fields.URLField')(max_length=2048, null=True, blank=True)),
+            ('wikipedia_pageid', self.gf('django.db.models.fields.BigIntegerField')(null=True, blank=True)),
+            ('url_status', self.gf('django.db.models.fields.IntegerField')(default=None, null=True, blank=True)),
+            ('dbpedia_uri', self.gf('django.db.models.fields.URLField')(max_length=2048, null=True, blank=True)),
+            ('popularity', self.gf('django.db.models.fields.IntegerField')(default=0, db_index=True)),
+        ))
+        db.send_create_signal('hdabo', ['Tag'])
+
+        # Adding unique constraint on 'Tag', fields ['label', 'original_label', 'url_status']
+        db.create_unique('hdabo_tag', ['label', 'original_label', 'url_status'])
+
+        # Adding model 'Location'
+        db.create_table('hdabo_location', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=512)),
+            ('insee', self.gf('django.db.models.fields.CharField')(unique=True, max_length=5)),
+        ))
+        db.send_create_signal('hdabo', ['Location'])
+
+        # Adding model 'Datasheet'
+        db.create_table('hdabo_datasheet', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('hda_id', self.gf('django.db.models.fields.CharField')(unique=True, max_length=512)),
+            ('author', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Author'], null=True, blank=True)),
+            ('organisation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Organisation'])),
+            ('title', self.gf('django.db.models.fields.CharField')(max_length=2048)),
+            ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
+            ('url', self.gf('django.db.models.fields.URLField')(max_length=2048, null=True, blank=True)),
+            ('town', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Location'], null=True, blank=True)),
+            ('format', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.DocumentFormat'], null=True, blank=True)),
+            ('original_creation_date', self.gf('django.db.models.fields.DateField')()),
+            ('original_modification_date', self.gf('django.db.models.fields.DateField')()),
+            ('modification_datetime', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('validation_date', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
+            ('validated', self.gf('django.db.models.fields.BooleanField')(default=False, db_index=True)),
+            ('validator', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True, blank=True)),
+            ('manual_order', self.gf('django.db.models.fields.BooleanField')(default=False, db_index=True)),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet'])
+
+        # Adding model 'TaggedSheet'
+        db.create_table('hdabo_taggedsheet', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('tag', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Tag'])),
+            ('original_order', self.gf('django.db.models.fields.IntegerField')(default=0)),
+            ('order', self.gf('django.db.models.fields.IntegerField')(default=0, db_index=True)),
+            ('index_note', self.gf('django.db.models.fields.FloatField')(default=0.0, db_index=True)),
+            ('wikipedia_revision_id', self.gf('django.db.models.fields.BigIntegerField')(null=True, blank=True)),
+        ))
+        db.send_create_signal('hdabo', ['TaggedSheet'])
+
+        # Adding model 'Datasheet_domains'
+        db.create_table('hdabo_datasheet_domains', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('domain', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Domain'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_domains'])
+
+        # Adding model 'Datasheet_highschool_periods'
+        db.create_table('hdabo_datasheet_highschool_periods', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('timeperiod', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.TimePeriod'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_highschool_periods'])
+
+        # Adding model 'Datasheet_highschool_themes'
+        db.create_table('hdabo_datasheet_highschool_themes', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('domain', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Domain'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_highschool_themes'])
+
+        # Adding model 'Datasheet_college_periods'
+        db.create_table('hdabo_datasheet_college_periods', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('timeperiod', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.TimePeriod'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_college_periods'])
+
+        # Adding model 'Datasheet_college_themes'
+        db.create_table('hdabo_datasheet_college_themes', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('domain', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Domain'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_college_themes'])
+
+        # Adding model 'Datasheet_primary_periods'
+        db.create_table('hdabo_datasheet_primary_periods', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('timeperiod', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.TimePeriod'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_primary_periods'])
+
+        # Adding model 'Datasheet_primary_themes'
+        db.create_table('hdabo_datasheet_primary_themes', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('datasheet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Datasheet'])),
+            ('sort_value', self.gf('django.db.models.fields.IntegerField')()),
+            ('domain', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdabo.Domain'])),
+        ))
+        db.send_create_signal('hdabo', ['Datasheet_primary_themes'])
+
+
+    def backwards(self, orm):
+        
+        # Removing unique constraint on 'Tag', fields ['label', 'original_label', 'url_status']
+        db.delete_unique('hdabo_tag', ['label', 'original_label', 'url_status'])
+
+        # Removing unique constraint on 'Domain', fields ['label', 'school_period']
+        db.delete_unique('hdabo_domain', ['label', 'school_period'])
+
+        # Removing unique constraint on 'TimePeriod', fields ['label', 'school_period']
+        db.delete_unique('hdabo_timeperiod', ['label', 'school_period'])
+
+        # Deleting model 'Organisation'
+        db.delete_table('hdabo_organisation')
+
+        # Deleting model 'Author'
+        db.delete_table('hdabo_author')
+
+        # Deleting model 'TimePeriod'
+        db.delete_table('hdabo_timeperiod')
+
+        # Deleting model 'Domain'
+        db.delete_table('hdabo_domain')
+
+        # Deleting model 'DocumentFormat'
+        db.delete_table('hdabo_documentformat')
+
+        # Deleting model 'TagCategory'
+        db.delete_table('hdabo_tagcategory')
+
+        # Deleting model 'Tag'
+        db.delete_table('hdabo_tag')
+
+        # Deleting model 'Location'
+        db.delete_table('hdabo_location')
+
+        # Deleting model 'Datasheet'
+        db.delete_table('hdabo_datasheet')
+
+        # Deleting model 'TaggedSheet'
+        db.delete_table('hdabo_taggedsheet')
+
+        # Deleting model 'Datasheet_domains'
+        db.delete_table('hdabo_datasheet_domains')
+
+        # Deleting model 'Datasheet_highschool_periods'
+        db.delete_table('hdabo_datasheet_highschool_periods')
+
+        # Deleting model 'Datasheet_highschool_themes'
+        db.delete_table('hdabo_datasheet_highschool_themes')
+
+        # Deleting model 'Datasheet_college_periods'
+        db.delete_table('hdabo_datasheet_college_periods')
+
+        # Deleting model 'Datasheet_college_themes'
+        db.delete_table('hdabo_datasheet_college_themes')
+
+        # Deleting model 'Datasheet_primary_periods'
+        db.delete_table('hdabo_datasheet_primary_periods')
+
+        # Deleting model 'Datasheet_primary_themes'
+        db.delete_table('hdabo_datasheet_primary_themes')
+
+
+    models = {
+        'auth.group': {
+            'Meta': {'object_name': 'Group'},
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
+            'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
+        },
+        'auth.permission': {
+            'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
+            'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
+        },
+        'auth.user': {
+            'Meta': {'object_name': 'User'},
+            'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
+            'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
+            'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
+            'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
+            'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
+            'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
+            'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
+            'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
+            'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
+            'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
+        },
+        'contenttypes.contenttype': {
+            'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
+            'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
+        },
+        'hdabo.author': {
+            'Meta': {'object_name': 'Author'},
+            'firstname': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),
+            'hda_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'lastname': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'})
+        },
+        'hdabo.datasheet': {
+            'Meta': {'object_name': 'Datasheet'},
+            'author': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Author']", 'null': 'True', 'blank': 'True'}),
+            'college_periods': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'college_periods_datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_college_periods']", 'to': "orm['hdabo.TimePeriod']"}),
+            'college_themes': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'college_themes_datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_college_themes']", 'to': "orm['hdabo.Domain']"}),
+            'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
+            'domains': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_domains']", 'to': "orm['hdabo.Domain']"}),
+            'format': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.DocumentFormat']", 'null': 'True', 'blank': 'True'}),
+            'hda_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'}),
+            'highschool_periods': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'highschool_periods_datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_highschool_periods']", 'to': "orm['hdabo.TimePeriod']"}),
+            'highschool_themes': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'highschool_themes_datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_highschool_themes']", 'to': "orm['hdabo.Domain']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'manual_order': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
+            'modification_datetime': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'organisation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Organisation']"}),
+            'original_creation_date': ('django.db.models.fields.DateField', [], {}),
+            'original_modification_date': ('django.db.models.fields.DateField', [], {}),
+            'primary_periods': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'primary_periods_datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_primary_periods']", 'to': "orm['hdabo.TimePeriod']"}),
+            'primary_themes': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'primary_themes_datasheets'", 'symmetrical': 'False', 'through': "orm['hdabo.Datasheet_primary_themes']", 'to': "orm['hdabo.Domain']"}),
+            'tags': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['hdabo.Tag']", 'through': "orm['hdabo.TaggedSheet']", 'symmetrical': 'False'}),
+            'title': ('django.db.models.fields.CharField', [], {'max_length': '2048'}),
+            'town': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Location']", 'null': 'True', 'blank': 'True'}),
+            'url': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),
+            'validated': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
+            'validation_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
+            'validator': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True', 'blank': 'True'})
+        },
+        'hdabo.datasheet_college_periods': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_college_periods'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {}),
+            'timeperiod': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.TimePeriod']"})
+        },
+        'hdabo.datasheet_college_themes': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_college_themes'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'domain': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Domain']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {})
+        },
+        'hdabo.datasheet_domains': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_domains'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'domain': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Domain']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {})
+        },
+        'hdabo.datasheet_highschool_periods': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_highschool_periods'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {}),
+            'timeperiod': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.TimePeriod']"})
+        },
+        'hdabo.datasheet_highschool_themes': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_highschool_themes'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'domain': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Domain']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {})
+        },
+        'hdabo.datasheet_primary_periods': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_primary_periods'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {}),
+            'timeperiod': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.TimePeriod']"})
+        },
+        'hdabo.datasheet_primary_themes': {
+            'Meta': {'ordering': "['sort_value']", 'object_name': 'Datasheet_primary_themes'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'domain': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Domain']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sort_value': ('django.db.models.fields.IntegerField', [], {})
+        },
+        'hdabo.documentformat': {
+            'Meta': {'object_name': 'DocumentFormat'},
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'})
+        },
+        'hdabo.domain': {
+            'Meta': {'unique_together': "(('label', 'school_period'),)", 'object_name': 'Domain'},
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'label': ('django.db.models.fields.CharField', [], {'max_length': '512'}),
+            'school_period': ('django.db.models.fields.IntegerField', [], {})
+        },
+        'hdabo.location': {
+            'Meta': {'object_name': 'Location'},
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'insee': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '5'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '512'})
+        },
+        'hdabo.organisation': {
+            'Meta': {'object_name': 'Organisation'},
+            'hda_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'location': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '512'}),
+            'website': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'})
+        },
+        'hdabo.tag': {
+            'Meta': {'unique_together': "(('label', 'original_label', 'url_status'),)", 'object_name': 'Tag'},
+            'alias': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),
+            'category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.TagCategory']", 'null': 'True', 'blank': 'True'}),
+            'dbpedia_uri': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),
+            'normalized_label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),
+            'original_label': ('django.db.models.fields.CharField', [], {'max_length': '1024'}),
+            'popularity': ('django.db.models.fields.IntegerField', [], {'default': '0', 'db_index': 'True'}),
+            'url_status': ('django.db.models.fields.IntegerField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
+            'wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'}),
+            'wikipedia_url': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'})
+        },
+        'hdabo.tagcategory': {
+            'Meta': {'object_name': 'TagCategory'},
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'})
+        },
+        'hdabo.taggedsheet': {
+            'Meta': {'object_name': 'TaggedSheet'},
+            'datasheet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Datasheet']"}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'index_note': ('django.db.models.fields.FloatField', [], {'default': '0.0', 'db_index': 'True'}),
+            'order': ('django.db.models.fields.IntegerField', [], {'default': '0', 'db_index': 'True'}),
+            'original_order': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
+            'tag': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.Tag']"}),
+            'wikipedia_revision_id': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'})
+        },
+        'hdabo.timeperiod': {
+            'Meta': {'unique_together': "(('label', 'school_period'),)", 'object_name': 'TimePeriod'},
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'label': ('django.db.models.fields.CharField', [], {'max_length': '512'}),
+            'school_period': ('django.db.models.fields.IntegerField', [], {})
+        }
+    }
+
+    complete_apps = ['hdabo']