from datetime import datetime

def init_models(db):
    class TeamCategory(db.Model):
        __tablename__ = 'team_categories'
        
        id = db.Column(db.Integer, primary_key=True)
        name = db.Column(db.String(50), unique=True, nullable=False)
        slug = db.Column(db.String(50), unique=True, nullable=False)
        url = db.Column(db.String(255), nullable=False)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        
        teams = db.relationship('Team', backref='category', lazy=True)

    class Team(db.Model):
        __tablename__ = 'teams'
        
        id = db.Column(db.Integer, primary_key=True)
        team_id = db.Column(db.String(50), nullable=True)
        name = db.Column(db.String(100), nullable=False)
        slug = db.Column(db.String(150), unique=True, nullable=True, index=True)
        short_name = db.Column(db.String(20), nullable=True)
        flag_url = db.Column(db.String(500), nullable=True)
        team_url = db.Column(db.String(500), nullable=True)
        category_id = db.Column(db.Integer, db.ForeignKey('team_categories.id'), nullable=False)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
        
        players = db.relationship('Player', backref='team', lazy=True, cascade='all, delete-orphan')

    class Player(db.Model):
        __tablename__ = 'players'
        
        id = db.Column(db.Integer, primary_key=True)
        player_id = db.Column(db.String(50), nullable=True)
        name = db.Column(db.String(100), nullable=False)
        slug = db.Column(db.String(150), unique=True, nullable=True, index=True)
        role = db.Column(db.String(50), nullable=True)
        photo_url = db.Column(db.String(500), nullable=True)
        player_url = db.Column(db.String(500), nullable=True)
        team_id = db.Column(db.Integer, db.ForeignKey('teams.id'), nullable=False)
        
        born = db.Column(db.String(100), nullable=True)
        birth_place = db.Column(db.String(200), nullable=True)
        nickname = db.Column(db.String(100), nullable=True)
        batting_style = db.Column(db.String(100), nullable=True)
        bowling_style = db.Column(db.String(100), nullable=True)
        
        bat_matches = db.Column(db.String(50), nullable=True)
        bat_innings = db.Column(db.String(50), nullable=True)
        bat_runs = db.Column(db.String(50), nullable=True)
        bat_balls = db.Column(db.String(50), nullable=True)
        bat_highest = db.Column(db.String(50), nullable=True)
        bat_average = db.Column(db.String(50), nullable=True)
        bat_strike_rate = db.Column(db.String(50), nullable=True)
        bat_not_outs = db.Column(db.String(50), nullable=True)
        bat_fours = db.Column(db.String(50), nullable=True)
        bat_sixes = db.Column(db.String(50), nullable=True)
        bat_ducks = db.Column(db.String(50), nullable=True)
        bat_fifties = db.Column(db.String(50), nullable=True)
        bat_hundreds = db.Column(db.String(50), nullable=True)
        bat_two_hundreds = db.Column(db.String(50), nullable=True)
        
        bowl_matches = db.Column(db.String(50), nullable=True)
        bowl_innings = db.Column(db.String(50), nullable=True)
        bowl_balls = db.Column(db.String(50), nullable=True)
        bowl_runs = db.Column(db.String(50), nullable=True)
        bowl_maidens = db.Column(db.String(50), nullable=True)
        bowl_wickets = db.Column(db.String(50), nullable=True)
        bowl_average = db.Column(db.String(50), nullable=True)
        bowl_economy = db.Column(db.String(50), nullable=True)
        bowl_strike_rate = db.Column(db.String(50), nullable=True)
        bowl_best_innings = db.Column(db.String(50), nullable=True)
        bowl_best_match = db.Column(db.String(50), nullable=True)
        bowl_four_wickets = db.Column(db.String(50), nullable=True)
        bowl_five_wickets = db.Column(db.String(50), nullable=True)
        bowl_ten_wickets = db.Column(db.String(50), nullable=True)
        
        batting_stats = db.Column(db.JSON, nullable=True)
        bowling_stats = db.Column(db.JSON, nullable=True)
        career_timeline = db.Column(db.JSON, nullable=True)
        
        profile_scraped = db.Column(db.Boolean, default=False)
        profile_scraped_at = db.Column(db.DateTime, nullable=True)
        
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)

    class ScrapeLog(db.Model):
        __tablename__ = 'scrape_logs'
        
        id = db.Column(db.Integer, primary_key=True)
        category = db.Column(db.String(50), nullable=True)
        status = db.Column(db.String(20), nullable=False)
        message = db.Column(db.Text, nullable=True)
        teams_scraped = db.Column(db.Integer, default=0)
        players_scraped = db.Column(db.Integer, default=0)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)

    class ScrapeSetting(db.Model):
        __tablename__ = 'scrape_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        auto_scrape_enabled = db.Column(db.Boolean, default=False)
        scrape_time = db.Column(db.String(10), default='02:00')
        last_scrape = db.Column(db.DateTime, nullable=True)
        player_auto_scrape_enabled = db.Column(db.Boolean, default=False)
        player_scrape_time = db.Column(db.String(10), default='03:00')
        last_player_scrape = db.Column(db.DateTime, nullable=True)
        intl_auto = db.Column(db.Boolean, default=False)
        intl_time = db.Column(db.String(10), default='04:00')
        domestic_auto = db.Column(db.Boolean, default=False)
        domestic_time = db.Column(db.String(10), default='05:00')
        league_auto = db.Column(db.Boolean, default=False)
        league_time = db.Column(db.String(10), default='06:00')
        women_auto = db.Column(db.Boolean, default=False)
        women_time = db.Column(db.String(10), default='07:00')
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class ProfileScrapeSetting(db.Model):
        __tablename__ = 'profile_scrape_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        category_slug = db.Column(db.String(50), unique=True, nullable=False)
        auto_scrape_enabled = db.Column(db.Boolean, default=False)
        scrape_time = db.Column(db.String(10), default='03:00')
        last_scrape = db.Column(db.DateTime, nullable=True)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class SeriesCategory(db.Model):
        __tablename__ = 'series_categories'
        
        id = db.Column(db.Integer, primary_key=True)
        name = db.Column(db.String(50), unique=True, nullable=False)
        slug = db.Column(db.String(50), unique=True, nullable=False)
        url = db.Column(db.String(255), nullable=False)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        
        series = db.relationship('Series', backref='category', lazy=True, cascade='all, delete-orphan')
    
    class Series(db.Model):
        __tablename__ = 'series'
        
        id = db.Column(db.Integer, primary_key=True)
        series_id = db.Column(db.String(50), unique=True, nullable=True, index=True)
        name = db.Column(db.String(200), nullable=False)
        slug = db.Column(db.String(250), unique=True, nullable=True, index=True)
        series_url = db.Column(db.String(500), nullable=True)
        start_date = db.Column(db.String(100), nullable=True)
        end_date = db.Column(db.String(100), nullable=True)
        date_range = db.Column(db.String(100), nullable=True)
        category_id = db.Column(db.Integer, db.ForeignKey('series_categories.id'), nullable=False)
        matches = db.relationship('Match', backref='series', lazy=True)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class SeriesScrapeSetting(db.Model):
        __tablename__ = 'series_scrape_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        category_slug = db.Column(db.String(50), unique=True, nullable=False)
        auto_scrape_enabled = db.Column(db.Boolean, default=False)
        scrape_time = db.Column(db.String(10), default='08:00')
        last_scrape = db.Column(db.DateTime, nullable=True)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class Match(db.Model):
        __tablename__ = 'matches'
        
        id = db.Column(db.Integer, primary_key=True)
        match_id = db.Column(db.String(50), unique=True, nullable=False, index=True)
        slug = db.Column(db.String(300), unique=True, nullable=True, index=True)
        cricbuzz_series_id = db.Column(db.String(50), nullable=True, index=True)
        team1_id = db.Column(db.String(50), nullable=True)
        team2_id = db.Column(db.String(50), nullable=True)
        venue_id = db.Column(db.String(50), nullable=True)
        match_format = db.Column(db.String(100), nullable=True)
        format_type = db.Column(db.String(50), nullable=True)
        venue = db.Column(db.String(200), nullable=True)
        match_date = db.Column(db.String(100), nullable=True)
        match_time = db.Column(db.String(100), nullable=True)
        start_date = db.Column(db.String(50), nullable=True)
        end_date = db.Column(db.String(50), nullable=True)
        state = db.Column(db.String(50), nullable=True)
        team1_name = db.Column(db.String(100), nullable=True)
        team1_score = db.Column(db.String(100), nullable=True)
        team1_flag = db.Column(db.String(500), nullable=True)
        team2_name = db.Column(db.String(100), nullable=True)
        team2_score = db.Column(db.String(100), nullable=True)
        team2_flag = db.Column(db.String(500), nullable=True)
        result = db.Column(db.String(300), nullable=True)
        match_url = db.Column(db.String(500), nullable=True)
        series_name = db.Column(db.String(300), nullable=True)
        series_id = db.Column(db.Integer, db.ForeignKey('series.id'), nullable=True)
        batting_data = db.Column(db.JSON, nullable=True)
        bowling_data = db.Column(db.JSON, nullable=True)
        innings_data = db.Column(db.JSON, nullable=True)
        toss = db.Column(db.String(300), nullable=True)
        live_status = db.Column(db.String(300), nullable=True)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class MatchScrapeSetting(db.Model):
        __tablename__ = 'match_scrape_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        category_slug = db.Column(db.String(50), nullable=True)
        auto_scrape_enabled = db.Column(db.Boolean, default=False)
        scrape_time = db.Column(db.String(10), default='10:00')
        interval_hours = db.Column(db.Integer, default=4)
        last_scrape = db.Column(db.DateTime, nullable=True)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class LiveScoreScrapeSetting(db.Model):
        __tablename__ = 'live_score_scrape_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        auto_scrape_enabled = db.Column(db.Boolean, default=False)
        interval_seconds = db.Column(db.Integer, default=60)
        last_scrape = db.Column(db.DateTime, nullable=True)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class PostCategory(db.Model):
        __tablename__ = 'post_categories'
        
        id = db.Column(db.Integer, primary_key=True)
        name = db.Column(db.String(100), unique=True, nullable=False)
        slug = db.Column(db.String(100), unique=True, nullable=False)
        description = db.Column(db.Text, nullable=True)
        custom_url = db.Column(db.String(500), nullable=True)  # External/custom URL
        show_in_navbar = db.Column(db.Boolean, default=True)
        navbar_order = db.Column(db.Integer, default=0)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
        
        posts = db.relationship('Post', backref='category', lazy=True)
    
    class Post(db.Model):
        __tablename__ = 'posts'
        
        id = db.Column(db.Integer, primary_key=True)
        title = db.Column(db.String(300), nullable=False)
        slug = db.Column(db.String(300), unique=True, nullable=False)
        content = db.Column(db.Text, nullable=True)
        excerpt = db.Column(db.Text, nullable=True)
        thumbnail = db.Column(db.String(500), nullable=True)
        
        meta_title = db.Column(db.String(200), nullable=True)
        meta_description = db.Column(db.Text, nullable=True)
        meta_keywords = db.Column(db.Text, nullable=True)
        canonical_url = db.Column(db.String(500), nullable=True)
        og_title = db.Column(db.String(200), nullable=True)
        og_description = db.Column(db.Text, nullable=True)
        og_image = db.Column(db.String(500), nullable=True)
        schema_markup = db.Column(db.Text, nullable=True)
        
        is_published = db.Column(db.Boolean, default=False)
        is_featured = db.Column(db.Boolean, default=False)
        views = db.Column(db.Integer, default=0)
        
        category_id = db.Column(db.Integer, db.ForeignKey('post_categories.id'), nullable=True)
        match_id = db.Column(db.String(50), nullable=True)
        author = db.Column(db.String(100), default='Admin')
        
        published_at = db.Column(db.DateTime, nullable=True)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class AdminUser(db.Model):
        __tablename__ = 'admin_users'
        
        id = db.Column(db.Integer, primary_key=True)
        username = db.Column(db.String(50), unique=True, nullable=False)
        password_hash = db.Column(db.String(256), nullable=False)
        name = db.Column(db.String(100), default='Admin')
        email = db.Column(db.String(100), nullable=True)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        last_login = db.Column(db.DateTime, nullable=True)
    
    class Page(db.Model):
        __tablename__ = 'pages'
        
        id = db.Column(db.Integer, primary_key=True)
        title = db.Column(db.String(200), nullable=False)
        slug = db.Column(db.String(200), unique=True, nullable=False)
        content = db.Column(db.Text, nullable=True)
        meta_title = db.Column(db.String(200), nullable=True)
        meta_description = db.Column(db.Text, nullable=True)
        meta_keywords = db.Column(db.String(500), nullable=True)
        is_published = db.Column(db.Boolean, default=True)
        show_in_footer = db.Column(db.Boolean, default=True)
        footer_order = db.Column(db.Integer, default=0)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class Redirect(db.Model):
        __tablename__ = 'redirects'
        
        id = db.Column(db.Integer, primary_key=True)
        old_url = db.Column(db.String(500), unique=True, nullable=False, index=True)
        new_url = db.Column(db.String(500), nullable=False)
        redirect_type = db.Column(db.Integer, default=301)  # 301 permanent, 302 temporary
        is_active = db.Column(db.Boolean, default=True)
        hit_count = db.Column(db.Integer, default=0)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class SiteSettings(db.Model):
        __tablename__ = 'site_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        
        # Basic Site Info
        site_name = db.Column(db.String(200), default='Cricbuzz Live Score')
        site_tagline = db.Column(db.String(300), nullable=True)
        logo_url = db.Column(db.String(500), nullable=True)
        favicon_url = db.Column(db.String(500), nullable=True)
        
        # Theme Colors
        primary_color = db.Column(db.String(20), default='#1a472a')
        secondary_color = db.Column(db.String(20), default='#2d5a3d')
        accent_color = db.Column(db.String(20), default='#4CAF50')
        header_bg_color = db.Column(db.String(20), default='#1a472a')
        header_text_color = db.Column(db.String(20), default='#ffffff')
        footer_bg_color = db.Column(db.String(20), default='#1a472a')
        footer_text_color = db.Column(db.String(20), default='#ffffff')
        body_bg_color = db.Column(db.String(20), default='#f5f5f5')
        card_bg_color = db.Column(db.String(20), default='#ffffff')
        text_color = db.Column(db.String(20), default='#333333')
        link_color = db.Column(db.String(20), default='#1a472a')
        
        # Google Analytics
        ga_tracking_id = db.Column(db.String(50), nullable=True)  # GA4: G-XXXXXXXXXX
        ga_enabled = db.Column(db.Boolean, default=False)
        
        # Google AdSense
        adsense_publisher_id = db.Column(db.String(50), nullable=True)  # ca-pub-XXXXXXXX
        adsense_enabled = db.Column(db.Boolean, default=False)
        adsense_auto_ads = db.Column(db.Boolean, default=False)
        adsense_verification_code = db.Column(db.Text, nullable=True)  # Full <script> for approval
        
        # Ad Slots - Header
        ad_header_enabled = db.Column(db.Boolean, default=False)
        ad_header_code = db.Column(db.Text, nullable=True)
        
        # Ad Slots - Sidebar
        ad_sidebar_enabled = db.Column(db.Boolean, default=False)
        ad_sidebar_code = db.Column(db.Text, nullable=True)
        
        # Ad Slots - In-Content (after paragraphs)
        ad_content_enabled = db.Column(db.Boolean, default=False)
        ad_content_code = db.Column(db.Text, nullable=True)
        
        # Ad Slots - Footer
        ad_footer_enabled = db.Column(db.Boolean, default=False)
        ad_footer_code = db.Column(db.Text, nullable=True)
        
        # Ad Slots - Between Posts
        ad_between_posts_enabled = db.Column(db.Boolean, default=False)
        ad_between_posts_code = db.Column(db.Text, nullable=True)
        
        # Ads.txt content stored in DB (no file permission issues)
        ads_txt_content = db.Column(db.Text, nullable=True, default='')
        
        # Ad Slots - Match Page
        ad_match_page_enabled = db.Column(db.Boolean, default=False)
        ad_match_page_code = db.Column(db.Text, nullable=True)
        
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class PushSubscription(db.Model):
        __tablename__ = 'push_subscriptions'
        
        id = db.Column(db.Integer, primary_key=True)
        endpoint = db.Column(db.Text, unique=True, nullable=False)
        p256dh_key = db.Column(db.Text, nullable=False)
        auth_key = db.Column(db.Text, nullable=False)
        user_agent = db.Column(db.String(500), nullable=True)
        ip_address = db.Column(db.String(50), nullable=True)
        is_active = db.Column(db.Boolean, default=True)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
        last_used = db.Column(db.DateTime, default=datetime.utcnow)
    
    class NotificationLog(db.Model):
        __tablename__ = 'notification_logs'
        
        id = db.Column(db.Integer, primary_key=True)
        title = db.Column(db.String(200), nullable=False)
        body = db.Column(db.Text, nullable=False)
        icon_url = db.Column(db.String(500), nullable=True)
        click_url = db.Column(db.String(500), nullable=True)
        sent_count = db.Column(db.Integer, default=0)
        failed_count = db.Column(db.Integer, default=0)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
    
    class AutoPostSetting(db.Model):
        __tablename__ = 'auto_post_settings'
        
        id = db.Column(db.Integer, primary_key=True)
        is_enabled = db.Column(db.Boolean, default=False)
        schedule_hour = db.Column(db.Integer, default=1)  # Hour in 24h format (IST)
        schedule_minute = db.Column(db.Integer, default=0)
        days_ahead = db.Column(db.Integer, default=1)  # Create posts for matches X days ahead
        auto_publish = db.Column(db.Boolean, default=True)
        category_id = db.Column(db.Integer, db.ForeignKey('post_categories.id'), nullable=True)
        last_run = db.Column(db.DateTime, nullable=True)
        last_run_status = db.Column(db.String(50), nullable=True)
        posts_created_last_run = db.Column(db.Integer, default=0)
        updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    class AutoPostLog(db.Model):
        __tablename__ = 'auto_post_logs'
        
        id = db.Column(db.Integer, primary_key=True)
        match_id = db.Column(db.String(50), nullable=True)
        post_id = db.Column(db.Integer, db.ForeignKey('posts.id'), nullable=True)
        match_title = db.Column(db.String(300), nullable=True)
        status = db.Column(db.String(50), default='success')
        message = db.Column(db.Text, nullable=True)
        created_at = db.Column(db.DateTime, default=datetime.utcnow)
    
    return TeamCategory, Team, Player, ScrapeLog, ScrapeSetting, ProfileScrapeSetting, SeriesCategory, Series, SeriesScrapeSetting, Match, MatchScrapeSetting, LiveScoreScrapeSetting, PostCategory, Post, AdminUser, Page, Redirect, SiteSettings, PushSubscription, NotificationLog, AutoPostSetting, AutoPostLog